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?
Problem updating the mysql database from web frontend
Some more info:
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?
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?
- zoneminder
- Site Admin
- Posts: 5215
- Joined: Wed Jul 09, 2003 2:07 pm
- Location: Bristol, UK
- Contact:
I feel like an idiot...
For completeness of this post, here's the answer:
Turn on "CHECK FOR NEW VERSIONS OF STORED WEB PAGES EVERY VISIT" in Internet Explorer.
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.
Turn on "CHECK FOR NEW VERSIONS OF STORED WEB PAGES EVERY VISIT" in Internet Explorer.
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.