One not upgraded.. 
Run : apt full-upgrade ( or apt-get dist-upgrade ) 

You still might be missing something. 
 

> -----Oorspronkelijk bericht-----
> Van: Freeradius-Users 
> [mailto:freeradius-users-bounces+belle=bazuin.nl@lists.freerad
ius.org] Namens Pizu
> Verzonden: woensdag 22 september 2021 15:42
> Aan: FreeRadius users mailing list
> Onderwerp: Re: FreeRadius Fresh installation 3.0.23 
> "${dialect}" Reference "${dialect}" not found
> 
> Hi,
> 
> Yes.
> 
> [image: image.png]
> 
> Regards,
> 
> On Wed, 22 Sept 2021 at 15:38, Jonathan Davis 
> <jonathan@prioritycolo.com>
> wrote:
> 
> > Has freeradius-mysql been intalled?
> >
> > Jonathan Davis - Priority Colo Inc.
> > jonathan@prioritycolo.com - https://www.prioritycolo.com
> > 1-888-AS-30176 (1-888-273-0176) x304
> >
> > On 2021-09-22 9:34 a.m., Pizu wrote:
> > > Hi,
> > >
> > > I have just installed FreeRadius from
> > https://networkradius.com/packages/
> > > repo on ubuntu 20.04
> > >
> > > and am having the below error after configuring the 
> dialect to mysql:
> > >
> > > Wed Sep 22 15:21:50 2021 : Info: FreeRADIUS Version 3.0.23
> > > Wed Sep 22 15:21:50 2021 : Info: Copyright (C) 1999-2021 
> The FreeRADIUS
> > > server project and contributors
> > > Wed Sep 22 15:21:50 2021 : Info: There is NO warranty; 
> not even for
> > > MERCHANTABILITY or FITNESS FOR A
> > > Wed Sep 22 15:21:50 2021 : Info: PARTICULAR PURPOSE
> > > Wed Sep 22 15:21:50 2021 : Info: You may redistribute copies of
> > FreeRADIUS
> > > under the terms of the
> > > Wed Sep 22 15:21:50 2021 : Info: GNU General Public License
> > > Wed Sep 22 15:21:50 2021 : Info: For more information about these
> > matters,
> > > see the file named COPYRIGHT
> > > Wed Sep 22 15:21:50 2021 : Info: Starting - reading 
> configuration files
> > ...
> > > Wed Sep 22 15:21:50 2021 : Debug: including dictionary file
> > > /usr/share/freeradius/dictionary
> > > Wed Sep 22 15:21:50 2021 : Debug: including dictionary file
> > > /usr/share/freeradius/dictionary.dhcp
> > > Wed Sep 22 15:21:50 2021 : Debug: including dictionary file
> > > /usr/share/freeradius/dictionary.vqp
> > > Wed Sep 22 15:21:50 2021 : Debug: including dictionary file
> > > /etc/freeradius/dictionary
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/radiusd.conf
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/proxy.conf
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/clients.conf
> > > Wed Sep 22 15:21:50 2021 : Debug: including files in directory
> > > /etc/freeradius/mods-enabled/
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/ldap
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/preprocess
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/ntlm_auth
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/utf8
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/unix
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/realm
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/echo
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/mschap
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/cache_eap
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/expr
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/logintime
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/chap
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/expiration
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/soh
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/replicate
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/dynamic_clients
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/eap
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/totp
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/detail.log
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/radutmp
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/attr_filter
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/exec
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/linelog
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/digest
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/pap
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/detail
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/unpack
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/files
> > > Wed Sep 22 15:21:50 2021 : Debug: including configuration file
> > > /etc/freeradius/mods-enabled/sql
> > >
> > > *Wed Sep 22 15:21:50 2021 : Error: 
> /etc/freeradius/mods-enabled/sql[365]:
> > > Reference "${dialect}" not foundWed Sep 22 15:21:50 2021 
> : Error: Errors
> > > reading or parsing /etc/freeradius/radiusd.co 
> <http://radiusd.co>*nf
> > >
> > >
> > >
> > > in mods-enabled/sql I have the below:
> > >
> > >          dialect = "mysql"
> > >
> > >          driver = "rlm_sql_${dialect}"
> > >
> > > I tried changing it to mysql instead of ${dialect}, still 
> the same error.
> > >
> > > Thanks.
> > > -
> > > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
> > -
> > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
> -
> List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
> 

dialect is also called in the $INCLUDE lower down the config. In mods-config does sql/main/mysql exist? and from the docs: In /etc/raddb/radiusd.conf ensure that the line saying:     $INCLUDE  sql.conf is uncommented. Jonathan Davis - Priority Colo Inc. jonathan@prioritycolo.com - https://www.prioritycolo.com 1-888-AS-30176 (1-888-273-0176) x304 On 2021-09-22 9:41 a.m., Pizu wrote:

Hi,

Yes.

[image: image.png]

Regards,

On Wed, 22 Sept 2021 at 15:38, Jonathan Davis <jonathan@prioritycolo.com> wrote:

