On Saturday 11 March 2006 10:04 am, Jim Douglas wrote: > When I login to mysql with > > mysql -u dbmail -p > it prompts for a password, I enter it and can connect. No problem. > > When I try to connect with, > > dbmail-users -l > > I get > Opening connection to database... > Failed. Could not connect to database (check log) > Command Failed. > > > This is my dbmail.conf, I know the socket, username, password, database are > correct... > > Thanks for your help.. > > > > # $Id: dbmail.conf 1539 2004-12-27 21:41:07Z paul $ > # (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. > > # when using a local socket connection to the > database, fill > # in the path to the socket here (e.g. > /var/run/mysql.sock) > sqlsocket=/var/lib/mysql/mysql.sock > > user=dbmail # user to connect as to database > pass=mypassword # password for user to database > db=dbmail # name of database > > # postmaster's email address. > [EMAIL PROTECTED] > > # trace level for dbmail-util > TRACE_LEVEL=2 > > [SMTP] > SENDMAIL=/usr/sbin/sendmail # sendmail executable for forwarding mail > AUTO_NOTIFY=no > AUTO_REPLY=no > TRACE_LEVEL=2 > > [LMTP] > # the user that dbmail-lmtpd will run as (need to be root to bind to a > port<1024) > EFFECTIVE_USER=root > > # the group that dbmail-lmtpd will run as > EFFECTIVE_GROUP=dbmail > BINDIP=* # the ipaddress the dbmail-lmtpd server has to > bind # to, * for all adresses. Use 127.0.0.1 to only # bind to localhost. > PORT=24 # the port number the dbmail-lmtpd server > has to bind to. NCHILDREN=20 # default number of LMTP > handlers (each is a process) MAXCHILDREN=10 # max. > number of LMTP handlers > MINSPARECHILDREN=2 > MAXSPARECHILDREN=4 > MAXCONNECTS=10000 # the maximum number of connections a > default childs makes > TIMEOUT=300 # the time (s) before the dbmail-lmtpd > should shutdown a connection which is being idle. > RESOLVE_IP=yes # if yes, the lmtp daemon resolves IP > numbers to DNS names in the log > TRACE_LEVEL=2 > MAX_ERRORS=500 > > [POP] > EFFECTIVE_USER=nobody # the user that dbmail-pop3d will run as > (need to be root to bind to a port<1024) > EFFECTIVE_GROUP=nogroup # the group that dbmail-pop3d will run as > BINDIP=* # the ipaddress the dbmail-pop3d server > has to bind to, * for all addresses > PORT=110 # the port number the dbmail-pop3d server > has to bind to. NCHILDREN=50 # default number of POP3 > handlers (each is a process) MAXCHILDREN=200 # mac. > number of POP3 handlers > MINSPARECHILDREN=2 > MAXSPARECHILDREN=4 > MAXCONNECTS=10000 # the maximum number of connections a > default childs makes > TIMEOUT=300 # the time (s) before the dbmail-pop3d > should shutdown a connection which is being idle. > RESOLVE_IP=yes # if yes, the pop daemon resolves IP > numbers to DNS names in the log > POP_BEFORE_SMTP=no > TRACE_LEVEL=2 > > [IMAP] > EFFECTIVE_USER=nobody > EFFECTIVE_GROUP=nogroup > BINDIP=* > PORT=143 > NCHILDREN=50 > MAXCHILDREN=200 # mac. number of IMAPD handlers > MINSPARECHILDREN=2 > MAXSPARECHILDREN=4 > MAXCONNECTS=10000 # the maximum number of connections a > default childs makes > TIMEOUT=4000 # the time (s) before the dbmail-imapd > should shutdown a connection which is being idle. > RESOLVE_IP=yes # if yes, the imap daemon resolves IP > numbers to DNS names in the log > IMAP_BEFORE_SMTP=no > TRACE_LEVEL=2 > > # end of configuration file
Did you check your log like it says?
