Forum Discussion
pjcampbell_7243
Cirrus
Oct 21, 2009Help logging mysql connections
We've got this weird connection attempt going to our mysqld which we now have going through the BIG-IP and I am having a hard time finding where the connection is coming from.
I have a simpl...
hoolio
Cirrostratus
Oct 22, 2009Couldn't you also check the mysql server status tables or logs to see which client IP addresses are running and which queries they're executing? If you're using SNAT on LTM and having a hard time correlating the query back to the original client IP, you could temporarily log the original and SNAT IP and ports in an iRule.
when SERVER_CONNECTED {
log local0. "[IP::client_addr]:[TCP::client_port] translated to [IP::local_addr]:[TCP::local_port]"
}
Aaron
Recent Discussions
Related Content
DevCentral Quicklinks
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com
Discover DevCentral Connects