Hello Stevan,
I make the wrong command in other base in Postrgres. Next make in bd dspam
dspam=> \d
Lista de relações
Esquema | Nome | Tipo | Dono
---------+------------------------+------------+----------
public | dspam_preferences | tabela | postgres
public | dspam_signature_data | tabela | postgres
public | dspam_stats | tabela | postgres
public | dspam_token_data | tabela | postgres
public | dspam_virtual_uids | tabela | postgres
public | dspam_virtual_uids_seq | sequência | postgres
(6 registros)
dspam=> \d+
Lista de relações
Esquema | Nome | Tipo | Dono | Tamanho |
Descrição
---------+------------------------+------------+----------+------------+-------------
public | dspam_preferences | tabela | postgres | 0 bytes |
public | dspam_signature_data | tabela | postgres | 0 bytes |
public | dspam_stats | tabela | postgres | 0 bytes |
public | dspam_token_data | tabela | postgres | 0 bytes |
public | dspam_virtual_uids | tabela | postgres | 0 bytes |
public | dspam_virtual_uids_seq | sequência | postgres | 8192 bytes |
(6 registros)
Is there more some information ?
Thanks !
Rodrigo Faria Tavares
________________________________
De: rodrigo tavares <rodrigofar...@yahoo.com.br>
Para: Stevan Bajić <ste...@bajic.ch>; "dspam-user@lists.sourceforge.net"
<dspam-user@lists.sourceforge.net>
Enviadas: Sexta-feira, 20 de Julho de 2012 10:41
Assunto: Re: [Dspam-user] Troubles with permission denied dspam-preferences
Hello Stevan,
Them, i login with postgres user. See the results.
postgres=# \d dspam_virtual_uids;
Not found none relation called "dspam_virtual_uids".
postgres=# \d+ dspam_virtual_uids;
Not found none relation called "dspam_virtual_uids".
Now, i try to recreate tables:
postgres@debian-expresso:~$ psql -u dspam < pgsql_objects.sql
/usr/lib/postgresql/8.4/bin/psql: invalid option -- 'u'
Try "psql --help" to obter information adition.
postgres@debian-expresso:~$ psql dspam < pgsql_objects.sql
ERROR: relation "dspam_token_data" exist
ERROR: relation "dspam_signature_data" exist
ERROR: relation "dspam_stats" já existe
ERROR: relation
"dspam_preferences" já existe
ERROR: function "lookup_tokens" yet existe with sames argument types
ERROR: funtion "lookup_tokens" yet existe with sames argument types
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ANALYZE
postgres@debian-expresso:~$ psql dspam <
8.4/ .bash_history pgsql_objects.sql .psql_history
.viminfo virtual_users.sql
postgres@debian-expresso:~$ psql dspam < virtual_users.sql
ERROR: relation "dspam_virtual_uids_seq" yet exist
ERROR: relation "dspam_virtual_uids" yet existe
ERROR: relation "id_virtual_uids_01" yet existe
ERROR: relation "id_virtual_uids_02"yet existe
Thanks !
Rodrigo Faria
________________________________
De: Stevan Bajić <ste...@bajic.ch>
Para: dspam-user@lists.sourceforge.net
Enviadas: Sexta-feira, 20 de Julho de 2012 10:14
Assunto: Re: [Dspam-user] Troubles with permission denied dspam-preferences
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
>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 ?
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
------------------------------------------------------------------------------
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
------------------------------------------------------------------------------
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
