Hi all,
I've been using DBI::Proxy with DES encryption to connect a bastion host
web server
through a firewall to some internal Oracle DBs. All has been well for a
couple of years
with a mix of Oracle 8.0.5 and 8.1.5 on their side and DBI 1.14 and
DBD:Oracle 1.06
on mine. Over the holiday they decided to upgrade to 9i without telling
anyone.
Probably needless to say but, everything broke. So...
First Step:
Changed tnsnames.ora from "SID=MYSID" to "SERVICE_NAME=MYSID.MYDOMAIN.COM"
on the firewall/proxy.
Second Step:
From the command line typed "sqlplus myuser@thatdb".
Gave it my password when prompted and successfully logged into "Oracle9i
Release 9.2.0.1.0"
I then tried one of the web apps that connect through DBI::Proxy, same
user/password... No joy.
The error log on the firewall/proxy says "Error while connecting to
DBI:Oracle:thatdb as myuser:
DBI::ProxyServer->connect(thatdb) failed: ORA-01017: invalid
username/password; logon
denied (DBD ERROR: OCISessionBegine) at /usr/bin/dbiproxy line 22"
Step Three:
Downloaded and installed DBI 1.32 and DBD Oracle:1.09
and... Still no joy. Same error as before. I can still connect to the
8.1.5 db via DBI::Proxy
just fine. I can connect to the new 9i db with a couple of internal
machines that connect directly
without using DBI::Proxy. I can still connect with sqlplus from the
command line of the proxy
machine...
I would greatly appreciate any suggestions/solutions. In the mean time,
I'm going grab a
sqlplus login of the wire and compare it to an attempted login via
DBI::Proxy. Maybe I'll
find something at that level.
TIA,
-Bill
P.S. Web and firewall/proxy are Linux, 9i server is NT, 8i server is Linux.
DBD::Oracle on the firewall/proxy compiled with 8.1.5 libraries etc.
I can grab more detailed kernel and Perl version info as needed, but
I don't have it off the top of my head. Thanks again ;-)
