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

Mon Sep 27 22:38:26 CEST 2021

:clap

On Mon, 27 Sep 2021, 20:29 marki, <jm+freeradiususer at roth.lu> wrote:

> As I wrote ;)
>
> On September 27, 2021 5:33:33 PM GMT+02:00, Jonathan Davis <
> jonathan at prioritycolo.com> wrote:
> >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
> >
> >
> >-
> >List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html