Problem updating the mysql database from web frontend
Posted: Tue Jun 22, 2004 10:56 am
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?
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?