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

[marki]

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.