[Emerald Digest]

emerald-digest-request@iea-software.com
Thu, 9 Jul 1998 00:00:00 -0700

Message 1: Re: E-mail invoices
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 2: RE: Emerald Accounting & Authentication
from "Rafael Gomez" <rgomez@c-com.net>

Message 3: Re: E-mail invoices
from "Greg Dobinson" <gregd@kenora.com>

Message 4: Re: E-mail invoices
from System Operator <sysop@i-star.net>

Message 5: New NAS
from David Kerr <dkerr@phonet.com>

Message 6: Re: No Accounting
from Victor Alba <victor@webjogger.net>

Message 7: Re: [Emerald Digest]
from "-=+*( Zi(7.\\0k - B3n3\\/0l3nc3 )*+=-" <srodrig@colossus.rhon.itam.mx>

Message 8: Re: New NAS
from Michael Whisenant <mwhisen@airnet.net>

Message 9: Re: [Emerald Digest]
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 10: Re: New NAS
from "Tony Morgan" <tmorg@clnk.com>

Message 11: Re: New NAS
from "Dusan Janjic" <djanjic@rockbridge.net>

Message 12: No Accounting II
from Victor Alba <victor@webjogger.net>

Message 13:
from Victor Alba <victor@webjogger.net>

Message 14: CallerID
from "Robert H. Clugston" <robert@csnsys.com>

Message 15: Emerald Blues
from Victor Alba <victor@webjogger.net>

Message 16: Re: Emerald Blues
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 17: Re: CallerID
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 18: Re: No Accounting
from "Dale E. Reed Jr." <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: E-mail invoices
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Wed, 08 Jul 1998 04:54:49 -0700

Robert H. Clugston wrote:
>
> List,
> I'm trying to modify our E-mail invoice to a get a month the pay for it
> system instead of the default pay a month get a month setup. Is there a
> report that can be changed or is this built in?

Emerald 2.2 and lower only supports pre-paying for internet service. It does
not support post-billing for a service, except for time usage.

-- 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 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Emerald Accounting & AuthenticationFrom: "Rafael Gomez" <rgomez@c-com.net>Date: Wed, 8 Jul 1998 10:20:51 -0400

Dale The Cisco Access Server send the accounting information to the Radiusserver, but this isn't capable to store the information in the table Call.The error message is "Log: AuthenticateAcctReq from xxx.xxx.xxx.xxx. WrongNAS Address."

DO you think I need to configure anything else in the Emerald Software?

Bye

-----Mensaje original-----De: Dale E. Reed Jr. <daler@iea-software.com>Para: emerald@iea-software.com <emerald@iea-software.com>Fecha: Tuesday, July 07, 1998 5:06 PMAsunto: Re: Emerald Accounting & Authentication

>Rafael Gomez wrote:>>>> I configured my CISCO to do authentication from one radius server(where>> the users are) and do accounting in another server. I can see the users>> connecting to my access server on the emerald console, but it can'treceive>> (the access server) any accounting accept>> response from the Emerald Radius Server. Do I need to have the users into>> the>> Emerald database to make accountig from the emerald software? or Can Imake>> accounting in one location and authentication in another one?>>By "different server" are you referring to a different RadiusNT server>running against the same SQL Server or two different RadiusNT servers>running against two different SQL Servers? The accounting data has to>go into the same database as the authentication does for the on-line>features to work. RadiusNT does not require users to be in the>database jsut to store the accounting information, 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 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: E-mail invoicesFrom: "Greg Dobinson" <gregd@kenora.com>Date: Wed, 8 Jul 1998 09:48:34 -0500

Further to this thread,

Can the e-mail invoices be modified(as far as wording etc.) or are thereports hard coded into the program?

If so which report or file would we modify?

Thanks.

----------> From: Dale E. Reed Jr. <daler@iea-software.com>> To: emerald@iea-software.com> Subject: Re: E-mail invoices> Date: Wednesday, July 08, 1998 6:54 AM> > Robert H. Clugston wrote:> > > > List,> > I'm trying to modify our E-mail invoice to a get a month thepay for it> > system instead of the default pay a month get a month setup. Is there a> > report that can be changed or is this built in?> > Emerald 2.2 and lower only supports pre-paying for internet service. Itdoes> not support post-billing for a service, except for time usage.> > -- > 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: Re: E-mail invoicesFrom: System Operator <sysop@i-star.net>Date: Wed, 08 Jul 1998 10:56:22 -0400

Greg,

Check out the changes.txt file in your Emerald DIR. It states how to use..txt files to add to the Email invoice.

Dean Morris

