FreeRadius Fresh installation 3.0.23 "${dialect}" Reference "${dialect}" not found

[Jonathan Davis]

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 at 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 at prioritycolo.com>
> wrote:
>
>> Has freeradius-mysql been intalled?
>>
>> Jonathan Davis - Priority Colo Inc.
>> jonathan at 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