[Slackbuilds-users] Problems upgrading ZoneMinder

[Geno Bob]

Daniel,

According to your error, your credentials are incorrect for your SQL
database. Try signing into your database using mysql -u zmuser -p   when it
asks for a password put in your password (the same credentials you used in
the 'zmupdate.pl' command above).

Thank you,

On Sat, May 5, 2018 at 6:35 AM, Daniel Prosser <dpross1100 at msn.com> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.slackbuilds.org/pipermail/slackbuilds-users/attachments/20180505/22a47c1c/attachment-0001.html>