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