So set trace_level=5 for lmtpd, and show me the debug trace. Nataraj S Narayan wrote: > 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 > > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
-- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
