From: Mads N. Vestergaard (no email)
Date: Sun Aug 01 2004 - 03:35:34 EDT
Hi, guys.
I have a litle problem, i've configured my postfix, so it should support
virtual users via mysql. The guide i followed is:
http://www.perseus.dk/linux/howto/postfix/, but is a danish translation
of a few guides on the net, but the virtual stuff and mysql is similar
to http://high5.net/howto/.
The problem is when it receives an email, is does all the database
querys, if the mail is surposed to be forwarded it works just fine.
But when its a mailbox user, it make the query(see query 211, form
mysql.log), and i tried to execute the query myself in mysql, and it is
executed correctly, but the mail isn't processed to the mail dir, but is
in the active queue, i.e. /var/spool/postfix/active/4/4752C99ED .
I'm not sure, but i don't think the messages in mail.err and mail.warn
has something to do with the problem, but i've included them for debug
purpose.
My /usr/local/virtual/ directory is chowned to 104.105
(postfix.posstfix), and chmoded to 771.
I really hope you can help me with this problem.
postconf -n
------------------------------------------------------------------------
append_dot_mydomain = no
biff = no
config_directory = /etc/postfix
myhostname = rwxr-xr-x.dk
mynetworks = 127.0.0.1/8, 217.122.186.108
smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = postfix:105
virtual_mailbox_base = /usr/local/virtual
virtual_mailbox_domains =
mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_limit = 51200000
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 104
virtual_transport = virtual
virtual_uid_maps = postfix:105
------------------------------------------------------------------------
Cut out from mail.info
------------------------------------------------------------------------
Aug 1 08:57:40 rwxr-xr-x postfix/smtpd[22085]: connect from
cc315005-a.ensch1.ov.home.nl[217.122.186.108]
Aug 1 08:57:40 rwxr-xr-x postfix/smtpd[22085]: 4752C99ED:
client=cc315005-a.ensch1.ov.home.nl[217.122.186.108]
Aug 1 08:57:40 rwxr-xr-x postfix/cleanup[22092]: 4752C99ED:
message-id=<1091343466 dot 2318 dot 39 dot camel at laptop>
Aug 1 08:57:40 rwxr-xr-x postfix/qmgr[21158]: 4752C99ED:
from=<>, size=1293, nrcpt=1 (queue active)
Aug 1 08:57:41 rwxr-xr-x postfix/smtpd[22085]: disconnect from
cc315005-a.ensch1.ov.home.nl[217.122.186.108]
------------------------------------------------------------------------
Cut out from mail.err
------------------------------------------------------------------------
Aug 1 08:57:56 rwxr-xr-x postfix/virtual[22094]: fatal: dict_open:
unsupported dictionary type: postfix: Is the postfix-postfix package
installed?
------------------------------------------------------------------------
Cut out from mail.warn
------------------------------------------------------------------------
Aug 1 08:57:39 rwxr-xr-x postfix/smtpd[22085]: warning: dict_nis_init:
NIS domain name not set - NIS lookups disabled
Aug 1 08:57:56 rwxr-xr-x postfix/virtual[22094]: fatal: dict_open:
unsupported dictionary type: postfix: Is the postfix-postfix package
installed?
Aug 1 08:57:57 rwxr-xr-x postfix/master[12438]: warning: process
/usr/lib/postfix/virtual pid 22094 exit status 1
Aug 1 08:57:57 rwxr-xr-x postfix/master[12438]: warning:
/usr/lib/postfix/virtual: bad command startup -- throttling
------------------------------------------------------------------------
Cut out from mysql.log
------------------------------------------------------------------------
040801 8:57:40 208 Connect root at localhost on postfix
208 Query select goto from alias where
address= 'timmy.dk'
209 Connect root at localhost on postfix
209 Query select description from domain where
domain = 'timmy.dk'
208 Query select goto from alias where address
= 'testmail.timmy.dk'
209 Query select description from domain where
domain = 'testmail.timmy.dk'
210 Connect root at localhost on postfix
210 Query select goto from alias where address
= ''
210 Query select goto from alias where address
= '@testmail.timmy.dk'
211 Connect root at localhost on postfix
211 Query select maildir from mailbox where
username = ''
212 Connect root at localhost on postfix
212 Query select goto from alias where address
= ''
212 Query select goto from alias where address
= '@testmail.timmy.dk'
040801 8:58:40 210 Quit
211 Quit
208 Quit
209 Quit
212 Quit
------------------------------------------------------------------------
-- Mads N. Vestergaard | Freelance Webudvikler | http://timmy.dk Wishlist: http://www.thinkgeek.com/brain/gimme.cgi?wid=81d083931 New adress: Kuipersdijk 7 | 7512 CA Enschede | Netherlands
|
|
|