Hello People,
I configured the DSPAM. When I try to send one email for other user, com this
message.
Jul 19 15:16:21 defensoria dspam[30456]: query error:
ERROR: permission denied dspam_preferences#012: see
sql.errors for more details
Jul 19 15:16:21 defensoria dspam[30456]: query error: ERROR: permission
denieddspam_preferences#012: see sql.errors for more
details
Jul 19 15:16:21 defensoria dspam[30456]: query error: ERROR: permission
denieddspam_virtual_uids#012: see sql.errors for more details
Jul 19 15:16:21 defensoria dspam[30456]: query error: ERROR: permission
denieddspam_virtual_uids#012: see sql.errors for more
details
Jul 19 15:16:21 defensoria dspam[30456]: bailing on error -2
Jul 19 15:16:21 defensoria dspam[30456]: received invalid result (!DSR_ISSPAM
&& !DSR_ISINNOCENT): -2
Jul 19 15:16:21 defensoria dspam[30456]: query error: ERROR: permission
denieddspam_virtual_uids#012: see sql.errors for more
details
Jul 19 15:16:21 defensoria dspam[30456]: process_message returned error -5.
delivering.
Come this logs:
[07/20/2012 09:28:10] 6446: ERRO: permission denied dspam_virtual_uids
: SELECT uid FROM dspam_virtual_uids WHERE username=E'rodrigofar...@gmail.com'
See my config:
root@debian-expresso:/var/log/dspam# ps ax | grep dspam
6446 pts/0 S 0:00 /usr/bin/dspam -- --daemon
6447 ? Ss 0:00 postgres: dspam dspam 127.0.0.1(56779)
idle
6448 ? Ss 0:00 postgres: dspam dspam 127.0.0.1(56780)
idle
6449 ? Ss 0:00 postgres: dspam dspam 127.0.0.1(56781)
idle
8208 pts/0 S+ 0:00 tail -f /var/log/dspam/sql.errors
8217 ? Ss 0:00 postgres: postgres dspam 10.26.7.136(50198)
idle
8376 pts/1 S+ 0:00 grep dspam
root@debian-expresso:/var/log/dspam# netstat -an | grep 10033
tcp 0 0 127.0.0.1:10033 0.0.0.0:* LISTE
root@debian-expresso:/var/log/dspam# netstat -an | grep 10034
tcp 0 0 127.0.0.1:10034 0.0.0.0:* LISTEN
How I Can to resolve this problem ?
Best regards,
Rodrigo Faria
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user
