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

Mon Sep 27 16:55:28 CEST 2021

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