ServerAccess

Ciro Vera ( (no email) )
Tue, 23 Jun 1998 17:59:44 -0000

This is a multi-part message in MIME format.

------=_NextPart_000_01BD9ED0.B3E530D0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

Hi' Dale, All

I'm testing Server Access in Radius NT 2.5.124, and look that StartTime and
StopTime
field of Serveraccess table not work correctly.

Current time is 1045 (minutes past midnight ), and StartTime=0,
StopTime=100 then
I think that a PPP user is allowed to login only between Starttime and
Stoptime,
but at current Time the authentification is done and PPP users is allowed
to login :(

The following thing I have done,
1° CREATE PROCEDURE RadCheckPort as say in Radius NT 2.5 documentation

2° Insert register in ServerAccess Table for AccountType=PPP

ServerID Port AccountType StartTime StopTime MaxSessionLength
----------- ---------- --------------- ----------- -----------
----------------
12 (null) PPP 0 100 100

3° run radlogin cirovera xxxxx and .....

radrecv: Request from host ce308e04 code=1, id=239, length=60
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "cirovera"
Password = "\230+\244~r\351>K\032\333\2756b+_3"
rad_authenticate_ODBC()
Password = "\230+\244~r\351>K\032\333\2756b+_3"

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(),
DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, sa.AccountType,
sa.Password, sa.Login, sa.Shell, sa.TimeLeft, sa.LoginLimit From
MasterAccounts ma, SubAccounts sa Where (sa.Login='cirovera' or
sa.Shell='cirovera') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
ma.Active<>0

Decrypted Password:xxxxx
Database Password: xxxxx
Checking for duplicate logins.

SQL Statement: RadCheckOnline 'cirovera'

cirovera found on-line 0 time(s).
Checking for port access.

SQL Statement: RadCheckPort '127.0.0.1', 0, 'PPP'

SQL Statement: RadGetConfigs 1

User-Service = 2 (2)
Framed-Protocol = 1 (1)
Framed-Routing = 0 (0)
Ascend-Assign-IP-Pool = 5 (5)
Ascend-Idle-Limit = 0 (0)
Sending Ack of id 239 to ce308e04 (lobo.interaccess.cl)
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Routing = None
Ascend-Assign-IP-Pool = 5
Ascend-Idle-Limit = 0

Thank's
ciro

------=_NextPart_000_01BD9ED0.B3E530D0
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi' Dale, All

I'm testing Server =Access in Radius NT 2.5.124, and look that StartTime and =StopTime
field of Serveraccess table not work correctly. =

Current time is 1045 (minutes past midnight ), and =StartTime=3D0, StopTime=3D100 then
I think that a PPP user is allowed =to login only between Starttime and Stoptime,
but at current Time = the authentification is done and PPP users is allowed to login =:(



The following thing  I have done,
1=B0 CREATE =PROCEDURE RadCheckPort as say in Radius NT 2.5 documentation

2=B0 =Insert register in ServerAccess Table for =AccountType=3DPPP

ServerID Port AccountType StartTi=me StopTime MaxSessionLength =
----------- ---------- --------------- = ----------- ----------- ---------------- =
12 (null) PPP 0 100 =100 =            &=nbsp;



3=B0  run radlogin cirovera xxxxx and = .....

radrecv: Request from host ce308e04 code=3D1, =id=3D239, length=3D60
   NAS-Identifier =3D =127.0.0.1
   NAS-Port =3D 0
=   User-Name =3D "cirovera"
=   Password =3D ="\230+\244~r\351>K\032\333\2756b+_3"
rad_authenticate_ODB=C()
   Password =3D ="\230+\244~r\351>K\032\333\2756b+_3"

SQL Statement: =Select DateDiff(Minute, GetDate(), DateAdd(Day, =(ma.Extension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), =DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, =sa.AccountType, sa.Password, sa.Login, sa.Shell, sa.TimeLeft, =sa.LoginLimit From MasterAccounts ma, SubAccounts sa  Where =(sa.Login=3D'cirovera' or sa.Shell=3D'cirovera') AND =ma.CustomerID=3Dsa.CustomerID and sa.Active<>0 and =ma.Active<>0

Decrypted Password:xxxxx
Database =Password: xxxxx
Checking for duplicate logins.

SQL Statement: =RadCheckOnline 'cirovera'

     cirovera =found on-line 0 time(s).
Checking for port access.

SQL =Statement: RadCheckPort '127.0.0.1', 0, 'PPP'


SQL =Statement: RadGetConfigs 1

=     User-Service =3D 2 (2)
=     Framed-Protocol =3D 1 (1)
=     Framed-Routing =3D 0 (0)
=     Ascend-Assign-IP-Pool =3D 5 (5)
=     Ascend-Idle-Limit =3D 0 (0)
Sending Ack =of id 239 to ce308e04 (lobo.interaccess.cl)
=   User-Service =3D Framed-User
=   Framed-Protocol =3D PPP
=   Framed-Routing =3D None
=   Ascend-Assign-IP-Pool =3D 5
=   Ascend-Idle-Limit =3D =0



Thank's
ciro

------=_NextPart_000_01BD9ED0.B3E530D0--