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

Jonathan Davis jonathan at prioritycolo.com
Wed Sep 22 16:11:09 CEST 2021 

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 at 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 at 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 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
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

More information about the Freeradius-Users mailing list