Hi last week i found your guide
Code:
http://howtoforge.com/virtual_postfix_mysql_quota_courier
I followed it as best i could but i was forced to make a few changes to how it is all setup for me, also im running ubuntu 5.10 on all servers. I usually prefer to RTFM and solve my own problems but i have a feeling i'll need better help with this one, i have read almost all posts in the howto related section but i cant find anything that fixes my problem, but maybe im just stupid. This is my last option, i hope to get the mailserver working before the end of next week, any help is very much appreciated.
Heres the changes i can remember: firstly, for me email and mysql are on two different boxes and the webmail client is on yet another one. The email server is called 'architect' with an IP of 192.168.1.203 this has smtp/imap/pop/spam/av. Then there is 'neo' (i use matrix characters to name my boxes

) with an IP of 192.168.1.201, theres also the shared apache box but no need to worry about that yet i feel. I am also using a newer version of postfix (2.2.4) and the quota patch (postfix-2.2.4-vda.patch) to the ones described. Oh and i also changed the mail base to /var/spool/vmail this is because i had already partitioned the box thinking i would put all mail in /var and lastly i had already added a vmail user before using this guide so i changed the UID in the config files to use 1002 in /etc/postfix/main.cf
Code:
virtual_uid_maps = static:1002
virtual_gid_maps = static:1002
I assume i got the UID right by doing:
Code:
root@architect:~# grep vmail /etc/passwd
vmail:x:1002:1002::/var/spool/vmail:
root@architect:~# grep vmail /etc/group
vmail:x:1002:
?
Apart from that i dont think i did much else different, i hope i have explained my situation well enough for it not to be confusing. Im going to post all the info i can think of to get this fixed quick
output of `netstat -tap` on architect
Code:
tcp 0 0 *:smux *:* LISTEN 10430/snmpd
tcp 0 0 localhost.localdo:10024 *:* LISTEN 20192/amavisd (mast
tcp 0 0 192.168.1.203:10025 *:* LISTEN 16051/master
tcp 0 0 192.168.1.203:imap2 *:* LISTEN 22373/couriertcpd
tcp 0 0 *:smtp *:* LISTEN 16051/master
tcp 0 0 192.168.1.203:42901 ldap:mysql ESTABLISHED2979/authdaemond.my
tcp 0 0 192.168.1.203:47017 ldap:mysql ESTABLISHED2976/authdaemond.my
tcp6 0 0 *:imaps *:* LISTEN 22767/couriertcpd
tcp6 0 0 *:pop3s *:* LISTEN 22696/couriertcpd
tcp6 0 0 *:pop3 *:* LISTEN 3041/couriertcpd
tcp6 0 0 *:ssh *:* LISTEN 5399/sshd
output of `netstat -tap` on neo
Code:
tcp 0 0 localhost.localdo:32769 *:* LISTEN 6 758/hpiod
tcp 0 0 localhost.localdo:32770 *:* LISTEN 6 771/python
tcp 0 0 *:smux *:* LISTEN 7 045/snmpd
tcp 0 0 *:mysql *:* LISTEN 6 880/mysqld
tcp 0 0 *:netbios-ssn *:* LISTEN 7 038/smbd
tcp 0 0 *:ftp *:* LISTEN 7 135/proftpd: (acce
tcp 0 0 neo:ipp *:* LISTEN 9 526/cupsd
tcp 0 0 localhost.localdoma:ipp *:* LISTEN 9 526/cupsd
tcp 0 0 *:3128 *:* LISTEN 7 120/(squid)
tcp 0 0 *:microsoft-ds *:* LISTEN 7 038/smbd
tcp 0 0 neo:mysql trinity:2793 ESTABLISHED6 880/mysqld
tcp 0 0 localhost.localdo:32806 localhost.localdo:32805 ESTABLISHED7 120/(squid)
tcp 0 0 localhost.localdo:50332 localhost.localdo:32769 ESTABLISHED6 771/python
tcp 0 0 localhost.localdo:32805 localhost.localdo:32806 ESTABLISHED9 627/(pam_auth)
tcp 0 0 neo:mysql trinity:2794 ESTABLISHED6 880/mysqld
tcp 0 0 localhost.localdo:32808 localhost.localdo:32807 ESTABLISHED7 120/(squid)
tcp 0 0 neo:mysql architect:47017 ESTABLISHED6 880/mysqld
tcp 0 0 localhost.localdo:32807 localhost.localdo:32808 ESTABLISHED9 628/(pam_auth)
tcp 0 0 localhost.localdo:32810 localhost.localdo:32809 ESTABLISHED7 120/(squid)
tcp 0 0 localhost.localdo:32809 localhost.localdo:32810 ESTABLISHED9 629/(pam_auth)
tcp 0 0 localhost.localdo:32812 localhost.localdo:32811 ESTABLISHED7 120/(squid)
tcp 0 0 localhost.localdo:32811 localhost.localdo:32812 ESTABLISHED9 630/(pam_auth)
tcp 0 0 localhost.localdo:32814 localhost.localdo:32813 ESTABLISHED7 120/(squid)
tcp 0 0 localhost.localdo:32813 localhost.localdo:32814 ESTABLISHED9 631/(pam_auth)
tcp 0 0 neo:mysql architect:42901 ESTABLISHED6 880/mysqld
tcp 0 0 localhost.localdo:32769 localhost.localdo:50332 ESTABLISHED6
my /etc/postfix/main.cf
Code:
# See /usr/share/postfix/main.cf.dist for a commented, more complete version
smtpd_banner = $myhostname ESMTP Server
biff = no
# appending .domain is the MUA's job.
append_dot_mydomain = no
# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h
myhostname = uberhosting.ath.cx
alias_maps = hash:/etc/aliases, ldap:/etc/postfix/ldap-aliases.cf
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = localhost, localhost.localdomain
relayhost =
mynetworks = 127.0.0.0/8,192.168.1.0/28
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_base = /var/spool/vmail
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_uid_maps = static:1002
virtual_gid_maps = static:1002
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_fowardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
mailbox_command = /usr/bin/procmail
virtual_alias_domains =
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
smtpd_use_tls = yes
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
transport_maps = mysql:/etc/postfix/mysql-virtual_transports.cf
virtual_create_maildirsize = yes
virtual_mailbox_extended = yes
virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_maildir_limit_message = "The user you are trying to reach is over quota."
virtual_overquota_bounce = yes
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
content_filter = amavis:[127.0.0.1]:10025
receive_override_options = no_address_mappings