Re: Error Adding accounts

Robert Boyle ( )
Sat, 30 May 1998 15:29:49 -0400

At 11:34 AM 5/30/98 -0700, you wrote:
>AS I have noted many times, do NOT use 2.2.42 unless you are
>directed to. 2.2.38 is the latest 2.2. for general use.

I understood that it fixed billing problems. We have been having problems
for quite a while now where invoices are not generated. We need to delete
the MBR and recreate it. Nothing else works. I KNOW that the expire and
paid through dates are correct and do not overlap any previous invoices. It
still says: No new invoices to create. I have been struggling with Radius
2.5. It looks like the latest build fixed the 100% CPU utilization that we
were seeing, but the other problem is still there. I send a message before
and I'll summarize again:

0) IgnoreCase: 1
1) Mode: 1
2) ODBCDatasource: Radius
3) Username: radius
4) Password: *************
5) CompanyName: Garden Networks
6) License: *****************
7) AllowMalformed: 1
8) AuthPort: 1645
9) UsersFile: Users
10) Proxy: 0
11) Options: 576
12) DataDirectory: c:\radius
13) AcctDirectory: c:\radius\acct
14) ReqAcctAuth: 0
15) AcctPort: 1646
16) Debug: 0
17) LogFile:
18) AcctODBCDatasource: ******
19) AcctUsername: ******
20) AcctPassword: ******

Param: Debug Level: 15
Param: ODBC Only Enabled
Initializing Winsock...
ODBC Datasource: 'Radius'...
Making ODBC Connection...
MS SQL Server Mode Enabled
ODBC Datasource: 'Radius'...
Making ODBC Connection...
MS SQL Server Mode Enabled
Allocating Statement...

Resp Time: 30 Auth: 0/0 -> 0 Acct: 1/0/0 -> 1
radrecv: Request from host ce1cd5fa code=4, id=149, length=89

Acct-Session-Id = "4A001462"
User-Name = "pdi"
NAS-Identifier =
NAS-Port = 20
NAS-Port-Type = ISDN
Acct-Status-Type = Start
Acct-Authentic = None
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address =
Acct-Delay-Time = 392

SQL Statement: UPDATE CallsOnline Set Username='pdi',AcctStatusType=1,
CallDate=GetDate(), FramedAddress='' WHERE
NASIdentifier='' and NASPort=20 AND (DateAdd(Second,
0-i.AcctDelayTime, i.CallDate) >= CallDate OR CallDate IS NULL)

ODBC Error:37000:107:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'i' does
not match with a table name or alias name used in the query.


What is this statement's i supposed to refer to? CallsOnline doesn't work
and the Calls table only gets new additions for the first 30-60 seconds
that RadiusNT is running. Any ideas? I have dropped and recreated Calls and
CallsOnline with the scripts included with the final 2.5 distribution. TIA!


Robert Boyle Server Co-location,
Garden Networks Internet Access,
50 Diller Ave Development & Consulting
Newton, NJ 07860 (973)300-9211 Ext.103
8AM-8PM Mon-Fri EST
Lucent RABU & Software.Com Post.Office VAR