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
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
-----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.