zm.conf and mysql
Posted: Sun Dec 28, 2008 3:24 am
EDIT -
As always after summarizing my problem in a post it causes me to re-think.
I deleted mysql using synaptic for complete removal and then re-installed it. BUT when it asked me for a root password during the install I entered nothing.
This allowed me to set up theZM db in the usual manner and now the ZM console comes up as expected.
next stop testing monitors etc.
++++++++++++++++++++++++++++++++++++++
So i thought I'd have ago at building a new system comprising
Ubuntu 8.10 and ZM 1.24 rc1 2678
I've managed to get ffmpeg compiled in ok and the config / make and make install appears ok.
mysql is running and I can access the zm page of sorts but it complains about zm.conf missing.
here's my config:
./configure --with-webdir=/var/www/html/zm --with-cgidir=/var/www/cgi-bin --with-ffmpeg=/usr/include/ffmpeg ZM_DB_HOST=localhost ZM_DB_NAME=zm ZM_DB_USER=zmuser ZM_DB_PASS=zmpass --enable-debug=yes --with-webgroup=www-data --with-webuser=www-data
Here's the end of the make install - not sure if it's terminating correctly.....
make[2]: Entering directory `/usr/local/src/ZoneMinder-1.24.0'
test -z "/usr/local/etc" || /bin/mkdir -p "/usr/local/etc"
/usr/bin/install -c -m 644 'zm.conf' '/usr/local/etc/zm.conf'
make install-data-hook
make[3]: Entering directory `/usr/local/src/ZoneMinder-1.24.0'
( cd /usr/local/etc; chown www-data:www-data zm.conf; chmod 600 zm.conf )
( if ! test -e /var/run; then mkdir /var/run; fi )
( if ! test -e /var/run/zm; then mkdir /var/run/zm; fi; chown www-data:www-data /var/run/zm; chmod u+w /var/run/zm )
make[3]: Leaving directory `/usr/local/src/ZoneMinder-1.24.0'
make[2]: Leaving directory `/usr/local/src/ZoneMinder-1.24.0'
make[1]: Leaving directory `/usr/local/src/ZoneMinder-1.24.0'
when I run zmpgk.pl start I get this:
Warning, overriding installed ./zm.conf file with local copy
DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at /usr/local/share/perl/5.10.0/ZoneMinder/Config.pm line 92.
Can't execute: Table 'zm.Config' doesn't exist at /usr/local/share/perl/5.10.0/ZoneMinder/Config.pm line 100
BEGIN failed--compilation aborted at /usr/local/share/perl/5.10.0/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/local/share/perl/5.10.0/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/local/share/perl/5.10.0/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've not been able to get mysql set up without using mysql admin to create the zmuser, zm db and zmpassword.
zm.conf does exist at /usr/local/etc and contains the following -
# Current version of ZoneMinder
ZM_VERSION=1.24.0
# Path to build directory, used mostly for finding DB upgrade scripts
ZM_PATH_BUILD=/usr/local/src/ZoneMinder-1.24.0
# Build time, used to record when to trigger various checks
ZM_TIME_BUILD=1230430376
# Path to ZoneMinder binaries
ZM_PATH_BIN=/usr/local/bin
# Path to ZoneMinder libraries (none at present, for future use)
ZM_PATH_LIB=/usr/local/lib
# Path to ZoneMinder configuration (this file only at present)
ZM_PATH_CONF=/usr/local/etc
# Path to ZoneMinder web files
ZM_PATH_WEB=/var/www/html/zm
# Path to ZoneMinder cgi files
ZM_PATH_CGI=/var/www/cgi-bin
# Username and group that web daemon (httpd/apache) runs as
ZM_WEB_USER=www-data
ZM_WEB_GROUP=www-data
# ZoneMinder database hostname or ip address
ZM_DB_HOST=localhost
# ZoneMinder database name
ZM_DB_NAME=zm
# ZoneMinder database user
ZM_DB_USER=zmuser
# ZoneMinder database password
ZM_DB_PASS=zmpass
Any suggestions / hints ?
Thanks Tim
As always after summarizing my problem in a post it causes me to re-think.
I deleted mysql using synaptic for complete removal and then re-installed it. BUT when it asked me for a root password during the install I entered nothing.
This allowed me to set up theZM db in the usual manner and now the ZM console comes up as expected.
next stop testing monitors etc.
++++++++++++++++++++++++++++++++++++++
So i thought I'd have ago at building a new system comprising
Ubuntu 8.10 and ZM 1.24 rc1 2678
I've managed to get ffmpeg compiled in ok and the config / make and make install appears ok.
mysql is running and I can access the zm page of sorts but it complains about zm.conf missing.
here's my config:
./configure --with-webdir=/var/www/html/zm --with-cgidir=/var/www/cgi-bin --with-ffmpeg=/usr/include/ffmpeg ZM_DB_HOST=localhost ZM_DB_NAME=zm ZM_DB_USER=zmuser ZM_DB_PASS=zmpass --enable-debug=yes --with-webgroup=www-data --with-webuser=www-data
Here's the end of the make install - not sure if it's terminating correctly.....
make[2]: Entering directory `/usr/local/src/ZoneMinder-1.24.0'
test -z "/usr/local/etc" || /bin/mkdir -p "/usr/local/etc"
/usr/bin/install -c -m 644 'zm.conf' '/usr/local/etc/zm.conf'
make install-data-hook
make[3]: Entering directory `/usr/local/src/ZoneMinder-1.24.0'
( cd /usr/local/etc; chown www-data:www-data zm.conf; chmod 600 zm.conf )
( if ! test -e /var/run; then mkdir /var/run; fi )
( if ! test -e /var/run/zm; then mkdir /var/run/zm; fi; chown www-data:www-data /var/run/zm; chmod u+w /var/run/zm )
make[3]: Leaving directory `/usr/local/src/ZoneMinder-1.24.0'
make[2]: Leaving directory `/usr/local/src/ZoneMinder-1.24.0'
make[1]: Leaving directory `/usr/local/src/ZoneMinder-1.24.0'
when I run zmpgk.pl start I get this:
Warning, overriding installed ./zm.conf file with local copy
DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at /usr/local/share/perl/5.10.0/ZoneMinder/Config.pm line 92.
Can't execute: Table 'zm.Config' doesn't exist at /usr/local/share/perl/5.10.0/ZoneMinder/Config.pm line 100
BEGIN failed--compilation aborted at /usr/local/share/perl/5.10.0/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/local/share/perl/5.10.0/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/local/share/perl/5.10.0/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've not been able to get mysql set up without using mysql admin to create the zmuser, zm db and zmpassword.
zm.conf does exist at /usr/local/etc and contains the following -
# Current version of ZoneMinder
ZM_VERSION=1.24.0
# Path to build directory, used mostly for finding DB upgrade scripts
ZM_PATH_BUILD=/usr/local/src/ZoneMinder-1.24.0
# Build time, used to record when to trigger various checks
ZM_TIME_BUILD=1230430376
# Path to ZoneMinder binaries
ZM_PATH_BIN=/usr/local/bin
# Path to ZoneMinder libraries (none at present, for future use)
ZM_PATH_LIB=/usr/local/lib
# Path to ZoneMinder configuration (this file only at present)
ZM_PATH_CONF=/usr/local/etc
# Path to ZoneMinder web files
ZM_PATH_WEB=/var/www/html/zm
# Path to ZoneMinder cgi files
ZM_PATH_CGI=/var/www/cgi-bin
# Username and group that web daemon (httpd/apache) runs as
ZM_WEB_USER=www-data
ZM_WEB_GROUP=www-data
# ZoneMinder database hostname or ip address
ZM_DB_HOST=localhost
# ZoneMinder database name
ZM_DB_NAME=zm
# ZoneMinder database user
ZM_DB_USER=zmuser
# ZoneMinder database password
ZM_DB_PASS=zmpass
Any suggestions / hints ?
Thanks Tim