Sorry, i'm going to past more info.
Want to report this as a bug?
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [a001 OK LOGIN
completed^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Finished command login [0]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info COMMAND: [ns1 NAMESPACE]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Executing command namespace...
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [* NAMESPACE ((""
"/")) (("#Users" "/")) (("#Public" "/"))^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [ns1 OK NAMESPACE
complete^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Finished command namespace [0]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info COMMAND: [ns1 NAMESPACE]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Executing command namespace...
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [* NAMESPACE ((""
"/")) (("#Users" "/")) (("#Public" "/"))^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [ns1 OK NAMESPACE
complete^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Finished command namespace [0]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info COMMAND: [sel1 SELECT
"INBOX"]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug arg[0]: 'INBOX'
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Executing command select...
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c,db_findmailbox: looking
for mailbox with FQN [INBOX].
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name LIKE 'INBOX' AND
owner_idnr='235']
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c,db_acl_has_right:
checking ACL [read_flag] for user [235] on mailbox [507]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '507']
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c, db_acl_has_right:
mailbox [507] is owned by user [235], is that also [235]?
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c, db_acl_has_right:
mailbox [507] is owned by user [235], giving all rights
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '507']
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '507']
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='507' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages
WHERE mailbox_idnr='507' AND (status='0' OR status='1') AND seen_flag=1
UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='507' AND
(status='0' OR status='1') AND recent_flag=1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '507' AND
status IN ('0','1') ORDER BY message_idnr ASC]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c,db_getmailbox_count:
exists [833]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT
1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '507']
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='507' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages
WHERE mailbox_idnr='507' AND (status='0' OR status='1') AND seen_flag=1
UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='507' AND
(status='0' OR status='1') AND recent_flag=1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '507' AND
status IN ('0','1') ORDER BY message_idnr ASC]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c,db_getmailbox_count:
exists [833]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT
1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [* 833 EXISTS^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [* 0 RECENT^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [* FLAGS (\Seen
\Answered \Deleted \Flagged \Draft \Recent)^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [* OK
[PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft \Recent)]^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [* OK [UIDNEXT
365085] Predicted next UID^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [* OK [UIDVALIDITY
507] UID value^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '507'
AND status < '2' AND seen_flag = '0']
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [* OK [UNSEEN 1]
first unseen message^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE recent_flag = 1 AND
mailbox_idnr = '507']
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug
dbmail-imapsession.c,dbmail_imap_session_mailbox_select_recent: recent [0]
in mailbox [507]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [sel1 OK
[READ-WRITE] SELECT completed^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Finished command select [0]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '507']
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='507' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages
WHERE mailbox_idnr='507' AND (status='0' OR status='1') AND seen_flag=1
UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='507' AND
(status='0' OR status='1') AND recent_flag=1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '507' AND
status IN ('0','1') ORDER BY message_idnr ASC]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c,db_getmailbox_count:
exists [833]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT
1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info COMMAND: [srch1 SEARCH UID
362466]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug arg[0]: 'UID'
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug arg[1]: '362466'
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Executing command search...
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c,db_acl_has_right:
checking ACL [read_flag] for user [235] on mailbox [507]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '507']
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c, db_acl_has_right:
mailbox [507] is owned by user [235], is that also [235]?
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c, db_acl_has_right:
mailbox [507] is owned by user [235], giving all rights
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmysql.c,db_query: query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '507' AND
status IN ('0','1') ORDER BY message_idnr]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug
dbmail-mailbox.c,append_search: [135063808] [1] type [1] field [] search
[1:*] at depth [1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug misc.c,check_msg_set:
[362466] [ok]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug
dbmail-mailbox.c,append_search: [134963200] [0] type [1] field [] search
[362466] at depth [1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug
dbmail-mailbox.c,dbmail_mailbox_get_set: [1:*]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug misc.c,g_tree_merge: a[0]
[OR] b[833] -> a[833]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmail-mailbox.c,_do_search:
[135063808] depth [1] type [1] rows [833]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug
dbmail-mailbox.c,dbmail_mailbox_get_set: [362466]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug misc.c,g_tree_merge: a[0]
[OR] b[1] -> a[1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug dbmail-mailbox.c,_do_search:
[134963200] depth [2] type [1] rows [1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug
dbmail-mailbox.c,_merge_search: [135063808] depth [1] type [1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug misc.c,g_tree_merge: a[833]
[AND] b[833] -> a[833]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug
dbmail-mailbox.c,_merge_search: [134963200] depth [2] type [1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug misc.c,g_tree_merge: a[833]
[AND] b[1] -> a[1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug
dbmail-mailbox.c,dbmail_mailbox_search: found [1] ids
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [* SEARCH 362466]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [^M srch1 OK
SEARCH completed^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Finished command search [0]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info COMMAND: [F1247 FETCH 362466
(BODYSTRUCTURE)]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug arg[0]: '362466'
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug arg[1]: '('
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug arg[2]: 'BODYSTRUCTURE'
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug arg[3]: ')'
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Executing command fetch...
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c,db_acl_has_right:
checking ACL [read_flag] for user [235] on mailbox [507]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c, db_acl_has_right:
mailbox [507] is owned by user [235], is that also [235]?
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug db.c, db_acl_has_right:
mailbox [507] is owned by user [235], giving all rights
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] =
[BODYSTRUCTURE]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] =
BODYSTRUCTURE (returning 3)
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] =
[)]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [F1247 BAD invalid
message range specified^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Finished command fetch [1]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info COMMAND: [ghd LIST "" ""]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug arg[0]: ''
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug arg[1]: ''
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Executing command list...
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [* LIST
(\NoSelect) "/" ""^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [ghd OK LIST
completed^M ]
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Info imap4.c,IMAPClientHandler:
Finished command list [0]
----- Original Message -----
From: "Jorge Bastos" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Saturday, August 26, 2006 12:43 AM
Subject: Re: [Dbmail] roundcube
Paul,
Continuing this roundcube thing, there's something in the dbmail logs, but
i need to confirm from you if it is dbmail or roundcube that is
requestiong some malformed data.
Aug 25 23:34:43 lira dbmail/imap4d[4263]: Debug RESPONSE: [F1247 BAD
invalid message range specified^M ]
from who's the problem?
Jorge
----- Original Message -----
From: "Rob Gil" <[EMAIL PROTECTED]>
To: "'DBMail mailinglist'" <[email protected]>
Sent: Friday, August 25, 2006 2:36 AM
Subject: RE: [Dbmail] roundcube
Yes, it takes AT LEAST 30 seconds. Also, whenever updating, it takes just
as
long. It makes my roundcube experience quite annoying. If there was a way
to
grab incremental data, it would solve the problem.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
Of Jorge Bastos
Sent: Thursday, August 24, 2006 12:48 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] roundcube
I see,
But with the 2.1.x it doesn't, i'm going to see what he needs.
I think the direct sql access is going to cost you alot of time, IMAP
should
be a good access point, 4500 messages it's a bit, i also have about those
many 2000 maybe, if he takes about what, 30 secunds to make the pages?
more?
but sinserely (i bet the word is bad written :P) in the messages i have,
it
loads as fast as another account that had only a few messages.
----- Original Message -----
From: "Rob Gil" <[EMAIL PROTECTED]>
To: "'DBMail mailinglist'" <[email protected]>
Sent: Thursday, August 24, 2006 5:00 AM
Subject: RE: [Dbmail] roundcube
Works fine with 2.0.10.
I have actually been considering implementing direct database access to
roundcube. This however seems to be quite a bit more work than first
thought. IMAP is so far ingrained into the code, it doesn't seem
feasible
at
this point in time. The main reason for doing this was the time it took
to
load the page due to the 4500 messages I have archived in my mailbox and
all
its many folders.
If anyone has looked at the roundcube code and has any ideas as to how
to
do
this, let me know.
~Rob (HAIDEN on freenode)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
Of Curtis Maurand
Sent: Tuesday, August 22, 2006 7:20 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] roundcube
I have it working. I'm not sure which version.
Curtis
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
On Tue, 22 Aug 2006, Jorge Bastos wrote:
Hi,
does anyone have roundcube webmail working with dbmail?
i downloaded the stable version on the website, "0.1beta2" version, but
when i doubleclick a message i get an error on dbmail-imap4d that is:
Aug 22 22:26:04 lira dbmail/imap4d[22371]: Debug RESPONSE: [fh0 BAD
invalid message range specified^M ]
and it doesn't work.
Paul, dbmail or roundcube problem?
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
