ZoneMinder Forums

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..

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.

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.