Table 'zm.Config' doesn't exist
Posted: Tue Jun 21, 2005 8:33 am
I'm working on my ZM config, and I ran the "perl zmconfig.pl" script and answered all the questions (boy there was a lot of them!). Aftwards as instructed I ran "perl zmconfig.pl -noi", and i get the following output:
Here is my current database layout:
So indeed there is no "zm" database (I configured it to use "zm" as a database, with a user called "zm"). I tried creating the database manually, giving the zm user full perms to it, but then it complains about missing tables:
I'm sure there is a simple fix or something I am doing wrong...any pointers would be much appreciated.
Code: Select all
[root@zoneminder zm-1.21.1]# perl zmconfig.pl -noi
Loading config from 'zmconfig.txt'
Loading config from DB
DBI connect('database=zm;host=localhost','zm',...) failed: Unknown database 'zm' at zmconfig.pl line 1662
Error: unable to load options from database: Unknown database 'zm'
Saving config to 'zmconfig.txt'
Saving config to DB
DBI connect('database=zm;host=localhost','zm',...) failed: Unknown database 'zm' at zmconfig.pl line 1566
Error: unable to save options to database: Unknown database 'zm'
Generating 'src/zm_config_defines.h'
Processing 'zm.conf'
Processing 'src/zm_config.h'
Processing 'web/zm_config.php'
Processing 'scripts/zmdc.pl'
Processing 'scripts/zmwatch.pl'
Processing 'scripts/zmaudit.pl'
Processing 'scripts/zmfilter.pl'
Processing 'scripts/zmtrigger.pl'
Processing 'scripts/zmx10.pl'
Processing 'scripts/zmpkg.pl'
Processing 'scripts/zmupdate.pl'
Processing 'scripts/zmvideo.pl'
Processing 'scripts/zmcontrol-pelco-d.pl'
Processing 'scripts/zmcontrol-pelco-p.pl'
Processing 'scripts/zmcontrol-visca.pl'
Processing 'scripts/zmcontrol-kx-hcm10.pl'
Processing 'scripts/zmcontrol-axis-v2.pl'
Processing 'scripts/zmtrack.pl'
Processing 'scripts/zm'
Processing 'db/zmschema.sql'
Code: Select all
[root@zoneminder zm-1.21.1]# mysql -u zm -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 107 to server version: 4.1.12-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.00 sec)
Code: Select all
[root@zoneminder zm-1.21.1]# perl zmconfig.pl -noi
Loading config from 'zmconfig.txt'
Loading config from DB
DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at zmconfig.pl line 1678.
Can't execute: Table 'zm.Config' doesn't exist at zmconfig.pl line 1678.