View Single Post
  #8  
Old 13th September 2011, 10:23
jz_ jz_ is offline
Junior Member
 
Join Date: Jun 2011
Location: Madrid
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jz_
Default

And here also left some files again, I can have someone help out with this how-to

/etc/postfix/mysql-virtual_domains.cf
Code:
user = mail_admin
password = 9430Ordenador
dbname = mail
query = SELECT domain AS virtual FROM domains WHERE domain='%s'
hosts = 127.0.0.1
table = domains
/etc/postfix/mysql-virtual_forwardings.cf
Code:
user = mail_admin
password = 9430Ordenador
dbname = mail
query = SELECT destination FROM forwardings WHERE source='%s'
hosts = 127.0.0.1
/etc/postfix/mysql-virtual_mailboxes.cf
Code:
user = mail_admin
password = 9430Ordenador
dbname = mail
query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='%s'
hosts = 127.0.0.1
/etc/postfix/mysql-virtual_email2email.cf
Code:
user = mail_admin
password = 9430Ordenador
dbname = mail
query = SELECT email FROM users WHERE email='%s'
hosts = 127.0.0.1
/etc/postfix/mysql-virtual_transports.cf
Code:
user = mail_admin
password = 9430Ordenador
dbname = mail
query = SELECT transport FROM transport WHERE domain='%s'
hosts = 127.0.0.1
/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
Code:
user = mail_admin
password = 9430Ordenador
dbname = mail
query = SELECT quota FROM users WHERE email='%s'
hosts = 127.0.0.1

/etc/authlib/authmysqlrc
Code:
MYSQL_SERVER localhost
MYSQL_USERNAME mail_admin
MYSQL_PASSWORD 9430Ordenador
MYSQL_PORT 0
MYSQL_DATABASE mail
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD password
#MYSQL_CLEAR_PWFIELD password
MYSQL_UID_FIELD 5000
MYSQL_GID_FIELD 5000
MYSQL_LOGIN_FIELD email
MYSQL_HOME_FIELD "/home/vmail"
MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
#MYSQL_NAME_FIELD
MYSQL_QUOTA_FIELD quota
/usr/lib/courier-imap/etc/imapd.cnf
Code:
default_md = sha1

[ req_dn ]
C=ES
ST=MADRID
L=GETAFE
O=Courier Mail Server
OU=Automatically-generated IMAP SSL key
CN=linux.reforo.com
emailAddress=webmaster@reforo.com


[ cert_type ]
nsCertType = server
/usr/lib/courier-imap/etc/pop3d.cnf
Code:
default_md = sha1

[ req_dn ]
C=ES
ST=MADRID
L=GETAFE
O=Courier Mail Server
OU=Automatically-generated IMAP SSL key
CN=linux.reforo.com
emailAddress=webmaster@reforo.com

[ cert_type ]
nsCertType = server

Last edited by jz_; 13th September 2011 at 12:13.
Reply With Quote