I'm looking to get authorization to operate on my small apache installation. I wish to authorize based on what group the consumer goes to.

I'm using

  • Apache 2.2.15
  • Centos 6.2 (Running as guest in VB)

My setup is working basically simply want to authenticate/authorize in line with the user.

This is actually the significant part (I believe...) of my httpd.conf:

<Directory "/var/www/html">

    Options Indexes FollowSymLinks

    AllowOverride None

    Order allow,deny
    Allow from all

        AuthType Basic
        AuthName "Restricted Files"
        AuthBasicProvider dbd
        Require dbd-group 1
        Require valid-user

        AuthzDBDQuery "SELECT group_id FROM groupsusers JOIN user ON groupsusers.user_id = user.id WHERE groupsusers.group_id = 1 AND user.users = %s"
        AuthDBDUserPWQuery "SELECT password FROM user WHERE users = %s"


AuthzDBDQuery does not work since, when i comprehend it, it's not a part of any stable version yet. This is actually the error message I recieve while beginning httpd:

Invalid command 'AuthzDBDQuery', possibly misspelled or based on a module not incorporated within the server configuration httpd not running, attempting to start

My real question is, how do i use groups for authorization when utilizing mysql for storing the particular groups? I suppose it should be possible without re-producing apache?

Since everything for this is fairly poor recorded it might be greate to obtain some detailed instructions. Obviously, anything that will help me within the rigth direction is appreciated.


It isn't feasible at this time. It can come support with this within the next stable version of httpd.