Setting up mojo with MySql

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.
3/21/2010 12:58:50 PM
Gravatar
Total Posts 4

Setting up mojo with MySql

Hi,

Just downloaded mojo and have tried to set it up on my web host.

I've copied over the various files from the MySql data layer but when i try to run the install it still says:

The system cannot connect to the MSSQL database. Please check your connection string

I'm not sure the connection string is correct but was wondering if i have set up mojo correctly, should it say this instead:

The system cannot connect to the MySql database. Please check your connection string

Si

 

3/23/2010 6:53:13 AM
Gravatar
Total Posts 18439

Re: Setting up mojo with MySql

Hi,

If the error says it cannot connect to MS SQL then it means clearly you have not replaced the dlls in the /bin folder with the MySql versions, so you may have copied files but not into the correct locations.

Hope it helps,

Joe

3/23/2010 7:24:53 AM
Gravatar
Total Posts 4

Re: Setting up mojo with MySql

thanks, turned out my ftp client was having problems copying files

3/23/2010 7:34:24 AM
Gravatar
Total Posts 18439

Re: Setting up mojo with MySql

I recommend FileZilla ftp client, it has a feature for showing failed transfers and allowing you to retry them.

Best,

Joe

3/23/2010 2:57:50 PM
Gravatar
Total Posts 4

Re: Setting up mojo with MySql

Ok new problem.

I'm now recieving this error:

Requested value '{MySQL ODBC 5.1 Driver}' was not found.

Stack trace:
[ArgumentException: Requested value '{MySQL ODBC 5.1 Driver}' was not found.]
System.Enum.Parse(Type enumType, String value, Boolean ignoreCase) +7534623
MySql.Data.MySqlClient.MySqlConnectionStringBuilder.ConvertToDriverType(Object value) +89
MySql.Data.MySqlClient.MySqlConnectionStringBuilder.SetValue(Keyword kw, Object value) +352
MySql.Data.MySqlClient.MySqlConnectionStringBuilder.SetValue(String keyword, Object value) +65
MySql.Data.MySqlClient.MySqlConnectionStringBuilder.set_Item(String keyword, Object value) +26
System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value) +181
MySql.Data.MySqlClient.MySqlConnectionStringBuilder..ctor(String connectionString) +82
MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString(String value) +143
MySql.Data.MySqlClient.MySqlConnection..ctor(String connectionString) +24
MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms) +54
mojoPortal.Data.DBTaskQueue.DeleteCompleted() +111
mojoPortal.Business.TaskQueue.DeleteCompleted() +5
mojoPortal.Web.WebTaskManager.StartOrResumeTasks(Boolean appWasRestarted) +62
mojoPortal.Web.Global.StartOrResumeTasks() +296
mojoPortal.Web.Global.Application_Start(Object sender, EventArgs e) +222

I've asked my web host if it is a problem their end and they say it must be mojo. They also say i need Driver:{MySQL ODBC 5.1 Driver} in the connection string.  Anyone know how i sort this?

3/24/2010 8:44:21 AM
Gravatar
Total Posts 18439

Re: Setting up mojo with MySql

Hi,

The mojoPortal Data layer for MySql does not use the ODBC driver for MySql, it uses the .NET Connector for MySql.

And the only way it can work in most medium trust shared hosting is if the host has the correct version of the MySql.Data.dll (the .NET Connector) installed in the GAC (Global Assembly Cache) on the server. In full trust it can use the MySql.Data.dll that is in the /bin folder but in medium trust the correct version must be in the GAC.

Bottom line is if you have medium trust hosting you will have an easier time with MS SQL database.

Hope it helps,

Joe

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