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

Pizu pizpower at gmail.com
Wed Sep 22 16:02:21 CEST 2021 

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 11008 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20210922/b0b1c6a5/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 55122 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20210922/b0b1c6a5/attachment-0003.png>

More information about the Freeradius-Users mailing list