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