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 < [email protected]> 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,49623c19150928544110855!
