On 20.07.2012 18:28, rodrigo tavares wrote:
Hi Steven,
Hello Rodrigo,
I change module for libhash,
what? You changed from using PostgreSQL backend to Hash backend. Why?
then i receive the menssage: Spam Filtering is Active.
Okay.
What things can I do for dspam learning each more.
I don't understand this. What do you mean?
Good By !
Rodrigo
--
Kind Regards from Switzerland,
Stevan Bajić
------------------------------------------------------------------------
*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 denieddspam_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
<mailto: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 <mailto: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
