Message 2: Authentication Problem with USR/Ns8i
from "Paul Smith" <pjsmith@microtech.co.gg>
Message 3: RE: Authentication Problem with USR/Ns8i
from "John Rickabaugh" <johnr@ccois.net>
Message 4: Re: Authentication Problem with USR/Ns8i
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 5: RE: Authentication Problem with USR/Ns8i
from "Paul Smith" <pjsmith@microtech.co.gg>
Message 6: Emerald Admin: Billing Cycles
from Glen Harvy <glen@aquarius.com.au>
Message 7: Emerald Admin: Billing Cycles
from Glen Harvy <glen@aquarius.com.au>
Message 8: Emerald Admin: Billing Cycles
from Glen Harvy <glen@aquarius.com.au>
Message 9: Re: Emerald Admin: Billing Cycles
from "Dale E. Reed Jr." <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: RadiusNT and USR-TC
From: "Peter D. Mayer" <dmayer@netwalk.com>
Date: Sun, 16 Aug 1998 08:24:53 -0400
I just added my first VSA to the RadAttributes table
(Final_TX_Data_Link_Rate USR attribute 0x006B (107)), and before I added it
to my calls table, I checked the -x15 output and saw
"Final_TX_Data_Link_Rate = 429" 8 times in each accounting request. Is this
normal?
My entry in RadAttributes looks like this:
RadAttributeID, Name, Type, RadVendorID, RadVendorType
26, Final_Tx_Link_Data_Rate, 1, 429, 107
I don't want to add the FinalTXDataLinkRate column to the calls table until
I'm sure it's going to work (rebuilding a 1 million record table just to
remove a crap column is not fun :( ) Also, is it possible to put the
lookup values for these attributes in the RadValues table? Maybe just use
the number of the attribute itself (107) since there are no RadVendor
fields?
Thanks,
Peter D. Mayer
NetWalk Tech Support
dmayer@netwalk.com
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: Saturday, August 15, 1998 2:46 AM
Subject: Re: RadiusNT and USR-TC
>Lamar Townsend wrote:
>>
>> Before I sit back and stick all of the USR VSA's into my dictionary file
>> has anyone out there already done this? And if so could I get a copy of
>> your RADIUS dictionary?
>>
>> What can I say, I'm getting lazy,
>
>I haven't done all of them, but I did as a few of the more popular ones
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Authentication Problem with USR/Ns8i
From: "Paul Smith" <pjsmith@microtech.co.gg>
Date: Sun, 16 Aug 1998 19:09:09 +0100
I am having a problem trying to authenticate users with Radius NT. As far
as I can see RADIUS NT is authenticating the user. But if you dial in the
call eventually gets dropped, windows saying 'it can't negotiate a
compatible set of network protocols'.
Can anyone tell me if this did authenticate or not, and if it did does
anyone have any ideas why the Netserver doesn't seem to accept the call.
Thanks
radrecv: Request from host c0a80066 code=1, id=125, length=71
User-Name = "support"
Password = "\263\202\274,\273b\204|\217\022((\377\0272\020"
NAS-Identifier = 192.168.0.102
NAS-Port = 2
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = "\263\202\274,\273b\204|\217\022((\377\0272\020"
SQL Statement: Select DateDiff('n', Now, DateAdd('d', ma.Extension+1,
maExpireD
ate)), DateDiff('n', Now, DateAdd('d', ma.Extension+1, maExpireDate)),
sa.Accoun
tID, sa.AccountType, sa.Password, sa.Login, sa.Shell From MasterAccounts ma,
Sub
Accounts sa Where (sa.Login='support' or sa.Shell='support') AND
ma.CustomerID=
sa.CustomerID and sa.Active<>0 and ma.Active<>0
Decrypted Password: micro1
Database Password: micro1
Checking for duplicate logins.
SQL Statement: Select Count(Username) From ServerPorts Where
Username='support'
and AcctStatusType=1
support found on-line 0 time(s).
SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type,
rc.RadVendorI
D, rc.RadVendorType, rc.RadCheck From RadConfigs rc, RadAttributes ra Where
ra.R
adAttributeID=rc.RadAttributeID AND rc.AccountID=35
Loading radius defaults for this type...
SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type,
rc.RadVendorI
D, rc.RadVendorType, rc.RadCheck From RadATConfigs rc, RadAttributes ra
Where ra
..RadAttributeID=rc.RadAttributeID AND rc.AccountType='PPP'
Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Session-Timeout = Session-Timeout (28800)
Framed-Compression = Frames-Compression (1)
Idle-Timeout = Idle-Timeout (2400)
Sending Ack of id 125 to c0a80066 (ns1.microtech.co.gg)
Framed-Protocol = PPP
User-Service = Framed-User
Session-Timeout = 28800
Framed-Compression = Van-Jacobsen-TCP-IP
Idle-Timeout = 2400
Resp Time: 271 Auth: 2/0 -> 2 Acct: 1/0/0 -> 1
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Authentication Problem with USR/Ns8i
From: "John Rickabaugh" <johnr@ccois.net>
Date: Sun, 16 Aug 1998 12:45:03 -0600
Check the dial in machine and see if TCP/IP is loaded. It is getting
authenticated
> -----Original Message-----
> From: radiusnt-request@iea-software.com
> [mailto:radiusnt-request@iea-software.com]On Behalf Of Paul Smith
> Sent: Sunday, August 16, 1998 12:09 PM
> To: radiusnt@iea-software.com
> Subject: Authentication Problem with USR/Ns8i
>
>
> I am having a problem trying to authenticate users with Radius NT. As far
> as I can see RADIUS NT is authenticating the user. But if you dial in the
> call eventually gets dropped, windows saying 'it can't negotiate a
> compatible set of network protocols'.
>
> Can anyone tell me if this did authenticate or not, and if it did does
> anyone have any ideas why the Netserver doesn't seem to accept the call.
>
> Thanks
>
> radrecv: Request from host c0a80066 code=1, id=125, length=71
> User-Name = "support"
> Password = "\263\202\274,\273b\204|\217\022((\377\0272\020"
> NAS-Identifier = 192.168.0.102
> NAS-Port = 2
> User-Service = Framed-User
> Framed-Protocol = PPP
> rad_authenticate_ODBC()
> Password = "\263\202\274,\273b\204|\217\022((\377\0272\020"
>
> SQL Statement: Select DateDiff('n', Now, DateAdd('d', ma.Extension+1,
> maExpireD
> ate)), DateDiff('n', Now, DateAdd('d', ma.Extension+1, maExpireDate)),
> sa.Accoun
> tID, sa.AccountType, sa.Password, sa.Login, sa.Shell From
> MasterAccounts ma,
> Sub
> Accounts sa Where (sa.Login='support' or sa.Shell='support') AND
> ma.CustomerID=
> sa.CustomerID and sa.Active<>0 and ma.Active<>0
>
> Decrypted Password: micro1
> Database Password: micro1
> Checking for duplicate logins.
>
> SQL Statement: Select Count(Username) From ServerPorts Where
> Username='support'
> and AcctStatusType=1
>
> support found on-line 0 time(s).
>
> SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type,
> rc.RadVendorI
> D, rc.RadVendorType, rc.RadCheck From RadConfigs rc,
> RadAttributes ra Where
> ra.R
> adAttributeID=rc.RadAttributeID AND rc.AccountID=35
>
> Loading radius defaults for this type...
>
> SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type,
> rc.RadVendorI
> D, rc.RadVendorType, rc.RadCheck From RadATConfigs rc, RadAttributes ra
> Where ra
> .RadAttributeID=rc.RadAttributeID AND rc.AccountType='PPP'
>
> Framed-Protocol = PPP (1)
> User-Service = Framed-User (2)
> Session-Timeout = Session-Timeout (28800)
> Framed-Compression = Frames-Compression (1)
> Idle-Timeout = Idle-Timeout (2400)
> Sending Ack of id 125 to c0a80066 (ns1.microtech.co.gg)
> Framed-Protocol = PPP
> User-Service = Framed-User
> Session-Timeout = 28800
> Framed-Compression = Van-Jacobsen-TCP-IP
> Idle-Timeout = 2400
>
> Resp Time: 271 Auth: 2/0 -> 2 Acct: 1/0/0 -> 1
>
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Authentication Problem with USR/Ns8i
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Sun, 16 Aug 1998 12:01:57 -0700
Paul Smith wrote:
>
> I am having a problem trying to authenticate users with Radius NT. As far
> as I can see RADIUS NT is authenticating the user. But if you dial in the
> call eventually gets dropped, windows saying 'it can't negotiate a
> compatible set of network protocols'.
>
> Can anyone tell me if this did authenticate or not, and if it did does
> anyone have any ideas why the Netserver doesn't seem to accept the call.
RadiusNT did authenticate the request. I would check the dial in
setting of DUN, since that is usually what causes that problem.
-- 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: RE: Authentication Problem with USR/Ns8iFrom: "Paul Smith" <pjsmith@microtech.co.gg>Date: Sun, 16 Aug 1998 20:51:06 +0100
Thanks for that. Turned out I wasn't getting assigned an IP address
-----Original Message-----From: radiusnt-request@iea-software.com[mailto:radiusnt-request@iea-software.com]On Behalf Of Dale E. Reed Jr.Sent: 16 August 1998 20:02To: radiusnt@iea-software.comSubject: Re: Authentication Problem with USR/Ns8i
Paul Smith wrote:>> I am having a problem trying to authenticate users with Radius NT. As far> as I can see RADIUS NT is authenticating the user. But if you dial in the> call eventually gets dropped, windows saying 'it can't negotiate a> compatible set of network protocols'.>> Can anyone tell me if this did authenticate or not, and if it did does> anyone have any ideas why the Netserver doesn't seem to accept the call.
RadiusNT did authenticate the request. I would check the dial insetting of DUN, since that is usually what causes that problem.
--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 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Emerald Admin: Billing CyclesFrom: Glen Harvy <glen@aquarius.com.au>Date: Mon, 17 Aug 1998 11:43:18 +1000
Hi Dale,
By way of background, I charge my customers on the 15th Monthly and havedone so for years. If someone joins up in between dates then I make anappropriate adjustment to their hours and/or charge.
I thought I had everything properly configured however when I ran callconsolidation, all the call details prior to August 1st was deleted fromthe CALLS table.
I presume that I didn't setup Emerald properly in that the billing cycleshould have been "anniversary" rather than "monthly" (I got thatinformation from the Database Schema). On trying to check this, when I tryto click on the tab I get:
SQL Server Error: 208 Invalid object name 'BillingCycles' State=1,Severity=16.
As the documentation for 2.1 doesn't even show this tab/option, I presumeit's yet to be implemented.
The problem I now have is that the call data from 15th July to 1st Augusthas "disappeared"! Is there anyway I can get extract this data?
Compounding the problem I have is that I allow my callers to access theCALLS table so they can monitor their time usage. I realise this table iscleared when ever a Call Consolidation takes place - it was for that reasonI only intended on running Call Consolidation on the 15th of the month.
The documentation infers that a users call data is saved in the users owndatabase. Is this correct? If it is, I could run Call Consolidation dailyand allow my users access to their own database.
I presume that by changing the "Billing Cycle" (when I can change it) asabove then I will be able to continue with my practice of 15th monthly.
Glen.--------------------------------------------------------------------AQUARIUS Communications for all your Internet<>Fidonet needs <>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailervoice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930http://www.aquarius.com.au <> mailto:sales@aquarius.com.au
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Emerald Admin: Billing CyclesFrom: Glen Harvy <glen@aquarius.com.au>Date: Mon, 17 Aug 1998 12:08:31 +1000
Hi Dale,
Just discovered that clicking on OK for the Error Message and then clickingon "Add" at least solved that problem.
Can you please describe the three options presented and also the "PreBill:" options.
Thanks.
Glen.--------------------------------------------------------------------AQUARIUS Communications for all your Internet<>Fidonet needs <>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailervoice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930http://www.aquarius.com.au <> mailto:sales@aquarius.com.au
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Emerald Admin: Billing CyclesFrom: Glen Harvy <glen@aquarius.com.au>Date: Mon, 17 Aug 1998 13:14:10 +1000
Sorry, forgot to add that I can't save a new one either.
--------------------------------------------------------------------------Hi Dale,
Just discovered that clicking on OK for the Error Message and then clickingon "Add" at least solved that problem.
Can you please describe the three options presented and also the "PreBill:" options.
Thanks.
Glen.--------------------------------------------------------------------AQUARIUS Communications for all your Internet<>Fidonet needs <>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailervoice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930http://www.aquarius.com.au <> mailto:sales@aquarius.com.au
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald Admin: Billing CyclesFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Sun, 16 Aug 1998 23:22:38 -0700
This isn't really a RadiusNT issue is it? This should be on theEmerald Mailing list. Please use it for followups. I really try tokeep Emerald specific issues on the Emerald list, since we haveRadiusNT customers on this list who don't use Emerald.
Glen Harvy wrote:> > By way of background, I charge my customers on the 15th Monthly and have> done so for years. If someone joins up in between dates then I make an> appropriate adjustment to their hours and/or charge.
Do you bill on the 15th for the 15th-15th or on the 15th for the1st-1st? > I thought I had everything properly configured however when I ran call> consolidation, all the call details prior to August 1st was deleted from> the CALLS table.
This sounds like an Emerlad 2.1 issue. If you use Emerald 2.2, theconsolidation will correctly align on the expiration date. > I presume that I didn't setup Emerald properly in that the billing cycle> should have been "anniversary" rather than "monthly" (I got that> information from the Database Schema). On trying to check this, when I try> to click on the tab I get:
Billing cycles are NOT implemented in Emerald 2.2 and lower. Ignore thetab in the Admin. > The problem I now have is that the call data from 15th July to 1st August> has "disappeared"! Is there anyway I can get extract this data?
Not unless you have a backup. > The documentation infers that a users call data is saved in the users own> database. Is this correct? If it is, I could run Call Consolidation daily> and allow my users access to their own database.
I don't follow the above, and if it is in the docs, its wrong. Thereis now users database. There is a CallHistory Table that shows summaryinformation for prior usage.
-- 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