Message 2: Re: Error Adding accounts
from "Mohammed Ersan" <ersan@first.net.jo>
Message 3: Re: Error Adding accounts
from Robert Boyle <robert@garden.net>
Message 4: Re: Error Adding accounts
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 5: Re: Error Adding accounts
from Robert Boyle <robert@garden.net>
Message 6: Re: Error Adding accounts
from "Dale E. Reed Jr." <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: [data] [data] ANNOUNCEMENT: RadiusNT 2.5 Releases
From: Sheryl Stover <sds@iea-software.com>
Date: Fri, 29 May 1998 18:34:52 -0700 (PDT)
INTRODUCING RADIUSNT 2.5!
IEA Software is proud to announce the official release of RadiusNT
Version 2.5. In addition to the RadiusNT Standard, we are also
pleased to introduce RadiusNT ENTERPRISE Edition.
All editions of RadiusNT 2.5 include the following new enhancements:
* Dual thread design separates authentication and accounting
processes, improving performance.
* Debugging information can be logged to a file while RadiusNT is
running as a service under Windows NT.
* Spaces can be trimmed from both the front and rear of user names for
authentication and accounting.
* Trims a "domain\" entry from DUN authentication attempts against a
users file, or
* When authenticating against the NT SAM, uses the "domain\" section
to find the correct domain in which to authenticate.
* RadiusNT Administrator's users and clients file editing options have
been added.
* Promiscuous mode has been added to allow requests from any client
with the correct global secret.
* Documentation has been updated to include common problems and
frequently asked questions.
The following ODBC features have been enhanced:
* Separate ODBC DSN settings are allowed for the authentication and
accounting threads (as well as debug log files).
* New advanced Server/Port Access controls, including time of day
restrictions.
* ODBC Support for Sybase and Oracle SQL databases has been added.
* DNIS based authentication restrictions.
* Now supports the use of stored procedures with SQL Server for
enhanced flexibility and more configuration of database behavior.
* Improved Manual Update for Concurrency control for out of order
accounting packets.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Error Adding accounts
From: "Mohammed Ersan" <ersan@first.net.jo>
Date: Sat, 30 May 1998 17:51:30 +0300
same thing for me
At 03:58 PM 05/29/98 -0400, you wrote:
>I have just encountered an error when adding a new account into Emerald..
>
>It says SQL error adding main account
>
>I can change existing accounts but can't add a new one.. I have plenty of
>MBR's left so I need to know where to look for the problem here..
>
>Using 2.2.42 client
>
>
<center>M. Ersan
ersan@first.net.jo
firstnet
</center>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Error Adding accounts
From: Robert Boyle <robert@garden.net>
Date: Sat, 30 May 1998 13:19:56 -0400
At 05:51 PM 5/30/98 +0300, you wrote:
>
> same thing for me
>
>
> At 03:58 PM 05/29/98 -0400, you wrote:
> >I have just encountered an error when adding a new account into Emerald..
> >
> >It says SQL error adding main account
> >
> >I can change existing accounts but can't add a new one.. I have plenty of
> >MBR's left so I need to know where to look for the problem here..
> >
> >Using 2.2.42 client
Same here. .42 just doesn't work to add new MBR's.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Error Adding accounts
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Sat, 30 May 1998 11:34:27 -0700
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.
Robert Boyle wrote:
>
> At 05:51 PM 5/30/98 +0300, you wrote:
> >
> > same thing for me
> >
> >
> > At 03:58 PM 05/29/98 -0400, you wrote:
> > >I have just encountered an error when adding a new account into Emerald..
> > >
> > >It says SQL error adding main account
> > >
> > >I can change existing accounts but can't add a new one.. I have plenty of
> > >MBR's left so I need to know where to look for the problem here..
> > >
> > >Using 2.2.42 client
>
> Same here. .42 just doesn't work to add new MBR's.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Error Adding accountsFrom: Robert Boyle <robert@garden.net>Date: 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 problemsfor quite a while now where invoices are not generated. We need to deletethe MBR and recreate it. Nothing else works. I KNOW that the expire andpaid through dates are correct and do not overlap any previous invoices. Itstill says: No new invoices to create. I have been struggling with Radius2.5. It looks like the latest build fixed the 100% CPU utilization that wewere seeing, but the other problem is still there. I send a message beforeand I'll summarize again:
0) IgnoreCase: 11) Mode: 12) ODBCDatasource: Radius3) Username: radius4) Password: *************5) CompanyName: Garden Networks6) License: *****************7) AllowMalformed: 18) AuthPort: 16459) UsersFile: Users10) Proxy: 011) Options: 57612) DataDirectory: c:\radius13) AcctDirectory: c:\radius\acct14) ReqAcctAuth: 015) AcctPort: 164616) Debug: 017) LogFile: 18) AcctODBCDatasource: ******19) AcctUsername: ******20) AcctPassword: ******
Param: Debug Level: 15Param: ODBC Only EnabledInitializing Winsock...ODBC Datasource: 'Radius'...Making ODBC Connection...MS SQL Server Mode EnabledODBC Datasource: 'Radius'...Making ODBC Connection...MS SQL Server Mode EnabledAllocating Statement...
Resp Time: 30 Auth: 0/0 -> 0 Acct: 1/0/0 -> 1radrecv: 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' WHERENASIdentifier='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' doesnot 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 workand the Calls table only gets new additions for the first 30-60 secondsthat RadiusNT is running. Any ideas? I have dropped and recreated Calls andCallsOnline 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 & ConsultingNewton, NJ 07860 (973)300-9211 Ext.1038AM-8PM Mon-Fri EST http://www.garden.netLucent RABU & Software.Com Post.Office VAR
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Error Adding accountsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Sat, 30 May 1998 23:15:48 -0700
Robert Boyle wrote:> > 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
Actually, it fixed ONE billing problem, which was applying payments.If you are not having problems applying payments, don't use 2.2.42.
> 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
If you send me your DB Information and an example user who willnot bill, I'll show you why it will not.
> 11) Options: 576
512: Stop Records Only64: Variable Login Limits
> 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!
This was corrected in 2.5.116 and higher (2.5.120 is the distributionavailable right now). If you turn off the Stop records only, it willwork until you update the executable.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com