Re: MS Sql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 08/09/10 14:44 +0100, Bruno Matos wrote:
Hello,

I'm using Cyrus SASL to configure authentication in Qpid, and I would
like to know if it is possible to use MsSql or how to add support for
it.

See:

http://www.cyrusimap.org/docs/cyrus-sasl/2.1.23/

and in particular:
http://www.cyrusimap.org/docs/cyrus-sasl/2.1.23/options.php

Using the cpp/etc/sasl2/qpidd.conf file (within the source) as a guide,
you'd do something like:

pwcheck_method: auxprop
auxprop_plugin: sql
sql_engine: mysql
sql_hostnames: localhost
sql_user: user
sql_passwd: secret
sql_database: sasl
sql_select: SELECT %p FROM user_table WHERE username = '%u' and realm = '%r'
sql_insert: INSERT INTO user_table (username, realm, %p) VALUES ('%u', '%r', '%v')
sql_update: UPDATE ...

and obviously remove the 'sql_select: dummy select' line from that config.

--
Dan White


[Index of Archives]     [Info Cyrus]     [Squirrel Mail]     [Linux Media]     [Yosemite News]     [gtk]     [KDE]     [Gimp on Windows]     [Steve's Art]

  Powered by Linux