httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Radek Pospíšil <>
Subject [users@httpd] Empty username causes internal server error
Date Sat, 27 Sep 2014 20:23:24 GMT

I am using user authentication with the following components:

Apache/2.4.10 (Win32) + mod_auth_basic + mod_authn_dbd + mod_dbd + ODBC Driver + Microsoft
SQL Server 2008(SP3).

It works fine except when I do not provide any username when browser asks for username and
password. In this case I receive the "Internal Server Error" as the response instead of "Unauthorized"

The most interesting part of the error.log is:

[Sat Sep 27 21:23:17.639860 2014] [authn_dbd:error] [pid 1208:tid 1636] [client]
AH01656: Query execution error looking up '' in database [[dbd_odbc] SQLBindParameter returned
SQL_ERROR (-1) at apr_dbd_odbc.c:604 [Microsoft][ODBC SQL Server Driver]Invalid precision
value HY104 ]

The AuthDBDUserPWQuery directive in my httpd.conf is:

AuthDBDUserPWQuery "SELECT password FROM member WHERE CONVERT(VARCHAR(10), member_Index) =

And the member_Index column in the database is smallint.

Is it a bug or am I missing something? Any ideas are welcome.



To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message