|
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 |