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