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.
