Re: Problems creating Mailboxes

Peter Smith <[email protected]> Thu, 1 Feb 2018 16:15:49 +0000
Newsgroups gmane.mail.imap.dbmail
Message-ID <[email protected]>
Thank you for the response.

I am using PostGreSQL, the auth is LDAP, and I'm running at maximum logging level.

The error is isolated, however here's some entries around the error:

Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Debug:[db] db_imap_split_mailbox(+2387): Preparing mailbox [DELETEME]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Debug:[db] db_findmailbox(+2133): looking for mailbox with FQN [DELETEME].
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Debug:[misc] mailbox_remove_namespace(+217): [DELETEME]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Database:[db] db_con_get(+314): [0xe7b570] connection from pool
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Database:[db] db_stmt_prepare(+477): [0xe7b570] [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE owner_idnr = ? AND name ILIKE ?]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Database:[db] db_stmt_set_u64(+497): [0x7f6fc4052d10] 1:[<USERID>]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Database:[db] db_stmt_set_str(+485): [0x7f6fc4052d10] 2:[DELETEME]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Database:[db] db_con_close(+342): [0xe7b570] connection to pool
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Debug:[db] db_createmailbox(+2612): creating shadow user for [<USERID>]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Debug:[db] db_user_find_create(+4056): user_idnr [<USERID>]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Debug:[auth] ldap_con_get(+130): connection [0x7f6fc4002070]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Debug:[auth] ldap_con_get(+130): connection [0x7f6fc4002070]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Debug:[auth] authldap_search(+281):  [(uidNumber=<USERID>)]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Debug:[auth] auth_get_userid(+694): returned value is [(null)]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Error:[db] db_createmailbox(+2615): unable to find or create sql shadow account for useridnr [<USERID>]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xe7b000] Debug:[imap] _ic_cb_leave(+724): handling imap session [0xed6bf0] client_state []
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xe7b000] Debug:[clientbase] ci_uncork(+210): [0xf7a6c0] [28] [28], [4000]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xe7b000] Debug:[imap] imap_handle_exit(+463): [0xed6bf0] state [2] command_status [1] [CREATE] returned with status [0]
Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xe7b000] Debug:[clientbase] ci_write(+347): [0xf7a6c0] S > [28/28:* BYE internal dbase error
]

"uidNumber" in this case is correct and matches my USERID, as does "useridnr".

The account I'm using is my own personal account and I can read the mailboxes just fine.  I do remember a time when I was able to create mailboxes..  I suspect there's a problem in the  "auth_get_userid" since it is returning NULL?

If I manually do an LDAPSEARCH using the "uidNumber", it does in fact find my account and returns everything that I expect.

ldapsearch -W -x -H ldaps://ldap -D <MY DN> -b <MY LOCAL ORG BITS> '(uidNumber=<USERID>)'

Thanks,
Peter

> Hi.
>
> which DB are you using?
>
> also which auth? SQL, LDAP,.. ?
>
> do you have the logging level turned up? are there any other errors as
> well?
>
> Regards


________________________________

UT Southwestern


Medical Center



The future of medicine, today.