| Linode Forum https://forum.linode.com/ |
|
| problem - configuring MySQL for postfix/courier catch-all https://forum.linode.com/viewtopic.php?f=11&t=3988 |
Page 1 of 1 |
| Author: | the_guv [ Fri Mar 13, 2009 12:14 pm ] |
| Post subject: | problem - configuring MySQL for postfix/courier catch-all |
I've got Postfix working with Courier and MySQL, but now want to set up catch-all mail accounts. But how? I am particularly confused about using MySQL for virtual_alias_maps. I guess I have to somehow cross-reference existing tables, and maybe create a catchall table for each domain. (I have next to no experience playing with this.) My main.cf reads ... smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu) biff = no append_dot_mydomain = no readme_directory = no smtpd_sasl_auth_enable = yes broken_sasl_auth_clients = yes smtpd_sasl_authenticated_header = yes smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination smtpd_use_tls = yes smtpd_tls_cert_file = /etc/ssl/certs/mailcert.pem smtpd_tls_key_file = $smtpd_tls_cert_file myhostname = mail.mydomain.com alias_maps = hash:/etc/aliases alias_database = hash:/etc/aliases myorigin = /etc/mailname mydestination = relayhost = mynetworks = mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128 mailbox_size_limit = 0 recipient_delimiter = + inet_interfaces = all virtual_alias_domains = virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-forwards.cf, mysql:/etc/postfix/mysql-email.cf virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-domains.cf virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-mailboxes.cf virtual_mailbox_base = /home/vmail virtual_uid_maps = static:5000 virtual_gid_maps = static:5000 ... Would I be right in thinking I need to change the above to: myhostname = localhost virtual_alias_domains = mydomain.com mydomain2.com another.tld And .. well, here's where I am most confused what to do... virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-forwards.cf, mysql:/etc/postfix/mysql-email.cf # What do I do here?? ... Were I not using MySQL, I guess I would set up /etc/postfix/virtual map file and add something like: @mydomain.com newbie@mydomain.com @another.tld newbie@mydomain.com ... but as I have created mySQL tables for domains, users, email and forward, I am guessing I need to do something different, ...and thought I would ask before messing everything up. Any pointers greatly appreciated. |
|
| Author: | Stever [ Fri Mar 13, 2009 1:44 pm ] |
| Post subject: | |
In the past, I have done catch-all addresses in virtual_mailbox_maps by creating an entry for @domain.com with the mailbox location. For example if I want the catch-all to go to user1@domain.com Code: user1@domain.com domain.com/user1/.maildir/ I've never used mysql though, so not sure if it will work for you. |
|
| Author: | the_guv [ Fri Mar 13, 2009 7:32 pm ] |
| Post subject: | |
tx Stever, appreciate that, will try. |
|
| Author: | the_guv [ Wed Mar 18, 2009 6:52 am ] |
| Post subject: | |
hmmn, have gone for Google apps for now! |
|
| Page 1 of 1 | All times are UTC-04:00 |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|