Guillaume Hilt wrote:
Crap, i forgot to restart DSPAM after setting the global dictionnary.
I only have one error now :
4272: [01/05/2009 21:34:29] mysql_fetch_row() failed in _ds_get_signature
I don't see a related error in sql.errors, just some verbose data.
vmail exists in the database and have data in every table except
dspam_preferences.
What's its meaning ?
Guillaume Hilt
It means that you have no corresponding signature for that uid in
dspam_signature_data table. You can check it with a query:
select signature,username,uid from dspam_signature_data natural join
dspam_virtual_uids where username='vmail' and
signature='9610dc323991804284693';
Kyle Johnson a écrit :
Is the user "vmail" in the dspam_virtual_uids table? Sounds to me
like dspam shouldn't be processing messages as "vmail", but as the
user that the mail was intended for. Now, dspam running as vmail is
something entirely different.
On Sun, Jan 4, 2009 at 2:34 PM, Guillaume Hilt
<postmas...@shadowprojects.org
<mailto:postmas...@shadowprojects.org>> wrote:
Hi again,
Now that my setup is working fine, I tested dspam plugin for
dovecot by moving a mail into my Spam folder.
Here's what I got in my logs :
==> ../dspam/dspam.debug <==
2821: [01/04/2009 20:28:43] DSPAM Instance Startup
2821: [01/04/2009 20:28:43] input args: /usr/bin/dspam
--source=error --class=spam --signature=49610dc323991804284693
2821: [01/04/2009 20:28:43] pass-thru args:
2821: [01/04/2009 20:28:43] processing user vmail
2821: [01/04/2009 20:28:43] uid = 1001, euid = 1001, gid = 12,
egid = 1000
2821: [01/04/2009 20:28:43] loading preferences for user vmail
2821: [01/04/2009 20:28:43] attribute MySQLServer =
/var/run/mysqld/mysqld.sock
2821: [01/04/2009 20:28:43] attribute MySQLUser = dspam
2821: [01/04/2009 20:28:43] attribute MySQLPass = XXXXXX
2821: [01/04/2009 20:28:43] attribute MySQLDb = srv_dspam
2821: [01/04/2009 20:28:43] attribute MySQLCompress = false
2821: [01/04/2009 20:28:43] attribute MySQLVirtualTable =
dspam_virtual_uids
2821: [01/04/2009 20:28:43] attribute MySQLVirtualUIDField = uid
2821: [01/04/2009 20:28:43] attribute MySQLVirtualUsernameField =
username
*2821: [01/04/2009 20:28:43] _ds_pref_load: unable to
_mysql_drv_getpwnam(vmail)*
2821: [01/04/2009 20:28:43] attribute MySQLServer =
/var/run/mysqld/mysqld.sock
2821: [01/04/2009 20:28:43] attribute MySQLUser = dspam
2821: [01/04/2009 20:28:43] attribute MySQLPass = XXXXXXX
2821: [01/04/2009 20:28:43] attribute MySQLDb = srv_dspam
2821: [01/04/2009 20:28:43] attribute MySQLCompress = false
2821: [01/04/2009 20:28:43] attribute MySQLVirtualTable =
dspam_virtual_uids
2821: [01/04/2009 20:28:43] attribute MySQLVirtualUIDField = uid
2821: [01/04/2009 20:28:43] attribute MySQLVirtualUsernameField =
username
2821: [01/04/2009 20:28:43] Loading preferences for uid 0
2821: [01/04/2009 20:28:43] attribute MySQLServer =
/var/run/mysqld/mysqld.sock
2821: [01/04/2009 20:28:43] attribute MySQLUser = dspam
2821: [01/04/2009 20:28:43] attribute MySQLPass = XXXXXXX
2821: [01/04/2009 20:28:43] attribute MySQLDb = srv_dspam
2821: [01/04/2009 20:28:43] attribute MySQLCompress = false
2821: [01/04/2009 20:28:43] attribute MySQLVirtualTable =
dspam_virtual_uids
2821: [01/04/2009 20:28:43] attribute MySQLVirtualUIDField = uid
2821: [01/04/2009 20:28:43] attribute MySQLVirtualUsernameField =
username
2821: [01/04/2009 20:28:43] Loading preferences for uid 0
2821: [01/04/2009 20:28:43] default preferences empty. reverting
to dspam.conf preferences.
2821: [01/04/2009 20:28:43] Loading preferences from dspam.conf
2821: [01/04/2009 20:28:43] aggregated preference
'signatureLocation' => 'header'
2821: [01/04/2009 20:28:43] aggregated preference 'showFactors'
=> 'on'
2821: [01/04/2009 20:28:43] aggregated preference 'spamAction' =>
'tag'
2821: [01/04/2009 20:28:43] aggregated preference 'spamSubject'
=> '[SPAM] '
2821: [01/04/2009 20:28:43] using
/var/spool/dspam/opt-in/local/vmail.dspam as path
2821: [01/04/2009 20:28:43] using
/var/spool/dspam/opt-out/local/vmail.nodspam as path
2821: [01/04/2009 20:28:43] sedation level set to: 5
2821: [01/04/2009 20:28:43] attribute IgnoreHeader = X-Spam-Status
2821: [01/04/2009 20:28:43] attribute IgnoreHeader = X-Spam-Scanned
2821: [01/04/2009 20:28:43] attribute IgnoreHeader =
X-Virus-Scanner-Result
2821: [01/04/2009 20:28:43] attribute StorageDriver =
/usr/lib64/dspam/libmysql_drv.so
2821: [01/04/2009 20:28:43] attribute MySQLServer =
/var/run/mysqld/mysqld.sock
2821: [01/04/2009 20:28:43] attribute MySQLUser = dspam
2821: [01/04/2009 20:28:43] attribute MySQLPass = XXXXXXX
2821: [01/04/2009 20:28:43] attribute MySQLDb = srv_dspam
2821: [01/04/2009 20:28:43] attribute MySQLCompress = false
2821: [01/04/2009 20:28:43] attribute MySQLVirtualTable =
dspam_virtual_uids
2821: [01/04/2009 20:28:43] attribute MySQLVirtualUIDField = uid
2821: [01/04/2009 20:28:43] attribute MySQLVirtualUsernameField =
username
2821: [01/04/2009 20:28:43] attribute HashRecMax = 98317
2821: [01/04/2009 20:28:43] attribute HashAutoExtend = on
2821: [01/04/2009 20:28:43] attribute HashMaxExtents = 0
2821: [01/04/2009 20:28:43] attribute HashExtentSize = 49157
2821: [01/04/2009 20:28:43] attribute HashPctIncrease = 10
2821: [01/04/2009 20:28:43] attribute HashMaxSeek = 10
2821: [01/04/2009 20:28:43] attribute HashConnectionCache = 10
2821: [01/04/2009 20:28:43] attribute LocalMX = 127.0.0.1
2821: [01/04/2009 20:28:43] attribute ProcessorURLContext = on
2821: [01/04/2009 20:28:43] attribute ProcessorBias = on
*2821: [01/04/2009 20:28:43] _mysql_drv_get_spamtotals: unable to
_mysql_drv_getpwnam(vmail)
2821: [01/04/2009 20:28:43] unable to load totals. using zero
values.
2821: [01/04/2009 20:28:43] _ds_get_signature: unable to
_mysql_drv_getpwnam(vmail)
2821: [01/04/2009 20:28:43] _mysql_drv_get_spamtotals: unable to
_mysql_drv_getpwnam(vmail)*
2821: [01/04/2009 20:28:43] DSPAM Instance Shutdown. Exit Code: 0
What are these "unable to _mysql_drv_getpwnam" ?
vmail is the user which owns all the mail for the virtual users.
--
Guillaume Hilt
!DSPAM:1011,49636a55150928538791183!