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 Mon, 11 Aug 2008 13:21:39 GMT
Res:

I've listed the modules (-t -D DUMP_MODULES), and both dbd_module & 
authn_dbd_module show up in the list.  The last line in the report 
states 'Syntax OK'.

Thanks,
    -Steve

Res wrote:
> On Thu, 7 Aug 2008, 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" ?
>
> That wont produce errors like that, not in apache log on "start up"
>
>
> Steve:
> Try this:   httpd -t -D DUMP_MODULES
>
> and look for 'authn_dbd_module' and  'dbd_module'
> and ensure it reprots no problems with syntax
>
>
> ------------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> 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