commit ineffective with AutoCommit enabled... MailWatch.pm

[Peter Farrow]

Bertrand Poulet wrote:
> 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.
>
>
>
Its a just awarning, don't worry about it...unless of course you've got 
too much time on your hands  ;-)