[Slackbuilds-users] Problems upgrading ZoneMinder

[Daniel Prosser]

Hi,

ZoneMinder was upgraded to version 1.31.1 in the last update. The new
version builds fine, but I am having trouble running the zmupdate.pl
script to update my database. Using this command:

/usr/bin/zmupdate.pl --version=1.30.4 --user={dbuser} --pass={dbpass}

I get this result:

----------
Initiating database upgrade to version 1.31.1 from version 1.30.4

Please ensure that ZoneMinder is stopped on your system prior to
upgrading the database.
Press enter to continue or ctrl-C to stop : 

Do you wish to take a backup of your database prior to upgrading?
This may result in a large file in /var/tmp/zm if you have a lot of
events.
Press 'y' for a backup or 'n' to continue : n

Upgrading database to version 1.31.1
Loading config from DBNo option 'ZM_DIR_EVENTS' found, removing.
No option 'ZM_DIR_IMAGES' found, removing.
No option 'ZM_DIR_SOUNDS' found, removing.
No option 'ZM_FRAME_SOCKET_SIZE' found, removing.
No option 'ZM_OPT_FRAME_SERVER' found, removing.
No option 'ZM_PATH_ARP' found, removing.
No option 'ZM_PATH_LOGS' found, removing.
No option 'ZM_PATH_MAP' found, removing.
No option 'ZM_PATH_SOCKS' found, removing.
No option 'ZM_PATH_SWAP' found, removing.
No option 'ZM_PATH_ZMS' found, removing.
 207 entries
Saving config to DB 207 entries
DBD::mysql::db do failed: Access denied for user 'zmuser'@'localhost' to
database 'zm' at /usr/share/perl5/vendor_perl/ZoneMinder/Config.pm line
214, <STDIN> line 2.
Can't lock Config table: Access denied for user 'zmuser'@'localhost' to
database 'zm' at /usr/bin/zmupdate.pl line 464.
----------

I have also tried without specifying --user and --pass, but I get the
same error. For now I have gone back to my old version and restored the
backup database. I can also ask on the ZoneMinder forums, but I'm not
sure if the issue lies with zmupdate.pl or with the way ZoneMinder is
configured by the SBo package. Seems like pretty much everyone over
there uses Ubuntu, CentOS, or Debian.

Dan