* Dan White <dwhite@xxxxxxx>: > 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 The OP requested MS SQL access and not MySQL. Does the MySQL driver work for MS SQL? p@rick > 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 -- All technical questions asked privately will be automatically answered on the list and archived for public access unless privacy is explicitely required and justified. saslfinger (debugging SMTP AUTH): <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
