Install Scripts with Remote DB look for local MySQL DB

Submitted by oracast on Thu, 12/29/2011 - 05:20

As the title says, here is the error I get: Database connection failed : DBI connect failed : Access denied for user 'whatever'@'192.168.0.14' (using password: YES) 1360.

.. failed! See the error message above for the reason why.

That is the local DB though with the remote set to 192.168.0.30. Any ideas?

Status: 
Closed (fixed)

Comments

Submitted by andreychek on Thu, 12/29/2011 - 08:29

Howdy -- can you describe your setup there? How was the remote database configured (that is, where is it that 192.168.0.30 is configured as the remote database)?

Submitted by JamieCameron on Thu, 12/29/2011 - 12:25

Also, which script was this? Virtualmin will configure almost all of them to connect to the remote MySQL, but some scripts may not have a setting to allow this ..

Submitted by oracast on Thu, 12/29/2011 - 12:58

Hi guys,

We have a remote MySQL 5 server setup on IP 192.168.0.30. We followed the steps here to set this up:

http://www.virtualmin.com/documentation/id,running_mysql_on_a_remote_sys...

Through Virtualmin I can add databases for the vhosts with ease: Creating MySQL database something_test .. .. done Updating Webmin user .. .. done Re-loading Webmin ..

.. done

At the top of the edit databases I can see this: All databases on this system are hosted on the remote MySQL server 192.168.0.30.

Now running the install of SquirrelMail.....

Found http://prdownloads.sourceforge.net:80/sourceforge/squirrelmail/squirrelm... in cache .. Found http://scripts.virtualmin.com:80/set_user_data-1.0.tar.gz in cache ..

Configuring webserver PHP settings .. .. already done.

Applying web server configuration .. .. done

Now installing SquirrelMail version 1.4.21 ..

Database connection failed : DBI connect failed : Access denied for user 'iwisesolutions'@'192.168.0.14' (using password: YES) 1360.

.. failed! See the error message above for the reason why.

Applying web server configuration ..

.. done

Part of the reason for this is so I can help setup a script installer for one of our own apps but it seems the DB stuff does not work for this and the example online of WordPress install also doesn't work even after some tweaking. If I could get either of those to work then I would be more confident in setting up one of my own script installers.

Thanks again.

Submitted by JamieCameron on Thu, 12/29/2011 - 13:10

If you login to Virtualmin as the iwisesolutions user and go to Edit Databases and click on the "Manage.." link next to your database, does it fail with the same error?

Submitted by oracast on Thu, 12/29/2011 - 15:08

Hmmm...you may have led me down the right path. Actually logging in as that user and clicking into webmin shows the same error. I will do a little more digging here and post back what I find unless you have suggestions. I am actually reading the message properly now and it's talking about user permissions FROM that host, not TO that host so what I am seeing is not an IP address error but a permissions error. Sorry. Will try to resolve here ASAP.

Submitted by oracast on Thu, 12/29/2011 - 19:38

Thank you. This was resolved as the user was not being created with enough permissions to connect from the virtualmin server. Setting up additional hosts in the MySQL settings in Virtualmin and properly configuring the hosts file on the remote MySQL server ensured the user had permissions to connect properly. My apologies for my own confusion here.

Submitted by JamieCameron on Thu, 12/29/2011 - 19:50

Cool, glad you got this working..