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]>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
