[support] dlandon - Zoneminder 1.36


Recommended Posts

This is my favorite unraid docker container and I don't mind rebuilding it but would like to prevent others from likely corruption as it's not obvious.  Is there anything in your build process with the new template to prevent people from stumbling into this issue? Meaning they need to set the previous shm value into the new template before the upgrade will even start?

Link to comment
1 minute ago, dlandon said:

That would be best.

 

Through unraid ui how does that happen given the template change? I saw the update available in the Unraid UI and updated the container.  That's how easy it is to stumble into this issue (assuming improper shm size in template led to db corruption).

Link to comment
1 hour ago, dlandon said:

Those of you with database issues, it may be due to you restarting the docker and updating Zoneminder in the process.  Zoneminder will get updated whenever the docker is restarted if there is a new version of Zoneminder.  Part of the update to Zoeminder is an update to the database.  If that failed because of the issues with shared memory, the database may have gotten corrupted.

Yes, this is what I figured happened to me too.  I got a clean install up and running, but notifications are broken.  Eager to hear if others are successful or not getting these going.

Link to comment
Just now, hbrob said:

Yes, this is what I figured happened to me too.  I got a clean install up and running, but notifications are broken.  Eager to hear if others are successful or not getting these going.

ES has been updated to 6.1.5.  You probably need to make some changes for the newer version.

Link to comment
1 hour ago, dlandon said:

You don't have a backup to recover?

I do, I tried restoring my settings to the new install and removing the DB which was corrupted (this was one of my first actions).  ES hooks did not work.  I may try this again tomorrow.

 

 

Edited by hbrob
Link to comment

Just found ES updated after restarted container, and notification stopped working. Realized some changes made in the new ES to use ml_sequence, so updated the objectconfig.ini according to the doc, but still couldn't get it working, from the log console, below is the message I got, no idea where it was generated. And even reverted back to the legacy detection method (use_sequence = no), still had the same error, anybody seeing the same issue?

 

01/03/21 22:12:49 zmesdetect_m4[3648] FAT zm_detect.py:534 [Unrecoverable error:'ml_sequence' Traceback:Traceback (most recent call last):
  File "/var/lib/zmeventnotification/bin/zm_detect.py", line 531, in <module>
    main_handler()
  File "/var/lib/zmeventnotification/bin/zm_detect.py", line 295, in main_handler
    if g.config['ml_sequence'] and g.config['use_sequence'] == 'yes':
KeyError: 'ml_sequence'
]
 

Link to comment

Also pressed on "update" last night thinking...what could happen.

This morning nothing was running ;) Once again a lesson for me to check changes before updating...

I also have issues with the included mysql database not working.
See attached logs at the bottom for further datapoints.

 

Also does opencv need to be compiled every restart of the container? I have a pretty poor cpu and no gpu and the compile takes ages.

I fear having to tweak the new mem settings when each restart with a config change takes 40+ minutes...

Compiling opencv - this will take a while...
Jan 4 07:57:14 17b93c0e5743 EventServer: Compiling opencv without GPU Support
Jan 4 07:57:35 17b93c0e5743 EventServer: Compiling opencv...
Jan 4 08:42:17 17b93c0e5743 EventServer: Installing opencv...
Jan 4 08:42:17 17b93c0e5743 EventServer: Installing opencv...
Jan 4 08:42:21 17b93c0e5743 EventServer: Cleaning up...

Error Logs:

