Hi,
You may want to check ALL (ALL!) the column names you have defined in
radiator's config file to be sure that they match what you have in your REAL
database.
Also, make sure the column format supports what you intend to put into them.
>From my own experience:
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" <[EMAIL PROTECTED]>
To: "Dennis Methelev" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED]
> > To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
===
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.
