[Slackbuilds-users] Problems upgrading ZoneMinder

[Willy Sudiarto Raharjo]

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

After looking at the last commit, it seems a mystery for me as the
sources are taken NOT from upstream but from third party repository. The
latest release by upstream is still at 1.30.4 as well.



-- 
Willy Sudiarto Raharjo

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 195 bytes
Desc: OpenPGP digital signature
URL: <http://lists.slackbuilds.org/pipermail/slackbuilds-users/attachments/20180505/5be98a5b/attachment.asc>