> >See the Attribute Idle-Timeout to 900 in the RadAtConfigs or
> >RadConfigs Table, appropraitely.
>
> I have tried adding the above, no luck.
> Account Type, RadAttributeID, Data, Value
> under RadAtConfigs I add PPP, 28, Idle-Timeout, 900
>
> And tried similer under RadConfigs Table.
>You may have some settings on your NAS that is overwriting this.
> Is there a way to log the Caller-ID and/or display it under CallsOnline.
>You can add fields to the Calls table that is the same as the
>attribute name, without the dashes.
>Are you reffierin to the On-Line tab in Emerald or the table
>in the database?
I am reffierin to the Table.
Got the CallerID in the Calls. Works Great, Thanks.
Still having that darn timeout problem. I checked every place that has NAS
and it is blank.
I am attaching some debug notes from the radius -x15
Eddie Wieder
eddiew@lvdi.net
--=====================_860094438==_
Content-Type: text/plain; charset="us-ascii"
Content-Disposition: attachment; filename="Debug.txt"
Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Radius2'...
Allocating ODBC Henv...
Allocating ODBC Connect...
Making ODBC Connection...
Allocating Statement...
SQL Statement: Select Name, RadAttributeID, Type From RadAttributes
SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv, RadAttribut
es ra Where rv.RadAttributeID = ra.RadAttributeId
odbc_read_client_info()
Allocating Statement...
SQL Statement: Select Server, IPAddress, Secret From Servers
Client:max2.points.net:208.210.222.3:shamr0k
Client:sql1.points.net:208.210.222.30:shamr0k
Allocating Statement...
Accounting Column 0: 'NASIdentifier'
Accounting Column 1: 'NASPort'
Accounting Column 2: 'AcctSessionID'
Accounting Column 3: 'AcctStatusType'
Accounting Column 4: 'CallDate'
Accounting Column 5: 'UserName'
Accounting Column 6: 'UserService'
Accounting Column 7: 'AcctDelayTime'
Accounting Column 8: 'AcctSessionTime'
Accounting Column 9: 'FramedProtocol'
Accounting Column 10: 'FramedAddress'
Accounting Column 11: 'AcctInputOctets'
Accounting Column 12: 'AcctOutputOctets'
Accounting Column 13: 'AcctTerminateCause'
Accounting Column 14: 'NASPortType'
Accounting Column 15: 'NASPortDNIS'
Accounting Column 16: 'CallerID'
Radius NT is ready to receive requests!
radrecv: Request from host d0d2de03 code=1, id=5, length=96
User-Name = "mattw"
Password = "\003\252\244R\226\264\006"
NAS-Identifier = 208.210.222.3
NAS-Port = 20101
User-Service = Framed-User
Framed-Protocol = PPP
State = ""
Caller-Id = "7024366745"
NAS-Port-DNIS = "3146245"
Framed-Address = 208.210.222.81
Acct-Session-Id = "521"
rad_authenticate_ODBC()
Password = "\003\252\244R\226\264\006"
Decrypted Password: mattw1
Allocating Statement...
SQL Statement: Select DateAdd(Day, ma.extension, maExpireDate), DateAdd(Day, sa
..extension, saExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='mattw' or sa.Sh
ell='mattw') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0
Database Password: mattw1
Freeing SQL Statement...
Allocating Statement...
SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=1
Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...
SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'
User-Service = Framed-User (2)
Framed-Protocol = PPP (1)
Idle-Timeout = 900 (900)
Freeing SQL Statement...
Sending Ack of id 5 to d0d2de03 (max2.points.net)
User-Service = Framed-User
Framed-Protocol = PPP
Idle-Timeout = 900
Response Time: 70
radrecv: Request from host d0d2de03 code=4, id=6, length=103
User-Name = "mattw"
NAS-Identifier = 208.210.222.3
NAS-Port = 20101
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "227154708"
Acct-Authentic = RADIUS
Caller-Id = "7024366745"
NAS-Port-DNIS = "3146245"
Framed-Protocol = PPP
Framed-Address = 208.210.222.82
Allocating Statement...
SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,CallerId,NASPortDNIS,FramedProtocol,Framed
Address) VALUES (GetDate(),'mattw','208.210.222.3',20101,1,0,'227154708','702436
6745','3146245',1,'208.210.222.82')
Freeing SQL Statement...
Sending Accounting Ack of id 6 to d0d2de03 (max2.points.net)
Response Time: 50
radrecv: Request from host d0d2de03 code=4, id=7, length=187
User-Name = "mattw"
NAS-Identifier = 208.210.222.3
NAS-Port = 20101
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "227154708"
Acct-Authentic = RADIUS
Acct-Session-Time = 9
Acct-Input-Octets = 3685
Acct-Output-Octets = 479
Acct-Input-Packets = 1467
Acct-Output-Packets = 22
Ascend-Disconnect-Cause = 100
Ascend-Connect-Progress = 60
Ascend-Data-Rate = 21600
Ascend-PreSession-Time = 23
Ascend-Pre-Input-Octets = 451
Ascend-Pre-Output-Octets = 412
Ascend-Pre-Input-Packets = 165
Ascend-Pre-Output-Packets = 16
Ascend-First-Dest = 208.210.222.30
Caller-Id = "7024366745"
NAS-Port-DNIS = "3146245"
Framed-Protocol = PPP
Framed-Address = 208.210.222.82
Allocating Statement...
SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,AcctSessionTime,AcctInputOctets,AcctOutput
Octets,CallerId,NASPortDNIS,FramedProtocol,FramedAddress) VALUES (GetDate(),'mat
tw','208.210.222.3',20101,2,0,'227154708',9,3685,479,'7024366745','3146245',1,'2
08.210.222.82')
Freeing SQL Statement...
Sending Accounting Ack of id 7 to d0d2de03 (max2.points.net)
Response Time: 50
--=====================_860094438==_--