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

Jonathan Davis jonathan at prioritycolo.com
Mon Sep 27 17:33:33 CEST 2021 

so there we changes further than updating the dialect ?

> On Sep 27, 2021, at 11:10 AM, Pizu <pizpower at gmail.com> wrote:
> 
> Hi,
> 
> You are 100% right. now it worked. I did that same thing on both servers
> and now it worked on both of them.
> 
> Thanks for watching the videos. I was desperate.. couldn't see what I was
> doing wrong.
> 
> Regards,
> 
> 
> 
> 
>> On Mon, 27 Sept 2021 at 16:56, Kristofer Hallin <kristofer at sunet.se> wrote:
>> 
>> Second movie, 02:19: you have to balance the brackets. Your configuration
>> can NOT look like this:
>> 
>> mysql {
>>        }
>>        warnings = auto
>> }
>> 
>> 
>> —
>> Kristofer Hallin
>> SUNET
>>> On 27 Sep 2021, 16:34 +0200, Pizu <pizpower at gmail.com>, wrote:
>>> Hi,
>>> 
>>> Videos uploaded here:
>>> https://www.transfernow.net/dl/20210927VzhbhVO0
>>> 
>>> Regards,
>>> 
>>> 
>>> 
>>> 
>>>> On Mon, 27 Sept 2021 at 16:16, Pizu <pizpower at gmail.com> wrote:
>>> 
>>>> Hi,
>>>> 
>>>> @Marki
>>>> So the OS is being installed manually from a usb stick and attached.
>> You
>>>> may find the recording of my screen installing the freeradius on a
>> fresh
>>>> ubuntu installation.
>>>> 
>>>> The recording is in 2 videos.
>>>> 
>>>> @Alan if you need anything else from me please let me know in the
>> videos
>>>> as you can see I am not doing anything special :(
>>>> 
>>>> Regards,
>>>> 
>>>> 
>>>> 
>>>> 
>>>> On Fri, 24 Sept 2021 at 00:58, Marki <jm+freeradiususer at roth.lu>
>> wrote:
>>>> 
>>>>> 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 at 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 at 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 at 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 at 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 at deployingradius.com>
>>>>>>>>>> wrote:
>>>>>>>>>>>> On Sep 23, 2021, at 9:22 AM, Pizu <pizpower at 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
>>>>> -
>>>>> 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