<div dir="ltr"><div><div><div>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. <br><br></div>Also, Urchlay is THE urchlay. If you ever go onto a slackware forum or IRC, he will be there. <br><br></div>Thank you,<br></div>GenoBob<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, May 5, 2018 at 8:12 PM, Daniel Prosser <span dir="ltr"><<a href="mailto:dpross1100@msn.com" target="_blank">dpross1100@msn.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I failed to reply all in my previous message, but anyway it wasn't very<br>
important. The long and short of it was that I changed the password for<br>
the "zmuser" DB user, but I think I needed to regrant permission to the<br>
zm database after that. However, after taking care of that and ensuring<br>
I can log in to mysql as zmuser, I am right back to the original error<br>
when I try to run <a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a>.<br>
<br>
But anyway, as far as I'm concerned, I'm not going to upgrade to a new<br>
version until it's actually released by upstream. Hopefully the zmupdate<br>
script will work when that happens.<br>
<span class=""><br>
Dan<br>
<br>
On Sat, May 05, 2018 at 03:51:08PM -0700, Geno Bob wrote:<br>
</span><span class="">> Daniel,<br>
> According to your error, your credentials are incorrect for your SQL<br>
> database. Try signing into your database using mysql -u zmuser -p<br>
> when it asks for a password put in your password (the same credentials<br>
</span>> you used in the '[1]<a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a>' command above).<br>
> Thank you,<br>
> <br>
> On Sat, May 5, 2018 at 6:35 AM, Daniel Prosser <[2]<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a>><br>
<span class="">> wrote:<br>
> <br>
> Hi,<br>
> ZoneMinder was upgraded to version 1.31.1 in the last update. The<br>
> new<br>
> version builds fine, but I am having trouble running the<br>
</span>> [3]<a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a><br>
<span class="">> script to update my database. Using this command:<br>
</span>> /usr/bin/[4]<a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a> --version=1.30.4 --user={dbuser}<br>
<div><div class="h5">> --pass={dbpass}<br>
> I get this result:<br>
> ----------<br>
> Initiating database upgrade to version 1.31.1 from version 1.30.4<br>
> Please ensure that ZoneMinder is stopped on your system prior to<br>
> upgrading the database.<br>
> Press enter to continue or ctrl-C to stop :<br>
> Do you wish to take a backup of your database prior to upgrading?<br>
> This may result in a large file in /var/tmp/zm if you have a lot of<br>
> events.<br>
> Press 'y' for a backup or 'n' to continue : n<br>
> Upgrading database to version 1.31.1<br>
> Loading config from DBNo option 'ZM_DIR_EVENTS' found, removing.<br>
> No option 'ZM_DIR_IMAGES' found, removing.<br>
> No option 'ZM_DIR_SOUNDS' found, removing.<br>
> No option 'ZM_FRAME_SOCKET_SIZE' found, removing.<br>
> No option 'ZM_OPT_FRAME_SERVER' found, removing.<br>
> No option 'ZM_PATH_ARP' found, removing.<br>
> No option 'ZM_PATH_LOGS' found, removing.<br>
> No option 'ZM_PATH_MAP' found, removing.<br>
> No option 'ZM_PATH_SOCKS' found, removing.<br>
> No option 'ZM_PATH_SWAP' found, removing.<br>
> No option 'ZM_PATH_ZMS' found, removing.<br>
> 207 entries<br>
> Saving config to DB 207 entries<br>
> DBD::mysql::db do failed: Access denied for user<br>
> 'zmuser'@'localhost' to<br>
> database 'zm' at /usr/share/perl5/vendor_perl/<wbr>ZoneMinder/Config.pm<br>
> line<br>
> 214, <STDIN> line 2.<br>
> Can't lock Config table: Access denied for user 'zmuser'@'localhost'<br>
> to<br>
</div></div>> database 'zm' at /usr/bin/[5]<a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a> line 464.<br>
<span class="">> ----------<br>
> I have also tried without specifying --user and --pass, but I get<br>
> the<br>
> same error. For now I have gone back to my old version and restored<br>
> the<br>
> backup database. I can also ask on the ZoneMinder forums, but I'm<br>
> not<br>
</span>> sure if the issue lies with [6]<a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a> or with the way<br>
<span class="im HOEnZb">> ZoneMinder is<br>
> configured by the SBo package. Seems like pretty much everyone over<br>
> there uses Ubuntu, CentOS, or Debian.<br>
> Dan<br>
> <br>
</span><div class="HOEnZb"><div class="h5">> References<br>
> <br>
> 1. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 2. mailto:<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a><br>
> 3. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 4. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 5. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 6. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
</div></div></blockquote></div><br></div>