Page 1 of 1

Error after apt-get upgrade

Posted: Tue Jun 03, 2008 1:43 pm
by bjs
./zmstart.sh start
Starting ZoneMinder: DBI connect('database=zm;host=localhost','zmuser',...) failed: Access denied for user 'zmuser'@'localhost' (using password: YES) at /usr/local/share/perl/5.8.8/ZoneMinder/Config.pm line 89
Can't call method "prepare_cached" on an undefined value at /usr/local/share/perl/5.8.8/ZoneMinder/Config.pm line 91.
BEGIN failed--compilation aborted at /usr/local/share/perl/5.8.8/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/local/share/perl/5.8.8/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/local/share/perl/5.8.8/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.
failure


upgraded to perl 5.8.8/mysql then the error started, i thought it was mysql_connect & mysql_pconnect that gave me the error cus the www-zm looks like this:

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'zmuser'@'localhost' (using password: YES) in /var/www/zm/zm_db.php on line 27
Could not connect to database: Access denied for user 'zmuser'@'localhost' (using password: YES)

Zm 1.23.2 btw..

some one else how has this error?

Posted: Wed Jun 11, 2008 7:53 am
by zm-padilla
I had the same problem, I think the post-install scripts on Debian haven't been tested for all conditions. I manually created the DB, assigned permissions and set the zm.conf file correctly. Now the system works fine, but I still have the shared memory errors.

Why oh why did I move from locally compiled to packaged versions!!?!??!? :(

Posted: Sun Jun 15, 2008 8:13 am
by PeterHoward
zm-padilla wrote:I had the same problem, I think the post-install scripts on Debian haven't been tested for all conditions. I manually created the DB, assigned permissions and set the zm.conf file correctly. Now the system works fine, but I still have the shared memory errors.
Can you give me a bit more information about your setup before installing the package? I assume you had zoneminder installed manually. The database from your old install was still there?

And which "shared memory errors" are you referring to?


PJH

Re: Error after apt-get upgrade

Posted: Sun Jun 15, 2008 8:17 am
by PeterHoward
bjs wrote:./zmstart.sh start
Starting ZoneMinder: DBI connect('database=zm;host=localhost','zmuser',...) failed: Access denied for user 'zmuser'@'localhost' (using password: YES) at /usr/local/share/perl/5.8.8/ZoneMinder/Config.pm line 89
Can't call method "prepare_cached" on an undefined value at /usr/local/share/perl/5.8.8/ZoneMinder/Config.pm line 91.
BEGIN failed--compilation aborted at /usr/local/share/perl/5.8.8/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/local/share/perl/5.8.8/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/local/share/perl/5.8.8/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.
failure


upgraded to perl 5.8.8/mysql then the error started, i thought it was mysql_connect & mysql_pconnect that gave me the error cus the www-zm looks like this:

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'zmuser'@'localhost' (using password: YES) in /var/www/zm/zm_db.php on line 27
Could not connect to database: Access denied for user 'zmuser'@'localhost' (using password: YES)

Zm 1.23.2 btw..
The fact you've got stuff in /usr/local/ makes me think at least some of your installation is manual. Is this correct? If so, which bits are installed from package, which parts installed manually.

And what's the base system? Debian (which) or Ubuntu (which)?

Posted: Sun Jun 15, 2008 8:41 am
by cordel
Check your zm.conf and make sure you have the correct database name, user name, and password as you had originally configured.