Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 10th October 2010, 21:10
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 115
Thanks: 7
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
  #12  
Old 11th October 2010, 10:29
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Please use
Code:
hosts = 127.0.0.1
instead of
Code:
hosts = localhost
Then restart Postfix.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
DKLeader (11th October 2010)
  #13  
Old 11th October 2010, 12:28
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 115
Thanks: 7
Thanked 0 Times in 0 Posts
Default [solved]

Thanks for the help.
Changed host value as you suggested and tested - everything seems to work

// DKLeader
Reply With Quote
  #14  
Old 21st February 2011, 19:02
matz matz is offline
Junior Member
 
Join Date: Feb 2011
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default what if ?

Quote:
Originally Posted by falko View Post
Please use
Code:
hosts = 127.0.0.1
instead of
Code:
hosts = localhost
Then restart Postfix.
what if host is = the actuall ip adress ?? would that wrong to ?
__________________
---------------
Matz
Even the smallest thing....
ledbelysning, ledlampor, ledlampa,ledbutiken
Reply With Quote
  #15  
Old 22nd February 2011, 15:13
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
 
Default

Actually, localhost = 127.0.0.1. The difference is that if you use a hostname, Postfix will try to connect to MySQL through the MySQL socket (which does not work if Postfix is running chrooted), whereas if you use an IP, Postfix will try to connect to MySQL through a TCP connection (which works even if Postfix is running chrooted).
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
matz (23rd February 2011)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
sneaking suspicion my postfix config has gone awry mjbarfoot Installation/Configuration 7 24th August 2010 12:23
Why did Squirrelmail, Dovecot/IMAP & Outbound mail break? websissy Technical 4 29th October 2009 22:39
procmail can't write Hellbound General 27 8th June 2009 21:51
Problem with dcc-client installation (Postfix) swap-as Installation/Configuration 9 18th September 2008 20:47
Filtering emails using Spamassassin and Clamav for Exchange 2000 Server Rocky Server Operation 19 11th March 2008 08:27


All times are GMT +2. The time now is 13:49.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.