[RADIATOR] Problem with Radiator connecting to remote oracle

Ghanim AL-Ghanim eternalblade at gmail.com
Tue Aug 19 05:01:51 CDT 2008


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20080819/4960ae85/attachment-0001.html>


More information about the radiator mailing list