Hello ~Lst, Wednesday, August 18, 2004, 6:14:41 PM, you wrote: Awalnya postfix dan mysql saya stop dulu, baru start ulang mulai dari postfix.
[EMAIL PROTECTED] root]# service postfix stop Shutting down postfix: [ OK ] [EMAIL PROTECTED] root]# ps -ax | grep mysql 1839 ? S 0:00 /bin/sh /opt/mysql/bin/mysqld_safe 1863 ? S 0:00 [mysqld] 2217 pts/2 S 0:00 grep mysql [EMAIL PROTECTED] root]# kill 1839 [EMAIL PROTECTED] root]# kill 1863 [EMAIL PROTECTED] root]# service postfix start Starting postfix: [ OK ] [EMAIL PROTECTED] root]# vi /etc/rc.local [EMAIL PROTECTED] root]# /opt/mysql/bin/mysqld_safe & [1] 2299 [1] Exit 127 /opt/mysql/mysqld_safe [EMAIL PROTECTED] root]# Starting mysqld daemon with databases from /opt/mysql/var [EMAIL PROTECTED] root]# hasil log postfix di tail -f /var/log/maillog Aug 19 08:33:12 jbn postfix/postfix-script: stopping the Postfix mail system Aug 19 08:33:12 jbn postfix/master[2294]: terminating on signal 15 Aug 19 08:34:03 jbn postfix/postfix-script: starting the Postfix mail system Aug 19 08:34:03 jbn postfix/master[2423]: daemon started -- version 2.2-20040801 hasil log mysql di tail -f /opt/mysql/var/jbn.hendratna.net.err 040819 8:26:06 InnoDB: Starting shutdown... 040819 8:26:08 InnoDB: Shutdown completed 040819 8:26:08 /opt/mysql/libexec/mysqld: Shutdown Complete 040819 08:26:08 mysqld ended 040819 08:28:30 mysqld started 040819 8:28:31 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 Lalu saya coba telnet [EMAIL PROTECTED] root]# telnet localhost 25 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 220 mail.hendratna.net ESMTP Postfix (2.2-20040801) helo hendratna.net 250 mail.hendratna.net ehlo hendratna.net 250-mail.hendratna.net 250-PIPELINING 250-SIZE 10240000 250-VRFY 250-ETRN 250 8BITMIME mail from:[EMAIL PROTECTED] sampai disini hang, hasil log di postfix Aug 19 08:37:31 jbn postfix/smtpd[3043]: connect from jbn.hendratna.net[127.0.0.1] Aug 19 08:38:32 jbn postfix/trivial-rewrite[3045]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Aug 19 08:38:32 jbn postfix/trivial-rewrite[3045]: fatal: mysql:/etc/postfix/mysql_virtual_domains_maps.cf(0,100): table lookup problem Aug 19 08:38:33 jbn postfix/smtpd[3043]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Aug 19 08:38:33 jbn postfix/smtpd[3043]: warning: problem talking to service rewrite: Success Aug 19 08:38:33 jbn postfix/master[2423]: warning: process /usr/libexec/postfix/trivial-rewrite pid 3045 exit status 1 Aug 19 08:38:34 jbn postfix/trivial-rewrite[3046]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Aug 19 08:38:34 jbn postfix/trivial-rewrite[3046]: fatal: mysql:/etc/postfix/mysql_virtual_domains_maps.cf(0,100): table lookup problem Aug 19 08:38:35 jbn postfix/smtpd[3043]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Aug 19 08:38:35 jbn postfix/smtpd[3043]: warning: problem talking to service rewrite: Success Aug 19 08:38:35 jbn postfix/master[2423]: warning: process /usr/libexec/postfix/trivial-rewrite pid 3046 exit status 1 Aug 19 08:38:35 jbn postfix/master[2423]: warning: /usr/libexec/postfix/trivial-rewrite: bad command startup -- throttling Lalu saya close consolenya hasil log di mysql Status information: Current dir: /opt/mysql/var/ Running threads: 0 Stack size: 196608 Current locks: key_cache status: blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key: 0 read_next: 0 read_rnd 0 read_first: 0 write: 0 delete 0 update: 0 Table status: Opened tables: 0 Open tables: 0 Open files: 2 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 [EMAIL PROTECTED] root]# ls -al /tmp/ total 60 drwxrwxrwt 14 root root 4096 Aug 19 08:34 . drwxr-xr-x 19 root root 4096 Aug 19 08:14 .. drwx------ 3 fansul fansul 4096 Aug 16 08:25 mcop-fansul drwx------ 3 root root 4096 Aug 19 08:18 mcop-root srwxrwxrwx 1 mysql mysql 0 Aug 19 08:34 mysql.sock drwx------ 2 fansul fansul 4096 Aug 16 08:25 orbit-fansul drwx------ 2 root root 4096 Aug 19 08:18 orbit-root drwx------ 2 root root 4096 Aug 19 08:17 ssh-XX9td66c -r--r--r-- 1 root root 11 Aug 19 08:14 .X0-lock drwxrwxrwt 2 root root 4096 Aug 19 08:14 .X11-unix Dimana lagi pak. terima kasih ~> betul, abis itu coba reload ulang postfix, stop mysql - trus start mysqlnya lagi (mnrt saya ada baiknya utk MySQL ini jgn cuman ngejalanin restart aja, tp perlu distop trus start servicenya), trus ~> coba liat di log-nya mysql apakah sdh terlihat spt ini : ~> bash-2.05b$ /usr/bin/sudo /usr/bin/tail -f /var/log/mysqld.log ~> /usr/sbin/mysqld-max: ready for connections. ~> Version: '4.0.20-Max-log' socket: '/tmp/mysql.sock' port: 3306 -- Best regards, ftrunbox mailto:[EMAIL PROTECTED]
