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?
