No subject
Tue Jun 24 01:21:20 CDT 2008
I had a column called TIME in an Oracle table and defined the same column in
one of
my AuthBy SQL sections. Later I decided the proper name for the column
should be
SESSIONTIME, so I changed it in the radius config file but forgot to alter
the actual
Oracle table's definition.
I then discovered that radiator wasn't logging my accounting records - to
make matters
worse, radiator was logging accounting-start records which does not containg
a value
for the Acct-Session-Time attribute which is what I intended to put in the
SESSIONTIME
column! But no accounting-stop records were being logged - strange eh? One
would have
thought the SQL statement would fail altogether !
Regards,
Tunde Itayemi.
----- Original Message -----
From: "Hugh Irvine" <hugh at open.com.au>
To: "Dennis Methelev" <dennis at gw.intertelecom.ru>
Cc: <radiator at open.com.au>
Sent: Thursday, January 23, 2003 11:07 AM
Subject: Re: (RADIATOR) accounting without authentication can't write data
to postgres
>
> Hello Dennis -
>
> Thanks for sending the configuration file and the debug trace.
>
> It looks to me like there is an error occuring with your SQL server due
> to the contents of the attributes you are trying to record.
>
> You should check the SQL server log to see what is happening.
>
> regards
>
> Hugh
>
>
> On Wednesday, Jan 22, 2003, at 20:23 Australia/Melbourne, Dennis
> Methelev wrote:
>
> > hi, all!
> >
> > my radiator can't record accounting requests to postgres database.
> > in <Authby SQL> AuthSelect sets without 'select' statement (as seen
> > in reference) - authentication not need.
> > please help.
> >
> > radiator 3.5 (test use)
> >
> > [config fragment]
> >
> > <AuthBy SQL>
> > Identifier SQLVOIPACCOUNTING
> > DBSource dbi:Pg:dbname=radius
> > DBUsername ***
> > DBAuth ***
> >
> > AuthSelect
> >
> > AccountingTable VOIPACCOUNTING
> > #AccountingStopsOnly
> > AcctColumnDef USERNAME,User-Name
> > AcctColumnDef TIME_STAMP,Timestamp,integer
> > AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> > AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
> > AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
> > AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
> > AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
> > AcctColumnDef ACCTINPUTPACKETS,Acct-Input-Packets,integer
> > AcctColumnDef ACCTOUTPUTPACKETS,Acct-Output-Packets,integer
> > AcctColumnDef ACCTSESSIONID,Acct-Session-Id
> > AcctColumnDef NASIDENTIFIER,NAS-IP-Address
> > AcctColumnDef NASPORT,Cisco-NAS-Port
> > AcctColumnDef DNIS,Called-Station-Id
> > AcctColumnDef CLID,Calling-Station-Id
> > </AuthBy>
> >
> > <SessionDatabase SQL>
> > Identifier SDBVOIP
> > DBSource dbi:Pg:dbname=radius
> > DBUsername ***
> > DBAuth ***
> >
> > AddQuery insert into VOIPONLINE (USERNAME, NASIDENTIFIER, NASPORT, \
> > ACCTSESSIONID, \
> > TIME_STAMP) values ('%{User-Name}', '%N',
> > '%{Cisco-NAS-Port}', '%{Acct-Session-Id}',\
> > %{Timestamp} )
> > DeleteQuery delete from VOIPONLINE where USERNAME='%{User-Name}' and
> > NASPORT='%{Cisco-NAS-Port}'
> > </SessionDatabase>
> >
> > <Handler NAS-IP-Address=(myvoipdeviceip)>
> > AythBy SQLVOIPACCOUNTING
> > SessionDatabase SDBVOIP
> > </Handler>
> >
> > [log fragment]
> >
> > Wed Jan 22 13:12:58 2003: DEBUG: Packet dump:
> > *** Received from ...... port 1646 ....
> >
> > Packet length = 237
> > Code: Accounting-Request
> > Identifier: 37
> > Authentic:
> > <29><188><0><252>&<151><200><25><141>H<188><222><219><135><147><197>
> > Attributes:
> > NAS-IP-Address = ......
> > Cisco-NAS-Port = "CAS 1/0:1:17"
> > NAS-Port-Type = Async
> > User-Name = "22......"
> > Called-Station-Id = "23......"
> > Calling-Station-Id = "22......"
> > Acct-Status-Type = Start
> > Service-Type = Login-User
> > Acct-Session-Id = "36/13:12:43.141 SAMT Wed Jan 22
> > 2003/....../F039911C 78DA00C5 0 4F8450F/answer/Telephony/////F039911C
> > 78DA00C5 0 4F8450F"
> > Acct-Delay-Time = 15
> >
> > Wed Jan 22 13:12:58 2003: DEBUG: Handling request with Handler
> > 'NAS-IP-Address=......'
> > Wed Jan 22 13:12:58 2003: DEBUG: SDBVOIP Adding session for 22......,
> > ......, Wed Jan 22 13:12:58 2003: DEBUG: do query is: delete from
> > VOIPONLINE where USERNAME='22......' and NASPORT='CAS 1/0:1:17'
> >
> > Wed Jan 22 13:12:58 2003: DEBUG: do query is: insert into VOIPONLINE
> > (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP) values
> > ('22......', '......', 'CAS 1/0:1:17', '36/13:12:43.141 SAMT Wed Jan
> > 22 2003/....../F039911C 78DA00C5 0
> > 4F8450F/answer/Telephony/////F039911C 78DA00C5 0 4F8450F',1043226763 )
> >
> > Wed Jan 22 13:13:00 2003: DEBUG: Packet dump:
> > *** Received from ...... port 1646 ....
> >
> > Packet length = 528
> > Code: Accounting-Request
> > Identifier: 38
> > Authentic: T+<231><14>Y'<215><26>Jw<167>I<26><175>o<142>
> > Attributes:
> > NAS-IP-Address = ......
> > Cisco-NAS-Port = "CAS 1/0:1:17"
> > NAS-Port-Type = Async
> > User-Name = "22......"
> > Called-Station-Id = "23......"
> > Calling-Station-Id = "22......"
> > Acct-Status-Type = Stop
> > Service-Type = Login-User
> > Acct-Session-Id = "36/13:12:43.141 SAMT Wed Jan 22
> > 2003/....../F039911C 78DA00C5 0 4F8450F/answer/Telephony/13:12:43.175
> > SAMT Wed Jan 22 2003/13:12:45.405 SAMT Wed Jan 22 2003/10//F039911C
> > 78DA00C5 0 4F8450F"
> > Acct-Input-Octets = 0
> > Acct-Output-Octets = 0
> > Acct-Input-Packets = 0
> > Acct-Output-Packets = 0
> > Acct-Session-Time = 2
> > cisco-avpair = "subscriber=Unknown"
> > cisco-avpair = "h323-ivr-out=Tariff:Unknown"
> > cisco-avpair = "pre-bytes-in=0"
> > cisco-avpair = "pre-bytes-out=0"
> > cisco-avpair = "pre-paks-in=0"
> > cisco-avpair = "pre-paks-out=0"
> > cisco-avpair = "nas-rx-speed=0"
> > cisco-avpair = "nas-tx-speed=0"
> > Acct-Delay-Time = 15
> >
> > Wed Jan 22 13:13:00 2003: DEBUG: Handling request with Handler
> > 'NAS-IP-Address=......'
> > Wed Jan 22 13:13:00 2003: DEBUG: SDBVOIP Deleting session for
> > 22......, ......, Wed Jan 22 13:13:00 2003: DEBUG: do query is: delete
> > from VOIPONLINE where USERNAME='22......' and NASPORT='CAS 1/0:1:17'
> >
> >
> >
> > ===
> > 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.
> >
> >
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, 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.
===
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