[ITNOG] sqlippool freeradius

[Sergio Chiesa]

ops :)) era mezz'ora che scrivevo :))

S

On 9/23/22 15:58, Matteo Sgalaberni wrote:
> ATTENZIONE: Questa email ha origine esterna all’organizzazione. Non selezionare link o scaricare allegati, a meno di riconoscere il mittente e di sapere che il contenuto è sicuro.
>
>
> Ho risolto e mi autorispondo...ho appena postato sul thread che avevo aperto sulla ML di freeradius, sotto il post. Caso chiuso...
>
> Matteo
>
> -----
> Hi Alan,
>
> I found that my thesis are very "obsolete" and related to an older "queries.conf".
>
> On the branch release_3_0_26 I found a patch authored by Nick Porter
>
>   https://urlsand.esvalabs.com/?u=https%3A%2F%2Fgithub.com%2FFreeRADIUS%2Ffreeradius-server%2Fcommit%2F1e9ab2a99674bb598af87c32e9202bc13c84e393&e=431a35a5&h=77964caf&f=n&p=n
>
> related to this pull request:
>
>   https://urlsand.esvalabs.com/?u=https%3A%2F%2Fgithub.com%2FFreeRADIUS%2Ffreeradius-server%2Fpull%2F3651&e=431a35a5&h=63f33dff&f=n&p=n
>
> from the pull request description:
>
>> Updates to schema - set default values for all columns, including expiry_time. This allows pools to be populated with the new helper script which only updates pool_name and framedipaddress. Having expiry_time as a NOT NULL >removes the need for selection criteria such as (expiry_time < NOW OR expiry_time IS NULL), enabling better use of indexes.
>> Updates to queries -
>> Take advantage of the new allocate_existing query to split re-issuing of existing address from finding a free one
>> Amend all "freeing" queries so that they just expire the entry rather than clearing all client data. Essential to allow "sticky" IP behaviour
>> Remove allocate_clear queries that achieve nothing useful (and also break "sticky" IP behaviour)
> So the issue was resolved by Nick in 2020 ;) Thanks Nick!
>
> Case closed
>
> Thanks to all,
>
> Matteo
>
>
>
>
> --
> Mailing list info:  https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.itnog.it%2Flistinfo%2Fitnog&e=431a35a5&h=71c63b1a&f=n&p=n