Upgrade error

Forum for questions and support relating to the 1.31.x releases only.
Locked
siki
Posts: 3
Joined: Sun Nov 15, 2009 11:39 pm

Upgrade error

Post by siki »

Hi
upgrade attempt let my system unusable...

------------------------------------------------
siki@siki:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.4 LTS
Release: 16.04
Codename: xenial

siki@zmhost:~$ sudo zmupdate.pl
Upgrading database to version 1.31.44
Loading config from DB 222 entries
Saving config to DB 222 entries
Upgrading DB to 1.31.2 from 1.31.1

Database successfully upgraded to version 1.31.2.
Upgrading DB to 1.31.3 from 1.31.1

Database successfully upgraded to version 1.31.3.
Upgrading DB to 1.31.4 from 1.31.1

Database successfully upgraded to version 1.31.4.
Upgrading DB to 1.31.5 from 1.31.1

Database successfully upgraded to version 1.31.5.
Upgrading DB to 1.31.6 from 1.31.1

Database successfully upgraded to version 1.31.6.
Upgrading DB to 1.31.7 from 1.31.1

Database successfully upgraded to version 1.31.7.
Upgrading DB to 1.31.8 from 1.31.1

Database successfully upgraded to version 1.31.8.
Upgrading DB to 1.31.9 from 1.31.1

Database successfully upgraded to version 1.31.9.
Upgrading DB to 1.31.10 from 1.31.1

Database successfully upgraded to version 1.31.10.
Upgrading DB to 1.31.11 from 1.31.1

Database successfully upgraded to version 1.31.11.
Upgrading DB to 1.31.12 from 1.31.1

Database successfully upgraded to version 1.31.12.
Upgrading DB to 1.31.13 from 1.31.1

Database successfully upgraded to version 1.31.13.
Upgrading DB to 1.31.14 from 1.31.1

Database successfully upgraded to version 1.31.14.
Upgrading DB to 1.31.15 from 1.31.1

Database successfully upgraded to version 1.31.15.
Upgrading DB to 1.31.16 from 1.31.1

Database successfully upgraded to version 1.31.16.
Upgrading DB to 1.31.17 from 1.31.1

Database successfully upgraded to version 1.31.17.
Upgrading DB to 1.31.18 from 1.31.1

Database successfully upgraded to version 1.31.18.
Upgrading DB to 1.31.19 from 1.31.1
ERROR 1370 (42000) at line 1: alter routine command denied to user 'zmuser'@'localhost' for routine 'zm.update_storage_stats'
Output:
Command 'mysql -hlocalhost -uzmuser -p"zmpass" zm < /usr/share/zoneminder/db/zm_update-1.31.19.sql' exited with status: 1


best regards
Davor
User avatar
iconnor
Posts: 2880
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Upgrade error

Post by iconnor »

echo "grant lock tables,alter,drop,select,insert,update,delete,create,index,alter routine,create routine, trigger,execute on ${ZM_DB_NAME}.* to '${ZM_DB_USER}'@localhost;" | mysql --defaults-file=/etc/mysql/debian.cnf mysql
Locked