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

[Pizu]

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
>
>