Re: [Emerald] SQL7 & Emerald

Dale E. Reed Jr. ( (no email) )
Wed, 17 Feb 1999 10:46:53 -0800

Albert Churba wrote:
> I want to move our Emerald Database to SQL7. Most of the reason for this
> transition is due to a failed server. I was able to restore a 2 day old
> backup onto another SQL 6.5 machine, yet that is not a production machine.
> We currently run RadiusNT version 2.2.41 7/27/97. Any attempts to install
> the new database version of Emerald 2.5x fail apparently due to data types.
> I would also like to import the data into SQL7, yet that fails too. We
> started with Emerald 2.1.11 as the database schema, and I see many
> enhancements to the new schema. Have you prepared any white papers on such a
> transition? I have to date converted 350 hosted SQL sites from 6.5 to 7.0
> without any problems, yet Emerald is baffling me. BTW, I really like SQL
> 7.0.

SQL 7 is what I do my primary development on now, and we have several
customers using Emerald 2.5.227 and higher with it. I would need more
specific details of the problems that you are running into.

You should be able to run the Emerlad 2.5 Upgrade on your SQL 6.5
then use the SQL 7.0 Database upgrade wizard to upgrade the database
from your 6.5 server to your 7.0 server.

> We also want to finally implement Emerald for billing. We still have been
> doing it the pre Emerald way. This is now totally out of control for us. We
> have been looking into AuthorizeNet and want to toss IC Verify. Have you
> added any additional support for such systems (I can supply web based code
> if needed)? Since we never closed or billed from Emerald, the Calls table
> now contains 6.7 million records. Anytime I have issued a SQL statement to
> delete records based on a date range, SQL craps out. This brings me to

Do you have any Service Packs on your SQL Server? You should be able to
do small deletes w/out a problem.

> another point. Trying to use just the text mode with RadiusNT for the
> Emerald generated users file, RadiusNT fails to load. Has this ever been
> fixed? Also, it wants license information and doesn't accept the Emerald

I'd need to look at your users files. There is also a command based
program calls RadUsers that can create the users files much faster and
can be batched.

> keys. If I take the SQL ODBC version off-line, the text only version does

If you ignore the warning, it will run fine. That problem was fixed
in RadiusNT 2.5 (which I highly recommand you upgrade to).

> not load. How can I correct this? Taking the SQL off-line to fix the Calls
> table seems to be a prerequisite.

I'm not sure what you mean by this. Why doesn't the text only
version not load? Could you have a problem between your Emerald
dictionary and your RadiusNT dictionary that is causing an
unknown attribute? If RadiusNT is not loading the users file,
what user does it error on? What does that user's entry look like?


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list, including removal,please see