1 /* Copyright 2003-5 The Apache Software Foundation or its licensors, as
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
17 /* Overview of what this is and does:
18 * http://www.apache.org/~niq/dbd.html
20 * http://apache.webthing.com/database/
25 #include "http_protocol.h"
26 #include "http_config.h"
28 #include "apr_reslist.h"
29 #include "apr_strings.h"
33 extern module AP_MODULE_DECLARE_DATA dbd_module;
35 /************ svr cfg: manage db connection pool ****************/
37 typedef struct dbd_prepared {
40 struct dbd_prepared *next;
42 typedef struct svr_cfg {
46 dbd_prepared *prepared;
48 apr_reslist_t *dbpool;
58 typedef enum { cmd_name, cmd_params, cmd_persist,
59 cmd_min, cmd_keep, cmd_max, cmd_exp
64 for (p = val; *p; ++p) \
66 return "Argument must be numeric!"
67 static const char *dbd_param(cmd_parms *cmd, void *cfg, const char *val)
70 const apr_dbd_driver_t *driver = NULL;
71 svr_cfg *svr = (svr_cfg*) ap_get_module_config
72 (cmd->server->module_config, &dbd_module);
74 switch ((long) cmd->info) {
77 /* loading the driver involves once-only dlloading that is
78 * best done at server startup. This also guarantees that
79 * we won't return an error later.
81 switch (apr_dbd_get_driver(cmd->pool, svr->name, &driver)) {
83 return apr_psprintf(cmd->pool, "DBD: No driver for %s", svr->name);
85 return apr_psprintf(cmd->pool,
86 "DBD: Can't load driver file apr_dbd_%s.so",
88 case APR_ESYMNOTFOUND:
89 return apr_psprintf(cmd->pool,
90 "DBD: Failed to load driver apr_dbd_%s_driver",
99 svr->persist = atoi(val);
104 svr->nmin = atoi(val);
108 svr->nkeep = atoi(val);
112 svr->nmax = atoi(val);
116 svr->exptime = atoi(val);
122 AP_DECLARE(void) ap_dbd_prepare(server_rec *s, const char *query,
125 svr_cfg *svr = ap_get_module_config(s->module_config, &dbd_module);
126 dbd_prepared *prepared = apr_pcalloc(s->process->pool, sizeof(dbd_prepared));
127 prepared->label = label;
128 prepared->query = query;
129 prepared->next = svr->prepared;
130 svr->prepared = prepared;
132 static const char *dbd_prepare(cmd_parms *cmd, void *cfg, const char *query,
135 ap_dbd_prepare(cmd->server, query, label);
138 static const command_rec dbd_cmds[] = {
139 AP_INIT_TAKE1("DBDriver", dbd_param, (void*)cmd_name, RSRC_CONF,
141 AP_INIT_TAKE1("DBDParams", dbd_param, (void*)cmd_params, RSRC_CONF,
142 "SQL Driver Params"),
143 AP_INIT_TAKE1("DBDPersist", dbd_param, (void*)cmd_persist, RSRC_CONF,
144 "Use persistent connection/pool"),
145 AP_INIT_TAKE2("DBDPrepareSQL", dbd_prepare, NULL, RSRC_CONF,
146 "Prepared SQL statement, label"),
148 AP_INIT_TAKE1("DBDMin", dbd_param, (void*)cmd_min, RSRC_CONF,
149 "Minimum number of connections"),
150 AP_INIT_TAKE1("DBDKeep", dbd_param, (void*)cmd_keep, RSRC_CONF,
151 "Maximum number of sustained connections"),
152 AP_INIT_TAKE1("DBDMax", dbd_param, (void*)cmd_max, RSRC_CONF,
153 "Maximum number of connections"),
154 AP_INIT_TAKE1("DBDExptime", dbd_param, (void*)cmd_exp, RSRC_CONF,
155 "Keepalive time for idle connections"),
159 #define DEFAULT_NMIN 0
160 #define DEFAULT_NMAX 5
161 #define DEFAULT_NKEEP 1
162 #define DEFAULT_EXPTIME 120
163 #define COND_PARAM(x,val) \
164 if (cfg->x == val) { \
165 cfg->x = ((svr_cfg*)base)->x; \
167 #define COND_PARAM0(x) COND_PARAM(x,0)
168 #define COND_PARAM1(x) COND_PARAM(x,-1)
169 static void *dbd_merge(apr_pool_t *pool, void *base, void *add) {
170 svr_cfg *cfg = apr_pmemdup(pool, add, sizeof(svr_cfg));
173 COND_PARAM1(persist);
175 COND_PARAM(nmin, DEFAULT_NMIN);
176 COND_PARAM(nkeep, DEFAULT_NKEEP);
177 COND_PARAM(nmax, DEFAULT_NMAX);
178 COND_PARAM(exptime, DEFAULT_EXPTIME);
185 static void *dbd_cfg(apr_pool_t *p, server_rec *x)
187 svr_cfg *svr = (svr_cfg*) apr_pcalloc(p, sizeof(svr_cfg));
189 svr->name = svr->params = ""; /* don't risk segfault on misconfiguration */
191 svr->nmin = DEFAULT_NMIN;
192 svr->nkeep = DEFAULT_NKEEP;
193 svr->nmax = DEFAULT_NMAX;
194 svr->exptime = DEFAULT_EXPTIME;
198 static apr_status_t dbd_prepared_init(apr_pool_t *pool, svr_cfg *svr,
202 apr_status_t ret = APR_SUCCESS;
203 apr_dbd_prepared_t *stmt;
204 dbd->prepared = apr_hash_make(pool);
206 for (p = svr->prepared; p; p = p->next) {
208 if (apr_dbd_prepare(dbd->driver, pool, dbd->handle, p->query,
209 p->label, &stmt) == 0) {
210 apr_hash_set(dbd->prepared, p->label, APR_HASH_KEY_STRING, stmt);
218 /************ svr cfg: manage db connection pool ****************/
219 /* an apr_reslist_constructor for SQL connections
220 * Also use this for opening in non-reslist modes, since it gives
221 * us all the error-handling in one place.
223 static apr_status_t dbd_construct(void **db, void *params, apr_pool_t *pool)
225 svr_cfg *svr = (svr_cfg*) params;
226 ap_dbd_t *rec = apr_pcalloc(pool, sizeof(ap_dbd_t));
227 apr_status_t rv = apr_dbd_get_driver(pool, svr->name, &rec->driver);
229 /* Error-checking get_driver isn't necessary now (because it's done at
230 * config-time). But in case that changes in future ...
234 ap_log_perror(APLOG_MARK, APLOG_CRIT, 0, pool,
235 "DBD: driver for %s not available", svr->name);
238 ap_log_perror(APLOG_MARK, APLOG_CRIT, 0, pool,
239 "DBD: can't find driver for %s", svr->name);
241 case APR_ESYMNOTFOUND:
242 ap_log_perror(APLOG_MARK, APLOG_CRIT, 0, pool,
243 "DBD: driver for %s is invalid or corrupted", svr->name);
246 ap_log_perror(APLOG_MARK, APLOG_CRIT, 0, pool,
247 "DBD: mod_dbd not compatible with apr in get_driver");
253 rv = apr_dbd_open(rec->driver, pool, svr->params, &rec->handle);
256 ap_log_perror(APLOG_MARK, APLOG_CRIT, 0, pool,
257 "DBD: Can't connect to %s[%s]", svr->name, svr->params);
260 ap_log_perror(APLOG_MARK, APLOG_CRIT, 0, pool,
261 "DBD: mod_dbd not compatible with apr in open");
267 rv = dbd_prepared_init(pool, svr, rec);
271 static apr_status_t dbd_destruct(void *sql, void *params, apr_pool_t *pool)
274 return apr_dbd_close(rec->driver, rec->handle);
277 static apr_status_t dbd_setup(apr_pool_t *pool, server_rec *s)
279 svr_cfg *svr = ap_get_module_config(s->module_config, &dbd_module);
280 apr_status_t rv = apr_reslist_create(&svr->dbpool, svr->nmin, svr->nkeep,
281 svr->nmax, svr->exptime,
282 dbd_construct, dbd_destruct,
284 if (rv == APR_SUCCESS) {
285 apr_pool_cleanup_register(pool, svr->dbpool,
286 (void*)apr_reslist_destroy,
287 apr_pool_cleanup_null);
290 ap_log_perror(APLOG_MARK, APLOG_CRIT, 0, pool,
291 "DBD Pool: failed to initialise");
299 /* Functions we export for modules to use:
300 - open acquires a connection from the pool (opens one if necessary)
301 - close releases it back in to the pool
303 AP_DECLARE(void) ap_dbd_close(server_rec *s, ap_dbd_t *sql)
305 svr_cfg *svr = ap_get_module_config(s->module_config, &dbd_module);
307 apr_dbd_close(sql->driver, sql->handle);
311 apr_reslist_release(svr->dbpool, sql);
315 static apr_status_t dbd_close(void *CONN)
317 ap_dbd_t *conn = CONN;
318 return apr_dbd_close(conn->driver, conn->handle);
320 #define arec ((ap_dbd_t*)rec)
322 AP_DECLARE(ap_dbd_t*) ap_dbd_open(apr_pool_t *pool, server_rec *s)
325 svr_cfg *svr = ap_get_module_config(s->module_config, &dbd_module);
326 apr_status_t rv = APR_SUCCESS;
330 /* Return a once-only connection */
331 rv = dbd_construct(&rec, svr, s->process->pool);
332 return (rv == APR_SUCCESS) ? arec : NULL;
336 if (dbd_setup(s->process->pool, s) != APR_SUCCESS) {
340 if (apr_reslist_acquire(svr->dbpool, &rec) != APR_SUCCESS) {
341 ap_log_perror(APLOG_MARK, APLOG_ERR, 0, pool,
342 "Failed to acquire DBD connection from pool!");
345 rv = apr_dbd_check_conn(arec->driver, pool, arec->handle);
346 if ((rv != APR_SUCCESS) && (rv != APR_ENOTIMPL)) {
347 errmsg = apr_dbd_error(arec->driver, arec->handle, rv);
349 errmsg = "(unknown)";
351 ap_log_perror(APLOG_MARK, APLOG_ERR, 0, pool,
352 "DBD[%s] Error: %s", svr->name, errmsg );
353 apr_reslist_invalidate(svr->dbpool, rec);
359 AP_DECLARE(ap_dbd_t*) ap_dbd_open(apr_pool_t *pool, server_rec *s)
361 apr_status_t rv = APR_SUCCESS;
364 svr_cfg *svr = ap_get_module_config(s->module_config, &dbd_module);
367 /* Return a once-only connection */
368 rv = dbd_construct(&rec, svr, s->process->pool);
369 return (rv == APR_SUCCESS) ? arec : NULL;
372 /* since we're in nothread-land, we can mess with svr->conn with impunity */
373 /* If we have a persistent connection and it's good, we'll use it */
375 rv = apr_dbd_check_conn(svr->conn->driver, pool, svr->conn->handle);
376 if ((rv != APR_SUCCESS) && (rv != APR_ENOTIMPL)) {
377 errmsg = apr_dbd_error(arec->driver, arec->handle, rv);
379 errmsg = "(unknown)";
381 ap_log_perror(APLOG_MARK, APLOG_ERR, 0, pool,
382 "DBD[%s] Error: %s", svr->name, errmsg);
386 /* We don't have a connection right now, so we'll open one */
388 if (dbd_construct(&rec, svr, s->process->pool) == APR_SUCCESS) {
390 apr_pool_cleanup_register(s->process->pool, svr->conn,
391 dbd_close, apr_pool_cleanup_null);
400 apr_reslist_t *dbpool;
402 static apr_status_t dbd_release(void *REQ)
404 dbd_pool_rec *req = REQ;
405 apr_reslist_release(req->dbpool, req->conn);
408 AP_DECLARE(ap_dbd_t *) ap_dbd_acquire(request_rec *r)
411 dbd_pool_rec *req = ap_get_module_config(r->request_config, &dbd_module);
413 req = apr_palloc(r->pool, sizeof(dbd_pool_rec));
414 req->conn = ap_dbd_open(r->pool, r->server);
416 svr = ap_get_module_config(r->server->module_config, &dbd_module);
417 ap_set_module_config(r->request_config, &dbd_module, req);
419 req->dbpool = svr->dbpool;
420 apr_pool_cleanup_register(r->pool, req, dbd_release,
421 apr_pool_cleanup_null);
424 apr_pool_cleanup_register(r->pool, req->conn, dbd_close,
425 apr_pool_cleanup_null);
431 AP_DECLARE(ap_dbd_t *) ap_dbd_cacquire(conn_rec *c)
434 dbd_pool_rec *req = ap_get_module_config(c->conn_config, &dbd_module);
436 req = apr_palloc(c->pool, sizeof(dbd_pool_rec));
437 req->conn = ap_dbd_open(c->pool, c->base_server);
439 svr = ap_get_module_config(c->base_server->module_config, &dbd_module);
440 ap_set_module_config(c->conn_config, &dbd_module, req);
442 req->dbpool = svr->dbpool;
443 apr_pool_cleanup_register(c->pool, req, dbd_release,
444 apr_pool_cleanup_null);
447 apr_pool_cleanup_register(c->pool, req->conn, dbd_close,
448 apr_pool_cleanup_null);
455 AP_DECLARE(ap_dbd_t *) ap_dbd_acquire(request_rec *r)
458 ap_dbd_t *ret = ap_get_module_config(r->request_config, &dbd_module);
460 svr = ap_get_module_config(r->server->module_config, &dbd_module);
461 ret = ap_dbd_open(r->pool, r->server);
463 ap_set_module_config(r->request_config, &dbd_module, ret);
465 apr_pool_cleanup_register(r->pool, svr->conn, dbd_close,
466 apr_pool_cleanup_null);
468 /* if persist then dbd_open registered cleanup on proc pool */
473 AP_DECLARE(ap_dbd_t *) ap_dbd_cacquire(conn_rec *c)
476 ap_dbd_t *ret = ap_get_module_config(c->conn_config, &dbd_module);
478 svr = ap_get_module_config(c->base_server->module_config, &dbd_module);
479 ret = ap_dbd_open(c->pool, c->base_server);
481 ap_set_module_config(c->conn_config, &dbd_module, ret);
483 apr_pool_cleanup_register(c->pool, svr->conn, dbd_close,
484 apr_pool_cleanup_null);
486 /* if persist then dbd_open registered cleanup on proc pool */
493 static void dbd_hooks(apr_pool_t *pool)
496 ap_hook_child_init((void*)dbd_setup, NULL, NULL, APR_HOOK_MIDDLE);
498 APR_REGISTER_OPTIONAL_FN(ap_dbd_open);
499 APR_REGISTER_OPTIONAL_FN(ap_dbd_close);
500 APR_REGISTER_OPTIONAL_FN(ap_dbd_acquire);
501 APR_REGISTER_OPTIONAL_FN(ap_dbd_cacquire);
502 APR_REGISTER_OPTIONAL_FN(ap_dbd_prepare);
506 module AP_MODULE_DECLARE_DATA dbd_module = {
507 STANDARD20_MODULE_STUFF,