Message 2: Upograde to Radius
from iml@interconnect.net
Message 3: SQL Newbie
from Thomas Massano <ThomasM@InletCorp.com>
Message 4: Re: SQL Newbie
from "Richard Sensale" <richards@visitus.net>
Message 5: Re: Upograde to Radius
from Dale Reed <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: NTMail Authentication not working
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Sun, 21 Jun 1998 00:13:38 -0700
Thomas Massano wrote:
>
> >Define a "logfile" in the registry and the emer_ntm.dll will write
> >relevant information to that for debugging. That should help a lot.
>
> Is this a DB problem? Is there an error list description somewhere?
> Thanks for all of your help Dale.
One of the reasons we moved the EmerAuth registry entries was to split
out the logfiles. The first pary was just RadiusNT.
> Jun 19 10:29:45 1998 VerifyUser josh:TheJetty.com:23482788
> Jun 19 10:29:45 1998 VerifyUser Error: 3
The Error:3 means a database error. This can be caused by not having
the VerifyMailUser or VerifyNTMUser stored procedurs in your database.
The original emer_ntm.dll uses the VerifyNTMuser stored procedure.
The newer one (in /emerald/external/beta) uses the VerifyMailuser
stored procedure. They are the exact same proc, just different
names.
-- 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 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Upograde to RadiusFrom: iml@interconnect.netDate: Sun, 21 Jun 1998 09:33:00 -0500
We are fixing to upgrade to Radius 2.5 on our Emerald DB, however, Ihad one concern. IT is my understanding all you have to do is installRadius2.5 and then runt he radius upgrade SQL script. My question isthis.....if we have a modified calls trigger will this scriptoverwrite that trigger.
We have one now that inserts the calls table entries into acalldetails too so we have a permanent history record.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: SQL NewbieFrom: Thomas Massano <ThomasM@InletCorp.com>Date: Sun, 21 Jun 1998 11:04:01 -0400
I have certifications in Novell, Banyan and Microsoft, but when it comes toSQL I am lost. I design, setup and support these networks, so i like tothink i am no slouch. Can anyone recommend a course or a book that can helpme learn more about SQL so that i may administrate it properly? Dale hastolerated my ignorance long enough. Also, I always wondered how i could getmy web pages to talk to SQL. I have NO database expertise. Anyone give mesome pointers.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL NewbieFrom: "Richard Sensale" <richards@visitus.net>Date: Sun, 21 Jun 1998 12:08:03 -0700
There are a lot of good books on SQL. Just stop by your local computer bookstore. I think there is even a "for dummies" book on the subject which isgreat for beginners. I hesitate to recommend one specifically since peopletend to learn faster with different books, depending on that person. As forgetting web pages to access an SQL database, the easiest way is by designingan ASP page with scripting to open up the database via an ODBC DSN. How itis set up really depends on what you want the page to do. I spotted somesample scripted pages at the Emerald ftp site, so that may be a good placeto start.
Richard SensaleNetwork AdministratorVisitUs Internet, Inc.5468 Schaefer RoadDearborn, MI 48126 USA(313) 945-5588(313) 945-0202 faxhttp://www.visitus.netrichards@visitus.net-----Original Message-----From: Thomas Massano <ThomasM@InletCorp.com>To: emerald@iea-software.com <emerald@iea-software.com>Date: Sunday, June 21, 1998 2:57 AMSubject: SQL Newbie
>I have certifications in Novell, Banyan and Microsoft, but when it comes to>SQL I am lost. I design, setup and support these networks, so i like to>think i am no slouch. Can anyone recommend a course or a book that can help>me learn more about SQL so that i may administrate it properly? Dale has>tolerated my ignorance long enough. Also, I always wondered how i could get>my web pages to talk to SQL. I have NO database expertise. Anyone give me>some pointers.>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Upograde to RadiusFrom: Dale Reed <daler@iea-software.com>Date: Sun, 21 Jun 1998 10:44:25 -0700
iml@interconnect.net wrote:> > We are fixing to upgrade to Radius 2.5 on our Emerald DB, however, I> had one concern. IT is my understanding all you have to do is install> Radius2.5 and then runt he radius upgrade SQL script. My question is> this.....if we have a modified calls trigger will this script> overwrite that trigger.> > We have one now that inserts the calls table entries into a> calldetails too so we have a permanent history record.
No it won't. You can look at the script before you run itto see exactly what it does, though.
-- 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