I've been down for 24 hours all my users are dead in the water.
Installation:
os: debian
mysql 5.0x
dbmail 2.2.4
Used apt-get to install dbmail. Until upgrade I have had dbmail working for
several years on the 2.0 version. I ran the dbmail migration from
2.0-2.2script with no problems. When I try to run dbmail-util -by I
get Failed to
connect to database error. phpMyAdmin can connect as root.
dbmail-imapd is eating up all connections in mysql so I can only attempt to
connect as root for max_connections +1 ability.
Here is my dbmail.err log and my dbmail.conf is below it.
Debug:[db] dbmodule.c,db_load_driver(+67): looking for mysql as
modules/.libs/libmysql.so
Info:[db] dbmodule.c,db_load_driver(+71): cannot load
modules/.libs/libmysql.so: cannot open shared object file: No such file or
directory
Debug:[db] dbmodule.c,db_load_driver(+67): looking for mysql as
/usr/lib/dbmail/libmysql.so
Error:[sql] dbmysql.c,db_connect(+171): mysql_real_connect failed: Access
denied for user 'root'@'localhost' (using password: YES)
FATAL:[server] server.c,StartServer(+121): Unable to connect to database.
Debug:[server] server.c,server_run(+264): server has exited, exit status
[75]
Debug:[serverparent] serverparent.c,DoConfig(+214): reading config
[/etc/dbmail/dbmail.conf]
Debug:[serverparent] serverparent.c,LoadServerConfig(+244): server will
create [5] children
Debug:[serverparent] serverparent.c,LoadServerConfig(+257): children will
make max. [10000] connections
Debug:[serverparent] serverparent.c,LoadServerConfig(+270): timeout [300]
seconds
Debug:[serverparent] serverparent.c,LoadServerConfig(+275): no value for
SOCKET in config file
Debug:[serverparent] serverparent.c,LoadServerConfig(+278): socket []
Debug:[serverparent] serverparent.c,LoadServerConfig(+290): binding to PORT
[110]
Debug:[serverparent] serverparent.c,LoadServerConfig(+306): binding to IP
[*]
Debug:[serverparent] serverparent.c,LoadServerConfig(+313): no value for
BACKLOG in config file. Using default value [16]
Debug:[serverparent] serverparent.c,LoadServerConfig(+327): not resolving
client IP
Debug:[serverparent] serverparent.c,LoadServerConfig(+341): Enabling
POP-before-SMTP
Debug:[serverparent] serverparent.c,LoadServerConfig(+353): effective user
shall be [dbmail]
Debug:[serverparent] serverparent.c,LoadServerConfig(+365): effective group
shall be [dbmail]
Debug:[serverparent] serverparent.c,LoadServerConfig(+377): will maintain
minimum of [2] spare children in reserve
Debug:[serverparent] serverparent.c,LoadServerConfig(+389): will maintain
maximum of [10] spare children in reserve
Debug:[serverparent] serverparent.c,LoadServerConfig(+401): will allow
maximum of [200] children
Debug:[server] server.c,dm_socket(+339): done
Debug:[server] server.c,create_inet_socket(+409): creating socket on [*:110]
with backlog [16]
Debug:[server] server.c,dm_bind_and_listen(+359): done
Debug:[db] dbmodule.c,db_load_driver(+67): looking for mysql as
modules/.libs/libmysql.so
Info:[db] dbmodule.c,db_load_driver(+71): cannot load
modules/.libs/libmysql.so: cannot open shared object file: No such file or
directory
Debug:[db] dbmodule.c,db_load_driver(+67): looking for mysql as
/usr/lib/dbmail/libmysql.so
Error:[sql] dbmysql.c,db_connect(+171): mysql_real_connect failed: Access
denied for user 'root'@'localhost' (using password: YES)
FATAL:[server] server.c,StartServer(+121): Unable to connect to database.
dbmail.conf
# $Id: dbmail.conf 2437 2007-02-26 09:50:25Z paul $
# (c) 2000-2006 IC&S, The Netherlands
#
# Configuration file for DBMAIL
[DBMAIL]
#
# Database settings
#
#
# Supported drivers are mysql, pgsql, sqlite.
#
driver = mysql
#
# Supported drivers are sql, ldap.
#
authdriver = sql
#
# Host for database, set to localhost if database is on
# the same host as dbmail and you want to use a local
# socket for connecting.
#
host = localhost
#
# If you want to use TCP/IP for connecting to the database,
# and have the database running on a non-standard port.
#
sqlport =
#
# 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/run/mysqld/mysqld.sock
#
# Database username.
#
user = root
#
# Database password.
#
pass = password
#
# Database name.
#
db = dbmail
#
# Table prefix. Defaults to "dbmail_" if not specified.
#
table_prefix = dbmail_
#
# encoding must match the database/table encoding.
#
encoding = latin1_swedish_ci
#
# messages with unknown encoding will be assumed to have
# default_msg_encoding
#
default_msg_encoding = latin1_swedish_ci
#
# Postmaster's email address for use in bounce messages.
#
postmaster = [EMAIL PROTECTED]
#
# Sendmail executable for forwards, replies, notifies, vacations.
# You may use pipes (|) in this command, for example:
# dos2unix|/usr/sbin/sendmail works well with Qmail.
# You may use quotes (") for executables with unusual names.
#
sendmail = /usr/sbin/sendmail
#
#
# The following items can be overridden in the service-specific sections.
#
#
#
# Trace level to send to syslog. Default is 2 (messages, errors, fatals).
#
TRACE_SYSLOG = 5
#
# Trace level to send to stderr. Default is 0 (fatals).
#
TRACE_STDERR = 5
#
# Root privs are used to open a port, then privs
# are dropped down to the user/group specified here.
#
EFFECTIVE_USER = dbmail
EFFECTIVE_GROUP = dbmail
#
# The IP addresses the services will bind to.
# Use * for all local interfaces.
# Use 127.0.0.1 for localhost only.
# Separate multiple entries with spaces ( ) or commas (,).
#
BINDIP = *
#
# Default number of child processes to start.
#
NCHILDREN = 5
#
# Maximum number of child processes allowed.
#
MAXCHILDREN = 200
#
# Unused children to always have availale.
#
MINSPARECHILDREN = 2
#
# Maximum unused children allowed to be active.
#
MAXSPARECHILDREN = 10
#
# Child process is restarted after handling this many connections.
#
MAXCONNECTS = 10000
#
# Child process will restart after this many connection errors.
#
MAX_ERRORS = 500
#
# Idle time allowed before a connection is shut off.
#
TIMEOUT = 300
#
# If yes, resolves IP addresses to DNS names when logging.
#
RESOLVE_IP = no
#
# logfile for stdout messages
#
logfile = /var/log/dbmail/dbmail.log
#
# logfile for stderr messages
#
errorlog = /var/log/dbmail/dbmail.err
#
# directory for storing PID files
#
pid_directory = /var/run
#
# directory for storing the daemon statefiles
#
state_directory = /var/run
[SMTP]
# In fact, there isn't anything here by default.
[LMTP]
#
# Port to bind to.
#
PORT = 24
[POP]
#
# Port to bind to.
#
PORT = 110
#
# If yes, allows SMTP access from the host IP connecting by POP3.
# This requires addition configuration of your MTA
#
POP_BEFORE_SMTP = yes
[IMAP]
#
# Port to bind to.
#
PORT = 143
#
# IMAP prefers a longer timeout than other services.
#
TIMEOUT = 4000
#
# If yes, allows SMTP access from the host IP connecting by IMAP.
# This requires addition configuration of your MTA
#
IMAP_BEFORE_SMTP = yes
[SIEVE]
#
# Port to bind to.
#
#PORT = 20000
[LDAP]
#PORT = 389
#VERSION = 3
#HOSTNAME = ldap
#BASE_DN = ou=People,dc=mydomain,dc=com
#
# If your LDAP library supports ldap_initialize(), then you can use the
# alternative LDAP server DSN like following.
#
# URI = ldap://127.0.0.1:389
# URI = ldapi://%2fvar%2frun%2fopenldap%2fldapi/
#
# Leave blank for anonymous bind.
# example: cn=admin,dc=mydomain,dc=com
#
BIND_DN =
#
# Leave blank for anonymous bind.
#
BIND_PW =
SCOPE = SubTree
USER_OBJECTCLASS = top,account,dbmailUser
FORW_OBJECTCLASS = top,account,dbmailForwardingAddress
CN_STRING = uid
FIELD_PASSWD = userPassword
FIELD_UID = uid
FIELD_NID = uidNumber
MIN_NID = 10000
MAX_NID = 15000
FIELD_CID = gidNumber
MIN_CID = 10000
MAX_CID = 15000
FIELD_MAIL = mail
FIELD_QUOTA = mailQuota
FIELD_FWDTARGET = mailForwardingAddress
[DELIVERY]
#
# Run Sieve scripts as messages are delivered.
#
SIEVE = no
#
# Use '[EMAIL PROTECTED]' format to deliver to a mailbox.
#
SUBADDRESS = yes
#
# Turn on/off the Sieve Vacation extension.
#
SIEVE_VACATION = no
#
# Turn on/off the Sieve Notify extension
#
SIEVE_NOTIFY = no
#
# Turn on/off additional Sieve debugging.
#
SIEVE_DEBUG = no
#
# Use the auto_notify table to send email notifications.
#
AUTO_NOTIFY = no
#
# Use the auto_reply table to send away messages.
#
AUTO_REPLY = no
#
# Defaults to "NEW MAIL NOTIFICATION"
#
#AUTO_NOTIFY_SUBJECT =
#
# Defaults to POSTMASTER from the DBMAIL section.
#
#AUTO_NOTIFY_SENDER =
# end of configuration file
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
