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.
