0
My setting: I took a code from the Internet that parses the Openvpn log and plays it in the database to play it in a table on an html page. The exit is more or less like this: https://www.devco.net/code/openvpnStatusParser/openvpnstatus-sample.html This parser scans a log file that has all clients connected.. It will run every 5 minutes.
Through the page, a customer key.
What I thought: parser analyzes the log, plays in a table in the bank with an active status column (because this log contains only active clients). Create another table that will contain the same data, however if this key is locked, put the status to locked. And compare the two tables, if it is locked in one and unlocked in another, the final result will be blocked. Then another script will run and lock the key definitely (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 make the comparison in the database... And if it’s one of two options, I don’t know how to make that comparison.