Page 1 of 1

Problem updating the mysql database from web frontend

Posted: Tue Jun 22, 2004 10:56 am
by nugget
I have a problem after recently upgrading ZM from 0.9.15 to 1.19.4. Zoneminder is running on RH9. Mysql version is 3.23.58

After upgrading any addition/alteration I try to do to the mysql database doesn't get written to the db. For instance, I can add a new motion zone to a monitor, but no corresponding db record is written to the Zones table. Any update I try to make to a zone (eg changing the name, dimensions, type of zone, ...) also aren't written back to the db.

Capture daemon is quite happily able to write records into the database when an event occurs - I can query the Events table and see new events being logged.

No error messages appear in any log file.

I originally thought the problem was an incorrect username/password supplied when I ran zmconfig.pl, however I've checked zmconfig.txt against the previous version and everything checks out OK. I can log into the db using the mysql command line by supplying the privileged and non-privileged username/password strings.

I ran the zmalter*.sql scripts in the db directory to update the database table structures. Is there anything else I had to do?

Some more info:

Posted: Tue Jun 22, 2004 11:11 am
by nugget
More info:

Any addition/edit/delete I make to a monitor zone logs the following messages in /var/log/messages:

Jun 22 21:04:52 server zma-m10[6738]: INF [Got signal (Terminated), exiting]
Jun 22 21:04:53 server zma-m10[6768]: INF [Debug Level = 0, Debug Log = ]
Jun 22 21:04:53 server zma-m10[6768]: INF [Warming up]
Jun 22 21:04:53 server zma-m10[6768]: INF [FrontDoor: 026 - Gone into alarm stat
e]

Can't see thatthis is terribly helpful, does the zma daemon terminate and restart each time a zone is updated?

Posted: Wed Jun 23, 2004 9:30 pm
by zoneminder
It might be worth check the web error logs if it's the web interface that you're having trouble with. See if there's anything in there that might flag an error.

Phil,

I feel like an idiot...

Posted: Thu Jul 22, 2004 7:16 am
by nugget
For completeness of this post, here's the answer:

Turn on "CHECK FOR NEW VERSIONS OF STORED WEB PAGES EVERY VISIT" in Internet Explorer. :oops:

My ZM host is a headless PC squirreled away in the house, I manage it by connecting from my Win XP machine via IE. I think I must have updated IE and reset the above setting. I open a prevously visited config page, and the cached configuration settings are loaded.

Any chance in considering forcing a reload of the configuration pages every time they're opened, in future releases.

Due to my own stupidity, I ended up completely rebuilding my ZM machine. A lot of work and heartache, but I learned a lot about RedHat and ZM in the process.

Phil, thanks for Zone Minder - it's an excellent product with great potential.