MS Sql

[Patrick Ben Koetter]

* Dan White <dwhite at olp.net>:
> 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 at 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/>