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

[Marki]

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