Page 1 of 1
Events records disappeared
Posted: Wed Nov 04, 2020 11:49 pm
by stonygate
I have zoneminder installed under ubuntu server 20.10.
I have a problem with the registration methods.
Any mode used to record videos after a few moments are automatically removed.
To check that the videos are missing, I pointed the directory to an external disk, instead there are all the frames taken!
Can you help me?
Re: Events records disappeared
Posted: Mon Nov 09, 2020 5:06 pm
by burger
Events are handled by db, and on filesystem. If events are not on the filesystem (say you have incorrect hdd permissions) then they will not be accessible, but may show up in db. If events are not on db, but are on filesystem it could be a db issue. Check logs.
Any events that are not found on the filesystem will be deleted from db by zmaudit.pl when it runs. There are two ways zmaudit.pl can be run in options. I forget exactly what the difference is, but something to be aware of. The defaults are fine for most users.
And Ubuntu 20 has had some conflicting install talk on this forum. Some people have issues with it... Make sure you installed correctly. Buster doesn't have any such issues.
Re: Events records disappeared
Posted: Mon Nov 09, 2020 5:44 pm
by stonygate
hi, this is a log:
Code: Select all
SQL-ERR dbFetchAll no result, statement was 'SELECT `Id`, `MonitorId`, `Name`, `Cause`, `Notes`, `StartDateTime`, date_format( StartDateTime, '%y/%m/%d %H:%i:%S' ) as StartTimeShort, `EndTime`, `Width`, `Height`, `Length`, `Frames`, `AlarmFrames`, `TotScore`, `AvgScore`, `MaxScore` FROM Events WHERE Events.MonitorId = :selector0 ORDER BY Id DESC limit 20'params: 1
Can is usefull?
Re: Events records disappeared
Posted: Tue Nov 10, 2020 3:59 am
by burger
Ok, it looks like the query is failing. Have you tried any more troubleshooting to track down why that query failed?
Does the ZM db and the table its referencing exist per the query?
https://wiki.zoneminder.com/MySQL Recreate db if necessary. Upgrade it if necessary.
Re: Events records disappeared
Posted: Thu Nov 12, 2020 5:37 pm
by stonygate
I have removed and reinstalled zoneminder to the latest version, including the database.
Unfortunately the problem still exists!
Re: Events records disappeared
Posted: Thu Nov 12, 2020 9:51 pm
by burger
Are you sure you removed the DB? Just uninstall ZM via apt-get might not remove the DB.
Regardless, you didn't specify which installation guide you followed. A common problem is that users did not install correctly or used an unsupported OS (for some reason, lots of folks want to use proprietary unraid, for example). I'd recommend
https://wiki.zoneminder.com/Ubuntu
and
https://wiki.zoneminder.com/Ubuntu_Serv ... der_1.34.x
20.10 is not on that list so, unless you know what you are doing, you should use 20.04 or 18.04.
Re: Events records disappeared
Posted: Fri Nov 13, 2020 6:38 pm
by stonygate
hi and tnxs for you answers.
This is the guide i used to remove it
viewtopic.php?t=26129
To install it again I used this
https://wiki.zoneminder.com/How_to_Inst ... l_Fossa%29
Only the part concerning mysql I deliberately skipped;
Code: Select all
rm /etc/mysql/my.cnf
cp /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/my.cnf
since I use mariadb already configured for other functions.
This is version of my ubuntu:
Code: Select all
lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 20.04.1 LTS
Release: 20.04
Codename: focal
Re: Events records disappeared
Posted: Sat Nov 14, 2020 3:07 am
by burger