Sorry for my persistence.
Resume of my steps:
1.- Update from subversion r422. Replaced files :
cluebringer/trunk/cbpadmin
cluebringer/trunk/cbpolicyd
cluebringer/trunk/cbp/*
cluebringer/trunk/cluebringer.conf
2.- Patched "amavisd-new-2.5.4" with
"amavisd-new-2.5.3_policyd-200802070918.patch".
Updated cluebringer/trunk/contrib/amavisd-policyd.pm
3.- Added include_config_files("...") at amavisd.conf with
amavisd-policyd.pm path
4.- Attached my clueringer.conf
Now I get this error at maillog:
Feb 24 19:56:34 mail amavis[31028]: (31028-01) (!!)[TRACKING] ERROR:
Failed to select session tracking info: cbp::dblayer::DBSelect(111):
Error executing select '\n\t\tSELECT\n\t\t\tInstance,
QueueID,\n\t\t\tUnixTimestamp,\n\t\t\tClientAddress, ClientName,
ClientReverseName,\n\t\t\tProtocol,\n\t\t\tEncryptionPr
otocol, EncryptionCipher, EncryptionKeySize,\n\t\t\tSASLMethod,
SASLSender,
SASLUsername,\n\t\t\tHelo,\n\t\t\tSender,\n\t\t\tSize,\n\t\t\tRecipientData\n\t\tFROM\n\t\t\tsession_tracking\n\t\tWHERE\n\t\t\tQueueID
= ?\n\t\t\tAND ClientAddress = ?\n\t\t\tAND Sender = ?\n\t\t': no such
table: session_tracking(1) at dbdimp.c line 271
Feb 24 19:56:34 mail amavis[31028]: (31028-01)
(!)policyd/process_policy: No session data found
And at policyd.log shows that amavis module doesn't start:
[2009/02/24-19:46:43 - 30706] [CBPOLICYD] NOTICE: Policyd v2 /
Cluebringer - v2.1.0a
[2009/02/24-19:46:43 - 30706] [CBPOLICYD] NOTICE: Initializing system
modules.
[2009/02/24-19:46:43 - 30706] [CBPOLICYD] NOTICE: System modules
initialized.
[2009/02/24-19:46:43 - 30706] [CBPOLICYD] NOTICE: Module load started...
[2009/02/24-19:46:43 - 30706] [CORE] NOTICE: => AccessControl: enabled
[2009/02/24-19:46:43 - 30706] [CORE] NOTICE: => Accounting: enabled
[2009/02/24-19:46:44 - 30706] [CORE] NOTICE: => CheckHelo: enabled
[2009/02/24-19:46:44 - 30706] [CORE] NOTICE: => CheckSPF: enabled
[2009/02/24-19:46:44 - 30706] [CORE] NOTICE: => Greylisting: enabled
[2009/02/24-19:46:44 - 30706] [CORE] NOTICE: => Quotas: enabled
[2009/02/24-19:46:44 - 30706] [CORE] NOTICE: => Protocol(Postfix): enabled
[2009/02/24-19:46:44 - 30706] [CORE] NOTICE: => Protocol(Bizanga): enabled
[2009/02/24-19:46:44 - 30706] [CBPOLICYD] NOTICE: Module load done.
I use mysql database. I observed that policyd is putting info into
database. There are data at session_tracking table.
Be patient with me!
Regards.
-=AJ=-
Nigel Kukard escribió:
Updated to r421 and patched amavisd, but same error at maillog when
amavisd analises a mail:
Feb 23 10:40:05 mail amavis[12917]: (12917-08) (!!)[TRACKING] ERROR: No
session data
Feb 23 10:40:05 mail amavis[12917]: (12917-08)
(!)policyd/process_policy: No session data found
I also get that :
Feb 23 10:51:20 mail amavis[12917]: (12917-17)
(!)policyd/process_policy: Failed to parse in queue id from received
line ' from Servidor (xx.xx.xx.xx)\n\tby mail.example.com (Postfix) with
ESMTPA id 82E1484DF40;\n\tMon, 23 Feb 2009 10:51:20 +0100 (CET)\n'
Where does the A come from in ESMTPA? thats definitely the problem. The
Received lines are parsed to determine the queue ID, this is then looked
up in the database.
Can be that Amavis module isn't loaded?. That my policyd log at start:
[2009/02/23-10:53:45 - 14428] [CBPOLICYD] NOTICE: Module load started...
[2009/02/23-10:53:45 - 14428] [CORE] NOTICE: => AccessControl: enabled
[2009/02/23-10:53:45 - 14428] [CORE] NOTICE: => CheckHelo: enabled
[2009/02/23-10:53:45 - 14428] [CORE] NOTICE: => Greylisting: enabled
[2009/02/23-10:53:45 - 14428] [CORE] NOTICE: => Quotas: enabled
[2009/02/23-10:53:45 - 14428] [CORE] NOTICE: => Accounting: enabled
[2009/02/23-10:53:45 - 14428] [CORE] NOTICE: => Protocol(Postfix): enabled
[2009/02/23-10:53:45 - 14428] [CORE] NOTICE: => Protocol(Bizanga): enabled
[2009/02/23-10:53:45 - 14428] [CBPOLICYD] NOTICE: Module load done.
Are you very sure you installed r421 and all its associated files?
-N
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users
#
# Server configuration
#
[server]
# Protocols to load
protocols=<<EOT
Postfix
Bizanga
EOT
# Modules to load
modules=<<EOT
Core
AccessControl
Accounting
Amavis
CheckHelo
CheckSPF
Greylisting
Quotas
EOT
# User to run this daemon as
#user=
#group=
# Filename to store pid of parent process
#pid_file=/var/run/cbpolicyd.pid
# Uncommenting the below option will prevent cbpolicyd going into the background
#background=no
# Preforking configuration
#
# min_server - Minimum servers to keep around
# min_spare_servers - Minimum spare servers to keep around ready to
# handle requests
# max_spare_servers - Maximum spare servers to have around doing nothing
# max_servers - Maximum servers alltogether
# max_requests - Maximum number of requests each child will serve
#
# One may want to use the following as a rough guideline...
# Small mailserver: 2, 2, 4, 10, 1000
# Medium mailserver: 4, 4, 12, 25, 1000
# Large mailserver: 8, 8, 16, 64, 1000
#
#min_servers=4
#min_spare_servers=4
#max_spare_servers=12
#max_servers=25
#max_requests=1000
# Log level:
# 0 - Errors only
# 1 - Warnings and errors
# 2 - Notices, warnings, errors
# 3 - Info, notices, warnings, errors
# 4 - Debugging
log_level=4
# File to log to instead of stdout
log_file=/var/log/cbpolicyd.log
# Log destination for mail logs...
# main - log to policyd's main log mechanism
# maillog - log mail via syslog
log_mail=maillog
# Things to log in extreme detail
# modules - Log detailed module running information
# tracking - Log detailed tracking information
# policies - Log policy resolution
# protocols - Log general protocol info, but detailed
# bizanga - Log the bizanga protocol
#
# There is no default for this configuration option. Options can be
# separated by commas. ie. protocols,modules
#
log_detail=modules
# Protocol to use "tcp" or "unix", defaults to "tcp"
proto=tcp
# IP to listen on, * for all. Blank for unix sockets
host=*
# Port to run on, in the case of a unix socket it would be the path
# eg. 10031
# eg. /var/run/cbpolicyd/policyd.sock
port=10031
# Timeout in communication with clients, defaults to 120s
#timeout=120
# cidr_allow/cidr_deny
# Comma, whitespace or semi-colon separated. Contains a CIDR block to
# compare the clients IP to. If cidr_allow or cidr_deny options are
# given, the incoming client must match a cidr_allow and not match a
# cidr_deny or the client connection will be closed.
#cidr_allow=0.0.0.0/0
#cidr_deny=
[database]
#DSN=DBI:SQLite:dbname=cluebringer.sqlite
DSN=DBI:mysql:database=policyd;host=localhost
Username=policyd
Password=policydpassword
#
# What do we do when we have a database connection problem
# tempfail - Return temporary failure
# pass - Return success
bypass_mode=tempfail
# How many seconds before we retry a DB connection
bypass_timeout=30
# Table prefix to use, be sure to generate the schema with the table
# prefix aswell!
#table_prefix=
# Access Control module
[AccessControl]
enable=1
# Accounting module
[Accounting]
enable=1
# Amavis module
[Amavis]
enable=1 # Disabled by default
# CheckHelo module
[CheckHelo]
enable=1
# CheckSPF module
[CheckSPF]
enable=1
# Greylisting module
[Greylisting]
enable=1
#training_mode=1
#defer_message=Greylisting in effect, please come back later
#blacklist_message=Greylisting in effect, sending server blacklisted
# Quotas module
[Quotas]
enable=1
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users
