Freeradius-Users Digest, Vol 46, Issue 102 Why is groupname fieldblank in radacct

tnt at tnt at
Thu Feb 26 11:34:28 CET 2009

>I have MySQL 5.0.67 and PostgreSQL 8.3.6 and freeRADIUS 2.17 installed on
>GNU/Linux Fedora 10 distribution. I have identical radius databases on both
>MySQL and PostgreSQL. When I use the PostgreSQL, the groupname field in the
>radacct table gets filled in but when I change the database to MySQL, the
>groupname filled is blank. I checked the queries in mysql/diaup.conf and
>postgresql/dialup.conf and found out that they are the same. Why is it
>working with PostgreSQL and not working with MySQL? The groupnames are
>defined in radusergroup table.

Default queries that come with the source don't write to groupname
field. MySQL or PostgreSQL. You can place Class in radgroupreply and
give it the value of the group name. Then put %{Class} into groupname
field in accounting queries.

Ivan Kalik
Kalik Informatika ISP

More information about the Freeradius-Users mailing list