commit ineffective with AutoCommit enabled... MailWatch.pm

[Julian Field]

Peter Farrow wrote:
> 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  ;-)
Any ideas of something I could do in MailScanner to stop MailWatch 
generating this error? If it's an easy thing to stop, I'm quite prepared 
to add it, as it would stop a significant number of support requests.

Jules

-- 
Julian Field MEng CITP CEng
www.MailScanner.info
Buy the MailScanner book at www.MailScanner.info/store

Need help customising MailScanner?
Contact me!
Need help fixing or optimising your systems?
Contact me!
Need help getting you started solving new requirements from your boss?
Contact me!

PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.