<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<div class="moz-text-flowed"
style="font-family: -moz-fixed; font-size: 13px;" lang="x-western">Hi
people!
<br>
<br>
thanks for answering and solving my problems with the mysql
database... I importet the sql-file into the database an it worked
... <span class="moz-smiley-s3"><span> ;-) </span></span>
<br>
<br>
But now another question...
<br>
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???
<br>
<br>
I inserted for example:
<br>
<br>
mysql> select * from usergroup;
<br>
+----+---------------+-------------+
<br>
| id | UserName | GroupName |
<br>
+----+---------------+-------------+
<br>
| 1 | fredf | dynamic |
<br>
| 2 | barney | static |
<br>
| 2 | dialrouter | netdial |
<br>
+----+---------------+-------------+
<br>
3 rows in set (0.00 sec)
<br>
<br>
mysql> select * from radcheck;
<br>
+----+----------------+----------------+--------------+------+
<br>
| id | UserName | Attribute | Value | Op |
<br>
+----+----------------+----------------+--------------+------+
<br>
| 1 | fredf | Password | wilma | == |
<br>
| 2 | barney | Password | betty | == |
<br>
| 2 | dialrouter | Password | dialup | == |
<br>
+----+----------------+----------------+--------------+------+
<br>
3 rows in set (0.02 sec)
<br>
<br>
mysql> select * from radgroupcheck;
<br>
<br>
+----+-------------+----------------+---------------+------+
<br>
| id | GroupName | Attribute | Value | Op |
<br>
+----+-------------+----------------+---------------+------+
<br>
| 1 | dynamic | Auth-Type | Local | := |
<br>
| 2 | static | Auth-Type | Local | := |
<br>
| 3 | netdial | Auth-Type | Local | := |
<br>
+----+-------------+----------------+---------------+------+
<br>
3 rows in set (0.01 sec)
<br>
<br>
mysql> select * from radreply;
<br>
<br>
+----+------------+-------------------+---------------------------------+------+
<br>
| id | UserName | Attribute |
Value | Op |
<br>
+----+------------+-------------------+---------------------------------+------+
<br>
| 1 | barney | Framed-IP-Address |
1.2.3.4 | := |
<br>
| 2 | dialrouter | Framed-IP-Address |
2.3.4.1 | := |
<br>
| 3 | dialrouter | Framed-IP-Netmask |
255.255.255.255 | := |
<br>
| 4 | dialrouter | Framed-Routing |
Broadcast-Listen | := |
<br>
| 5 | dialrouter | Framed-Route | 2.3.4.0
255.255.255.248 | := |
<br>
| 6 | dialrouter | Idle-Timeout | 900
| := |
<br>
+----+------------+-------------------+---------------------------------+------+
<br>
6 rows in set (0.01 sec)
<br>
<br>
mysql> select * from radgroupreply;
<br>
+----+--------------+-----------------------+------------------------+------+
<br>
| id | GroupName | Attribute |
Value | Op |
<br>
+----+--------------+-----------------------+------------------------+------+
<br>
| 34 | dynamic | Framed-Compression |
Van-Jacobsen-TCP-IP | := |
<br>
| 33 | dynamic | Framed-Protocol |
PPP | := |
<br>
| 32 | dynamic | Service-Type |
Framed-User | := |
<br>
| 35 | dynamic | Framed-MTU |
1500 | := |
<br>
| 37 | static | Framed-Protocol |
PPP | := |
<br>
| 38 | static | Service-Type |
Framed-User | := |
<br>
| 39 | static | Framed-Compression |
Van-Jacobsen-TCP-IP | := |
<br>
| 41 | netdial | Service-Type |
Framed-User | := |
<br>
| 42 | netdial | Framed-Protocol |
PPP | := |
<br>
+----+--------------+-----------------------+------------------------+------+
<br>
12 rows in set (0.01 sec)
<br>
<br>
<br>
<br>
thanks
<br>
<br>
<br>
Michael Ziemann
<br>
<br>
<br>
<br>
</div>
</body>
</html>