dedy wrote:
terima kasih atas tanggapannya.
untuk lebih memperjelas permasalahan saya lampirkan detail error
seperti dibawah ini :
May 17 18:07:53 server postfix/trivial-rewrite[5227]: warning: connect
to mysql server localhost: Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2)
May 17 18:07:53 server postfix/trivial-rewrite[5227]: fatal:
mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,lock|fold_fix): table
lookup problem
May 17 18:07:54 server postfix/cleanup[5119]: warning: premature
end-of-input on private/rewrite socket while reading input attribute name
May 17 18:07:54 server postfix/cleanup[5119]: warning: problem talking
to service rewrite: Connection reset by peer
May 17 18:07:54 server postfix/master[5113]: warning: process
/usr/libexec/postfix/trivial-rewrite pid 5227 exit status 1
May 17 18:07:54 server postfix/master[5113]: warning:
/usr/libexec/postfix/trivial-rewrite: bad command startup -- throttling
May 17 18:07:54 server postfix/smtpd[5213]: warning: premature
end-of-input on private/rewrite socket while reading input attribute name
May 17 18:07:54 server postfix/smtpd[5213]: warning: problem talking
to service rewrite: Success
mohon pencerahannya
terima kasih
dedy
jalanain command ini di cli , netstat -pln | grep :3306 apakah mysqld
nya listen di tcp socket atau cuma di unix domain socket.
contoh:
[r...@mx1 postfix]# netstat -pln | grep :3306
tcp 0 0 0.0.0.0:3306
0.0.0.0:* LISTEN 3861/mysqld
isi mysql_virtual_alias_maps.cf gimana?
contoh punya saya:
user = user
password = password
hosts = localhost
dbname = maps
query = SELECT goto FROM alias WHERE address='%s' AND active = 1
kalau parameter hostsnya di set localhost coba di set 127.0.0.1 (hosts =
127.0.0.1), pastikan mysqld nya listen juga di tcp socket.
ini kutipan dari website official tentang mysql lookup table
*MYSQL PARAMETERS*
*hosts* The hosts that Postfix will try to connect to and
query from. Specify /unix:/ for UNIX domain sockets,
/inet:/ for TCP connections (default). Example:
hosts = host1.some.domain host2.some.domain
hosts = unix:/file/name
The hosts are tried in random order, with all con-
nections over UNIX domain sockets being tried
before those over TCP. The connections are auto-
matically closed after being idle for about 1
minute, and are re-opened as necessary. Postfix
versions 2.0 and earlier do not randomize the host
order.
NOTE: if you specify localhost as a hostname (even
if you prefix it with /inet:/), MySQL will connect to
the default UNIX domain socket. In order to
instruct MySQL to connect to localhost over TCP you
have to specify
hosts = 127.0.0.1
http://www.postfix.org/mysql_table.5.html
di website nya semua nya sebenarnya udah lengkap banget.cuma harus
rajin2 aja liat.
cmiiw
PT.CITRA SARI MAKMUR
SATELLITE & TERRESTRIAL NETWORK
Connecting the distance - anytime, anywhere, any content
http://www.csmcom.com
