[Emerald Digest]

emerald-digest-request@iea-software.com
Wed, 10 Jun 1998 00:01:38 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: SQL Service Packs"
Next message: Chris A. Christopher: "Re: Clearing Calls from the online table"

Message 1: RE: IMail from IPSwitch
from "John Davies" <jgd@rockliffe.com>

Message 2: unsubscribe emerald
from "vincent b" <vincent_911@hotmail.com>

Message 3:
from Ed and Kathy Tate <tatee@onlinemac.com>

Message 4: unsubscribe
from "Bob Korch" <bkorch@snji.net>

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

Message 6: Custom Reports Tab Disappeared
from "Chris A. Christopher" <management@labyrinth.net>

Message 7: Re: Clearing Calls from the online table
from "Mourad Dahoumane" <mdahoumane@interway.lu>

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

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

Message 10: Re: Custom Reports Tab Disappeared
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 11: Radius Attributes
from "Boyd Goodin" <boyd@planetc.com>

Message 12: Re: Radius Attributes
from "Dale E. Reed Jr." <daler@iea-software.com>

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

Message 14: SQL Service Packs
from "Jay Kerr" <gkerr@whro.net>

Message 15: Re: SQL Service Packs
from "Dale E. Reed Jr." <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: IMail from IPSwitch
From: "John Davies" <jgd@rockliffe.com>
Date: Tue, 9 Jun 1998 07:29:54 -0700

>> When will Emerald interface with IMail?
>
>Rather than chase down every possible vendor that could work with
>Emerald and do all the grunt work, we are going to be using a new
>approash with Emerald 2.5. Emerald 2.5 will include a fully
>extensive DLL that currently has the proprietary extensions for
>NTMail, Serv-U and DNews. Also includes is our open API set
>that allows any program to validate and manipulate Emerlad users,
>without having to understand the database. It will come with
>full documentation so that other vendors can easily make hooks
>for Emerald w/out us having to re-invent the wheel each time.
>
>The advantage to this is great. You the customer, can send
>the vendor the information (our point them at it) and they
>should have a very small development cycle to support it,
>since there will be no interaction requirements from our
>side.
>
>If you are a vendor or 2rd party integrator and would like to
>see the DLL information before Emerald 2.5 is released, please
>send me E-Mail, and I will forward it to you.

Just a reminder: MailSite (http://www.rockliffe.com/mailsite.htm) integrates
with Emerald 2.5 out of the box today. We built in a native ODBC connector to
authenticate against Emerald without requiring an external DLL.

Regards, John.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: unsubscribe emerald
From: "vincent b" <vincent_911@hotmail.com>
Date: Tue, 09 Jun 1998 07:56:23 PDT

unsubscribe emerald

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject:
From: Ed and Kathy Tate <tatee@onlinemac.com>
Date: Tue, 9 Jun 1998 11:04:01 -0700

List,

I am looking for input on how or whether the 'Limit' or 'Extend' fields
work in conjunction with Emerald 2.1.11. If you are currently using or
attempted to use these fields with this version, could you possibly share
with me what you learned?

Thanks,

Kathy Tate
tatee@onlinemac.com

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: unsubscribe
From: "Bob Korch" <bkorch@snji.net>
Date: Tue, 9 Jun 1998 14:23:13 -0400

unsubscribe emerald

Bob Korch
Southern New Jersey Inter.Net, Inc.
609-459-1700
Fax: 609-459-1701
bkorch@snji.net

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Clearing Calls from the online table
From: "Chris A. Christopher" <management@labyrinth.net>
Date: Tue, 09 Jun 1998 16:13:16 -0400

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.

-------------------------------------------------------------------
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: Custom Reports Tab Disappeared
From: "Chris A. Christopher" <management@labyrinth.net>
Date: Tue, 09 Jun 1998 16:05:57 -0400

My custom reports tab has disappeared from the reports section. I am also
unable to view other reports, other than the defered revenue report, in the
drop down box. The reports are on the client machine located in the Emerald
root directory.
-------------------------------------------------------------------
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 7 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Clearing Calls from the online table
From: "Mourad Dahoumane" <mdahoumane@interway.lu>
Date: Tue, 9 Jun 1998 23:57:00 +0200

first ,locate the port that you want to clear
go to emerald admin/config radius/Server ports, choose the relevant nas and
port and uncheck
the "on-line" box

-----Original Message-----
From: Chris A. Christopher <management@labyrinth.net>
To: emerald@emerald.iea.com <emerald@emerald.iea.com>
Date: Tuesday, June 09, 1998 22:17
Subject: Clearing Calls from the online table

>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.
>
>
>-------------------------------------------------------------------
>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 8 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: SQL Querry for Homedir
From: "Brian Johnson" <brian@hdc.net>
Date: Tue, 9 Jun 1998 17:12:42 -0500

We moved our IIS and need a SQL querry to create all directories in the ned
IIS directory.
Any help would be appreciated.

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

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 9 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Clearing Calls from the online table
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Tue, 09 Jun 1998 15:24:37 -0700

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?

-- 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: Custom Reports Tab DisappearedFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 09 Jun 1998 15:26:02 -0700

Chris A. Christopher wrote:> > My custom reports tab has disappeared from the reports section. I am also> unable to view other reports, other than the defered revenue report, in the> drop down box. The reports are on the client machine located in the Emerald> root directory.

Emerald looks in the global report path to find the reports. If it cannot find any reports, it hides the custom report tab. Check yourglobal reports path.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Radius AttributesFrom: "Boyd Goodin" <boyd@planetc.com>Date: Tue, 9 Jun 1998 18:32:46 -0400

Hello all.

I am have a bit of difficulty. On Emerald administrator when I go tothe radius defaults and try to add any new attibutes, I get this errorcoming back when I go to save it: "SQL Server Error: 213 insert error: Column name or number of suppliedvalues does not match table definition State = 4, Severity = 16"

I did not have this problem until after I applied the rad25_up.sqlfile to the database to be able to run the 2.5 version of Radius.

Boyd GoodinPlanet systems Inc.Technical Director423-623-8300Web: www.planetc.com

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Radius AttributesFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 09 Jun 1998 15:42:03 -0700

Boyd Goodin wrote:> > I am have a bit of difficulty. On Emerald administrator when I go to> the radius defaults and try to add any new attibutes, I get this error> coming back when I go to save it:> "SQL Server Error: 213 insert error: Column name or number of supplied> values does not match table definition> State = 4, Severity = 16"> > I did not have this problem until after I applied the rad25_up.sql> file to the database to be able to run the 2.5 version of Radius.

The Emerald 2.2 administrator should work w/out this problem.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL Querry for HomedirFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 09 Jun 1998 15:45:38 -0700

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 SubAccountsSet HomeDir = '\\server\share\' + loginWhere Login IS NOT NULL and login <> ' '

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: SQL Service PacksFrom: "Jay Kerr" <gkerr@whro.net>Date: Tue, 9 Jun 1998 20:04:35 -0400

Hey Dale...

I am looking for the definitive answer from IEA. What SQL Service Pack doesEmerald like best?

Jay KerrWHRO-TV

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL Service PacksFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Tue, 09 Jun 1998 20:42:48 -0700

Jay Kerr wrote:> > I am looking for the definitive answer from IEA. What SQL Service Pack does> Emerald like best?

I have always recommened SQL SP3. I've head that SP4 is a must for "large"databases, but don't have a definition of what "large" means.

Previous message: Dale E. Reed Jr.: "Re: SQL Service Packs"
Next message: Chris A. Christopher: "Re: Clearing Calls from the online table"