[Slackbuilds-users] Problems upgrading ZoneMinder

[Geno Bob]

If you get a few minutes, you might try updating the database one step at a
time. You are going from 1.30.4 right to 1.31.1, however there is a decent
amount of updates in the 1.31.0 db file. Try updating the db to 1.31.0 and
then to 1.31.1 and see if it makes a difference. When I get a chance I will
spin up a VM with 1.30.4 and see if I cant replicate your issue.

Also, Urchlay is THE urchlay. If you ever go onto a slackware forum or IRC,
he will be there.

Thank you,
GenoBob

On Sat, May 5, 2018 at 8:12 PM, Daniel Prosser <dpross1100 at msn.com> wrote:

> 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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.slackbuilds.org/pipermail/slackbuilds-users/attachments/20180506/80771e6e/attachment.html>