saya kemarin menginstall postfix dan mengkonfigurasi agar berjalan dengan mysql sbg backendnya serta postfixadmin sebagai frontend nya. kira2 environment system saya sebagai berikut
uid postfix=108
gui postfix=110
virtual mail tersimpan di /var/mail (chown ke postfix dan chmod 751)
berikut tambahan konfigurasi postfix(main.cf)
======================================
virtual_alias_maps = mysql:/etc/postfix/mysql/valias
virtual_mailbox_domains = mysql:/etc/postfix/mysql/vdomain
virtual_mailbox_maps = mysql:/etc/postfix/mysql/vmailbox
virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql/vquota
virtual_mailbox_base = /var/mail
virtual_transport = virtual
virtual_uid_maps = static:108
virtual_gid_maps = static:110
virtual_minimum_uid = 108
dan berikut tambahan konfigurasi mapping virtualnya
==================================
user = root
password = rahasia
hosts = localhost
dbname = dbpostfix
table = alias
select_field = goto
where_field = addres
setelah saya jalankan postfix kelihatan lancar, tp setelah saya buat alias d postfixadmin ternyata dalam log-nya muncul pesan seperti ini:
fatal: mysql:/etc/postfix/mysql/valias(0,lock|fold_fix): table lookup problem
warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
fatal: mysql:/etc/postfix/mysql/valias(0,lock|fold_fix): table lookup problem
warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
mysql:/etc/postfix/mysql/valias(0,lock|fold_fix): table lookup problem
warning: process /usr/lib/postfix/trivial-rewrite pid 24535 exit status 1
/usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
warning: problem talking to service rewrite: Connection reset by peer
warning: premature end-of-input on private/rewrite socket while reading input attribute name
warning: problem talking to service rewrite: Success
warning: process /usr/lib/postfix/trivial-rewrite pid 24537 exit status 1
berikut ini konfigurasi mysql
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
kira-kira apa ya penyebabnya dan solusinya bagaimana ya?
saya sudah mengikuti beberapa petunjuk dari internet dan belum berhasil, bagi para master postfix apa ada tutorial lain yang jitu?
o ya linux yg saya pake debian 4
terimakasih