23rd September 2006, 13:29
|
|
Member
|
|
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
Yet another post about Courier + MySQL + Postfix etc... Auth problems :)
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
Last edited by geekman; 23rd September 2006 at 13:37.
|
23rd September 2006, 13:31
|
|
Member
|
|
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
following on...
my /etc/postfix/master.cf
Code:
#
# Postfix master process configuration file. For details on the format
# of the file, see the Postfix master(5) manual page.
#
# ==========================================================================
# service type private unpriv chroot wakeup maxproc command + args
# (yes) (yes) (yes) (never) (100)
# ==========================================================================
smtp inet n - - - - smtpd
#submission inet n - - - - smtpd
# -o smtpd_etrn_restrictions=reject
# -o smtpd_client_restrictions=permit_sasl_authenticated,reject
#smtps inet n - - - - smtpd
# -o smtpd_tls_wrappermode=yes -o smtpd_sasl_auth_enable=yes
#submission inet n - - - - smtpd
# -o smtpd_etrn_restrictions=reject
# -o smtpd_enforce_tls=yes -o smtpd_sasl_auth_enable=yes
#628 inet n - - - - qmqpd
pickup fifo n - - 60 1 pickup
cleanup unix n - - - 0 cleanup
qmgr fifo n - - 300 1 qmgr
#qmgr fifo n - - 300 1 oqmgr
tlsmgr unix - - - 1000? 1 tlsmgr
rewrite unix - - - - - trivial-rewrite
bounce unix - - - - 0 bounce
defer unix - - - - 0 bounce
trace unix - - - - 0 bounce
verify unix - - - - 1 verify
flush unix n - - 1000? 0 flush
proxymap unix - - n - - proxymap
smtp unix - - - - - smtp
# When relaying mail as backup MX, disable fallback_relay to avoid MX loops
relay unix - - - - - smtp
-o fallback_relay=
# -o smtp_helo_timeout=5 -o smtp_connect_timeout=5
showq unix n - - - - showq
error unix - - - - - error
discard unix - - - - - discard
local unix - n n - - local
virtual unix - n n - - virtual
lmtp unix - - - - - lmtp
anvil unix - - - - 1 anvil
scache unix - - - - 1 scache
#
# ====================================================================
# Interfaces to non-Postfix software. Be sure to examine the manual
# pages of the non-Postfix software to find out what options it wants.
#
# Many of the following services use the Postfix pipe(8) delivery
# agent. See the pipe(8) man page for information about ${recipient}
# and other message envelope options.
# ====================================================================
#
# maildrop. See the Postfix MAILDROP_README file for details.
# Also specify in main.cf: maildrop_destination_recipient_limit=1
#
maildrop unix - n n - - pipe
flags=DRhu user=vmail argv=/usr/local/bin/maildrop -d ${recipient}
#
# See the Postfix UUCP_README file for configuration details.
#
uucp unix - n n - - pipe
flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)
#
# Other external delivery methods.
#
ifmail unix - n n - - pipe
flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp unix - n n - - pipe
flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient
scalemail-backend unix - n n - 2 pipe
flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
mailman unix - - n - - pipe
flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
${nexthop} ${user}
192.168.1.203:10025 inet n - - - - smtpd
-o content_filter=
-o local_recipient_maps=
-o relay_recipient_maps=
-o smtpd_restriction_classes=
-o smtpd_client_restrictions=
-o smtpd_helo_restrictions=
-o smtpd_sender_restrictions=
-o smtpd_recipient_restrictions=permit_mynetworks,reject
-o mynetworks=127.0.0.0/8,192.168.1.0/28
-o strict_rfc821_envelopes=yes
-o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
-o smtpd_bind_address=192.168.1.203
my /etc/courier/authdaemonrc
Code:
authmodulelist="authmysql"
authmodulelistorig="authcustom authcram authuserdb authldap authpgsql authmysql authpam"
daemons=5
version=""
authdaemonvar=/var/run/courier/authdaemon
my /etc/courier/authmysqlrc
Code:
MYSQL_SERVER 192.168.1.201
MYSQL_USERNAME mail_admin
MYSQL_PASSWORD mypass
MYSQL_PORT 0
MYSQL_DATABASE mail
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD password
#MYSQL_CLEAR_PWFIELD password
MYSQL_UID_FIELD 1002
MYSQL_GID_FIELD 1002
MYSQL_LOGIN_FIELD email
MYSQL_HOME_FIELD "/var/spool/vmail"
MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
#MYSQL_NAME_FIELD
MYSQL_QUOTA_FIELD quota
my /etc/courier/imapd
Code:
ADDRESS=192.168.1.203
PORT=143
MAXDAEMONS=40
MAXPERIP=20
PIDFILE=/var/run/courier/imapd.pid
TCPDOPTS="-nodnslookup -noidentlookup"
AUTHMODULES="authdaemon"
AUTHMODULES_ORIG="authdaemon"
DEBUG_LOGIN=0
IMAP_CAPABILITY="IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE"
IMAP_KEYWORDS=1
IMAP_CAPABILITY_ORIG="IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA AUTH=CRAM-MD5 AUTH=CRAM-SHA1 IDLE"
IMAP_IDLE_TIMEOUT=60
IMAP_CAPABILITY_TLS="$IMAP_CAPABILITY AUTH=PLAIN"
IMAP_CAPABILITY_TLS_ORIG="$IMAP_CAPABILITY_ORIG AUTH=PLAIN"
IMAP_DISABLETHREADSORT=0
IMAP_CHECK_ALL_FOLDERS=0
IMAP_OBSOLETE_CLIENT=0
IMAP_ULIMITD=65536
IMAP_USELOCKS=1
IMAP_SHAREDINDEXFILE=/etc/courier/shared/index
IMAP_ENHANCEDIDLE=0
IMAP_TRASHFOLDERNAME=Trash
IMAP_EMPTYTRASH=Trash:7
IMAP_MOVE_EXPUNGE_TO_TRASH=0
SENDMAIL=/usr/sbin/sendmail
HEADERFROM=X-IMAP-Sender
IMAPDSTART=YES
MAILDIRPATH=Maildir
my /etc/courier/maildrop
my /etc/courier/pop3d
Code:
PIDFILE=/var/run/courier/pop3d.pid
MAXDAEMONS=40
MAXPERIP=4
AUTHMODULES="authdaemon"
AUTHMODULES_ORIG="authdaemon"
DEBUG_LOGIN=0
POP3AUTH="LOGIN CRAM-MD5 CRAM-SHA1"
POP3AUTH_ORIG="LOGIN CRAM-MD5 CRAM-SHA1"
POP3AUTH_TLS=""
POP3AUTH_TLS_ORIG="LOGIN PLAIN"
PORT=110
ADDRESS=0
TCPDOPTS="-nodnslookup -noidentlookup"
POP3DSTART=YES
MAILDIRPATH=Maildir
There are two more config files for imap/pop with ssl but man i hate sifting through those files so i wont include them yet. :P
Now onto the logs...I had at first thought that it was imap/pop that would not auth as when i first setup postfix (without any modifications -- auth) i was able to email my gmail account, and it seemed that because the messages were coming from webmail while i was trying to recieve mail it must be those two. Although it could be those two aswell still, i ran a telnet session to pop today and was able to login but then was logged out because there was no MailDir. Then when i attempted the same thing with smtp i didnt know howto login , but when i tried to email one of the accounts on the server, it said `Temporary lookup failure` so now i have no idea whats wrong really.
Code:
root@architect:~# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
220 uberhosting.ath.cx ESMTP Server
MAIL FROM:<admin@uberhosting.ath.cx>
250 Ok
RCPT TO:<admin@uberhosting.ath.cx>
451 <admin@uberhosting.ath.cx>: Temporary lookup failure
my /var/log/mail.log
Code:
Way too big, added as attachment. But heres the tail:
root@architect:~# tail /var/log/mail.log
Sep 24 22:10:40 localhost postfix/qmgr[26289]: warning: connect to transport amavis: No such file or directory
Sep 24 22:11:13 localhost postfix/virtual[26321]: fatal: open /etc/postfix/mysql -virtual_mailbox_limit_maps.cf: No such file or directory
Sep 24 22:11:14 localhost postfix/master[16051]: warning: process /usr/lib/postfix/virtual pid 26321 exit status 1
Sep 24 22:11:14 localhost postfix/master[16051]: warning: /usr/lib/postfix/virtual: bad command startup -- throttling
Sep 24 22:11:29 localhost postfix/smtpd[26322]: connect from unknown[192.168.1.199]
Sep 24 22:11:29 localhost postfix/smtpd[26322]: disconnect from unknown[192.168.1.199]
Sep 24 22:11:40 localhost postfix/qmgr[26289]: warning: connect to transport amavis: No such file or directory
Sep 24 22:12:14 localhost postfix/virtual[26325]: fatal: open /etc/postfix/mysql -virtual_mailbox_limit_maps.cf: No such file or directory
Sep 24 22:12:15 localhost postfix/master[16051]: warning: process /usr/lib/postfix/virtual pid 26325 exit status 1
Sep 24 22:12:15 localhost postfix/master[16051]: warning: /usr/lib/postfix/virtual: bad command startup -- throttling
root@architect:~#
maybe im blind but i didnt see the mssing file defined in main.cf?
Last edited by geekman; 24th September 2006 at 14:23.
|
23rd September 2006, 14:59
|
|
Member
|
|
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
Ok i think that im supposed to change 192.168.1.0/28 to 192.168.1.0/24...i think, no good with that subnet mask thing, doubt it would fix anything but still good to change.
|
24th September 2006, 14:16
|
|
Super Moderator
|
|
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,665
Thanks: 1,896
Thanked 2,595 Times in 2,446 Posts
|
|
Quote:
|
Originally Posted by geekman
Ok i think that im supposed to change 192.168.1.0/28 to 192.168.1.0/24...
|
Yes, that's a good idea.
Also make sure that the DNS record for uberhosting.ath.cx is ok. Finally, what's the output of
Code:
postconf -d | grep mail_version
?
|
24th September 2006, 14:24
|
|
Member
|
|
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
the /var/log/mail.err file is most definitely going to be attached, i flooded my network trying to cat it on ssh at a remote location, which caused by router to crash . Lucky someone is home or I'd have to wait 2 days. Ill have to make another post filling in the info when its all accessible again  I would also like to mention that im sorry for so much spam, i can just attach all the files and remove the code boxes if you'd prefer.
ok finally got it all back up again with the mail.err log its way too big, but ill post the tail and also the whole thing as an attachment.
Code:
Sep 24 22:06:39 localhost postfix/qmgr[25648]: fatal: timeout connecting to transport: virtual
Sep 24 22:07:09 localhost postfix/virtual[26292]: fatal: open /etc/postfix/mysql-virtual_mailbox_limit_maps.cf: No such file or directory
Sep 24 22:08:10 localhost postfix/virtual[26295]: fatal: open /etc/postfix/mysql-virtual_mailbox_limit_maps.cf: No such file or directory
Sep 24 22:09:11 localhost postfix/virtual[26319]: fatal: open /etc/postfix/mysql-virtual_mailbox_limit_maps.cf: No such file or directory
Sep 24 22:10:12 localhost postfix/virtual[26320]: fatal: open /etc/postfix/mysql-virtual_mailbox_limit_maps.cf: No such file or directory
Sep 24 22:11:13 localhost postfix/virtual[26321]: fatal: open /etc/postfix/mysql-virtual_mailbox_limit_maps.cf: No such file or directory
Sep 24 22:12:14 localhost postfix/virtual[26325]: fatal: open /etc/postfix/mysql-virtual_mailbox_limit_maps.cf: No such file or directory
Sep 24 22:13:15 localhost postfix/virtual[26327]: fatal: open /etc/postfix/mysql-virtual_mailbox_limit_maps.cf: No such file or directory
Sep 24 22:14:16 localhost postfix/virtual[26330]: fatal: open /etc/postfix/mysql-virtual_mailbox_limit_maps.cf: No such file or directory
Sep 24 22:15:17 localhost postfix/virtual[26336]: fatal: open /etc/postfix/mysql-virtual_mailbox_limit_maps.cf: No such file or directory
also i didnt think that this file was covered in the howto?
and one last thing, i couldnt find a mysql log on neo, im running mysql 5
ok so thats all i can think of, hope someone can help me
Thanks everyone in advance.
|
24th September 2006, 14:28
|
|
Member
|
|
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
thanks i missed your response falko, im pretty sure DNS records are OK but even still if they aren't i dont think i can change them as im using DynDns. Also the output of `postconf -d | grep mail_version` is:
mail_version = 2.2.4
also i dont know if you read it but i mentioned that and also that i had the latest quota patch applied...i guess you just needed to be sure.
Thanks man, also the logs are *not* attached (i couldnt be bothered to get them to this box as the mail server has no ftp or http, i did put them on my shared apache but but) attached and the tails of both were edited into the other post. The logs can be found at http://uberhosting.ath.cx/~geekman/mail.log and http://uberhosting.ath.cx/~geekman/mail.err
Ok so now i *have* uploaded them, sometimes i surprise even my own mind
Thankyou again
Last edited by geekman; 24th September 2006 at 14:43.
|
25th September 2006, 08:06
|
|
Member
|
|
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
Ok so it seems im extremely blind or extremely tired, or maybe i need to sleep more. But i was sure the `mysql-virtual_mailbox_limit_maps.cf` was not mentioned in the howto but seeing as the logs were swamped with the error i decided to grep main.cf and see where it was being called, then i looked in the howto for the file 
Ok but now i am still getting some errors with amavis that ive had all along
Code:
Sep 25 15:56:15 localhost postfix/master[29013]: daemon started -- version 2.2.4, configuration /etc/postfix
Sep 25 15:56:15 localhost postfix/qmgr[29016]: 957B262117: from=<root@uberhosting.ath.cx>, size=508, nrcpt=1 (queue active)
Sep 25 15:56:15 localhost postfix/qmgr[29016]: warning: connect to transport amavis: No such file or director
thats all i get in the mail logs when i restart postfix, i havent done any testing yet but i assume it wont work still because i have been reading orielly's 'definitive guide to postfix' and seeing as amavis is the content filter, i assume it will not be passed on to store?
Thanks in Advance
|
25th September 2006, 13:05
|
|
Super Moderator
|
|
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,665
Thanks: 1,896
Thanked 2,595 Times in 2,446 Posts
|
|
Please post your main.cf and master.cf here (please strip out the comments).
Quote:
|
also i dont know if you read it but i mentioned that and also that i had the latest quota patch applied...i guess you just needed to be sure.
|
I just fly over the posts as there are so many questions to answer in this forum that I just can't afford to spend more than 5 minutes per question... So it's possible I didn't read it.
|
26th September 2006, 07:57
|
|
Member
|
|
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 7 Times in 7 Posts
|
|
Thats cool, as you requested:
the `/etc/postfix/main.cf` file
Code:
smtpd_banner = $myhostname ESMTP Server
biff = no
append_dot_mydomain = no
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/24
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]:10024
receive_override_options = no_address_mappings
and the `/etc/postfix/master.cf` file
Code:
smtp inet n - - - - smtpd
pickup fifo n - - 60 1 pickup
cleanup unix n - - - 0 cleanup
qmgr fifo n - - 300 1 qmgr
tlsmgr unix - - - 1000? 1 tlsmgr
rewrite unix - - - - - trivial-rewrite
bounce unix - - - - 0 bounce
defer unix - - - - 0 bounce
trace unix - - - - 0 bounce
verify unix - - - - 1 verify
flush unix n - - 1000? 0 flush
proxymap unix - - n - - proxymap
smtp unix - - - - - smtp
relay unix - - - - - smtp
-o fallback_relay=
showq unix n - - - - showq
error unix - - - - - error
discard unix - - - - - discard
local unix - n n - - local
virtual unix - n n - - virtual
lmtp unix - - - - - lmtp
anvil unix - - - - 1 anvil
scache unix - - - - 1 scache
maildrop unix - n n - - pipe
flags=DRhu user=vmail argv=/usr/local/bin/maildrop -d ${recipient}
uucp unix - n n - - pipe
flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)
ifmail unix - n n - - pipe
flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp unix - n n - - pipe
flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient
scalemail-backend unix - n n - 2 pipe
flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
mailman unix - - n - - pipe
flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
${nexthop} ${user}
192.168.1.203:10025 inet n - - - - smtpd
-o content_filter=
-o local_recipient_maps=
-o relay_recipient_maps=
-o smtpd_restriction_classes=
-o smtpd_client_restrictions=
-o smtpd_helo_restrictions=
-o smtpd_sender_restrictions=
-o smtpd_recipient_restrictions=permit_mynetworks,reject
-o mynetworks=127.0.0.0/8,192.168.1.0/28
-o strict_rfc821_envelopes=yes
-o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
-o smtpd_bind_address=192.168.1.203
Also i noticed that in my `/etc/courier/authmysqlrc` file
it has
Code:
MYSQL_CRYPT_PWFIELD password
#MYSQL_CLEAR_PWFIELD password
The thing is that i didnt edit out the password, so i assume i have to put in the mysql user password? But also seen as im currently using `MYSQL_CRYPT_PWFIELD`, how do i encrypt the password for use with this parameter? Or should i just use `MYSQL_CLEAR_PWFIELD` instead?
Thanks in Advance
PS i changed the
Code:
-o mynetworks=127.0.0.0/8,192.168.1.0/28
string to
Code:
-o mynetworks=127.0.0.0/8,192.168.1.0/24
after i noticed
Last edited by geekman; 26th September 2006 at 08:02.
|
26th September 2006, 17:08
|
|
Super Moderator
|
|
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,665
Thanks: 1,896
Thanked 2,595 Times in 2,446 Posts
|
|
Quote:
|
Originally Posted by geekman
and the `/etc/postfix/master.cf` file
Code:
smtp inet n - - - - smtpd
pickup fifo n - - 60 1 pickup
cleanup unix n - - - 0 cleanup
qmgr fifo n - - 300 1 qmgr
tlsmgr unix - - - 1000? 1 tlsmgr
rewrite unix - - - - - trivial-rewrite
bounce unix - - - - 0 bounce
defer unix - - - - 0 bounce
trace unix - - - - 0 bounce
verify unix - - - - 1 verify
flush unix n - - 1000? 0 flush
proxymap unix - - n - - proxymap
smtp unix - - - - - smtp
relay unix - - - - - smtp
-o fallback_relay=
showq unix n - - - - showq
error unix - - - - - error
discard unix - - - - - discard
local unix - n n - - local
virtual unix - n n - - virtual
lmtp unix - - - - - lmtp
anvil unix - - - - 1 anvil
scache unix - - - - 1 scache
maildrop unix - n n - - pipe
flags=DRhu user=vmail argv=/usr/local/bin/maildrop -d ${recipient}
uucp unix - n n - - pipe
flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)
ifmail unix - n n - - pipe
flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp unix - n n - - pipe
flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient
scalemail-backend unix - n n - 2 pipe
flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
mailman unix - - n - - pipe
flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
${nexthop} ${user}
192.168.1.203:10025 inet n - - - - smtpd
-o content_filter=
-o local_recipient_maps=
-o relay_recipient_maps=
-o smtpd_restriction_classes=
-o smtpd_client_restrictions=
-o smtpd_helo_restrictions=
-o smtpd_sender_restrictions=
-o smtpd_recipient_restrictions=permit_mynetworks,reject
-o mynetworks=127.0.0.0/8,192.168.1.0/28
-o strict_rfc821_envelopes=yes
-o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
-o smtpd_bind_address=192.168.1.203
|
You forgot to put
Code:
amavis unix - - - - 2 smtp
-o smtp_data_done_timeout=1200
-o smtp_send_xforward_command=yes
into master.cf, as shown on http://www.howtoforge.com/virtual_po...ota_courier_p3
Also use
Code:
127.0.0.1:10025 inet n - - - - smtpd
-o content_filter=
-o local_recipient_maps=
-o relay_recipient_maps=
-o smtpd_restriction_classes=
-o smtpd_client_restrictions=
-o smtpd_helo_restrictions=
-o smtpd_sender_restrictions=
-o smtpd_recipient_restrictions=permit_mynetworks,reject
-o mynetworks=127.0.0.0/8
-o strict_rfc821_envelopes=yes
-o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
-o smtpd_bind_address=127.0.0.1
instead of your code.
Quote:
|
Originally Posted by geekman
Also i noticed that in my `/etc/courier/authmysqlrc` file
it has
Code:
MYSQL_CRYPT_PWFIELD password
#MYSQL_CLEAR_PWFIELD password
The thing is that i didnt edit out the password, so i assume i have to put in the mysql user password? |
No, don't replace the string password. It means the password column in the MySQL database.
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT +2. The time now is 00:40.
|
|
English | 
Deutsch
Recent comments
23 hours 19 min ago
1 day 4 hours ago
1 day 8 hours ago
1 day 10 hours ago
2 days 47 min ago
2 days 53 min ago
2 days 5 hours ago
2 days 12 hours ago
2 days 13 hours ago
2 days 14 hours ago