[Emerald Digest]

emerald-digest-request@iea-software.com
Thu, 11 Jun 1998 00:00:00 -0700

Message 1: Re: Clearing Calls from the online table
from "Chris A. Christopher" <management@labyrinth.net>

Message 2: RE: SQL Querry for Homedir
from "Brian Johnson" <brian@hdc.net>

Message 3: Expiration date
from "Alan D. Criado" <ACriado@elink.net>

Message 4: .DLLs
from "Alan D. Criado" <ACriado@elink.net>

Message 5: RE: Clearing Calls from the online table
from "Greg Keys" <greg@loclnet.com>

Message 6: Re: Expiration date
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 7: Re: Expiration date
from "Alan D. Criado" <ACriado@elink.net>

Message 8: Re: SQL Querry for Homedir
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 9: Re: Clearing Calls from the online table
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 10: RE: Expiration date
from ronnie@itexas.net (Ronnie D. Franklin)

Message 11: Slightly off topic.
from "Richard Sensale" <richards@visitus.net>

Message 12: Data Model for Emerald
from Gil <gil@city-online.com>

Message 13: RE: Slightly off topic.
from "John Davies" <jgd@rockliffe.com>

Message 14: Re: Slightly off topic.
from "Richard Sensale" <richards@visitus.net>

Message 15: Re: Slightly off topic.
from "Richard Sensale" <richards@visitus.net>

Message 16: Re: Slightly off topic.
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 17: Excluding time ranges
from "TechNet of Kenora" <gregd@kenora.com>

Message 18: Re: Slightly off topic.
from "Richard Sensale" <richards@visitus.net>

Message 19: Re: Slightly off topic.
from "Richard Sensale" <richards@visitus.net>

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

Message 21: NTMail
from David Kerr <dkerr@phonet.com>

Message 22: emer_su.dll
from "Josh Hillman" <admin-maillist@talstar.com>

Message 23: Billing Problem
from "Scott Burch" <sburch@bmni.com>

Message 24: Re: Billing Problem
from "John Dodd" <jmdodd@mychoice.net>

Message 25: RE: Billing Problem
from "Scott Burch" <sburch@bmni.com>

Message 26: Re: Billing Problem
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 27: Re: Excluding time ranges
from "Dale E. Reed Jr." <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Clearing Calls from the online table
From: "Chris A. Christopher" <management@labyrinth.net>
Date: Wed, 10 Jun 1998 09:07:07 -0400

At 03:24 PM 6/9/98 -0700, you wrote:
>Chris A. Christopher wrote:
>>
>> I am unable to clear calls from the online table. I have restarted the SQL
>> services and rebooted the machine to no avail. What am I doing wrong? I
>> keep getting an SQL error everytime I try and clear a call.
>
>Its most likely a permissions problem. Can you clear the call if you
>login as sa?

No, even if I am logged in as SA
>

>
>
-------------------------------------------------------------------
Chris A. Christopher mailto:management@labyrinth.net
CEO Voice (304)292.7700
Labyrinth Solutions Inc. Fax (304)292.6549
235 High Street, Suite 416
Morgantown, WV 26507-0434 http://www.labyrinth.net
====================================================================

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: SQL Querry for Homedir
From: "Brian Johnson" <brian@hdc.net>
Date: Wed, 10 Jun 1998 08:43:50 -0500

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Tuesday, June 09, 1998 5:46 PM
> To: emerald@iea-software.com
> Subject: Re: SQL Querry for Homedir
>
>
> Brian Johnson wrote:
> >
> > We moved our IIS and need a SQL querry to create all
> directories in the ned
> > IIS directory.
> > Any help would be appreciated.
>
> Use something like this:
>
> Update SubAccounts
> Set HomeDir = '\\server\share\' + login
> Where Login IS NOT NULL
> and login <> ' '
>
> --
> 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
>

I already got this one. I was looking for something to actually create the
directory for the user. Not put the UNC in the database.

------------------------------------------
Brian Johnson
Network Administrator, Hard Drive Central
brian@hdc.net
605-229-1562 Fax: 605-229-1563
------------------------------------------

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Expiration date
From: "Alan D. Criado" <ACriado@elink.net>
Date: Wed, 10 Jun 1998 11:52:05 -0400

I hope you can help me with the following questions:

