I have problems with RadiusNT inserting records in Oracle's "CALLS" table,
AcctSessionId and Username is not inserted in the database, but other fields
is (se below),
Dale could it be a bug in the program ?
Other information is loaded OK from Oracle (161 Dictionary Attributes
Loaded...)
I hope this information will help
Regards
Flemming Eriksen
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
C:\radius>radius -x15
RadiusNT 2.5.175 Copyright (c) 1995-1998 IEA Software, Inc.
All Rights Reserved, Worldwide
Some portions Copyright (c) 1992 Livingston Enterprises, Inc.
and Copyright (c) 1995 Ascend Communications, Inc.
0) IgnoreCase: 0
1) TrimName: 0
2) ReqAcctAuth: 0
3) AllowMalformed: 0
4) Mode: 1
5) Proxy: 0
6) Options: 0
7) SNMP: 0
8) Debug: 0
9) LogFile:
10) AcctLogFile:
11) ODBCDatasource: RadiusNT
12) Username: fe
13) Password: radius
14) AcctODBCDatasource:
15) AcctUsername:
16) AcctPassword:
17) TestDatabaseSecs:
18) DataDirectory: c:\radius\users\
19) AcctDirectory: c:\radius\acct\
20) UsersFile: empty.txt
21) CompanyName: --------------------------------------
22) License: ------------------------------------------------
23) IPAddress: All
24) AuthPort: 1645
25) AcctPort: 1646
26) EncryptPasswords: 0
Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'RadiusNT'...
Making ODBC Connection...
Oracle RDBMS Mode Enabled
SQL Statement: Select DISTINCT Company, LicenseID From Licenses
ODBC Datasource: 'RadiusNT'...
Making ODBC Connection...
Oracle RDBMS Mode Enabled
SQL Statement: Select DISTINCT Company, LicenseID From Licenses
Allocating Statement...
SQL Statement: Select Name, RadAttributeID, Type, RadVendorID,
RadVendorType From RadAttributes Order By RadVendorID, R
adAttributeID
SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv,
RadAttributes ra Where rv.RadAttributeID = ra.RadAt
tributeID
56 Dictionary Attributes Loaded...
SQL Statement: Select Server, IPAddress, Secret From Servers
3 Clients Loaded
0 Accounting Columns Loaded
RadiusNT 2.5.175 Standard Initialized...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
radrecv: Request from host c026e33a code=1, id=85, length=90
NAS-IDENTIFIER = 192.38.227.58
NAS-PORT = 20000
NAS-PORT-TYPE = ISDN
USER-NAME = "FE"
NAS-PORT-DNIS = "16222"
CALLER-ID = "76960190"
CHALLENGE-RESPONSE = "\027i]'ho\211v8\0114}7\215\217E\350"
USER-SERVICE = FRAMED-USER
FRAMED-PROTOCOL = PPP
rad_authenticate_ODBC()
SQL Statement: Select maExpireDate+ma.Extension+1,
saExpireDate+sa.Extension+1, sa.AccountID, sa.AccountType, sa.Passwo
rd, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa Where
sa.Login='FE' AND ma.CustomerID=sa.CustomerID and
sa.Active<>0 and ma.Active<>0
SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type,
rc.RadVendorID, rc.RadVendorType, rc.RadCheck From Ra
dConfigs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND
rc.AccountID=1000
SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type,
rc.RadVendorID, rc.RadVendorType, rc.RadCheck From Ra
dATConfigs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID
AND rc.AccountType='PPP'
Sending Ack of id 85 to c026e33a (POP2)
USER-SERVICE = FRAMED-USER
FRAMED-PROTOCOL = PPP
FRAMED-COMPRESSION = VAN-JACOBSEN-TCP-IP
Resp Time: 300 Auth: 1/0 -> 1 Acct: 0/0/0 -> 0
radrecv: Request from host c026e33a code=4, id=86, length=99
NAS-IDENTIFIER = 192.38.227.58
NAS-PORT = 20000
NAS-PORT-TYPE = ISDN
USER-NAME = "FE"
NAS-PORT-DNIS = "16222"
CALLER-ID = "76960190"
ACCT-STATUS-TYPE = START
ACCT-AUTHENTIC = RADIUS
USER-SERVICE = FRAMED-USER
ACCT-SESSION-ID = "00000015"
FRAMED-PROTOCOL = PPP
ACCT-DELAY-TIME = 0
SQL Statement: INSERT INTO Calls
(CallDate,NASIDENTIFIER,NASPORT,NASPORTTYPE,USERNAME,NASPORTDNIS,CALLERID,AC
CTSTATUSTY
PE,ACCTAUTHENTIC,USERSERVICE,ACCTSESSIONID,FRAMEDPROTOCOL,ACCTDELAYTIME)
VALUES (sysdate,'192.38.227.58',20000,2,'','','
',1,1,2,'',1,0)
Sending Accounting Ack of id 86 to c026e33a (POP2)
Resp Time: 181 Auth: 1/0 -> 1 Acct: 1/0/0 -> 1
radrecv: Request from host c026e33a code=4, id=87, length=151
NAS-IDENTIFIER = 192.38.227.58
NAS-PORT = 20000
NAS-PORT-TYPE = ISDN
USER-NAME = "FE"
NAS-PORT-DNIS = "16222"
CALLER-ID = "76960190"
ACCT-STATUS-TYPE = STOP
ACCT-AUTHENTIC = RADIUS
USER-SERVICE = FRAMED-USER
ACCT-SESSION-ID = "00000015"
FRAMED-PROTOCOL = PPP
ACCT-LINK-COUNT = 1
ACCT-MULTI-SESSION-ID = "8"
FRAMED-ADDRESS = 192.168.32.10
ACCT-TERMINATE-CAUSE = HOST-REQUEST
ACCT-INPUT-OCTETS = 454
ACCT-OUTPUT-OCTETS = 454
ACCT-INPUT-PACKETS = 13
ACCT-OUTPUT-PACKETS = 13
ACCT-SESSION-TIME = 21
ACCT-DELAY-TIME = 0
SQL Statement: INSERT INTO Calls
(CallDate,NASIDENTIFIER,NASPORT,NASPORTTYPE,USERNAME,NASPORTDNIS,CALLERID,AC
CTSTATUSTY
PE,ACCTAUTHENTIC,USERSERVICE,ACCTSESSIONID,FRAMEDPROTOCOL,ACCTLINKCOUNT,ACCT
MULTISESSIONID,FRAMEDADDRESS,ACCTTERMINATECA
USE,ACCTINPUTOCTETS,ACCTOUTPUTOCTETS,ACCTINPUTPACKETS,ACCTOUTPUTPACKETS,ACCT
SESSIONTIME,ACCTDELAYTIME) VALUES (sysdate,'
192.38.227.58',20000,2,'','','',2,1,2,'',1,1,'','192.168.32.10',18,454,454,1
3,13,21,0)
Sending Accounting Ack of id 87 to c026e33a (POP2)
Resp Time: 270 Auth: 1/0 -> 1 Acct: 2/0/0 -> 2
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --
- - - - -
CREATE TABLE Calls (
NASIdentifier varchar2(16)
,NASPort int DEFAULT(-1)
,AcctSessionID varchar2(10)
,AcctStatusType number(1)
,CallDate date
,UserName varchar2(32)
,AcctDelayTime int default(0) NULL
,AcctSessionTime int default(0) NULL
,FramedAddress varchar2(16) NULL
,AcctTerminateCause number(1) NULL
,FramedProtocol int NULL
,AcctAuthentic number(1) NULL
,UserService number(1) NULL
,AcctInputOctets int NULL
,AcctOutputOctets int NULL
,AcctInputPackets int NULL
,AcctOutputPackets int NULL
,NASPortType number(1) NULL
,CallerId varchar2(20) NULL
,NasPortDNIS varchar2(40) NULL
,AcctMultiSessionID varchar2(10)
,AcctlinkCount number(4)
);