httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Whitson <steven.whit...@gmail.com>
Subject Re: [users@httpd] mod_dbd & mod_dbd_authn - mysql user authentication problems - apache 2.2.9
Date Fri, 08 Aug 2008 18:22:52 GMT
The query works just fine from the command line interface (from the same 
server system), and matches the case of the tables (all lower case).

Thanks much!

Tom Donovan wrote:
> Steve Whitson wrote:
>> I’m trying to use mod_dbd and mod_authn_dbd and replacements for 
>> mod_auth_mysql within an apache 2.2.9 server I built on solaris.
>
>> AuthDBDUserPWQuery "select password from users where name = %s"
>> ...
>> When I start the server I get the following error:
>
>> [error] (20014)Internal error: DBD: failed to prepare SQL statements: 
>> Unknown command
>> [error] (20014)Internal error: DBD: failed to initialise
>
> A guess: mysql table names are case-sensitive on Unix, although field 
> names are not.
>
> Is your actual table name "Users" rather than "users" ?
>
> -tom-
>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server 
> Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>   "   from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>



---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message