(RADIATOR) accounting without authentication can't write data to postgres
Hugh Irvine
hugh at open.com.au
Thu Jan 23 04:07:05 CST 2003
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.
More information about the radiator
mailing list