(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