Thanks for your reply, Peter nothing is chrooted (till it works .-)
using socket or not its still not working: connect failed: Unknown MySQL Server Host ' 192.168.192.181' (1) connect failed: Unknown MySQL Server Host ' localhost' (1) any other tool can connect to the DB, only DBMAIL can't. Looked into DNS, hosts, etc settings. All seem correct. Will try using an external MySql machine, just for the heck of it as I have the feeling that its DBMAIL and not my setup which is playing games with me. thanks Alex On Sat, 2004-10-16 at 16:00, Peter wrote: > I think that dbmail user is not allowed to read the socket directory. > Most probabbly it is chrooted or something like that. > Try NOT to use socket , but TCP/IP. You can achieve that by putting IP > adress of the server(e.g 123.456.789.111) instead of localhost or > 127.0.0.0.1 > Another solution is to remove the chroot or make symlink, or if not chrooted > simply to allow that user to red socket dir > > I hope this helps > > Peter > ----- Original Message ----- > From: Alex Broens > To: [email protected] > Sent: Saturday, October 16, 2004 4:17 PM > Subject: [Dbmail] DBmail 2.0 - FC2 - can't connect - mysql.sock > > > Good Day, > I'm a DBmail newbie with a little problemm which has driven me nuts for > a long day and no matter what I do I don't get any further. > > -------------- > dbmail-util -tvp produces: > > Oct 16 11:22:16 mail dbmail/maintenance[3433]: dbmysql.c,db_connect: > mysql_real_connect failed: Can't connect to local MySQL server through > socket ' /var/lib/mysql/mysql.sock' (2) > --------------- > dbmail-users -v -a [EMAIL PROTECTED] -w passwd -g 0 -m 100M @domain.tld > produces: > > Oct 16 15:13:32 mail dbmail/adduser[3497]: dbmysql.c,db_connect: > mysql_real_conn ect failed: Can't connect to local MySQL server through > socket ' /var/lib/mysql/ mysql.sock' (2) > -------------- > > Pls see diagnostics below: > > Using Fedora Core2 / MySQL 4.0.21-Max > I can connect to MySQL with phpmyadmin and or cli tools. > > mysql> \s > -------------- > mysql Ver 12.22 Distrib 4.0.21, for pc-linux (i686) > > Connection id: 10 > SSL: Not in use > Current pager: stdout > Using outfile: '' > Server version: 4.0.21-Max > Protocol version: 10 > Connection: Localhost via UNIX socket > Client characterset: latin1 > Server characterset: latin1 > UNIX socket: /var/lib/mysql/mysql.sock > -------------- > > dbmail.conf: > # $Id: dbmail.conf,v 1.105.2.1 2004/08/23 14:46:05 ilja Exp $ > # (c) 2000-2002 IC&S, The Netherlands > # > # Configuration file for DBMAIL > # This configuration file needs to be run through dbmail-config to be > effective > # after that, changes are effective inmediatly > > > [DBMAIL] > # Database settings > host=localhost # host for database, set to localhost if > database is om > # the same host as dbmail and you want to use a > local socket > # for connecting. > sqlport= 3306 # if you want to use TCP/IP for connecting to > the database, > # and have the database running on a > non-standard port. > sqlsocket= /var/lib/mysql/mysql.sock # when using a local socket > connection to the database, fill > # in the path to the socket here (e.g. > /var/run/mysql.sock) > user=dbmail # user to connect as to database > pass=passwd # password for user to database > db=dbmail # name of database > [EMAIL PROTECTED] # postmaster's email address. > # trace level for dbmail-util > TRACE_LEVEL=10 > ------------------------ > > > Would really appreciate a hint which will get me further. > > Thanks > > Alex > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
