You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by po...@web.de on 2008/01/08 09:22:27 UTC

[users@httpd] apache 2.2.6 not connecting to oracle with mod_dbd

Hi all,

i am trying to use apache 2.2.6 with mod_dbd and mod_authn_dbd in conjunction with apr 1.3 in order to do digest authentication with users in an oracle database. mod_dbd finds the oracle driver but it obviously can't connect to oracle. The oracle logs show me that mod_dbd doesn't even try to connect to oracle. What am i doing wrong?

The apache error log just says:
[Tue Jan 08 08:52:59 2008] [error] (20014)Internal error: DBD: Can't connect to oracle
[Tue Jan 08 08:52:59 2008] [error] (20014)Internal error: DBD: failed to initialise

My httpd.conf looks like this:

DBDriver oracle
DBDParams "user=ows pass=xxxxx dbname=NAVTST server=10.6.222.11:1532"
DBDMin  1
DBDKeep 2
DBDMax  10
DBDExptime 60
<Directory /application/webalizer>
    AuthType Digest
    AuthName "testrealm"
    AuthBasicProvider dbd
    Require valid-user
    AuthDBDUserPWQuery "select pass from usertest where name = %s"
</Directory>

If you don't know the solution i would even be happy about an advice how to debug my problem.

Thanks in advance.




_______________________________________________________________________
Jetzt neu! Schützen Sie Ihren PC mit McAfee und WEB.DE. 30 Tage
kostenlos testen. http://www.pc-sicherheit.web.de/startseite/?mc=022220


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org

Re: [users@httpd] apache 2.2.6 not connecting to oracle with mod_dbd

Posted by Nick Kew <ni...@webthing.com>.
On Tue, 8 Jan 2008 10:18:49 +0000
Nick Kew <ni...@webthing.com> wrote:


> OK, since you're using APR 1.3, you can get a bit more error message
> by patching mod_dbd as follows (modulo my mailer's line wrap):

Bah.  That patch should of course be as attached.

-- 
Nick Kew

Application Development with Apache - the Apache Modules Book
http://www.apachetutor.org/

Re: [users@httpd] apache 2.2.6 not connecting to oracle with mod_dbd

Posted by Nick Kew <ni...@webthing.com>.
On Tue, 08 Jan 2008 09:22:27 +0100
porath@web.de wrote:

> The apache error log just says:
> [Tue Jan 08 08:52:59 2008] [error] (20014)Internal error: DBD: Can't
> connect to oracle [Tue Jan 08 08:52:59 2008] [error] (20014)Internal
> error: DBD: failed to initialise

OK, since you're using APR 1.3, you can get a bit more error message
by patching mod_dbd as follows (modulo my mailer's line wrap):

--- modules/database/mod_dbd.c  (revision 609791)
+++ modules/database/mod_dbd.c  (working copy)
@@ -459,6 +459,7 @@
     apr_pool_t *rec_pool, *prepared_pool;
     ap_dbd_t *rec;
     apr_status_t rv;
+    const char *err = "";
 
     rv = apr_pool_create(&rec_pool, pool);
     if (rv != APR_SUCCESS) {
@@ -502,12 +503,12 @@
         return rv;
     }
 
-    rv = apr_dbd_open(rec->driver, rec->pool, cfg->params,
&rec->handle);
+    rv = apr_dbd_open_ex(rec->driver, rec->pool, cfg->params,
&rec->handle, &err);
     if (rv != APR_SUCCESS) {
         switch (rv) {
         case APR_EGENERAL:
             ap_log_error(APLOG_MARK, APLOG_ERR, rv, cfg->server,
-                         "DBD: Can't connect to %s", cfg->name);
+                         "DBD: Can't connect to %s: %s", cfg->name,
err);
             break;
         default:
             ap_log_error(APLOG_MARK, APLOG_ERR, rv, cfg->server,



> My httpd.conf looks like this:

1.  Is that at top-level or inside a <virtualhost>?
2.  Does dropping DBDMin to 0 make any difference?

-- 
Nick Kew

Application Development with Apache - the Apache Modules Book
http://www.apachetutor.org/

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org