more authn_dbd woes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

[Index of Archives]     [Open SSH Users]     [Linux ACPI]     [Linux Kernel]     [Linux Laptop]     [Kernel Newbies]     [Security]     [Netfilter]     [Bugtraq]     [Squid]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Samba]     [Video 4 Linux]     [Device Mapper]

  Powered by Linux