Modx Install: one web server, one database server

Hello all,

I’m trying to install Modx to one server, while connecting it to a database that’s set up on a different server. (Client’s request, they insisted on this for security reasons.)

My plan of attack was to install Modx on the DB server in order to have it create the necessary tables, then run the install on the web server and point it to the DB server.

Part one (installing to the DB server) seems to have worked, although I did get an error at the end (Could not load DBAPI class).

Part two stalled at the screen that asks you for Database Information. For ’Database host’, I entered the ip of the DB server ( like so - http://120.120.10.1 ), then the user and password.

However, clicking on Test database server connection and view collations does nothing.

I’ve searched for solutions to this, but nothing I’ve tried yet has worked.

Any suggestions?

• ModX 1.04
• Apache / 2.2.14 (Ubuntu)
• MySQL client version: 5.1.41
• PHP version 5.3.2
• Using Firefox and Chrome for install

Thank you.

That is not necessary. Install MODx where you want it, and simply tell the installer the host for the database in the appropriate field (where you see the default ’localhost’).

Thanks for the response. Unfortunately, I’ve done that but the Test database server link still is non-functioning.

I suppose what I should be asking is what would potentially cause this link to not work?

Perhaps they’ve neglected to install a necessary component to the server?

You may need to tell it the port number, usually 3306. e.g.
120.120.10.1:3306
I seem to recall I used something like that when in the same situation.

You also need to ensure that MySQL accepts remote connections

From the client’s IT guy:

The identifier in the my.cnf file was set to localhost instead of 120.120.10.x. That told mysql to not answer outside requests.

Thank you to everyone for the help.