I have problem using session database heres my sample config ....
 
 
------------------------------------------------------------------------------------------------------------------------------------------------
<Client DEFAULT>
        Secret  mysecret
        DupInterval 1
</Client>
 
<SessionDatabase SQL>
 
        DBSource        dbi:ODBC:radius_sql
        DBUsername      radius
        DBAuth  
        Identifier SQL1
 
</SessionDatabase SQL>
<AuthBy SQL>
        DBSource          dbi:ODBC:radius_sql
        DBUsername      radius
        DBAuth            
 
        AuthSelect        select password,expiration,service_type,expirat
                                session_timeout,frame_mtu from subscribers \
                                where username = '%n' and status = 1
 
        AuthColumnDef 0, User-Password, check
        AuthColumnDef 1, Expiration, check
        AuthColumnDef 2, Service-Type, check
        AuthColumnDef 3, Session-Timeout, reply
        AuthColumnDef 4, Framed-MTU, reply

        AccountingTable Radusage%Y%m
        AcctColumnDef   USERNAME,User-Name
        AcctColumnDef   TIME_STAMP,Timestamp,integer
        AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type
        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   NASPORT,NAS-Port,integer
        AcctColumnDef   NAS_IP_ADDRESS,NAS-IP-Address
        AcctColumnDef   NASPORT_TYPE,NAS-Port-Type
        SessionDatabase SQL1
   
</AuthBy>
<AuthBy PORTLIMITCHECK>
        SessionDatabase SQL1
        SessionLimit 1
 
</AuthBy PORTLIMITCHECK>
 
 
 
--------------------------------------------------------------------------------------------------------------------------------------------
 
it will give me this error..
 
Thu Jul 29 12:55:32 1999: ERR: Unknown keyword 'SessionDatabase' in common-sql.cfg line 54
Thu Jul 29 12:55:32 1999: ERR: Unknown keyword 'SessionDatabase' in common-sql.cfg line 57
 
which is the keywork SeesionDatabase is in the <Authby SQL> and <AuthBy PORTLIMITCHECK>
 
any comments or suggestion on my sample test config ....
 
 
mark
 
-P-h-i-l-i-p-p-i-n-e-s--O-n-l-i-n-e---------------------------------------------------------------------------------------------------
Mark Anthony R. Lastrilla , CNE,MCP
System Administrator                                          Phone  : +63 (2) 411-4545 Quezon City
E-mail : [EMAIL PROTECTED]                         Cel. #   : +63 (917) 90-36-757
3rd Flr. F.C. Building, 288 Tomas Morato         
cor. Sct. Rallos St., Quezon City, Philippines 1203
-----------------------------------------------------------------------------------------------------------------------------------------------

Reply via email to