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


--
To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx
with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx



Relevant Pages

  • Postfix, Courier-imap with mysql and squirrelmail
    ... The accounts allready there works just fine, ... virtual unix - n n - - virtual ... maildrop unix - n n - - pipe ... hosts = 127.0.0.1 ...
    (Debian-User)
  • RE: Cant access SOME sites on one particular XP account on TWO PC
    ... Command RUN and type every line or entrance alone and preess OK after each ... About hte HOSTS text file is in the following Path on *Window Explorer* ... "nass" wrote: ... Remember that ONE account on the PC it works fine on BOTH accounts. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Simple Lisp Support
    ... and it's encrypted and sent as command ... AdminIdle (it checks whether I'm online on my Unix shell account, ... - Unix script idoes call-forward to NewEco site to deposit the message. ...
    (comp.lang.lisp)
  • RE: Cant access SOME sites on one particular XP account on TWO PC
    ... as is or rename it OLDHOSTS to remember that is the HOSTS file. ... try the WebSites. ... "nass" wrote: ... Remember that ONE account on the PC it works fine on BOTH accounts. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: RWW Security was compromised.
    ... > disagreement that this special Admin Account policy will likely need to be ... >> Windows server security as my previous experience is Unix. ... >> easily be removed from accessing external tools like RWW. ...
    (microsoft.public.windows.server.sbs)