Well, one of two things is going on, either it's not using that dbmail.conf file, or the user/pw is incorrect. I don't see many other alternatives.
-Micah On Saturday 11 March 2006 10:47 am, Jim Douglas wrote: > >From: Micah Stevens <[EMAIL PROTECTED]> > >Reply-To: DBMail mailinglist <[email protected]> > >To: DBMail mailinglist <[email protected]> > >Subject: Re: [Dbmail] Receiving mail > >Date: Sat, 11 Mar 2006 10:13:17 -0800 > > > >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? > > > > > >_______________________________________________ > >Dbmail mailing list > >[email protected] > >https://mailman.fastxs.nl/mailman/listinfo/dbmail > > Entering this, > > dbmail-users -l > > this is what is in the log file.... > > Mar 11 13:39:30 cpe-66-65-161-178 dbmail/adduser[4139]: > dbmysql.c,db_connect: mysql_real_connect failed: Access denied for user > 'root'@'localhost' (using password: NO) > > I would have thought it would be using dbuser from the /etc/dbmail.conf > file... > > > Jim > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
