Hi,
I am new to this qmail and dbmail. I am unable to get
the mails into the database.
My O.S is RHEL4.0, dbmail version is 2.0.4,qmail-1.03
and mysql-version is 4.1.13rhel4.
I created a user john and the path of john home
directory is /home/john.
I add a file,in the john directory .qmail_default. In
that file, i add a line
(|/usr/local/sbin/dbmail-smtp -d ${RECIPIENT:7}). I
created a same user in the
dbmail database (./dbmail-users -a john -w secret -g 0
-m 25M\). It is created fine.
The qmailctl stat is
qmailctl stat
/service/qmail-send: up (pid 21151) 3725 seconds
/service/qmail-send/log: up (pid 21152) 3725 seconds
/service/qmail-smtpd: up (pid 21153) 3725 seconds
/service/qmail-smtpd/log: up (pid 21154) 3725 seconds
messages in queue: 8
messages in queue but not yet preprocessed: 0
Then i started dbmail-imap it is open some 20-30
connections
Jul 31 15:09:49 ns2 dbmail/imap4d[20645]:
pool.c,child_register: register child [20645]
Jul 31 15:09:49 ns2 dbmail/imap4d[20647]:
pool.c,child_register: register child [20647]
Jul 31 15:09:49 ns2 dbmail/imap4d[20649]:
pool.c,child_register: register child [20649]
Jul 31 15:09:49 ns2 dbmail/imap4d[20655]:
pool.c,child_register: register child [20655]
Jul 31 15:09:49 ns2 dbmail/imap4d[20657]:
pool.c,child_register: register child [20657]
Jul 31 15:09:49 ns2 dbmail/imap4d[20659]:
pool.c,child_register: register child [20659]
Jul 31 15:09:49 ns2 dbmail/imap4d[20661]:
pool.c,child_register: register child [20661]
Jul 31 15:09:49 ns2 dbmail/imap4d[20663]:
pool.c,child_register: register child [20663]
Jul 31 15:09:49 ns2 dbmail/imap4d[20665]:
pool.c,child_register: register child [20665]
Jul 31 15:09:49 ns2 dbmail/imap4d[20667]:
pool.c,child_register: register child [20667]
Jul 31 15:09:49 ns2 dbmail/imap4d[20669]:
pool.c,child_register: register child [20669]
Jul 31 15:09:49 ns2 dbmail/imap4d[20671]:
pool.c,child_register: register child [20671]
Jul 31 15:09:49 ns2 dbmail/imap4d[20673]:
pool.c,child_register: register child [20673]
Jul 31 15:09:49 ns2 dbmail/imap4d[20675]:
pool.c,child_register: register child [20675]
Jul 31 15:09:49 ns2 dbmail/imap4d[20677]:
pool.c,child_register: register child [20677]
Jul 31 15:09:49 ns2 dbmail/imap4d[20675]:
pool.c,child_register: register child [20675]
Jul 31 15:09:49 ns2 dbmail/imap4d[20677]:
pool.c,child_register: register child [20677]
Jul 31 15:09:49 ns2 dbmail/imap4d[20679]:
pool.c,child_register: register child [20679]
Jul 31 15:09:49 ns2 dbmail/imap4d[20711]:
pool.c,child_register: register child [20711]
Jul 31 15:09:49 ns2 dbmail/imap4d[20713]:
pool.c,child_register: register child [20713]
Jul 31 15:09:49 ns2 dbmail/imap4d[20715]:
pool.c,child_register: register child [20715]
after that, i use telnet localhost 25 and try to send
a test message to [EMAIL PROTECTED] from john and it is
working fine.
When i check the qmail logs
@4000000042eca77204e69da4 new msg 746669
@4000000042eca77204e8e794 info msg 746669: bytes 221
from <[EMAIL PROTECTED]> qp 23032 uid 7791
@4000000042eca7720525c984 starting delivery 17: msg
746669 to local [EMAIL PROTECTED]
@4000000042eca772052730e4 status: local 1/10 remote
0/20
@4000000042eca7720676a3e4 delivery 17: deferral:
@4000000042eca7720676b384 status: local 0/10 remote
0/20
@4000000042eca7d705813f94 starting delivery 18: msg
746669 to local [EMAIL PROTECTED]
@4000000042eca7d705814f34 status: local 1/10 remote
0/20
@4000000042eca7d706c592ec delivery 18: deferral:
@4000000042eca7d706c5a28c status: local 0/10 remote
0/20
@4000000042eca8960506c41c starting delivery 19: msg
746647 to local [EMAIL PROTECTED]
@4000000042eca8960506d3bc status: local 1/10 remote
0/20
@4000000042eca89606469b04 delivery 19: deferral:
@4000000042eca8960646aaa4 status: local 0/10 remote
0/20
i created only john but it is trying to send to
dbmail-john, but their is no dbmail-john account in
the dbmail database.
I tested like this also
(dbmail-smtp -d [EMAIL PROTECTED] -f slocate.db)
Jul 31 15:49:55 ns2 dbmail/smtp[22757]:
dbmysql.c,db_query: query [SELECT 1=1 FROM
dbmail_physmessage LIMIT 1 OFFSET 0] failed
Jul 31 15:49:55 ns2 dbmail/smtp[22757]:
dbmysql.c,db_query: mysql_real_query failed: No
database selected
Jul 31 15:49:55 ns2 dbmail/smtp[22757]:
dbmysql.c,db_query: mysql_real_query failed: No
database selected
Jul 31 15:49:55 ns2 dbmail/smtp[22757]:
db.c,db_check_version: database incompatible. You may
need to run the conversion script
Jul 31 15:58:10 ns2 dbmail/smtp[23094]: main(): error
reading alternate config file [slocate.db]
Jul 31 15:59:15 ns2 dbmail/smtp[23156]: main(): error
reading alternate config file [slocate.db]
Jul 31 16:03:58 ns2 dbmail/smtp[23369]: main(): error
reading alternate config file [slocate.db]
Jul 31 16:28:22 ns2 dbmail/smtp[24391]: main(): error
reading alternate config file [slocate.db]
dbmail.conf file in the /etc/dbmail.conf
[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.
#sqlsocket= # when using a local socket
connection to the database, fill
# in the path to the socket
here (e.g. /var/run/mysql.sock)
user=abc # user to connect as to
database
pass=abc # password for user to
database
db=abc # name of database
db=abc # name of database
[EMAIL PROTECTED] # postmaster's email
address.
# 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]
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=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
I hope,i could get the solution to my problem.
Thanks & Regards
qmaildb
_______________________________________________________
Too much spam in your inbox? Yahoo! Mail gives you the best spam protection for
FREE! http://in.mail.yahoo.com
