Woke up to zoneminder not working with these errors in log

Previous development branch now released as 1.36
Locked
homebrewdude
Posts: 54
Joined: Mon Aug 26, 2019 12:42 pm

Woke up to zoneminder not working with these errors in log

Post by homebrewdude »

2021-04-18 08:29:11 zmdc 1227 ERR 'zmc -m 9' exited abnormally, exit status 255 zmdc.pl -
2021-04-18 08:29:11 zmc_m9 4852 ERR Can't run query: Unknown column 'Importance' in 'field list'


Worked fine last night. Didn't do any updates or anything that I know of.

1.35.26
User avatar
iconnor
Posts: 2862
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Woke up to zoneminder not working with these errors in log

Post by iconnor »

For some reason the 1.35.25 db update hasn't happened. That column was added there.

mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.35.25.sql
homebrewdude
Posts: 54
Joined: Mon Aug 26, 2019 12:42 pm

Re: Woke up to zoneminder not working with these errors in log

Post by homebrewdude »

It tried to update today.
This is the error



Initiating database upgrade to version 1.35.26 from version 1.35.23

Upgrading database to version 1.35.26
Loading config from DB 220 entries
Saving config to DB 220 entries
Upgrading DB to 1.35.24 from 1.35.23
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1419 (HY000) at line 4 in file: '/usr/share/zoneminder/db/triggers.sql': You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
Output: This update may make changes that require SUPER privileges. If you see an error message saying:

ERROR 1419 (HY000) at line 298: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_functio
This update may make changes that require SUPER privileges. If you see an error message saying:\n\nERROR 1419 (HY000) at line 298: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)\n\nYou will have to either run this update as root manually using something like (on ubuntu/debian)\n\nsudo mysql --defaults-file=/etc/mysql/debian.cnf zm < /usr/share/zoneminder/db/zm_update-1.35.24.sql\n\nOR\n\nsudo mysql --defaults-file=/etc/mysql/debian.cnf "set global log_bin_trust_function_creators=1;"\nsudo zmupdate.pl\n\nOR\n\nTurn off binary logging in your mysql server by adding this to your mysql config.\n[mysqld]\nskip-log-bin\n\n
Event_Summaries Already exists
Event_Summaries Already exists
Command 'mysql -hlocalhost -uzmuser -p'zmpass' zm < /usr/share/zoneminder/db/zm_update-1.35.24.sql' exited with status: 1
Error updating db.
dpkg: error processing package zoneminder (--configure):
installed zoneminder package post-installation script subprocess returned error exit status 1
Errors were encountered while processing:
zoneminder
E: Sub-process /usr/bin/dpkg returned an error code (1)
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Woke up to zoneminder not working with these errors in log

Post by Magic919 »

You either run zmupdate as a more powerful DB user, or turn off binary logging. (As it states in the text you posted)
-
Locked