ZoneMinder Forums

I got an error when I ran /usr/bin/zmupdate.pl to upgrade my database.

Ubuntu 14.04-3 64 bit system

Upgrading database to version 1.28.109
Loading config from DB
Saving config to DB
DBD::mysql::db do failed: Access denied for user 'zmuser'@'localhost' to database 'zm' at /usr/share/perl5/ZoneMinder/ConfigAdmin.pm line 135, <STDIN> line 2.
Can't lock Config table: Access denied for user 'zmuser'@'localhost' to database 'zm' at /usr/bin/zmupdate.pl line 498.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db handle database=zm;host=localhost at /usr/share/perl/5.18/Carp.pm line 100, <STDIN> line 2.

I got around the error by dropping the zm database and installing a fresh copy

I did too today, I think I went to phpmyadmin and the privileges were reduced for zmuser, so I edited it and applied all.

I also had a version mismatch error so I installed again uping .108 to .109. so after I fixed zmuser I ran zmupdate.pl

The best I can remember

Jimmy

Can't lock Config table: Access denied for user 'zmuser'@'localhost' to database 'zm' at /usr/bin/zmupdate.pl line 498.

So either the Config table was open by some other process (did you stop zoneminder?)
or your zmuser account does not have mysql "lock" permission assigned to it.

zm was stopped

lack of "lock" likely it

Should input?

mysql -e "grant select,insert,update,delete,create,lock on zm.* to 'zmuser'@localhost identified by 'zmpass';"


Will try again tomorrow.

I got an error when I ran /usr/bin/zmupdate.pl to upgrade my database.

I ran into the same errors with the fix by ending up dropping the database and creating new. Upgrade 1.28.108 > 1.28.109

Upgrade worked the second time. MySQL permissions should be:

mysql -e "grant select,insert,update,delete,create,alter,lock tables on zm.* to 'zmuser'@localhost identified by 'zmpass';"

Upgrade procedures at:

https://wiki.zoneminder.com/Common_Issu ... _on_Ubuntu

Bill,
As of 1.28.109, you need to add "index" to the set of mysql permissions.

Will go back and try it again.....

bb

2nd test upgrade. I needed the lock tables and alter to get the database upgrade to work. So, with index added the command is:

mysql -e "grant select,insert,update,delete,create,alter,lock tables,index on zm.* to 'zmuser'@localhost identified by 'zmpass';"