List Info

Thread: Amavisd-new on FreeBSD




Amavisd-new on FreeBSD
country flaguser name
Germany
2007-03-19 05:02:53
Hello,

	
I have a problem with amavisd new (Maia) with which I simply
do not get ahead.

<code>
Mar 19 00:59:31 home postfix/smtp[5577]: E0AF71D0D2:
to=<roothome.silviosiefke.de>,
orig_to=<root>, relay=127.0.0.1[127.0.0.1]:10024,
delay=3570,
delays=3568/0.04/2.3/0.1,
dsn=4.4.2, status=deferred (lost connection with
127.0.0.1[127.0.0.1] while
sending RCPT TO)
</code>

To a few searches the thought of the Perlmodules DBD came::
Mysql. In
addition, after the new installation the problem did not
put.

/usr/local/sbin/amavisd debug > http://home.s
ilviosiefke.de/postfix.txt

I do not continue to know no more

postconf -n
alias_database = hash:/etc/mail/aliases
alias_maps = hash:/etc/mail/aliases
broken_sasl_auth_clients = yes
command_directory = /usr/local/sbin
config_directory = /usr/local/etc/postfix
content_filter = smtp-amavis:127.0.0.1:10024
daemon_directory = /usr/local/libexec/postfix
home_mailbox = maildir/
html_directory = no
mail_owner = postfix
mailq_path = /usr/local/bin/mailq
manpage_directory = /usr/local/man
mydestination = $myhostname, home.silviosiefke.de,
listen.hserver.info
myhostname = home.silviosiefke.de
mynetworks = 127.0.0.0/8, 192.168.0.0/24
newaliases_path = /usr/local/bin/newaliases
queue_directory = /var/spool/postfix
readme_directory = no
sample_directory = /usr/local/etc/postfix
sendmail_path = /usr/local/sbin/sendmail
setgid_group = maildrop
smtp_tls_note_starttls_offer = yes
smtp_use_tls = yes
smtpd_recipient_restrictions = permit_mynetworks,
permit_sasl_authenticated,  reject_non_fqdn_hostname,
reject_non_fqdn_sender,  reject_non_fqdn_recipient,
reject_unauth_destination,  reject_unauth_pipelining,
reject_invalid_hostname,  check_sender_access
hash:/usr/local/etc/postfix/spam/sender_access 
reject_rbl_client
opm.blitzed.org,  reject_rbl_client list.dsbl.org, 
reject_rbl_client
bl.spamcop.net,  reject_rbl_client sbl-xbl.spamhaus.org
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain =
smtpd_sasl_security_options = noanonymous
smtpd_tls_CAfile = /usr/local/etc/postfix/ssl/smtpd.pem
smtpd_tls_cert_file = /usr/local/etc/postfix/ssl/smtpd.pem
smtpd_tls_key_file = /usr/local/etc/postfix/ssl/smtpd.pem
smtpd_tls_loglevel = 0
smtpd_tls_received_header = yes
smtpd_tls_session_cache_timeout = 3600s
smtpd_use_tls = yes
tls_random_source = dev:/dev/urandom
transport_maps = hash:/usr/local/etc/postfix/transport
unknown_local_recipient_reject_code = 550
virtual_alias_maps =
proxy:mysql:/usr/local/etc/postfix/mysql/mysql_virtual_alias
_maps.cf
virtual_create_maildirsize = yes
virtual_gid_maps = static:125
virtual_mailbox_base = /usr/local/virtual
virtual_mailbox_domains =
proxy:mysql:/usr/local/etc/postfix/mysql/mysql_virtual_domai
ns_maps.cf
virtual_mailbox_limit = 51200000
virtual_mailbox_limit_maps =
proxy:mysql:/usr/local/etc/postfix/mysql/mysql_virtual_mailb
ox_limit_maps.cf
virtual_mailbox_maps =
proxy:mysql:/usr/local/etc/postfix/mysql/mysql_virtual_mailb
ox_maps.cf
virtual_minimum_uid = 125
virtual_transport = virtual
virtual_uid_maps = static:125

master.cf
smtp      inet  n       -       n       -       -      
smtpd
smtp-amavis unix -      -       n       -       4  	 smtp
  -o smtp_data_done_timeout=1200
  -o disable_dns_lookups=yes
127.0.0.1:10025 inet n  -       n       -       -  	 smtpd
  -o content_filter=
  -o local_recipient_maps=
  -o smtpd_helo_restrictions=
  -o smtpd_client_restrictions=
  -o smtpd_sender_restrictions=
  -o smtpd_recipient_restrictions=permit_mynetworks,reject
  -o mynetworks=127.0.0.0/8
