Forum Debian Users Gang

Nov 26 22:16:28 mikinet postfix/pickup[25065]: 44E7319525: uid=33 from=<norbert@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26108]: 44E7319525: message-id=<40623d556b3c1197b84f6ce87f7aefcd@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26108]: warning: 44E7319525: virtual_alias_maps map lookup problem for norbert740@gmail.com
Nov 26 22:16:28 mikinet postfix/pickup[25065]: 4527519525: uid=33 from=<norbert@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26109]: 4527519525: message-id=<2a51c60ef871a12e15ca37b0f5f94a02@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26109]: warning: 4527519525: virtual_alias_maps map lookup problem for norbert@mikinet.pl
Nov 26 22:16:28 mikinet postfix/pickup[25065]: 4568C19525: uid=33 from=<norbert@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26109]: 4568C19525: message-id=<1787c33e53924168d1a6aa30560fc0a5@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26109]: warning: 4568C19525: virtual_alias_maps map lookup problem for norbert@mikinet.pl
Nov 26 22:16:28 mikinet postfix/pickup[25065]: 45A9E19525: uid=33 from=<norbert@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26109]: 45A9E19525: message-id=<054bf498741f14b0201675f775485365@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26109]: warning: 45A9E19525: virtual_alias_maps map lookup problem for norbert@mikinet.pl
Nov 26 22:16:28 mikinet postfix/pickup[25065]: 45EA119525: uid=33 from=<norbert@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26109]: 45EA119525: message-id=<f94fa97b4d17dc8e264862ea883ff9db@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26109]: warning: 45EA119525: virtual_alias_maps map lookup problem for norbert740@gmail.com
Nov 26 22:16:28 mikinet postfix/pickup[25065]: 462A219525: uid=33 from=<norbert@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26109]: 462A219525: message-id=<152cc82065aaa9e5bf9e1accfee8fb89@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26109]: warning: 462A219525: virtual_alias_maps map lookup problem for norbert740@gmail.com
Nov 26 22:16:28 mikinet postfix/pickup[25065]: 466E519525: uid=33 from=<norbert@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26108]: 466E519525: message-id=<ff1c9c15ae953885fd3663c955294d77@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26108]: warning: 466E519525: virtual_alias_maps map lookup problem for norbert740@gmail.com
Nov 26 22:16:28 mikinet postfix/pickup[25065]: 46B3D19525: uid=33 from=<norbert@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26108]: 46B3D19525: message-id=<2bdc238b5cff14f82dab92e0dcc75b14@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26108]: warning: 46B3D19525: virtual_alias_maps map lookup problem for norbert740@gmail.com
Nov 26 22:16:28 mikinet postfix/pickup[25065]: 46F5719525: uid=33 from=<norbert@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26108]: 46F5719525: message-id=<0e6e8de4ec2a0cbc35832e9831cf73c4@kasy.radom.pl>
Nov 26 22:16:28 mikinet postfix/cleanup[26108]: warning: 46F5719525: virtual_alias_maps map lookup problem for norbert740@gmail.com

protocols = imap
listen = *
login_process_size = 64
default_mail_env = maildir:/home/mail/vmail/%u/

namespace private {
  separator = .
  prefix = INBOX.
  inbox = yes
}

namespace private {
  separator = .
  prefix =
  inbox = yes
  hidden = yes
}

#mail_extra_groups = postfix
verbose_proctitle = yes
first_valid_uid = 125
first_valid_gid = 125
#umask = 0077
mbox_read_locks = fcntl
mbox_write_locks = fcntl

ssl_disable = no

ssl_cert_file = /etc/ssl/certs/dovecot.pem
ssl_key_file = /etc/ssl/private/dovecot.pem

# If key file is password protected, give the password here. Alternatively
# give it when starting dovecot with -p parameter.
ssl_key_password =

protocol imap {
  imap_client_workarounds = delay-newmail outlook-idle netscape-eoh tb-extra-mailbox-sep
}

#People who use outlook are fux0red anyway...

#protocol pop3 {
#  pop3_uidl_format = %08Xu%08Xv
#  pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
#}

protocol lda {
  postmaster_address = postmaster@yourdomain.tld
  sendmail_path = /usr/local/sbin/sendmail
}

auth_username_chars = abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890.-_@

auth_debug = yes
auth_verbose = yes
auth default {

passdb sql {
        args = /etc/dovecot/dovecot-sql.conf
  }
  
userdb sql {
        args = /etc/dovecot/dovecot-sql.conf
  }
}

# Database driver: mysql, pgsql
driver = mysql

# Currently supported schemes include PLAIN, PLAIN-MD5, DIGEST-MD5, and CRYPT.
default_pass_scheme = CRYPT

# Database options
connect = host=localhost dbname=postfix user=root password=xxxxxx

password_query = SELECT password FROM mailbox WHERE username = '%u' AND active = '1'
user_query = SELECT maildir, 125 AS uid, 125 AS gid FROM mailbox WHERE username = '%u' AND active = '1'

# eof

smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
biff = no
append_dot_mydomain = no
readme_directory = no

myhostname = domenamoja.pl
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = localhost
relayhost =
mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all

