Message 2: RE: New NAS
from "Brian Johnson" <brian@hdc.net>
Message 3: New NAS
from "Lamar Townsend" <lamar@shuttle.com>
Message 4: Adding charges.
from "Billy Huddleston" <billy@nxs.net>
Message 5: Re: Adding charges.
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 6: Re: Daily Maintence.
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 7: Terminate Cause
from "Pat Augustine" <ereth@ilnk.com>
Message 8: RE: Adding charges.
from "Billy Huddleston" <billy@nxs.net>
Message 9: Re: Adding charges.
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 10: Final Steps
from "Victor A." <victor@webjogger.net>
Message 11: Re: Daily Maintence.
from Jim Dunmyer <jdunmyer@toltbbs.com>
Message 12: Re: Terminate Cause
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 13: Re: Daily Maintence.
from "Dale E. Reed Jr." <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Daily Maintence.
From: Thomas Massano <ThomasM@InletCorp.com>
Date: Fri, 10 Jul 1998 08:12:40 -0400
I have a brand new installation up and running. I have the Master and
Emerald DB dump every night so I have a BU of it.
What else should i be doing? Are there scripts I should be running, any
maintenance?
Looking for your suggestions.
Thomas
..........................................................................
Inlet Corporation http:\\www.InletCorp.com
800-34-INLET
I am not one who was born in the possession of knowledge; I am one who is
fond of antiquity, and earnest in seeking it there.
Confucius 551-479 B.C.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: New NAS
From: "Brian Johnson" <brian@hdc.net>
Date: Fri, 10 Jul 1998 08:29:55 -0500
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of John Lange
> Sent: Thursday, July 09, 1998 9:15 PM
> To: emerald@iea-software.com
> Subject: Re: New NAS
>
>
> [begin vent]
>
> My 2 cents worth...
>
> At 09:15 AM 6/19/1998 -0500, you wrote:
> >I have had VERY good luck with my PM3's.
>
> I love my PM3's even with the beta v.90 code "GREAT" support for USR v.90
> and NO support for Rockwell v.90 (imagine that...from a kFlux
> company). My
> old PM2's & Sportsters, were even more reliable.
>
> >Livingston, unlike Ascend, doesn't release code until it is relatively
> Rock solid.
>
[begin rebuttal]
Horse Pucky.
> This is weird, Ascend called me today to tell me that their v.90
> code is no
> longer beta. I told them to late, and stop calling. We just
> spent $50K on
> new Livingston/Lucent equipment.
Ascend thoroughly tests it's code before release. they allow beta releases
with strict instructions not to use it on a production machine. I have
never had problems with getting help from ascend. If anything, I have had
more problems with USR and finding upgrades for their modems (if an upgrade
exists).
>
> The USR eWhine list has more complaints then all the other lists together.
> And the $2K per year for service contracts are a joke.
>
What can you do about a company that continually looses every battle to
smaller companies who care more about the industry.
> All the other stuff on the market is either unsupported junk or WAY to
> expensive. Or has more bells & wistles than we will ever need,
> Unless GTE-North starts spending some of the money We pay them. Can't do
> BRI can't do PRI, lucky to be able to do trunkside CT1, untill last month
> we had lineside.
Not my fault you can't deal with so many options. Having the options of an
Ascend is what give me the flexibility I need to change out my gear with
little or no interruptions in service.
[end rebuttal]
>
> [end of vent]
> JOhn :}
>
>
> John C. Lange, Sr. PALACE dot NET, INC.
> microjl@palacenet.net MICRO-TECH Computers, Inc.
> 608.742.1601 & 6980 2800 New Pinery Road
> http://www.palacenet.net/ Portage, WI 53901
> Visit our online store @ http://www.microt.com/
> Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
>
> --- __o
> --- _-\<,_ Fastest Service in Town
> --- (_)/ (_)
>
--------------------------------------------
Brian Johnson
Network Administrator
Hard Drive Central Internet Services
E-Mail: brian@hdc.net
Voice: 1-605-229-1562
Fax: 1-605-229-1563
--------------------------------------------
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: New NAS
From: "Lamar Townsend" <lamar@shuttle.com>
Date: Fri, 10 Jul 1998 08:51:58 -0500
> The USR eWhine list has more complaints then all the other lists
together.
> And the $2K per year for service contracts are a joke.
That's funny. I have a few Total Controls and I have had NO problems with
them.. Two of them are in
remote cities and they have not given me a minutes trouble. I also like
having the room to support up
to 336 v.90/ISDN calls per chassis which I don't believe any of the other
chassis are doing at this time.
As for the $2k per year for a service contract, I do not have a 3Com
service contract. My service contract
is through Source Technology (www.source-technology.com) and they provide
awesome support for these
boxes.
I am currently running the beta code on the HyperDSP (1.2.2) and the
release code on the HyperARP
(4.0.29) and both are working flawless with Emerald and RadiusNT thanks to
Jeff Binkley's extra attributes. :)
These are actually some very nice NAS. Granted, there are things that need
to be worked on, but if there
was a company out there that had 100% compatability and 0 complaints then
all of the others would be out
of business. I for one do not see that happening in the near future.
Lamar Townsend
Microgear Computers & Microgear.Net
lamar@microgear.net
lamar@shuttle.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Adding charges.
From: "Billy Huddleston" <billy@nxs.net>
Date: Fri, 10 Jul 1998 13:23:51 -0400
What kind of SQL statement would one use to add charges to an account? And.
is there a way to make it so that it's a credit card, not and invoice? I
need to add the ability to tack on Setup Fees for Online Signup.
Oh? Anyone find my ASP IEAK Signup useful?
Thanks, Billy Huddleston.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Adding charges.
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Fri, 10 Jul 1998 11:31:16 -0700
Billy Huddleston wrote:
>
> What kind of SQL statement would one use to add charges to an account? And.
> is there a way to make it so that it's a credit card, not and invoice? I
> need to add the ability to tack on Setup Fees for Online Signup.
>
> Oh? Anyone find my ASP IEAK Signup useful?
Just add an entry in the Charges table for the MBR's CustomerID.
Emerald will add it as a line item to the next invoice for the
customer. How it gets billed/paid is dependant upson how the
customer is configured to be billed.
-- 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 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Daily Maintence.From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 10 Jul 1998 12:13:47 -0700
Thomas Massano wrote:> > I have a brand new installation up and running. I have the Master and> Emerald DB dump every night so I have a BU of it.> What else should i be doing? Are there scripts I should be running, any> maintenance?> Looking for your suggestions.
I typically recommend running a "dbcc CheckDB(Emerald)" once a week via SQLEM (scheduled Tasks). Don't schedule these to happen in thenormal time frame the dump is going on, though. :)
-- 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: Terminate CauseFrom: "Pat Augustine" <ereth@ilnk.com>Date: Fri, 10 Jul 1998 15:55:41 -0400
With Josh Hillmans help I now have my Ascend MAX 400x sending Terminatecause messages that will show up in Emerald. The only problem I have is thatin the Time On tab most of the messages show up as numeric, instead of text,but a few show up as text. I'm guessing there's a lookup table that has values for the numerics thatturn them into text, but I can't find it to add the entries Ascend uses.
Where do I update that table so that 185 becomes, for example, "Remote EndHung Up"?
Thanks for your help.
Pat AugustineInterlink America
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Adding charges.From: "Billy Huddleston" <billy@nxs.net>Date: Fri, 10 Jul 1998 16:43:07 -0400
Were do I get the info for the ItemID? The numbers don't look consecutive..Or is that left blank and Emerald will fill it in when it process invoicesand such?
> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.> Sent: Friday, July 10, 1998 2:31 PM> To: emerald@iea-software.com> Subject: Re: Adding charges.>>> Billy Huddleston wrote:> >> > What kind of SQL statement would one use to add charges to> an account? And.> > is there a way to make it so that it's a credit card, not> and invoice? I> > need to add the ability to tack on Setup Fees for Online Signup.> >> > Oh? Anyone find my ASP IEAK Signup useful?>> Just add an entry in the Charges table for the MBR's CustomerID.> Emerald will add it as a line item to the next invoice for the> customer. How it gets billed/paid is dependant upson how the> customer is configured to be billed.>> --> 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 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Adding charges.From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 10 Jul 1998 14:24:43 -0700
Billy Huddleston wrote:> > Were do I get the info for the ItemID? The numbers don't look consecutive..> Or is that left blank and Emerald will fill it in when it process invoices> and such?
Leave it blank. Once Emerald has processed the charge and put it intoan Invoice Line Item, the ItemID will be put it to note which InvoiceLine Item (and indirectly which invoice) the charge was applied on.
-- 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 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Final StepsFrom: "Victor A." <victor@webjogger.net>Date: Fri, 10 Jul 1998 17:45:58 -0400
We've succesfully transfered our database to the new machine. We'veinstalled RadiusNT 2.5 and tested Authentication and Accounting accordingto the RadiusNT documentation. Authentication seems to be working ok. Butwhen we do a:
c:\radius\Radlogin UserName START
At the prompt I can see: Auth 0/0 Acct 0/0 T/O:1 Good 0 Bad 0
Emerald displays this error: "Runtime error 30009 Invalid Row Value" andclose itself down.
I think I'm getting real close :-) what do I need to check now..?
-Victor
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Daily Maintence.From: Jim Dunmyer <jdunmyer@toltbbs.com>Date: Fri, 10 Jul 1998 18:08:37 -0400
Dale E. Reed Jr. wrote:
> I typically recommend running a "dbcc CheckDB(Emerald)" once a week> via SQLEM (scheduled Tasks). Don't schedule these to happen in the> normal time frame the dump is going on, though. :)
Dale, Can I run this from Enterprise Manager? Is this documented someplace?
<<jdunmyer@toltbbs.com>> <<lower SE Michigan, USA>>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Terminate CauseFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 10 Jul 1998 15:04:25 -0700
Pat Augustine wrote:> > With Josh Hillmans help I now have my Ascend MAX 400x sending Terminate> cause messages that will show up in Emerald. The only problem I have is that> in the Time On tab most of the messages show up as numeric, instead of text,> but a few show up as text.> I'm guessing there's a lookup table that has values for the numerics that> turn them into text, but I can't find it to add the entries Ascend uses.
The RFC standard includes definitions for about 20 or so of the lowernumbers to messages. The rest are Ascend specific, and its possiblethat Ascend is not using the RFC stated numbers. > Where do I update that table so that 185 becomes, for example, "Remote End> Hung Up"?
YOu can't. I'll look into an option like this for a future release,though.
-- 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 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Daily Maintence.From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 10 Jul 1998 16:17:38 -0700
Jim Dunmyer wrote:> > Dale E. Reed Jr. wrote:> > > I typically recommend running a "dbcc CheckDB(Emerald)" once a week> > via SQLEM (scheduled Tasks). Don't schedule these to happen in the> > normal time frame the dump is going on, though. :)> > Dale,> Can I run this from Enterprise Manager? Is this documented someplace?
You can use Enterprise Manager to configure SQL Executive to run it.SQL Executive is a seperate program that runs along side of SQL Server.It can do many things like restart SQL Server if it dies, run all sortsof scheduled task, etc.
In Enterprise Manager, Select "Manage Scheduled Tasks". Click on New task. The type is TSQL. Enter "DBCC CheckDB(Emerald)" as the TSQL statement and Master as the database (it doens't actually matter).Then change the frequency to weekly on Sunday at say 3am. You haveto make sure SQL Executive is running and starts automatically as well.
-- 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