Ops, I forgot to mention that you need to remove the “#” from “column_name”, “packet_xlat” and “reply_xlat” e.g: https://github.com/FreeRADIUS/freeradius-server/blob/v3.0.x/raddb/mods-confi...
On 26 Aug 2021, at 13:49, Jorge Pereira <jpereira@freeradius.org> wrote:
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-confi... <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/... <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@freeradius.org
On 26 Aug 2021, at 12:57, Pizu <pizpower@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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html