My scenario : I got a code on the internet that does the OpenVPN log parser and plays it in the database to play a table on an html page. The output looks something like this: link This parser parses a log file that has all clients logged in. It will run every 5 minutes.
On the page, a client key may be blocked.
What I thought: parser parses the log, plays a table in the database with an active status column (because that log only contains active clients). Create another table that will contain the same data, but if this key is locked, put the status to locked. And comparing the two tables, if it is locked in one and unlocked in another, the end result will be blocked. Then another script will run and lock the key permanently (block on the firewall).
But I do not know how to do this. I do not know if it is better to compare in txt, better do the comparison in the database ... And if it is one of two options, I do not know how to make that comparison.