View Single Post
  #3  
Old 2nd February 2011, 20:04
gu35t gu35t is offline
Junior Member
 
Join Date: Feb 2011
Posts: 4
Thanks: 0
Thanked 1 Time in 1 Post
Default

cat mysql-virtual_mailboxes.cf
Code:
 
user = mail_admin
password = pass
dbname = mail
#query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='%s'
table = users
select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
where_field = email
hosts = localhost
cat mysql-virtual_mailbox_limit_maps.cf
Code:
user = mail_admin
password = pass
dbname = mail
query = SELECT quota FROM users WHERE email='%s'
hosts = localhost
cat mysql-virtual_domains.cf
Code:
user = mail_admin
password = pass
dbname = mail
query = SELECT domain AS virtual FROM domains WHERE domain='%s'
hosts = localhost
cat mysql-virtual_email2email.cf
Code:
user = mail_admin
password = pass
dbname = mail
query = SELECT email FROM users WHERE email='%s'
hosts = localhost
cat mysql-virtual_forwardings.cf
Code:
 
user = mail_admin
password = pass
dbname = mail
query = SELECT destination FROM forwardings WHERE source='%s'
hosts = localhost
cat mysql-virtual_transports.cf
Code:
user = mail_admin
password = pass
dbname = mail
query = SELECT transport FROM transport WHERE domain='%s'
hosts = localhost
Reply With Quote