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
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
