(RADIATOR) Profiles problems

[Hugh Irvine]

Hello Brandon -

Could you please send me a trace 4 debug showing what is happening, and 
a bit more detail on what exactly you are wanting to have happen? I am 
not clear on what the TimeOfDay reply item is meant to do.

regards

Hugh


On 13/11/2003, at 7:10 AM, Brandon Lehmann wrote:

> Hi List,
>
> I cannot get the radius server to return the profile while using
> the following configuration:
>
> ------START-----
> LogStdout   c:/radiator/stdout.txt
> LogDir c:/radiator
> DbDir c:/radiator.
>
> <Client DEFAULT>
>      Secret !removed for my protection!
>      DupInterval 0
> </Client>
>
> <Realm DEFAULT>
>
>      AuthByPolicy ContinueAlways
>
>      <AuthBy SQL>
>           Identifier ACCT1
>           DBSource dbi:ODBC:!removed for my protection!
>           DBUsername !removed for my protection!
>           DBAuth !removed for my protection!
>
>           AuthSelect
>
>           AccountingTable radacct1
>           AcctColumnDef UserName,User-Name
>           AcctColumnDef LogDateTime,Timestamp,integer-date
>           AcctColumnDef AcctStatusType,Acct-Status-Type
>           AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
>           AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
>           AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
>           AcctColumnDef AcctInputPackets,Acct-Input-Packets,integer
>           AcctColumnDef AcctOutputPackets,Acct-Output-Packets,integer
>           AcctColumnDef AcctSessionTime,Acct-Session-Time,integer
>           AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause
>           AcctColumnDef NasIPAddress,NAS-IP-Address
>           AcctColumnDef NasIdentifier,NAS-Identifier
>           AcctColumnDef NasPortId,NAS-Port,integer
>           AcctColumnDef NasPortType,NAS-Port-Type,integer
>           AcctColumnDef ConnectInfo,Connect-Info
>           AcctColumnDef ServiceType,Service-Type
>           AcctColumnDef FramedProtocol,Framed-Protocol
>           AcctColumnDef FramedAddress,Framed-IP-Address
>           AcctColumnDef CallingStationId,Calling-Station-Id
>      </AuthBy>
>
>      <AuthBy SQL>
>           Identifier AUTH1
>           DBSource dbi:ODBC:!removed for my protection!
>           DBUsername !removed for my protection!
>           DBAuth  !removed for my protection!
>
>           AuthSelect select 
> ClearTextPassword,ServiceType,SessionLimit, \
>               IdleLimit,StaticIP,IPNetmask,FramedRoute,PortLimit, \
>               PortLimit,ProfileID from Customers where CustomerID=%0 \
>               and Disable is null
>           AuthColumnDef 0,Password,check
>           AuthColumnDef 1,Service-Type,reply
>           AuthColumnDef 2,Session-Timeout,reply
>           AuthColumnDef 3,Idle-Timeout,reply
>           AuthColumnDef 4,Framed-IP-Address,reply
>           AuthColumnDef 5,Framed-IP-Netmask,reply
>           AuthColumnDef 6,Framed-Route,reply
>           AuthColumnDef 7,Port-Limit,reply
>           AuthColumnDef 8,Simultaneous-Use,check
>           AuthColumnDef 9,Profile,reply
>      </AuthBy>
>      <AuthBy SQL>
>          DBSource dbi:ODBC:!removed for my protection!
>          DBUsername !removed for my protection!
>          DBAuth !removed for my protection!
>
>          AuthSelect      SELECT timeofday FROM profiles WHERE \
>             [profile]='%{Reply:Profile}'
>          AuthColumnDef 0,TimeOfDay,reply
>
>          StripFromReply Profile
>      </AuthBy>
>
>      SessionDatabase SDB1
>
> </Realm>
>
> <SessionDatabase SQL>
>      Identifier SDB1
>      DBSource dbi:ODBC:!removed for my protection!
>      DBUsername !removed for my protection!
>      DBAuth  !removed for my protection!
> </SessionDatabase>
> -------END----
>
> If I change "AuthByPolicy ContinueAlways" to "AuthByPolicy
> ContinueWhileAccept" then the server always returns "Request Denied". 
> Any
> input would be greatly appreciated. Note: I have already searched the 
> list
> archives, nothing seems to work.
>
> Thank you,
>
> Brandon Lehmann
> Network Administrator
> Great Lakes Internet Service, LLC.
> The Computer Loft, Inc.
> 218 Justice St
> Fremont, Ohio 43420
> 419.332.3553
> blehmann at glis.cc
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.