Database data dlls

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.
4/1/2010 9:39:02 PM
lithuanian98
Gravatar
Total Posts 6
View Posts

Database data dlls

I am trying to use MySql for my website and during setup it keeps trying to use MS SQL. I saw the following in the web.config file and needed help.

<!-- Note that each db platform has its own connection string, but the database used depends on which data dlls are in the bin folder
it is not determined by configuration settings.

What dll do I need in the bin folder for MySql to be used?

 

Bill Lugaila

4/1/2010 10:18:47 PM
lithuanian98
Gravatar
Total Posts 6
View Posts

Re: Database data dlls

Have the above error solved but have the following.

MySql.Data.MySqlClient.MySqlException: Access denied for user 'mojouser'@'GANGA' (using password: YES) at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read) at MySql.Data.MySqlClient.NativeDriver.Authenticate411() at MySql.Data.MySqlClient.NativeDriver.Authenticate() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at mojoPortal.Data.DBPortal.DatabaseHelperGetConnectionError(String overrideConnectionInfo)

 

I changed the connection string in user.config and web.config, neither has ganga.

4/2/2010 8:23:10 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Database data dlls

Hi,

MySql permissions are very granular, they must be assigned per machine that the user will connect from.  So mojouser must have permissions associated with the host name GANGA, which is apparently the name of the web server machine from the point of view of MySql. So permissions must be granted for mojouser@GANGA

Hope it helps,

Joe

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