AW: multiple calls to canonuser-plugin?

[Lars Duesing]

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 at anywhere.local

Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin: userin:
webmaster at anywhere.local; user_realm=mail

Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin create statement
from webmaster at anywhere.local webmaster at anywhere.local mail

Mar 19 06:29:49 mail cyrus/imap[14563]: canonuersql plugin doing query
select mailbox_name from mailbox_aliases where
mailbox_alias='webmaster at anywhere.local' or
mailbox_alias='webmaster at anywhere.local@mail';

Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin done:
lars at test.local (len 15)

Mar 19 06:29:49 mail cyrus/imap[14563]: canonuersql plugin lookup done:
out_user: lars at test.local, out_ulen: 15

Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin Parse the username
lars at test.local

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 at test.local

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 at test.local

Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin: userin:
lars at test.local; user_realm=mail

Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin create statement
from lars at test.local lars at test.local mail

Mar 19 06:29:49 mail cyrus/imap[14563]: canonuersql plugin doing query
select mailbox_name from mailbox_aliases where
mailbox_alias='lars at test.local' or mailbox_alias='lars at test.local@mail';

Mar 19 06:29:49 mail cyrus/imap[14563]: canonusersql plugin done:
webmaster at test.local (len 20)

Mar 19 06:29:49 mail cyrus/imap[14563]: canonuersql plugin lookup done:
out_user: webmaster at test.local, out_ulen: 20

Mar 19 06:29:49 mail cyrus/imap[14563]: sql plugin Parse the username
webmaster at test.local

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 at 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 at 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 at test.local

 

 

Von: Lars Duesing [mailto:lars.duesing at camelotsweb.de] 
Gesendet: Donnerstag, 18. März 2010 06:50
An: cyrus-sasl at lists.andrew.cmu.edu
Betreff: multiple calls to canonuser-plugin?

 

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 at test.local lars at test.local

lars at test.local                  webmaster at anywhere.local

 

my code does (at the moment!) only one select statement, but is called
twice.

When I ask for webmaster at anywhere.local sasl sends webmaster at 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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.andrew.cmu.edu/pipermail/cyrus-sasl/attachments/20100319/17ec2a67/attachment.html