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

Fri May 2 00:31:49 CDT 2003

Hello Ian -

If you are wanting to connect via ODBC, I would expect that you should 
use the DBD-ODBC module together with a suitable ODBC driver. If on the 
other hand you want to use the Oracle libraries, you will first of all 
have to install them, then use the DBD-Oracle module.

I have copied this mail to Mike as he may have more to say.

BTW - the latest version of Radiator is 3.6.

regards

Hugh

On Friday, May 2, 2003, at 09:20 Australia/Melbourne, Ian Campbell 
wrote:

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

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

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