(RADIATOR) weird Oracle behaviour
Andy De Petter
adepette at skybel.net
Tue Oct 14 01:38:03 CDT 2003
Hey Hugh,
After doing some more debugging, it seems that all db operations exit
successfully. I don't have any clue whatsoever, on why Radiator gives
me a no reply, even though he did his db operations properly.. ;-/
-Andy
Hugh Irvine wrote:
>
> 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?
>
--
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.
More information about the radiator
mailing list