Page 1 of 1
probs starting zoneminder
Posted: Mon Mar 06, 2006 3:10 pm
by thoweiss
Hello everybody,
i have installed zoneminder 1.22.0 on Debian sarge (latest net-inst version)
everything seems to be ok, but when i try to execute zmpkg.pl start i get the following errors:
Code: Select all
DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at /usr/local/share/perl/5.8.4/ZoneMinder/Config.pm line 91.
Can't execute: Table 'zm.Config' doesn't exist at /usr/local/share/perl/5.8.4/ZoneMinder/Config.pm line 99
BEGIN failed--compilation aborted at /usr/local/share/perl/5.8.4/ZoneMinder/Config.pm line 99.
Compilation failed in require at /usr/local/share/perl/5.8.4/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/local/share/perl/5.8.4/ZoneMinder.pm line 33.
Compilation failed in require at /usr/local/bin/zmpkg.pl line 45.
BEGIN failed--compilation aborted at /usr/local/bin/zmpkg.pl line 45.
i can't find the zm.Config file.
Thank you for your help,
and excuse me for my bad englisch because i'm from Germany.
Posted: Mon Mar 06, 2006 4:38 pm
by cordel
Check and make sure you have the database setup correctly.
You must create the data base as discribed in the manual.
User Manual wrote:mysql mysql < db/zm_create.sql
mysql mysql
grant select,insert,update,delete on <database name>.* to '<database user>'@localhost identified by '<database password>';
quit
mysqladmin reload
Check that the database is running.
You can check to see if the database is there by doing the following:
Code: Select all
mysql <database name>
describe Config;
exit
That should return the Config table structure if the database is there.
If it does exist, then check that you set the correct information in /etc/zm.conf .
Regards,
Corey
Posted: Mon Mar 06, 2006 7:24 pm
by thoweiss
Hello Cordel,
i have tried to set up the database as you described, but i have got only a error:
Code: Select all
mysql> mysql < db/zm_create.sql mysql mysql grant select,insert,update,delete on <zm>.* to '<zoneminder>'@localhost identified by '<zone>';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql < db/zm_create.sql mysql mysql grant select,insert,update,delete on <zm>' at line 1
I've also tried to setup the database with phpmyadmin,
and set up a database with name zm, user zoneminder and password zone and set the zm.cnf accordind to the parameters....
I'm using : MySQL 4.1.11-Debian_4sarge2-log
any ideas??
Regards,
Thorsten
Posted: Mon Mar 06, 2006 7:47 pm
by thoweiss
oohhh...
I'm so silly....
i have used the false MYsql Databasename in the command
it schoul be mysql
zm < db/zm_create.sql -u zoneminder -p
Thank you for your help,
the problem almost sits in front of the computer..
See you,
Thorsten.
Posted: Tue Mar 07, 2006 11:09 pm
by zoneminder
Yes, and the angle brackets (<>) in the grant command just indicate things you should change so don't type <zm> just zm for instance.