pickup    fifo  n       -       n       60      1      
pickup
cleanup   unix  n       -       n       -       0      
cleanup
qmgr      fifo  n       -       n       300     1      
qmgr
tlsmgr    unix  -       -       n       1000?   1      
tlsmgr
rewrite   unix  -       -       n       -       -      
trivial-rewrite
bounce    unix  -       -       n       -       0      
bounce
defer     unix  -       -       n       -       0      
bounce
trace     unix  -       -       n       -       0      
bounce
verify    unix  -       -       n       -       1      
verify
flush     unix  n       -       n       1000?   0      
flush
proxymap  unix  -       -       n       -       -      
proxymap
smtp      unix  -       -       n       -       -      
smtp
relay     unix  -       -       n       -       -      
smtp
	-o fallback_relay=
showq     unix  n       -       n       -       -      
showq
error     unix  -       -       n       -       -      
error
discard   unix  -       -       n       -       -      
discard
local     unix  -       n       n       -       -      
local
virtual   unix  -       n       n       -       -      
virtual
lmtp      unix  -       -       n       -       -      
lmtp
anvil     unix  -       -       n       -       1      
anvil
scache	  unix	-	-	n	-	1	scache
maildrop  unix  -       n       n       -       -      
pipe
  flags=DRhu user=vmail argv=/usr/local/bin/maildrop -d
$
old-cyrus unix  -       n       n       -       -      
pipe
  flags=R user=cyrus argv=/cyrus/bin/deliver -e -m
$ $
cyrus     unix  -       n       n       -       -      
pipe
  user=cyrus argv=/cyrus/bin/deliver -e -r $ -m
$ $
uucp      unix  -       n       n       -       -      
pipe
  flags=Fqhu user=uucp argv=uux -r -n -z -a$sender -
$nexthop!rmail
($recipient)
ifmail    unix  -       n       n       -       -      
pipe
  flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop
($recipient)
bsmtp     unix  -       n       n       -       -      
pipe
  flags=Fq. user=foo argv=/usr/local/sbin/bsmtp -f $sender
$nexthop $recipient
vacation  unix  -       n       n       -       -      
pipe
  flags=DRhu user=vacation
argv=/var/spool/vacation/vacation.pl


Test:
home# telnet localhost 25
Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
Connected to localhost.silviosiefke.de.
Escape character is '^]'.
220 home.silviosiefke.de ESMTP Postfix

home# telnet localhost 10024
Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
Connected to localhost.silviosiefke.de.
Escape character is '^]'.
220 [127.0.0.1] ESMTP amavisd-maia service ready

home# telnet localhost 10025
Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
Connected to localhost.silviosiefke.de.
Escape character is '^]'.
220 home.silviosiefke.de ESMTP Postfix

Thanks for help!

System:
FreeBSD 6.2, Postfix 2.3.8, Maia 1.0.2, Mysql Server
4.1.22,
SpamAssassin 3.1.8


Kind Regards
Silvio Siefke

------------------------------------------------------------
-------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the
chance to share your
opinions on IT & business topics through brief
surveys-and earn cash
http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user

AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/

Re: Amavisd-new on FreeBSD
country flaguser name
Slovenia
2007-03-19 06:52:12
Silvio,

> FreeBSD 6.2, Postfix 2.3.8, Maia 1.0.2, Mysql Server
4.1.22,
> SpamAssassin 3.1.8

(05633-01) lookup_sql select: SELECT *,users.id 
  FROM users,policy WHERE (users.policy_id=policy.id) AND
  (users.email IN (?,?,?,?,?,?)) ORDER BY users.priority
DESC

(05633-01) lookup_sql: 1030, Got error 1 from storage
engine

(05633-01) TROUBLE in process_request:  DBD::mysql::st
execute failed:
  Got error 1 from storage engine at (eval 53) line 258

Looks like something is wrong with your database or SQL
server.
Try to determine what "1030, Got error 1 from storage
engine"
means for Mysql Server 4.1.22. Perhaps your database has
grown over 4 GB.


The following needs fixing too:

>amavisd[5632]: SpamControl: initializing
Mail::SpamAssassin
>  bayes: database version 0 is different than we
understand (3), aborting!
>  at
/usr/local/lib/perl5/site_perl/5.8.8/Mail/SpamAssassin/Bayes
Store/SQL.pm
>  line 136.


Mark

------------------------------------------------------------
-------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the
chance to share your
opinions on IT & business topics through brief
surveys-and earn cash
http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user

AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/

[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )