Steve wrote:
> -------- 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?
>
mysql Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using readline 5.2
> - What architecture?
>
## --------- ##
## Platform. ##
## --------- ##
uname -r = 2.6.20-16-server
uname -m = i686
uname -v = #2 SMP Sun Sep 23 19:57:25 UTC 2007
> - What bit depth? 32Bit? 64Bit?
>
32 bit
> - What compiler?
>
gcc
> - What compiler version?
>
configure:2936: checking for C compiler version
configure:2943: i486-linux-gnu-gcc --version >&5
i486-linux-gnu-gcc (GCC) 4.1.2 (Ubuntu 4.1.2-0ubuntu4)
> - What compiler flags did you use?
> - What configure options did you use?
>
$ ../configure --host=i486-linux-gnu --build=i486-linux-gnu
--prefix=/usr --includedir=/usr/include --mandir=/usr/share/man
--infodir=/usr/share/info --with-logdir=/var/log/dspam/
--localstatedir=/var --libexecdir=/usr/lib/dspam --srcdir=..
--with-dspam-home=/var/spool/dspam --sysconfdir=/etc/dspam
--enable-domain-scale --enable-signature-headers
--with-delivery-agent=/usr/bin/procmail --enable-
daemon --with-mysql-includes=/usr/include/mysql
--with-pgsql-includes=/usr/include/postgresql
--with-storage-driver=libdb4_drv,mysql_drv,pgsql_drv,sqlite3_drv,hash_drv
--enable-ldap --enable-debug --enable-virtual-users
--enable-preferences-extension --enable-clamav
And here are the dependent library versions on this system (Ubuntu 7.04):
[EMAIL PROTECTED]:~/dspam_cvs/dspam/build--tmp$ ldd /usr/bin/dspam
linux-gate.so.1 => (0xffffe000)
libdspam.so.7 => /usr/lib/libdspam.so.7 (0xb7f7d000)
libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0xb7f56000)
libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb7f52000)
libldap_r.so.2 => /usr/lib/libldap_r.so.2 (0xb7f1c000)
liblber.so.2 => /usr/lib/liblber.so.2 (0xb7f0f000)
libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0xb7ef8000)
libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7db6000)
/lib/ld-linux.so.2 (0x80000000)
libresolv.so.2 => /lib/tls/i686/cmov/libresolv.so.2 (0xb7da3000)
libcrypt.so.1 => /lib/tls/i686/cmov/libcrypt.so.1 (0xb7d75000)
libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7d5e000)
libgnutls.so.13 => /usr/lib/libgnutls.so.13 (0xb7cee000)
libtasn1.so.3 => /usr/lib/libtasn1.so.3 (0xb7cd8000)
libz.so.1 => /usr/lib/libz.so.1 (0xb7cc4000)
libgcrypt.so.11 => /usr/lib/libgcrypt.so.11 (0xb7c73000)
libgpg-error.so.0 => /usr/lib/libgpg-error.so.0 (0xb7c6f000)
libnsl.so.1 => /lib/tls/i686/cmov/libnsl.so.1 (0xb7c58000)
>
>
>> -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
>>>
>>>
>>>
>>>
>>>
>
>
