ZoneMinder won't start on CentOS 6.3

[scjgreen]

Hi
Forgive me i'm a complete novice at ZoneMinder however i have a server running CentOS 6.3 which i've been trying to get ZM to run on.

Code: Select all

[root@localhost LambNet]# service zm start
ERROR 1146 (42S02) at line 1: Table 'zm.Config' doesn't exist
Starting ZoneMinder: DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at /usr/local/share/perl5/ZoneMinder/Config.pm line 92.
Can't execute: Table 'zm.Config' doesn't exist at /usr/local/share/perl5/ZoneMinder/Config.pm line 100
BEGIN failed--compilation aborted at /usr/local/share/perl5/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/local/share/perl5/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/local/share/perl5/ZoneMinder.pm line 33.
Compilation failed in require at /usr/local/bin/zmpkg.pl line 37.
BEGIN failed--compilation aborted at /usr/local/bin/zmpkg.pl line 37.
                                                           [FAILED]

If anyone could help i'd greatly appreciate it.

Thanks
Steve

[PacoLM]

Are you sure that the database has been created?. Install phpmyadmin and check that the database (zm) is there.

[scjgreen]

Paco i've installed phpmyadmin

The database zm is there but no tables within. Is this right?

Thanks

[scjgreen]

Anyone help?

[PacoLM]

Hi,

Have you installed the zoneminder from repositories or compiled yourself?
Anyway, download and extract the attached file and run the following commands in order to create the database for ZM1.25:

Code: Select all

#create db
mysqladmin -u root -p -f drop zm
mysql -u root -p < db/zm_create.sql
#Password that is requested is Mysql root password that was entered during install, not your debian password.
mysql -u root -p
grant select,insert,update,delete on zm.* to 'zmuser'@localhost identified by 'zmpass';
quit
mysqladmin -p reload

Don't forget to change 'zmuser' and 'zmpass' according to your settings.

Hope it helps,

PacoLM

[scjgreen]

Hi,

Have you installed the zoneminder from repositories or compiled yourself?
Anyway, download and extract the attached file and run the following commands in order to create the database for ZM1.25:

Code: Select all

#create db
mysqladmin -u root -p -f drop zm
mysql -u root -p < db/zm_create.sql
#Password that is requested is Mysql root password that was entered during install, not your debian password.
mysql -u root -p
grant select,insert,update,delete on zm.* to 'zmuser'@localhost identified by 'zmpass';
quit
mysqladmin -p reload

Don't forget to change 'zmuser' and 'zmpass' according to your settings.

Hope it helps,

PacoLM

Paco

Thank you so much for your help, wasn't quite as easy as your post made it look but i got their in the end

Just trying to figure out how to secure Zoneminder now

[PacoLM]

Congratulations!

[scjgreen]

Just one more question Paco

When i'm setting up Zones it doesn't show the picture from the camera, just a placeholder like the image is missing?

If i right click and open image in new tab it is trying to open

Code: Select all

/var/www/html/zm/video/Zones12.jpg

If i open the image directly using url it shows up fine but Zoneminder cannot see it.

[PacoLM]

In my debian system, the zones image directory is :

/var/www/zm/images

Check the permissions of the directory, in my system they belong to www-data:www-data

Hope it helps,

PacoLM

[PacoLM]

In my debian system, the zones image directory is :

/var/www/zm/images

Check the permissions of the directory, in my system they belong to www-data:www-data

Hope it helps,

PacoLM