Jan 4 08:42:21 17b93c0e5743 EventServer: Cleaning up...
Starting services...
* Starting Apache httpd web server apache2
Jan 4 08:42:23 17b93c0e5743 web_php[19213]: FAT [Failed db connection to ]
Jan 4 08:42:23 17b93c0e5743 web_php[19213]: ERR [Unable to authenticate user. error decoding JWT token:Signature verification failed]
Jan 4 08:42:23 17b93c0e5743 web_php[19213]: ERR [Unable to authenticate user. error decoding JWT token:Signature verification failed]
Jan 4 08:42:23 17b93c0e5743 web_php[19214]: FAT [Failed db connection to ]
Jan 4 08:42:23 17b93c0e5743 web_php[19215]: FAT [Failed db connection to ]
Jan 4 08:42:23 17b93c0e5743 web_php[19216]: FAT [Failed db connection to ]
Jan 4 08:42:23 17b93c0e5743 web_php[19217]: FAT [Failed db connection to ]
Jan 4 08:42:23 17b93c0e5743 web_php[19217]: ERR [Unable to authenticate user. error decoding JWT token:Signature verification failed]
Jan 4 08:42:23 17b93c0e5743 web_php[19217]: ERR [Unable to authenticate user. error decoding JWT token:Signature verification failed]
Jan 4 08:42:23 17b93c0e5743 web_php[19213]: FAT [Failed db connection to ]
Jan 4 08:42:23 17b93c0e5743 web_php[19214]: FAT [Failed db connection to ]
Jan 4 08:42:23 17b93c0e5743 web_php[19215]: FAT [Failed db connection to ]
*
* Starting MariaDB database server mysqld
Jan 4 08:42:40 17b93c0e5743 web_php[19216]: FAT [Failed db connection to ]
Jan 4 08:42:40 17b93c0e5743 web_php[19216]: ERR [Unable to authenticate user. error decoding JWT token:Signature verification failed]
Jan 4 08:42:40 17b93c0e5743 web_php[19216]: ERR [Unable to authenticate user. error decoding JWT token:Signature verification failed]
Jan 4 08:42:40 17b93c0e5743 web_php[19217]: FAT [Failed db connection to ]
Jan 4 08:42:40 17b93c0e5743 web_php[19213]: FAT [Failed db connection to ]
Jan 4 08:42:40 17b93c0e5743 web_php[19214]: FAT [Failed db connection to ]

#
# This happens quite a few times
# Redacted for better readability

Jan 4 08:42:53 17b93c0e5743 web_php[19215]: FAT [Failed db connection to ]
Jan 4 08:42:53 17b93c0e5743 web_php[19216]: FAT [Failed db connection to ]
...fail!
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
Jan 4 08:42:54 17b93c0e5743 zmupdate[19654]: ERR [Error reconnecting to db: errstr:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) error val:]
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
Can't call method "prepare_cached" on an undefined value at /usr/share/perl5/ZoneMinder/Config.pm line 96.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm line 147.
Compilation failed in require at /usr/bin/zmupdate.pl line 73.
BEGIN failed--compilation aborted at /usr/bin/zmupdate.pl line 73.
Jan 4 08:42:54 17b93c0e5743 zmupdate[19654]: ERR [Error reconnecting to db: errstr:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) error val:]
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
Jan 4 08:42:54 17b93c0e5743 zmupdate[19655]: ERR [Error reconnecting to db: errstr:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) error val:]
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
Can't call method "prepare_cached" on an undefined value at /usr/share/perl5/ZoneMinder/Config.pm line 96.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm line 147.
Compilation failed in require at /usr/bin/zmupdate.pl line 73.
BEGIN failed--compilation aborted at /usr/bin/zmupdate.pl line 73.
Jan 4 08:42:54 17b93c0e5743 zmupdate[19655]: ERR [Error reconnecting to db: errstr:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) error val:]
Starting ZoneMinder:
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
Jan 4 08:42:54 17b93c0e5743 zmpkg[19665]: ERR [Error reconnecting to db: errstr:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) error val:]
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
Can't call method "prepare_cached" on an undefined value at /usr/share/perl5/ZoneMinder/Config.pm line 96.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm line 147.
Compilation failed in require at /usr/share/perl5/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder.pm line 33.
Compilation failed in require at /usr/bin/zmpkg.pl line 34.
BEGIN failed--compilation aborted at /usr/bin/zmpkg.pl line 34.
Jan 4 08:42:54 17b93c0e5743 zmpkg[19665]: ERR [Error reconnecting to db: errstr:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) error val:]
ZoneMinder failed to start

*** /etc/my_init.d/40_firstrun.sh failed with status 255

 

Edited by sillywalks
Link to comment

Hi,

 

I had issue with db so I ended up restarting from scratch.

 

Now I wanted to make things better so I tried to change DB from int to ext ( I have a mariadb container).

 

So I followed this according to @dlandon :

 

Quote

Change Databases: You can change to an external database by overwriting the default zm.config database settings.  Change the following settings for your particular needs and put them in the file "99-mysql.conf' in the /appdata/Zoneminder/conf/ folder.  Your settings will be installed when the docker is started.

 

I changed only ZM_DB_HOST to my db istance 192.168.2.100:3306.

 

I don't find any  "99-mysql.conf' in the /appdata/Zoneminder/conf/ folder.  Something has changed?

Link to comment
7 hours ago, Jokerigno said:

Hi,

 

I had issue with db so I ended up restarting from scratch.

 

Now I wanted to make things better so I tried to change DB from int to ext ( I have a mariadb container).

 

So I followed this according to @dlandon :

 

 

