DBI connect error during shut down only

Support and queries relating to all previous versions of ZoneMinder
Locked
antar
Posts: 35
Joined: Mon Mar 20, 2006 1:32 am

DBI connect error during shut down only

Post 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 )
antar
Posts: 35
Joined: Mon Mar 20, 2006 1:32 am

Found the problem but need advice

Post 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
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Post 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.
Phil
antar
Posts: 35
Joined: Mon Mar 20, 2006 1:32 am

Post 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
W.
Posts: 108
Joined: Tue Apr 10, 2007 5:06 pm
Location: Latvia

Post by W. »

rename K00zm to K000zm :)
if common sense is so uncommon, why is it called common then?
Locked