the code below seems to have helped, but i still got these errors:
Stopping ZoneMinder: DBD::mysql::st execute failed: Table 'zm.Logs' doesn't exist at /usr/share/perl5/ZoneMinder/Logger.pm line 609.
and
Converting filters from PHP to JSON format
PurgeWhenFull - failed
but ZM is running now at least and the PurgeWhenFull filter is still there...
are there more things i need to fix?
Code: Select all
$ sudo mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 151
Server version: 5.5.38-0ubuntu0.12.04.1 (Ubuntu)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use zm
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show grants for 'zmuser'@'localhost';
+---------------------------------------------------------------------------------------------------------------+
| Grants for zmuser@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'zmuser'@'localhost' IDENTIFIED BY PASSWORD '*X' |
| GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, LOCK TABLES ON `zm`.* TO 'zmuser'@'localhost' |
+---------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> grant create on * to 'zmuser'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for 'zmuser'@'localhost';
+---------------------------------------------------------------------------------------------------------------+
| Grants for zmuser@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'zmuser'@'localhost' IDENTIFIED BY PASSWORD '*X' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, LOCK TABLES ON `zm`.* TO 'zmuser'@'localhost' |
+---------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> exit
Bye
$ sudo apt-get install zoneminder
Reading package lists... Done
Building dependency tree
Reading state information... Done
zoneminder is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 53 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue [Y/n]?
Setting up zoneminder (1.25.0-1) ...
Stopping ZoneMinder: DBD::mysql::st execute failed: Table 'zm.Logs' doesn't exist at /usr/share/perl5/ZoneMinder/Logger.pm line 609.
Zoneminder already stopped
Initiating database upgrade to version 1.25.0 from version 1.24.2
Upgrading database to version 1.25.0
Loading config from DB
Saving config to DB
Database successfully upgraded from version 1.24.2.
Database successfully upgraded from version 1.24.3.
Converting filters from PHP to JSON format
PurgeWhenFull - failed, please check or report. Query is '{"sort_field":"Id","terms":[{"val":0,"attr":"Archived","op":"="},{"cnj":"and","val":95,"attr":"DiskPercent","op":">="}],"limit":5,"sort_asc":1}'
ERROR: Unknown type {. at /usr/bin/zmupdate.pl line 930
Conversion complete
Database successfully upgraded from version 1.24.4.
Database upgrade to version 1.25.0 successful.
Starting ZoneMinder: success
$