maria-discuss team mailing list archive

[Benoit Plessis <benoit@xxxxxxxxxxxx>]

Hi Eliezer,

Why not simply having a timestamp on your client list table with the 
automatic timestamp update of mysql/mariadb
 (https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html)

And having your external client filter on this automatically maintained 
update date ?

I don't know the use-case but a stronger auth than MAC/IP is also often 
a good solution ^

Regards,
Benoit

On 30/09/2022 09:02, ngtech1ltd@xxxxxxxxx wrote:
> Hey Everybody,
>
> I have the next scenario which I am not sure about the right way for a 
> solution.
>
> I have a radius server that authenticate clients from multiple WIFI 
> Access Points.
>
> I have couple systems and they need to know the current client login 
> identifier (MAC or IP Address).
>
> It is stored in the DB and the DB is being updated on every login.
>
> I can try to give a static IP for every user and it will resolve this 
> issue but there is an overhead for this.
>
> Sowhat I was thinking instead is to either run a query that will fetch 
> the latest changes or use a trigger to update another table
> which in turn will be read by an external software every 1-5 seconds.
>
> I believe that the right solution is to use a trigger that will update 
> another table with the details and on the other table I will have a
>
> Processed column that will be updated when the software finished 
> processing the row.
>
> Then in turn every 24 hours I will run a DB cleanup cron.
>
> I will try later on to share the schema.
>
> Any advice is more than welcome.
>
> Thanks,
>
> Eliezer
>
> ----
>
> Eliezer Croitoru
>
> NgTech, Tech Support
>
> Mobile: +972-5-28704261
>
> Email: ngtech1ltd@xxxxxxxxx <mailto:ngtech1ltd@xxxxxxxxx>
>
> Web: https://ngtech.co.il/ <https://ngtech.co.il/>
>
> My-Tube: https://tube.ngtech.co.il/ <https://tube.ngtech.co.il/>
>
>
> _______________________________________________
> Mailing list:https://launchpad.net/~maria-discuss
> Post to     :maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe :https://launchpad.net/~maria-discuss
> More help   :https://help.launchpad.net/ListHelp