-------- Original-Nachricht -------- > Datum: Mon, 31 Dec 2007 13:56:10 -0800 > Von: Jason Axley <[EMAIL PROTECTED]> > An: [email protected] > Betreff: Re: [dspam-users] CVS version getting invalid result messages in logs
> Digging around in my dspam debug logs, I found these messages that > probably correspond: > > 12984: [12/31/2007 10:15:52] sedation level set to: 0 > 12984: [12/31/2007 10:15:52] _mysql_drv_getspamtotals: unable to > _mysql_drv_getpwnam((null)) > 12984: [12/31/2007 10:15:52] unable to load totals. using zero values. > 12984: [12/31/2007 10:15:52] _ds_getall_spamrecords: unable to > _mysql_drv_getpwnam((null)) > 12984: [12/31/2007 10:15:52] _ds_getall_spamrecords() failed > This error means that the CTX (DSPAM Classification Context) has no username or group associated with the context. Actually it is a NULL value associated with the context. I see that in the error: _mysql_drv_getpwnam((null)) The error is initiated in _ds_getall_spamrecords wich is an abstraction level for and above all the storage drivers. So probably you have a issue with the storage backend and in your case this is MySQL. Tonny from the DSPAM ML has the same error with CVS on his FC6 system. I could not replicate or reproduce the error on my CentOS 5.1 or Gentoo system. I however only used CVS on the CentOS 5.1 system. On the Gentoo system I am running 3.8.0 with the Gentoo patches and a bunch of my own patches. There I have rewritten a big part of the MySQL storage driver for DSPAM. Since I am fiddling around with the MySQL driver in DSPAM for so long I know that that part of the original code is not without problems. But that is another story. > Dspam is working, but just occassionally the mysql driver is getting > some errors. Some threading issue perhaps? > DSPAM adds mutex locks around each MySQL connection. The chance that you have a threading issue is pretty small. > Oh, and it occurs on even mundane text emails so that isn't a factor. > Looks like a bug in the mysql driver unrelated to the message contents. > I think that as well. Allow me to ask: - What MySQL version? - What architecture? - What bit depth? 32Bit? 64Bit? - What compiler? - What compiler version? - What compiler flags did you use? - What configure options did you use? > -Jason > Steve > Jason Axley wrote: > > I've got the latest CVS version built on ubuntu and it seems to be > > better than the 3.8.0 version at telling me there is an error > > encountered instead of failing to completely tag messages it chokes on. > > Several messages slipped through and I see this in the mail.log: > > > > Dec 31 10:15:53 void dspam[12984]: bailing on error -2 > > Dec 31 10:15:53 void dspam[12984]: received invalid result (! DSR_ISSPAM > > || DSR_INNOCENT) : -2 > > Dec 31 10:15:53 void dspam[12984]: process_message returned error -2. > > delivering. > > > > Anyone seen this or have an idea offhand why dspam might error on this? > > I'm using the mysql driver along with this group config: > > > > [EMAIL PROTECTED]:merged:* > > global-classification:classification:[EMAIL PROTECTED] > > > > The messages it failed on were really simple, short > > multipart/alternative messages with just a plaintext and html version. > > > > -Jason > > > > !DSPAM:4,47796046129841817296938! > > > > -- GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS. Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
