probs starting zoneminder

[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.

[cordel]

Check and make sure you have the database setup correctly.
You must create the data base as discribed in the manual.

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

[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

[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.

[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.