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