MySQL db parameters

Michael Ziemann mailinglist at ziemann-perl.de
Mon Aug 6 11:36:44 CEST 2007


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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070806/09b52d53/attachment.html>


More information about the Freeradius-Users mailing list