...

Has freeradius-mysql been intalled?

Jonathan Davis - Priority Colo Inc. jonathan@prioritycolo.com - https://www.prioritycolo.com 1-888-AS-30176 (1-888-273-0176) x304

...

Hi,

I have just installed FreeRadius from https://networkradius.com/packages/ repo on ubuntu 20.04

and am having the below error after configuring the dialect to mysql:

Wed Sep 22 15:21:50 2021 : Info: FreeRADIUS Version 3.0.23 Wed Sep 22 15:21:50 2021 : Info: Copyright (C) 1999-2021 The FreeRADIUS server project and contributors Wed Sep 22 15:21:50 2021 : Info: There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A Wed Sep 22 15:21:50 2021 : Info: PARTICULAR PURPOSE Wed Sep 22 15:21:50 2021 : Info: You may redistribute copies of FreeRADIUS under the terms of the Wed Sep 22 15:21:50 2021 : Info: GNU General Public License Wed Sep 22 15:21:50 2021 : Info: For more information about these matters, see the file named COPYRIGHT Wed Sep 22 15:21:50 2021 : Info: Starting - reading configuration files ... Wed Sep 22 15:21:50 2021 : Debug: including dictionary file /usr/share/freeradius/dictionary Wed Sep 22 15:21:50 2021 : Debug: including dictionary file /usr/share/freeradius/dictionary.dhcp Wed Sep 22 15:21:50 2021 : Debug: including dictionary file /usr/share/freeradius/dictionary.vqp Wed Sep 22 15:21:50 2021 : Debug: including dictionary file /etc/freeradius/dictionary Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/radiusd.conf Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/proxy.conf Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/clients.conf Wed Sep 22 15:21:50 2021 : Debug: including files in directory /etc/freeradius/mods-enabled/ Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/ldap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/preprocess Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/ntlm_auth Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/utf8 Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/unix Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/realm Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/echo Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/mschap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/cache_eap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/expr Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/logintime Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/chap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/expiration Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/soh Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/replicate Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/dynamic_clients Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/eap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/totp Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/detail.log Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/radutmp Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/attr_filter Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/exec Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/linelog Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/digest Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/pap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/detail Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/unpack Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/files Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/sql

*Wed Sep 22 15:21:50 2021 : Error: /etc/freeradius/mods-enabled/sql[365]: Reference "${dialect}" not foundWed Sep 22 15:21:50 2021 : Error: Errors reading or parsing /etc/freeradius/radiusd.co <http://radiusd.co>*nf

in mods-enabled/sql I have the below:

dialect = "mysql"

driver = "rlm_sql_${dialect}"

I tried changing it to mysql instead of ${dialect}, still the same error.

Thanks. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

On 2021-09-22 9:34 a.m., Pizu wrote: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

In one of your screenshots, the path that is shown is 
/etc/freeradius/mods-conifg

I thought FreeRadius 3 installed to /etc/freeradius/3.0, e.g. 
/etc/freeradius/3.0/mods-config/sql/main

Are there multiple versions of FreeRadius installed (and are you 
possibly editing the wrong mods-enabled/sql)?

Outside of that I've exhausted my knowledge.

Jonathan Davis - Priority Colo Inc.
jonathan@prioritycolo.com - https://www.prioritycolo.com
1-888-AS-30176 (1-888-273-0176) x304

