I have a suggestion :) upgrade geentoo to CentOS or Debian :) Remo On Aug 10, 2011, at 1:25 AM, Tom Hendrikx wrote:
> Hi, > > An update on this issue: I'm able to reproduce this on 2 (amd64 hardened > gentoo) boxes, and we are investigating the issue. Sadly, Stevan is a > bit short on time currently, so this might take a bit longer than expected. > > -- > Tom > > On 05/08/11 14:52, Stevan Bajić wrote: >> On Fri, 05 Aug 2011 14:37:51 +0200 >> Guillaume Hilt <gh...@shadowprojects.org> wrote: >> >>> Sorry, I forgot. >>> I'm running MySQL 5.1.42. >>> Mail server is running with Gentoo 2011 AMD64 and MySQL server is using >>> OpenSolaris AMD64. >>> MySQL librairies are both on 5.1.42. >>> >> Please post the output of "emerge --info". >> >> >>> Guillaume Hilt >>> >>> >>> Le 05/08/2011 14:31, Tom Hendrikx a écrit : >>>> Hi Guillaume, >>>> >>>> Which MySQL version is this? >>>> >>>> On 05/08/11 13:50, Guillaume Hilt wrote: >>>>> I have an issue on gentoo with dspam 3.10 (i just got released in >>>>> portage). >>>>> I followed the UPGRADE file and dspam mysql database is up to date but i >>>>> have these issues, it looks like the queries are malformed : >>>>> >>>>> Aug 5 13:37:34 srv1 dspam[24278]: query error: You have an error in >>>>> your SQL syntax; check the manual that corresponds to your MySQL server >>>>> version for the right syntax to use near 'FROM Uk WHERE vmail='vmail'' >>>>> at line 1: see sql.errors for more details >>>>> >>>>> [08/05/2011 13:28:26] 6862: You have an error in your SQL syntax; check >>>>> the manual that corresponds to your MySQL server version for the right >>>>> syntax to use >>>>> near '/lib64/libgcc_s.so.1 FROM À0k WHERE ='ann...@domain1.com'' at line >>>>> 1: SELECT /lib64/libgcc_s.so.1 FROM À0k WHERE ='ann...@domain1.com' >>>>> [08/05/2011 13:28:26] 6862: You have an error in your SQL syntax; check >>>>> the manual that corresponds to your MySQL server version for the right >>>>> syntax to use >>>>> near '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: >>>>> SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' >>>>> [08/05/2011 13:28:26] 6862: You have an error in your SQL syntax; check >>>>> the manual that corresponds to your MySQL server version for the right >>>>> syntax to use >>>>> near '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: >>>>> SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' >>>>> [08/05/2011 13:28:26] 6862: You have an error in your SQL syntax; check >>>>> the manual that corresponds to your MySQL server version for the right >>>>> syntax to use >>>>> near '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: >>>>> SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' >>>>> [08/05/2011 13:32:56] 6862: You have an error in your SQL syntax; check >>>>> the manual that corresponds to your MySQL server version for the right >>>>> syntax to use >>>>> near '/lib64/libgcc_s.so.1 FROM olpic.net WHERE >>>>> ='bdarn...@domaine2.com'' at line 1: SELECT /lib64/libgcc_s.so.1 FROM >>>>> olpic.net WHERE ='bdarn...@domain2.com' >>>>> [08/05/2011 13:32:56] 6862: You have an error in your SQL syntax; check >>>>> the manual that corresponds to your MySQL server version for the right >>>>> syntax to use >>>>> near '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: >>>>> SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' >>>>> [08/05/2011 13:32:56] 6862: You have an error in your SQL syntax; check >>>>> the manual that corresponds to your MySQL server version for the right >>>>> syntax to use >>>>> near '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: >>>>> SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' >>>>> [08/05/2011 13:32:56] 6862: You have an error in your SQL syntax; check >>>>> the manual that corresponds to your MySQL server version for the right >>>>> syntax to use >>>>> near '/lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail'' at line 1: >>>>> SELECT /lib64/libgcc_s.so.1 FROM olpic.net WHERE ='vmail' >>>>> [08/05/2011 13:37:34] 24278: You have an error in your SQL syntax; check >>>>> the manual that corresponds to your MySQL server version for the right >>>>> syntax to use >>>>> near 'FROM ~@Uk WHERE vmail='vmail'' at line 1: SELECT FROM ~@Uk >>>>> WHERE vmail='vmail' >>>>> [08/05/2011 13:37:34] 24278: You have an error in your SQL syntax; check >>>>> the manual that corresponds to your MySQL server version for the right >>>>> syntax to use >>>>> near 'FROM ~@Uk WHERE vmail='vmail'' at line 1: SELECT FROM ~@Uk >>>>> WHERE vmail='vmail' >>>>> [08/05/2011 13:37:34] 24278: You have an error in your SQL syntax; check >>>>> the manual that corresponds to your MySQL server version for the right >>>>> syntax to use >>>>> near 'FROM ~@Uk WHERE vmail='vmail'' at line 1: SELECT FROM ~@Uk >>>>> WHERE vmail='vmail >>>>> >>>>> Please note that olpic.net is a part of one of our domain, it got >>>>> truncted and i don't know why. >>>>> >>>>> DSPAM has been restarted and i tried to figure if something was broken >>>>> with revdep-rebuild but it's good. >>>>> >>>>> Any idea ? >>>>> >>>>> Guillaume Hilt >>>>> >>>>> >>>>> Le 04/08/2011 03:48, Nathanael D. Noblet a écrit : >>>>>> On 08/03/2011 01:52 PM, Stevan Bajić wrote: >>>>>>> On Tue, 02 Aug 2011 12:54:28 -0600 >>>>>>> "Nathanael D. Noblet"<nathan...@gnat.ca> wrote: >>>>>>> >>>>>>>> One more question, which I'm fairly certain of, but thought I would ask >>>>>>>> anyway. This is a safe upgrade from 3.9 I presume? no changes to token >>>>>>>> system that would force a user to dump the db and re-train?... >>>>>>>> >>>>>>> Might I ask you why you are asking this? Is it because of the version >>>>>>> number jump from 3.9.x to 3.10.x? Or any other reason? >>>>>>> >>>>>>> >>>>>> Just to be prudent. As the packager for fedora I wouldn't want to push >>>>>> an update that could change the underlying DB or tokenizer etc... I'm >>>>>> also partially lazy plus didn't really understand the release >>>>>> announcement when it said the upgrade should be problem free... No idea >>>>>> why. We just had a baby 2 weeks ago so I blame it on lack of sleep. >>>>>> >>>>>> Either way Fedora 16,15,14, EPEL 6,5 all have dspam 3.10 rolling in. >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA >>>>>> The must-attend event for mobile developers. Connect with experts. >>>>>> Get tools for creating Super Apps. See the latest technologies. >>>>>> Sessions, hands-on labs, demos& much more. Register early& save! >>>>>> http://p.sf.net/sfu/rim-blackberry-1 >>>>>> _______________________________________________ >>>>>> Dspam-user mailing list >>>>>> Dspam-user@lists.sourceforge.net >>>>>> https://lists.sourceforge.net/lists/listinfo/dspam-user >>>>> ------------------------------------------------------------------------------ >>>>> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA >>>>> The must-attend event for mobile developers. Connect with experts. >>>>> Get tools for creating Super Apps. See the latest technologies. >>>>> Sessions, hands-on labs, demos& much more. Register early& save! >>>>> http://p.sf.net/sfu/rim-blackberry-1 >>>>> _______________________________________________ >>>>> Dspam-user mailing list >>>>> Dspam-user@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/dspam-user >>>> >>> >>> ------------------------------------------------------------------------------ >>> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA >>> The must-attend event for mobile developers. Connect with experts. >>> Get tools for creating Super Apps. See the latest technologies. >>> Sessions, hands-on labs, demos & much more. Register early & save! >>> http://p.sf.net/sfu/rim-blackberry-1 >>> _______________________________________________ >>> Dspam-user mailing list >>> Dspam-user@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/dspam-user >> >> ------------------------------------------------------------------------------ >> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA >> The must-attend event for mobile developers. Connect with experts. >> Get tools for creating Super Apps. See the latest technologies. >> Sessions, hands-on labs, demos & much more. Register early & save! >> http://p.sf.net/sfu/rim-blackberry-1 >> _______________________________________________ >> Dspam-user mailing list >> Dspam-user@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/dspam-user > > > -- > Groeten, > Tom > > ------------------------------------------------------------------------------ > uberSVN's rich system and user administration capabilities and model > configuration take the hassle out of deploying and managing Subversion and > the tools developers use with it. Learn more about uberSVN and get a free > download at: http://p.sf.net/sfu/wandisco-dev2dev > _______________________________________________ > Dspam-user mailing list > Dspam-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspam-user > > !DSPAM:4e4233b5215061333812749! > Remo Mattei r...@italy1.com ------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
