[Emerald Digest]
emerald-digest-request@iea-software.com
Wed, 19 Aug 1998 00:00:09 -0700
Message 1:
from "Anton G. Popov" <anton@unacs.bg>
Message 2: unsubscribe
from "-=+*( Zi(7.\\0k - B3n3\\/0l3nc3 )*+=-" <srodrig@colossus.rhon.itam.mx>
Message 3: Password
from "Lanham Rattan" <lanham@montrose.net>
Message 4: Re: Password
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 5: Error 380 and Emerald application errors
from Michael Bradley <BradleyM@energy.wsu.edu>
Message 6: Re: Password
from "Josh Hillman" <admin-maillist@talstar.com>
Message 7: Partial or Unapplied payments
from "Rick Morgan" <eval2@gtn.net>
Message 8: setup different billing rates
from "Bernard Andrys" <bernard@olg.com>
Message 9: billing configuration
from "Bernard Andrys" <bernard@olg.com>
Message 10: Emailing of CC bills
from Jeff Woods <jwoods@delta.com>
Message 11: Caller ID and RADLOGS
from "Pat Augustine" <ereth@ilnk.com>
Message 12: Re: billing configuration
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 13: Re: Partial or Unapplied payments
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 14: Re: Caller ID and RADLOGS
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 15: Re: Emailing of CC bills
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 16: Re: error message
from emerald@nls.net
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject:
From: "Anton G. Popov" <anton@unacs.bg>
Date: Tue, 18 Aug 1998 14:22:39 +0300
This is a multi-part message in MIME format.
------=_NextPart_000_0016_01BDCAB3.A7D0D600
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
unsubscribe
------=_NextPart_000_0016_01BDCAB3.A7D0D600
Content-Type: text/html;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
unsubscribe
------=_NextPart_000_0016_01BDCAB3.A7D0D600--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: unsubscribeFrom: "-=+*( Zi(7.\\0k - B3n3\\/0l3nc3 )*+=-" Date: Tue, 18 Aug 1998 10:35:38 -0600 (CST)unsubscribe-=+*( 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 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: PasswordFrom: "Lanham Rattan" Date: Tue, 18 Aug 1998 09:53:05 -0600How do I get Emerald to accept passwords smaller than 6 characters.Thanks,Lanham...------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: PasswordFrom: "Dale E. Reed Jr." Date: Tue, 18 Aug 1998 11:19:19 -0700Lanham Rattan wrote:> > How do I get Emerald to accept passwords smaller than 6 characters.Change the Min password length in the EMerald Admin, Config Clientsection.-- 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: Error 380 and Emerald application errorsFrom: Michael Bradley Date: Tue, 18 Aug 1998 12:04:32 -0700OK, got rid of the problem of not being able to add users by followingyour advice on the Error 380 problem to Nylis Renschler.The problem with a few reports crashing Emerald is still an issue.Also, when trying to access the "Billing Groups" tab in Config Databasein Emerald Administrator I get the error "Runtime error 424: Objectrequired." When I click OK, the program crashes.When trying to access the "Billing Cycles" tab, I get the error message"SQL Server Error: Invalid object name 'Billing Cycles'. State=1Severity=16. Clicking OK does not cause a crash in this case. I getthe same error if I try to add a Billing Cycle type.The only other problem I see right now is that the "Operators" tab isblank...------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: PasswordFrom: "Josh Hillman" Date: Tue, 18 Aug 1998 15:43:56 -0400> From: Lanham Rattan > How do I get Emerald to accept passwords smaller than 6 characters.Go into Emerald Admin and click on Client Config. There's a setting forthis under the Client tab.Josh Hillmanhillman@talstar.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Partial or Unapplied paymentsFrom: "Rick Morgan" Date: Tue, 18 Aug 1998 15:57:55 -0400This is a multi-part message in MIME format.------=_NextPart_000_0006_01BDCAC0.F66D1F00Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableCan Emerald handle partial or unapplied payments? How?rick@gtn.netwww.gtn.net519.858.6000------=_NextPart_000_0006_01BDCAC0.F66D1F00Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableCan Emerald handle partial or =unapplied=20payments? How?
rick@gtn.net
www.gtn.net
519.858.6000 <=/BODY>------=_NextPart_000_0006_01BDCAC0.F66D1F00--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: setup different billing ratesFrom: "Bernard Andrys" Date: Tue, 18 Aug 1998 17:19:23 -0400We charge $20/month for invoiced PPP accounts and $14.95/month for CreditCard PPP accounts.Where do I configure emerald to switch the amount billed based on whether"invoice" or "credit card" is checked?..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: billing configurationFrom: "Bernard Andrys" Date: Tue, 18 Aug 1998 17:21:53 -0400We charge $20/month for invoiced PPP accounts and $14.95/month for CreditCard PPP accounts.Where do I configure emerald to switch the amount billed based on whether"invoice" or "credit card" is checked?..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Emailing of CC billsFrom: Jeff Woods Date: Tue, 18 Aug 1998 17:23:55 -0400I just lost yet ANOTHER customer, because Emerald doesn't seem to do whatit says it will do. Emerald 2.1.11 (latest available to me for a production environment)MBR: under Services, I had in his only service, the boxes "Current" and"Send Bill" checked. under Billing, I had the pull-down for Send-Methodselected to "Electronic Mail".We do not use any of the automated batch services. To bill, I simply goto the BATCH tab, and do this:1) Type in the LAST date of the current month. Select "Renewal" Click CREATE This generates some of the paper invoice billing records and invoices.2) I repeat step one, with a date 30 days hence (i.e. 9/17/98 today). This step combined with the above ensures everyone gets billed. It took forever to get this straight, but now it works.3) I print each of the above-generated invoices, manually, one at a time, stuff the envelopes, and mail the bills. Since ALL of these clients are set up as quarterly billing to avoid the lack of balance forward (not complaining, just offering details), it works well.4) Type in the date seven days hence. If that date is NOT in the current month, I instead use the LAST day of the current month (and do a second group ala step 3 above). Select "Credit Card" Click CREATE This generates all (or some) of the cc billing records and invoices.5) I enter TODAY'S date, so that I am dealing with all invoices created today. I click on EMAIL to send an Email copy of all so-configured invoices to the users in question. THIS IS WHERE THE PROBLEM IS. The user who cancelled today claimed never to have received that Email copy, and this irked him. I lost the account after only three months.Why isn't Emerald doing what I asked -- Emailing the invoice that wasgenerated -- when I click on the button that says to Email it? The MBR andservice appear to be configured correctly. SOME customers get their mailcopies, but not all of them, and I can find NO difference in setup.6) I click PRINT, and print that one-page summary of all credit card invoices I generated in step 4. I then manually authorize them from that page, and mark them paid as I go.My customers need those Emailed copies -- how can I GUARANTEE that theywill be sent to the user?..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Caller ID and RADLOGSFrom: "Pat Augustine" Date: Tue, 18 Aug 1998 17:31:26 -0400Dale, I added the CALLERID table to my CALLS table and restarted Radius andvoila! CallerID is now being stored in the CALLS table. I note, however, that it is NOT being stored in the RADLOGS table, eventhough there is a field there. As a matter of fact, NASIdentifier, NASPortand CallerID are all blank. I'm running Emerald 2.1.11 with Radius NT 2.5. Should those fields be beingfilled or are they placeholders for future functionality?Pat AugustineInterlink America..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: billing configurationFrom: "Dale E. Reed Jr." Date: Tue, 18 Aug 1998 14:57:23 -0700Bernard Andrys wrote:> > We charge $20/month for invoiced PPP accounts and $14.95/month for Credit> Card PPP accounts.> > Where do I configure emerald to switch the amount billed based on whether> "invoice" or "credit card" is checked?You need to setup two different services. Emerald doesn't differentiatebetween pay methods for different costs.-- 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: Partial or Unapplied paymentsFrom: "Dale E. Reed Jr." Date: Tue, 18 Aug 1998 15:06:24 -0700> Rick Morgan wrote:> > Can Emerald handle partial or unapplied payments? How?Emerald 2.2 and lower does not support partial payments.Emerald 2.5 will.-- 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: Caller ID and RADLOGSFrom: "Dale E. Reed Jr." Date: Tue, 18 Aug 1998 15:10:07 -0700Pat Augustine wrote:> > Dale,> I added the CALLERID table to my CALLS table and restarted Radius and> voila! CallerID is now being stored in the CALLS table.:)> I note, however, that it is NOT being stored in the RADLOGS table, even> though there is a field there. As a matter of fact, NASIdentifier, NASPort> and CallerID are all blank.Thats correct. Currently RadiusNT isn't populating those fields. Weworking on that one. > I'm running Emerald 2.1.11 with Radius NT 2.5. Should those fields be being> filled or are they placeholders for future functionality?For the future...-- 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: Emailing of CC billsFrom: "Dale E. Reed Jr." Date: Tue, 18 Aug 1998 17:23:01 -0700Jeff Woods wrote:> > I just lost yet ANOTHER customer, because Emerald doesn't seem to do what> it says it will do.I'd probably guess you are assuming it will. Where does it say it willdo that?> Emerald 2.1.11 (latest available to me for a production environment)> > MBR: under Services, I had in his only service, the boxes "Current" and> "Send Bill" checked. under Billing, I had the pull-down for Send-Method> selected to "Electronic Mail".Emerald does not send email for CCs. It never has. We are working onthisfeature. :(> 5) I enter TODAY'S date, so that I am dealing with all invoices created> today. I click on EMAIL to send an Email copy of all so-configured> invoices to the users in question. THIS IS WHERE THE PROBLEM IS.> The user who cancelled today claimed never to have received that Email> copy, and this irked him. I lost the account after only three months.>> Why isn't Emerald doing what I asked -- Emailing the invoice that was> generated -- when I click on the button that says to Email it? The MBR and> service appear to be configured correctly. SOME customers get their mail> copies, but not all of them, and I can find NO difference in setup.Each invoice has a "sent date". When you print a batch of invoices,pay an invoice, etc, the sent date is set. Only those invoices witha sent date not set are emailed. > 6) I click PRINT, and print that one-page summary of all credit card invoices> I generated in step 4. I then manually authorize them from that page, and> mark them paid as I go.> > My customers need those Emailed copies -- how can I GUARANTEE that they> will be sent to the user?Email the invoices before printing them. That will ensure that theones to be emailed, are infact emailed.-- 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: error messageFrom: emerald@nls.netDate: Wed, 19 Aug 1998 01:41:04 -0400At 11:57 AM 8/17/98 -0700, you wrote:>The above is most likely the person re-entering their password>again within the same call (and minute). RadiusNT will only log the>same message for the same user once per minute, to prevent someone>from filling up your database.Ok, that makes sense.>How often do you see the below error and have you ever seen it in>the -x15 debug mode?>>> >> Sun Aug 16 16:48:23 1998: ODBC Error:07001:0:>> >> [Microsoft][ODBC SQL Server Driver]Wrong number of parametersAfter checking repeated entries, it appears to be related to the first errorexcept just for people who are trying to login a third time when they areonly allowed 2 simultaneous logins. So the progression goes something like this:Tue Aug 18 09:03:25 1998: User: danp already logged onto system 2 time(s). Tue Aug 18 09:03:25 1998: ODBC Error:23000:2627: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEYconstraint 'pk_RadLogs': Attempt to insert duplicate key in object 'RadLogs'.Tue Aug 18 09:03:25 1998: ODBC Error:07001:0: [Microsoft][ODBC SQL Server Driver]Wrong number of parametersThat's about the only pattern I can find. Geo.>> >>> >Typically, this is when RadiusNT is calling a stored proc and using the>> >wrong number of parameters. Did it show the actual call itself above>> >the error?>>-- >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>