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 11:00:25 -0800
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
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
I tried rebuilding dbmail, that is my problem.
./configure --with -mysql runs ok
make all gives me this error,
libtool: link : cannot find library '/usr/lib/mysql/libz.la'
I rebuilt and reinstalled the MySQL source RPM's yesterday.
I have no idea what file it may be missing from the MySQl install, but
that's what I think is the problem.
Any suggestions?
Jim
