Re: SPAMD & Mysql & non standard Port

Jordi wrote on 10.08.2007 11:01:

> I try to use the 3308 because I have another mysql in 3306 and the SPAMD
> don't take the information of the local.cf file
>
> user_scores_dsn DBI:mysql:spamassassin:localhost:3308
>
>
> Mysql is running on port 3308 and using "/tmp/mysql2.sock" and NOT the
> "/tmp/mysql.sock"

You might want to try a different dsn string: - for port 3308:
DBI:mysql:spamassassin;host=localhost:3308 or
DBI:mysql:spamassassin;host=localhost;port=3308

(beware ":" and ";" difference)

or for the socket:
DBI:mysql:spamassassin;mysql_socket=/tmp/mysql2.sock

Keep in mind that either the port or the socket is used by a mysql client, but not both.

As a last resort, if all that is not working, modify the .my.cnf file for the user spamassassin or spamd is running under and make these entries:

[client]
host=localhost
port=3308

Do you need help?
In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related spamassassin.apache.org Links users Request more information about Pantek

or
[client]
socket=/tmp/mysql2.sock

or if you don't want to use the default .my.cnf file, give an explicit filename in the dsn string:

DBI:mysql:spamassassin;mysql_read_default_file=/etc/mail/spamassassin/.my.cnf and put the options into /etc/mail/spamassassin/.my.cnf. Received on Fri Aug 10 05:33:31 2007