ZoneMinder Forums

After I make and make install, when i go to perform the upgrade using the zmupdate.pl script. I get the following:

I confirmed ZM was not running and even rebooted the box and again confirmed it was not running.

zmupdate.pl -version=1.22.2 --user=root --pass=XXXX
Warning, overriding installed ./zm.conf file with local copy
Bareword found in conditional at /usr/local/bin/zmupdate.pl line 149.
Update agent starting at 06/12/07 18:29:03

Initiating database upgrade to version 1.22.3
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 if you have a lot of events.
Press 'y' for a backup or 'n' to continue : n

Upgrading database to version 1.22.3
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Output:
Command 'mysql -hlocalhost -uroot -pXXXX zm < /zm3/ZoneMinder-1.22.3/db/zm_update-1.22.2.sql' exited with status: 1


I tried using the root password and the zmuser and password.
________
Suzuki FR-50 specifications

Hogface wrote: zmupdate.pl -version=1.22.2 --user=root --pass=XXXX
Warning, overriding installed ./zm.conf file with local copy
Bareword found in conditional at /usr/local/bin/zmupdate.pl line 149.
Update agent starting at 06/12/07 18:29:03

Make sure your local copy has correct information. By that error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Suggests that the password is not correct.

Regards,
Corey

The root user id and password work, and I have tried those.
I also tried the zm password and id (database). Both allow me to login into the db...

but script still doesnt work.
________
extreme vaporizer

Hogface wrote: Warning, overriding installed ./zm.conf file with local copy

Find the offending zm.conf and then your update will work.

Regards,
Corey

Elminated one other zm.conf in the ZoneMinder-1.22.2 directory.
Still get the same error:

[root@scruffy ZoneMinder-1.22.3]# zmupdate.pl -version=1.22.2 --user=root --pass=XXXX
Warning, overriding installed ./zm.conf file with local copy
Bareword found in conditional at /usr/local/bin/zmupdate.pl line 149.
Update agent starting at 06/12/07 19:33:02

Initiating database upgrade to version 1.22.3
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 if you have a lot of events.
Press 'y' for a backup or 'n' to continue : y
Creating backup to zm-1.22.2.dump. This may take several minutes.
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
Output:
Command 'mysqldump -hlocalhost -uadmin -pXXXX --add-drop-table --databases zm > zm-1.22.2.dump' exited with status: 2
________
Honda VT250F specifications

Change out of the source directory that has a zm.conf and run zmupdate.pl.

Make sure that the version in /etc/zm.conf is set at 1.22.3

Corey

Disread the difference in the username...I was changing it only for the post.
________
volcano vaporizer

Hello all!!

i think: you'll use the crypted password ...perhaps...
can you try ?

In zm.conf, the line that says current was .3....I changed it to .2, but it made no differences.

Still getting the error
________
marijuana vaporizer

Do you have ssh access into this box?
PM the details if you want me to take a look.

Corey

You should have the info in a private message
________
787B

Your database is upgraded. Sorry I had to eat dinner before getting to you.
For security reasons, I will not say what the specific issue was but,

Your root user to login to Linux is not the same as your root user to login to mysql.

Regards,
Corey

PS Look for my PM for details

SecServ:/ # zmupdate.pl -version=1.22.2 --user=zm --pass=zm
Bareword found in conditional at /usr/local/bin/zmupdate.pl line 149.
Update agent starting at 06/12/19 14:06:45

Initiating database upgrade to version 1.22.3
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 if you have a lot of events.
Press 'y' for a backup or 'n' to continue : n

Upgrading database to version 1.22.3
ERROR 1142 (42000) at line 8: ALTER command denied to user 'zm'@'localhost' for table 'Filters'
Output:
Command 'mysql -hlocalhost -uzm -pzm zm < /usr/local/ZoneMinder-1.22.3/db/zm_update-1.22.2.sql' exited with status: 1

Any ideas about this one? Seems like it couldn't open the filters table.

ManRoaming wrote: ERROR 1142 (42000) at line 8: ALTER command denied to user 'zm'@'localhost' for table 'Filters'

exactly like it says, you obviously didn't give the zm usr permition to alter tables so need to use the root user instead of zm.

Regards,
Corey

Would alter permission be set when I ran the configure script?