Message 2: Re: Database Size.
from Dale Reed <daler@iea-software.com>
Message 3: Re: Multiple IP address pools
from Dale Reed <daler@iea-software.com>
Message 4: Re: Opinion on Replication
from Victor Alba <victor@webjogger.net>
Message 5: Re: can't create invoice
from Jim Dunmyer <jdunmyer@toltbbs.com>
Message 6: RE: EmerAuth & Serv-U
from Ray Carpenter <ray@systec.com>
Message 7: Re: NTMail Authentication not working
from Thomas Massano <ThomasM@InletCorp.com>
Message 8: SQL servers other than Microsoft
from "Robert H. Clugston" <robert@csnsys.com>
Message 9: delay on accounting packet.
from "Ed Miller" <emiller@del.net>
Message 10: Re: SQL servers other than Microsoft
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 11: Re: delay on accounting packet.
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 12: Re: EmerAuth & Serv-U
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 13: Re: Opinion on Replication
from "Dale E. Reed Jr." <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: NTMail -Emerald
From: Dale Reed <daler@iea-software.com>
Date: Fri, 19 Jun 1998 00:58:22 -0700
Waldemar Born wrote:
>
> How safe is this?
Well, its probably not as fun as Russian Roulette?
> Does ist make life easier? ;)
That depends on whether you like double-entering information.
> Will there be any problems with my current installation? (several domains
> configured)
Nope. The DLL interface fully supports multiple domains and being able
to specify the email address of a domain that is NOT your primary
address.
> I'm currently not sure, how this dll works... Do I need to create the users
> in NTMail or Emerald?
Just in Emerald. NTMail will consult the DLL if it can not find the
user locally.
-- 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: Re: Database Size.From: Dale Reed <daler@iea-software.com>Date: Fri, 19 Jun 1998 01:01:14 -0700
> Kelly Wright wrote:> > We have about 350 MBRs and appoaching 200Meg in size. I have run the> SQL scripts to delete the call records with little effect. I know> there is something else that needs to be done but don't know. I> figure the db should be about 60-70 Meg in size.> > Is there any other maintenance that needs to be done. I have> seperated the logs for the emerald db so I know it is not the logs.
The only table in Emerald that grows that large is your callstable. In Enterprise Manager, drill down to your calls table,riight-click and select indexes. It will tell you the size andnumber of records. If there is a significant discrepency betweenthe two, you should run the checkdb.sql script (/emerald/beta)on your database. By significant, I mean also after taking intoaccount that your typical database excluding the calls table isusually not more than about 20mb. Therefore if you DB shows 400mbused, and your calls table is only hoilding 150mb, then you shouldrun the checkdb.sql script.
-- 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 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Multiple IP address poolsFrom: Dale Reed <daler@iea-software.com>Date: Fri, 19 Jun 1998 01:08:34 -0700
> Joe Bissot wrote:> > I am evaluating Emerald for use with my ISP service. We have one> requirement> that I can't seem to get straight, maybe you could help me. We have> some> businesses that purchase blocks of dial up accounts. All those account> need> to be assigned an address from a specific address pool. So group one> would> have IP subnet 1 and group 2 would have IP subnet 2 etc... It seems> that I> can do this with Emerald but that it only works with certain access> concentrators.
The issue is that RadiusNT/Emerald does not currently supportingmanaging your IP Pools. This is best done the NAS itself for manytechnical reasons. Any NAS that supports configuring multiple IPpools and being able to specify one of the pools (like Ascend, andpossibly USR) will work fine for this.
-- 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 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Opinion on ReplicationFrom: Victor Alba <victor@webjogger.net>Date: Fri, 19 Jun 1998 07:57:03 -0400
At 08:25 AM 6/19/98 +0200, you wrote:>It depends on the amount of activity within the database, but as long >as you don't replicate things like the calls table, it is no problem. >We have it running for just on 7000 users, simply replicating the >required tables for authentication. Note that it is not necessary to >replicate all the tables, if you are only using it for >authentication.>>Regards,> Graeme
What tables are needed to replicate only for authentication, I'm about todo this and your answer will be very useful, thanks.
-Victor
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: can't create invoiceFrom: Jim Dunmyer <jdunmyer@toltbbs.com>Date: Fri, 19 Jun 1998 08:04:08 -0400
At 02:52 PM 6/18/98 -0700, you wrote:>Jim Dunmyer wrote:>> >> I have an account that hasn't had an invoice created for it. The Expire>> date is 5/25, but it doesn't matter what I set it to, attempting "Invoice>> Next Term" gives me "No new Invoices to Create!".
>Check to see if there is an invoice with an end date after>the expire date. Also, make sure its Active, has active
You hit it right on the head. The account was changed from our 3-month planto a one-month plan and there was an old invoice that was VOIDed. DELETEingit took care of the problem.
Thanks!! <<Jim>>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: EmerAuth & Serv-UFrom: Ray Carpenter <ray@systec.com>Date: Fri, 19 Jun 1998 09:16:13 -0400
Due to the lack of response from Dale & company, I guess one would have toassume that Serv-U and EmerAuth.dll do not work together. Is there anyplans to fix this in the future?
At 05:21 PM 6/18/98 +0100, you wrote:>Hi,>The EmerAuth.dll loads ok on my installation but, as soon as serv_u tries to>auth a user it crashes serv_u ?>Anyone solved this problem ?>The Auth log does not give any clues as far as I can see.>>The reg entries have been added as per doc...>Thanks>Julian Dyer>Athene Internet>>>>> -----Original Message----->> From: emerald-request@iea-software.com>> [mailto:emerald-request@iea-software.com]On Behalf Of Ray Carpenter>> Sent: 18 June 1998 17:17>> To: emerald@iea-software.com>> Subject: EmerAuth & Serv-U>>>>>> Hi All,>>>> I tried to upgrade serv-u from emer_su.dll to the new emerauth.dll and>> serv-u reports that it cannot load or find emerauth.dll. This was working>> fine with the previous emer_su.dll. I added the reg entries from the docs>> and created the storedproc verifyftpuser. I also added the homedirlimit>> column in the db.>>>> Does anyone have any ideas? Is this working anywhere?>>>> TIA>> Ray Carpenter>>>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: NTMail Authentication not workingFrom: Thomas Massano <ThomasM@InletCorp.com>Date: Fri, 19 Jun 1998 10:37:09 -0400
At 04:56 PM 6/18/98 , you wrote:>Thomas Massano wrote:>> >> Added the ESID registry value of 1 to the radius registry. I do not know if>> this is it for sure, but it was the only external i created, so i guessed>> it must be 1.>>Open up isql_w and run this query. You are looking for the >ExternalSystemID field for the NTMail entry:>>Select * From ExternalSystems
Returned 1
>> Also changed the user name to sa and gave it the appropriate password.>> Created an ODBC System DSN called Radius and pointed it to the SQL server.>>Did you configure the ODBCDataSource registry entry to point to that>DSN? Does RadiusNT run against the database correctly?
Yes it is Radius. Yes it does.
>> I apologize i have no idea how to trace the odbc to see if it is working.>> But i set it up exactly like i did on the serv-u ftp server and that one>> works. The ntmail works if i create a user in ITs user DB. I am using the>> same user id and pass i used to test the ascend and the serv-u.>>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.
Initializing Winsock...ODBC Datasource: 'Radius'...Making ODBC Connection...MS SQL Server Mode EnabledODBC Datasource: 'Radius'...Making ODBC Connection...MS SQL Server Mode EnabledLicensed MBRs: 500Accounting Column 0 (16): 'NASIdentifier'Accounting Column 1 (4): 'NASPort'Accounting Column 2 (10): 'AcctSessionID'Accounting Column 3 (1): 'AcctStatusType'Accounting Column 4 (16): 'CallDate'Accounting Column 5 (32): 'UserName'Accounting Column 6 (1): 'UserService'Accounting Column 7 (4): 'AcctDelayTime'Accounting Column 8 (4): 'AcctSessionTime'Accounting Column 9 (4): 'FramedProtocol'Accounting Column 10 (16): 'FramedAddress'Accounting Column 11 (4): 'AcctInputOctets'Accounting Column 12 (4): 'AcctOutputOctets'Accounting Column 13 (1): 'AcctTerminateCause'Accounting Column 14 (1): 'NASPortType'Accounting Column 15 (10): 'NASPortDNIS' 16 Accounting Columns Loaded
Enterprise features enabled.
RadiusNT (Emerald Standard) Initialized...
Jun 19 10:29:45 1998 VerifyUser josh:TheJetty.com:23482788Jun 19 10:29:45 1998 VerifyUser Error: 3
Thomas
..........................................................................Inlet Corporation http:\\www.InletCorp.com800-34-INLET
I am not one who was born in the possession of knowledge; I am one who isfond of antiquity, and earnest in seeking it there. Confucius 551-479 B.C.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: SQL servers other than MicrosoftFrom: "Robert H. Clugston" <robert@csnsys.com>Date: Fri, 19 Jun 1998 10:56:04 -0700
List, Has anyone put their SQL database on a Linux box using mySQL. Since it isODBC compliant this shouldn't be to hard. I've also seen a mySQL servers inproduction. It is many, many times faster than Microsoft SQL.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: delay on accounting packet.From: "Ed Miller" <emiller@del.net>Date: Fri, 19 Jun 1998 13:55:19 -0400
With a Livingston PM3, how do you set the delay for the accounting packet.We have about 8 bouncing from our new pm3 and I need to get rid of them.
Ed Miller, PresidentDel.Net/IDV.NetInterNet Delaware, Inc.Web Hosting, ProgrammingDial-up and Dedicated Access"Make the Connection"Voice (302) 737-1001Fax (302) 737-1000http://del.nethttp://idv.net
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL servers other than MicrosoftFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 19 Jun 1998 11:34:23 -0700
Robert H. Clugston wrote:> > Has anyone put their SQL database on a Linux box using mySQL. Since it is> ODBC compliant this shouldn't be to hard. I've also seen a mySQL servers in> production. It is many, many times faster than Microsoft SQL.
At present it would be pretty challenging to run Emerald against anything except MS SQL Server, since Emerald uses the native DB-LIBinterface (which I really doubt mySQL does). The v3 release ofEmerald will work against other databases than MS and will beODBC compatable. On a true comaparison of database systems, SQL Server holds its own against sybase and Oracle. I'm sureits possible to trim a lot of the features to get better speed, but do you really want to run your mission criticalapplications on that kind of a database system?
-- 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 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: delay on accounting packet.From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 19 Jun 1998 11:36:07 -0700
Ed Miller wrote:> > With a Livingston PM3, how do you set the delay for the accounting packet.> We have about 8 bouncing from our new pm3 and I need to get rid of them.
You can't. Until the next major ComOS release, Livingston doesn'tlet their users "think". Its not a bad concept (no rope to hangyourself) but it can cause some other issues. If its Admin loginsor accounting start/stop (not session start/stop) records, thenRadiusNT 2.5 should ack them (although you may need to put somedefaults in your database).
-- 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 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: EmerAuth & Serv-UFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 19 Jun 1998 14:49:08 -0700
Ray Carpenter wrote:> > Due to the lack of response from Dale & company, I guess one would have to> assume that Serv-U and EmerAuth.dll do not work together. Is there any> plans to fix this in the future?
I am in the process of checking on it. I just got an installingwhere I could test it, but haven't had a chance to dig into it.Just because I don't respond to a message immediately, doesn't meanI'm not looking into it.
-- 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 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Opinion on ReplicationFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 19 Jun 1998 14:52:30 -0700
Victor Alba wrote:> > What tables are needed to replicate only for authentication, I'm about to> do this and your answer will be very useful, thanks.
Only those tables/fields lists in the RadiusNT manual are required.
-- 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