I currently have a MariaDB server setup behind (Enterprise) spectrum. The application type is set to TCP, and I’ve enabled Proxy Protocol v2. Connections work fine.
However, I run into an issue with translating my own IP to the server, since all my users are IP bound, I would like to send that IP to the server to handle. Without it, I get that what I assume is Cloudflare’s IP cannot access the server, which is reassuring that no one except me can access it, but I would still like to access it since I am, in fact, me.
After searching, I was led to MariaDB’s article on Proxy Protocol: Proxy Protocol Support - MariaDB Knowledge Base
However, I am asked to specify subnets:
To enable use of the proxy protocol, it is necessary to specify subnetworks that are allowed to send proxy headers, using the proxy-protocol-networks server variable.
I assume these are Cloudflares, so I’m not exactly sure how to give it this information.
I could be overlooking something, so any help is appreciated!