Problem updating the mysql database from web frontend

Support and queries relating to all previous versions of ZoneMinder
Locked
User avatar
nugget
Posts: 42
Joined: Mon Dec 08, 2003 7:52 pm
Location: Sydney, Australia
Contact:

Problem updating the mysql database from web frontend

Post 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?
User avatar
nugget
Posts: 42
Joined: Mon Dec 08, 2003 7:52 pm
Location: Sydney, Australia
Contact:

Some more info:

Post 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?
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Post 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,
User avatar
nugget
Posts: 42
Joined: Mon Dec 08, 2003 7:52 pm
Location: Sydney, Australia
Contact:

I feel like an idiot...

Post 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.
Locked