Hi people!
thanks for answering and solving my problems with the mysql
database... I importet the sql-file into the database an it worked
... ;-)
But now another question...
Which type of parameters can I insert in the MySQL db for freeradius?
example in radreply or radgroupreply, like Framed-IP-Address,
Framed-Routing or Idle-Timeout etc. ... Is there somewhere a list???
I inserted for example:
mysql> select * from usergroup;
+----+---------------+-------------+
| id | UserName | GroupName |
+----+---------------+-------------+
| 1 | fredf | dynamic |
| 2 | barney | static |
| 2 | dialrouter | netdial |
+----+---------------+-------------+
3 rows in set (0.00 sec)
mysql> select * from radcheck;
+----+----------------+----------------+--------------+------+
| id | UserName | Attribute | Value | Op |
+----+----------------+----------------+--------------+------+
| 1 | fredf | Password | wilma | == |
| 2 | barney | Password | betty | == |
| 2 | dialrouter | Password | dialup | == |
+----+----------------+----------------+--------------+------+
3 rows in set (0.02 sec)
mysql> select * from radgroupcheck;
+----+-------------+----------------+---------------+------+
| id | GroupName | Attribute | Value | Op |
+----+-------------+----------------+---------------+------+
| 1 | dynamic | Auth-Type | Local | := |
| 2 | static | Auth-Type | Local | := |
| 3 | netdial | Auth-Type | Local | := |
+----+-------------+----------------+---------------+------+
3 rows in set (0.01 sec)
mysql> select * from radreply;
+----+------------+-------------------+---------------------------------+------+
| id | UserName | Attribute |
Value | Op |
+----+------------+-------------------+---------------------------------+------+
| 1 | barney | Framed-IP-Address |
1.2.3.4 | := |
| 2 | dialrouter | Framed-IP-Address |
2.3.4.1 | := |
| 3 | dialrouter | Framed-IP-Netmask |
255.255.255.255 | := |
| 4 | dialrouter | Framed-Routing |
Broadcast-Listen | := |
| 5 | dialrouter | Framed-Route | 2.3.4.0
255.255.255.248 | := |
| 6 | dialrouter | Idle-Timeout | 900
| := |
+----+------------+-------------------+---------------------------------+------+
6 rows in set (0.01 sec)
mysql> select * from radgroupreply;
+----+--------------+-----------------------+------------------------+------+
| id | GroupName | Attribute |
Value | Op |
+----+--------------+-----------------------+------------------------+------+
| 34 | dynamic | Framed-Compression |
Van-Jacobsen-TCP-IP | := |
| 33 | dynamic | Framed-Protocol |
PPP | := |
| 32 | dynamic | Service-Type |
Framed-User | := |
| 35 | dynamic | Framed-MTU |
1500 | := |
| 37 | static | Framed-Protocol |
PPP | := |
| 38 | static | Service-Type |
Framed-User | := |
| 39 | static | Framed-Compression |
Van-Jacobsen-TCP-IP | := |
| 41 | netdial | Service-Type |
Framed-User | := |
| 42 | netdial | Framed-Protocol |
PPP | := |
+----+--------------+-----------------------+------------------------+------+
12 rows in set (0.01 sec)
thanks
Michael Ziemann
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
