[Emerald Digest]
emerald-digest-request@iea-software.com
Tue, 2 Jun 1998 00:00:44 -0700
Message 1: server ports
from iml@interconnect.net
Message 2: Hmmm
from "Richard Sensale" <richards@visitus.net>
Message 3: Re: Hmmm
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 4: Problem with IIS Ieak setup provided in list earlier.
from dannydp@greennet.net (Danny Della Paolera)
Message 5: Billing Problems
from "Greg Keys" <greg@loclnet.com>
Message 6: Re: Hmmm
from "Richard Sensale" <richards@visitus.net>
Message 7: How soon till Emerald 2.5 Release ?
from "Kurt Schafer" <kahuna@cyberbeach.net>
Message 8: Call Consolidation
from "Bill Bongiorno" <bill@systec.com>
Message 9: RadiusNT 2.5 Problems
from "Robert H. Clugston" <robert@csnsys.com>
Message 10: RE: RadiusNT 2.5 Problems
from "Robert H. Clugston" <robert@csnsys.com>
Message 11: RE: Error Adding accounts
from "Robert H. Clugston" <robert@csnsys.com>
Message 12: Radius 2.5 Docs
from "Robert H. Clugston" <robert@csnsys.com>
Message 13: Re: How soon till Emerald 2.5 Release ?
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 14: Re: Radius 2.5 Docs
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 15: RE: Radius 2.5 Docs
from "Robert H. Clugston" <robert@csnsys.com>
Message 16: Re: Radius 2.5 Docs
from dannydp@greennet.net (Danny Della Paolera)
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: server ports
From: iml@interconnect.net
Date: Mon, 01 Jun 1998 11:10:24 -0500
Hey Dale I see this mentioned in the 2.5 Radius list
* New advanced Server/Port Access controls, including time of day
restrictions.
I sent message earlier about setting port types you mentioned in 2.5
(i.e. ISDN and analog users)
By the docs in Chapter 9 I assume this is the DNIS function?
Also, how do you work with the time of day restrictions? I didn't see
any mention in the docs about time of day restrictions. Will all this
work with Emerald we have been wanting to offer a daytime only account
for sometime now.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Hmmm
From: "Richard Sensale" <richards@visitus.net>
Date: Mon, 1 Jun 1998 12:34:06 -0700
After having some major problems with reports producing a lot of erroneous
data, I tried to run a check database from the administrator and got a
fields.rpt file not found error? What causes this? I can't do batch
invoicing, all I get is a single blank invoice after creating a batch and
trying to print it, although it does look like it is processing more than
one invoice. Also my account.rpt file is acting strangely. For instance it
is messing up address data for users. I get oen address at the top of the
page and each of the services has different and incorrect data.
Richard Sensale
Network Administrator
VisitUs Internet, Inc.
5468 Schaefer Road
Dearborn, MI 48126 USA
(313) 945-5588
(313) 945-0202 fax
http://www.visitus.net
richards@visitus.net
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Hmmm
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Mon, 01 Jun 1998 11:01:48 -0700
Richard Sensale wrote:
>
> After having some major problems with reports producing a lot of erroneous
Did you upgrade to CR 6.0 when the problem started happening? I
put a CR 6.0 happy invoice.rpt in the /emerald/reports/cr60 directory.
It seems that CR 6.0 has some major incompatability problems with
5.0 and lower reports.
> data, I tried to run a check database from the administrator and got a
> fields.rpt file not found error? What causes this? I can't do batch
Ignore the Check database in the admin of 2.2 and lower.
> invoicing, all I get is a single blank invoice after creating a batch and
> trying to print it, although it does look like it is processing more than
Make sure the date in the box is todays date, NOT the date you had when
you batched the invoices. That is most likely the reason why you are
getting a blank invoice.
> one invoice. Also my account.rpt file is acting strangely. For instance it
> is messing up address data for users. I get oen address at the top of the
> page and each of the services has different and incorrect data.
This is the CR 6.0 problem when runnign CR 5.0 or 4.5 reports. I've
reported this to SS, and we have had about 10 customers so far report
the same problem. Its very frustrating to say the least. I've tried
to convert and corretc the 5.0 reports and start putting them in
the 6.0 directory.
BTW, the problem with 6.0 is that it doesn't link the tables (or
the WHERE clauses is missing completely). Therefore you get the results
of all records in each table against all other records of all other
tables, which is usually over several million records and something
usually gets filled or blows up. :)
-- 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 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Problem with IIS Ieak setup provided in list earlier.From: dannydp@greennet.net (Danny Della Paolera)Date: Mon, 1 Jun 1998 14:21:09 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_001C_01BD8D68.85720800Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
Hello All, I've setup the IIS instalation that Josh Perry sent out on the list =a long time ago on a Oreilly Website server. I've got all the files in =the correct areas and that newuser.exe loads up fine but it won't get =past the first HTML file. It displays the file, I choose to setup a new =account with a credit card..., and click on next. It then brings the =page back up again to me.=20=20
------=_NextPart_000_001C_01BD8D68.85720800Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
Hello All,
I've setup the =IIS=20instalation that Josh Perry sent out on the list a long time ago on a =Oreilly=20Website server. I've got all the files in the correct areas and that =newuser.exe=20loads up fine but it won't get past the first HTML file. It displays the =file, I=20choose to setup a new account with a credit card..., and click on next. =It then=20brings the page back up again to me.
------=_NextPart_000_001C_01BD8D68.85720800--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Billing ProblemsFrom: "Greg Keys" Date: Mon, 1 Jun 1998 14:20:50 -0400I have approx 300 Credit Card customers who are PaidThru 6/1/98 andMaExpireDate on 6/1/98 with a Limit of 10Trying to batch them today (6/1/98) and they will NOT invoice........Help???????Gregory E. KeysSystem AdministratorLoclNet (A Division of ESC Inc.)Electro-data Systems Company Inc.Voice: (704)861-1251Fax: (704)861-1870E-Mail: greg@loclnet.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: HmmmFrom: "Richard Sensale" Date: Mon, 1 Jun 1998 14:19:39 -0700I'll grab the report. But the one I was using was the midified one youemailed me a few weeks back. It works okay if I do a single invoice print.It only messers up with batch printing.Im wondering if we may have a problem with our database.-----Original Message-----From: Dale E. Reed Jr. To: emerald@iea-software.com Date: Monday, June 01, 1998 5:59 AMSubject: Re: Hmmm>Richard Sensale wrote:>>>> After having some major problems with reports producing a lot oferroneous>>Did you upgrade to CR 6.0 when the problem started happening? I>put a CR 6.0 happy invoice.rpt in the /emerald/reports/cr60 directory.>It seems that CR 6.0 has some major incompatability problems with>5.0 and lower reports.>>> data, I tried to run a check database from the administrator and got a>> fields.rpt file not found error? What causes this? I can't do batch>>Ignore the Check database in the admin of 2.2 and lower.>>> invoicing, all I get is a single blank invoice after creating a batch and>> trying to print it, although it does look like it is processing more than>>Make sure the date in the box is todays date, NOT the date you had when>you batched the invoices. That is most likely the reason why you are>getting a blank invoice.>>> one invoice. Also my account.rpt file is acting strangely. For instanceit>> is messing up address data for users. I get oen address at the top ofthe>> page and each of the services has different and incorrect data.>>This is the CR 6.0 problem when runnign CR 5.0 or 4.5 reports. I've>reported this to SS, and we have had about 10 customers so far report>the same problem. Its very frustrating to say the least. I've tried>to convert and corretc the 5.0 reports and start putting them in>the 6.0 directory.>>BTW, the problem with 6.0 is that it doesn't link the tables (or>the WHERE clauses is missing completely). Therefore you get the results>of all records in each table against all other records of all other>tables, which is usually over several million records and something>usually gets filled or blows up. :)>>-->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 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: How soon till Emerald 2.5 Release ?From: "Kurt Schafer" Date: Mon, 1 Jun 1998 16:25:37 -0400This is a multi-part message in MIME format.------=_NextPart_000_0020_01BD8D79.E8F261C0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableMost of the beta reports seem really positive, and RadiusNT 2.5 is =finally on the shelves.Are we going to see Emerald 2.5 soon ? We've been plugging along with =2.2.x style versions for awhile now and would really like to move on to =2.5.=3D K------=_NextPart_000_0020_01BD8D79.E8F261C0Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableMost of the beta reports seem really =positive,=20and RadiusNT 2.5 is finally on the shelves.
Are we going to see Emerald 2.5 soon =? We've=20been plugging along with 2.2.x style versions for awhile now and would =really=20like to move on to 2.5.
=3D K
------=_NextPart_000_0020_01BD8D79.E8F261C0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Call ConsolidationFrom: "Bill Bongiorno" Date: Mon, 1 Jun 1998 17:42:42 -0400The instructions say to click BATCH then click CHARGES but the chargesbutton is greyed out. What are the correct instructions?Bill BongiornoSysTec Computer Associates, Inc...------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RadiusNT 2.5 ProblemsFrom: "Robert H. Clugston" Date: Mon, 1 Jun 1998 15:54:47 -0700Dear List, I put on Emerald 2.5 today and I am having some problems. I can't makechanges to the Radius defaults/attributes. My "PPP" service works fine, butmy "Free PPP" service does work at all. I had deleted the attributes forthis service (cause I had thought I had ran the update script duringinstallation, but I killed it before it was done.) I can't make changes withEmerald Administrator. HELP!!!!..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: RadiusNT 2.5 ProblemsFrom: "Robert H. Clugston" Date: Mon, 1 Jun 1998 16:09:35 -0700Sorry, I'm using 2.1.0 EA on NT4.0 SP3, SQL 6.5 SP3.-----Original Message-----From: emerald-request@iea-software.com[mailto:emerald-request@iea-software.com] On Behalf Of Robert H. ClugstonSent: Monday, June 01, 1998 3:55 PMTo: Emerald Mailing ListSubject: RadiusNT 2.5 ProblemsImportance: HighDear List, I put on Emerald 2.5 today and I am having some problems. I can't makechanges to the Radius defaults/attributes. My "PPP" service works fine, butmy "Free PPP" service does work at all. I had deleted the attributes forthis service (cause I had thought I had ran the update script duringinstallation, but I killed it before it was done.) I can't make changes withEmerald Administrator. HELP!!!!..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Error Adding accountsFrom: "Robert H. Clugston" Date: Mon, 1 Jun 1998 16:15:24 -0700The Error Message I'm getting is:SQL Server Error: 213 Insert Error: column name or number of suppliedvalue does not match table definationState=4 Severity =16-----Original Message-----From: emerald-request@iea-software.com[mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.Sent: Saturday, May 30, 1998 11:16 PMTo: emerald@iea-software.comSubject: Re: Error Adding accountsRobert 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 problemsActually, 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 andIf you send me your DB Information and an example user who willnot bill, I'll show you why it will not.> 11) Options: 576512: 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 Callsand> 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..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Radius 2.5 DocsFrom: "Robert H. Clugston" Date: Mon, 1 Jun 1998 16:18:36 -0700Is it just me or is the radius docs.zip file a html file...------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: How soon till Emerald 2.5 Release ?From: "Dale E. Reed Jr." Date: Mon, 01 Jun 1998 16:23:04 -0700> Kurt Schafer wrote:> > Most of the beta reports seem really positive, and RadiusNT 2.5 is> finally on the shelves.> > Are we going to see Emerald 2.5 soon ? We've been plugging along with> 2.2.x style versions for awhile now and would really like to move on> to 2.5.Emerald 2.5 is being tested by quite a few people who opted torespond to the last inquiry we had. So far we have to keep it ina controlled manner, since if we opened it up, it would be a support nightmare and give us a bad image (IOW, only 2.5% of the peoplewho would use 2.5 in an open beta would actually read the docs first).-- 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 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Radius 2.5 DocsFrom: "Dale E. Reed Jr." Date: Mon, 01 Jun 1998 16:43:55 -0700Robert H. Clugston wrote:> > Is it just me or is the radius docs.zip file a html file.Its just you. I just downloaded, extracted and checked it from anothermachine here and Word97 brought it up with all the layout correctly(which it wouldn't have done if it was an HTML file).-- 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 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Radius 2.5 DocsFrom: "Robert H. Clugston" Date: Mon, 1 Jun 1998 16:52:00 -0700Damn IE 4.1-----Original Message-----From: emerald-request@iea-software.com[mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.Sent: Monday, June 01, 1998 4:44 PMTo: emerald@iea-software.comSubject: Re: Radius 2.5 DocsRobert H. Clugston wrote:>> Is it just me or is the radius docs.zip file a html file.Its just you. I just downloaded, extracted and checked it from anothermachine here and Word97 brought it up with all the layout correctly(which it wouldn't have done if it was an HTML file).--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 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Radius 2.5 DocsFrom: dannydp@greennet.net (Danny Della Paolera)Date: Mon, 1 Jun 1998 21:16:54 -0400IE 4.1 replaces Wordpad with a IE 4.1 screenYou can run good old wordpad by goign to program files/accesories andfinding wordpd :-)-----Original Message-----From: Robert H. Clugston To: emerald@iea-software.com Date: Monday, June 01, 1998 7:48 PMSubject: RE: Radius 2.5 Docs>Damn IE 4.1>>-----Original Message----->From: emerald-request@iea-software.com>[mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.>Sent: Monday, June 01, 1998 4:44 PM>To: emerald@iea-software.com>Subject: Re: Radius 2.5 Docs>>Robert H. Clugston wrote:>>>> Is it just me or is the radius docs.zip file a html file.>>Its just you. I just downloaded, extracted and checked it from another>machine here and Word97 brought it up with all the layout correctly>(which it wouldn't have done if it was an HTML file).>>-->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>>