Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 23rd September 2006, 13:29
geekman geekman is offline
Member
 
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 10 Times in 10 Posts
Send a message via ICQ to geekman Send a message via MSN to geekman
Question 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.
Reply With Quote
Sponsored Links
  #2  
Old 23rd September 2006, 13:31
geekman geekman is offline
Member
 
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 10 Times in 10 Posts
Send a message via ICQ to geekman Send a message via MSN to geekman
Default

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
Code:
/usr/bin/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.
Reply With Quote
  #3  
Old 23rd September 2006, 14:59
geekman geekman is offline
Member
 
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 10 Times in 10 Posts
Send a message via ICQ to geekman Send a message via MSN to geekman
Cool

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.
Reply With Quote
  #4  
Old 24th September 2006, 14:16
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

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
?
__________________
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
  #5  
Old 24th September 2006, 14:24
geekman geekman is offline
Member
 
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 10 Times in 10 Posts
Send a message via ICQ to geekman Send a message via MSN to geekman
Default

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.
Reply With Quote
  #6  
Old 24th September 2006, 14:28
geekman geekman is offline
Member
 
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 10 Times in 10 Posts
Send a message via ICQ to geekman Send a message via MSN to geekman
Default

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
Attached Files
File Type: zip mail.zip (7.2 KB, 325 views)
File Type: zip mail_err.zip (33.9 KB, 396 views)

Last edited by geekman; 24th September 2006 at 14:43.
Reply With Quote
  #7  
Old 25th September 2006, 08:06
geekman geekman is offline
Member
 
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 10 Times in 10 Posts
Send a message via ICQ to geekman Send a message via MSN to geekman
Red face

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
Reply With Quote
  #8  
Old 25th September 2006, 13:05
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

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.
__________________
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
  #9  
Old 26th September 2006, 07:57
geekman geekman is offline
Member
 
Join Date: Sep 2006
Location: Sydney, Australia
Posts: 56
Thanks: 1
Thanked 10 Times in 10 Posts
Send a message via ICQ to geekman Send a message via MSN to geekman
Default

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.
Reply With Quote
  #10  
Old 26th September 2006, 17:08
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
 
Default

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.
__________________
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
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
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota... killfrog HOWTO-Related Questions 3 25th September 2009 21:45
Help with Virtual Users And Domains With Postfix, Courier And MySQL procedure netzach HOWTO-Related Questions 5 20th September 2006 17:52
Virtual Users And Domains With Postfix, Courier And MySQL - "apt-get" and Courier burritonator HOWTO-Related Questions 3 15th March 2006 20:11
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 02:53


All times are GMT +2. The time now is 01:47.


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