<div dir="ltr"><div><div>No problem. Thank you for testing. I will test on my VM and see if I can replicate. <br><br></div>Thank you,<br></div>GenoBob<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, May 7, 2018 at 7:08 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">Bob,<br>
<br>
Thank you for helping me try to sort this out. I was able to use the<br>
upgrade dbs in /usr/share/zoneminder/db to incrementally upgrade my<br>
database to 1.31.1. At least, the commands completed without reporting<br>
any errors. Before I could do that, I did have to grant alter permission<br>
to zmuser, which wasn't mentioned in README.SLACKWARE, FYI. However,<br>
after upgrading I'm getting a bunch of errors in the logs about not<br>
having proper permissions on directories, sockets not existing, etc.<br>
Those logs recommend running <a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a> -f, which I am still unable to<br>
do. So I'm not really sure if the database was actually upgraded<br>
correctly. These errors may be fixable with some hand editing of the<br>
paths through the web interface, but I need to do more research to find<br>
out.<br>
<br>
B Watson, aka Urchlay, ank youthay orfay explainingay erewhay ethay<br>
ourcesay amecay omfray. (Pardon my poor pig latin.)<br>
<br>
Dan<br>
<span class=""><br>
On Sun, May 06, 2018 at 09:25:21PM -0700, Geno Bob wrote:<br>
> I apologize, no. Anytime you upgrade Zoneminder from any version to<br>
> another newer version, you have to upgrade the database incrementally.<br>
> My easiest method is no not use the zmupdate tool (it works great if<br>
> you are working with incremental versions, but anything more and I like<br>
> to do it the old fashioned way), but instead to access mysql directly.<br>
> In this case run:<br>
> mysql -u zmuser -p databasename <<br>
> /usr/share/zoneminder/db/zm_<wbr>update-1.31.0.sql<br>
> and<br>
> mysql -u zmuser -p databasename <<br>
> /usr/share/zoneminder/db/zm_<wbr>update-1.31.1.sql<br>
> replacing zmuser with your database username and databasename with your<br>
> db name (probably just zm ?)<br>
> This will also give us some more info as to what issue you are having<br>
> with the db files, and which file it is having the issue with.<br>
> Let me know if this works for you or not.<br>
> Thank you,<br>
> GenoBob<br>
> <br>
</span>> On Sun, May 6, 2018 at 8:47 PM, Daniel Prosser <[1]<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a>><br>
<div><div class="h5">> wrote:<br>
> <br>
> If I get time, I will give that a try. But seeing as how upstream<br>
> still<br>
> has 1.30.4 as the latest source, I'm not exactly sure where I'm<br>
> supposed<br>
> to get 1.31.0. I'm guessing the same urchlay site, but just adjust<br>
> the<br>
> download URL?<br>
> I guess I'm just ignorant, but I have been active on the Slackware<br>
> forum<br>
> on Linuxquestions.org for a couple years and never remember coming<br>
> across someone named Urchlay. But that aside, I'm not sure why being<br>
> a<br>
> well-known Slackware user makes him the correct upstream for<br>
> ZoneMinder.<br>
> Is he a ZoneMinder dev also? Why does the official upstream still<br>
> have<br>
> 1.30.4 as the latest stable release? I need a better reason for the<br>
> upgrade than what you have provided, and I'm sure the rest of the<br>
> ZoneMinder users on SBo would appreciate one too. (Please don't get<br>
> me<br>
> wrong -- I'm very appreciative of your maintainership efforts.)<br>
> Regards,<br>
> Dan<br>
> On Sun, May 06, 2018 at 12:11:37AM -0700, Geno Bob wrote:<br>
> > If you get a few minutes, you might try updating the database<br>
> one step<br>
> > at a time. You are going from 1.30.4 right to 1.31.1, however<br>
> there is<br>
> > a decent amount of updates in the 1.31.0 db file. Try updating<br>
> the db<br>
> > to 1.31.0 and then to 1.31.1 and see if it makes a difference.<br>
> When I<br>
> > get a chance I will spin up a VM with 1.30.4 and see if I cant<br>
> > replicate your issue.<br>
> > Also, Urchlay is THE urchlay. If you ever go onto a slackware<br>
> forum or<br>
> > IRC, he will be there.<br>
> > Thank you,<br>
> > GenoBob<br>
> ><br>
> > On Sat, May 5, 2018 at 8:12 PM, Daniel Prosser<br>
</div></div>> <[1][2]<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a>><br>
<span class="">> > wrote:<br>
> ><br>
> > I failed to reply all in my previous message, but anyway it<br>
> wasn't<br>
> > very<br>
> > important. The long and short of it was that I changed the<br>
> password<br>
> > for<br>
> > the "zmuser" DB user, but I think I needed to regrant<br>
> permission to<br>
> > the<br>
> > zm database after that. However, after taking care of that<br>
> and<br>
> > ensuring<br>
> > I can log in to mysql as zmuser, I am right back to the<br>
> original<br>
> > error<br>
</span>> > when I try to run [2][3]<a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a>.<br>
<span class="">> > But anyway, as far as I'm concerned, I'm not going to upgrade<br>
> to a<br>
> > new<br>
> > version until it's actually released by upstream. Hopefully<br>
> the<br>
> > zmupdate<br>
> > script will work when that happens.<br>
> > Dan<br>
> > On Sat, May 05, 2018 at 03:51:08PM -0700, Geno Bob wrote:<br>
> > > Daniel,<br>
> > > According to your error, your credentials are incorrect<br>
> for<br>
> > your SQL<br>
> > > database. Try signing into your database using mysql -u<br>
> zmuser<br>
> > -p<br>
> > > when it asks for a password put in your password (the<br>
> same<br>
> > credentials<br>
</span>> > > you used in the '[1][3][4]<a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a>' command above).<br>
<span class="">> > > Thank you,<br>
> > ><br>
> > > On Sat, May 5, 2018 at 6:35 AM, Daniel Prosser<br>
</span>> > <[2][4][5]<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<br>
> update.<br>
> > The<br>
> > > new<br>
> > > version builds fine, but I am having trouble running<br>
> the<br>
</span>> > > [3][5][6]<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][6][7]<a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a> --version=1.30.4<br>
<div><div class="h5">> --user={dbuser}<br>
> <br>
> ><br>
> > > --pass={dbpass}<br>
> > > I get this result:<br>
> > > ----------<br>
> > > Initiating database upgrade to version 1.31.1 from version<br>
> > 1.30.4<br>
> > > Please ensure that ZoneMinder is stopped on your system<br>
> 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<br>
> > upgrading?<br>
> > > This may result in a large file in /var/tmp/zm if you have<br>
> a lot<br>
> > 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,<br>
> 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/<br>
> > ZoneMinder/Config.pm<br>
> > > line<br>
> > > 214, <STDIN> line 2.<br>
> > > Can't lock Config table: Access denied for user<br>
> > 'zmuser'@'localhost'<br>
> > > to<br>
> ><br>
> <br>
</div></div>> > > database 'zm' at /usr/bin/[5][7][8]<a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a> line<br>
<span class="">> 464.<br>
> > > ----------<br>
> > > I have also tried without specifying --user and<br>
> --pass, but I<br>
> > get<br>
> > > the<br>
> > > same error. For now I have gone back to my old version<br>
> and<br>
> > restored<br>
> > > the<br>
> > > backup database. I can also ask on the ZoneMinder<br>
> forums, but<br>
> > I'm<br>
> > > not<br>
</span>> > > sure if the issue lies with [6][8][9]<a href="http://zmupdate.pl" rel="noreferrer" target="_blank">zmupdate.pl</a> or<br>
<span class="">> with the way<br>
> > > ZoneMinder is<br>
> > > configured by the SBo package. Seems like pretty much<br>
> > everyone over<br>
> > > there uses Ubuntu, CentOS, or Debian.<br>
> > > Dan<br>
> > ><br>
> ><br>
> > > References<br>
> > ><br>
</span>> > > 1. [9][10]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > > 2. mailto:[10][11]<a href="mailto:dpross1100@msn.com">dpross1100@msn.<wbr>com</a><br>
> > > 3. [11][12]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > > 4. [12][13]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > > 5. [13][14]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > > 6. [14][15]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> ><br>
> > References<br>
> ><br>
> > 1. mailto:[16]<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a><br>
> > 2. [17]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > 3. [18]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > 4. mailto:[19]<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a><br>
> > 5. [20]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > 6. [21]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > 7. [22]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > 8. [23]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > 9. [24]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > 10. mailto:[25]<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a><br>
> > 11. [26]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > 12. [27]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > 13. [28]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> > 14. [29]<a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> <br>
> References<br>
> <br>
> 1. mailto:<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a><br>
<span class="">> 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>
</span>> 5. mailto:<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a><br>
<span class="">> 6. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 7. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 8. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 9. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
</span>> 10. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 11. mailto:<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a><br>
<span class="">> 12. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 13. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 14. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
</span>> 15. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 16. mailto:<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a><br>
> 17. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 18. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 19. mailto:<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a><br>
> 20. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 21. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 22. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 23. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 24. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 25. mailto:<a href="mailto:dpross1100@msn.com">dpross1100@msn.com</a><br>
> 26. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 27. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 28. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
> 29. <a href="http://zmupdate.pl/" rel="noreferrer" target="_blank">http://zmupdate.pl/</a><br>
</blockquote></div><br></div>