[Slackbuilds-users] Problems upgrading ZoneMinder

[Daniel Prosser]

I failed to reply all in my previous message, but anyway it wasn't very
important. The long and short of it was that I changed the password for
the "zmuser" DB user, but I think I needed to regrant permission to the
zm database after that. However, after taking care of that and ensuring
I can log in to mysql as zmuser, I am right back to the original error
when I try to run zmupdate.pl.

But anyway, as far as I'm concerned, I'm not going to upgrade to a new
version until it's actually released by upstream. Hopefully the zmupdate
script will work when that happens.

Dan

On Sat, May 05, 2018 at 03:51:08PM -0700, Geno Bob wrote:
>    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 '[1]zmupdate.pl' command above).
>    Thank you,
> 
>    On Sat, May 5, 2018 at 6:35 AM, Daniel Prosser <[2]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
>      [3]zmupdate.pl
>      script to update my database. Using this command:
>      /usr/bin/[4]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/[5]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 [6]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
> 
> References
> 
>    1. http://zmupdate.pl/
>    2. mailto:dpross1100 at msn.com
>    3. http://zmupdate.pl/
>    4. http://zmupdate.pl/
>    5. http://zmupdate.pl/
>    6. http://zmupdate.pl/