ZoneMinder Forums

Let me start by saying that I HAD Zoneminder working fine (although it is still filling my hard drive with events).

I moved a camera, and deleted all my zones. Now that Im starting over, when I create a new zone it creates a zone of type "ActivePixels". Here is what I get as a default new zone:




I change the settings to:




which looks like this:



but I am never able to get Zoneminder to alarm and create an event now. I've tried setting the threshold to 0,0 and changed the Minimum alarm area to small numbers (3) and large and had no success.

Any suggestions?

-=STZ=-

My Zoneminder installation seems to be imploding. This morning I woke up to find this error when I boot up the ZM console:

Can't open file: 'Events.MYI'. (errno: 145)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/localhost/htdocs/zm/zm_html_view_console.php on line 72
Can't open file: 'Events.MYI'. (errno: 145)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/localhost/htdocs/zm/zm_html_view_console.php on line 72

Checking my phpMyAdmin shows that the "Stats", "Events", and "Frames" tables are all "In Use". Rebooting my machine, restarting mySQL and ZoneMinder make no difference. I'm assuming that means I've got a corrupt database. Can someone tell me how to correct this? I'm no MySQL expert, but I'd imagine I could delete the database, and reload the "zmschema.sql" file.

Thank god I have this phpMyAdmin, I haven't been able to get MySQL working from the command line, but I am able to send SQL commands through the phpMyAdmin HTML interface. My first troubleshooting step (unless I hear better steps from someone here) will be to just delete the database and send the "zmschema.sql" command to re-initalize a clean database.

Hi,
to repair the database try
replace password with your mysql adminpassword and user with your mysqladminuser ( normally root )


Regards, Rainer

Thanks RMO, that did the trick!

However, I'm still having the problem that I cannot seem to get the motion detection working. It was working fine for like 2 weeks...then then I moved one of my cameras...both cameras stopped detecting motion.

-=STZ=-

What zone settings do you have at the moment?

Phil

out of interest i had the mysql error listed above and the repair fixed mine too, This happened after a power failure and a system shutdown. Could this repair be run even if anything wasnt wrong ie every boot and say once a week???

James

Yes it could.

ok then next question how?? lol
I assume i use this cron thing

JAmes

I put it in the startup script for mysql.
mysqlcheck --all-databases --auto-repair

I believe that Ross has already done the same thing and is part of the liveCD.
Regards,
Cordel

i left my box running all day in hope it would just fix itself but it didnt do we know the frequency it does this (im using the new torrent live cd

As part of the startup script it would only do this at boot time or upon mysql restart.

i dont think it is yet maybe ross could correct me as it didnt repair on boot up. I only ran this command when my event list on the console started showing php errors. When i ran this command it sorted the databse out. I assume if the db is huge this could take a while. Maybe thats why its not there at start up. If it was there where would it be. Im used to old windows having an autoexec etc that loaded things at boot. Whats linux startup file called??

James

Maybe he forgot to put it in the newer CD. It was in the 1.19 version