Am 2012-07-20 14:53, schrieb rodrigo tavares:
> 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 denied dspam_preferences#012: see sql.errors for more
details
> Jul 19 15:16:21 defensoria dspam[30456]: query error: ERROR:
permission denied dspam_virtual_uids#012: see sql.errors for more
details
> Jul 19 15:16:21 defensoria dspam[30456]: query error: ERROR:
permission denied dspam_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 denied
dspam_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 ?
How have you created the tables?
What commands did you use?
What output do you get in pgsql when you
run:
1) d+ dspam_virtual_uids;
2) d dspam_virtual_uids;
> Best
regards,
> Rodrigo Faria
--
Kind Regards from Switzerland,
Stevan
Bajić
------------------------------------------------------------------------------
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
