Forums

How to connect concrete5 to a remote database at the initial setup?

Permalink
I have no issues setting up the database on a localhost basis but what I wanted to do (and had been doing) in production was to put the databases in one server.

How do I tell concrete5 that the database is located at 192.168.10.1 and NOT at the localhost?

My workaround:
I made a workaround by setting it up using its localhost database (it went well) then after I change the site.php file and point DB-Server to 192.168.10.1 - save site.php, restart apache but it failed to connect with the database.

see attached image.

These databases have the same details except of its location:
1 - localhost and other 1 is in 192.168.10.1

How do i resolve this? during the setup / installation of concrete5 and post installation / setup? (ie: moving of database from host1 to host2)

Thanks, Aste

1 Attachment

 
unionsystems replied on at Permalink Reply
unionsystems
Hi Aste,

Did you work out your issue?

I am wanting to trial use of an Amazon RDS remote database service instead of a localhost mysql database to see if I can improve concrete5 website performance. I can connect manually to the remote database server from the server hosting my concrete5 website with the mysql command 

# mysql -h remote_server -u db_username -p db_password


But when I change the config/site.php line from
define('DB_SERVER', 'localhost');

to
define('DB_SERVER', 'remote_server');


The connection fails (and yes I do have a concrete5 database on the remote_server).

Note that "remote_server db_username db_password" all use real names in real setup.