ZoneMinder Forums

Code: Select all

# dpkg --configure zoneminder
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
ERROR 1142 (42000) at line 10: CREATE command denied to user 'zmuser'@'localhost' for table 'Logs'
Output: 
Command 'mysql -hlocalhost -uzmuser -pzmpass zm < /usr/share/zoneminder/db/zm_update-1.24.4.sql' exited with status: 1
dpkg: error processing zoneminder (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 zoneminder
#

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

$