Author Topic: moving MYSQL DB to a different MYSQL SERVER POSSIBLE?  (Read 1910 times)

Offline uyuy

  • Newbie
  • *
  • Posts: 1
moving MYSQL DB to a different MYSQL SERVER POSSIBLE?
« on: January 28, 2019, 06:20:23 PM »
 :)

I have a rather new roundcube installation with the latest which was fresh download @ end 2018 near X'mas it works.

Now in a effort of consolidation I am trying to move the database roundcubemain from localhost to other host in LAN, the database is exported and verified, and the aim is to no longer have a MYSQL SERVER inside this apache that host roundcube, and just have single MYSQL server centrallizing all other databases, safer for backup and security.

If successful then I can purge mysql-server from this host.

I edited /var/www/html/rcube/config/config.inc.php

$config['db_dsnw'] = 'mysql://roundcube:PASSWORD@localhost/roundcubemail';

changed to :


$config['db_dsnw'] = 'mysql://roundcube:PASSWORD@192.168.1.169/roundcubemail';

By substitution from localhost to ip address of new MYSQL server IP address.

It does not work, DATABASE ERROR: CONNECTION FAILED! msg on the login page.

Any members here got any idea? What is the correct edit and format to specify new SQL server?

The other MYSQL server works with an empty temporary roundcube setup there already. It has grant for the remote user and firewall opening. These are verified by bash mysql client login at the roundcube host. I can SELECT TABLE etc.

When I gave show grants with is user login using bash mysql client I got:

GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `user\_%`.* TO 'user'@'%'             |

Is there something else in php server that I have to modify?

Could it be APPARMOR restriction?

Thanks folks!

 ;)
« Last Edit: January 28, 2019, 06:25:46 PM by uyuy »