(RADIATOR) DBI Oracle can't connect to any Database

[Ian Campbell]

I have a very frustrating problem with my Radiator installation.

Radiator is configured to authenticate from an Oracle database, but it 
responds with an error 

ERR: Could not connect to SQL database with DBI->connect dbi:Oracle:PROXY,  
PROXY_USR, PROXY_PWD:

(trace level 5 logfile is included below)

There are two things that are strange about this:

(i)  I can connect to the database successfully via ODBC from this server

# /opt/oracle/bin/sqlplus PROXY_USR/PROXY_PWD at PROXY

SQL*Plus: Release 9.0.1.0.0 - Production on Fri May 2 11:08:58 2003

(c) Copyright 2001 Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL>

...from there, I can even run the "AuthBy" query successfully.

(ii) I've run a tcpdump on port 1521 and RADIUS isn't even sending out a 
single packet before deciding that "I can't connect to any Databases".  


Now, this "setup" is working in a production environment, and the 
radius.cfg file is identical to the working copy other than the Oracle 
Instance name (PROXY)


...any ideas would be greatly appreciated.

...also - the mikem/fred user still exists in the userfile and 
authenticates successfully.  FWIW.

Kind Regards,
Ian.

Here's the logfile...  It shows the RADIUS server starting, and responding 
to a single Access request generated via "radpwtst" on the local host.

Fri May  2 11:01:06 2003: DEBUG: Reading users file /etc/radiator/users
Fri May  2 11:01:06 2003: INFO: Server started: Radiator 2.19 on devradius
Fri May  2 11:01:14 2003: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 32769 ....

Packet length = 94
01 d1 00 5e 31 32 33 34 35 36 37 38 39 30 31 32
33 34 35 36 01 0a 31 30 36 33 34 32 31 30 06 06
00 00 00 02 04 06 cb 3f 9a 01 05 06 00 00 04 d2
1e 0b 31 32 33 34 35 36 37 38 39 1f 0b 39 38 37
36 35 34 33 32 31 3d 06 00 00 00 00 02 12 b3 70
fd 91 a3 c5 de 02 b5 a6 63 e9 13 43 5b ac
Code:       Access-Request
Identifier: 209
Authentic:  1234567890123456
Attributes:
        User-Name = "10634210"
        Service-Type = Framed-User
        NAS-IP-Address = 203.63.154.1
        NAS-Port = 1234
        Called-Station-Id = "123456789"
        Calling-Station-Id = "987654321"
        NAS-Port-Type = Async
        User-Password = 
"<179>p<253><145><163><197><222><2><181><166>c<233><19>C[<172>"

Fri May  2 11:01:14 2003: DEBUG: Handling request with Handler 
'Realm=DEFAULT'
Fri May  2 11:01:14 2003: DEBUG:  Deleting session for 10634210, 
203.63.154.1, 1234
Fri May  2 11:01:14 2003: DEBUG: Handling with Radius::AuthFILE:
Fri May  2 11:01:14 2003: DEBUG: Radius::AuthFILE looks for match with 
10634210
Fri May  2 11:01:14 2003: DEBUG: Handling with Radius::AuthSQL
Fri May  2 11:01:14 2003: DEBUG: Handling with Radius::AuthSQL:
Fri May  2 11:01:14 2003: ERR: Could not connect to SQL database with 
DBI->connect dbi:Oracle:PROXY, PROXY_USR, PROXY_PWD:
Fri May  2 11:01:14 2003: ERR: Could not connect to any SQL database. 
Request is ignored. Backing off for 10 seconds


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.