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.

Reply via email to