Re: Problem with CallsOnline - not updating

Waldemar Born ( (no email) )
Tue, 30 Dec 1997 19:13:40 +0100

I included the whole authentication and accounting request. I have various
problems to get the Bricks running with radius. Authentication is ok, but
accounting is very bad. I had to change Acct-Link-Count attribute to
NAS-Port and removed the 'default 1' I added from the calls table. Now it
looks like the follwing. Info on my config: Emerald 2.1.11, RadiusNT 2.2,
Bianca/Brick-XS and
Brick-XL. This is the full request from the brick when one user logs in.

Resp Time: 329 Auth: 3/5 -> 8 Acct: 2/0/0 -> 2
radrecv: Request from host c0a80063 code=1, id=139, length=44
NAS-Identifier = "brick1"
Service-Type = Framed-User
Framed-Protocol = PPP
User-Name = "24"
rad_authenticate_ODBC()
Sending Reject of id 139 to c0a80063 (brick1.lip.net)
LOG: Authenticate: from brick1.lip.net - No Password

SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, UserName, Data)
VALUE
S (52, GetDate(), '24', 'brick1.lip.net')

Resp Time: 391 Auth: 3/6 -> 9 Acct: 2/0/0 -> 2
radrecv: Request from host c0a80063 code=1, id=140, length=67
NAS-Identifier = "brick1"
Service-Type = Framed-User
Framed-Protocol = PPP
User-Name = "WallyB"
Challenge-Response = "\001?\243\023\215\006\304+-`[v\177>\311)\204"
rad_authenticate_ODBC()
Challenge-Response = "\001?\243\023\215\006\304+-`[v\177>\311)\204"

SQL Statement: Select DateAdd(Day, (ma.extension + ma.overdue),
maExpireDate),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,
sa.Passw
ord, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa Where
(sa.Login=
'WallyB' or sa.Shell='WallyB') AND ma.CustomerID=sa.CustomerID and
sa.Active<>0
and ma.Active<>0

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

Loading radius defaults for this type...

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'

Service-Type = Framed-User (2)
Framed-Protocol = PPP (1)
Idle-Timeout = 3600 (3600)
Sending Ack of id 140 to c0a80063 (brick1.lip.net)
Service-Type = Framed-User
Framed-Protocol = PPP
Idle-Timeout = 3600

Resp Time: 937 Auth: 4/6 -> 10 Acct: 2/0/0 -> 2
radrecv: Request from host c0a80063 code=4, id=141, length=86
NAS-Identifier = "brick1"
Service-Type = Framed-User
Framed-Protocol = PPP
User-Name = "WallyB"
Acct-Status-Type = Start
Acct-Delay-Time = 0
NAS-Port = 1
Acct-Session-Id = "d4000023"
Acct-Multi-Session-Id = "d4000023"

SQL Statement: INSERT INTO Calls
(CallDate,NASIdentifier,FramedProtocol,UserNam
e,AcctStatusType,AcctDelayTime,NASPort,AcctSessionId) VALUES
(GetDate(),'brick1'
,1,'WallyB',1,0,1,'d4000023')

Incomplete accounting record. CallsOnline not updated
Sending Accounting Ack of id 141 to c0a80063 (brick1.lip.net)

Resp Time: 547 Auth: 4/6 -> 10 Acct: 3/0/0 -> 3

-----Original Message-----
From: Dale E. Reed Jr. <daler@iea.com>
To: emerald@emerald.iea.com <emerald@emerald.iea.com>
Date: Dienstag, 30. Dezember 1997 18:42
Subject: Re: Problem with CallsOnline - not updating

>NAS-Port is a required field for CallsOnline to work properly.
>Since you NAS is not returning this, RadiusNT can not track
>users online. I'm guessing you probably either do not have
>or removed the primary key, since it did not return an error
>on the insert statement.
>
>--
>Dale E. Reed Jr. (daler@iea.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>