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
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
