Hi Mark -
On Tue, 29 Jun 1999, Mark Anthony Lastrilla wrote:
> >%_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 ....
>
You only need the <SessionDatabase SQL> configuration statements. Remove the
keyword SessionDatabase in the <AuthBy SQL> clause.
BTW - what is the <AuthBy PORTLIMITCHECK> clause?
hth
Hugh
--
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.
