unable to install from source 1.26.5

Forum for questions and support relating to the 1.26.x releases only.
Locked
User avatar
Basildane
Posts: 108
Joined: Mon Sep 16, 2013 1:09 pm

unable to install from source 1.26.5

Post by Basildane »

I am stuck on an error from zmupdate.pl

Code: Select all

mysqldump: Got error: 1044: Access denied for user 'zm'@'localhost' to database 'zm' when using LOCK TABLES
I tried zmupdate.pl -u zm -p zm, but that didn't help.
zm/zm are what I have listed as the db user and password according to my old zm.conf.
I tried admin/admin too, same error.

I am compiling from source, Ubuntu 12.04 LTS.
I had no problem compiling from source for 1.26.4.
User avatar
Basildane
Posts: 108
Joined: Mon Sep 16, 2013 1:09 pm

Re: unable to install from source 1.26.5

Post by Basildane »

nevermind.
Found on another forum: zmupdate.pl --user=root --pass=

That worked.
User avatar
knight-of-ni
Posts: 2406
Joined: Thu Oct 18, 2007 1:55 pm
Location: Shiloh, IL

Re: unable to install from source 1.26.5

Post by knight-of-ni »

You need to add the "Lock Tables" permission to your mysql user "zm".
The documentation has been updated to reflect this.

This feature was added to prevent one's Config tables from getting corrupted.
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/
User avatar
Basildane
Posts: 108
Joined: Mon Sep 16, 2013 1:09 pm

Re: unable to install from source 1.26.5

Post by Basildane »

Thanks, I will do that.
I guess you have to know these things when you're king.
User avatar
knight-of-ni
Posts: 2406
Joined: Thu Oct 18, 2007 1:55 pm
Location: Shiloh, IL

Re: unable to install from source 1.26.5

Post by knight-of-ni »

I might even know the unladen velocity of a swallow too.... both African and European. :D

But, in all seriousness, I didn't realize we pushed the Lock Tables requirement out for 1.26.5. Until I read your post, I thought it was slated for the next release.
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/
Locked