zm remote mysql server.

Forum for questions and support relating to the 1.30.x releases only.
Locked
drako
Posts: 1
Joined: Wed Apr 05, 2017 8:26 pm

zm remote mysql server.

Post by 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
Posts: 97
Joined: Sun May 28, 2017 4:29 pm

Re: zm remote mysql server.

Post by 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
Posts: 17
Joined: Fri May 19, 2017 1:52 am

Re: zm remote mysql server.

Post by 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.
Locked