httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From RJones1 <randy_jo...@esri.com>
Subject Re: [users@httpd] mod_authn_dbd/mod_dbd problem with oracle
Date Tue, 13 Jan 2009 01:09:16 GMT

Ok, I now have a success story to tell.

So Nick pointed me in the right direction with the OS 126 error. I went to
try to create an odbc connection and got the same exception. My 3rd Google
search resulted in 
http://forums.oracle.com/forums/thread.jspa?threadID=527220&tstart=0 this
forum  which lead me to copy mfc71.dll and msvcr71.dll into my Oracle Client
installation. I could then create an odbc connection. But when I tried to
use the odbc connection in apache I got a strange TNS Listener error
(ORA-12154). I started to get suspicious so I restarted my computer (yes I
too can't believe after installing oracle client that I didn't restart
immediately). After the restart odbc magically worked and so did straight
oracle.

So the high-level installation instructions for using mod_dbd with oracle on
Windows are:
1. Install Apache 2.2.9 or later (I was successful with 2.2.11)
2. Install Oracle Client (I did full with sqlplus support but the docs say
Oracle Instant Client is enough)
3. RESTART
3. Configure mod_dbd as follows (which is basically the example from 
http://httpd.apache.org/docs/2.2/mod/mod_authn_dbd.html the docs ):

# mod_dbd configuration
DBDriver oracle
DBDParams "server=<tnsnames entry> user=<user> pass=<password>"

DBDMin  4
DBDKeep 8
DBDMax  20
DBDExptime 300

<Directory "C:/Apache/Apache2.2/htdocs/private">
  # core authentication and mod_auth_basic configuration
  # for mod_authn_dbd
  AuthType Basic
  AuthName "My Server"
  AuthBasicProvider dbd

  # core authorization configuration
  Require valid-user

  # mod_authn_dbd SQL query to authenticate a user
  AuthDBDUserPWQuery /
    "SELECT password FROM acl_users WHERE username = %s"
</Directory>

Randy

-- 
View this message in context: http://www.nabble.com/mod_authn_dbd-mod_dbd-problem-with-oracle-tp21419910p21427309.html
Sent from the Apache HTTP Server - Users mailing list archive at Nabble.com.


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