Re: postfix + mysql
try this.. change the location for mysqld.sock location under [mysqld] and
[mysqld_safe] (in /etc/mysql/my.cnf) to /var/spool/postfix/var/run/mysqld/mysqld.sock .. ln
/var/spool/postfix/var/run/mysqld/mysqld.sock to /var/run/mysqld/ ...
your going to have to create /var/run/mysqld in /var/spool/postfix and
make sure ownership's right. restart mysql.
as i understand it, postfix cant access mysqld.sock since it doesn't
live in the postfix chroot.
~august
* Pim Bliek <pim.bliek@gmail.com>
|__ Sat, Jul 10, 2004 at 01:14:09AM +0200:
> Hi everybody,
>
> I am struggling with this one for hours now. Google doesn't help me
> anymore. I feel like I want to tear the hair out of my head. Maybe
> someone might be able to help on this one.
>
> I am trying to setup Postfix + MySQL, according to lots of HOWTO's,
> but most closely according to this one because I'd like to use
> webbased Postfix admin: http://www.high5.net/howto/
>
> Anyway, all is in place. Databse is up. Postfix admin PHP stuff
> connects to MySQL and works. I can login to MySQL from the shell. All
> config files are there, in place, etc.
>
> But, when I start postfix I get this in my logs:
>
> Jul 10 00:38:01 srv1 postfix/master[32687]: daemon started -- version 2.1.3
> Jul 10 00:38:01 srv1 postfix/qmgr[32691]: B1D3931313:
> from=<noreply@srv1.mydomain.tld>, size=333, nrcpt=1 (queue active)
> Jul 10 00:38:01 srv1 postfix/pickup[32690]: 1A6B73131D: uid=0 from=<root>
> Jul 10 00:38:01 srv1 postfix/cleanup[32692]: warning: connect to mysql
> server unix:/var/run/mysqld/mysqld.sock: Can't connect to local MySQL
> server through socket '/var/run/mysqld/mysqld.sock' (2)
> Jul 10 00:38:01 srv1 postfix/cleanup[32692]: warning: 1A6B73131D:
> virtual_alias_maps map lookup problem for root@mydomain.tld
> Jul 10 00:38:01 srv1 postfix/pickup[32690]: warning:
> maildrop/80A2831319: Error writing message file
>
> But, when I try to connect via commandline using this same socket it works
> :
> srv1:/var/log/mysql# mysql -S /var/run/mysqld/mysqld.sock -u postfix -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 320 to server version: 4.0.20-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql>
>
> Versions used:
> ii postfix 2.1.3-0.backpo A high-performance mail transport agent
> ii postfix-doc 2.1.3-0.backpo Postfix documentation
> ii postfix-mysql 2.1.3-0.backpo MYSQL map support for Postfix
> ii postfix-tls 2.1.3-0.backpo TLS and SASL support for Postfix
> ii libdbd-mysql-p 1.2216-2 mySQL database interface for Perl
> ii libmysqlclient 4.0.20-0.dotde mysql database development files
> ii libmysqlclient 3.23.49-8.6 mysql database client library
> ii libmysqlclient 4.0.20-0.dotde mysql database client library
> ii libpam-mysql 0.4.7-1 PAM module allowing authentication from a My
> ii mysql-client 4.0.20-0.dotde mysql database client binaries
> ii mysql-common 4.0.20-0.dotde mysql database common files (e.g. /etc/mysql
> ii mysql-server 4.0.20-0.dotde mysql database server binaries
> ii php4-mysql 4.3.7-1.dotdeb MySQL module for php4
> ii postfix-mysql 2.1.3-0.backpo MYSQL map support for Postfix
>
> Got the backports from backports.org ad dotdebs.org for Woody. Maybe
> this is an ugly mix? If someone knows a consistent backport source for
> postfix + mysql + courier-imap + maildrop (including mysql suppot, I
> built my own from source) I will be more than happy.
> I am totally lost. Anyone with bright idea's? If you live close to
> Amsterdam I will get you a round of beer :) LOL. Damn, I need a beer
> myself after this stuff. Or maybe just sleep.
>
> Best regards,
>
> Pim
>
>
> --
> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
--
August MacBeth
System Administrator
HiP Design
824 N. Victory Blvd Suite 2A
Burbank, CA 91502
http://www.hipdesign.com
Reply to: