conecting to a db on another machine didn't work either. should I give up or hope someone from the dev team comes up with THE solution?
Alex On Sat, 2004-10-16 at 17:40, Alex Broens wrote: > 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 > > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
