modules/aaa/mod_authz_dbd.c

	mod_authz_dbd.c revision 0cf25f370efc889c01f7028bdfc8204b17aa4ce4
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim/* Licensed to the Apache Software Foundation (ASF) under one or more
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim * contributor license agreements.  See the NOTICE file distributed with
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim * this work for additional information regarding copyright ownership.
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim * The ASF licenses this file to You under the Apache License, Version 2.0
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim * (the "License"); you may not use this file except in compliance with
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim * the License.  You may obtain a copy of the License at
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim *
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim *     http://www.apache.org/licenses/LICENSE-2.0
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim *
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim * Unless required by applicable law or agreed to in writing, software
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim * distributed under the License is distributed on an "AS IS" BASIS,
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim * See the License for the specific language governing permissions and
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim * limitations under the License.
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim */
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim#include "httpd.h"
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim#include "http_log.h"
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim#include "http_config.h"
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim#include "ap_provider.h"
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim#include "http_request.h"
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim#include "http_protocol.h"
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim#include "http_core.h"
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick#include "apr_dbd.h"
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim#include "mod_dbd.h"
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim#include "apr_strings.h"
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim#include "mod_authz_dbd.h"
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim#include "mod_auth.h"
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jimmodule AP_MODULE_DECLARE_DATA authz_dbd_module;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim/* Export a hook for modules that manage clientside sessions
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick * (e.g. mod_auth_cookie)
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim * to deal with those when we successfully login/logout at the server
0c32a43de97332a10a45ca4213339132dd4a3844trawick *
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick * XXX: WHY would this be specific to dbd_authz?  Why wouldn't we track
0c32a43de97332a10a45ca4213339132dd4a3844trawick * this across all authz user providers in a lower level mod, such as
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick * mod_auth_basic/digest?
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick */
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickAPR_IMPLEMENT_OPTIONAL_HOOK_RUN_ALL(authz_dbd, AUTHZ_DBD, int, client_login,
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim                            (request_rec *r, int code, const char *action),
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim                            (r, code, action), OK, DECLINED)
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jimtypedef struct {
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    const char *query;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    const char *redir_query;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    int redirect;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim} authz_dbd_cfg ;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jimstatic ap_dbd_t *(*dbd_handle)(request_rec*) = NULL;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jimstatic void (*dbd_prepare)(server_rec*, const char*, const char*) = NULL;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jimstatic const char *const noerror = "???";
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jimstatic void *authz_dbd_cr_cfg(apr_pool_t *pool, char *dummy)
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim{
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    authz_dbd_cfg *ret = apr_pcalloc(pool, sizeof(authz_dbd_cfg));
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    ret->redirect = -1;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    return ret;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim}
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickstatic void *authz_dbd_merge_cfg(apr_pool_t *pool, void *BASE, void *ADD)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick{
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    authz_dbd_cfg *base = BASE;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    authz_dbd_cfg *add = ADD;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    authz_dbd_cfg *ret = apr_palloc(pool, sizeof(authz_dbd_cfg));
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    ret->query = (add->query == NULL) ? base->query : add->query;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    ret->redir_query = (add->redir_query == NULL)
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim                            ? base->redir_query : add->redir_query;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    ret->redirect = (add->redirect == -1) ? base->redirect : add->redirect;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    return ret;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim}
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jimstatic const char *authz_dbd_prepare(cmd_parms *cmd, void *cfg,
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim                                     const char *query)
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim{
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    static unsigned int label_num = 0;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    char *label;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    const char *err = ap_check_cmd_context(cmd, NOT_IN_HTACCESS);
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    if (err)
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim        return err;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    if (dbd_prepare == NULL) {
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim        dbd_prepare = APR_RETRIEVE_OPTIONAL_FN(ap_dbd_prepare);
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim        if (dbd_prepare == NULL) {
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim            return "You must load mod_dbd to enable AuthzDBD functions";
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim        }
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim        dbd_handle = APR_RETRIEVE_OPTIONAL_FN(ap_dbd_acquire);
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    }
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    label = apr_psprintf(cmd->pool, "authz_dbd_%d", ++label_num);
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    dbd_prepare(cmd->server, query, label);
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
f8aafb8bd93472f7da5a7c158958ee09e4176c8etrawick    /* save the label here for our own use */
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    return ap_set_string_slot(cmd, cfg, label);
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim}
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jimstatic const command_rec authz_dbd_cmds[] = {
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    AP_INIT_FLAG("AuthzDBDLoginToReferer", ap_set_flag_slot,
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim                 (void*)APR_OFFSETOF(authz_dbd_cfg, redirect), ACCESS_CONF,
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim                 "Whether to redirect to referer on successful login"),
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    AP_INIT_TAKE1("AuthzDBDQuery", authz_dbd_prepare,
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim                  (void*)APR_OFFSETOF(authz_dbd_cfg, query), ACCESS_CONF,
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim                  "SQL query for DBD Authz or login"),
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    AP_INIT_TAKE1("AuthzDBDRedirectQuery", authz_dbd_prepare,
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim                  (void*)APR_OFFSETOF(authz_dbd_cfg, redir_query), ACCESS_CONF,
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim                  "SQL query to get per-user redirect URL after login"),
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    {NULL}
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim};
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jimstatic int authz_dbd_login(request_rec *r, authz_dbd_cfg *cfg,
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim                           const char *action)
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim{
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    int rv;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    const char *newuri = NULL;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    int nrows;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    const char *message;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    ap_dbd_t *dbd = dbd_handle(r);
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    apr_dbd_prepared_t *query;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    apr_dbd_results_t *res = NULL;
67139e2d50d1e11558d87f7042f61cb04bb0d1d2jim    apr_dbd_row_t *row = NULL;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (cfg->query == NULL) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        ap_log_rerror(APLOG_MARK, APLOG_ERR, 0, r, APLOGNO(01642)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                      "No query configured for %s!", action);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        return HTTP_INTERNAL_SERVER_ERROR;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    query = apr_hash_get(dbd->prepared, cfg->query, APR_HASH_KEY_STRING);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (query == NULL) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        ap_log_rerror(APLOG_MARK, APLOG_ERR, 0, r, APLOGNO(01643)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                      "Error retrieving Query for %s!", action);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        return HTTP_INTERNAL_SERVER_ERROR;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    rv = apr_dbd_pvquery(dbd->driver, r->pool, dbd->handle, &nrows,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                         query, r->user, NULL);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (rv == 0) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        if (nrows != 1) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            ap_log_rerror(APLOG_MARK, APLOG_WARNING, 0, r, APLOGNO(01644)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                          "authz_dbd: %s of user %s updated %d rows",
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                          action, r->user, nrows);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    else {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        message = apr_dbd_error(dbd->driver, dbd->handle, rv);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        ap_log_rerror(APLOG_MARK, APLOG_ERR, 0, r, APLOGNO(01645)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                      "authz_dbd: query for %s failed; user %s [%s]",
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                      action, r->user, message?message:noerror);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        return HTTP_INTERNAL_SERVER_ERROR;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (cfg->redirect == 1) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        newuri = apr_table_get(r->headers_in, "Referer");
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (!newuri && cfg->redir_query) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        query = apr_hash_get(dbd->prepared, cfg->redir_query,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                             APR_HASH_KEY_STRING);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        if (query == NULL) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            ap_log_rerror(APLOG_MARK, APLOG_ERR, 0, r, APLOGNO(01646)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                          "authz_dbd: no redirect query!");
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            /* OK, this is non-critical; we can just not-redirect */
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        else if ((rv = apr_dbd_pvselect(dbd->driver, r->pool, dbd->handle,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                        &res, query, 0, r->user, NULL)) == 0) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            for (rv = apr_dbd_get_row(dbd->driver, r->pool, res, &row, -1);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                 rv != -1;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                 rv = apr_dbd_get_row(dbd->driver, r->pool, res, &row, -1)) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                if (rv != 0) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                    message = apr_dbd_error(dbd->driver, dbd->handle, rv);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                    ap_log_rerror(APLOG_MARK, APLOG_ERR, 0, r, APLOGNO(01647)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                          "authz_dbd in get_row; action=%s user=%s [%s]",
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                          action, r->user, message?message:noerror);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                else if (newuri == NULL) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                    newuri = apr_dbd_get_entry(dbd->driver, row, 0);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                /* we can't break out here or row won't get cleaned up */
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        else {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            message = apr_dbd_error(dbd->driver, dbd->handle, rv);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            ap_log_rerror(APLOG_MARK, APLOG_ERR, 0, r, APLOGNO(01648)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                          "authz_dbd/redirect for %s of %s [%s]",
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                          action, r->user, message?message:noerror);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (newuri != NULL) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        r->status = HTTP_MOVED_TEMPORARILY;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        apr_table_set(r->err_headers_out, "Location", newuri);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    authz_dbd_run_client_login(r, OK, action);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    return OK;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick}
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickstatic int authz_dbd_group_query(request_rec *r, authz_dbd_cfg *cfg,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                 apr_array_header_t *groups)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick{
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    /* SELECT group FROM authz WHERE user = %s */
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    int rv;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    const char *message;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    ap_dbd_t *dbd = dbd_handle(r);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    apr_dbd_prepared_t *query;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    apr_dbd_results_t *res = NULL;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    apr_dbd_row_t *row = NULL;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    const char **group;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (cfg->query == NULL) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        ap_log_rerror(APLOG_MARK, APLOG_ERR, 0, r, APLOGNO(01649)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                      "No query configured for dbd-group!");
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        return HTTP_INTERNAL_SERVER_ERROR;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    query = apr_hash_get(dbd->prepared, cfg->query, APR_HASH_KEY_STRING);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (query == NULL) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        ap_log_rerror(APLOG_MARK, APLOG_ERR, 0, r, APLOGNO(01650)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                      "Error retrieving query for dbd-group!");
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        return HTTP_INTERNAL_SERVER_ERROR;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    rv = apr_dbd_pvselect(dbd->driver, r->pool, dbd->handle, &res,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                          query, 0, r->user, NULL);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (rv == 0) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        for (rv = apr_dbd_get_row(dbd->driver, r->pool, res, &row, -1);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick             rv != -1;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick             rv = apr_dbd_get_row(dbd->driver, r->pool, res, &row, -1)) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            if (rv == 0) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                group = apr_array_push(groups);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                *group = apr_dbd_get_entry(dbd->driver, row, 0);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            else {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                message = apr_dbd_error(dbd->driver, dbd->handle, rv);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                ap_log_rerror(APLOG_MARK, APLOG_ERR, 0, r, APLOGNO(01651)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                        "authz_dbd in get_row; group query for user=%s [%s]",
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                        r->user, message?message:noerror);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                return HTTP_INTERNAL_SERVER_ERROR;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    else {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        message = apr_dbd_error(dbd->driver, dbd->handle, rv);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        ap_log_rerror(APLOG_MARK, APLOG_ERR, 0, r, APLOGNO(01652)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                      "authz_dbd, in groups query for %s [%s]",
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                      r->user, message?message:noerror);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        return HTTP_INTERNAL_SERVER_ERROR;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    return OK;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick}
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickstatic authz_status dbdgroup_check_authorization(request_rec *r,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                                 const char *require_args,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                                 const void *parsed_require_args)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick{
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    int i, rv;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    const char *w;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    apr_array_header_t *groups = NULL;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    const char *err = NULL;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    const ap_expr_info_t *expr = parsed_require_args;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    const char *require;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    const char *t;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    authz_dbd_cfg *cfg = ap_get_module_config(r->per_dir_config,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                              &authz_dbd_module);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (!r->user) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        return AUTHZ_DENIED_NO_USER;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (groups == NULL) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        groups = apr_array_make(r->pool, 4, sizeof(const char*));
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        rv = authz_dbd_group_query(r, cfg, groups);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        if (rv != OK) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            return AUTHZ_GENERAL_ERROR;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    require = ap_expr_str_exec(r, expr, &err);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (err) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        ap_log_rerror(APLOG_MARK, APLOG_ERR, 0, r, APLOGNO(02590)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                      "authz_dbd authorize: require dbd-group: Can't "
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                      "evaluate require expression: %s", err);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        return AUTHZ_DENIED;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    t = require;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    while (t[0]) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        w = ap_getword_white(r->pool, &t);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        for (i=0; i < groups->nelts; ++i) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            if (!strcmp(w, ((const char**)groups->elts)[i])) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                return AUTHZ_GRANTED;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    return AUTHZ_DENIED;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick}
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickstatic authz_status dbdlogin_check_authorization(request_rec *r,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                                 const char *require_args,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                                 const void *parsed_require_args)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick{
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    authz_dbd_cfg *cfg = ap_get_module_config(r->per_dir_config,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                              &authz_dbd_module);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (!r->user) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        return AUTHZ_DENIED_NO_USER;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    return (authz_dbd_login(r, cfg, "login") == OK ? AUTHZ_GRANTED : AUTHZ_DENIED);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick}
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickstatic authz_status dbdlogout_check_authorization(request_rec *r,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                                  const char *require_args,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                                  const void *parsed_require_args)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick{
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    authz_dbd_cfg *cfg = ap_get_module_config(r->per_dir_config,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                              &authz_dbd_module);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (!r->user) {
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        return AUTHZ_DENIED_NO_USER;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    }
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    return (authz_dbd_login(r, cfg, "logout") == OK ? AUTHZ_GRANTED : AUTHZ_DENIED);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick}
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickstatic const char *dbd_parse_config(cmd_parms *cmd, const char *require_line,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                                     const void **parsed_require_line)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick{
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    const char *expr_err = NULL;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    ap_expr_info_t *expr = apr_pcalloc(cmd->pool, sizeof(*expr));
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    expr = ap_expr_parse_cmd(cmd, require_line, AP_EXPR_FLAG_STRING_RESULT,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick            &expr_err, NULL);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    if (expr_err)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick        return apr_pstrcat(cmd->temp_pool,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                           "Cannot parse expression in require line: ",
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                           expr_err, NULL);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    *parsed_require_line = expr;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    return NULL;
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick}
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickstatic const authz_provider authz_dbdgroup_provider =
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick{
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    &dbdgroup_check_authorization,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    dbd_parse_config,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick};
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickstatic const authz_provider authz_dbdlogin_provider =
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick{
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    &dbdlogin_check_authorization,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    NULL,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick};
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickstatic const authz_provider authz_dbdlogout_provider =
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick{
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    &dbdlogout_check_authorization,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    NULL,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick};
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickstatic void authz_dbd_hooks(apr_pool_t *p)
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick{
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    ap_register_auth_provider(p, AUTHZ_PROVIDER_GROUP, "dbd-group",
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                              AUTHZ_PROVIDER_VERSION,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                              &authz_dbdgroup_provider,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                              AP_AUTH_INTERNAL_PER_CONF);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    ap_register_auth_provider(p, AUTHZ_PROVIDER_GROUP, "dbd-login",
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                              AUTHZ_PROVIDER_VERSION,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                              &authz_dbdlogin_provider,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                              AP_AUTH_INTERNAL_PER_CONF);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    ap_register_auth_provider(p, AUTHZ_PROVIDER_GROUP, "dbd-logout",
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                              AUTHZ_PROVIDER_VERSION,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                              &authz_dbdlogout_provider,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick                              AP_AUTH_INTERNAL_PER_CONF);
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick}
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawickAP_DECLARE_MODULE(authz_dbd) =
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick{
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    STANDARD20_MODULE_STUFF,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    authz_dbd_cr_cfg,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    authz_dbd_merge_cfg,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    NULL,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    NULL,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    authz_dbd_cmds,
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick    authz_dbd_hooks
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick};
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick
11f2c481e1d57bedb3f758565307501e9a2730ddtrawick