[Emerald] Re (2) In serach of stable Db

Peter at Datafast ( (no email) )
Mon, 23 Nov 1998 03:30:03 +1100

This is a multi-part message in MIME format.

------=_NextPart_000_0085_01BE1691.8E96A960
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

OK, thanks for that Dale. I have obtained the file, but not yet used it. =
Can I use the Admin portion only, or do I need to upgrade the whole show =
to the beta 2.2 (with all the support limitations of a beta release)?

Given that we are about to throw some $ at iea, how far off is the 2.5 =
release (Enterprise) ? Should we hold off until then?

Thanks again.
Pete.=20

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: [Emerald] In search of a stable Emerald Db
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Mon, 16 Nov 1998 23:21:03 -0800

> Peter at Datafast wrote:
>=20
> Hi, hope someone can assist - I am in a 'problematic' evaluation of
> emerald.
>=20
> My current concern is that I might not have alignment between the
> software components and the installed database structure. I have
> installed the following components on an nt4 sp3 with sql6.5:
>=20
> Radius.exe 2.5.124
> RadAdmin 2.5
> Emerald Admin 2.1.0
> Emerald.exe 2.1.11
>=20
> I have run the script Rad25_up2.sql on the 'fresh' database as advised
> somewhere in this list.
>=20
> I have radius running as a service and am using odbc authentication.
>=20
> With the above I can achieve a working system, however I am not able
> to perform certain operations, for example I get an SQL error if I
> attempt to alter the default attributes for a service (and the default
> attributes get wiped!). This was not the case prior to running the
> update script, however without the update script other errors
> prevented any authentication because the stored procedure
> getradattributes disagreed with the radattributes table structure. In
> either case (ie, both before and after running the update script) the
> 'check database' routine reports the tables RadAttributes & RadValues
> (among others) have an incorrect number of fields.

You can ignore the check information. This is a bug in the Emerald 2.1
admin. The Emerald 2.2 Admin (in the /emerald/beta/emerald22 directory)
will correct the problem.

> I will be happy to provide more exact SQL trace info or logfile output
> with -x15 debugging from radius, however I feel sure the problem lies
> in the process I am using to create the database, or is it this flakey
> for everyone?

This isn't a DB issue. Its a known issue with the 2.1 admin.

--=20

Dale E. Reed Jr. (daler@iea-software.com)
_________________________________________________________________

------=_NextPart_000_0085_01BE1691.8E96A960
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

 
OK, thanks for that Dale. I have =obtained the=20file, but not yet used it. Can I use the Admin portion only, or do I =need to=20upgrade the whole show to the beta 2.2 (with all the support limitations =of a=20beta release)?
 
Given that we are about to throw =some $ at iea,=20how far off is the 2.5 release (Enterprise) ? Should we hold off until=20then?
 
Thanks again.
Pete. 
 
 
 
.------ ------ ------ ------ ------ ------ ------ ------ ------=20------.
| Message=204            =            &=nbsp;           &n=bsp;           &nb=sp;         =20|
'------ ------ ------ ------ ------ ------ ------ ------ ------=20------'
Subject: Re: [Emerald] In search of a stable Emerald=20Db
From:    "Dale E. Reed Jr." <daler@iea-software.com>
=Date:   =20Mon, 16 Nov 1998 23:21:03 -0800

> Peter at Datafast =wrote:
>=20
> Hi, hope someone can assist - I am in a 'problematic' =evaluation=20of
> emerald.
>
> My current concern is that I might =not have=20alignment between the
> software components and the installed =database=20structure. I have
> installed the following components on an nt4 =sp3 with=20sql6.5:
>
> Radius.exe 2.5.124
> RadAdmin 2.5
> =Emerald=20Admin 2.1.0
> Emerald.exe 2.1.11
>
> I have run the =script=20Rad25_up2.sql on the 'fresh' database as advised
> somewhere in =this=20list.
>
> I have radius running as a service and am using =odbc=20authentication.
>
> With the above I can achieve a working =system,=20however I am not able
> to perform certain operations, for example =I get=20an SQL error if I
> attempt to alter the default attributes for a =service=20(and the default
> attributes get wiped!). This was not the case =prior to=20running the
> update script, however without the update script =other=20errors
> prevented any authentication because the stored =procedure
>=20getradattributes disagreed with the radattributes table structure. =In
>=20either case (ie, both before and after running the update script) =the
>=20'check database' routine reports the tables RadAttributes &=20RadValues
> (among others) have an incorrect number of =fields.

You=20can ignore the check information.  This is a bug in the Emerald=202.1
admin.  The Emerald 2.2 Admin (in the =/emerald/beta/emerald22=20directory)
will correct the problem.

> I will be happy to =provide=20more exact SQL trace info or logfile output
> with -x15 debugging =from=20radius, however I feel sure the problem lies
> in the process I am =using=20to create the database, or is it this flakey
> for =everyone?

This=20isn't a DB issue.  Its a known issue with the 2.1 admin.

--=20

Dale E. Reed Jr.  (daler@iea-software.com)
___=______________________________________________________________
------=_NextPart_000_0085_01BE1691.8E96A960--