Moving Database

Hello,

I’ve encountered an issue when trying to move the database location to another server.

Currently running on Linux (Mint) successfully for 3 years on dedicated hardware with MariaDB, but for some resilliancy i’m moving the database to another installation of MariaDB on a different server.

I backed up to an SQL file and imported it into the new server, quite easy!

Then i modified the server location in conf.php from ‘localhost’ to ‘http://192.168.0.8
and of course entered the correct username and password.

But when opening dolibarr i get error messages about not being able to connect, things like

php_network_getaddresses: getaddrinfo failed: Name or service not known

port is open through firewall and enabled in MariaDB at 3306

all other things remain the same

Does anyone have experience of this kind of error?

So, after a couple of hours trying, just 10 minutes after posting i solved the issue!

the user in the new database was only granted for localhost

also

the address needed to be ‘192.168.0.8’ without the http:// prefix

2 Likes