Hello Greg,

It looks to me like the Framed-IP-Address is being sent back to your NAS as you
expect. If your NAS is not honouring it, I think you will need to check your
NAS configuration.

Hope that helps.
Cheers.

On Jul 29, 11:15am, Greg Kornatowsky wrote:
> Subject: RE: (RADIATOR) Framed IP Address not returned from Radiator
> Sorry, wrong logfile.  Hopefully this is the right one.
>
> Greg
>
> Thu Jul 29 11:03:36 1999: DEBUG: Packet dump:
> *** Received from 216.94.40.126 port 1645 ....
> Code:       Access-Request
> Identifier: 112
> Authentic:  <221><146><127><255><195><26>&Q<195>'3<212><139>ps<161>
> Attributes:
>         NAS-IP-Address = 216.94.40.126
>         NAS-Port = 41
>         NAS-Port-Type = Async
>         User-Name = "greg"
>         Called-Station-Id = "6385466"
>         Calling-Station-Id = "6046385467"
>         User-Password =
> "<139>{]<206><186>Q<154>w37<167><197><15><155>u<246>"
>         Service-Type = Framed
>         Framed-Protocol = PPP
>
> Thu Jul 29 11:03:36 1999: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Thu Jul 29 11:03:36 1999: DEBUG: Rewrote user name to greg
> Thu Jul 29 11:03:36 1999: DEBUG: Handling with Radius::AuthEMERALD
> Thu Jul 29 11:03:36 1999: DEBUG: Query is: select DateAdd(Day, ma.extension,
> maExpireDate),
> DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,
> sa.password, sa.login, sa.shell, sa.TimeLeft
> from masteraccounts ma, subaccounts sa
> where (sa.login = 'greg' or sa.shell = 'greg')
> and ma.customerid = sa.customerid
> and sa.active <> 0 and ma.active <> 0
>
> Thu Jul 29 11:03:36 1999: DEBUG: Query is: select ra.RadAttributeID, Data,
> Value, Type
> from RadConfigs rc, RadAttributes ra
> where ra.RadAttributeID = rc.RadAttributeID and rc.AccountID=1070
>
> Thu Jul 29 11:03:36 1999: DEBUG: Radius::AuthEMERALD looks for match with
> greg
> Thu Jul 29 11:03:36 1999: DEBUG: Packet dump:
> *** Sending to 216.94.40.126 port 1645 ....
> Code:       Access-Accept
> Identifier: 112
> Authentic:  <221><146><127><255><195><26>&Q<195>'3<212><139>ps<161>
> Attributes:
>         Framed-IP-Address = 216.94.40.97
>
> Thu Jul 29 11:03:36 1999: DEBUG: Packet dump:
> *** Received from 216.94.40.126 port 1646 ....
> Code:       Accounting-Request
> Identifier: 113
> Authentic:  <177>S<144><3>}<181>6=W<13><249><132>4<29><6><218>
> Attributes:
>         NAS-IP-Address = 216.94.40.126
>         NAS-Port = 41
>         NAS-Port-Type = Async
>         User-Name = "greg"
>         Called-Station-Id = "6385466"
>         Calling-Station-Id = "6046385467"
>         Acct-Status-Type = Start
>         Acct-Authentic = RADIUS
>         Service-Type = Framed
>         Acct-Session-Id = "00002B8B"
>         Framed-Protocol = PPP
>         Acct-Delay-Time = 0
>
> Thu Jul 29 11:03:36 1999: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Thu Jul 29 11:03:36 1999: DEBUG: Rewrote user name to greg
> Thu Jul 29 11:03:36 1999: DEBUG: Handling accounting with
> Radius::AuthEMERALD
> Thu Jul 29 11:03:36 1999: DEBUG: Query is: insert into Calls
>                 (UserName, AcctStatusType, NASIdentifier,
> AcctTerminateCause, NASPort, AcctDelayTime, CallDate, AcctSessionId, AcctI
> nputOctets, AcctOutputOctets, AcctSessionTime)
>                 values
>                 ('greg', 1, '216.94.40.126', NULL, 41, 0, 'Jul 29, 99 11:3',
> '00002B8B', NULL, NULL, NULL)
>
> Thu Jul 29 11:03:36 1999: DEBUG: Adding session for greg, 216.94.40.126, 41
> Thu Jul 29 11:03:36 1999: DEBUG: Packet dump:
> *** Sending to 216.94.40.126 port 1646 ....
> Code:       Accounting-Response
> Identifier: 113
> Authentic:  <177>S<144><3>}<181>6=W<13><249><132>4<29><6><218>
> Attributes:
>
>
>
> -----Original Message-----
> From: Mike McCauley [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 29, 1999 11:44 AM
> To: Greg Kornatowsky
> Subject: Re: (RADIATOR) Framed IP Address not returned from Radiator
>
>
> Hi Greg,
>
> On Jul 28,  7:32pm, Greg Kornatowsky wrote:
> > Subject: RE: (RADIATOR) Framed IP Address not returned from Radiator
> > When I execute:
> >
> > select ra.RadAttributeID, Data, Value, Type
> > from RadConfigs rc, RadAttributes ra
> > where ra.RadAttributeID = rc.RadAttributeID and rc.AccountID=1070
> >
> > it returns:
> >
> > RadAttributeID Data
> > Value       Type
> > -------------- -----------------------------------------------------------
> --
> > ---------------------- ----------- -----------
> > 8              216.94.40.201
> > 217         2
> That looks OK.
>
> >
> > So it appears that the database is set up correctly.
> >
> > Radiator Trace 4 returns:
> >
> > Wed Jul 28 19:24:45 1999
> >         NAS-IP-Address = 216.94.40.126
> >         NAS-Port = 28
> >         NAS-Port-Type = Async
> >         User-Name = "greg"
> >         Called-Station-Id = "6385466"
> >         Calling-Station-Id = "6046385468"
> >         Acct-Status-Type = Start
> >         Acct-Authentic = RADIUS
> >         Service-Type = Framed
> >         Acct-Session-Id = "000028A7"
> >         Framed-Protocol = PPP
> >         Acct-Delay-Time = 0
> >         Timestamp = 933215085
>
> That looks like an incoming accounting start record?
>
> Will you pease turn on Radiator tracing to level 4, and send a complete
> transcript of what you see in the log file when your user withthe static IP
> address logs in.
>
> Without that I cant tell whats going on.
>
> Cheers.
>
> >
> >
> > -----Original Message-----
> > From: Mike McCauley [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, July 29, 1999 10:16 AM
> > To: Greg Kornatowsky
> > Subject: Re: (RADIATOR) Framed IP Address not returned from Radiator
> >
> >
> > Hello Greg,
> >
> > On Jul 28,  5:42pm, Greg Kornatowsky wrote:
> > > Subject: RE: (RADIATOR) Framed IP Address not returned from Radiator
> > > We have added the Framed-IP-Address within Platypus but it still isn't
> > > working.  I have looked in the database and the value is there.  What is
> > the
> > > SQL call that Radiator makes to retrieve the Framed-IP-Address?  Any
> ideas
> > > what the problem might be?
> >
> > It issues this query:
> >
> > select ra.RadAttributeID, Data, Value, Type
> > from RadConfigs rc, RadAttributes ra
> > where ra.RadAttributeID = rc.RadAttributeID and rc.AccountID=$account_id
> >
> >
> > Can you post the Radiator log file at trace level 4 showing what is
> > happening
> > when you authenticate that user? Send it to the mailing list, rather than
> me
> > personally, thanks.
> >
> > Cheers.
> >
> >
> > >
> > > Greg
> > >
> > > -----Original Message-----
> > > From: Mike McCauley [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, July 29, 1999 8:12 AM
> > > To: Greg Kornatowsky; [EMAIL PROTECTED]
> > > Subject: Re: (RADIATOR) Framed IP Address not returned from Radiator
> > >
> > >
> > > On Jul 28,  1:03pm, Greg Kornatowsky wrote:
> > > > Subject: (RADIATOR) Framed IP Address not returned from Radiator
> > > > We debugged our Cisco 5200 and determined that the radius server is
> not
> > > > giving the access server the Framed Address attribute.  We are
> > > > authenticating off a database.  We are currently using Platypus for
> our
> > > > accounting software.  We are running Radiator 2.12.1and Microsoft SQL
> > > > Server.  Below is the default realm from our radius config file.  My
> > > problem
> > > > is we want to give some users a static IP Address, but it will not
> work.
> > > > What is the problem here?  Can you tell me what the SQL call Radiator
> > > makes
> > > > to our database, so we can run it locally to make sure it is getting
> the
> > > > framed IP address.
> > >
> > > All you have to do is to use the Platypus radius setup menu, and add a
> > > Framed-IP-Address reply item for the user you are interested in.
> Radiator
> > > will
> > > automatically find it when the user is authenticated.
> > >
> > > Cheers.
> > >
> > > >
> > > > Greg Kornatowsky
> > > > ZooLink
> > > >
> > > > [EMAIL PROTECTED]
> > > >
> > > > <Realm DEFAULT>
> > > >         RewriteUsername tr/[A-Z]/[a-z]/
> > > >         MaxSessions     1
> > > >         AcctLogFileName %L/detail
> > > >         PasswordLogFileName %L/password.log
> > > >
> > > >         <AuthBy EMERALD>
> > > >                 # Change DBSource, DBUsername, DBAuth for your
> database
> > > >                 # See the reference manual
> > > >                 DBSource        dbi:Sybase:SQLSERVER1
> > > >                 DBUsername      platuser
> > > >                 DBAuth          XXXXXX
> > > >
> > > >                 # You can add to or change these if you want.
> > > >                 AccountingTable Calls
> > > >                 AcctColumnDef   UserName,User-Name
> > > >                 AcctColumnDef   CallDate,Timestamp,integer-date
> > > >                 AcctColumnDef
> AcctStatusType,Acct-Status-Type,integer
> > > >                 AcctColumnDef   AcctDelayTime,Acct-Delay-Time,integer
> > > >                 AcctColumnDef
> > AcctInputOctets,Acct-Input-Octets,integer
> > > >                 AcctColumnDef
> > > AcctOutputOctets,Acct-Output-Octets,integer
> > > >                 AcctColumnDef   AcctSessionId,Acct-Session-Id
> > > >                 AcctColumnDef
> > AcctSessionTime,Acct-Session-Time,integer
> > > >                 AcctColumnDef
> AcctTerminateCause,Acct_Terminate-Cause
> > > >                 AcctColumnDef   NASIdentifier,NAS-Identifier
> > > >                 AcctColumnDef   NASIdentifier,NAS-IP-Address
> > > >                 AcctColumnDef   NASPort,NAS-Port,integer
> > > >
> > > >                 # You can use this to force Radiator to limit
> > > >                 # maximum session times to how many minutes
> > > >                 # are left in subaccounts.timeleft
> > > >                 TimeBanking
> > > >         </AuthBy>
> > > > </Realm>
> > > >
> > > >
> > > > ===
> > > > Archive at http://www.thesite.com.au/~radiator/
> > > > To unsubscribe, email '[EMAIL PROTECTED]' with
> > > > 'unsubscribe radiator' in the body of the message.
> > > >-- End of excerpt from Greg Kornatowsky
> > >
> > >
> > >
> > > --
> > > Mike McCauley                               [EMAIL PROTECTED]
> > > Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
> > > 24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
> > > Phone +61 3 9598-0985                       Fax   +61 3 9598-0955
> > >
> > > Radiator: the most portable, flexible and configurable RADIUS server
> > > anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> > > Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
> > > NT, Rhapsody
> > >
> > >
> > >-- End of excerpt from Greg Kornatowsky
> >
> >
> >
> > --
> > Mike McCauley                               [EMAIL PROTECTED]
> > Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
> > 24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
> > Phone +61 3 9598-0985                       Fax   +61 3 9598-0955
> >
> > Radiator: the most portable, flexible and configurable RADIUS server
> > anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> > Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
> > NT, Rhapsody
> >
> >
> > ===
> > Archive at http://www.thesite.com.au/~radiator/
> > To unsubscribe, email '[EMAIL PROTECTED]' with
> > 'unsubscribe radiator' in the body of the message.
> >-- End of excerpt from Greg Kornatowsky
>
>
>
> --
> Mike McCauley                               [EMAIL PROTECTED]
> Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
> 24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
> Phone +61 3 9598-0985                       Fax   +61 3 9598-0955
>
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
> NT, Rhapsody
>
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from Greg Kornatowsky



-- 
Mike McCauley                               [EMAIL PROTECTED]
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, 
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to