[Web-cyradm] Postfix/virtual problem

[Micky Del Favero]

I have a problem with virtual that i can't solve, in the log i read:

	Apr 28 09:25:43 bia postfix/virtual[25059]: fatal: bad string
	length (0 < 1): virtual_mailbox_base = 
	Apr 28 09:25:44 bia postfix/master[23021]: warning: process
	/usr/lib/postfix/virtual pid 25059 exit status 1 
	Apr 28 09:25:44 bia postfix/master[23021]: warning:
	/usr/lib/postfix/virtual: bad command startup -- throttling 

On the machine runs debian/sarge with postgres and postfix 2.0.16.

This is the main.cf

command_directory = /usr/sbin
daemon_directory = /usr/lib/postfix
program_directory = /usr/lib/postfix

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
setgid_group = postdrop
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no
myhostname = bia.example.com
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = bia.example.com
mydestination = bia.example.com, localhost
relayhost = 
mynetworks = 127.0.0.0/8
mailbox_command = /usr/bin/procmail
mailbox_size_limit = 0
recipient_delimiter = +
# 
# 
# 
proxy_read_maps = proxy:unix:passwd.byname 
        proxy:pgsql:/etc/postfix/pgsql-virtual.cf
        proxy:pgsql:/etc/postfix/pgsql-canonical.cf
        proxy:pgsql:/etc/postfix/pgsql-mydestination.cf
local_recipient_maps = proxy:unix:passwd.byname $alias_maps
virtual_maps = proxy:pgsql:/etc/postfix/pgsql-virtual.cf
# virtual_alias_domain = proxy:pgsql:/etc/postfix/pgsql-mydestination.cf
virtual_mailbox_domains = proxy:pgsql:/etc/postfix/pgsql-mydestination.cf
sender_canonical_maps = proxy:pgsql:/etc/postfix/pgsql-canonical.cf
mailbox_transport = lmtp:unix:/var/run/cyrus/socket/lmtp
# fallback_transport = lmtp:unix:/var/run/cyrus/socket/lmtp
disable_vrfy_command = yes
# 
# 
# 
smtpd_use_tls = yes
smtp_use_tls = yes
smtpd_tls_auth_only = yes
smtpd_tls_key_file = /etc/postfix/newkey.pem
smtpd_tls_cert_file = /etc/postfix/newcert.pem
smtpd_tls_CAfile = /etc/postfix/cacert.pem
smtpd_tls_loglevel = 1
smtpd_tls_received_header = yes
smtpd_tls_session_cache_timeout = 3600s
tls_random_source = dev:/dev/urandom
relay_clientcerts = hash:/etc/postfix/relay_clientcerts
smtpd_tls_ask_ccert = yes
# smtpd_recipient_restrictions = permit_mynetworks,
	permit_sasl_authenticated, permit_tls_clientcerts,
	check_relay_domains 
smtpd_recipient_restrictions = permit_mynetworks,
	permit_tls_clientcerts, reject_unauth_destination

this is pgsql-virtual.cf:
# 
hosts = 127.0.0.1
user = mail
password = xxxxxx
dbname = mail
table = virtual
select_field = dest
where_field = alias
additional_conditions = and status = '1'

this is pgsql-canonical.cf:
# 
hosts = 127.0.0.1
user = mail
password = xxxxxx
dbname = mail
table = virtual
select_field = alias
where_field = username
additional_conditions = and status = '1' limit 1

and this is pgsql-mydestination.cf:
# 
hosts = 127.0.0.1
user = mail
password = xxxxxx
dbname = mail
table = domain
select_field = domain_name
where_field = domain_name

Many thanks for you help, Micky
-- 
Micky Del Favero  micky at mesina.net  micky at linux.it
Linux Registered User #78384 http://counter.li.org