[Slackbuilds-users] Problems upgrading ZoneMinder
Geno Bob
geno.bob at gmail.com
Mon May 7 04:25:21 UTC 2018
I apologize, no. Anytime you upgrade Zoneminder from any version to another
newer version, you have to upgrade the database incrementally. My easiest
method is no not use the zmupdate tool (it works great if you are working
with incremental versions, but anything more and I like to do it the old
fashioned way), but instead to access mysql directly. In this case run:
mysql -u zmuser -p databasename <
/usr/share/zoneminder/db/zm_update-1.31.0.sql
and
mysql -u zmuser -p databasename <
/usr/share/zoneminder/db/zm_update-1.31.1.sql
replacing zmuser with your database username and databasename with your db
name (probably just zm ?)
This will also give us some more info as to what issue you are having with
the db files, and which file it is having the issue with.
Let me know if this works for you or not.
Thank you,
GenoBob
On Sun, May 6, 2018 at 8:47 PM, Daniel Prosser <dpross1100 at msn.com> wrote:
> If I get time, I will give that a try. But seeing as how upstream still
> has 1.30.4 as the latest source, I'm not exactly sure where I'm supposed
> to get 1.31.0. I'm guessing the same urchlay site, but just adjust the
> download URL?
>
> I guess I'm just ignorant, but I have been active on the Slackware forum
> on Linuxquestions.org for a couple years and never remember coming
> across someone named Urchlay. But that aside, I'm not sure why being a
> well-known Slackware user makes him the correct upstream for ZoneMinder.
> Is he a ZoneMinder dev also? Why does the official upstream still have
> 1.30.4 as the latest stable release? I need a better reason for the
> upgrade than what you have provided, and I'm sure the rest of the
> ZoneMinder users on SBo would appreciate one too. (Please don't get me
> wrong -- I'm very appreciative of your maintainership efforts.)
>
> Regards,
> Dan
>
> On Sun, May 06, 2018 at 12:11:37AM -0700, Geno Bob wrote:
> > 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 <[1]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 [2]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][3]zmupdate.pl' command above).
> > > Thank you,
> > >
> > > On Sat, May 5, 2018 at 6:35 AM, Daniel Prosser
> > <[2][4]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][5]zmupdate.pl
> > > script to update my database. Using this command:
> > > /usr/bin/[4][6]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][7]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][8]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. [9]http://zmupdate.pl/
> > > 2. mailto:[10]dpross1100 at msn.com
> > > 3. [11]http://zmupdate.pl/
> > > 4. [12]http://zmupdate.pl/
> > > 5. [13]http://zmupdate.pl/
> > > 6. [14]http://zmupdate.pl/
> >
> > References
> >
> > 1. mailto:dpross1100 at msn.com
> > 2. http://zmupdate.pl/
> > 3. http://zmupdate.pl/
> > 4. mailto:dpross1100 at msn.com
> > 5. http://zmupdate.pl/
> > 6. http://zmupdate.pl/
> > 7. http://zmupdate.pl/
> > 8. http://zmupdate.pl/
> > 9. http://zmupdate.pl/
> > 10. mailto:dpross1100 at msn.com
> > 11. http://zmupdate.pl/
> > 12. http://zmupdate.pl/
> > 13. http://zmupdate.pl/
> > 14. http://zmupdate.pl/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.slackbuilds.org/pipermail/slackbuilds-users/attachments/20180506/883c3fb9/attachment-0001.html>
More information about the SlackBuilds-users
mailing list