OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: mysql support won't work--but no errors

From: lmh (lhdex.com)
Date: Wed Oct 01 2003 - 20:10:12 CDT


Larry Honig wrote:

>On Wed, 2003-10-01 at 13:54, Michael Breton wrote:
>
>
>
>>>I previously installed sleepycat's Berkeley DB ( db-4.1.25
>>>)(using Luc
>>>DeLouw's instructions; it seemed to compile and install just fine.
>>>
>>>
>>There is a companion db-4.1.25-devel package that you need to install as
>>well.
>>
>>Michael Breton
>>Commtel
>>
>>
>
>Thank you. The compile worked! This package is necessary, but that is not mentioned in Luc's instructions. Anyone else attempting to follow them will also probably run into this issue.
>
>In Mandrake 9.2 RC2 the package is called libdb4.1-devel-4.1.25-3mdk.i586.rpm, and a further dependency is libdbtcl4.1-4.1.25-3mdk.i586.rpm . These RPMS are on the International CD (CD 3)
>
>
>
I spoke a bit too soon. Now I have a compiled and installed Postfix
system. However when I start it I get the following message in
/var/log/mail/warnings:

Oct 1 20:29:50 paris postfix/cleanup[29243]: warning: connect to mysql server unix:/var/lib/mysql/mysql.sock: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Oct 1 20:29:50 paris postfix/cleanup[29243]: warning: 12904149E9: virtual_alias_maps map lookup problem for avalidusermyvaliddomain.com
Oct 1 20:29:50 paris postfix/cleanup[29243]: warning: 12904149E9: skipping further client input
Oct 1 20:29:50 paris postfix/pickup[29241]: warning: maildrop/308F15C3FC: Error writing message file

The system then throttles.

The line which reads

unix:/var/lib/mysql/mysql.sock:

originally read:

Oct 1 20:08:12 paris postfix/cleanup[28793]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I tried changing the hosts = localhost line in mysql-
 canonical.cf, mysql-virtual.cf and mysql-mysdestination.cf. I have also
changed the entry in master.cf for smtpd to read "n" in the chroot column.

Naturally I have stopped and restarted all of the daemons which could
possibly be involved; postfix, mysql, etc. and have also tried rebooting
the machine.

I am at a loss here. Mysql is running fine, the file which is referenced
exists in /var/lib/mysql and other processes (like web-cyradm) can
attach to and read and write from the Mysql database.

The only thing I can possibly point to is that I still seem to be
running the original copy of mysql, installed when I built the box using
Mandrake 9.2 RC2 CDs (version 4.0.14) rather than the version which I
downloaded, compiled and installed as part of Luc DeLouw's instructions,
which also confuses me.

Any help most appreciated! Thanks in advance.

/Larry Honig