Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

Brian May writes: > From the upstream bug report it is sounding increasingly likely that > this is a Perl bug, related to tainted mode. > > The upstream developer is working on getting some solid evidence to > prove this. A bug has now been reported against Perl.

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

Henrique de Moraes Holschuh writes: > Brian, could you forward the debug dump to upstream? I don't have my > github login handy ATM... >From the upstream bug report it is sounding increasingly likely that this is a Perl bug, related to tainted mode. The upstream developer is

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

desc spamfilter_users   Field Type Null Key Default Extra  idint(11) unsignedNOPRINULLauto_incrementsys_useridint(11) unsignedNO 0  sys_groupidint(11) unsignedNO 0 sys_perm_uservarchar(5)NO    sys_perm_groupvarchar(5)NO   sys_perm_othervarchar(5)NO   server_idint(11) unsignedNO 0 

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

Upstream has asked for some rather detailed information: https://github.com/perl5-dbi/DBD-mysql/issues/78 The information I asked for will do for now, then we can decide if this more extensive information is required. -- Brian May

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

Henrique de Moraes Holschuh writes: > LOC, could you send (to this bug report) a dump of the *schema* for the > relevant tables (the ones returning 0 instead of the correct float) ? LOC, please connect to the database using the mysql client, and type in the following commands.

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

Brian, could you forward the debug dump to upstream? I don't have my github login handy ATM... Also, some interesting points: On Mon, Feb 13, 2017, at 14:13, LOC wrote: > > About the DB schema, someone asked before, I'm using ISPConfig 3.1, so > the whole amavis configuration is done by

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

Hello Henrique,  thank you for the response and guide to modify amavisd-new, I have done that and restarted amavis with "/etc/init.d/amavis debug". The results are in the attachment, hope it will help.   About the DB schema, someone asked before, I'm using ISPConfig 3.1, so the whole amavis

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

On Sun, 12 Feb 2017, Brian May wrote: > >> https://github.com/perl5-dbi/DBD-mysql/issues/78 > > Please read the latest message on the above report... Jakub, This issue is a nasty problem between amavisd-new and DBD-mysql. It is yet not clear which program is at fault, or if it is an ABI break

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

Henrique de Moraes Holschuh writes: >> https://github.com/perl5-dbi/DBD-mysql/issues/78 > > Thanks! Please read the latest message on the above report... -- Brian May

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

On Sun, 12 Feb 2017, Brian May wrote: > I am starting to think that maybe the bug lies solely in p5-DBD-mysql > not returning valid data. I guess one could try to look at what it actually returns, comparing 4.037 (old API/ABI) with 4.041 (new API/ABI?), for the "string" return type, I think. And

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

I missed reading the following: "The change is that p5-DBD-mysql now returns mysql doubles as perl doubles and mysql floats as perl floats (and not as a string anymore). This should be adressed by amavisd." There is more debug information here:

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

On Sun, 12 Feb 2017, Brian May wrote: > Henrique de Moraes Holschuh writes: > > > I don't know. I never use mysql (or any DB, really) with amavisd-new, > > and I have no idea why it would fetch 0 instead of the proper float > > value from mysql, or how to fix it :-( > > Same

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

Henrique de Moraes Holschuh writes: > I don't know. I never use mysql (or any DB, really) with amavisd-new, > and I have no idea why it would fetch 0 instead of the proper float > value from mysql, or how to fix it :-( Same here. Not even convinced this should be RC,

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

On Sun, 05 Feb 2017, Brian May wrote: > On Wed, Dec 07, 2016 at 09:26:04AM +0100, Jakub Novak wrote: > > With the latest update of Debian packages in Scratch, Amavis started to > > reject more than 50% of all emails as spam. > > From Amavis debuging logs, all the MySQL fields that are of type

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

On Wed, Dec 07, 2016 at 09:26:04AM +0100, Jakub Novak wrote: > With the latest update of Debian packages in Scratch, Amavis started to > reject more than 50% of all emails as spam. > From Amavis debuging logs, all the MySQL fields that are of type "float" does > not get its correct values from

Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0".

Package: amavisd-new Version: 1:2.10.1-4 Severity: grave Justification: causes non-serious data loss Dear Maintainer, With the latest update of Debian packages in Scratch, Amavis started to reject more than 50% of all emails as spam. >From Amavis debuging logs, all the MySQL fields that are of