MariaDB access denied
Posted: Thu Dec 26, 2019 10:28 pm
I've recently updated to 1.33.16 on archlinux. I've got a multiserver setup that has had some issues on 1.32.4.
I've got a db server running just fine on another arch box, but none of my zoneminder boxes can connect.
On the DB server, I get.
On the ZM server, I get
Heres the rub, I'm able to log in to the db server from the zm server with 'mysql -uzmuser -pzmpass -hfqdn.domain.org zm'
Those values for username/password/db name are the same in /etc/zoneminder/zm.conf AND a separate file named /etc/zoneminder/conf.d/03-dbconf.conf
What am I missing? The username/password is correct without a doubt, the clocks are synced with ntp. Any ideas?
I've got a db server running just fine on another arch box, but none of my zoneminder boxes can connect.
On the DB server, I get.
Code: Select all
2019-12-26 17:23:06 19250 [Warning] Access denied for user 'zmuser'@'fqdn.domain.org' (using password: YES)
Code: Select all
Dec 26 17:24:33 zoneminder undef[4663]: ERR [undef] [Can't connect to server: Access denied for user 'zmuser'@'fqdn.domain.org' (using password: YES)]
Dec 26 17:24:33 zoneminder undef[4663]: ERR [undef] [Can't run query: MySQL server has gone away]
Those values for username/password/db name are the same in /etc/zoneminder/zm.conf AND a separate file named /etc/zoneminder/conf.d/03-dbconf.conf
What am I missing? The username/password is correct without a doubt, the clocks are synced with ntp. Any ideas?