On 2021-09-22 10:02 a.m., Pizu wrote:
> comments in-line.
>
> Thanks all btw for getting back.
>
>
> On Wed, 22 Sept 2021 at 15:56, Jonathan Davis <jonathan@prioritycolo.com>
> wrote:
>
>> dialect is also called in the $INCLUDE lower down the config.
>>
> This line right?        $INCLUDE
> ${modconfdir}/${.:name}/main/${dialect}/queries.conf
>
>
>> In mods-config does sql/main/mysql exist?
>>
> [image: image.png]
>
>
>> and from the docs:
>>
>> In /etc/raddb/radiusd.conf ensure that the line saying:
>>
>>       $INCLUDE  sql.conf
>>
>> is uncommented.
>>
>> I have this:
> [image: image.png]
>
> I believe the above is saying anything in the mods-enable is included..
> correct?
>
>>
>> Jonathan Davis - Priority Colo Inc.
>> jonathan@prioritycolo.com - https://www.prioritycolo.com
>> 1-888-AS-30176 (1-888-273-0176) x304
>>
>> On 2021-09-22 9:41 a.m., Pizu wrote:
>>> Hi,
>>>
>>> Yes.
>>>
>>> [image: image.png]
>>>
>>> Regards,
>>>
>>> On Wed, 22 Sept 2021 at 15:38, Jonathan Davis <jonathan@prioritycolo.com
>>>
>>> wrote:
>>>
>>>> Has freeradius-mysql been intalled?
>>>>
>>>> Jonathan Davis - Priority Colo Inc.
>>>> jonathan@prioritycolo.com - https://www.prioritycolo.com
>>>> 1-888-AS-30176 (1-888-273-0176) x304
>>>>
>>>> On 2021-09-22 9:34 a.m., Pizu wrote:
>>>>> Hi,
>>>>>
>>>>> I have just installed FreeRadius from
>>>> https://networkradius.com/packages/
>>>>> repo on ubuntu 20.04
>>>>>
>>>>> and am having the below error after configuring the dialect to mysql:
>>>>>
>>>>> Wed Sep 22 15:21:50 2021 : Info: FreeRADIUS Version 3.0.23
>>>>> Wed Sep 22 15:21:50 2021 : Info: Copyright (C) 1999-2021 The FreeRADIUS
>>>>> server project and contributors
>>>>> Wed Sep 22 15:21:50 2021 : Info: There is NO warranty; not even for
>>>>> MERCHANTABILITY or FITNESS FOR A
>>>>> Wed Sep 22 15:21:50 2021 : Info: PARTICULAR PURPOSE
>>>>> Wed Sep 22 15:21:50 2021 : Info: You may redistribute copies of
>>>> FreeRADIUS
>>>>> under the terms of the
>>>>> Wed Sep 22 15:21:50 2021 : Info: GNU General Public License
>>>>> Wed Sep 22 15:21:50 2021 : Info: For more information about these
>>>> matters,
>>>>> see the file named COPYRIGHT
>>>>> Wed Sep 22 15:21:50 2021 : Info: Starting - reading configuration files
>>>> ...
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including dictionary file
>>>>> /usr/share/freeradius/dictionary
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including dictionary file
>>>>> /usr/share/freeradius/dictionary.dhcp
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including dictionary file
>>>>> /usr/share/freeradius/dictionary.vqp
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including dictionary file
>>>>> /etc/freeradius/dictionary
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/radiusd.conf
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/proxy.conf
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/clients.conf
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including files in directory
>>>>> /etc/freeradius/mods-enabled/
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/ldap
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/preprocess
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/ntlm_auth
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/utf8
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/unix
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/realm
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/echo
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/mschap
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/cache_eap
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/expr
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/logintime
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/chap
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/expiration
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/soh
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/replicate
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/dynamic_clients
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/eap
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/totp
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/detail.log
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/radutmp
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/attr_filter
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/exec
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/linelog
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/digest
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/pap
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/detail
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/unpack
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/files
>>>>> Wed Sep 22 15:21:50 2021 : Debug: including configuration file
>>>>> /etc/freeradius/mods-enabled/sql
>>>>>
>>>>> *Wed Sep 22 15:21:50 2021 : Error:
>> /etc/freeradius/mods-enabled/sql[365]:
>>>>> Reference "${dialect}" not foundWed Sep 22 15:21:50 2021 : Error:
>> Errors
>>>>> reading or parsing /etc/freeradius/radiusd.co <http://radiusd.co>*nf
>>>>>
>>>>>
>>>>>
>>>>> in mods-enabled/sql I have the below:
>>>>>
>>>>>            dialect = "mysql"
>>>>>
>>>>>            driver = "rlm_sql_${dialect}"
>>>>>
>>>>> I tried changing it to mysql instead of ${dialect}, still the same
>> error.
>>>>> Thanks.
>>>>> -
>>>>> List info/subscribe/unsubscribe? See
>>>> http://www.freeradius.org/list/users.html
>>>> -
>>>> List info/subscribe/unsubscribe? See
>>>> http://www.freeradius.org/list/users.html
>>> -
>>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

On Sep 22, 2021, at 11:17 AM, Pizu <pizpower@gmail.com> wrote:

Hi,

Line 365: $INCLUDE ${modconfdir}/${.:name}/main/${dialect}/queries.conf

Well, then change that ${dialect} to mysql Alan DeKok.

On Sep 22, 2021, at 11:31 AM, Pizu <pizpower@gmail.com> wrote:

After changing that, I have the same error but clearer.

Wed Sep 22 17:21:32 2021 : Error: Unable to open file "/etc/freeradius/mods-config/modules/main/mysql/queries.conf": No such file or directory

The proper directory should be: "/etc/freeradius/mods-config/sql/main/mysql/queries.conf" and not "/etc/freeradius/mods-config/modules/main/mysql/queries.conf"

This doesn't happen to anyone else, and we don't see it in any of our tests. I'm not sure what's broken on your system, but it's something I've never seen before. Alan DeKok.

