The following bug has been SUBMITTED.
======================================================================
http://dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000176
======================================================================
Reported By: aabramov1
Assigned To:
======================================================================
Project: DBMail
Bug ID: 176
Category: Database layer
Reproducibility: always
Severity: minor
Priority: normal
Status: new
======================================================================
Date Submitted: 21-Feb-05 10:24 CET
Last Modified: 21-Feb-05 10:24 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.
======================================================================
Bug History
Date Modified Username Field Change
======================================================================
21-Feb-05 10:24aabramov1 New Bug
======================================================================
