As far as what SQL I am using.  I am using MySQL.  I will send the log files later
on today.

..Rich

Mike McCauley wrote:

> Hi Rich.
>
> On Mar 16,  9:47am, Richard Hawley wrote:
> > Subject: (RADIATOR) Simultaneous Use checking
> > Simultaneous Use checking does not seem to be working.  I am not sure
> > exactly why.  I am using an SQL database with the following table
> Can you send the Radiator log file at trace level 4 showing what happens when
> you try to log in the first and seconds times?
>
> On the topic of formatted dates, the answer depends on what type of SQL you are
> using. Let us know.
>
> Cheers.
>
> >
> >        AuthColumnDef 0, User-Password, check
> >        AuthColumnDef 1, Idle-Timeout, reply
> >        AuthColumnDef 2, Session-Timeout, reply
> >        AuthColumnDef 3, Simultaneous-Use, check
> >        AuthColumnDef 4, Time, check
> >        AuthColumnDef 5, GENERIC, check
> >        AuthColumnDef 6, GENERIC, reply
> >        AuthColumnDef 7, Framed-IP-Address, reply
> >
> > My session database is as follows
> >
> > <SessionDatabase SQL>
> >         DBSource  ****
> >         DBUsername   ****
> >         DBAuth ****
> >         AddQuery \
> >                 insert into Sessions (UserName, NASIdent, NASPort, \
> >                 AcctSessionID, TimeStamp, FramedAddress, NASPortType, \
> >                 ServiceType) values ('%n', '%N', %{NAS-Port},
> > '%{Acct-Session-Id
> > }', \
> >                 %{Timestamp}, '%{Framed-IP-Address}', '%{Port-Type}',
> > '%{Service
> > -Type}')
> >         DeleteQuery \
> >                 delete from Sessions where UserName='%n' and \
> >                 NASIdent='%N' and NASPort=%{NAS-Port}
> >         ClearNasQuery \
> >                 delete from Sessions where NASIdent='%N'
> >         CountQuery \
> >                 select NASIdent, NASPort, AcctSessionID from Sessions \
> >                 where UserName='%n'
> > </SessionDatabase>
> >
> > I'm very new to SQL so forgive my inexperience.  I am learning more
> > everyday but this problem can't wait for me to figure it out. :)
> >
> > Also, could someone give me some pointers on making the Timestamp field
> > more human readable?  The seconds since Jan 1, 1970 is functional but is
> > there a way to make it a normal date?  I've read the section in the
> > Radiator reference manual on Formated date stamps, etc, but I am not
> > sure how to configure that for SQL.  Plus I don't want to make a mistake
> > and corrupt the tables.  Thanks all.
> >
> > ..Rich
> >
> >
> > --
> > ------------------------------------
> > Richard W. Hawley - Network Engineer
> > CyberZone Internet Services
> > http://www.cyberzone.net
> > [EMAIL PROTECTED]
> >
> >
> >
> > ===
> > To unsubscribe, email '[EMAIL PROTECTED]' with
> > 'unsubscribe radiator' in the body of the message.
> >-- End of excerpt from Richard Hawley
>
> --
> Mike McCauley                               [EMAIL PROTECTED]
> Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
> 24 Bateman St Hampton, VIC 3188 Australia   Consulting and development
> Phone, Fax: +61 3 9598-0985                 http://www.open.com.au
>
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> Platypus, Freeside, external, etc etc on Unix, Win95/8, NT, Rhapsody

--
------------------------------------
Richard W. Hawley - Network Engineer
CyberZone Internet Services
http://www.cyberzone.net
[EMAIL PROTECTED]



===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to