MySQL db parameters

[tnt at kalik.co.yu]

http://www.freeradius.org/rfc/attributes.html

What freeradius version are you using? That profile is some years out of
date. In last few versions you shouldn't be setting up Auth-Type at all
and you should use Cleartext-Password with := as op.

Ivan Kalik
Kalik Informatika ISP


Dana 6/8/2007, "Michael Ziemann" <mailinglist at ziemann-perl.de> piše:

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