Greg Dobinson wrote:> > Further to this thread,> > Can the e-mail invoices be modified(as far as wording etc.) or are the> reports hard coded into the program?> > If so which report or file would we modify?> > Thanks.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: New NASFrom: David Kerr <dkerr@phonet.com>Date: Wed, 8 Jul 1998 10:51:08 -0500

I will be upgrading our NAS to do 56k and have found that populating my max with 56k cards would cost more than buying a new max already populated with modems.

I have a flyer from lucent about the portmaster 3 and would like anyones feed back regarding the Portmaster and or lucents support now that they own it.

Other than Ascend's non RFC of the disconnect cause code i've been happy with ascend.

Anyone with a portmaster have any gripes about it?

Thanks

Dave

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: No AccountingFrom: Victor Alba <victor@webjogger.net>Date: Wed, 08 Jul 1998 12:06:46 -0400

At 10:50 PM 7/7/98 -0700, you wrote:>My guess would be either permisions or some problem with the Calls>table. Who does RadiusNT connect as? Does it have problems if>you login as sa?

Radius connects using "sa" and works just great it has no problems loggingusing "sa". It authenticates just fine.

>Do you have a callsonline query or a possible permissions problem with>it?

I have no callsonline query at all. All I get whenever I click on theOn-line tab is "SQL failed"

What needs to be changed here for Emerald to perform the accounting.

_Victor

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: [Emerald Digest]From: "-=+*( Zi(7.\\0k - B3n3\\/0l3nc3 )*+=-" <srodrig@colossus.rhon.itam.mx>Date: Wed, 8 Jul 1998 11:29:29 -0600 (CST)

Is there any way to change the language in Emerald? ... I'm trying itfor my ISP, but I dont know if the registered version comes in differentlanguages or if there is somewhere to change it. Thats an important point forme because if it does, I'll buy it.

ThanksSteve.

