David Hrbáč wrote:
> Thorsten,
> send postfix/mysql configuration files. Majority of mysql+postfix howtos
> is broken and copied from one source. So send the configs.
> David
# postconf -n
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases, hash:/etc/mailman/aliases
biff = no
command_directory = /usr/sbin
config_directory = /etc/postfix
daemon_directory = /usr/libexec/postfix
debug_peer_level = 2
default_destination_concurrency_limit = 50
default_process_limit = 30
delay_warning_time = 4h
disable_vrfy_command = yes
fallback_transport = virtual
home_mailbox = Maildir/
html_directory = no
in_flow_delay = 1s
inet_interfaces = $myhostname, localhost
local_destination_concurrency_limit = 5
local_recipient_maps = unix:passwd.byname $alias_maps
mail_owner = postfix
mailq_path = /usr/bin/mailq.postfix
manpage_directory = /usr/share/man
maximal_queue_lifetime = 3d
message_size_limit = 15240000
mydestination = $myhostname, localhost.$mydomain, $mydomain
mydomain = mydomain.com
myhostname = mail.mydomain.com
mynetworks = 127.0.0.0/8 <MYOFFICENETWORKIP>
newaliases_path = /usr/bin/newaliases.postfix
owner_request_special = no
proxy_interfaces = <BACKUPMXIP>
queue_directory = /var/spool/postfix
readme_directory = /usr/share/doc/postfix-2.2.10/README_FILES
relay_domains = $transport_maps
sample_directory = /usr/share/doc/postfix-2.2.10/samples
sendmail_path = /usr/sbin/sendmail.postfix
setgid_group = postdrop
smtpd_helo_required = yes
smtpd_recipient_restrictions = permit_mynetworks,
reject_rbl_client sbl-xbl.spamhaus.org, reject_unauth_destination,
reject_non_fqdn_sender, reject_non_fqdn_recipient,
reject_unlisted_recipient, reject_unknown_recipient_domain,
reject_unauth_destination
soft_bounce = no
transport_maps = mysql:/etc/postfix/sql/transport
unknown_local_recipient_reject_code = 550
virtual_gid_maps = static:507
virtual_mailbox_base = /server/vmail
virtual_mailbox_maps = mysql:/etc/postfix/sql/vmailbox
virtual_minimum_uid = 500
virtual_transport = $transport_maps
virtual_uid_maps = static:507
master.cf
smtp inet n - n - 25 smtpd
pickup fifo n - n 60 1 pickup
cleanup unix n - n - 0 cleanup
qmgr fifo n - n 300 1 qmgr
rewrite unix - - n - - trivial-rewrite
bounce unix - - n - 0 bounce
defer unix - - n - 0 bounce
trace unix - - n - 0 bounce
verify unix - - n - 1 verify
flush unix n - n 1000? 0 flush
proxymap unix - - n - - proxymap
smtp unix - - n - 10 smtp
relay unix - - n - - smtp
# -o smtp_helo_timeout=5 -o smtp_connect_timeout=5
showq unix n - n - - showq
error unix - - n - - error
local unix - n n - - local
virtual unix - n n - - virtual
lmtp unix - - n - - lmtp
anvil unix - - n - 1 anvil
maildrop unix - n n - - pipe
flags=DRhu user=vmail argv=/usr/bin/maildrop -d ${recipient}
old-cyrus unix - n n - - pipe
flags=R user=cyrus argv=/usr/lib/cyrus-imapd/deliver -e -m
${extension} ${user}
# Also specify in main.cf: cyrus_destination_recipient_limit=1
cyrus unix - n n - - pipe
user=cyrus argv=/usr/lib/cyrus-imapd/deliver -e -r ${sender} -m
${extension} ${user}
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=foo argv=/usr/local/sbin/bsmtp -f $sender $nexthop
$recipient
scache unix - - n - 1 scache
my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
port=3306
#
# Local changes. /JRG
#
max_connections = 125
thread_cache = 25
thread_concurrency = 4
key_buffer = 64M
table_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 1M
join_buffer_size = 1M
query_cache_limit = 2M
query_cache_size = 32M
max_allowed_packet = 8M
#
# Set buffer pool size to 50-80% of your computer's memory
set-variable = innodb_buffer_pool_size=64M
set-variable = innodb_additional_mem_pool_size=16M
#
# Set the log file size to about 25% of the buffer pool size
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
[mysql.server]
user=mysql
basedir=/var/lib
set-variable = thread_concurrent=4
set-variable = wait_timeout=30
set-variable = thread_cache_size=25
port=3306
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
