Some log-entries: Mar 19 06:29:34 mail cyrus/imap[14563]: sql canonuser plugin STARTING Mar 19 06:29:34 mail cyrus/imap[14563]: sql canonuser plugin using mysql engine with select: select mailbox_name from mailbox_aliases where mailbox_alias='%u ' or mailbox_alias='%u@%r' Mar 19 06:29:34 mail cyrus/imap[14563]: sql canonuser plugin STARTING Mar 19 06:29:34 mail cyrus/imap[14563]: sql canonuser plugin using mysql engine with select: select mailbox_name from mailbox_aliases where mailbox_alias='%u ' or mailbox_alias='%u@%r' Mar 19 06:29:34 mail cyrus/imap[14563]: sql auxprop plugin using mysql engine Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql START LOOKUP Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin Parse the username webmaster@xxxxxxxxxxxxxx Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin: userin: webmaster@xxxxxxxxxxxxxx; user_realm=mail Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin create statement from webmaster@xxxxxxxxxxxxxx webmaster@xxxxxxxxxxxxxx mail Mar 19 06:29:49 mail cyrus/imap[14563]: canonuersql plugin doing query select mailbox_name from mailbox_aliases where mailbox_alias='webmaster@xxxxxxxxxxxxxx' or mailbox_alias='webmaster@xxxxxxxxxxxxxx@mail'; Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin done: lars@xxxxxxxxxx (len 15) Mar 19 06:29:49 mail cyrus/imap[14563]: canonuersql plugin lookup done: out_user: lars@xxxxxxxxxx, out_ulen: 15 Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin Parse the username lars@xxxxxxxxxx Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin try and connect to a host Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin trying to open db 'mail' on host 'localhost' Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin Parse the username lars@xxxxxxxxxx Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin try and connect to a host Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin trying to open db 'mail' on host 'localhost' Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql START LOOKUP Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin Parse the username lars@xxxxxxxxxx Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin: userin: lars@xxxxxxxxxx; user_realm=mail Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin create statement from lars@xxxxxxxxxx lars@xxxxxxxxxx mail Mar 19 06:29:49 mail cyrus/imap[14563]: canonuersql plugin doing query select mailbox_name from mailbox_aliases where mailbox_alias='lars@xxxxxxxxxx' or mailbox_alias='lars@xxxxxxxxxx@mail'; Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin done: webmaster@xxxxxxxxxx (len 20) Mar 19 06:29:49 mail cyrus/imap[14563]: canonuersql plugin lookup done: out_user: webmaster@xxxxxxxxxx, out_ulen: 20 Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin Parse the username webmaster@xxxxxxxxxx Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin create statement from userPassword webmaster test. Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin doing query select mailbox_password from mailbox where mailbox_name='webmaster' or mailbox_name='webmaster@test.'; Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin create statement from cmusaslsecretPLAIN webmaster test. Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin doing query select mailbox_password from mailbox where mailbox_name='webmaster' or mailbox_name='webmaster@test.'; Mar 19 06:29:49 mail cyrus/imap[14563]: commit transaction Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin Parse the username webmaster@xxxxxxxxxx Von: Lars Duesing [mailto:lars.duesing@xxxxxxxxxxxxxx] Hi List, I am programming a sql canonuser-plugin. In short it does a sql-statement (SELECT main_account FROM accounts WHERE address=’%s’) This plugin is to be used in cyrus-imap. All my code works fine. But: the canonuser-plugin is called multiple times within the same context. For instance: --- DB: main_account address webmaster@xxxxxxxxxx lars@xxxxxxxxxx lars@xxxxxxxxxx webmaster@xxxxxxxxxxxxxx my code does (at the moment!) only one select statement, but is called twice. When I ask for webmaster@xxxxxxxxxxxxxx sasl sends webmaster@t – because the length given back is the length from the first select. My problem is it seems like the code is called twice at the same time. Is this a problem of sasl or of imap? Regards, Lars |
