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 = 206.28.213.250
NAS-Port = 20
NAS-Port-Type = ISDN
Acct-Status-Type = Start
Acct-Authentic = None
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 208.148.112.193
Acct-Delay-Time = 392
SQL Statement: UPDATE CallsOnline Set Username='pdi',AcctStatusType=1,
CallDate=GetDate(), FramedAddress='208.148.112.193' WHERE
NASIdentifier='206.28.213.250' 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
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 http://www.garden.net
Lucent RABU & Software.Com Post.Office VAR