commit ineffective with AutoCommit enabled... MailWatch.pm

[Bertrand Poulet]

hi,

having error message on starting MailScanner (4.68.8-1) with MailWatch:
  # /etc/init.d/MailScanner restart
   Shutting down MailScanner daemons:
         MailScanner:       commit ineffective with AutoCommit enabled
         at 
/usr/lib/MailScanner/MailScanner/CustomFunctions/MailWatch.pm line 93,
         <CLIENT> line 1.

i've read about same problem on mailing list :
http://lists.mailscanner.info/pipermail/mailscanner/2007-August/077492.html 
(disabling autocommit)
http://lists.mailscanner.info/pipermail/mailscanner/2008-April/083596.html 
(automatic syntax check = no )

and tried to disabled autocommit.
  [root at host1 ~]#  mysql mailscanner -u user -p
   mysql> select @@autocommit ;
    @@autocommit ->    1


so i changed in /etc/my.cnf
   [mysqld]
   init_connect='SET autocommit=0'

and then
   mysql> select @@autocommit ;
    @@autocommit ->    0


but still got the error message 'commit ineffective with AutoCommit 
enabled...'
maybe, because of "the statements specified for the init_connect option 
are not executed for users
  that have the SUPER privilege"

any idea to solve this issue ?
maybe something like giving 'Autocommit' value when connecting to DB in 
MailWatch.pm and
then leave 'automatic syntax check = yes' ?

Regards,
Gwo.






	

	
		
___________________________________________________________________________
Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les 
tarifs exceptionnels pour appeler la France et l'international.
Téléchargez sur http://fr.messenger.yahoo.com