Marc

Thanks a lot.

the alter table form

no it is not. A shortend example: CREATE TABLE `tblFile` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Filename` varchar(230) NOT NULL DEFAULT '', `Creation_Date` timestamp NOT NULL DEFAULT current_timestamp(), `CreationDate` int(10) unsigned GENERATED ALWAYS AS (timestampdiff(SECOND,from_unixtime(0),`Creation_Date`)) VIRTUAL, PRIMARY KEY (`ID`) ) Now edit (change) this table. CreationDate is shown as a regular column. It should be shown as a virt column, or removed, so no changes could take...

From header not parsed correctly

no, it does not. At least QS_SrvMaxConnPerIP uses the IP of the loadbalancer. Since all my trouble I switched to my own loadbalancer and now remove the bad traffic in front - but not all users will have that possibility.

So there is currently no way to use the parsed client IP that is available in log as %a ? Since this is a transparent proxy, the http header is not modified (hetzner).

I have generic loadbalancer in front of my webservers. So the RemoteIPProxyProtocol is enabled and the remote ip adresse can be accessed via %a in the log file. I've seen the "QS_ClientIpFromHeader" directive, but I don't know how to configure it, in order to use the client address set by the proxy protocol. Any help would be great.

Remove generated columns from editmask