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 - [EMAIL PROTECTED] 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' 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 - [EMAIL PROTECTED] 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
