User Class

[Jorge Pereira]

Pizu,

Of course, just need to update the raddb/mods-config/sql/main/queries.conf, therefore the latest 3.0.23 version is coming up with that changes as can be seen in our repo https://github.com/FreeRADIUS/freeradius-server/blob/v3.0.x/raddb/mods-config/sql/main/mysql/queries.conf#L71 <https://github.com/FreeRADIUS/freeradius-server/blob/v3.0.x/raddb/mods-config/sql/main/mysql/queries.conf#L71> or if you don’t have any special modification in your local raddb/mods-config/sql/main/queries.conf, just overwrite your local queries.conf with the the latest like:

e.g:

$ cp /etc/raddb/mods-config/sql/main/queries.conf /etc/raddb/mods-config/sql/main/queries.conf.bak
$ curl -o /etc/raddb/mods-config/sql/main/queries.conf https://raw.githubusercontent.com/FreeRADIUS/freeradius-server/v3.0.x/raddb/mods-config/sql/main/mysql/queries.conf <https://raw.githubusercontent.com/FreeRADIUS/freeradius-server/v3.0.x/raddb/mods-config/sql/main/mysql/queries.conf>

If you got some error, report and just revert to the .bak

--
Jorge Pereira
jpereira at freeradius.org




> On 26 Aug 2021, at 12:57, Pizu <pizpower at gmail.com> wrote:
> 
> Hi,
> 
> Currently on the MySQL database the class is remaining NULL and in the log
> files the class is being written mixed numbers/letters.
> 
> log file:
> 
> Class = 0x5253534f2d49542d4e6574776f726b696e67
> 
> in db:
> 
> [image: image.png]
> 
> Is it possible to write the actual value in the database and in the log
> file?
> 
> Thanks.
> <image.png>-
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html