配置Apache使用SQL Server身份验证 [英] Configure Apache to use SQL Server authentication

问题描述

我相信这是可能配置Apache使用SQL Server进行身份验证。您提供的数据库连接参数和查询运行。我认为合同是一样的东西：

I believe it's possible to configure Apache to use SQL Server for authentication. You supply the DB connection parameters and a query to run. I suppose the contract is something like:

如果该查询返回的东西用户进行身份验证，如果查询结果为空，用户是未知。

If the query returns something the user is authenticated, and if the query results are empty, the user is unkown.

有谁知道我可以配置此？

Does anyone know how I can configure this?

推荐答案

Apache支持 mod_authn_dbd 支持对SQL驱动程序认证和的 mod_dbd 以支持不同的数据库驱动程序。有迹象表明，与TDS协议弥合了Apache DBD框架，从而使针对SQL Server身份验证，喜欢的 ODBC的DBD 。

Apache supports mod_authn_dbd that supports authentication against a SQL driver, and mod_dbd to support various database drivers. There are various projects that bridge the Apache DBD Framework with the TDS protocol, thus allowing authentication against a SQL Server, like odbc-dbd.

我不知道任何人在生产中这样做的，但它看起来像在理论上是可能的，你已经是做的就是这些点连接起来。

I'm not aware of anyone doing this in production, but it looks like theoretically is possible, all you have is to do is connect the dots.

当然，我们在这里谈论一个真正的HTTP认证方案：基本或文摘。如果你有兴趣在形式的认证，这不是HTTP认证，这是某些应用程序的行为，因此在应用code实现，而不是在Apache的。

Of course, we're talking here a true HTTP authentication scheme: Basic or Digest. If you are interested in 'Forms' authentication, that is not HTTP authentication, that is some application behavior and as such is implemented in your app code, not in Apache.

这篇关于配置Apache使用SQL Server身份验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！