-=+*( CliCk 4 mY pUb pGp -> http://elitekdge.home.ml.org/signature.html )*+=-

|.------------.| |.---)\/(--\ - /-----------------_-.| |.-/|---/\---|\-.|...|| ascii ansi ||.|| /____\ \ / __/\_ _/\ _/\ _| |||.||/ --' `--' \||.....|| anim & art ||.|| . - - . Y / / |/ _// _/| | |||.|/ zigmok@m-net \|.....|| amiga - pc ||.||..|_||_|.. | \/ /| | / |/ | ` ||| / .arbornet.org \.....|| - - -- - - ||.||.` ,, '. : / / | | \/ '\/ ' '||( ICQ #: 5855790 )....|| b e n e v ||.|||t\..../'| . \___'_'\__/\__/ |_| ||`\ iRc: /'....||o l e n c e ||.|||:|``''|:| -=fashion underwear=-||.\\ ^[ZiGm0k]^ //.....|`____ __ ____'|.|`___\__/____._____________________'|.|\\__ _ __ _ __//|.....`zMk/bNc/eKdGe!'.`_http://elitekdge.home.ml.org _pGp_'.`_<-Mah_HoMePAGe_'..

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: New NASFrom: Michael Whisenant <mwhisen@airnet.net>Date: Wed, 08 Jul 1998 11:17:08 -0500

David,

I am a strong supporter of USR's chassis for the last few years. Withthat said I have on-site one of the PM3's doing an eval, and really likeit. The support with Lucent is different than before when I had PM's withLivingston, but the same can be said about 3Com vs USR. If you are deadset against the TC platform, then the PM3 or PM4 for high density chassisis the next best option, in my opinon. I have used the Ascend 4xxx seriesand can not comment on the TNT platform, but ease of use, features, andpricing either the USR or the Lucent is a good value. You CAN NOT go wrongwith either purchase.

It is not that one is better than the other, its which one intergratesinto your current business plan, and which one offers greater scalabilitydown the road, personally and professionally I recommend the 3Com solutionover the Lucent one. You can find people with bad experiences with anyequipment, and you will find hundreds of happy user with each. If not thenthe compnay would not be continuing to sale them as customers would revolt. My business has grown 530% in the last two years, thanks in part to mydecision to use USR/3Com. I supported both K56Flex and x2 for severalmonths and know the trials of each. Develop a relationship with thevendor/supplier and make a long term look at where you are now, and whereyou plan to be, the figure out which product solves the needs.

At 10:51 AM 7/8/98 -0500, you wrote:>I will be upgrading our NAS to do 56k and have found that populating my max >with 56k cards would cost more than buying a new max already populated with >modems.>>I have a flyer from lucent about the portmaster 3 and would like anyones >feed back regarding the Portmaster and or lucents support now that they own >it.>>Other than Ascend's non RFC of the disconnect cause code i've been happy >with ascend.>>Anyone with a portmaster have any gripes about it?>>Thanks>>Dave> Michael J. WhisenantVice-President, OperationsAIRnet Internet Services, Inc.ph: (256) 704-4692 fax: (256) 704-2329

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: [Emerald Digest]From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 08 Jul 1998 10:16:00 -0700

Currently, No. We are working on multi-lingual editions for thefuture.

-=+*( Zi(7.\0k - B3n3\/0l3nc3 )*+=- wrote:> > Is there any way to change the language in Emerald? ... I'm trying it> for my ISP, but I dont know if the registered version comes in different> languages or if there is somewhere to change it. Thats an important point for> me because if it does, I'll buy it.

-- 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: Re: New NASFrom: "Tony Morgan" <tmorg@clnk.com>Date: Wed, 8 Jul 1998 12:40:38 -0500

Been using PM for 3 years and tried several others and I've found nothingbetter!

Tony Morgan

-----Original Message-----From: David Kerr <dkerr@phonet.com>To: 'emerald@iea-software.com' <emerald@iea-software.com>Date: Wednesday, July 08, 1998 11:06 AMSubject: New NAS

>I will be upgrading our NAS to do 56k and have found that populating my max>with 56k cards would cost more than buying a new max already populated with>modems.>>I have a flyer from lucent about the portmaster 3 and would like anyones>feed back regarding the Portmaster and or lucents support now that they own>it.>>Other than Ascend's non RFC of the disconnect cause code i've been happy>with ascend.>>Anyone with a portmaster have any gripes about it?>>Thanks>>Dave>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: New NASFrom: "Dusan Janjic" <djanjic@rockbridge.net>Date: Wed, 08 Jul 1998 13:58:49 -0400

This is a multi-part message in MIME format.--------------2469DC353C41AFB3FBE921E9Content-Type: text/plain; charset=us-asciiContent-Transfer-Encoding: 7bit

David Kerr wrote:

> I will be upgrading our NAS to do 56k and have found that populating my max> with 56k cards would cost more than buying a new max already populated with> modems.>> I have a flyer from lucent about the portmaster 3 and would like anyones> feed back regarding the Portmaster and or lucents support now that they own> it.

PM 3 is great. We don't have any problems with it. You plug them in and theywork, and work.... They also offer a lease on these, you may want to check thatas well. Support is still free, we had one bad modem in two years, theyovernight the replacement card. They can be slow in telephone response sometimes, it depends to which of the technicians you've been assigned. Only ifyour are out off commision they will take you right away. But for the most partyou don't need any support.

One more good place to check would be their mailing list, it can give you agood idea what kind of problems people have with their stuff....

>>> Other than Ascend's non RFC of the disconnect cause code i've been happy> with ascend.>> Anyone with a portmaster have any gripes about it?>> Thanks>> Dave

--------------2469DC353C41AFB3FBE921E9Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"Content-Transfer-Encoding: 7bitContent-Description: Card for Dusan JanjicContent-Disposition: attachment; filename="vcard.vcf"

begin: vcardfn: Dusan Janjicn: Janjic;Dusan org: RGVadr: 17 S. Jefferson;;;Lexington;VA;24450;U.S.email;internet: djanjic@rockbridge.nettel;work: 540-463-4451note: http://www.rockbridge.netx-mozilla-cpt: ;0x-mozilla-html: FALSEversion: 2.1end: vcard

--------------2469DC353C41AFB3FBE921E9--

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: No Accounting IIFrom: Victor Alba <victor@webjogger.net>Date: Wed, 08 Jul 1998 14:30:53 -0400

I'm still trying to see why I can't emerald to do the accounting eventhough RadiusNT 2.5 works fine. I just saw something that might be part ofthe problem, on the "ODBC DSN" tab of Radius Admin, whenever I click on the"Check" button I get the following error:

S0002:[Mircrosoft][ODBC SQL Server Driver][SQL Server] Invalid Object Name'masterAccounts'

If I click on the "Check" button for authentication or Accounting I getexactly the same error.

I've been trying to set this up for more than a week and can't find thesource of the problem yet....

-Victor

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: From: Victor Alba <victor@webjogger.net>Date: Wed, 08 Jul 1998 16:54:37 -0400

I hope anyone out there can give me an idea of what is happening with Emerlad.

This is a summary of what is happening in Emerald once the program is open:

"Accounts Tab"---------------

1)Having the box "Search services also" box checked all users are loadedand displayed on the screen.

2)If we search for a Specific user using his/her "lastname" we get a "notfound" message.

3)If we search for "Company" the MBR is located, the information isdisplayed but the "services tab" is empty ?!?

