[Emerald Digest]
emerald-digest-request@iea-software.com
Sat, 29 Aug 1998 00:00:15 -0700
Message 1: RE: Printing batches of invoices
from "Bill Bongiorno" <bill@systec.com>
Message 2: Re: Email Invoices
from "Richard Sensale" <wolfen@visitus.net>
Message 3: RE: Y2K Compliance
from Rafael Gomez <rgomez@mail.vnzla.c-com.net>
Message 4: Re: DALE: NAS of Choice for Emerald?
from "Admin" <admin@parod.com>
Message 5: Re: DALE: NAS of Choice for Emerald?
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 6: Re: Email Invoices
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 7: Re: Printing batches of invoices
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 8: Re: Email Invoices
from "Richard Sensale" <richards@visitus.net>
Message 9:
from "CCOM" <rgomez@c-com.net>
Message 10:
from "JWD" <juergen.dobler@meritmalta.com>
Message 11: Disconnect Codes
from Mike Davis <mkdvs@naxs.com>
Message 12: Re: Questions with Radius
from "Dusan Janjic" <djanjic@rockbridge.net>
Message 13: Serv-u FTP
from "Derrick Young" <dyoung@thenew.net>
Message 14: Re: Disconnect Codes
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 15: Re: Billing "special" accounts
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 16: NT Mail 4.0 and Emerald
from "Derrick Young" <dyoung@thenew.net>
Message 17:
from "Lynella Devillier" <lynella@buz.net>
Message 18: Re: Serv-u FTP
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 19: Re: Questions with Radius
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 20: Re: Email Invoices
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 21: Re: Consolidation
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 22: Re: billing a "first month free"
from "Dale E. Reed Jr." <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Printing batches of invoices
From: "Bill Bongiorno" <bill@systec.com>
Date: Fri, 28 Aug 1998 08:02:01 -0400
Was the question regarding not printing sent email invoices ever answered?
This is a manual nightmare and I would like to know if it is, or is not,
possible. If not possible, will it be included in 2.5?
Bill Bongiorno
SysTec Computer Associates, Inc.
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Olivier Astier
> Sent: Tuesday, August 25, 1998 7:55 PM
> To: emerald@iea-software.com
> Subject: Printing batches of invoices
>
>
> Hi all,
>
> I have two problems with printing batches of invoices with emerald 2.2.38.
>
> 1) The footer doesn't match the header of the invoices : it is
> the footer of the next invoice. I know this is a know bug with
> CR5.0 but I have never installed it. Anyway, the report inv50.rpt
> seems to correct this problem but when I try to open it in
> Crystal Reports 4.5 I have an error "Acces Denied" whereas I am
> sure I have the NTFS rights to open it. Any idea? Is there a
> fixed version of this report for CR 4.5 ?
>
> 2) In the "batch" tab, I enter the date I created the invoice and
> click on "e-mail" : everything is ok. Then I click on "print" and
> it prints ALL the invoices, even those who should have been (and
> have been) sent by e-mail. How can I print only the invoices for
> the "postal bill" customers?
>
> Thank you for your attention.
>
> Oliver
> EchoWeb LLC
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Email Invoices
From: "Richard Sensale" <wolfen@visitus.net>
Date: Fri, 28 Aug 1998 08:29:06 -0400
Sorry, I wasn't sure if it used the same report as the printed ones.
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Thursday, August 27, 1998 2:00 PM
Subject: Re: Email Invoices
>Richard Sensale wrote:
>>
>> Which report file does Emerald use for Emailed Invoices? I need to
>> customize ours to include out letterhead graphic and address.
>
>Its called, drum roll, invoice.rpt :)
>
>--
>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: Y2K Compliance
From: Rafael Gomez <rgomez@mail.vnzla.c-com.net>
Date: Fri, 28 Aug 1998 10:28:46 -0400
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------ =_NextPart_000_01BDD26E.A4508DA0
Content-Type: text/plain
Thanks for your answer. I'm going to put an eye on your page until the
Y2K letter be there.
Bye
Rafael Gomez
> -----Mensaje original-----
> De: Dale E. Reed Jr. [SMTP:daler@iea-software.com]
> Enviado el: Jueves 27 de Agosto de 1998 05:30 PM
> Para: emerald@iea-software.com
> Asunto: Re: Y2K Compliance
>
> We have a Y2k letter that is avaialbable and will be put on our
> website here soon. Both products are Y2k compliant. If you need it
> sooner you may request it from sales.
>
> > Rafael Gomez wrote:
> >
> > Hi all
> > Is Emerald or Radius NT 2.5 Y2K compliant?. If so, I want to
> > know where I could find a letter with the Y2K certification. It is
> > very important to us because our enterprise wants to deal with the
> Y2K
> > certification and is very necessary all the companies we work deal
> > with.
>
> --
> 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
>
------ =_NextPart_000_01BDD26E.A4508DA0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IjEOAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAAzgcIABwACgAcAC4ABQBSAQEggAMADgAAAM4HCAAc
AAoAHAAuAAUAUgEBCYABACEAAAAxQ0VENTQwNTYwM0VEMjExODI4NjAwQTAyNDk4MTNGNgDhBgEE
gAEAEwAAAFJFOiBZMksgQ29tcGxpYW5jZQDiBQENgAQAAgAAAAIAAgABA5AGAPwHAAAqAAAACwAC
AAEAAAADAC4AAAAAAEAAOQCg8lwqkNK9AR4AcAABAAAAEwAAAFJFOiBZMksgQ29tcGxpYW5jZQAA
AgFxAAEAAAAWAAAAAb3Sj2ibBVTtJT5gEdKChgCgJJgT9gAAHgAxQAEAAAAHAAAAUkdPTUVaAAAD
ABpAAAAAAB4AMEABAAAABwAAAFJHT01FWgAAAwAZQAAAAAACAQkQAQAAAM8DAADLAwAADAYAAExa
RnWjP+jCAwAKAHJjcGcxMjVGMgD4C2BuZzgB0DKdAfcgAqQD4wIAY2gKwOBzZXQwIAcTAoMAUKEQ
dnBycTIRdn0KgNkIyCA7CW8OMDUCgAqBbHVjAFALA2MAQQ8CMyYwD0ALpiBUEQBua1cEIAIQBcB5
CGEgAHF3AQSQLiBJJ20gZwJvC4BnIHRvIHCGdQVAA5FleWUgAiBrGIQKsGcawHUCMAMRdIJoGsBZ
MksgbBFAcnQEkCBiGsAcEQlwLjcKogqECoBCGrAdmlJhKGZhZQMgRwNwZXrDHZoK9GxpMzYBQBaQ
SwFAEsBvHMBjdBIEMSg2IC0iwk0J8HNh9moawQUQZwuAB0Aiwx2WDyHUIaELEyHWaS0xNMY0AUAh
IDE4MAFADNBBJmNiIERlOgyDYq0RYEQHQBrARRlAUgngCGQgShkxW1NNVEhQOmQocXJACJBh6C1z
bwGAdwrAHXAFoIxtXR2VJ5BFbnYHMK5kGhAfgCfXSgpQdgeRuDI3IAEAEXAZoHMaAQEtoTE5OTgg
MDWiOhcQIFBNK0dQCsCaYSfXZQeAL/BsZCovaStHQXMbsW8n1yjgOpscQwhQbQtQBzBuYx53vyTv
IgIhJA8GC6cdo1cawG8RAC0wGNAcQWschhwQYbcFQAQAGNB2C3AHQGIBoO8ogQBwKRAD8GwDIB0B
GjLvGuEIYR2UGRBiAJAcwDhwnR1RICpwAiAZQCBCIeDWaBogA2BkFgB0OgE9QZc48isBNFN0PbFJ
ZhiC/CBuKPI84B2UPXIc0UAy6QDAeSAJcHEKUC4AQLGvGEADYT1gKHFzHYs+B/A/H1k7ECHSJ9BE
BUP2SGmvGNA7QEP2R3ZJBCBFMLSjI4FEYWRpdQehVC1g7C41HEM/Rz8ZQUAQKnA+LBlQOxA/oRnx
Q/ZrbrpvB+B3PSNLMAWgdUiB/yYwOvE40ByVA/A+ARwWNKCvACAGkA3gOcBpPZJJOdLbQ/YtMHJC
EAdwcAkRS2T/G6AEIB0AT5BJIBrBGLEJ8P8cwRLABAAawEtSBCAuEwdA/05LQ/ZPKzrTOfFQ40Bw
NKD/BBAKwEIQRtEcAz9CAHAIkP8EIBkQOxAFsDkQVDJD9k5Szx2LIsBGFShvICgp3yrj+ikdlF9f
D2AfYS9iCx2U+UeWRUEGACqFSxE0kD2x/UdyfD3ASORJUEsQSDVLEOM64klRRkFRUFVksRzBv0Bw
BUBkIApAT7IYNFQEcH9CAWVSAzAWkk0wOHACQHDQOi8vd2rwLjEvIYIvTTA35R2UE4EAbbAACwAA
gAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAGACCAGAAAAAADAAAAAAAAARgAAAAAQhQAA
AAAAAAMAAoAIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAC3DQAAHgADgAggBgAAAAAAwAAAAAAAAEYA
AAAAVIUAAAEAAAAEAAAAOC4wAAMABIAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAFgAgg
BgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAAaACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAA
AAMAB4AIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgAIgAggBgAAAAAAwAAAAAAAAEYAAAAA
NoUAAAEAAAABAAAAAAAAAB4ACYAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAe
AAqACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAAwDxPwkEAAADAP0/5AQAAAMA
JgAAAAAAAwA2AAAAAAADAIAQ/////wIBRwABAAAALAAAAGM9RVM7YT0gO3A9Q0NPTTtsPUNBUkFD
QVMxLTk4MDgyODE0Mjg0NlotMTkAHgA4QAEAAAAHAAAAUkdPTUVaAAAeADlAAQAAAAcAAABSR09N
RVoAAEAABzAQ/1wqkNK9AUAACDAQ5Y0qkNK9AR4APQABAAAABQAAAFJFOiAAAAAAHgAdDgEAAAAP
AAAAWTJLIENvbXBsaWFuY2UAAB4ANRABAAAAPAAAADwxMUE1MjMxOTM4MzlEMjExQUJFMzAwMDAy
MTRGNDc3MjA1NDdAbWFpbC52bnpsYS5jLWNvbS5uZXQ+AAsAKQAAAAAACwAjAAAAAAADAAYQxx1A
cQMABxDiAgAAAwAQEAAAAAADABEQAQAAAB4ACBABAAAAZQAAAFRIQU5LU0ZPUllPVVJBTlNXRVJJ
TUdPSU5HVE9QVVRBTkVZRU9OWU9VUlBBR0VVTlRJTFRIRVkyS0xFVFRFUkJFVEhFUkVCWUVSQUZB
RUxHT01FWi0tLS0tTUVOU0FKRU9SSUcAAAAAAgF/AAEAAAA8AAAAPDExQTUyMzE5MzgzOUQyMTFB
QkUzMDAwMDIxNEY0NzcyMDU0N0BtYWlsLnZuemxhLmMtY29tLm5ldD4AiNY=
------ =_NextPart_000_01BDD26E.A4508DA0--
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: DALE: NAS of Choice for Emerald?
From: "Admin" <admin@parod.com>
Date: Fri, 28 Aug 1998 11:08:36 -0500
I am using Compaq 4000's and I have never had a problem with Emerald or
Radius with them. They work great the only thing that I don't see is the
"Termination Reason".
And the Traffic Table doesn't seem to be collecting information.
Darryl Etter
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Thursday, August 27, 1998 4:48 PM
Subject: Re: DALE: NAS of Choice for Emerald?
>Franco Nogarin - Cascade Publishing wrote:
>>
>> Dale, we plan to buy all new equipment and sell our older stuff. We are
an
>> all NT ISP and would like a NAS recommendation for about 20-25 lines with
>> expandability for ISDN etc. What would you recommend?
>
>Probably a PM3. They seem to have the least amount of gripes.
>USR is getting pretty decent 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
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: DALE: NAS of Choice for Emerald?
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Fri, 28 Aug 1998 09:24:58 -0700
Admin wrote:
>
> And the Traffic Table doesn't seem to be collecting information.
The traffic table is for external support. We have not implemented
support for it yet.
--
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: Email InvoicesFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 28 Aug 1998 09:49:18 -0700
Richard Sensale wrote:> > Sorry, I wasn't sure if it used the same report as the printed ones.
Actually, I missed the Emailed part. Emerald 2.2 and lower use aninternal report for it that can't be modified. YOu can, however, create three files (invhead.txt, invbody.txt and invfoot.txt) to addlines to the respective areas of the emailed reports.
--
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: Re: Printing batches of invoicesFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 28 Aug 1998 09:52:16 -0700
Bill Bongiorno wrote:> > Was the question regarding not printing sent email invoices ever answered?
I replied to the post.
> This is a manual nightmare and I would like to know if it is, or is not,> possible. If not possible, will it be included in 2.5?
One thing you can do is update the invoice.rpt to only include thoseinvoices where the SentDate field is NULL. I'll check to see whetherthisis still a problem in Emerald 2.5.
--
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 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Email InvoicesFrom: "Richard Sensale" <richards@visitus.net>Date: Fri, 28 Aug 1998 13:21:01 -0400
Do you have any advice on our other problems, concurrency control notworking, and the problem with our online calls table. P.S. where do thesetext files need to reside and do I need to tell emerald to use them or dothey get detected automatically?
-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: emerald@iea-software.com <emerald@iea-software.com>Date: Friday, August 28, 1998 7:50 AMSubject: Re: Email Invoices
>Richard Sensale wrote:>>>> Sorry, I wasn't sure if it used the same report as the printed ones.>>Actually, I missed the Emailed part. Emerald 2.2 and lower use an>internal report for it that can't be modified. YOu can, however,>create three files (invhead.txt, invbody.txt and invfoot.txt) to add>lines to the respective areas of the emailed reports.>>>-->>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: From: "CCOM" <rgomez@c-com.net>Date: Fri, 28 Aug 1998 13:52:34 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_0007_01BDD28B.1BF0E0A0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
UNSUBSCRIBE emerald
------=_NextPart_000_0007_01BDD28B.1BF0E0A0Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
UNSUBSCRIBE =emerald
------=_NextPart_000_0007_01BDD28B.1BF0E0A0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: From: "JWD" Date: Fri, 28 Aug 1998 20:15:42 +0200This is a multi-part message in MIME format.------=_NextPart_000_0004_01BDD2C0.A219DE40Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableUNSUBSCRIBE emerald------=_NextPart_000_0004_01BDD2C0.A219DE40Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable------=_NextPart_000_0004_01BDD2C0.A219DE40--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Disconnect CodesFrom: Mike Davis Date: Fri, 28 Aug 1998 14:47:57 -0400Is there any documentation that translates the terminate cause codes in thecalls table?Mike DavisNetAccess, Inc.Abingdon, VA..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Questions with RadiusFrom: "Dusan Janjic" Date: Fri, 28 Aug 1998 15:35:49 -0400Dale E. Reed Jr. wrote:> Dusan Janjic wrote:>> > mode. Here are the error messages from the log file:> >> ...> > I am not sure how to solve this??>> Run the rad25_up2.sql script against your Emerald database. It includes> the missings fields noted.>Ok Dale,This seemed to fix the problem but only partially. I have noticed more thenusual number of users that Radius reports as logged in. Here is the portion ofthe messages from the log file:Fri Aug 28 13:45:42 1998: ODBC Error:23000:547: [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflictedwith COLUMN FOREIGN KEY constraint 'FK__RadLogs__RadLogM__1E1A7EA3'. Theconflict occurred in database 'Emerald', table 'RadLogMsgs', column'RadLogMsgID'Fri Aug 28 13:45:56 1998: User: rockplan already logged onto system 1 time(s).Fri Aug 28 13:45:56 1998: ODBC Error:23000:547: [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflictedwith COLUMN FOREIGN KEY constraint 'FK__RadLogs__RadLogM__1E1A7EA3'. Theconflict occurred in database 'Emerald', table 'RadLogMsgs', column'RadLogMsgID'It seems that either, Radius doesn't send the proper string to Emerald toinform it of the termination of the session, or (unlikely ) unusual highnumber of our users is trying to log in twice.Can you help?..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Serv-u FTPFrom: "Derrick Young" Date: Fri, 28 Aug 1998 16:31:44 -0400This is a multi-part message in MIME format.------=_NextPart_000_0069_01BDD2A1.582FFEF0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableWhen Serv-U authenticates a user through the Emerald system does this =user or can this user be a part of a group other than the default. What =I am trying to do is manage the disk quota on the ftp/web space. Some =of our packages get more than others.Derrickdyoung@thenew.net------=_NextPart_000_0069_01BDD2A1.582FFEF0Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableWhen Serv-U authenticates a user =through the=20Emerald system does this user or can this user be a part of a group =other than=20the default. What I am trying to do is manage the disk quota on =the=20ftp/web space. Some of our packages get more than =others.
Derrick
dyoung@thenew.net
------=_NextPart_000_0069_01BDD2A1.582FFEF0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Disconnect CodesFrom: "Dale E. Reed Jr." Date: Fri, 28 Aug 1998 13:31:06 -0700Mike Davis wrote:> > Is there any documentation that translates the terminate cause codes in the> calls table?Check your NAS vendor docs. They should cover them. The basic onesare covered in the RFC (see ftp.livingston.com/radius/rfc2139.txt).-- 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: Billing "special" accountsFrom: "Dale E. Reed Jr." Date: Fri, 28 Aug 1998 15:05:31 -0700Bernard Andrys wrote:> > Is there any way to have Emerald handle "special" accounts.> > That is we have couple dozen accounts that don't fit the standard billing> options. Is there a way to have emerald bill these without having to create> dozens of accounts types for each of these special accounts?> > I noticed that under billing, there is "balance" and "other". Can "other"> be used to fill in the amount that these accounts should be billed?You can override the default cost for a service in the generaltab by selecting static cost and filling in the amount to theright of it. Its a per-month cost and discounts and other optionsare not applied.-- 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: NT Mail 4.0 and EmeraldFrom: "Derrick Young" Date: Fri, 28 Aug 1998 18:10:56 -0400This is a multi-part message in MIME format.------=_NextPart_000_0014_01BDD2AF.33900C30Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableHas anyone managed to get NT Mail 4.0 working with emer_ntm.dll?------=_NextPart_000_0014_01BDD2AF.33900C30Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableHas anyone managed to get NT Mail =4.0 working=20with emer_ntm.dll?
------=_NextPart_000_0014_01BDD2AF.33900C30--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: From: "Lynella Devillier" Date: Fri, 28 Aug 1998 22:04:47 -0500This is a multi-part message in MIME format.------=_NextPart_000_0001_01BDD2CF.DEE64CA0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: 7bitunsubscribe lynella@buz.net------=_NextPart_000_0001_01BDD2CF.DEE64CA0Content-Type: application/ms-tnef; name="winmail.dat"Content-Transfer-Encoding: base64Content-Disposition: attachment; filename="winmail.dat"eJ8+Ii8DAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAAM4HCAAcABYAAwAAAAUAFwEBA5AGAKAEAAAmAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAAIBcQABAAAAFgAAAAG90vmO/n1GumQ+7BHSt+dIVOgo4H0AAAIBHQwBAAAAFQAAAFNNVFA6TFlORUxMQUBCVVouTkVUAAAAAAsAAQ4AAAAAQAAGDgDKmof50r0BAgEKDgEAAAAYAAAAAAAAABl7bVw3y9ERt39IVOgo4H3CgAAACwAfDgEAAAADAAYQO7oU0QMABxAZAAAAHgAIEAEAAAAaAAAAVU5TVUJTQ1JJQkVMWU5FTExBQEJVWk5FVAAAAAIBCRABAAAAfQAAAHkAAACnAAAATFpGdZlFzycDAAoAcmNwZzEyNRYyAPgLYG4OEDAzM50B9yACpAPjAgBjaArAYHNldDAgBxMCgH0ZCoF1YwBQCwN1bG4dAiBlC6cKsQqEZCB1CQCAdWIE8mJlIGwKeRMAbAtgQGJ1erouEwB0E6kTpBHxABdgAAAAAwAQEAAAAAADABEQAAAAAAsAAYAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwAQgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAAPATAAAeABGACCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA4LjUACwAVgAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADABaACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAH4AIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAggAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADACGACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAI4AIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgAzgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4ANIAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeADWACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAACwA9gAggBgAAAAAAwAAAAAAAAEYAAAAAgoUAAAEAAAALAD+ACyAGAAAAAADAAAAAAAAARgAAAAAAiAAAAAAAAAsAQYALIAYAAAAAAMAAAAAAAABGAAAAAAWIAAAAAAAAAgH4DwEAAAAQAAAAGXttXDfL0RG3f0hU6CjgfQIB+g8BAAAAEAAAABl7bVw3y9ERt39IVOgo4H0CAfsPAQAAAIIAAAAAAAAAOKG7EAXlEBqhuwgAKypWwgAAUFNUUFJYLkRMTAAAAAAAAAAATklUQfm/uAEAqgA32W4AAABDOlxXSU5OVFxQcm9maWxlc1xseW5lbGxhXEFwcGxpY2F0aW9uIERhdGFcTWljcm9zb2Z0XE91dGxvb2tcb3V0bG9vay5wc3QAAAADAP4PBQAAAAMADTT9NwAAAgF/AAEAAAAxAAAAMDAwMDAwMDAxOTdCNkQ1QzM3Q0JEMTExQjc3RjQ4NTRFODI4RTA3RDQ0NjEyMTAwAAAAAArD------=_NextPart_000_0001_01BDD2CF.DEE64CA0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 18 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Serv-u FTPFrom: "Dale E. Reed Jr." Date: Fri, 28 Aug 1998 22:31:08 -0700> Derrick Young wrote:> > When Serv-U authenticates a user through the Emerald system does this> user or can this user be a part of a group other than the default.> What I am trying to do is manage the disk quota on the ftp/web space.> Some of our packages get more than others.The group doesn't have a lot to do with it. Serv-U Authenticatedbased on the username/password and gets a homedir as a result. Weare working on updating the EmerAuth.dll to include quota capabilitieswith Emerald 2.5.-- 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 19 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Questions with RadiusFrom: "Dale E. Reed Jr." Date: Fri, 28 Aug 1998 22:42:18 -0700Dusan Janjic wrote:> > > > mode. Here are the error messages from the log file:> > >> > ...> > > I am not sure how to solve this??> >> > Run the rad25_up2.sql script against your Emerald database. It includes> > the missings fields noted.> > This seemed to fix the problem but only partially. I have noticed more then> usual number of users that Radius reports as logged in. Here is the portion of> the messages from the log file:> > Fri Aug 28 13:45:42 1998: ODBC Error:23000:547:> [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted> with COLUMN FOREIGN KEY constraint 'FK__RadLogs__RadLogM__1E1A7EA3'. The> conflict occurred in database 'Emerald', table 'RadLogMsgs', column> 'RadLogMsgID'The other common issue is that you don't have any entries in the RadLogMsgs table. Because of constraints, you can't put an entry intothe RadLogs table w/out a defining entry in the RadLogMsgs table. Run these lines in isql_w to populate the table:INSERT RadLogMsgs VALUES(0, "Generic Message", 0)INSERT RadLogMsgs VALUES(1, "Generic Error", 5)INSERT RadLogMsgs VALUES(10, "User Not Found", 3)INSERT RadLogMsgs VALUES(11, "Bad Password", 3)INSERT RadLogMsgs VALUES(12, "User Expired", 2)INSERT RadLogMsgs VALUES(13, "User OverDue", 2)INSERT RadLogMsgs VALUES(14, "Over Login Limit", 1)INSERT RadLogMsgs VALUES(15, "No Time Left", 1)INSERT RadLogMsgs VALUES(16, "Port Not Allowed", 2)INSERT RadLogMsgs VALUES(19, "No Attributes", 3)INSERT RadLogMsgs VALUES(50, "Bad Request", 4)INSERT RadLogMsgs VALUES(51, "No Username", 4)INSERT RadLogMsgs VALUES(52, "No Password", 4)INSERT RadLogMsgs VALUES(53, "Bad Digest", 6)INSERT RadLogMsgs VALUES(54, "Bad username", 3)INSERT RadLogMsgs VALUES(60, "Parse Error", 5)INSERT RadLogMsgs VALUES(100, "Chap Not Allowed", 5)> Fri Aug 28 13:45:56 1998: User: rockplan already logged onto system 1 time(s).Is the callsonline looking correct? This could be a result ofaccounting problems and callsonline not be right. > It seems that either, Radius doesn't send the proper string to Emerald to> inform it of the termination of the session, or (unlikely ) unusual high> number of our users is trying to log in twice.Most likely you have an accounting problem that is preventing thecallsonline from being accurate. That could be a result of a fulldatabase, errant accounting, etc.-- 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 20 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Email InvoicesFrom: "Dale E. Reed Jr." Date: Fri, 28 Aug 1998 22:47:12 -0700Richard Sensale wrote:> > Do you have any advice on our other problems, concurrency control not> working, and the problem with our online calls table. P.S. where do these> text files need to reside and do I need to tell emerald to use them or do> they get detected automatically?They should be in the working directory of Emerald.Concurrency requires calls online to work correctly. If your callsare not being tracked, run RadiusNT in -x15 and look at the accountingrecords (they will have an Acct-Status-Type attribute in them). Whatis the port number being reported in the NAS-Port attribute? Does that port exist for the NAS? Is the IP Address for the NAS the sameas the NAS-Identifier being reported?-- 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 21 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: ConsolidationFrom: "Dale E. Reed Jr." Date: Fri, 28 Aug 1998 23:32:03 -0700greg Lowthian wrote:> > >> >> > Then you should be ok. The summary is only a summary an not exactly.> >> > Ok how long will the periods stay in the summary. I assume on the first> number 3 will show up. I have consolidated every day and the (number)> for 1 and 2 does not change.If you have orphan records, then they will be there until you cleanthem up. The 1 and 2 will evenually change over time. If they don't change for the day, you probably don't need to run a consolidation.> Also I cant believe that there aren't call records for canceled accounts> there has to be a bunch that can be deleted.> I saw a script you sent someone that deleted from Calls if the> account was not there.If the numbers in 2+ aren't changing, then there probably are someorphan records. I have't to look at your DB to really give youan answer.-- 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 22 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: billing a "first month free"From: "Dale E. Reed Jr." Date: Fri, 28 Aug 1998 23:33:45 -0700Bernard Andrys wrote:> > How do you setup emerald to handle a "first month free" monthly or yearly> account.The easiest way to do it is change the ExpireDate on the Account whenyou are signing up the customer to be the end of the free period. TheEmerald will pickup the billing after that. You can set the DefaultExpire to something like 30 in the Config Client to make this happenautomatically for all new accounts.> Can the Start Date be used for this or will the user not be able to log in> if the Start Date is set to a month in the future.The start date isn't used currently in Emerald.-- 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