Blog of Roy Chan

Postfix and new server

Oct 16
2004

HKLUG’s Alpha DS10 is fucked up. It seems the harddisk is dying. Therefore, I’m trying to migrate every thing out. I have moved the main website and wiki to new niet and spent sometime to migrate the mail services. I decided to use Postfix instead of Exim and try to use MySQL as the forward table. However, the postfix fail to connect MySQL. Finally, I aware that postfix jail some processes under chroot environment and make them unable to access MySQL via Unix socket. After some consideration, I decide to switch on the TCP/IP connection of MySQL but blocking connection from outside via netfilter. Now, it work smoothly.

Today, I also migrate most xychen.org websites to new niet.

http://workaround.org/articles/ispmail-sarge/

Share It:

Comments

anthony

October 16th, 2004 | 9:40

well, you can set Mysql to just listen to 127.0.0.1, as such other computers can’t connect to it.
wayhorn

October 21st, 2004 | 10:54

… or you can simply set –skip-networking when you start mysql (changing this option in my.cnf works as well)
Roy Chan

November 1st, 2004 | 0:45

I know that. Otherwise, I won’t make it run. The only thing I aware after is that I need to use localhost.localdomain instead of localhost on the Postfix MySQL lookup. Otherwise, Postfix will still keep trying to connect MySQL via Unix Socket.