[Dovecot] Install Configuring and run.

[Marko Weber]

Hi Thorsten,

now it looks different to old log before,

I disabled  "MySQLUIDInSignature" like you said ,
now when i move a  mail to SPAM folder  "dspam.debug" tells this =

2376: [11/14/2008 14:02:51] DSPAM Instance Startup
2376: [11/14/2008 14:02:51] input args: /usr/bin/dspam --source=error 
--class=spam --signature==?iso-8859-1?Q?491d76cb23581804284693=0D?= 
--user clamav
2376: [11/14/2008 14:02:51] pass-thru args:
2376: [11/14/2008 14:02:51] processing user clamav
2376: [11/14/2008 14:02:51] uid = 207, euid = 207, gid = 207, egid = 1000
2376: [11/14/2008 14:02:51] loading preferences for user clamav
2376: [11/14/2008 14:02:51] Loading preferences for uid 1
2376: [11/14/2008 14:02:51] Loading preferences for uid 0
2376: [11/14/2008 14:02:51] Loading preferences for uid 0
2376: [11/14/2008 14:02:51] default preferences empty. reverting to 
dspam.conf preferences.
2376: [11/14/2008 14:02:51] Loading preferences from dspam.conf
2376: [11/14/2008 14:02:51] using 
/var/spool/dspam/opt-in/local/clamav.dspam as path
2376: [11/14/2008 14:02:51] using 
/var/spool/dspam/opt-out/local/clamav.nodspam as path
2376: [11/14/2008 14:02:51] sedation level set to: 0
2376: [11/14/2008 14:02:51] mysql_fetch_row() failed in _ds_get_signature
2376: [11/14/2008 14:02:51] DSPAM Instance Shutdown.  Exit Code: 0
 
failed on fetch_row

the /var/log/messages tells this =

Nov 14 14:02:51 kraftwerk1 imap: antispam: /usr/bin/dspam --source=error 
--class=spam --signature==?iso-8859-1?Q?491d76cb23581804284693=0D?= ...
Nov 14 14:02:51 kraftwerk1 dspam[2376]: Signature retrieval for 
'=?iso-8859-1?Q?491d76cb23581804284693=0D?=' failed
Nov 14 14:02:51 kraftwerk1 dspam[2376]: Unable to find a valid 
signature. Aborting.
Nov 14 14:02:51 kraftwerk1 dspam[2376]: process_message returned error 
-5.  dropping message.

when i search with phpmyadmin in the database the signatur 
491d76cb23581804284693 is there.

i really dont get it what can be wrong.

thanks

marko






Thorsten Vollmer schrieb:
> On Fri, 2008-11-14 at 11:40 +0100, Marko Weber wrote:
>   
>> Hello Thorsten , Hello All in List,
>>
>> i got to write again,
>> ok : dspam workinng , dovecot-antispam working
>>
>> moving mails to or out of spam seems to work and is listed in the logs;
>> BUT the logs shows this on moving a mail to or from spam =
>>
>>
>> Nov 14 11:31:57 kraftwerk1 imap: antispam: /usr/bin/dspam --source=error 
>> --class=innocent 
>> --signature==?iso-8859-1?Q?1,491d521770551288576733=0D?= ...
>> Nov 14 11:31:57 kraftwerk1 dspam[7203]: _ds_get_signature(): 
>> _mysql_drv_getpwuid(0) failed: aborting
>> Nov 14 11:31:57 kraftwerk1 dspam[7203]: Signature retrieval for 
>> '=?iso-8859-1?Q?1,491d521770551288576733=0D?=' failed
>> Nov 14 11:31:57 kraftwerk1 dspam[7203]: Unable to find a valid 
>> signature. Aborting.
>> Nov 14 11:31:57 kraftwerk1 dspam[7203]: process_message returned error 
>> -5.  dropping message.
>>
>> incoming mails are scanned by user clamav and mails are moved now by 
>> user clamav after the the Tip of  Thorsten adding this to dovecot.conf =
>>
>> antispam_dspam_args = --user;clamav
>>     
>
> I just realized that you enabled MySQLUIDInSignature. Thus specifying
> the user is not strictly necessary.
>
> You may also try to disable MySQLUIDInSignature.
>
>   
>> the following point in the logs  "mysql_drv_getpwuid(0)"  , looks for me 
>> like dspam tries with User-ID 0 to work,
>> but User clamav is in the mysql-db with User ID 1
>>
>> do i have to set any special entires in dovecot.conf or dspam.conf ?
>>
>> marko
>>     
>
>   

-- 

-- 
*Marko Weber* | Administration

*SALON DIGITAL* Media GmbH
Rothenbaumchaussee 19a
20148 Hamburg

T. (040) 429 48 68 - 23
F. (040) 429 48 68 - 20

marko.weber at salondigital.de <mailto:marko.weber at salondigital.de>
www.salondigital.de <http://www.salondigital.de>

--
Geschäftsführung: Stephan Michalik, Ekkehart Opitz
Registergericht: Amtsgericht Hamburg, NR: HRB 78111

NOTE: This communication is confidential and is intended for the use of 
the individual or entity to which it is directed. It may contain 
information that is privileged and exempt from disclosure under 
applicable law. If you are not the intended recipient please notify us 
immediately. You should not copy it or disclose its contents to any 
other person.