4)If we search for "login" we obtain the same as for "company".

"Reports Tab"--------------

1) NO matter what report we try to run we get an "SQL Server Error" box

"Batch Tab"--------------

1) As soon as we click on the "Batch Tab" we get an "SQL Error" box

"On-line Tab"--------------

1) As soon as we click on the Tab we get "SQL Command Failed"

Just in case you ask.... Radius runs fine.

-Victor

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: CallerIDFrom: "Robert H. Clugston" <robert@csnsys.com>Date: Wed, 8 Jul 1998 14:01:07 -0700

List, I now I asked this before, but I must have forgotten. Can radiusNT log thecalledID field? Does the lastest version do this? This would be a usefull feature.

robert@comstocknet.com

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Emerald BluesFrom: Victor Alba <victor@webjogger.net>Date: Wed, 08 Jul 1998 17:03:10 -0400

I hope anyone out there can give me an idea of what is happening with Emerlad.

This is a summary of what is happening in Emerald once the program is open:

"Accounts Tab"---------------

1)Having the box "Search services also" box checked all users are loadedand displayed on the screen.

2)If we search for a Specific user using his/her "lastname" we get a "notfound" message.

3)If we search for "Company" the MBR is located, the information isdisplayed but the "services tab" is empty ?!?

4)If we search for "login" we obtain the same as for "company".

"Reports Tab"--------------

1) NO matter what report we try to run we get an "SQL Server Error" box

"Batch Tab"--------------

1) As soon as we click on the "Batch Tab" we get an "SQL Error" box

"On-line Tab"--------------

1) As soon as we click on the Tab we get "SQL Command Failed"

Just in case you ask.... Radius runs fine.

-Victor

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald BluesFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 08 Jul 1998 22:36:03 -0700

Victor Alba wrote:> > I hope anyone out there can give me an idea of what is happening with Emerlad.> > This is a summary of what is happening in Emerald once the program is open:> > "Accounts Tab"> ---------------> > 1)Having the box "Search services also" box checked all users are loaded> and displayed on the screen.

With Search services also checked, Emerald only searches those MBRs whohave services. MBRs w/out services are not searched unless the "searchservices also" checkbox is unchecked. > 2)If we search for a Specific user using his/her "lastname" we get a "not> found" message.

With the SSA checked, Emerald searches the service last name. With itunchecked it searches the MBR last name. Some people do not realize thatthese two are NOT the same thing. > 3)If we search for "Company" the MBR is located, the information is> displayed but the "services tab" is empty ?!?

Is it possible that this MBR doesn't have any services? > 4)If we search for "login" we obtain the same as for "company".

You also might wnat to try the Services..Reload option. It will tellEmerald to reload the services that are associated to the MBR.

> "Reports Tab"> --------------> > 1) NO matter what report we try to run we get an "SQL Server Error" box

I would make sure you download the reports from the website. Someof the Emerald 2.1 reports errorneously looked for an Emerald2 databasespecificcally, which would cause this problem. If you open up a reportin Crystal Reports, you can use the Database...view SQL to see if ithas Emerald2 in it (and change it to just Emerald). > "Batch Tab"> --------------> > 1) As soon as we click on the "Batch Tab" we get an "SQL Error" box

This is most likely an issue with Emerald 2.2. Your database doesn'thave a correct ExternalTrans table. Emerlad is trying to find bad transactions, but the SQL Statement is failing. This could also be a permissions issue. Does it give this error when logged in asSA? > "On-line Tab"> --------------> > 1) As soon as we click on the Tab we get "SQL Command Failed"> > Just in case you ask.... Radius runs fine.

This is most likel a database problem as well. Either yourcallsonline query is not in your database or there is a permissionproblems.

-- 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 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: CallerIDFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 08 Jul 1998 22:40:13 -0700

Robert H. Clugston wrote:> > List,> I now I asked this before, but I must have forgotten. Can radiusNT log the> calledID field? Does the lastest version do this?> This would be a usefull feature.

Yes. You just need to add a field to the Calls table named "CallerID" or typevarchar(12), save the settings, and restart RadiusNT. The latest schemas andexample databases come with this as well as a ConnectInfo field.

-- 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 18 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: No AccountingFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 08 Jul 1998 22:58:44 -0700

Victor Alba wrote:> > >Do you have a callsonline query or a possible permissions problem with> >it?> > I have no callsonline query at all. All I get whenever I click on the> On-line tab is "SQL failed"> > What needs to be changed here for Emerald to perform the accounting.

If you don't have a callsonline view, then that is what the problemis. The view is in the insttabs.sql file. You can highly just thecreateview lines and execute them to create the view. You'll need toapply permissions to it 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