Page 1 of 1

DBI connect error during shut down only

Posted: Tue Nov 13, 2007 3:41 pm
by antar
Anyone is having this issue. It happens only at shutdown of ZM


Shutting ZoneMinder: DBI connect('database=zm;host=localhost','zmuser',...) failed: Access denied for user 'zmuser'@'localhost' (using password: YES) at /usr/share/perl5/ZoneMinder/Config.pm line 89
Can't call method "prepare_cached" on an undefined value at /usr/share/perl5/ZoneMinder/Config.pm line 91.


Starting looks fine. it is bothering me for the SQL DB health

install Details:

Mandriva 2008
mySQL 5.1
perl 5

How do i check if i am missing any perl modules (DBI is not installed properly i think )

Found the problem but need advice

Posted: Mon Nov 19, 2007 5:03 pm
by antar
Hi,
I found why this error is happenning : mysqld is shutting down before zm in the rcX.d files.

I know how to change the K00 order to K10 or K20 ... on K00mysqld but does anyone know which services have to stay alive before i get to the shutdown instruction K10mysqld. Presently all of them have K00 (http, netconsole,...


Thanks

Posted: Tue Nov 20, 2007 10:11 am
by zoneminder
I think you may be better off getting ZM to shut down earlier rather than messing around with mysql as that may have more dependencies.

Posted: Tue Nov 20, 2007 12:01 pm
by antar
zoneminder wrote:I think you may be better off getting ZM to shut down earlier rather than messing around with mysql as that may have more dependencies.
That is what i am trying to do !. how can I go lower than K00 ?

presently

mysql is K00mysql
zm is K00zm

mysql is shutting before zm

Posted: Tue Nov 20, 2007 12:03 pm
by W.
rename K00zm to K000zm :)