Message 2: RE: Something strange
from "Robert H. Clugston" <robert@csnsys.com>
Message 3: Immediate Help - Dead - Over License Limit
from Albert Churba <Albert@dialisdn.com>
Message 4: Re: Question about BESS proxy server
from Dale Reed <daler@iea-software.com>
Message 5: Radius 25 help please.
from Eric Jensen <ejensen@accnorwalk.com>
Message 6: RE: Immediate Help - Dead - Over License Limit
from "Bill Bongiorno" <bill@systec.com>
Message 7: RE: Immediate Help - Dead - Over License Limit
from Albert Churba <Albert@dialisdn.com>
Message 8: Re: Radius 25 help please.
from Dale Reed <daler@iea-software.com>
Message 9: Re: Radius 25 help please.
from Dale Reed <daler@iea-software.com>
Message 10: unsubscribe emerald
from James <daj4@mcmedia.com.au>
Message 11: unsubscribe emerald
from Lindsay Blume <lindsay@opera.iinet.net.au>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Question about BESS proxy server
From: "OTR Communications, LLC" <otrcomm@sedona.net>
Date: Fri, 12 Jun 1998 07:54:37
We are a new start ISP and will be offering clients optional access to the
internet through a BESS proxy filter developed by N2H2. I have been told
that it is possible to point these clients to the BESS proxy by selecting
one of the RADIUS attributes under the SERVICES tab of the MBR. I was told
that this particular ATTRIBUTE and associated VALUE will instruct my
Portmaster3 to point this particular client to the gateway for the BESS
proxy. Does anyone know if this will work, and if it will, what is the
ATTRIBUTE to select?
Also, how can I change the First and Last names associated with an MBR?
Once the MBR is initially setup and saved, I have not been able to change
the names. I can change the name on the Master Billing Information card,
but it does not update whatever database the original MBR is stored in.
The name does stayed in the Master Billing Information card, but the Search
button in the Main Emerald menu finds the old record with the original
First and Last names. What kind of database structure are these records
stored in? Where are they located? Can I change the information in SQL?
How?
Thanks,
Murrah Boswell
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Something strange
From: "Robert H. Clugston" <robert@csnsys.com>
Date: Fri, 12 Jun 1998 11:16:43 -0700
Dear Dusan,
Sounds like your radius server is dying. Maybe you are low on ram,
processor speed, or hard drive space. Run a program in the foreground is a
lot less processor intensive that running in the background.
I use Norton System Doctor to monitor system resources. It does a lot
better job than the tools that come with NT.
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Dusan Janjic
Sent: Thursday, June 11, 1998 6:18 PM
To: emerald@emerald.iea.com
Subject: Something strange
Hi Dale and all
Maybe it is just a coincidence but today we have switched our service to
PRI lines and our authentication stopped working when Radius is running
as a service. Radius -x15 works fine. As soon as I stop it from DOS
prompt it no longer works. To make things worst Dr. Watson jumps
inexplicably and after that nothing works. I have adjusted parameters in
Radius tab done a "report" command. Have exact number of ports. I am
running RadiusNT 2.2. Portmasters 3, Emerald 2.2.23 and Emerald Admin
2.2.19. What am I missing?
I need urgent help!!!! Thanks.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Immediate Help - Dead - Over License Limit
From: Albert Churba <Albert@dialisdn.com>
Date: Fri, 12 Jun 1998 15:27:03 -0400
Dale,
We were entering some more accounts in Emerald when all of a sudden we got
a prompt saying we have exceeded our license limit and have been shut out
of Emerald completely. The message says we are 2 over our limit. We called
sales, only to get a recording. We need to purchase an additional 500
licensees NOW.
How would the software allow us to enter over our limit?
Thank you,
Albert Churba, President
Dial ISDN, Inc.
Phone 954-424-9991
Fax 954-452-3592
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Question about BESS proxy server
From: Dale Reed <daler@iea-software.com>
Date: Fri, 12 Jun 1998 12:40:07 -0700
OTR Communications, LLC wrote:
>
> We are a new start ISP and will be offering clients optional access to the
> internet through a BESS proxy filter developed by N2H2. I have been told
> that it is possible to point these clients to the BESS proxy by selecting
> one of the RADIUS attributes under the SERVICES tab of the MBR. I was told
> that this particular ATTRIBUTE and associated VALUE will instruct my
> Portmaster3 to point this particular client to the gateway for the BESS
> proxy. Does anyone know if this will work, and if it will, what is the
> ATTRIBUTE to select?
I'm guessing they are talking about filters, to prevent the custmoer
from just getting around the proxy server. So you are probably
looking for Framed-Filter. Does BESS comes with any documentation
pertaining to this?
> Also, how can I change the First and Last names associated with an MBR?
> Once the MBR is initially setup and saved, I have not been able to change
> the names. I can change the name on the Master Billing Information card,
> but it does not update whatever database the original MBR is stored in.
> The name does stayed in the Master Billing Information card, but the Search
> button in the Main Emerald menu finds the old record with the original
> First and Last names. What kind of database structure are these records
> stored in? Where are they located? Can I change the information in SQL?
> How?
When you are searching both the MBR and service, the service information
is displayed in the results. Therefore, you need to change the SERVICE
information as well as the MBR information. Edit the service and go to
the personal tab. Change that name as well.
-- 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 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Radius 25 help please.From: Eric Jensen <ejensen@accnorwalk.com>Date: Fri, 12 Jun 1998 15:49:11 -0400
I upgraded to Radius 2.5 and used the Radius_25_124_Update files. I alsoused the rad25_up.sql script to update the database. Users can loginwithout a problem and everything seems to be running ok. Except for thefollowing errors in the logfile:
Fri Jun 12 11:07:20 1998: ODBC Error:23000:547: [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__RadLogs__RadLogM__0642F512'. The conflict occurred in database 'Emerald', table 'RadLogMsgs', column 'RadLogMsgID'
Fri Jun 12 14:55:45 1998: ODBC Error:37000:103: [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts with '`o' is too long. Maximum length is 30.
Why am I getting these errors and what can I do to correct them? Thanks in advanced!Eric Jensen
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Immediate Help - Dead - Over License LimitFrom: "Bill Bongiorno" <bill@systec.com>Date: Fri, 12 Jun 1998 16:09:30 -0400
A temporary work around is to consolidate a bunch of accounts as separateservices under a single account. Once the license is available you can thendo things properly. Of course, this won't work for billing, but at least thenew users will have access to the service.
Bill BongiornoSysTec Computer Associates, Inc.
> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Albert Churba> Sent: Friday, June 12, 1998 3:27 PM> To: 'emerald@iea-software.com'> Subject: Immediate Help - Dead - Over License Limit>>> Dale,>> We were entering some more accounts in Emerald when all of a> sudden we got> a prompt saying we have exceeded our license limit and have been shut out> of Emerald completely. The message says we are 2 over our limit.> We called> sales, only to get a recording. We need to purchase an additional 500> licensees NOW.>> How would the software allow us to enter over our limit?>>> Thank you,> Albert Churba, President> Dial ISDN, Inc.> Phone 954-424-9991> Fax 954-452-3592>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Immediate Help - Dead - Over License LimitFrom: Albert Churba <Albert@dialisdn.com>Date: Fri, 12 Jun 1998 16:14:05 -0400
Thanks, but the problem is we are all locked out of Emerald and can not do anything.
-----Original Message-----From: Bill Bongiorno [SMTP:bill@systec.com]Sent: Friday, June 12, 1998 4:10 PMTo: emerald@iea-software.comSubject: RE: Immediate Help - Dead - Over License Limit
A temporary work around is to consolidate a bunch of accounts as separateservices under a single account. Once the license is available you can thendo things properly. Of course, this won't work for billing, but at least thenew users will have access to the service.
Bill BongiornoSysTec Computer Associates, Inc.
> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Albert Churba> Sent: Friday, June 12, 1998 3:27 PM> To: 'emerald@iea-software.com'> Subject: Immediate Help - Dead - Over License Limit>>> Dale,>> We were entering some more accounts in Emerald when all of a> sudden we got> a prompt saying we have exceeded our license limit and have been shut out> of Emerald completely. The message says we are 2 over our limit.> We called> sales, only to get a recording. We need to purchase an additional 500> licensees NOW.>> How would the software allow us to enter over our limit?>>> Thank you,> Albert Churba, President> Dial ISDN, Inc.> Phone 954-424-9991> Fax 954-452-3592>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Radius 25 help please.From: Dale Reed <daler@iea-software.com>Date: Fri, 12 Jun 1998 14:27:09 -0700
Eric Jensen wrote:> > I upgraded to Radius 2.5 and used the Radius_25_124_Update files. I also> used the rad25_up.sql script to update the database. Users can login> without a problem and everything seems to be running ok. Except for the> following errors in the logfile:> > Fri Jun 12 11:07:20 1998: ODBC Error:23000:547:> [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement> conflicted with COLUMN FOREIGN KEY constraint> 'FK__RadLogs__RadLogM__0642F512'. The conflict occurred in database> 'Emerald', table 'RadLogMsgs', column 'RadLogMsgID'
This is most likely because your RadLogMsgs table is empty. You canpopulate it with the following statements (execute in isql_w on yourEmerald database).
INSERT RadLogMsgs VALUES(0, "Generic Message", 0)INSERT RadLogMsgs VALUES(1, "Generic Error", 5)
INSERT RadLogMsgs VALUES(10, "User Not Found", 3)INSERT RadLogMsgs VALUES(11, "Bad Password", 3)INSERT RadLogMsgs VALUES(12, "User Expired", 2)INSERT RadLogMsgs VALUES(13, "User OverDue", 2)INSERT RadLogMsgs VALUES(14, "Over Login Limit", 1)INSERT RadLogMsgs VALUES(15, "No Time Left", 1)INSERT RadLogMsgs VALUES(16, "Port Not Allowed", 2)INSERT RadLogMsgs VALUES(19, "No Attributes", 3)
INSERT RadLogMsgs VALUES(50, "Bad Request", 4)INSERT RadLogMsgs VALUES(51, "No Username", 4)INSERT RadLogMsgs VALUES(52, "No Password", 4)INSERT RadLogMsgs VALUES(53, "Bad Digest", 6)
INSERT RadLogMsgs VALUES(60, "Parse Error", 5)INSERT RadLogMsgs VALUES(100, "Chap Not Allowed", 5)
GO > Fri Jun 12 14:55:45 1998: ODBC Error:37000:103:> [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that> starts with '`o' is too long. Maximum length is 30.
I'm not sure which table/field this is. Its possible that this iscaused by a garbage RadLogs entry, 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
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Radius 25 help please.From: Dale Reed <daler@iea-software.com>Date: Fri, 12 Jun 1998 14:27:09 -0700
Eric Jensen wrote:> > I upgraded to Radius 2.5 and used the Radius_25_124_Update files. I also> used the rad25_up.sql script to update the database. Users can login> without a problem and everything seems to be running ok. Except for the> following errors in the logfile:> > Fri Jun 12 11:07:20 1998: ODBC Error:23000:547:> [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement> conflicted with COLUMN FOREIGN KEY constraint> 'FK__RadLogs__RadLogM__0642F512'. The conflict occurred in database> 'Emerald', table 'RadLogMsgs', column 'RadLogMsgID'
This is most likely because your RadLogMsgs table is empty. You canpopulate it with the following statements (execute in isql_w on yourEmerald database).
INSERT RadLogMsgs VALUES(0, "Generic Message", 0)INSERT RadLogMsgs VALUES(1, "Generic Error", 5)
INSERT RadLogMsgs VALUES(10, "User Not Found", 3)INSERT RadLogMsgs VALUES(11, "Bad Password", 3)INSERT RadLogMsgs VALUES(12, "User Expired", 2)INSERT RadLogMsgs VALUES(13, "User OverDue", 2)INSERT RadLogMsgs VALUES(14, "Over Login Limit", 1)INSERT RadLogMsgs VALUES(15, "No Time Left", 1)INSERT RadLogMsgs VALUES(16, "Port Not Allowed", 2)INSERT RadLogMsgs VALUES(19, "No Attributes", 3)
INSERT RadLogMsgs VALUES(50, "Bad Request", 4)INSERT RadLogMsgs VALUES(51, "No Username", 4)INSERT RadLogMsgs VALUES(52, "No Password", 4)INSERT RadLogMsgs VALUES(53, "Bad Digest", 6)
INSERT RadLogMsgs VALUES(60, "Parse Error", 5)INSERT RadLogMsgs VALUES(100, "Chap Not Allowed", 5)
GO > Fri Jun 12 14:55:45 1998: ODBC Error:37000:103:> [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that> starts with '`o' is too long. Maximum length is 30.
I'm not sure which table/field this is. Its possible that this iscaused by a garbage RadLogs entry, 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
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: unsubscribe emeraldFrom: James <daj4@mcmedia.com.au>Date: Sat, 13 Jun 1998 15:59:37 +1000 (EST)
unsubscribe emerald
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: unsubscribe emeraldFrom: Lindsay Blume <lindsay@opera.iinet.net.au>Date: Sat, 13 Jun 1998 12:57:17 +0800 (WST)