Status now is..
I entered a couple of the ports in the ServerPorts table and when I look
at the ServerPorts table I see logged in users.. however, I do not see them
in the Emerald On-Line screen...
Ronnie
On Thursday, January 15, 1998 12:40 PM, Laslo Orto [SMTP:laslo@cpol.com]
wrote:
> The 4 means 4 bytes long integer, which can be a number betwean 0 and
> 4294967296
> You should be able to do what you want with this:
>
> insert into serverports (serverid,port) values ((select serverid from
> servers where server='yourservernamehere'),PORTNUMBER)
>
> repeat for every port number you want to add
>
> At 12:21 PM 1/15/98 -0600, you wrote:
> >I looked at the port field in the database and it is defined as 4 int
....
> >which to me means that it is only capable of 4 digits.. ie 6010 but not
> >60100
> >
> >I also looked at the Cisco page about the attributes and it appears that
> >the IETF defined the NAS-Port as being 5 digits....
> >
> >Here is their info...
> >=====================
> >NAS-Port
> >
> >Indicates the physical port number of the network access server that is
> >authenticating the user. The NAS-Port value (32 bits) consists of one or
> >two 16-bit values (depending on the setting of the radius-server
> >extended-portnames command.) Each 16-bit number should be viewed as a
> >5-digit decimal integer for interpretation as follows:
> >
> >For asynchronous terminal lines, async network interfaces, and virtual
> >async interfaces, the value is 00ttt, where ttt is the line number or
async
> >interface unit number.
> >
> >For ordinary synchronous network interface, the value is 10xxx.
> >
> >For channels on a primary rate ISDN interface, the value is 2ppcc.
> >
> >For channels on a basic rate ISDN interface, the value is 3bb0c.
> >
> >For other types of interfaces, the value is 6nnss.
> >=====================
> >
> >As you can see from the last line.. the 60100.. etc is defined as 6nnss
> >
> >Maybe this will help to point me in the right direction!!!!!!!
> >
> >As for entering the ports.. Microsoft Visual InterDev will allow me to
use
> >the tables just like I would be using a spreadsheet... so I can enter
them
> >their.. except I am limited to 4 int....
> >
> >Thanks
> >
> >Ronnie
> >
> >On Thursday, January 15, 1998 12:08 PM, Dale E. Reed Jr.
> >[SMTP:daler@iea.com] wrote:
> >> Ronnie D. Franklin wrote:
> >> >
> >> > 5. I have been unable to configure the ports numbers
via
> >> > EmeraldAdm. SQL Server Error: 207 Invalid column
> >> > name "microcom1". microcom1 being the name of the
> >> > NAS in the Servers Table. I have used both 2.1.11
and
> >> > 2.2.31 EmeraldAdm
> >> >
> >> > Any helpful hints would be nice.. Once all is done I will share my
> >setup files with anyone that is interested in this product.
> >>
> >> The only thing I can think of to resolve this is to use something
> >> like MS Query to manuall the the entries to your ServerPorts table.
> >> The only two fields that are relevant are the ServerID and Port
> >> fields. The ServerID must match the ServerID field for the Microcom
> >> in the Servers table. Port is just the port. Add as many as it
> >> returns in the NAS-Port field for accounting.
> >>
> >> --
> >> Dale E. Reed Jr. (daler@iea.com)
> >> _________________________________________________________________
> >> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> >> Internet Solutions for Today | http://www.iea-software.com
> >>
> >> ----------------------------------------------------------
> >> Emerald Mailing List listserver@emerald.iea.com
> >
> > ----------------------------------------------------------
> > Emerald Mailing List listserver@emerald.iea.com
> >
> >
>
>
> Laslo Orto Computer Pages / Better.Net
> Systems Administrator 253 Sheppard Ave. West
> laslo@cpol.com / laslo@Better.net Toronto, Canada M2N 1N2
> www.cpol.com / www.better.net Ph: +1 416 225 3030
> Fax: +1 416 225 6737
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com