database upgrade failure - 1.34.20 from version 1.34.19 [solved]

[JoshZ17]

Trying up upgrade and ran into this.

Code: Select all

Setting up zoneminder (1.34.20-buster1) ...
Detected db service is mariadb.service
Updating permissions

Initiating database upgrade to version 1.34.20 from version 1.34.19

Upgrading database to version 1.34.20
Loading config from DB 230 entries
Saving config to DB 230 entries
Upgrading DB to 1.34.20 from 1.34.19
mysql: unknown variable 'bind-address=0.0.0.0'
Output: 
Command 'mysql -hlocalhost -uzmuser -p'zmpass' zm < /usr/share/zoneminder/db/zm_update-1.34.20.sql' exited with status: 7

Freshening configuration in database
Migratings passwords, if any...
Loading config from DB 230 entries
Saving config to DB 230 entries
Done Updating; starting ZoneMinder.
Job for zoneminder.service failed because the control process exited with error code.
See "systemctl status zoneminder.service" and "journalctl -xe" for details.
Job for zoneminder.service failed because the control process exited with error code.
See "systemctl status zoneminder.service" and "journalctl -xe" for details.
invoke-rc.d: initscript zoneminder, action "start" failed.
● zoneminder.service - ZoneMinder CCTV recording and surveillance system
   Loaded: loaded (/lib/systemd/system/zoneminder.service; enabled; vendor preset: enabled)
   Active: activating (auto-restart) (Result: exit-code) since Sat 2020-09-05 14:16:13 PDT; 6ms ago
  Process: 4068 ExecStart=/usr/bin/zmpkg.pl start (code=exited, status=255/EXCEPTION)
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)

So i ran zmupdate.pl and got this result.

Code: Select all

Setting up zoneminder (1.34.20-buster1) ...
Detected db service is mariadb.service
Updating permissions

Initiating database upgrade to version 1.34.20 from version 1.34.19

Upgrading database to version 1.34.20
Loading config from DB 230 entries
Saving config to DB 230 entries
Upgrading DB to 1.34.20 from 1.34.19
mysql: unknown variable 'bind-address=0.0.0.0'
Output: 
Command 'mysql -hlocalhost -uzmuser -p'zmpass' zm < /usr/share/zoneminder/db/zm_update-1.34.20.sql' exited with status: 7

Freshening configuration in database
Migratings passwords, if any...
Loading config from DB 230 entries
Saving config to DB 230 entries
Done Updating; starting ZoneMinder.
Job for zoneminder.service failed because the control process exited with error code.
See "systemctl status zoneminder.service" and "journalctl -xe" for details.
Job for zoneminder.service failed because the control process exited with error code.
See "systemctl status zoneminder.service" and "journalctl -xe" for details.
invoke-rc.d: initscript zoneminder, action "start" failed.
● zoneminder.service - ZoneMinder CCTV recording and surveillance system
   Loaded: loaded (/lib/systemd/system/zoneminder.service; enabled; vendor preset: enabled)
   Active: activating (auto-restart) (Result: exit-code) since Sat 2020-09-05 14:16:13 PDT; 6ms ago
  Process: 4068 ExecStart=/usr/bin/zmpkg.pl start (code=exited, status=255/EXCEPTION)
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)

And now I am stumped. Any ideas?

[Magic919]

Not sure where this bit comes from - mysql: unknown variable 'bind-address=0.0.0.0'

I'd try running the zmupdate.pl and feed it a suitable user and password for the database. See if that helps.

[JoshZ17]

I was thinking it was something with the 'bind-address=0.0.0.0', but didn't know what to do with that.

I ended up going to etc/mysql/my.conf and there in the configuration file was

Code: Select all

bind-address   = 0.0.0.0

I commented it out saved and ran zmupdate.pl again this time to success.

Code: Select all

Upgrading database to version 1.34.20
Loading config from DB 230 entries
Saving config to DB 230 entries
Upgrading DB to 1.34.20 from 1.34.19

Database successfully upgraded to version 1.34.20.

Everything is working again.

Thanks