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

The content that belongs here is too complex to display securely.
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 18409
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.