Error on Installing at Mysql 5.1

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

What operating system were you running when the bug appeared?
What database platform is your site using?
What version of mojoPortal are you running?
What version of .NET do you use?
What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.

5/18/2009 11:46:28 AM

Serjaomendes

Total Posts 3

View Posts

Error on Installing at Mysql 5.1

Probing system...
File system permissions ok.
MySQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
This site appears to be running in a secured environment using Medium Trust policy or at least lower than Full Trust.
In order to use MySQL under Medium Trust, The MySQL Connector for .NET must be installed in the Global Assembly Cache on the server. If you see a SecurityException in the error message then the Connector is not installed. You can download the MySql Connector for .NET from here: http://dev.mysql.com/downloads/connector/net/5.0.html

In order for the Search Engine to work in Medium trust, you need to add this in Web.config in the AppSettings section:

Running script mojoportal-core - 2.2.7.8 - 00:00:00.0468012
MySql.Data.MySqlClient.MySqlException: Can't create table 'serjaomende.mp_Sites' (errno: 150) at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:00.0936024
Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

--------------------------

I'm using Mysql 5.1, and not is possible back to old version.

5/18/2009 12:09:04 PM

Joe Audette

Total Posts 18439

View Posts

Re: Error on Installing at Mysql 5.1

My position on this is and has been that MySql released 5.1 too soon with a lot of bugs. Many people have reported this problem since 5.1 was in RC status. The only hope I can offer is maybe if you upgrade to a newer MySql connector it "might" solve it. I will be making a new release later today or tomorrow and it will use MySql Connector 6.0.3 which was released recently. I do not know if that will solve the problem or not as I have not tested with MySql 5.1.

The error seems like a permission problem, but these same install scripts have worked since MySql 3.x and if you run them manually on 5.1 they also work fine, so there is either something configured differently by default in MySql 5.1 that causes this error or something is broken in MySql 5.1. I would google for information about what changed in 5.1 vs 5.0 to find clues.

I hope the new connector solves it.

Best,

Joe

5/18/2009 12:32:17 PM

Serjaomendes

Total Posts 3

View Posts

Re: Error on Installing at Mysql 5.1

Ok Joe,

Im waiting for new release.

Thanks.

5/19/2009 8:18:49 AM

Serjaomendes

Total Posts 3

View Posts

Re: Error on Installing at Mysql 5.1

Hi,

I try update to new version Released (2-3-0-4)

but. not make any effect :S

Suggestions ?

5/19/2009 9:37:53 AM

Joe Audette

Total Posts 18439

View Posts

Re: Error on Installing at Mysql 5.1

I would check with your host if they have included the InnoDb storage engine as that is required for mojoPortal. The initial check that mojoPortal does to test the MySql db is to create and drop a table, but this is using the MyIsam storage engine, when it runs the scripts its trying to create InnoDb tables.

Thats why it says "database permissions are sufficient to alter schema". I'm going to change the test code in the next release to use InnoDb so it will match the actual tables. MyIsam is the default storage engine in MySql but it does not support transactions so we have always used InnoDb.

A while back when Oracle bought InnoDb it may have spooked MySql and maybe they don't include InnoDB in all packages of MySql, of course going forward since Oracle is buying Sun, it seems likely that they will include InnoDB.

Possibly this bug is related.

Thats all the info I have for you right now.

Best,

Joe

5/19/2009 1:24:41 PM

Joe Audette

Total Posts 18439

View Posts

Re: Error on Installing at Mysql 5.1

I have very good news for you. I installed MySql 5.1 on my machine today and of course the same errors occurred. But, I was able to find a solution. For anyone interested, the code change that solved it was like this:

// this fixed the problems with mysql 5.1
MySqlScript mySqlScript = new MySqlScript(connection, script);
mySqlScript.Execute();

//this worked in all versions of mysql prior to 5.1
//MySqlHelper.ExecuteNonQuery(
// connection,
// script,
// null);
transaction.Commit();
result = true;

I have uploaded a new mojoportal-2-3-0-4-mysqldatalayer-GPL.zip file. If you download the new version and replace the /bin/mojoPortal.Data.dll in your installation with the new one it should work.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.