| View previous topic :: View next topic |
| Author |
Message |
BlueSol
n00b
Joined: 13 Oct 2003
Posts: 4
Location: Sunnyvale, CA, US
|
 Posted: Wed Dec 28, 2005 2:28 pm Post subject: Postfix 2.2.5 upgrade problem [SOLVED] |
 |
|
So I finally took the plunge and upgraded to postfix 2.2.5 from postfix 2.1.5. This upgrade was not automatic due to all the changes. I thought I had everything covered until I realized that my server was refusing outside SMTP connections. I hadn't changed my main.cf file as I was not affected by any of the newer revision changes. As far as I can tell, postfix is not looking into my database for virtual_mailbox_domains.
The following does not work...
| Code: |
# main.cf
virtual_mailbox_domains = mysql:/etc/postfix/mysql/mysql_virtual_domains_maps.cf
|
| Code: |
# mysql/mysql_virtual_domains_maps.cf
user = postfix
password = PASSWORD
hosts = localhost
dbname = postfix
table = domain
select_field = description
where_field = domain
additional_conditions = and backupmx = '0' and active = '1'
|
Manually adding in domains does work...
| Code: |
# main.cf
virtual_mailbox_domains = mydomain.com, mysql:/etc/postfix/mysql/mysql_virtual_domains_maps.cf
|
Any ideas? It worked in 2.1.5 just fine.
Last edited by BlueSol on Wed Dec 28, 2005 9:32 pm; edited 1 time in total |
|
| Back to top |
|
 |
magic919
Advocate
Joined: 17 Jun 2005
Posts: 2182
Location: Berkshire, UK
|
| Posted: Wed Dec 28, 2005 2:41 pm Post subject: |
|
|
Did you run postfix upgrade-configuration ?
What exactly goes on in your logs wehn you start Postfix?
What made you draw the conclusion is isn't using the DB? |
|
| Back to top |
|
|
langthang
Retired Dev
Joined: 27 Nov 2003
Posts: 620
|
| Posted: Wed Dec 28, 2005 6:25 pm Post subject: |
|
|
what does `postmap -q <yourdomain> mysql:/etc/postfix/mysql-virtual_mailbox_domains.cf` return? It should return your domain name; else change your query.
With postfix-2.2.x you can do something like
| Code: | # mysql/mysql_virtual_domains_maps.cf
user = postfix
password = PASSWORD
hosts = localhost
dbname = postfix
query = SELECT domain
FROM domain
WHERE domain = '%s'
AND backupmx = '0'
AND active = '1' |
man 5 mysql_table for detail.
BTW, check if you have mysql support with `postconf -m`
_________________
Gentoo users' map |
|
| Back to top |
|
|
kashani
Advocate
Joined: 02 Sep 2002
Posts: 2032
Location: San Francisco
|
|
| Back to top |
|
|
BlueSol
n00b
Joined: 13 Oct 2003
Posts: 4
Location: Sunnyvale, CA, US
|
| Posted: Wed Dec 28, 2005 9:32 pm Post subject: D'oh! |
|
|
As always, you people are life savers. It's working again.
I must apologize for the lack of testing/log information. I'd been up all night doing upgrades at the point. Yes, I ran postfix upgrade-configuration and nothing happened. The logs looked ok with no errors related to the DB. I had tried removing all extra setup except for the DB/Vitual options, which I found to be the source, thus I assumed there was a problem querying the DB.
Postmap returned nothing due to the change in query setup. Thanks for the link. I had problems finding info ont he new 2.2.5 format. |
|
| Back to top |
|
|
|
Networking & Security
