All,
I have a slight problem with amavis and per user settings in a mysql
database. I have created the tables from the sql readme doc that
came with amavis and granted SELECT to the user that is configured in
amavisd,conf as follows...
@lookup_sql_dsn = (
['DBI:mysql:database=amavisd;host=127.0.0.1;port=3306','amavisfilter','g
wyllanfro']
);
Postfix is the mailer and it passes all mail from the internet
through to port 10024 for amavis to do its stuff. I have inserted
one user and one policy into the database for testing.
Prior to trying to implement per user the amavisd,conf file was set
up with my default settings, all i did was enable the lookup_sql....
setting.
DBD DBI and everything is installed as I use this with other perl
scripts also.
I can connect to the db and if amavisd is in debug mode I can see a
success there too!!!!
But postfix THROTTLES itself when I enable lookup_sql_dsn...
Here are some logs. Please can someone help...
AMAVIS debug
ESMTP< MAIL FROM:<[EMAIL PROTECTED]> SIZE=1227\r\n
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) switch_to_my_time 480 s, SMTP MAIL received
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) check_mail_begin_task: task_count=1
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) TempDir::prepare: creating directory /home/amavis/tmp/
amavis-20070212T221448-67855
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) TempDir::prepare_file: creating file /home/amavis/tmp/
amavis-20070212T221448-67855/email.txt
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) lookup (debug_sender) => undef, "[EMAIL PROTECTED]" does
not match
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) ESMTP> 250 2.1.0 Sender [EMAIL PROTECTED] OK
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) switch_to_client_time 480 s, smtp response sent
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) idle_proc, 6: was busy, 3.5 ms, total idle 0.005 s, busy
0.017 s
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) idle_proc, 5: was idle, 2.9 ms, total idle 0.008 s, busy
0.017 s
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) ESMTP< RCPT TO:<ian@ domain.net> ORCPT=rfc822;ian@
domain.net\r\n
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) switch_to_my_time 480 s, SMTP RCPT received
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) lookup_acl(ian@ domain.net) matches key ". domain.net",
result=1
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) lookup (local_domains) => true, "ian@ domain.net"
matches, result="1", matching_key=". domain.net"
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) query_keys: [EMAIL PROTECTED], ian, @ domain.net, @.
domain.net, @.net, @.
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) lookup_sql "ian@ domain.net", query args: "ian@
domain.net", "ian", "@ domain.net", "@. domain.net", "@.net", "@."
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) lookup_sql select: SELECT *,users.id FROM users LEFT JOIN
policy ON users.policy_id=policy.id WHERE users.email IN
(?,?,?,?,?,?) ORDER BY users.priority DESC
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) sql begin, nontransaction
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) Connecting to SQL database server
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) connect_to_sql: trying
'DBI:mysql:database=amavisdPolicies;host=127.0.0.1;port=3306'
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67854]:
(67854-01) connect_to_sql:
'DBI:mysql:database=amavisdPolicies;host=127.0.0.1;port=3306' succeeded
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67854]:
(67854-01) sql: preparing and executing: SELECT *,users.id FROM users
LEFT JOIN policy ON users.policy_id=policy.id WHERE users.email IN
(?,?,?,?,?,?) ORDER BY users.priority DESC
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67852]:
Net::Server: Starting "1" children
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) connect_to_sql:
'DBI:mysql:database=amavisdPolicies;host=127.0.0.1;port=3306' succeeded
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67855]:
(67855-01) sql: preparing and executing: SELECT *,users.id FROM users
LEFT JOIN policy ON users.policy_id=policy.id WHERE users.email IN
(?,?,?,?,?,?) ORDER BY users.priority DESC
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67987]:
Net::Server: Child Preforked (67987)
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67987]:
TIMING [total 14 ms] - bdb-open: 14 (100%)100, rundown: 0 (0%)100
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67852]:
Net::Server: Starting "1" children
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67988]:
Net::Server: Child Preforked (67988)
Feb 12 22:14:48 mail. domain.net /usr/local/bin/amavisd[67988]:
TIMING [total 7 ms] - bdb-open: 7 (100%)100, rundown: 0 (0%)100
maillog
Feb 12 22:14:48 freebsd postfix/qmgr[67982]: 3DE6317EBC:
from=<[EMAIL PROTECTED]>, size=1249, nrcpt=1 (queue active)
Feb 12 22:14:48 freebsd postfix/qmgr[67982]: E046617ED9:
from=<[EMAIL PROTECTED]>, size=1227, nrcpt=1 (queue active)
Feb 12 22:14:48 freebsd postfix/smtp[67984]: 3DE6317EBC:
to=<[EMAIL PROTECTED]>, relay=127.0.0.1[127.0.0.1]:10024, delay=2408,
delays=2408/0.02/0.02/0.04, dsn=4.4.2, status=deferred (lost con$
Feb 12 22:14:48 freebsd postfix/smtp[67984]: warning: connect to
mysql server localhost: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)
Feb 12 22:14:48 freebsd postfix/smtp[67984]: fatal: mysql:/etc/
postfix/sql/transport(0,lock|fold_fix): table lookup problem
Feb 12 22:14:48 freebsd postfix/smtp[67985]: E046617ED9:
to=<[EMAIL PROTECTED]>, relay=127.0.0.1[127.0.0.1]:10024, delay=2325,
delays=2325/0.03/0.02/0.06, dsn=4.4.2, status=deferred (lost con$
Feb 12 22:14:48 freebsd postfix/smtp[67985]: warning: connect to
mysql server localhost: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)
Feb 12 22:14:48 freebsd postfix/smtp[67985]: fatal: mysql:/etc/
postfix/sql/transport(0,lock|fold_fix): table lookup problem
Feb 12 22:14:48 freebsd postfix/smtp[67985]: warning: connect to
mysql server localhost: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)
Feb 12 22:14:48 freebsd postfix/smtp[67985]: fatal: mysql:/etc/
postfix/sql/transport(0,lock|fold_fix): table lookup problem
ip=[85.210.30.141], headers=0, body=0, rcvd=272, sent=1295, time=83,
starttls=1
Feb 12 22:14:49 freebsd postfix/qmgr[67982]: warning: premature end-
of-input on private/smtp-amavis socket while reading input attribute
name
Feb 12 22:14:49 freebsd postfix/qmgr[67982]: warning: private/smtp-
amavis socket: malformed response
Feb 12 22:14:49 freebsd postfix/qmgr[67982]: warning: transport smtp-
amavis failure -- see a previous warning/fatal/panic logfile record
for the problem description
Feb 12 22:14:49 freebsd postfix/master[67980]: warning: process /usr/
libexec/postfix/smtp pid 67984 exit status 1
Feb 12 22:14:49 freebsd postfix/master[67980]: warning: /usr/libexec/
postfix/smtp: bad command startup -- throttling
Feb 12 22:14:49 freebsd postfix/qmgr[67982]: 3DE6317EBC: to=<ian@
domain.net>, relay=none, delay=2409, delays=2408/1.2/0/0, dsn=4.3.0,
status=deferred (unknown mail transport error)
Feb 12 22:14:49 freebsd postfix/qmgr[67982]: warning: premature end-
of-input on private/smtp-amavis socket while reading input attribute
name
Feb 12 22:14:49 freebsd postfix/qmgr[67982]: warning: private/smtp-
amavis socket: malformed response
Feb 12 22:14:49 freebsd postfix/qmgr[67982]: warning: transport smtp-
amavis failure -- see a previous warning/fatal/panic logfile record
for the problem description
Feb 12 22:14:49 freebsd postfix/master[67980]: warning: process /usr/
libexec/postfix/smtp pid 67985 exit status 1
Feb 12 22:14:49 freebsd postfix/qmgr[67982]: E046617ED9: to=<ian@
domain.net>, relay=none, delay=2326, delays=2325/1.2/0/0, dsn=4.3.0,
status=deferred (unknown mail transport error)
Any help would be very appreciated,
Thanks, Ian
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
