(RADIATOR) weird Oracle behaviour
Hugh Irvine
hugh at open.com.au
Tue Oct 14 00:48:00 CDT 2003
Hello Andy -
I wonder if this is something to do with the DBI/DBD-Oracle versions
and/or installation?
You might want to try turning on some debug in DBI/DBD-Oracle and also
try executing the queries by hand to see if there are any problems.
regards
Hugh
On Monday, Oct 13, 2003, at 22:00 Australia/Melbourne, Andy De Petter
wrote:
>
> Hello all,
>
> I have somewhat weird behaviour, with Oracle SessionDatabase.
>
> I do a radpwtst:
>
> sending Access-Request...
> OK
> sending Accounting-Request Start...
> OK
> sending Accounting-Request Stop...
> No reply
>
> increased debugging on the account-request stop:
>
> =====
> sending Accounting-Request Stop...
> Packet dump:
> *** Sending to * port 1546 ....
>
> Code: Accounting-Request
> Identifier: 171
> Authentic: <0><0><0><0><0><0><0><0><0><0><0><0><0><0><0><0>
> Attributes:
> User-Name = "mytest"
> Service-Type = Framed-User
> NAS-IP-Address = *
> NAS-Port = 1234
> NAS-Port-Type = Async
> Acct-Session-Id = "00001234"
> Acct-Status-Type = Stop
> Called-Station-Id = "123456789"
> Calling-Station-Id = "987654321"
> Framed-IP-Address = 192.168.1.1
> Acct-Delay-Time = 0
> Acct-Session-Time = 10
> Acct-Input-Octets = 20000
> Acct-Output-Octets = 30000
>
> No reply
> =====
>
> and the log on server:
>
> =====
> Mon Oct 13 13:49:35 2003: DEBUG: Packet dump:
> *** Received from * port 35879 ....
>
> Code: Accounting-Request
> Identifier: 171
> Authentic: `<2><141><20>a<172><193><3><162><165><184>_>hf<15>
> Attributes:
> User-Name = "mytest"
> Service-Type = Framed-User
> NAS-IP-Address = *
> NAS-Port = 1234
> NAS-Port-Type = Async
> Acct-Session-Id = "00001234"
> Acct-Status-Type = Stop Called-Station-Id =
> "123456789"
> Calling-Station-Id = "987654321"
> Framed-IP-Address = 192.168.1.1
> Acct-Delay-Time = 0
> Acct-Session-Time = 10 Acct-Input-Octets =
> 20000
> Acct-Output-Octets = 30000
>
> Mon Oct 13 13:49:35 2003: DEBUG: Rewrote user name to mytest Mon Oct
> 13 13:49:35 2003: DEBUG: Handling request with Handler 'MyHandler'
> Mon Oct 13 13:49:35 2003: DEBUG: Rewrote user name to mytest
> Mon Oct 13 13:49:35 2003: DEBUG: SkynetOnline Deleting session for
> mytest, *, 1234
> Mon Oct 13 13:49:35 2003: DEBUG: do query is: 'BEGIN
> acct.del('mytest','* 1234'); END;':
> =====
>
> It seems to "freeze" on the DeleteQuery of the SessionDatabase,
> although on the accounting-request start, it does a DeleteQuery and
> AddQuery, as expected:
>
> Mon Oct 13 13:49:35 2003: DEBUG: do query is: 'BEGIN
> acct.del('mytest','* 1234'); END;':
> Mon Oct 13 13:49:35 2003: DEBUG: do query is: 'BEGIN acct.add(
> 'mytest', '*', '00001234', 1066045775, '192.168.1.1'
> , 'Async', 'Framed-User', '987654321', '987654321', '* 1234', '',
> 'Start'); END;':
>
> On the Oracle table, I can clearly see, that the ticket is being
> inserted correctly. Even for the accounting-stop, the ticket is
> deleted correctly aswell, although I get a No Reply back from > Radiator.
>
> Do you have any idea, on what may be causing this weird behaviour?
> The SQL statement ended successfully (as can be seen in the table),
> although Radiator apparantly thinks something went wrong somewhere..
>
> This is my config (SessionDatabase):
>
> <SessionDatabase SQL>
>
> Identifier SkynetOnline
>
> DBSource dbi:Oracle:MYTSN
> DBUsername radius
> DBAuth MYPASS
>
> DeleteQuery BEGIN \
> acct.del('%n','%N %{NAS-Port}'); \
> END;
> AddQuery BEGIN \
> acct.add( \
> '%n', \
> '%N', \
> '%{Acct-Session-Id}', \
> %{Timestamp}, \
> '%{Framed-IP-Address}', \
> '%{NAS-Port-Type}', \
> '%{Service-Type}', \
> '%{Calling-Station-Id}', \
> '%{Calling-Station-Id}', \
> '%N %{NAS-Port}', \
> '', \
> '%{Acct-Status-Type}'); \
> END;
>
> </SessionDatabase>
> Regards,
>
> -Andy
>
> --
> Andy De Petter - Expert IT Analyst - andy.de.petter at skybel.net
> Belgacom ANS/NTA/NST - Carlistraat 2 - 1140 Brussels (Belgium)
> Tel +32 (0)2 7061170 - Fax +32 (0)2 7061150 - ICQ #1548957
> "Cogito Ergo Sum - I think, therefore I am."
> -- R. Descartes
> *** DISCLAIMER ***
> This e-mail and any attachments thereto may contain information, which
> is confidential and/or protected by intellectual property rights and
> are intended for the sole use of the recipient(s) named above. Any use
> of the information contained herein (including, but not limited to,
> total or partial reproduction, communication or distribution in any
> form) by persons other than the designated recipient(s) is prohibited.
> If you have received this e-mail in error, please notify the sender
> either by telephone or by e-mail and delete the material from any
> computer. Thank you for your cooperation.
>
>
> ===
> 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, 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.
More information about the radiator
mailing list