Hello,
I've just about gotten things working so that cyrus will use mysql natively
(not using saslauthd).
I need to resolve how sasl2 treats users and how web-cyradm sets up it's
database.
What are the columns prefix and domain_name supposed to contain? When I use
sasl tools (like saslpasswd2) I can create users and setup passwords. But
in order for it to understand how to instruct SQL I need to know where to
stuff the right values.
For example, this is my /usr/lib/sasl2/saslpasswd2.conf file:
pwcheck_method: auxprop
auxprop_plugin: sql
sql_engine: mysql
sql_user: mail
sql_passwd: secret
sql_hostnames: localhost
sql_database: mail
sql_select: select password from accountuser where username = '[EMAIL
PROTECTED]'
sql_insert: insert into accountuser (username, password, realm) values
('%u', '%v', '%r')
sql_update: update accountuser set password = '%v', realm = '%r' where
username = '%u'
sql_verbose: true
The 'realm' value is currently the FQDN on this host. I, presumably, change
the sql select, update and insert commands to use whatever columns are
appropriate. Is the 'domain_name' column the equivalent to realm? What's
supposed to be in prefix?
Once this is resolved then it becomes a matter of how passwords are stored
and how that affects using challenge-response mechanisms. More on that as I
peel this onion, layer by stress-inducing layer...
-Bill Kearney
_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm
