[GTER] Ajuda freeradius

Carlos Eduardo Tavares Terra eduardo at eduardoterra.com
Sat Mar 14 10:52:56 -03 2020


Verifique como está a configuração do módulo SQL.
Provavelmente no caminho: /etc/freeradius/3.0/mods-available/sql

        #
        # The group attribute specific to this instance of rlm_sql
        #

        # This entry should be used for additional instances (sql foo {})
        # of the SQL module.
*#       group_attribute = "${.:instance}-SQL-Group"*

        # This entry should be used for the default instance (sql {})
        # of the SQL module.
*        group_attribute = "SQL-Group"*

        # Read database-specific queries
        $INCLUDE ${modconfdir}/${.:name}/main/${dialect}/queries.conf

On 14/03/2020 10:15, Juliano GigaNET wrote:
> Bom dia.
>
> Adicionei um novo NAS e tive que reiniciar o meu freeradius. Com isso
> comecou minha dor de cabeça.
>
> Me mostra a mensagem de erro abaixo
>
> Mar 14 11:55:44 radius01 freeradius[17893]:
> /etc/freeradius/3.0/mods-config/sql/main/mysql/queries.conf[145]:
> Reference "${group_attribute}" not found
> Mar 14 11:55:44 radius01 freeradius[17893]:
> /etc/freeradius/3.0/mods-config/sql/main/mysql/queries.conf[152]:
> Reference "${group_attribute}" not found
> Mar 14 11:55:44 radius01 freeradius[17893]:
> /etc/freeradius/3.0/mods-config/sql/main/mysql/queries.conf[145]:
> Reference "${group_attribute}" not found
>
> no arquivo query.conf sao as linhas
>
> authorize_group_check_query = "\
>         SELECT id, groupname, attribute, \
>         Value, op \
>         FROM ${groupcheck_table} \
>         WHERE groupname = '%{${group_attribute}}' \
>         ORDER BY id"
>
> authorize_group_reply_query = "\
>         SELECT id, groupname, attribute, \
>         value, op \
>         FROM ${groupreply_table} \
>         WHERE groupname = '%{${group_attribute}}' \
>         ORDER BY id"
>
>
> Como posso resolver? Poriam me dar uma ajuda?
>
> Atte
>
> Juliano
>
> -- 
> gter list    https://eng.registro.br/mailman/listinfo/gter

-- 
Carlos Eduardo Tavares Terra
https://keybase.io/cetterra

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <https://eng.registro.br/pipermail/gter/attachments/20200314/318bc8f9/attachment.sig>


More information about the gter mailing list