Hi Steven,
I change module for libhash, then i receive the menssage: Spam Filtering is
Active.
What things can I do for dspam learning each more.
Good By !
Rodrigo
________________________________
De: Stevan Bajić <ste...@bajic.ch>
Para: dspam-user@lists.sourceforge.net
Enviadas: Sexta-feira, 20 de Julho de 2012 11:32
Assunto: Re: [Dspam-user] Troubles with permission denied dspam-preferences
Am 2012-07-20 15:41, schrieb rodrigo tavares:
Hello Stevan,
Hello Rodrigo,
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
This is wrong. You can not just import the pgsql_objects.sql that way into
PostgreSQL. I think the documentation of the DSPAM PostgreSQL driver is
explaining how to create that the proper way.
At least you must have something like this:
\\set ON_ERROR_STOP = on;
CREATE USER [DSPAM_USER_NAME_HERE] WITH PASSWORD '[DSPAM_USER_PASSWORD_HERE]'
NOCREATEDB NOCREATEUSER;
CREATE DATABASE [DSPAM_DB_NAME_HERE];
GRANT ALL PRIVILEGES ON DATABASE [DSPAM_DB_NAME_HERE] TO [DSPAM_USER_NAME_HERE];
GRANT ALL PRIVILEGES ON SCHEMA public TO [DSPAM_USER_NAME_HERE];
UPDATE pg_database SET datdba=(SELECT usesysid FROM pg_shadow WHERE
usename='[DSPAM_USER_NAME_HERE]') WHERE datname='[DSPAM_DB_NAME_HERE]';
\\c [DSPAM_DB_NAME_HERE];
CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler AS
'$libdir/plpgsql', 'plpgsql_call_handler' LANGUAGE c;
CREATE FUNCTION plpgsql_validator(oid) RETURNS void AS '$libdir/plpgsql',
'plpgsql_validator' LANGUAGE c;
CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler
VALIDATOR plpgsql_validator;
And then you import the SQL file with
psql -d [DSPAM_DB_NAME_HERE] -U [DSPAM_USER_NAME_HERE] < pgsql_objects.sql
psql -d [DSPAM_DB_NAME_HERE] -U [DSPAM_USER_NAME_HERE] < virtual_users.sql
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 !
Please read the documentation. It should have the info you need for creating
that PostgreSQL database.
Rodrigo Faria
>
>________________________________
>De: Stevan Bajić
>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
>
>
>
--
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
