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.

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.