Message 2: Re: Static IP can't surf
from "Rudy Komsic" <rudyk@cyberglobe.net>
Message 3: Re: Static IP
from "jmercer" <radiusnt@ultravision.net>
Message 4: Re: Static IP
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 5: Invalid character value for cast specification
from "George Mansoor (LS)" <ghmls@4Link.Net>
Message 6: Re: Invalid character value for cast specification
from "George Mansoor (LS)" <ghmls@4Link.Net>
Message 7: Re: Invalid character value for cast specification
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 8: Problems with Proxy from Service
from "Tony Schwartz" <tony@transport.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Static IP can't surf
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Sat, 18 Jul 1998 00:59:51 -0700
Victor A. wrote:
>
> We've assigned a Static IP address to one of our customers in Emerald and
> under the Radius Tab we've setup the following configuration:
>
> User-Service Framed-User 6 2
> Framed Protocol PPP 7 1
> Framed Address xxx.xxx.xxx.xxx 8
> Framed Netmask 255.255.255.0 9
>
> Well, the user logs on fine, Emerald shows the user with the Static IP
> but.... the user can't do anything at all!! We had him connect to our
> PR and to the PM3 no changes at all. He's unable to go onto the Internet.
>
> What else does one needs to do, the user is running Win95 and has tried
> entering the Static IP info in DUN and the Network Icon of the CP, in both
> cases same result.
The typical cause of this is assigning the user an IP that isn't on
the local ethernet of the PM or PR. At that point it turns into a
routing 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 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Static IP can't surfFrom: "Rudy Komsic" <rudyk@cyberglobe.net>Date: Sat, 18 Jul 1998 05:09:13 -0400
I had this problem and the way to resolve it EASILY was to turn on RIP on myRouter and RIP on my modem Chassis. After that Class Cs became a Breeze toset up.
-----Original Message-----From: Dale E. Reed Jr. <daler@iea-software.com>To: Victor A. <victor@webjogger.net>Cc: radiusNT@iea-software.com <radiusNT@iea-software.com>Date: July 18, 1998 4:02 AMSubject: Re: Static IP can't surf
>Victor A. wrote:>>>> We've assigned a Static IP address to one of our customers in Emerald and>> under the Radius Tab we've setup the following configuration:>>>> User-Service Framed-User 6 2>> Framed Protocol PPP 7 1>> Framed Address xxx.xxx.xxx.xxx 8>> Framed Netmask 255.255.255.0 9>>>> Well, the user logs on fine, Emerald shows the user with the Static IP>> but.... the user can't do anything at all!! We had him connect to our>> PR and to the PM3 no changes at all. He's unable to go onto the Internet.>>>> What else does one needs to do, the user is running Win95 and has tried>> entering the Static IP info in DUN and the Network Icon of the CP, in both>> cases same result.>>The typical cause of this is assigning the user an IP that isn't on>the local ethernet of the PM or PR. At that point it turns into a>routing 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 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Static IPFrom: "jmercer" <radiusnt@ultravision.net>Date: Sat, 18 Jul 1998 09:23:07 -0500
I had the same problem. Tell the user to not put the static address ineither place just log in as usual and all will work fine. Apparently thereis something about the timing, he is asking for an address and the Nasthinks it has already assigned it (maybe) In any case this works for me.
>Subject: Static IP can't surf>From: "Victor A." <victor@webjogger.net>>Date: Fri, 17 Jul 1998 17:48:52 -0400>>We've assigned a Static IP address to one of our customers in Emerald and>under the Radius Tab we've setup the following configuration:>>User-Service Framed-User 6 2>Framed Protocol PPP 7 1>Framed Address xxx.xxx.xxx.xxx 8>Framed Netmask 255.255.255.0 9>>Well, the user logs on fine, Emerald shows the user with the Static IP>but.... the user can't do anything at all!! We had him connect to our>PR and to the PM3 no changes at all. He's unable to go onto the Internet.>>What else does one needs to do, the user is running Win95 and has tried>entering the Static IP info in DUN and the Network Icon of the CP, in both>cases same result.>>Anyone knows what am I missing here....>>-Victor
Jerry MercerUltra-VisionInternet - jmercer@ultravision.net
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Static IPFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Sat, 18 Jul 1998 13:28:53 -0700
jmercer wrote:> > I had the same problem. Tell the user to not put the static address in> either place just log in as usual and all will work fine. Apparently there> is something about the timing, he is asking for an address and the Nas> thinks it has already assigned it (maybe) In any case this works for me.
Some terminal servers don't allow the client to request an address,EVEN IF its the address the terminal server is going to assign.The LCP during that is like to little kids fighting for a piece ofcandy and is prety funny (from a twisted technical point of view).
-- 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: Invalid character value for cast specificationFrom: "George Mansoor (LS)" <ghmls@4Link.Net>Date: Sat, 18 Jul 1998 21:02:13 -0700
I'm trying to test Radius 2.5 and my server will not authenticate users.It can't find them after the select to query to see if it's in thesubaccount table, there is an error that is returned:
ODBC Error:22005:0: Invalid character value for cast specification.
Any ideas on this?
George
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Invalid character value for cast specificationFrom: "George Mansoor (LS)" <ghmls@4Link.Net>Date: Sat, 18 Jul 1998 21:22:03 -0700
I found out the reason for this error. I tried to change the type ofAccountID from int to varchar (setting it the same as the login id). Thereason I did this was because I wrote a stored procedure to add accounts tomy radius database. The when the stored procedure inserts a row intosubaccounts, the identity column (accountid) isn't incremented correctly.Does anyone know how I can insert a row into subaccounts using a storedprocedure?
Thanks
George
George Mansoor (LS) wrote:
> I'm trying to test Radius 2.5 and my server will not authenticate users.> It can't find them after the select to query to see if it's in the> subaccount table, there is an error that is returned:>> ODBC Error:22005:0: Invalid character value for cast specification.>> Any ideas on this?>> George
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Invalid character value for cast specificationFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Sat, 18 Jul 1998 22:44:47 -0700
George Mansoor (LS) wrote:> > I found out the reason for this error. I tried to change the type of> AccountID from int to varchar (setting it the same as the login id). The> reason I did this was because I wrote a stored procedure to add accounts to> my radius database. The when the stored procedure inserts a row into> subaccounts, the identity column (accountid) isn't incremented correctly.
You can't do that. The accountID MUST be an integer. Its used inchecking the RadConfigs table in the authentication.
> Does anyone know how I can insert a row into subaccounts using a stored> procedure?
Just use the old fashion:
INSERT INTO SubAccounts(field1, ...) VALUES(field1, ...)
statement. Maybe I missed the original issue?
-- 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 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Problems with Proxy from ServiceFrom: "Tony Schwartz" <tony@transport.com>Date: Sat, 18 Jul 1998 22:56:52 -0700
I am making some progress in my eval of Enterprise proxying..
My problem on an NT box using SQL, I can do proxy from Debug mode but notfrom service mode. Any ideas??
Tony