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 <[email protected]> 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][email protected] > > > > 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:[email protected] > > 3. http://zmupdate.pl/ > > 4. http://zmupdate.pl/ > > 5. http://zmupdate.pl/ > > 6. http://zmupdate.pl/ >
_______________________________________________ SlackBuilds-users mailing list [email protected] https://lists.slackbuilds.org/mailman/listinfo/slackbuilds-users Archives - https://lists.slackbuilds.org/pipermail/slackbuilds-users/ FAQ - https://slackbuilds.org/faq/
