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@xxxxxxxxxxxxxxxx
" from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|