Importing users and nas clients from the radius files to a mysql database

[Conrad Classen]

Hi Jochem

This still leaves me with the need to convert several thousand user 
records into a csv format which daloradius can import.

Either way, the same baseline issue exists.

I had a look at the "users2mysql.pl" included in the freeradius source 
code, however that was designed to be used with freeradius 0.7 and most 
of the perl script would need to be changed/replaced to work with newer 
freedaius versions.

Many thanks

Conrad

On 2024/07/23 08:12, Jochem Sparla wrote:
> Not specifically from the RADIUS files itself, but you can take a look at DaloRADIUS.
>
> It's a web interface to a (mariadb) database for use with FreeRADIUS.
> It has import options. Maybe you can modify the RADIUS text files to work with this.
>
> Greetings, Jochem
>
>
> -----Oorspronkelijk bericht-----
> Van: Freeradius-Users<freeradius-users-bounces+j.sparla=iolan.com at lists.freeradius.org>  Namens Conrad Classen
> Verzonden: maandag 22 juli 2024 16:19
> Aan:freeradius-users at lists.freeradius.org
> Onderwerp: Importing users and nas clients from the radius files to a mysql database
>
> Hi
>
> Is there a tool that can be run (Linux Rocky9) to import the freeradius users and the nas clients to a mysql (mariadb) database?
>
> If so, please can you point me to it ...--
>
> Conrad
> -
> List info/subscribe/unsubscribe? Seehttp://www.freeradius.org/list/users.html
> -
> List info/subscribe/unsubscribe? Seehttp://www.freeradius.org/list/users.html