Re: spamd & mysql redux

2006-02-22 Thread Barton L. Phillips
To specify the socket in a perl DBI connect do the following: my $DBH = DBI->connect('dbi:mysql:databaseName;mysql_socket=/tmp/mysql.sock', 'user', 'password', {ShowErrorStatement => 1}) or die "Can't open database"; Steve Thomas wrote: Feb 22 11:45:42 ronin spamd[3322]: bayes:

Re: spamd & mysql redux

2006-02-22 Thread Matthias Fuhrmann
On Wed, 22 Feb 2006, Steve Thomas wrote: > > i googled a bit and found this related to fedora3 and SELinux: > > http://forums.mysql.com/read.php?11,20759,21482#msg-21482 > > I had seen that page, but didn't know what selinux was (thought it was a > distro!) so I thought it was irrelevant. After ch

Re: spamd & mysql redux

2006-02-22 Thread Steve Thomas
> i googled a bit and found this related to fedora3 and SELinux: > http://forums.mysql.com/read.php?11,20759,21482#msg-21482 I had seen that page, but didn't know what selinux was (thought it was a distro!) so I thought it was irrelevant. After checking it out, it turns out that that's what the pr

Re: spamd & mysql redux

2006-02-22 Thread Scott Russell
Steve Thomas wrote: I'm most curious about the error number given - (13). In mysql speak, that's a 'permission denied', but according to the logs, there's no connection attempt even being made. I don't know if that number is coming from spamd, the perl db api or mysql. I doubt it's coming from my

Re: spamd & mysql redux

2006-02-22 Thread Matthias Fuhrmann
On Wed, 22 Feb 2006, Steve Thomas wrote: > >> Feb 22 11:45:42 ronin spamd[3322]: bayes: unable to connect to database: > >> Can't connect to local MySQL server through socket > >> '/var/lib/mysql/mysql.sock' (13) > > > > Is that where mysql.sock is located? I don't know where the MySQL RPMs > > mi

Re: spamd & mysql redux

2006-02-22 Thread Steve Thomas
>> Feb 22 11:45:42 ronin spamd[3322]: bayes: unable to connect to database: >> Can't connect to local MySQL server through socket >> '/var/lib/mysql/mysql.sock' (13) > > Is that where mysql.sock is located? I don't know where the MySQL RPMs > might > stick it, but source installs stick it at /tmp/m

Re: spamd & mysql redux

2006-02-22 Thread Mike Jackson
Feb 22 11:45:42 ronin spamd[3322]: bayes: unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) Is that where mysql.sock is located? I don't know where the MySQL RPMs might stick it, but source installs stick it at /tmp/mysql.sock by

spamd & mysql redux

2006-02-22 Thread Steve Thomas
Howdy list, I'm having the exact same problem that Glenn is/was having as posted about last week. (see http://article.gmane.org/gmane.mail.spam.spamassassin.general/77708) I'm using Fedora Core 4, perl 5.8.6, SA 3.1.0 and mysql 4.1. SA was installed by building an RPM directly from the tarball. I