[RADIATOR] Problem with Radiator connecting to remote oracle

[Hugh Irvine]

Hello Ghanim Al-Ghanim -

I am not sure what the problem is - can you please send me a copy of  
your configuration file?

It looks like there may be a problem with your DBSource/DBUsername/ 
DBAuth lines.

regards

Hugh


On 19 Aug 2008, at 19:31, Ghanim AL-Ghanim wrote:

> Hi,
>
>   I am trying to connect to a remote orcale for authntication but I  
> get the following
>
> <<<<<
> Tue Aug 19 05:48:20 2008: DEBUG: Adding Clients from SQL database
> Tue Aug 19 05:48:20 2008: DEBUG: Query is: 'select
>     NASIDENTIFIER,
>     SECRET,
>     IGNOREACCTSIGNATURE,
>     DUPINTERVAL,
>     DEFAULTREALM,
>     NASTYPE,
>     SNMPCOMMUNITY,
>     LIVINGSTONOFFS,
>     LIVINGSTONHOLE,
>     FRAMEDGROUPBASEADDRESS,
>     FRAMEDGROUPMAXPORTSPERCLASSC,
>     REWRITEUSERNAME,
>     NOIGNOREDUPLICATES,
>     PREHANDLERHOOK from RADCLIENTLIST':
> Tue Aug 19 05:48:20 2008: DEBUG: ClientListSQL adds Client x.x.x.x
> Tue Aug 19 05:48:20 2008: DEBUG: ClientListSQL adds Client x.x.x.x
> Tue Aug 19 05:48:20 2008: DEBUG: Finished reading configuration  
> file '/etc/radiator/radius.cfg'
> Tue Aug 19 05:48:20 2008: DEBUG: Reading dictionary file '/etc/ 
> radiator/dictionary'
> Tue Aug 19 05:48:20 2008: DEBUG: Creating authentication port  
> 0.0.0.0:1645
> Tue Aug 19 05:48:20 2008: DEBUG: Creating accounting port 0.0.0.0:1646
> Tue Aug 19 05:48:20 2008: NOTICE: Server started: Radiator 4.3 on G- 
> Rad
> Tue Aug 19 05:48:53 2008: DEBUG: Packet dump:
> *** Received from x.x.x.x port 59527 ....
>
> Packet length = 104
> 01 8f 00 68 72 2a 3e 65 73 c3 30 ed d4 57 00 a3
> ca 4f ff 98 01 06 64 75 6b 6f 06 06 00 00 00 02
> 04 06 c3 e2 ec 02 20 0e 32 30 33 2e 36 33 2e 31
> 35 34 2e 31 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 a4 e5 9b c1 ef 22 28 ba
> d4 13 ec 18 ea db 31 33
> Code:       Access-Request
> Identifier: 143
> Authentic:  r*>es<195>0<237><212>W<0><163><202>O<255><152>
> Attributes:
>     User-Name = "duko"
>     Service-Type = Framed-User
>     NAS-IP-Address = x.x.x.x
>     NAS-Identifier = "x.x.x.x"
>     NAS-Port = 1234
>     Called-Station-Id = "123456789"
>     Calling-Station-Id = "987654321"
>     NAS-Port-Type = Async
>     User-Password =  
> <164><229><155><193><239>"(<186><212><19><236><24><234><219>13
>
> Tue Aug 19 05:48:53 2008: DEBUG: Handling request with Handler 'NAS- 
> IP-Address = x.x.x.x'
> Tue Aug 19 05:48:53 2008: DEBUG:  Deleting session for duko,  
> x.x.x.x, 1234
> Tue Aug 19 05:48:53 2008: DEBUG: Handling with Radius::AuthPLSQL:
> Tue Aug 19 05:48:53 2008: DEBUG: Handling with Radius::AuthPLSQL:
> Tue Aug 19 05:48:53 2008: ERR: Could not connect to SQL database  
> with DBI->connect dbi:Oracle:qbill, qbill_auth, qabulhlti:
> Tue Aug 19 05:48:53 2008: ERR: Could not connect to any SQL  
> database. Request is ignored. Backing off for 600 seconds
> Tue Aug 19 05:48:53 2008: DEBUG: AuthBy PLSQL result: IGNORE, User  
> database access error
>
>
>
> -- 
> Regards,
> Ghanim Al-Ghanim
> Qualitynet System Administrator
> Office # +(965) 808888 extension 316
> mobile # +(965) 9389494
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.