(RADIATOR) accounting without authentication can't write data to postgres

[Dennis Methelev]

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.