Hi Michael,

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

The "parameters" are RADIUS attributes, as defined in the various RFCs about RADIUS. Which ones to use depends on what you want to do. Nice to see someone from Perl on this list here (I'm from Besch) :-) Stefan Winter -- Stefan WINTER Stiftung RESTENA - Réseau Téléinformatique de l'Education Nationale et de la Recherche Ingenieur Forschung & Entwicklung 6, rue Richard Coudenhove-Kalergi L-1359 Luxembourg E-Mail: stefan.winter@restena.lu     Tel.:    +352 424409-1 http://www.restena.lu               Fax:      +352 422473

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