httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Simon <wreckmyb...@yahoo.com>
Subject Re: [users@httpd] help with mod_authn_dbd and oracle
Date Tue, 18 Nov 2008 21:46:17 GMT
> > 

> > To answer your question directly, if your apr-util is built
> > to load drivers dynamically, then yes, it should be
> > apr_dbd_oracle.so (or .dll).  But I don't know what the
> > situation is on windows.  Have you tried building it
> > yourself (either the driver, or the whole of apr-util)?
> > 
> > You might also be able to use the ODBC driver as an alternative.
> > 
> > -- Nick Kew
> 
> That's very helpful information. I have Apache 2.2.9/APR 1.3 available on 
> another box. I tried the config and now
> I'm getting a different error message:
> 
> [Tue Nov 18 14:42:18 2008] [error] (20014)Internal error: DBD: Can't connect to 
> oracle
> [Tue Nov 18 14:42:18 2008] [error] (20014)Internal error: DBD: failed to 
> initialise
> 
> What does that tell me, besides the obvious?
> 
> Yes, odbc is an option. I investigated ODBC by setting "DBDriver odbc", but on 
> startup the error log is reporting:
> 
> (OS 126)The specified module could not be found.  : DBD: mod_dbd not compatible 
> with APR in get_driver
> (OS 126)The specified module could not be found.  : DBD: failed to initialise
> 
> Any further guidance?
> 

I mucked around some more. I have the following config for mod_dbd:

DBDriver oracle
DBDParams "user=testdev pass=xxxx dbname=db9i server=10.8.130.12:1521"

DBDMin  4
DBDKeep 8
DBDMax  20
DBDExptime 300

I'm thinking that the DBDParams aren't correct because I can see, what looks to be, apache/mod_dbd
communicating with Oracle on startup and maybe passing the wrong SERVICE_NAME, 10.8.130.12
instead of db9i?

filter: (ip or ip6) and ( port 1521 )
####
T 10.8.130.176:4302 -> 10.8.130.12:1521 [AP]
  .........9.,...............:....aa........................(DESCRIPTION=(CON
  NECT_DATA=(SERVICE_NAME=10.8.130.12)(CID=(PROGRAM=C:\Program Files\Apache S
  oftware Foundation\Apache2.2\bin\httpd.exe)(HOST=APACHETESTSERVER)(USER=SYSTEM
  )))(ADDRESS=(PROTOCOL=TCP)(HOST=10.8.130.12)(PORT=1521)))
#
T 10.8.130.12:1521 -> 10.8.130.176:4302 [AP]
  .g......"..[(DESCRIPTION=(TMP=)(VSNNUM=153093632)(ERR=12514)(ERROR_STACK=(E
  RROR=(CODE=12514)(EMFI=4))))
##
T 10.8.130.12:1521 -> 10.8.130.176:4302 [A]
  ......
#
T 10.8.130.12:1521 -> 10.8.130.176:4302 [AF]
  ......

---------------------------------------------------------------------
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


Mime
View raw message