View Single Post
  #11  
Old 10th October 2010, 21:10
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 113
Thanks: 6
Thanked 0 Times in 0 Posts
Default

Sure :

mysql-virtual_client.cf :
Code:
user = ispconfig
password = somethingiknow
dbname = dbispconfig
table        = mail_access
select_field = access
where_field  = source
additional_conditions = and type = 'client' and active = 'y'
hosts = localhost
mysql-virtual_domains.cf
Code:
user = ispconfig
password = somethingiknow
dbname = dbispconfig
table = mail_domain
select_field = domain
where_field = domain
additional_conditions = and active = 'y' and server_id = 6
hosts = localhost
mysql-virtual_email2email.cf
Code:
user = ispconfig
password = somethingiknow
dbname = dbispconfig
table = mail_user
select_field = email
where_field = email
additional_conditions = and postfix = 'y' and server_id = 6
hosts = localhost
mysql-virtual_forwardings.cf
Code:
user = ispconfig
password = somethingiknow
dbname = dbispconfig
table = mail_forwarding
select_field = destination
where_field = source
additional_conditions = and active = 'y' and server_id = 6
hosts = localhost
mysql-virtual_mailboxes.cf
Code:
user = ispconfig
password = somethingiknow
dbname = dbispconfig
table = mail_user
select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'mail,'@',1),'/')
where_field = email
additional_conditions = and postfix = 'y' and server_id = 6
hosts = localhost
mysql-virtual_recipient.cf
Code:
user = ispconfig
password = somethingiknow
dbname = dbispconfig
table        = mail_access
select_field = access
where_field  = source
additional_conditions = and type = 'recipient' and active = 'y' and server_id = 6
hosts = localhost
mysql-virtual_relaydomains.cf
Code:
user = ispconfig
password = somethingiknow
dbname = dbispconfig
table = mail_transport
select_field = domain
where_field = domain
additional_conditions = and active = 'y' and server_id = 6
hosts = localhost
mysql-virtual_relayrecipientmaps.cf
Code:
user = ispconfig
password = somethingiknow
dbname = dbispconfig
table = mail_relay_recipient
select_field = access
where_field = source
additional_conditions = and active = 'y' and server_id = 6
hosts = localhost
mysql-virtual_sender.cf
Code:
user = ispconfig
password = somethingiknow
dbname = dbispconfig
table        = mail_access
select_field = access
where_field  = source
additional_conditions = and type = 'sender' and active = 'y' and server_id = 6
hosts = localhost
mysql-virtual_transports.cf
Code:
user = ispconfig
password = somethingiknow
dbname = dbispconfig
table = mail_transport
select_field = transport
where_field = domain
additional_conditions = and active = 'y' and server_id = 6
hosts = localhost
I have checked the password and they are the same in all of the cf files.
Reply With Quote
Sponsored Links