Paul,
It tells me what's going on, but unfortunately not enough to diagnose
why it's going wrong! It looks like a regex processing fault.
*For example, Connect & Login* - seems to work OK
Oct 31 08:23:00 linux dbmail/imap4d[23482]: PerformChildTask(): incoming
connection from [192.168.0.232]
Oct 31 08:23:00 linux dbmail/imap4d[23482]: PerformChildTask(): client
info init complete, calling client handler
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler(): line
read for PID 23482
Oct 31 08:23:00 linux dbmail/imap4d[23482]: COMMAND: [1 authenticate login]
Oct 31 08:23:00 linux dbmail/imap4d[23482]: arg[0]: 'login'
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler():
Executing command authenticate...
Oct 31 08:23:00 linux dbmail/imap4d[23482]: __auth_query(): connection ok
Oct 31 08:23:00 linux dbmail/imap4d[23482]: __auth_query(): executing
query [SELECT user_idnr, passwd, encryption_type FROM users WHERE userid
= 'steve']
Oct 31 08:23:00 linux dbmail/imap4d[23482]: auth_validate(): validating
using cleartext passwords
Oct 31 08:23:00 linux dbmail/imap4d[23482]: __auth_query(): connection ok
Oct 31 08:23:00 linux dbmail/imap4d[23482]: __auth_query(): executing
query [UPDATE users SET last_login = '2003-10-31 08:23:00' WHERE
user_idnr = 2::bigint]
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPD [PID 23482]: user (id
2, name steve) login accepted @ 2003-10-31 08:23:00^M
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler():
Finished command authenticate
*Get mailbox list??* Oops, looks broken - no data returned
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler(): line
read for PID 23482
Oct 31 08:23:00 linux dbmail/imap4d[23482]: COMMAND: [2 lsub "" "*"]
Oct 31 08:23:00 linux dbmail/imap4d[23482]: arg[0]: ''
Oct 31 08:23:00 linux dbmail/imap4d[23482]: arg[1]: '*'
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler():
Executing command lsub...
Oct 31 08:23:00 linux dbmail/imap4d[23482]: ic_list(): build the
pattern: [^.*$]
Oct 31 08:23:00 linux dbmail/imap4d[23482]: db_query(): executing query
[SELECT mailbox_idnr FROM mailboxes WHERE owner_idnr=2::bigint AND
is_subscribed != 0 AND name ~* '^^.*$$']
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler():
Finished command lsub
*Something not right here, if I take the SQL from above and execute it I
get no mailbox_idnr's returned:*
dbmail=# SELECT mailbox_idnr FROM mailboxes WHERE owner_idnr=2::bigint
AND is_subscribed != 0 AND name ~* '^^.*$$';
mailbox_idnr
--------------
(0 rows)
*List content of Inbox??*
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler(): line
read for PID 23482
Oct 31 08:23:00 linux dbmail/imap4d[23482]: COMMAND: [3 list "" "INBOX"]
Oct 31 08:23:00 linux dbmail/imap4d[23482]: arg[0]: ''
Oct 31 08:23:00 linux dbmail/imap4d[23482]: arg[1]: 'INBOX'
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler():
Executing command list...
Oct 31 08:23:00 linux dbmail/imap4d[23482]: ic_list(): build the
pattern: [^INBOX$]
Oct 31 08:23:00 linux dbmail/imap4d[23482]: db_query(): executing query
[SELECT mailbox_idnr FROM mailboxes WHERE owner_idnr=2::bigint AND name
~* '^^INBOX$$']
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler():
Finished command list
*Same here, the query returns no data :(
*
dbmail=# SELECT mailbox_idnr FROM mailboxes WHERE owner_idnr=2::bigint
AND name ~* '^^INBOX$$';
mailbox_idnr
--------------
(0 rows)
whereas if i do:
dbmail=# SELECT mailbox_idnr, name FROM mailboxes WHERE
owner_idnr=2::bigint;
mailbox_idnr | name
--------------+------------
7 | testing
6 | Sent Items
5 | eric
4 | test
3 | Trash
2 | INBOX
(6 rows)
It is immediately clear that I have an 'INBOX' and other mailboxes, but
the AND name ~* '^^INBOX$$' clause is not matching anything. I am not
sufficiently familiar with regex processing is PostgreSQL to determine
why this is.
Any suggestions? A bit more log below if it helps.
Thanks,
Steve
*List content of Trash??*
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler(): line
read for PID 23482
Oct 31 08:23:00 linux dbmail/imap4d[23482]: COMMAND: [4 list "" "Trash"]
Oct 31 08:23:00 linux dbmail/imap4d[23482]: arg[0]: ''
Oct 31 08:23:00 linux dbmail/imap4d[23482]: arg[1]: 'Trash'
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler():
Executing command list...
Oct 31 08:23:00 linux dbmail/imap4d[23482]: ic_list(): build the
pattern: [^Trash$]
Oct 31 08:23:00 linux dbmail/imap4d[23482]: db_query(): executing query
[SELECT mailbox_idnr FROM mailboxes WHERE owner_idnr=2::bigint AND name
~* '^^Trash$$']
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler():
Finished command list
*Create Trash ?? Why, Trash already exists, but the IMAP client doesn't
seem to know this, presumably it hasn't received this information from
the imap daemon*
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler(): line
read for PID 23482
Oct 31 08:23:00 linux dbmail/imap4d[23482]: COMMAND: [5 create "Trash"]
Oct 31 08:23:00 linux dbmail/imap4d[23482]: arg[0]: 'Trash'
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler():
Executing command create...
Oct 31 08:23:00 linux dbmail/imap4d[23482]: db_query(): executing query
[SELECT mailbox_idnr FROM mailboxes WHERE lower(name) = lower('Trash')
AND owner_idnr=2::bigint]
Oct 31 08:23:00 linux dbmail/imap4d[23482]: IMAPClientHandler():
Finished command create
Oct 31 08:27:33 linux dbmail/imap4d[23488]: IMAPClientHandler(): line
read for PID 23488
Oct 31 08:27:33 linux dbmail/imap4d[23488]: COMMAND: [199 check]
Oct 31 08:27:33 linux dbmail/imap4d[23488]: IMAPClientHandler():
Executing command check...
Oct 31 08:27:33 linux dbmail/imap4d[23488]: IMAPClientHandler():
Finished command check
Oct 31 08:27:33 linux dbmail/imap4d[23488]: db_query(): executing query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM mailboxes WHERE mailbox_idnr = 2::bigint AND owner_idnr = 2::bigint]
Oct 31 08:27:33 linux dbmail/imap4d[23488]: db_query(): executing query
[SELECT message_idnr, seen_flag, recent_flag FROM messages WHERE
mailbox_idnr = 2::bigint AND status<2 AND unique_id!='' ORDER BY
message_idnr ASC]
Oct 31 08:27:33 linux dbmail/imap4d[23488]: db_query(): executing query
[SELECT message_idnr FROM messages WHERE unique_id!='' ORDER BY
message_idnr DESC LIMIT 1]
Paul Stevens wrote:
Steve,
Try setting the debug level to 5 for IMAP in dbmail.conf.
Your syslog should tell you exactly what's going on when you
access your imap account.
Steve Burrows wrote:
Hi All,
I have just installed dbmail 1.2.1 on SuSE SLES 8 running PostFix and
PostgreSQL.
dbmail-adduser worked fine, I have a test user. Postfix delivers fine
to dbmail-smtp, and messages / messageblocks appear in the database,
however when I access via an IMAP client (Mozilla / Thunderbird /
Outlook Express) there are no folders listed, and none available to
subscribe to.
There are folders listed in the database which I have created using
an IMAP client. It is clear from this and the log that that the IMAP
client is talking to dbmail-imap, so does anyone have any suggestions
as to what is going wrong?
Thanks,
Steve
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
