(RADIATOR) Simultaneous-Use checking - sometimes (still)
Help! I'm currently running Radiator 2.15 and I found that simultaneous-use only works sometimes. So, I read the revision history of 2.16 that there was a fix. Well, I'm testing simultaneous-use and it would still fail if I would login with a suffix (+ppp) for the newest release - 2.16.3. --- - Radiator 2.16.3 Radiator 2.15 --- - Test #1 - (sim-use fails) Test #1 - (sim-use fails) --- --- 1st Login: mikesanlite+ppp 1st Login: mikesanlite+ppp 2nd Login: mikesanlite 2nd Login: mikesanlite Test #2 - (rejects 2nd login) Test #2 - (sim-use fails) --- --- 1st Login: mikesanlite+ppp 1st Login: mikesanlite+ppp 2nd Login: mikesanlite+ppp 2nd Login: mikesanlite+ppp Test #3 - (rejects 2nd login) Test #3 - (rejects 2nd login) --- --- 1st Login: mikesanlite 1st Login: mikesanlite 2nd Login: mikesanlite 2nd Login: mikesanlite Test #4 - (sim-use fails) Test #4 - (rejects 2nd login) --- --- 1st Login: mikesanlite 1st Login: mikesanlite 2nd Login: mikesanlite+ppp 2nd Login: mikesanlite+ppp Note that with Test #4, Radiator 2.15 sim-use works, but 2.16.3 fails. Isn't that odd? TIA, Janet _ Janet del Mundo Internet Administrator, Startec Global Communications 135 Chalan Santo Papa Agana, Guam 96910 Email: [EMAIL PROTECTED] === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Simultaneous Use checking
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
> >
> >
> > 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'
> >
> >
> > 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. LtdUnix, 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.
Re: (RADIATOR) Simultaneous Use checking
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
>
>
> 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'
>
>
> 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. LtdUnix, 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.
(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
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
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'
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.
(RADIATOR) Simultaneous Use checking not working
I have radiator running on a linux server using a mysql database. I have Simultaneous-Use checking enabled but it is not working. What do I need to add to enable the sim use checking? Thanks. The database is as follows: DBSourcedbi:mysql:dbname DBUsername dbname DBAuth dbname AuthSelect Select Password, IdleTime, SessionTime, \ SimUse, LogonTime, CheckAttr, ReplyAttr, StaticIP from \ Subscribers Where UserName = '%n' and Status = 'A' 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 AccountingTable RadiusAccounting AcctColumnDef UserName,User-Name AcctColumnDef TimeStamp,Timestamp,integer AcctColumnDef StatusType,Acct-Status-Type AcctColumnDef DelayTime,Acct-Delay-Time,integer AcctColumnDef InputOctets,Acct-Input-Octets,integer AcctColumnDef OutputOctets,Acct-Output-Octets,integer AcctColumnDef SessionID,Acct-Session-Id AcctColumnDef SessionTime,Acct-Session-Time,integer AcctColumnDef TerminateCause,Acct-Terminate-Cause AcctColumnDef NASIdent,Client-Id AcctColumnDef NASPort,NAS-Port,integer AcctColumnDef FramedIPAddress,Framed-IP-Address AcctColumnDef ConnectSpeed,Connect-Speed AcctColumnDef ModType,Modulation-Type AcctColumnDef CallerID,Calling-Station-Id AcctColumnDef PopID,Called-Station-Id -- 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.
