Hi
Thank you for giving solution. I already configure qmail with vpopmail
and courier-imap . It is working fine. All of the user accounts are
stored in "/home/vpopmail/domains/abc.com/user1/Maildir". I confiugred
dbmail with database. When i am sending a mail to [EMAIL PROTECTED] The
mail's are storing in
"/home/vpopmail/domains/abc.com/user1/Maildir not in the database. Could
any one tell me. How to store all the mails in the database. I searched
in google.com. Some of sites told that mailbox2dbmail is used to convert
maildir to dbmail database. I didn't know how to use or execute
mailbox2dbmail. Could any one help me to solve this problem. Once again
Thank you to paul and dbmail mailinglist.
Thanks & Regards
sreekanth.
On Thu, 2005-05-19 at 13:22, Paul J Stevens wrote:
> Sort is broken. That test should be commented out. Maybe I'm not looking
> straight atm, but I don't see anything relevant in the logs either.
>
> Also, even a broken sort doesn't explain your troubles inserting email.
> Try running dbmail-smtp or lmtpd on trace level 5.
>
> sreekanth wrote:
> > HI,
> >
> > I am sreekanth. I had a problem with dbmail. I am using qmail 1.03 with
> > vpopmail 5.47 on RHEL3.
> >
> > I had installed dbamil2.0.4. It was installed but when i am running
> > test-scripts, i am getting the error
> > /*
> > ./testimap.py
> > .............('OK', [None])
> > ........ 28:57.84 > CDME2 LIST "" *
> > 28:57.89 < * LIST () "/" "#Users/testuser1/testaclbox"
> > 28:57.89 < * LIST () "/" "INBOX"
> > 28:57.89 < CDME2 OK LIST completed
> > ('OK', ['() "/" "#Users/testuser1/testaclbox"', '() "/" "INBOX"'])
> > ..E.....
> > ======================================================================
> > ERROR: testSort (__main__.testImapServer)
> > ----------------------------------------------------------------------
> > Traceback (most recent call last):
> > File "./testimap.py", line 359, in testSort
> > result1=self.o.sort('(REVERSE ARRIVAL)','US-ASCII','ALL')
> > File "/usr/lib/python2.2/imaplib.py", line 572, in sort
> > typ, dat = apply(self._simple_command, (name, sort_criteria,
> > charset) + search_criteria)
> > File "/usr/lib/python2.2/imaplib.py", line 925, in _simple_command
> > return self._command_complete(name, apply(self._command, (name,) +
> > args))
> > File "/usr/lib/python2.2/imaplib.py", line 762, in _command_complete
> > raise self.error('%s command error: %s %s' % (name, typ, data))
> > error: SORT command error: BAD ['syntax error in sort keys']
> >
> > ----------------------------------------------------------------------
> > Ran 29 tests in 5.492s
> >
> > FAILED (errors=1)
> > */
> >
> > when i see the logs at /var/log/maillog
> >
> > /*
> >
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]:
> > db.c,db_list_mailboxes_by_regex: comparing mailbox [INBOX] to regular
> > expression
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]:
> > db.c,db_list_mailboxes_by_regex: regex match INBOX, mailbox_idnr = 20
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]:
> > db.c,db_list_mailboxes_by_regex: checking mailbox: testunsub, nr 155,
> > owner = 5
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]:
> > db.c,db_list_mailboxes_by_regex: comparing mailbox [testunsub] to
> > regular expression
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]:
> > db.c,db_list_mailboxes_by_regex: regex match testunsub, mailbox_idnr = 155
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]:
> > db.c,db_list_mailboxes_by_regex: exit
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: db.c,db_findmailbox_by_regex:
> > found [2] mailboxes
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: imapcommands.c,_ic_list:
> > children[0] = 20
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '20']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '20']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '20']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '20']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: imapcommands.c,_ic_list:
> > children[1] = 155
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '155']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '155']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '155']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '155']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: IMAPClientHandler(): Finished
> > command list
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: IMAPClientHandler(): line read
> > for PID 26200
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: COMMAND: [DD5 DELETE testunsub]
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: arg[0]: 'testunsub'
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: IMAPClientHandler(): Executing
> > command delete...
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: db.c,db_findmailbox: looking
> > for mailbox with FQN [testunsub].
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='testunsub'
> > AND owner_idnr='5']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr =
> > '155' AND owner_idnr = '5']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '155' AND
> > owner_idnr = '5']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name LIKE
> > 'testunsub/%' AND owner_idnr = '5']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '155']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT sum(pm.messagesize) FROM dbmail_messages msg,
> > dbmail_physmessage pm WHERE msg.physmessage_id = pm.id AND
> > msg.mailbox_idnr = '155' AND msg.status < '2']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_get_result:
> > result is null
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [DELETE FROM dbmail_mailboxes WHERE mailbox_idnr = '155']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '155']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: db.c,db_delete_mailbox:
> > mailbox is empty
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_free_result:
> > Trying to free result set that is already NULL!
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: db.c,db_subtract_quotum_used:
> > subtracting 0 from mailsize
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]:
> > db.c.user_idnr_is_delivery_user_idnr: no need to look up user_idnr for
> > [EMAIL PROTECTED]@__
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: dbmysql.c,db_query: executing
> > query [UPDATE dbmail_users SET curmail_size = curmail_size - '0' WHERE
> > user_idnr = '5']
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: IMAPClientHandler(): Finished
> > command delete
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: IMAPClientHandler(): line read
> > for PID 26200
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: COMMAND: [DD6 LOGOUT]
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: IMAPClientHandler(): Executing
> > command logout...
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: _ic_logout(): user (id:5)
> > logging out @ [2005-05-19 09:28:58]
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: IMAPClientHandler(): Finished
> > command logout
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: IMAPClientHandler(): Closing
> > connection for client from IP [202.71.158.218]
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: PerformChildTask(): client
> > handling complete, closing streams
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: serverchild.c,client_close:
> > closing write stream
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: serverchild.c,client_close:
> > closing read stream
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: PerformChildTask(): connection
> > closed
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: PerformChildTask(): waiting
> > for connection
> > May 19 09:28:58 ns1 dbmail/imap4d[26200]: pool.c,child_reg_disconnected:
> > [26200]
> >
> > */
> >
> > I am unable to get mails, in to the dbmail database. I am able to get
> > mail into vpopmail->domains->xxxx.com->[EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>>Maildir..... But i am unable to get mails into
> > dbmail database. I hope, i could get help from your side.
> >
> >
> > Thanks & Regards
> > sreekanth.
> >
> > --
> > Sreekanth
> > [viswasreekanth]
> > TrulyIntelligent.com
> >
> >
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Dbmail mailing list
> > [email protected]
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
