ZM doesnt start anymore after update to 1.35.13

[biologisch]

Code: Select all

# systemctl status zoneminder.service
● zoneminder.service - ZoneMinder CCTV recording and surveillance system
     Loaded: loaded (/lib/systemd/system/zoneminder.service; enabled; vendor pr>
     Active: activating (auto-restart) (Result: exit-code) since Thu 2020-11-05>
    Process: 7757 ExecStart=/usr/bin/zmpkg.pl start (code=exited, status=255/EX>
lines 1-4/4 (END)

Code: Select all

# journalctl -xe
Nov 05 13:21:24 postmaster sudo[10976]: pam_unix(sudo:session): session closed >
Nov 05 13:21:24 postmaster systemd[1]: zoneminder.service: Control process exit>
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- An ExecStart= process belonging to unit zoneminder.service has exited.
-- 
-- The process' exit code is 'exited' and its exit status is 255.
Nov 05 13:21:24 postmaster systemd[1]: zoneminder.service: Failed with result '>
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- The unit zoneminder.service has entered the 'failed' state with result 'exit>
Nov 05 13:21:24 postmaster systemd[1]: Failed to start ZoneMinder CCTV recordin>
-- Subject: A start job for unit zoneminder.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- A start job for unit zoneminder.service has finished with a failure.
-- 
-- The job identifier is 2875 and the job result is failed.
lines 2948-2970/2970 (END)

[iconnor]

The update probably failed.

1.35.13 updates triggers which will fail on a lot of people's systems.

On a debian/ubuntu system you need to do:
mysql --defaults-file=/etc/mysql/debian.cnf
set global log_bin_trust_function_creators=1;

Then re-run zmupdate
sudo zmupdate.pl

[biologisch]

Works again and thanks a lot <3

[iconnor]

This will probably happen in 1.35.14 as well.

[dougmccrary]

This will probably happen in 1.35.14 as well.

Is that to say it will probably break it again and the fix will need to be re-applied?

Update: yes.

[homebrewdude]

I need help with this. I am sure I am doing something wrong.

@basement:~$ mysql --defaults-file=/etc/mysql/debian.cnf
mysql: [ERROR] Failed to open required defaults file: /etc/mysql/debian.cnf
mysql: [ERROR] Fatal error in defaults handling. Program aborted!

[dougmccrary]

Try $ sudo -i first.
You need a root (#) prompt, like when you do an install.

[homebrewdude]

That worked!

Try $ sudo -i first.
You need a root (#) prompt, like when you do an install.