httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tom Donovan <donov...@bellatlantic.net>
Subject Re: [users@httpd] mod_dbd & mod_dbd_authn - mysql user authentication problems - apache 2.2.9
Date Fri, 15 Aug 2008 11:50:37 GMT
Steve Whitson wrote:

>> When I start the server I get the following error:
>>
>> [notice] Apache/2.2.9 (Unix) DAV/2 PHP/5.2.6 SVN/1.5.1 configured --
>> resuming normal operations
>> [info] Server built: Aug 7 2008 11:06:05
>> [debug] prefork.c(1001): AcceptMutex: fcntl (default: fcntl)
>> [error] (20014)Internal error: DBD: failed to prepare SQL
>> statements:
>> Unknown command
>> [error] (20014)Internal error: DBD: failed to initialise
>>

Since you get to the point of preparing your SQL statement when the error occurs, apache has
already 
successfully connected to your mysql database.  This pretty much rules out missing libraries,
etc.

The problem seems to be that mysql is returning "Unknown command" in response to your SQL
statement:

  "select password from users where name = %s"

The apache part of the error message is as expected, but the mysql-supplied part of the message
is 
"Unknown command".  FYI - this is what a log entry for an invalid SQL statement looks like:

[Fri Aug 15 07:35:09 2008] [error] (20014)Internal error: DBD: failed to prepare SQL statements:
You 
have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
for 
the right syntax to use near 'selectXX password from users where name = ?' at line 1
[Fri Aug 15 07:35:09 2008] [error] (20014)Internal error: DBD: failed to initialise

You are using mysql version 5.0, right?

-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


Mime
View raw message