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

Mon Sep 27 17:48:00 CEST 2021

Hi Jonathan,

Yes, seems I missed that part.

If I wanted to hide something I wouldn't have sent the video. but yes I
forgot to mention that I had to uncomment the certificate part from
the mysql section within the sql part.

Thanks Kristofer Hallin again for your help.

I know this was my mistake but couldn't see what was wrong.

Regards,

Pizu

On Mon, 27 Sept 2021 at 17:34, 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