zm remote mysql server.

[drako]

Hi,
i've installed zoneminder 1.30 in ubuntu.

i need to change the settings of zm.conf to add new ip address of mysql server on a remote.

first i dump databases and move to the new server, create the same user and password with grant all and the database with same name.

and i 've changed the /etc/zm/zm.conf the ZM_DB_HOST=10.0.0.4

them i stop the mysql services, visit the webpage of zm and appears mysql connect error.

anyone can help please..

[Maximo1970]

If you've not resolved this issue, have you made sure that the ZM host is allowed to access MySQL? For example change the account from 'zm@hostname.domain.net' to be 'zm@%'. This will allow all hosts to access MySQL from that account.

[tpcarmen]

Make sure you can actually connect as the zm user from the machine zm is running on.

From the command prompt type:

mysql --host=YourServerAddress -u UserName -p --protocol=TCP

If you can't connect that way, Zoneminder can't connect either.