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.
