Login-Time + SQL ?

[Patrick]

Hi,

 

im just reposting this after trawling the mailing lists i still havent

seem to have come up with anything usefull... im trying to run login time

but here is my confusing bit ... currently im using both users file and sql

database ... i add the line into the users file with login-time and it

works user cant login

 

eg :

 

xsitest0005  Password == "xsitest0005", Login-Time := "Any0000-1000"
 Service-Type = Framed-User,
 Framed-Protocol = PPP

this user gets <radtest>:

 

Sending Access-Request of id 119 to 127.0.0.1:1812
        User-Name = "xsitest0005"
        User-Password = "h8\332&}\221\254\240j\222\357u\376\241\263"
        NAS-IP-Address = local
        NAS-Port = 10
        Framed-Protocol = PPP
Re-sending Access-Request of id 119 to 127.0.0.1:1812
        User-Name = "xsitest0005"
        User-Password = "h8\332&}\221\254\240j\222\357u\376\241\263"
        NAS-IP-Address = local
        NAS-Port = 10
        Framed-Protocol = PPP
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=119, length=69
        Reply-Message = "You are calling outside your allowed timespan\r\n"

 

so in sql i make a user xsitest0001

and in rad group reply i put the following stuff :

 

mysql> select * from radgroupreply where GroupName = "XSInetDaytime";
+----+---------------+-----------------+----+-------------+------+
| id | GroupName     | Attribute       | op | Value       | prio |
+----+---------------+-----------------+----+-------------+------+
|  3 | XSInetDaytime | Service-Type    | := | Framed-User |    0 |
|  4 | XSInetDaytime | Framed-Protocol | := | PPP         |    0 |
|  6 | XSInetDaytime | Login-Time      | := | Al0000-0020 |    0 |
+----+---------------+-----------------+----+-------------+------+
3 rows in set (0.00 sec)

 

mysql>

mysql> select * from usergroup where GroupName = "XSInetDaytime";
+----+-------------+---------------+
| id | UserName    | GroupName     |
+----+-------------+---------------+
|  3 | xsitest0001 | XSInetDaytime |
+----+-------------+---------------+
1 row in set (0.00 sec)

 

mysql> select * from radcheck where UserName = "xsitest0001";
+----+-------------+-----------+----+-------------+
| id | UserName    | Attribute | op | Value       |
+----+-------------+-----------+----+-------------+
|  3 | xsitest0001 | Password  | == | xsitest0001 |
+----+-------------+-----------+----+-------------+
1 row in set (0.00 sec)

 

so theoretically it should work between 00:00 - 00:20 AM

and not other times

 

pikachu raddb # radtest xsitest0001 xsitest0001 localhost 10 SecretSecret 1 local
Sending Access-Request of id 161 to 127.0.0.1:1812
        User-Name = "xsitest0001"
        User-Password = "\251\222Jm\026*\326v\276\240\205\231\276\334D\260"
        NAS-IP-Address = local
        NAS-Port = 10
        Framed-Protocol = PPP
rad_recv: Access-Accept packet from host 127.0.0.1:1812, id=161, length=32
        Service-Type = Framed-User
        Framed-Protocol = PPP

 

pikachu raddb # date
Wed Aug  6 14:14:30 SAST 2003

 

pikachu raddb #

 

*CONFUSED*

 

please help me out here

im sure im doing somthing stupid

just not sure what ...

 

 

 

 

 

 

Patrick
XSInet

 

------------------------------------------------------

 

I live in my own little world. But it's OK. They know me here.