Correct way of redefining sql queries

[Jiří Hromádka]

Thank you Alan
 

On 09.03.2022 13:21, "Freeradius-Users on behalf of Alan DeKok" <freeradius-users-bounces+hrom.jiri=gmail.com at lists.freeradius.org on behalf of aland at deployingradius.com> wrote:

    On Mar 8, 2022, at 5:36 PM, Jiří Hromádka <hrom.jiri at gmail.com> wrote:
    > I’d like to ask what is the correct way to redefine some main sql queries in mods-config and don’t change default files so any updates won’t stop asking what version I want?
    > 
    > Let’s say I need to add few more conditions to “authorize_check_query” in sql/main/mysql/queries.conf. Editing this file directly will make future updates stops, asking me which version to use (in case this file is changed in new version)

      Exactly.

    > I’ve created new file with redefined query and included that file at the end of the rlm_sql instance definition, right before include of default queries.conf with other queries definition. Based on debug output, I can see that authorize_check_query contains my changed SQL query.

      That's fine.

    > The question is, is this correct way to do this or is there better one?

      That's the correct way.

      Alan DeKok.

    -
    List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html