I changed only ZM_DB_HOST to my db istance 192.168.2.100:3306.

 

I don't find any  "99-mysql.conf' in the /appdata/Zoneminder/conf/ folder.  Something has changed?

I think this got broken over the last few changes.  I'll take a look and update the docker if necessary.

Link to comment
7 hours ago, Jokerigno said:

Hi,

 

I had issue with db so I ended up restarting from scratch.

 

Now I wanted to make things better so I tried to change DB from int to ext ( I have a mariadb container).

 

So I followed this according to @dlandon :

 

 

I changed only ZM_DB_HOST to my db istance 192.168.2.100:3306.

 

I don't find any  "99-mysql.conf' in the /appdata/Zoneminder/conf/ folder.  Something has changed?

Building a new docker with a fix.  You create the 99-mysql.conf from the zm.default file in the appdata/conf/ folder.  The file actually gets copied to /etc/zm/conf.d/ inside the container.

Link to comment
55 minutes ago, repomanz said:

I'm trying to figure this one out after rebuilding the container from scratch.  Anyone here know what this may be about?

 

|----> FORK:garage-low-res (1), eid:96 Not sending event end alarm, as we did not send a start alarm for this, or start hook processing failed

 

 

That's a message from hook processing.  I normally turn this off in the zmeventnotification.ini file, but it was left on and causes that message:
 

# send event end notifications (default: no)
# Note that if you are using hooks for end notifications, they may change
# the final decision. This needs to be yes if you want end notifications with 
# or without hooks
send_event_end_notification = no

Be sure it's set to no.  For some reason pliablepixels sets it to yes in the ES release.

Link to comment
39 minutes ago, dlandon said:

That's a message from hook processing.  I normally turn this off in the zmeventnotification.ini file, but it was left on and causes that message:
 


# send event end notifications (default: no)
# Note that if you are using hooks for end notifications, they may change
# the final decision. This needs to be yes if you want end notifications with 
# or without hooks
send_event_end_notification = no

Be sure it's set to no.  For some reason pliablepixels sets it to yes in the ES release.

 

I think something else is going on.  For example, my monitor picked up motion and recorded it but I don't see anything in the log ui for zmdetect.  Any pointers here?

Link to comment

Just an FYI I noticed that the log file limitations that were in place have gone away from the template.

Extra Parameters: --log-opt max-file=1 --log-out max-size=50m

I know it probably junked up/confused the field that users would be adjusting the shared mem, but zoneminder will probably make some huge log files given the chance.

 

Also a PSA, I recommend users add a cpu usage limit to the container, specifically when using object detect because of the opencv compile, which can lock up your server when it uses 100% CPU to compile.  I'd recommend N-2 at most, where N is your cpu's threads so you leave 2 threads for all your other stuff to run on while ZM compiles.  The number can be a float so fraction of threads is allowed.

 

Extra Parameters: --cpus=X.X
Link to comment
3 minutes ago, ThreeFN said:

Just an FYI I noticed that the log file limitations that were in place have gone away from the template.


Extra Parameters: --log-opt max-file=1 --log-out max-size=50m

I know it probably junked up/confused the field that users would be adjusting the shared mem, but zoneminder will probably make some huge log files given the chance.

 

Also a PSA, I recommend users add a cpu usage limit to the container, specifically when using object detect because of the opencv compile, which can lock up your server when it uses 100% CPU to compile.  I'd recommend N-2 at most, where N is your cpu's threads so you leave 2 threads for all your other stuff to run on while ZM compiles.  The number can be a float so fraction of threads is allowed.

 


Extra Parameters: --cpus=X.X

I use those myself.  Are you saying the switches are no longer applicable given the new template?

Link to comment
2 minutes ago, dlandon said:

Log stuff is no longer needed.  Go to Docker settings, stop dockers and you'll see:

Docker.png.94e62d2dc4148e00fdf10821bfe5bf47.png

Ah, good to know, thanks for that, completely missed it.

 

Then yes it's probably good it's gone as it frees up space a reduces confusion in the extra parameters field.

Link to comment
1 hour ago, repomanz said:

going to restore a zoneminder folder from a previous backup, this time using shm 16g.  wish me luck

 

quick update.  To test out the shm issue corrupting db I restored an older zoneminder folder and installed again.  The upgrade did work.  What isn't working post upgrade is object detection / event server related stuff.  This was working per the previous zoneminder version (pre template change)

Is this what others have experienced? Do you know what the issue is?

Edited by repomanz
Link to comment
  • dlandon changed the title to [support] dlandon - Zoneminder 1.36

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.