Postfix + MySql_502

[Peter Novak]

> pred par dny jsem si hral s postfixem a
> postgresem. muzes ukazat prislusne
> soubory?

instalovane:
/usr/ports/mail/postfix (make WITH_MYSQL=YES WITH_MYSQL_VER=50)
/usr/ports/security/pam-mysql
/usr/ports/security/cyrus-sasl2-saslauthd
/usr/ports/archivers/zoo
/usr/ports/security/amvisd-new  (make WITH_MYSQL)
/usr/ports/mail/postfixadmin  (pri vytvoreni tabulky alias bola chyba stlpca "goto")
*************************************************

/usr/local/etc/postfix/main.cf 
------------------------------
command_directory = /usr/sbin
daemon_directory = /usr/lib/postfix
program_directory = /usr/lib/postfix 
myorigin = doma 
mydomain = doma
myhostname = server.doma
mydestination = $myhostname, localhost.$mydomain, $mydomain
mynetworks = 10.1.1.0
virtual_mailbox_limit = 10000000
virtual_mailbox_base = /home/vmail/
virtual_uid_maps = static:1002
virtual_gid_maps = static:1002
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-maps.cf
alias_maps = mysql:/etc/postfix/mysql-aliases.cf
transport_maps = mysql:/etc/postfix/mysql-transport.cf
virtual_maps = mysql:/etc/postfix/mysql-virtual.cf
local_recipient_maps = $alias_maps $virtual_mailbox_maps unix:passwd.byname
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = $myhostname
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, check_relay_domains
smtpd_sasl_security_options = noanonymous
broken_sasl_auth_clients = yes
smtpd_banner = $myhostname ESMTP on  FreeBSD
setgid_group = postdrop
biff = no
append_dot_mydomain = no
relayhost =  
mailbox_size_limit = 0
recipient_delimiter = +
message_size_limit = 10000000

/usr/local/etc/postfix/mysql-virtual-maps.cf 
-------------------------------------------
user = postfix
password = postx
dbname = postfix
table = users
select_field = maildir
where_field = email
additional_conditions = and postfix = 'y'
hosts = localhost

/usr/local/etc/postfix/mysql-aliases.cf 
-----------------------------------------
user = postfix
password = postx
dbname = postfix
table = alias
select_field = destination
where_field = alias
hosts = localhost

/usr/local/etc/postfix/mysql-transport.cf 
------------------------------------------
user = postfix
password = postx
dbname = postfix
table = transport
select_field = destination
where_field = domain
hosts = localhost

/usr/local/etc/postfix/mysql-virtual.cf 
------------------------------------------
user = postfix
password = postx
dbname = postfix
table = virtual
select_field = destination
where_field = email
hosts = localhost

Doplnene do /usr/local/etc/postfix/master.cf 
---------------------------------------------
...
smtp-amavis unix -      -       n     -       2  smtp
   -o smtp_data_done_timeout=1200
   -o disable_dns_lookups=yes

127.0.0.1:10025 inet n  -       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



________
Videli ste uz http://blog.sme.sk? 
Najpopularnejsie dennicky na slovenskom internete.