(RADIATOR) weird Oracle behaviour

[Andy De Petter]

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.