# postfixadmin stuff
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:507
virtual_mailbox_base = /home/mail/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_limit = 51200000
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 507
virtual_transport = virtual
virtual_uid_maps = static:507
# Additional for quota support
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 = Sorry, the user's maildir has overdrawn his diskspace quota, please try again later.
virtual_overquota_bounce = yes
# store backup mx domains in mysql
#relay_domains = proxy:mysql:/etc/postfix/mysql_relay_domains_maps.cf
#sasl2 stuff
# TLS parameters
#smtpd_tls_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem
#smtpd_tls_key_file=/etc/ssl/private/ssl-cert-snakeoil.key
#smtpd_use_tls=yes
#smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtpd_sasl_auth_enable          = yes
#smtpd_sasl_local_domain        = $myhostname
smtpd_sasl_exceptions_networks  = $mynetworks
smtpd_sasl_security_options     = noanonymous
broken_sasl_auth_clients        = yes
smtpd_sasl_type                 = dovecot
# Can be an absolute path, or relative to $queue_directory
smtpd_sasl_path                 = private/auth
smtpd_tls_security_level        = may
smtpd_tls_auth_only             = yes
smtpd_tls_received_header       = yes
smtpd_tls_ask_ccert             = yes
smtpd_tls_loglevel              = 1
tls_random_source               = dev:/dev/urandom

#smtp_tls_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem
#smtp_tls_key_file=/etc/ssl/private/ssl-cert-snakeoil.key
#smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache

smtpd_helo_required             = yes
disable_vrfy_command            = yes
non_fqdn_reject_code            = 450
invalid_hostname_reject_code    = 450
maps_rbl_reject_code            = 450

smtpd_recipient_restrictions =
        permit_mynetworks
        permit_sasl_authenticated
        reject_unauth_destination
        reject_invalid_helo_hostname
        warn_if_reject reject_non_fqdn_helo_hostname
        warn_if_reject reject_unknown_helo_hostname
        warn_if_reject reject_unknown_client
        reject_non_fqdn_sender
        reject_non_fqdn_recipient
        reject_unknown_sender_domain
        reject_unknown_recipient_domain
        reject_rbl_client zen.spamhaus.org
        reject_rbl_client bl.spamcop.net
        reject_rbl_client dnsbl.sorbs.net=127.0.0.2
        reject_rbl_client dnsbl.sorbs.net=127.0.0.3
        reject_rbl_client dnsbl.sorbs.net=127.0.0.4
        reject_rbl_client dnsbl.sorbs.net=127.0.0.5
        reject_rbl_client dnsbl.sorbs.net=127.0.0.7
        reject_rbl_client dnsbl.sorbs.net=127.0.0.9
        reject_rbl_client dnsbl.sorbs.net=127.0.0.11
        reject_rbl_client dnsbl.sorbs.net=127.0.0.12
        warn_if_reject reject_rhsbl_sender dsn.rfc-ignorant.org
        warn_if_reject reject_rhsbl_sender abuse.rfc-ignorant.org
        warn_if_reject reject_rhsbl_sender whois.rfc-ignorant.org
        warn_if_reject reject_rhsbl_sender bogusmx.rfc-ignorant.org
        warn_if_reject reject_rhsbl_sender postmaster.rfc-ignorant.org
        permit
smtpd_data_restrictions =
        reject_unauth_pipelining,
        reject_multi_recipient_bounce,
        permit

#
# Postfix master process configuration file.  For details on the format
# of the file, see the master(5) manual page (command: "man 5 master").
#
# ==========================================================================
# service type  private unpriv  chroot  wakeup  maxproc command + args
#               (yes)   (yes)   (yes)   (never) (100)
# ==========================================================================
smtp      inet  n       -       n       -       -       smtpd -o content_filter=spamassassin
#smtp      inet  n       -       -       -       -       smtpd
#submission inet n       -       -       -       -       smtpd
#  -o smtpd_enforce_tls=yes
#  -o smtpd_sasl_auth_enable=yes
#  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
#smtps    inet    n    -    -    -    -    smtpd -o smtpd_tls_wrappermode=yes -o smtpd_sasl_auth_enable=yes -o smtpd_client_restrictions=permit_sasl_authenticated,reject
#628      inet  n       -       -       -       -       qmqpd
localhost:10025 inet n  -       n       -       -       smtpd
pickup    fifo  n       -       -       60      1       pickup
cleanup   unix  n       -       -       -       0       cleanup
qmgr      fifo  n       -       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 smtp_fallback_relay=
#       -o smtp_helo_timeout=5 -o smtp_connect_timeout=5
showq     unix  n       -       -       -       -       showq
error     unix  -       -       -       -       -       error
retry     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/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       n       -       -       pipe
  flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
  ${nexthop} ${user}
#
# Spamassassin
#
#spamassassin     unix  -       n       n       -       -       pipe
#   user=nobody argv=/usr/bin/spamc -e /usr/sbin/sendmail -oi -f ${sender} #${recipient}
  # Dovecot LDA
dovecot   unix  -       n       n       -       -       pipe
  flags=DRhu user=vmail:vmail argv=/usr/lib/dovecot/deliver -f ${sender} -d ${recipient}

user = root
password = xxxxx
hosts = localhost
dbname = postfix
table = alias
select_field = goto
where_field = address

user = postfix
password = djeIJ786dadasd23123kpqsxz
hosts = localhost
dbname = postfix
query = SELECT goto FROM alias WHERE address='%s'