View Single Post
  #2  
Old 27th May 2006, 06:11
mholownych mholownych is offline
Junior Member
 
Join Date: May 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

mysql-virtual_forwardings.cf
Code:
user = mail_admin
password = mail_admin_password
dbname = mail
table = forwardings
select_field = destination
where_field = source
hosts = 127.0.0.1
mysql-virtual_mailboxes.cf
Code:
user = mail_admin
password = mail_admin_password
dbname = mail
table = users
select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
where_field = email
hosts = 127.0.0.1
mysql-virtual_mailbox_limit_maps.cf
Code:
user = mail_admin
password = mail_admin_password
dbname = mail
table = users
select_field = quota
where_field = email
hosts = 127.0.0.1
mysql-virtual_transports.cf
Code:
user = mail_admin
password = mail_admin_password
dbname = mail
table = transport
select_field = transport
where_field = domain
hosts = 127.0.0.1
commands run:
mail:/var/log# /etc/init.d/postfix restart
Stopping mail transport agent: Postfix.
Starting mail transport agent: Postfix.
mail:/var/log# postfix check
mail:/var/log# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
220 mail.pgehosting.com ESMTP Postfix (Debian/GNU)
helo pgesystems.com
250 mail.pgehosting.com
mail from:mike@pgesystems.com
250 Ok
rcpt to:mike@pgesystems.com
250 Ok
data
354 End data with <CR><LF>.<CR><LF>
subject:test
test
.
250 Ok: queued as 7F0A11F2BC
quit
221 Bye
Connection closed by foreign host.
[/CODE]

logs:
Code:
May 27 00:05:08 mail postfix/postfix-script: stopping the Postfix mail system
May 27 00:05:08 mail postfix/master[2791]: terminating on signal 15
May 27 00:05:08 mail postfix/postfix-script: starting the Postfix mail system
May 27 00:05:08 mail postfix/master[2982]: daemon started -- version 2.1.5
May 27 00:05:15 mail postfix/smtpd[3050]: connect from localhost.localdomain[127.0.0.1]
May 27 00:05:41 mail postfix/smtpd[3050]: 7F0A11F2BC: client=localhost.localdomain[127.0.0.1]
May 27 00:05:52 mail postfix/cleanup[3057]: 7F0A11F2BC: message-id=<20060527040533.7F0A11F2BC@mail.pgehosting.com>
May 27 00:05:52 mail postfix/qmgr[2986]: 7F0A11F2BC: from=<mike@pgesystems.com>, size=378, nrcpt=1 (queue active)
May 27 00:05:53 mail dccproc[3062]: socket(UDP): Address family not supported by protocol
May 27 00:05:53 mail postfix/smtpd[3064]: connect from localhost.localdomain[127.0.0.1]
May 27 00:05:53 mail postfix/smtpd[3064]: 72B741F2BF: client=localhost.localdomain[127.0.0.1]
May 27 00:05:53 mail postfix/cleanup[3057]: 72B741F2BF: message-id=<20060527040533.7F0A11F2BC@mail.pgehosting.com>
May 27 00:05:53 mail postfix/qmgr[2986]: 72B741F2BF: from=<mike@pgesystems.com>, size=853, nrcpt=1 (queue active)
May 27 00:05:53 mail amavis[1441]: (01441-03) Passed, <mike@pgesystems.com> -> <mike@pgesystems.com>, Message-ID: <20060527040533.7F0A11F2BC@mail.pgehosting.com>, Hits: -1.251
May 27 00:05:53 mail postfix/smtp[3058]: 7F0A11F2BC: to=<mike@pgesystems.com>, relay=127.0.0.1[127.0.0.1], delay=20, status=sent (250 2.6.0 Ok, id=01441-03, from MTA: 250 Ok: queued as 72B741F2BF)
May 27 00:05:53 mail postfix/qmgr[2986]: 7F0A11F2BC: removed
May 27 00:05:53 mail postfix/smtpd[3064]: disconnect from localhost.localdomain[127.0.0.1]
May 27 00:05:53 mail postfix/error[3067]: 72B741F2BF: to=<mike@pgesystems.com>, relay=none, delay=0, status=bounced (User unknown in virtual alias table)
May 27 00:05:53 mail postfix/cleanup[3057]: 80BBC1F2C0: message-id=<20060527040553.80BBC1F2C0@mail.pgehosting.com>
May 27 00:05:53 mail postfix/qmgr[2986]: 80BBC1F2C0: from=<>, size=2545, nrcpt=1 (queue active)
May 27 00:05:53 mail postfix/qmgr[2986]: 72B741F2BF: removed
May 27 00:05:53 mail postfix/error[3067]: 80BBC1F2C0: to=<mike@pgesystems.com>, relay=none, delay=0, status=bounced (User unknown in virtual alias table)
May 27 00:05:53 mail postfix/qmgr[2986]: 80BBC1F2C0: removed
May 27 00:05:54 mail postfix/smtpd[3050]: disconnect from localhost.localdomain[127.0.0.1]
Reply With Quote