Got it. Problem: âDbmail cannot connect to the database serverâ. Previous posts to dbmail threads, suggest this is a database connection problem. However the database connection works fine. It is only when the server is switched to ldap auth that this is showing up. Not sure of what to do next.
Fix: Enable OpenLDAP has a setting to allow LDAP Version 2. Uncomment the "allow bind_v2" line in the "slapd.conf". Restart your LDAP server. I'm assuming that dbmail requires ldap version 2, since uncommenting this line, enabling version2, seems to fix the problem. BTW: I am running OpenLDAP: slapd 2.2.26 and dbmail 2.2 - Kevin --- Kevin Baker <[EMAIL PROTECTED]> wrote: > > > --- Kevin Baker <[EMAIL PROTECTED]> wrote: > > > Reply below... > > > > > > --- Paul J Stevens <[EMAIL PROTECTED]> wrote: > > > > > > > > > Kevin Baker wrote: > > > > So I'm back to the ldap configuration. Still not > > there. > > > > > > > > I have DBMail working perfectly on just mysql auth. > > > When I > > > > switch to the "ldap" auth, I get "the can not > connect > > > to > > > > the database" error. > > > > > > Could you be a tiny bit more verbose? Like some > level5 > > > log lines > > > perhaps... That should point to where this is coming > > > from. > <snip: Kevin's responses to Paul suggests> > > Below is a copy of my dbmail.conf.. maybe that will help. > > > > > # $Id: dbmail.conf 1992 2006-02-21 07:22:57Z aaron $ > # (c) 2000-2006 IC&S, The Netherlands > # > # Configuration file for DBMAIL > > [DBMAIL] > # Database settings > driver=mysql # Supported drivers are mysql, > pgsql, sqlite. > authdriver=ldap # Supported drivers are sql, > ldap. > host=localhost > # the same host as dbmail and > you > want to use a local > # socket for connecting. > sqlport= # If you want to use TCP/IP for > connecting to the database, > # and have the database running > on a non-standard port. > sqlsocket= #/var/run/mysqld/mysqld.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=mail > pass=MYSECRET > db=dbmail > #table_prefix=dbmail_ # Table prefix. Defaults to > "dbmail_" if not specified. > [EMAIL PROTECTED] # > Postmaster's email address for use in bounce messages. > sendmail=/usr/sbin/sendmail # Sendmail executable for > forwards, replies, notifies, vacations. > > # The following items can be overridden in the > service-specific sections. > TRACE_SYSLOG=5 # Trace level to send to syslog. > Default is 2 (errors, fatals). > TRACE_STDERR=2 # Trace level to send to stderr. > Default is 0 (fatals). > EFFECTIVE_USER=dbmail # Root privs are used to open a > port, then privs > EFFECTIVE_GROUP=dbmail # are dropped down to the > user/group specified here. > BINDIP=* # The IP address the services > will > bind to. > # Use * for all local > interfaces. > # Use 127.0.0.1 for localhost > only. > NCHILDREN=2 # Default number of child > processes > to start. > MAXCHILDREN=10 # Maximum number of child > processes > allowed. > MINSPARECHILDREN=2 # Unused children to always have > availale. > MAXSPARECHILDREN=4 # Maximum unused children allowed > to be active. > MAXCONNECTS=10000 # Child process is restarted > after > handling this many connections. > MAX_ERRORS=500 # Child process will restart > after > this many connection errors. > TIMEOUT=300 # Idle time allowed before a > connection is shut off. > RESOLVE_IP=yes # If yes, resolves IP addresses > to > DNS names when logging. > > [SMTP] > # In fact, there isn't anything > here by default. > > [LMTP] > PORT=24 # Port to bind to. > > [POP] > PORT=110 # Port to bind to. > POP_BEFORE_SMTP=no # If yes, allows SMTP access from > the host IP connecting by POP3. > > [IMAP] > PORT=143 # Port to bind to. > TIMEOUT=4000 # IMAP prefers a longer timeout > than other services. > IMAP_BEFORE_SMTP=no # If yes, allows SMTP access from > the host IP connecting by IMAP. > > [SIEVE] > PORT=2000 # Port to bind to. > > [LDAP] > BASE_DN=dc=MYDOMAINNAME,dc=com > BIND_DN=cn=manager,cn=internal,dc=MYDOMAINNAME,dc=com > BIND_PW=TD1RyDtAfC > SCOPE=SubTree > PORT=389 > HOSTNAME=localhost > USER_OBJECTCLASS=top,inetOrgPerson,kolabInetOrgPerson > #FORW_OBJECTCLASS=top,account,dbmailForwardingAddress > CN_STRING=uid > FIELD_PASSWD=userPassword > FIELD_UID=uid > FIELD_NID=uidNumber > MIN_NID=1 > MAX_NID=150000000 > FIELD_CID=gidNumber > MIN_CID=1 > MAX_CID=150000000 > FIELD_MAIL=mail > FIELD_QUOTA=cyrus-userquota > #FIELD_FWDTARGET=mailForwardingAddress > > [DELIVERY] > SIEVE=yes # Run Sieve scripts as messages > are > delivered. > SUBADDRESS=yes # Use '[EMAIL PROTECTED]' > format > to deliver to a mailbox. > SIEVE_VACATION=yes # Turn on/off the Sieve Vacation > extension (unsupported). > SIEVE_NOTIFY=no # Turn on/off the Sieve Notify > extension (unsupported). > AUTO_NOTIFY=no # Use the auto_notify table to > send > email notifications. > AUTO_REPLY=no # Use the auto_reply table to > send > away messages. > > > > # end of configuration file > > > Kevin Baker > Mission Vi Inc. > [EMAIL PROTECTED] > 858.454.5532 > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection > around > http://mail.yahoo.com > Kevin Baker Mission Vi Inc. [EMAIL PROTECTED] 858.454.5532 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
