Hi Paul
Here's my /etc/main.cf tail. I use debian sarge. and dbmail-2.0.7 with
postfix.
postfix alone without dbmail was working fine.
## SASL Settings
# This is going in to THIS server
#smtpd_sasl_auth_enable = no
# We need this
smtp_sasl_auth_enable = yes
#smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd
#smtpd_sasl_local_domain = $myhostname
smtp_sasl_security_options =
#smtp_sasl_tls_security_options = noanonymous,noplaintext
#smtpd_sasl_application_name = smtpd
#local_transport = dbmail-lmtp:$myhostname
mail_transport = dbmail-lmtp:localhost:24
#broken_sasl_auth_clients = yes
I need to use sasl2 for mail relay.
My master.cf is as follows
smtp inet n - - - - smtpd
#submission inet n - n - - smtpd
.
.
dbmail-lmtp unix - - n - - lmtp -v
My /etc/dbmail.cf is as follows.
[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
socket = /var/run/mysqld/mysqld.sock
user=dbmail # user to connect as to database
pass=rambo1 # password for user to database
db=dbmail # name of database
[EMAIL PROTECTED] # postmaster's email address.
# trace level for dbmail-util
TRACE_LEVEL=5
[SMTP]
SENDMAIL=/usr/sbin/sendmail # sendmail executable for forwarding mail
AUTO_NOTIFY=no
AUTO_REPLY=no
TRACE_LEVEL=5
[LMTP]
EFFECTIVE_USER=nobody # the user that dbmail-lmtpd will run as
(need to be root to bind to a port<1024)
EFFECTIVE_GROUP=nogroup # the group that dbmail-lmtpd will run as
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=5
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=5
[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
My /etc/mysql/my.cnf is as follows
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
#socket=/var/lib/mysql/mysql.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently
parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# For compatibility to other Debian packages that still use
# libmysqlclient10 and libmysqlclient12.
old_passwords = 1
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = localhost
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
#
# * Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size = 16777216
query_cache_type = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql.log
#log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log-slow-queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for
replication.
#server-id = 1
log-bin = /var/log/mysql/mysql-bin.log
# See /etc/mysql/debian-log-rotate.conf for the number of files kept.
max_binlog_size = 104857600
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name
#
# * BerkeleyDB
#
# According to an MySQL employee the use of BerkeleyDB is now discouraged
# and support for it will probably cease in the next versions.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt.gz
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
My /etc/mysql/debian.cnf is as follows
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = z7U1oEP1xaiFrNx4
socket = /var/run/mysqld/mysqld.sock
Paul J Stevens wrote:
Nataraj,
Don't be stingy when it comes to sharing details regarding your setup.
What's in your master.cf, esp the dbmail transport?
Nataraj S Narayan wrote:
Hi
Still having problems with Mysql sockets.
no you don't. That's a warning you can safely ignore.
dbmail-lmtp and dbmail-pop3 worked right just once. From then on the
mails to a users are not seen on pop3.
As suggested by Steven and Mueller I am using port 25 in the
thunderbird client.
Not for pop3 I should hope.
Of course, i use 110 for pop3
Nov 30 10:53:45 ghost postfix/qmgr[5533]: warning: connect to transport
dbmail:
Connection refused
That's not good. Apparently you did *not* setup the transport correctly.
I cant quite figure it out myself.
Nov 30 10:53:46 ghost dbmail/pop3d[4512]: dbmysql.c,db_connect: MySQL
host is se
t to localhost, but no mysql_socket has been set. Use sqlsocket=... in
dbmail.co
nf. Connecting will be attempted using the default socket.
That's no problem, but consider setting the sqlsocket in dbmail.conf to
what is valid for your mysql setup. On debian that would be
/var/run/mysqld/mysqld.sock, but please check your my.cnf to be sure.
regards
Natarak
