Page 1 of 1
ZoneMinder won't start on CentOS 6.3
Posted: Fri Oct 26, 2012 12:36 pm
by 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
Re: ZoneMinder won't start on CentOS 6.3
Posted: Fri Oct 26, 2012 3:45 pm
by PacoLM
Are you sure that the database has been created?. Install phpmyadmin and check that the database (zm) is there.
Re: ZoneMinder won't start on CentOS 6.3
Posted: Fri Oct 26, 2012 4:23 pm
by scjgreen
Paco i've installed phpmyadmin
The database zm is there but no tables within. Is this right?
Thanks
Re: ZoneMinder won't start on CentOS 6.3
Posted: Sun Oct 28, 2012 10:48 am
by scjgreen
Anyone help?
Re: ZoneMinder won't start on CentOS 6.3
Posted: Mon Oct 29, 2012 8:05 am
by 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
Re: ZoneMinder won't start on CentOS 6.3
Posted: Mon Oct 29, 2012 9:31 pm
by scjgreen
PacoLM wrote: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
Re: ZoneMinder won't start on CentOS 6.3
Posted: Tue Oct 30, 2012 7:24 am
by PacoLM
Congratulations!
Re: ZoneMinder won't start on CentOS 6.3
Posted: Tue Oct 30, 2012 7:38 am
by 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.
Re: ZoneMinder won't start on CentOS 6.3
Posted: Wed Oct 31, 2012 8:42 am
by 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
Re: ZoneMinder won't start on CentOS 6.3
Posted: Wed Oct 31, 2012 8:51 am
by 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