(I'm using Emerald 2.2.31 and RadiusNT 2.5)

1. Is there a way to change the expiration dates in Emerald for ALL the
customers at the same time? If so, how?

2. We've populated our Emerald database with all of our customers; however,
we won't be using Emerald to charge our customers until the beginning of
July. How do we keep Emerald from charging them from the date they were
entered?

For example: John Doe was entered May 15. '98 and Emerald shows this as his
start date. Come July 1, '98 I would like to charge John Doe 19.95 for
the first time for the month of July and I want Emerald to forget that he
even existed prior to July 1, '98.

3. Is there a beta version of Emerald that has a working BatchIn process?

Thank you.

Alan D. Criado

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: .DLLs
From: "Alan D. Criado" <ACriado@elink.net>
Date: Wed, 10 Jun 1998 12:11:36 -0400

How do I incorporate the .DLLs for NTMail and Servu into Emerald?

Thank you.

Alan

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Clearing Calls from the online table
From: "Greg Keys" <greg@loclnet.com>
Date: Wed, 10 Jun 1998 12:18:28 -0400

I ran into this problem with Emerald 2.1.whatever........ It was something
to do with the call table.....
AAARRRGGGHHH ... went to pull up the sql enterprise manager and my server
blue screened........

Anyway, now that the server is back up..... the call table has an item in
it called connectinfo that somehow was not in my copy of the database......
Set your radius to -x15 and watch for SQL errors...... I do not remember
what the details were but I do remember that a change to the database fixed
this problem....
It may also have been related to the following problem. I was working on a
different problem when the inability to clear calls was fixed, which is why
I do not clearly remember the details of it. I Just remember thinking, "I
bet that fixed this too!" and when I checked, it had...........

The connectinfo also must exist in the serverports table

> Greg Keys wrote:
>
> I am sitting here watching Radius authenticating against our brand new
emerald
> install (what a job :} ) and everything is working fine,
> except.......,
> When we get an invalid login attempt (bad user name) I see in Radius
(debug
> mode) the following error:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Data'
>
> Any idea's?

You need to add a data column to your RadLogs table. Execute this in
isql_w against your Emerald database:

ALTER TABLE RadLogs
ADD Data varchar (50) NULL DEFAULT NULL
GO

--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

---------------------------------------------------------- Emerald Mailing List listserver@emerald.iea.com> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Chris A.> Christopher> Sent: Wednesday, June 10, 1998 9:07 AM> To: emerald@iea-software.com> Subject: Re: Clearing Calls from the online table>>>> At 03:24 PM 6/9/98 -0700, you wrote:> >Chris A. Christopher wrote:> >>> >> I am unable to clear calls from the online table. I have> restarted the SQL> >> services and rebooted the machine to no avail. What am I doing wrong? I> >> keep getting an SQL error everytime I try and clear a call.> >> >Its most likely a permissions problem. Can you clear the call if you> >login as sa?>> No, even if I am logged in as SA> >>> >> >> -------------------------------------------------------------------> Chris A. Christopher mailto:management@labyrinth.net> CEO Voice (304)292.7700> Labyrinth Solutions Inc. Fax (304)292.6549> 235 High Street, Suite 416> Morgantown, WV 26507-0434 http://www.labyrinth.net> ====================================================================>>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Expiration dateFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 10 Jun 1998 09:18:29 -0700

Alan D. Criado wrote:> > I hope you can help me with the following questions:> > (I'm using Emerald 2.2.31 and RadiusNT 2.5)> > 1. Is there a way to change the expiration dates in Emerald for ALL the> customers at the same time? If so, how?

Open up isql_w, connect to your SQL Server, change the database to Emeraldand Execute this statement:

Update MasterAccounts Set maExpireDate = '7/1/98'

> 2. We've populated our Emerald database with all of our customers; however,> we won't be using Emerald to charge our customers until the beginning of> July. How do we keep Emerald from charging them from the date they were> entered?

Change their ExpireDate as notes above. > For example: John Doe was entered May 15. '98 and Emerald shows this as his> start date. Come July 1, '98 I would like to charge John Doe 19.95 for> the first time for the month of July and I want Emerald to forget that he> even existed prior to July 1, '98.> > 3. Is there a beta version of Emerald that has a working BatchIn process?

For what CC Type?

-- 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: Expiration dateFrom: "Alan D. Criado" <ACriado@elink.net>Date: Wed, 10 Jun 1998 12:30:09 -0400

>> 3. Is there a beta version of Emerald that has a working BatchIn process?>>For what CC Type?>

The major four credit cards using ICVerify.

Thank you.

Alan

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL Querry for HomedirFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Wed, 10 Jun 1998 09:45:42 -0700

> I already got this one. I was looking for something to actually create the> directory for the user. Not put the UNC in the database.

Select cmd='md ' + HomeDir