The following issue has been CLOSED
======================================================================
http://www.dbmail.org/mantis/view.php?id=176
======================================================================
Reported By: aabramov1
Assigned To:
======================================================================
Project: DBMail
Issue ID: 176
Category: Database layer
Reproducibility: always
Severity: minor
Priority: normal
Status: closed
Resolution: open
Fixed in Version:
======================================================================
Date Submitted: 21-Feb-05 10:24 CET
Last Modified: 14-Feb-06 16:41 CET
======================================================================
Summary: Imap clients haven't access to shared folder.
Description:
I tried to create (and subscribe to) new shared mailbox using Mulberry IMAP
client. In database I see thaty mailbox was created, but users haven't
access on it.
-- few lines from syslog --
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: COMMAND: [A00025 CREATE
#Public_tttest]
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: arg[0]: '#Public_tttest'
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: IMAPClientHandler(): Executing
command create...
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: db.c,db_findmailbox: looking
for mailbox with FQN [#Public_tttest].
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: db.c,db_findmailbox: finding
user with name [__public__].
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: dbmysql.c,db_query: executing
query [SELECT user_idnr FROM dbmail_users WHERE userid='__public__']
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: dbmysql.c,db_query: executing
query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='' AND
owner_idnr='8']
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: checking for
'#Public_tttest'...
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: db.c,db_findmailbox: looking
for mailbox with FQN [#Public_tttest].
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: db.c,db_findmailbox: finding
user with name [__public__].
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: dbmysql.c,db_query: executing
query [SELECT user_idnr FROM dbmail_users WHERE userid='__public__']
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: dbmysql.c,db_query: executing
query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='c' AND
owner_idnr='8']
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: imapcommands.c,_ic_create:
Checking if we have the right to create mailboxes under mailbox [0]
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: dbmysql.c,db_query: executing
query [INSERT INTO dbmail_mailboxes (name, owner_idnr,seen_flag,
answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag,
permission) VALUES ('#Public_tttest', '1', 1, 1, 1, 1, 1, 1, 2)]
Feb 21 11:35:41 mysrv dbmail/imap4d[29177]: IMAPClientHandler(): Finished
command create
Feb 21 11:35:50 mysrv dbmail/imap4d[29177]: IMAPClientHandler(): line read
for PID 29177
Feb 21 11:35:50 mysrv dbmail/imap4d[29177]: COMMAND: [A00026 SUBSCRIBE
#Public_tttest]
Feb 21 11:35:50 mysrv dbmail/imap4d[29177]: arg[0]: '#Public_tttest'
Feb 21 11:35:50 mysrv dbmail/imap4d[29177]: IMAPClientHandler(): Executing
command subscribe...
Feb 21 11:35:50 mysrv dbmail/imap4d[29177]: db.c,db_findmailbox: looking
for mailbox with FQN [#Public_tttest].
Feb 21 11:35:50 mysrv dbmail/imap4d[29177]: db.c,db_findmailbox: finding
user with name [__public__].
Feb 21 11:35:50 mysrv dbmail/imap4d[29177]: dbmysql.c,db_query: executing
query [SELECT user_idnr FROM dbmail_users WHERE userid='__public__']
Feb 21 11:35:50 mysrv dbmail/imap4d[29177]: dbmysql.c,db_query: executing
query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='' AND
owner_idnr='8']
Feb 21 11:35:50 mysrv dbmail/imap4d[29177]: IMAPClientHandler(): Finished
command subscribe
-- cut ---
Last SQL query has empty name instead of name of just-created mailbox.
======================================================================
----------------------------------------------------------------------
aaron - 05-May-05 07:25
----------------------------------------------------------------------
Did you manually enter the '_' in this mailbox name: #Public_tttest ?
The MAILBOX_SEPERATOR [sic] is defined to be "/" in dbmail.h. Perhaps you
need to tell Mulberry to use "/" instead of "_"?
See if that helps and let us know!
----------------------------------------------------------------------
paul - 14-Feb-06 16:41
----------------------------------------------------------------------
closing due to lack of feedback
Issue History
Date Modified Username Field Change
======================================================================
21-Feb-05 10:24 aabramov1 New Issue
05-May-05 07:25 aaron Note Added: 0000678
14-Feb-06 16:41 paul Status new => closed
14-Feb-06 16:41 paul Note Added: 0001002
======================================================================
