On 06/29/2014 09:37 AM, Edgar Pettijohn wrote: > On 06/29/2014 07:25 AM, Torge Riedel wrote: >> Hi, >> >> I'm having a server installed with Apache 2.2 (Ubuntu LTS 12.04) and I >> used mod_authn_dbd as documented here >> >> http://httpd.apache.org/docs/2.2/mod/mod_authn_dbd.html >> >> to check the permissions. >> >> Since I use a MySQL database >> >> DBDriver mysql >> >> is set. >> Since there is already an existing user management on a different >> server with access restrictions, the only way to use it is via a >> stored procedure, thus >> >> AuthDBUserPWQuery "CALL queryUser(%s)" >> >> is defined like this. >> But this is a problem, since MySQL is - let's say - a little bit >> special when performing a query which is a call to a stored procedure. If >> you just perform the query and fetch the result, the next query within >> the same connection will fail with "Commands out of sync; you can't >> run this command now" error. >> >> The reason is that when performing a query with a call to a stored >> procedure you must take result sets into account like you do when >> doing a multi-query. >> >> Multi-Query: >> >> "SELECT * FROM tUsers1; SELECT * FROM tUsers2;" >> >> returns in MySQL two result sets and you have to use >> >> mysql_use_result() >> mysql_store_result() >> mysql_free_result() >> >> to properly handle the returned data. And in ANY case where stored >> procedures are involved, you have to use the methods above otherwise >> to you get error. >> I think the reason is, that in stored procedures you can execute two >> or more SELECTs. >> >> I already tried to find the location in the httpd sources where a fix >> is needed, but it seems to me that httpd is using the apr db driver >> interface. >> Maybe the fix has to be done there and not in httpd source, but I'm >> not sure. >> >> Regards >> Torge >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx >> For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx >> > I had this issue before and I can't remember how I fixed it. If you > could provide more of your httpd.conf It might remind me. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx > For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx > And httpd-error.log snippets. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|