Re: Postfix, Courier-imap with mysql and squirrelmail
Sturla Holm Hansen wrote:
> Hi there list.
> I'm having trouble with my mail-server running courier-imap and
> squirrelmail after moving it to a new box.
> The accounts allready there works just fine, but when I tried adding
> another account (by adding another user and password in the user-list in
> mysql) it didn't make the required directories by itself as it used to do
> on the old box.
> I made them myself, set the rights like they were on another account and
> it seemed to work ok, until new mail arrived that is.
> Logging in is painfully slow and I discovered that new mail in the inbox
> on this new account gets set rw---- instead of rwr-r- like it does on the
> other accounts.
> Anybody have a clue what's going on?
>
> My main.cf:
>
>
> smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
> 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 = <hostname>
> alias_maps = hash:/etc/aliases
> alias_database = hash:/etc/aliases
> myorigin = /etc/mailname
> mydestination = localhost.localdomain, localhost.localdomain, localhost
> relayhost =
> mynetworks = 127.0.0.0/8
> mailbox_command = procmail -a "$EXTENSION"
> mailbox_size_limit = 0
> recipient_delimiter = +
> inet_interfaces = all
> virtual_alias_maps =
> mysql:/etc/postfix/mysql-virtual_forwardings.cf
> mysql:/etc/postfix/mysql-virtual_email2email.cf
> virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
> virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
> virtual_mailbox_base = /home/vmail
> virtual_uid_maps = static:5000
> virtual_gid_maps = static:5000
> 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
> content_filter = amavis:[127.0.0.1]:10024
> receive_override_options = no_address_mappings
>
> master.cf:
>
> smtp inet n - - - - smtpd
> #submission inet n - - - - smtpd
> # -o smtpd_etrn_restrictions=reject
> #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
> 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 smtp_helo_timeout=5 -o smtp_connect_timeout=5
> showq unix n - - - - showq
> error unix - - - - - error
> local unix - n n - - local
> virtual unix - n n - - virtual
> lmtp unix - - n - - lmtp
> anvil unix - - n - 1 anvil
> #
> # Interfaces to non-Postfix software. Be sure to examine the manual
> # pages of the non-Postfix software to find out what options it wants.
> #
> # maildrop. See the Postfix MAILDROP_README file for details.
> #
> 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 -d -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}
>
> # only used by postfix-tls
> #tlsmgr fifo - - n 300 1 tlsmgr
> #smtps inet n - n - - smtpd -o
> smtpd_tls_wrappermode=yes -o smtpd_sasl_auth_enable=yes
> #587 inet n - n - - smtpd -o
> smtpd_enforce_tls=yes -o smtpd_sasl_auth_enable=yes
>
> amavis unix - - - - 2 smtp
> -o smtp_data_done_timeout=1200
> -o smtp_send_xforward_command=yes
>
> 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
>
>
> mysql_virtual_domains
>
> user = user
> password = password
> dbname = provider
> table = domains
> select_field = 'virtual'
> where_field = domain
> hosts = 127.0.0.1
>
>
> mysql_virtual_email2email.cf
>
> user = user
> password = password
> dbname = provider
> table = users
> select_field = email
> where_field = email
> hosts = 127.0.0.1
>
> mysql_virtual_forwardings.cf
>
> user = user
> password = password
> dbname = provider
> table = forwardings
> select_field = destination
> where_field = source
> hosts = 127.0.0.1
>
> mysql_virtual_mailboxes.cf
>
> user = user
> password = password
> dbname = provider
> table = users
> select_field =
> CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
> where_field = email
> hosts = 127.0.0.1
>
>
>
> Any help much appreciated.
>
> Thanx
>
Update: Just found out that this now applies to every account, wtf?
Again, any ideas would be MUCH appreciated....
Sturla
Reply to: