I have a server with several hundred directories, each password protected against their own database. I added a file, httpd-auth.conf in conf/extra that I include from httpd.conf. This file has many entries that look like this:
<Directory /var/www/securedocs/1pbpdemo> AuthType Basic AuthName "Z-TEC International, Inc.: Onepage Plans" AuthBasicProvider dbd Require valid-user AuthDBDUserPWQuery "select password from onepage_1pbpdemo.structure where userid = %s </Directory> <Directory /var/www/securedocs/1pbpdemo/admin> AuthType Basic AuthName "Z-TEC International, Inc. Admin Area" AuthBasicProvider dbd Require valid-user AuthDBDUserPWQuery "select adminPasswd from onepage_1pbpdemo.master where adminUser = %s </Directory> when there are only a few of these entries, the system works. However, when the file is complete with all 17,000 lines, the server produces errors and no longer does authentication correctly. I get this error: Internal error: DBD: failed to prepare SQL statements: I grep 'failed to prepare' in modules/aaa and srclib/apr and srclib/apr-util, but it isn't found. As usual, this isn't a terribly informative error. It would be great if it said WHAT SQL statement it failed to prepare, or if it was out of memory or whatever. Any help?