Hi, Same issue :( Regards, On Wed, 22 Sept 2021 at 17:44, Pizu <pizpower@gmail.com> wrote:

Hi,

Well this is a Fresh Ubuntu installation with Freeradius fresh installed, tomorrow will wipe everything and install the OS + FreeRadius from scratch.

Regards,

Pizu

On Wed, 22 Sept 2021 at 17:41, Alan DeKok <aland@deployingradius.com> wrote:

...

On Sep 22, 2021, at 11:31 AM, Pizu <pizpower@gmail.com> wrote:

...

After changing that, I have the same error but clearer.

Wed Sep 22 17:21:32 2021 : Error: Unable to open file "/etc/freeradius/mods-config/modules/main/mysql/queries.conf": No such file or directory

The proper directory should be: "/etc/freeradius/mods-config/sql/main/mysql/queries.conf" and not "/etc/freeradius/mods-config/modules/main/mysql/queries.conf"

This doesn't happen to anyone else, and we don't see it in any of our tests. I'm not sure what's broken on your system, but it's something I've never seen before.

Alan DeKok.

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Steps from documentation I did when installing my other 2 freeradius
servers.. (which are working)

The only difference between the other 2 servers and this is that this is a
physical server and the others are VM(s)

Instructions from "https://networkradius.com/packages/"
apt install freeradius freeradius-mysql freeradius-krb5 freeradius-ldap
mariadb-server mariadb-client

cd /etc/freeradius/sites-enabled
ln -s ../sites-available/status status

cd /etc/freeradius/mods-enabled
ln -s ../mods-available/ldap ldap
ln -s ../mods-available/sql sql

on all servers I don't have the /modules/ folder or the /3.0/ folder.

This is very strange :(

Regards,




On Thu, 23 Sept 2021 at 14:42, Jonathan Davis <jonathan@prioritycolo.com>
wrote:

> I setup a new box not more than a month ago, Ubuntu 20.04.3 LTS with
> freeradius/focal,now 3.0.20+dfsg-3build1 amd64
>
> FreeRadius installed to /etc/freeradius/3.0/
>
> I had problems (due to yubico's pam module and not reading the docs
> thoroughly), but not the one you experienced. I'm still curious how the
> name for the sql module is being changed from sql to modules.
>
> What steps did you take, did you edit any other configs, what docs are
> you following?
>
>
> On 2021-09-23 8:19 a.m., Pizu wrote:
>
> > Hi,
> >
> > Same issue :(
> >
> > Regards,
> >
> >
> >
> > On Wed, 22 Sept 2021 at 17:44, Pizu <pizpower@gmail.com> wrote:
> >
> >> Hi,
> >>
> >> Well this is a Fresh Ubuntu installation with Freeradius fresh
> installed,
> >> tomorrow will wipe everything and install the OS + FreeRadius from
> scratch.
> >>
> >> Regards,
> >>
> >> Pizu
> >>
> >>
> >> On Wed, 22 Sept 2021 at 17:41, Alan DeKok <aland@deployingradius.com>
> >> wrote:
> >>
> >>> On Sep 22, 2021, at 11:31 AM, Pizu <pizpower@gmail.com> wrote:
> >>>> After changing that, I have the same error but clearer.
> >>>>
> >>>> Wed Sep 22 17:21:32 2021 : Error: Unable to open file
> >>>> "/etc/freeradius/mods-config/modules/main/mysql/queries.conf": No such
> >>> file
> >>>> or directory
> >>>>
> >>>> The proper directory should be:
> >>>> "/etc/freeradius/mods-config/sql/main/mysql/queries.conf" and not
> >>>> "/etc/freeradius/mods-config/modules/main/mysql/queries.conf"
> >>>    This doesn't happen to anyone else, and we don't see it in any of
> our
> >>> tests.  I'm not sure what's broken on your system, but it's something
> I've
> >>> never seen before.
> >>>
> >>>    Alan DeKok.
> >>>
> >>>
> >>> -
> >>> List info/subscribe/unsubscribe? See
> >>> http://www.freeradius.org/list/users.html
> >>
> > -
> > List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html

Hi, Debugging Logs with -X -xx root@tstmstfreerad01:/etc/freeradius# freeradius -X -xx Thu Sep 23 15:06:32 2021 : Debug: Server was built with: Thu Sep 23 15:06:32 2021 : Debug: accounting : yes Thu Sep 23 15:06:32 2021 : Debug: authentication : yes Thu Sep 23 15:06:32 2021 : Debug: ascend-binary-attributes : yes Thu Sep 23 15:06:32 2021 : Debug: coa : yes Thu Sep 23 15:06:32 2021 : Debug: control-socket : yes Thu Sep 23 15:06:32 2021 : Debug: detail : yes Thu Sep 23 15:06:32 2021 : Debug: dhcp : yes Thu Sep 23 15:06:32 2021 : Debug: dynamic-clients : yes Thu Sep 23 15:06:32 2021 : Debug: osfc2 : no Thu Sep 23 15:06:32 2021 : Debug: proxy : yes Thu Sep 23 15:06:32 2021 : Debug: regex-pcre : no Thu Sep 23 15:06:32 2021 : Debug: regex-posix : yes Thu Sep 23 15:06:32 2021 : Debug: regex-posix-extended : yes Thu Sep 23 15:06:32 2021 : Debug: session-management : yes Thu Sep 23 15:06:32 2021 : Debug: stats : yes Thu Sep 23 15:06:32 2021 : Debug: systemd : yes Thu Sep 23 15:06:32 2021 : Debug: tcp : yes Thu Sep 23 15:06:32 2021 : Debug: threads : yes Thu Sep 23 15:06:32 2021 : Debug: tls : yes Thu Sep 23 15:06:32 2021 : Debug: unlang : yes Thu Sep 23 15:06:32 2021 : Debug: vmps : yes Thu Sep 23 15:06:32 2021 : Debug: developer : no Thu Sep 23 15:06:32 2021 : Debug: Server core libs: Thu Sep 23 15:06:32 2021 : Debug: freeradius-server : 3.0.23 Thu Sep 23 15:06:32 2021 : Debug: talloc : 2.3.* Thu Sep 23 15:06:32 2021 : Debug: ssl : 1.1.1f release Thu Sep 23 15:06:32 2021 : Debug: Endianness: Thu Sep 23 15:06:32 2021 : Debug: little Thu Sep 23 15:06:32 2021 : Debug: Compilation flags: Thu Sep 23 15:06:32 2021 : Debug: cppflags : -Wdate-time -D_FORTIFY_SOURCE=2 Thu Sep 23 15:06:32 2021 : Debug: cflags : -I. -Isrc -include src/freeradius-devel/autoconf.h -include src/freeradius-devel/build.h -include src/freeradius-devel/features.h -include src/freeradius-devel/radpaths.h -fno-strict-aliasing -g -O2 -fdebug-prefix-map=/srv/jenkins/workspace/freeradius-release-3.0/build-packages/platforms/ubuntu20/freeradius-server=. -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2 -O2 -Wall -std=c99 -D_GNU_SOURCE -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -DOPENSSL_NO_KRB5 -DNDEBUG -DIS_MODULE=1 Thu Sep 23 15:06:32 2021 : Debug: ldflags : -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now Thu Sep 23 15:06:32 2021 : Debug: libs : -lcrypto -lssl -ltalloc -latomic -lcap -lnsl -lresolv -ldl -lpthread -lreadline Thu Sep 23 15:06:32 2021 : Debug: Thu Sep 23 15:06:32 2021 : Info: FreeRADIUS Version 3.0.23 Thu Sep 23 15:06:32 2021 : Info: Copyright (C) 1999-2021 The FreeRADIUS server project and contributors Thu Sep 23 15:06:32 2021 : Info: There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A Thu Sep 23 15:06:32 2021 : Info: PARTICULAR PURPOSE Thu Sep 23 15:06:32 2021 : Info: You may redistribute copies of FreeRADIUS under the terms of the Thu Sep 23 15:06:32 2021 : Info: GNU General Public License Thu Sep 23 15:06:32 2021 : Info: For more information about these matters, see the file named COPYRIGHT Thu Sep 23 15:06:32 2021 : Info: Starting - reading configuration files ... Thu Sep 23 15:06:32 2021 : Debug: including dictionary file /usr/share/freeradius/dictionary Thu Sep 23 15:06:32 2021 : Debug: including dictionary file /usr/share/freeradius/dictionary.dhcp Thu Sep 23 15:06:32 2021 : Debug: including dictionary file /usr/share/freeradius/dictionary.vqp Thu Sep 23 15:06:32 2021 : Debug: including dictionary file /etc/freeradius/dictionary Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/radiusd.conf Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/proxy.conf Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/clients.conf Thu Sep 23 15:06:32 2021 : Debug: including files in directory /etc/freeradius/mods-enabled/ Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/echo Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/ntlm_auth Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/sradutmp Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/soh Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/date Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/radutmp Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/exec Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/passwd Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/chap Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/dynamic_clients Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/always Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/pap Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/totp Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/mschap Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/digest Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/files Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/utf8 Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/linelog Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/ldap Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/replicate Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/logintime Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/unpack Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/preprocess Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/detail Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/unix Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/expiration Thu Sep 23 15:06:32 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/sql Thu Sep 23 15:06:32 2021 : Error: /etc/freeradius/mods-enabled/sql[365]: Reference "${dialect}" not found Thu Sep 23 15:06:32 2021 : Error: Errors reading or parsing /etc/freeradius/radiusd.conf Regards, On Thu, 23 Sept 2021 at 15:03, Alan DeKok <aland@deployingradius.com> wrote:

On Sep 23, 2021, at 8:50 AM, Pizu <pizpower@gmail.com> wrote

...

Steps from documentation I did when installing my other 2 freeradius servers.. (which are working)

The only difference between the other 2 servers and this is that this is a physical server and the others are VM(s)

That shouldn't matter.

...

Instructions from "https://networkradius.com/packages/" apt install freeradius freeradius-mysql freeradius-krb5 freeradius-ldap mariadb-server mariadb-client

cd /etc/freeradius/sites-enabled ln -s ../sites-available/status status

cd /etc/freeradius/mods-enabled ln -s ../mods-available/ldap ldap ln -s ../mods-available/sql sql

on all servers I don't have the /modules/ folder or the /3.0/ folder.

The default Debian / Ubuntu packages put the configuration into /etc/freeradius/3.0. The Network RADIUS packages don't.

...

This is very strange :(

It is exceedingly strange that there's a magic "modules/main" thing added there.

At this point, I'd suggest posting the entire debug output. There's something broken in your system. Maybe the debug output is more informative.

Alan DeKok.

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

I am going to format it and install ESXi and will create a VM and will give you an update. Regards, On Thu, 23 Sept 2021 at 15:14, Alan DeKok <aland@deployingradius.com> wrote:

On Sep 23, 2021, at 9:07 AM, Pizu <pizpower@gmail.com> wrote:

...

Debugging Logs with -X -xx

...

Well, that's not helpful/

I really don't know what to say here. No one else has seen this.

Alan DeKok.

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Hi, This is a formated server, fresh Ubuntu installation and fresh freeradius installation, just did the above mentioned configuration. I.e sym linked the LDAP/SQL/Status mods and site and changed the dialect from SQLite to MySQL and driver from null to use the dialect that's all the configuration. I cannot understand what I did wrong here :( The same procedure for all servers.. On Thu, 23 Sep 2021, 16:06 Alan DeKok, <aland@deployingradius.com> wrote:

On Sep 23, 2021, at 9:22 AM, Pizu <pizpower@gmail.com> wrote:

...

I am going to format it and install ESXi and will create a VM and will

give

...

you an update.

I suspect what happened is that you broke the configuration, and then kept re-installing the packages, hoping that would fix it.

The problem is that the packages don't wipe your configuration and install the new ones. That's so you can upgrade the server by installing the new package, and it won't break a production system.

So as always, if you make a change:

* test it before the change. Make sure it works

* make the change

* test it after the change. If it doesn't work, then the problem is the change you made. Don't do anything else until you fix the configuration.

Alan DeKok.

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Hi,

Yes vm I have no issues. Live setup is on same os version and same
freeradius version.

Physical server I have issue, tomorrow I am going to try a
different physical server as the current one is old and cannot install esxi
on it, it's not supported.

Will keep you all updated.

Thanks & Regards

On Thu, 23 Sep 2021, 16:50 Kristofer Hallin, <kristofer@sunet.se> wrote:

> Hi,
>
> I got curious and started a fresh VM with Ubuntu myself (Ubuntu 20.04.2
> LTS). I installed the packages from NetworkRADIUS and symlinked status, sql
> and ldap just like you did. I then changed dialect in sql from sqlite to
> mysql and restarted FreeRADIUS without seeing the same issue as you do (TLS
> for MySQL, LDAP config etc are out of the scope here).
>
> The sql configuration now has the following two lines for dialect and
> driver:
>
>   dialect = "mysql"
>   driver = "rlm_sql_${dialect}"
>
> And that was the _only_ change I made to the configuration and it works.
>
> BR,
> /K
>
> —
> Kristofer Hallin
> SUNET
> On 23 Sep 2021, 16:17 +0200, Pizu <pizpower@gmail.com>, wrote:
> > Hi,
> >
> > This is a formated server, fresh Ubuntu installation and fresh freeradius
> > installation, just did the above mentioned configuration. I.e sym linked
> > the LDAP/SQL/Status mods and site and changed the dialect from SQLite to
> > MySQL and driver from null to use the dialect that's all the
> configuration.
> > I cannot understand what I did wrong here :( The same procedure for all
> > servers..
> >
> >
> >
> > On Thu, 23 Sep 2021, 16:06 Alan DeKok, <aland@deployingradius.com>
> wrote:
> >
> > > On Sep 23, 2021, at 9:22 AM, Pizu <pizpower@gmail.com> wrote:
> > > >
> > > > I am going to format it and install ESXi and will create a VM and
> will
> > > give
> > > > you an update.
> > >
> > > I suspect what happened is that you broke the configuration, and then
> > > kept re-installing the packages, hoping that would fix it.
> > >
> > > The problem is that the packages don't wipe your configuration and
> > > install the new ones. That's so you can upgrade the server by
> installing
> > > the new package, and it won't break a production system.
> > >
> > > So as always, if you make a change:
> > >
> > > * test it before the change. Make sure it works
> > >
> > > * make the change
> > >
> > > * test it after the change. If it doesn't work, then the problem is the
> > > change you made. Don't do anything else until you fix the
> configuration.
> > >
> > > Alan DeKok.
> > >
> > >
> > > -
> > > List info/subscribe/unsubscribe? See
> > > http://www.freeradius.org/list/users.html
> > -
> > List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html

I also doubt that to be the root cause.
I also doubt that replacing the physical server changes anything.

But if any of it holds true, it will give a nice story ;)

I suspect OP is not giving all the information of what he is doing / 
doing differently in VM and physical server. Just like in August ("I did 
stuff and it didn't work"[tm])

How are you installing the server / VM? Is it all manually? Is there any 
configuration mgmt / deployment / CI tool involved?
Are you using _exactly_ the same repos both times and _exactly_ the same OS?
Please provide output of "apt-cache policy" and "cat /etc/os-release" 
and "uname -a".

Please stop posting images/screenshots of any command results. Use text 
and format it properly.

_Before_ issuing for example any "ln" commands, have you checked the 
contents of the directories you are manipulating?
Check that everything is as it should be before issuing any commands.
Issue the commands.
Then check if they did what they were supposed to do.

On 9/23/2021 6:27 PM, Kristofer Hallin wrote:
> How on earth can this possibly be different on a physical machine compared to a virtual?
>
>> On 23 Sep 2021, at 18:23, Pizu <pizpower@gmail.com> wrote:
>>
>> Hi,
>>
>> Yes vm I have no issues. Live setup is on same os version and same
>> freeradius version.
>>
>> Physical server I have issue, tomorrow I am going to try a
>> different physical server as the current one is old and cannot install esxi
>> on it, it's not supported.
>>
>> Will keep you all updated.
>>
>> Thanks & Regards
>>
>>> On Thu, 23 Sep 2021, 16:50 Kristofer Hallin, <kristofer@sunet.se> wrote:
>>>
>>> Hi,
>>>
>>> I got curious and started a fresh VM with Ubuntu myself (Ubuntu 20.04.2
>>> LTS). I installed the packages from NetworkRADIUS and symlinked status, sql
>>> and ldap just like you did. I then changed dialect in sql from sqlite to
>>> mysql and restarted FreeRADIUS without seeing the same issue as you do (TLS
>>> for MySQL, LDAP config etc are out of the scope here).
>>>
>>> The sql configuration now has the following two lines for dialect and
>>> driver:
>>>
>>>   dialect = "mysql"
>>>   driver = "rlm_sql_${dialect}"
>>>
>>> And that was the _only_ change I made to the configuration and it works.
>>>
>>> BR,
>>> /K
>>>
>>> —
>>> Kristofer Hallin
>>> SUNET
>>>> On 23 Sep 2021, 16:17 +0200, Pizu <pizpower@gmail.com>, wrote:
>>>> Hi,
>>>>
>>>> This is a formated server, fresh Ubuntu installation and fresh freeradius
>>>> installation, just did the above mentioned configuration. I.e sym linked
>>>> the LDAP/SQL/Status mods and site and changed the dialect from SQLite to
>>>> MySQL and driver from null to use the dialect that's all the
>>> configuration.
>>>> I cannot understand what I did wrong here :( The same procedure for all
>>>> servers..
>>>>
>>>>
>>>>
>>>> On Thu, 23 Sep 2021, 16:06 Alan DeKok, <aland@deployingradius.com>
>>> wrote:
>>>>> On Sep 23, 2021, at 9:22 AM, Pizu <pizpower@gmail.com> wrote:
>>>>>> I am going to format it and install ESXi and will create a VM and
>>> will
>>>>> give
>>>>>> you an update.
>>>>> I suspect what happened is that you broke the configuration, and then
>>>>> kept re-installing the packages, hoping that would fix it.
>>>>>
>>>>> The problem is that the packages don't wipe your configuration and
>>>>> install the new ones. That's so you can upgrade the server by
>>> installing
>>>>> the new package, and it won't break a production system.
>>>>>
>>>>> So as always, if you make a change:
>>>>>
>>>>> * test it before the change. Make sure it works
>>>>>
>>>>> * make the change
>>>>>
>>>>> * test it after the change. If it doesn't work, then the problem is the
>>>>> change you made. Don't do anything else until you fix the
>>> configuration.
>>>>> Alan DeKok.
>>>>>
>>>>>
>>>>> -
>>>>> List info/subscribe/unsubscribe? See
>>>>> http://www.freeradius.org/list/users.html
>>>> -
>>>> List info/subscribe/unsubscribe? See
>>> http://www.freeradius.org/list/users.html
>>> -
>>> List info/subscribe/unsubscribe? See
>>> http://www.freeradius.org/list/users.html
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

You shouldn't take this personal.
The golden rule of IT Support is "Everybody lies".
People mostly do it unwittingly.
Happens to everyone from time to time, including myself.
People leave out details in their thought process (hence in their 
support queries) because they think they are unimportant. However since 
things are going bad for them and they ask for support, they shouldn't 
leave out anything beforehand and let the person(s) they are asking for 
help decide what is important and what is not.
As someone pointed out before, you need to adopt a very systematic 
approach diagnosing this issue since it is very strange indeed.
"Do you suggest I am lying" does not help.
Questioning oneself is one of the primary qualities of IT engineers.
*Something* is clearly interfering with some of your installations. It's 
either some automatic process or it's yourself.
No insult intended.

On 9/23/2021 11:46 PM, Pizu wrote:
> Hmm are you suggesting I am lying? Why should I? I need help that is why I
> asked for help. I don't need to lie to get help.
>
> I am installing the OS from a USB, formatted with Rufus with Ubuntu server
> iso download from the official site.
>
> The VM is being installed by mounting the iso. Same iso.
>
> Gn
>
>
>
>
> On Thu, 23 Sep 2021, 19:02 Marki, <jm+freeradiususer@roth.lu> wrote:
>
>> I also doubt that to be the root cause.
>> I also doubt that replacing the physical server changes anything.
>>
>> But if any of it holds true, it will give a nice story ;)
>>
>> I suspect OP is not giving all the information of what he is doing /
>> doing differently in VM and physical server. Just like in August ("I did
>> stuff and it didn't work"[tm])
>>
>> How are you installing the server / VM? Is it all manually? Is there any
>> configuration mgmt / deployment / CI tool involved?
>> Are you using _exactly_ the same repos both times and _exactly_ the same
>> OS?
>> Please provide output of "apt-cache policy" and "cat /etc/os-release"
>> and "uname -a".
>>
>> Please stop posting images/screenshots of any command results. Use text
>> and format it properly.
>>
>> _Before_ issuing for example any "ln" commands, have you checked the
>> contents of the directories you are manipulating?
>> Check that everything is as it should be before issuing any commands.
>> Issue the commands.
>> Then check if they did what they were supposed to do.
>>
>> On 9/23/2021 6:27 PM, Kristofer Hallin wrote:
>>> How on earth can this possibly be different on a physical machine
>> compared to a virtual?
>>>> On 23 Sep 2021, at 18:23, Pizu <pizpower@gmail.com> wrote:
>>>>
>>>> Hi,
>>>>
>>>> Yes vm I have no issues. Live setup is on same os version and same
>>>> freeradius version.
>>>>
>>>> Physical server I have issue, tomorrow I am going to try a
>>>> different physical server as the current one is old and cannot install
>> esxi
>>>> on it, it's not supported.
>>>>
>>>> Will keep you all updated.
>>>>
>>>> Thanks & Regards
>>>>
>>>>> On Thu, 23 Sep 2021, 16:50 Kristofer Hallin, <kristofer@sunet.se>
>> wrote:
>>>>> Hi,
>>>>>
>>>>> I got curious and started a fresh VM with Ubuntu myself (Ubuntu 20.04.2
>>>>> LTS). I installed the packages from NetworkRADIUS and symlinked
>> status, sql
>>>>> and ldap just like you did. I then changed dialect in sql from sqlite
>> to
>>>>> mysql and restarted FreeRADIUS without seeing the same issue as you do
>> (TLS
>>>>> for MySQL, LDAP config etc are out of the scope here).
>>>>>
>>>>> The sql configuration now has the following two lines for dialect and
>>>>> driver:
>>>>>
>>>>>    dialect = "mysql"
>>>>>    driver = "rlm_sql_${dialect}"
>>>>>
>>>>> And that was the _only_ change I made to the configuration and it
>> works.
>>>>> BR,
>>>>> /K
>>>>>
>>>>> —
>>>>> Kristofer Hallin
>>>>> SUNET
>>>>>> On 23 Sep 2021, 16:17 +0200, Pizu <pizpower@gmail.com>, wrote:
>>>>>> Hi,
>>>>>>
>>>>>> This is a formated server, fresh Ubuntu installation and fresh
>> freeradius
>>>>>> installation, just did the above mentioned configuration. I.e sym
>> linked
>>>>>> the LDAP/SQL/Status mods and site and changed the dialect from SQLite
>> to
>>>>>> MySQL and driver from null to use the dialect that's all the
>>>>> configuration.
>>>>>> I cannot understand what I did wrong here :( The same procedure for
>> all
>>>>>> servers..
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Thu, 23 Sep 2021, 16:06 Alan DeKok, <aland@deployingradius.com>
>>>>> wrote:
>>>>>>> On Sep 23, 2021, at 9:22 AM, Pizu <pizpower@gmail.com> wrote:
>>>>>>>> I am going to format it and install ESXi and will create a VM and
>>>>> will
>>>>>>> give
>>>>>>>> you an update.
>>>>>>> I suspect what happened is that you broke the configuration, and then
>>>>>>> kept re-installing the packages, hoping that would fix it.
>>>>>>>
>>>>>>> The problem is that the packages don't wipe your configuration and
>>>>>>> install the new ones. That's so you can upgrade the server by
>>>>> installing
>>>>>>> the new package, and it won't break a production system.
>>>>>>>
>>>>>>> So as always, if you make a change:
>>>>>>>
>>>>>>> * test it before the change. Make sure it works
>>>>>>>
>>>>>>> * make the change
>>>>>>>
>>>>>>> * test it after the change. If it doesn't work, then the problem is
>> the
>>>>>>> change you made. Don't do anything else until you fix the
>>>>> configuration.
>>>>>>> Alan DeKok.
>>>>>>>
>>>>>>>
>>>>>>> -
>>>>>>> List info/subscribe/unsubscribe? See
>>>>>>> http://www.freeradius.org/list/users.html
>>>>>> -
>>>>>> List info/subscribe/unsubscribe? See
>>>>> http://www.freeradius.org/list/users.html
>>>>> -
>>>>> List info/subscribe/unsubscribe? See
>>>>> http://www.freeradius.org/list/users.html
>>>> -
>>>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>> -
>>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html