Forum Discussion
Simon_Knox_1115
Nimbostratus
Dec 12, 2005TCP::payload replace and MSSQL
Hello,
I'm trying to figure out away to change the database value within a SQL connection string as it passes through the Big-Ip on the way to the DB server.
I'm guessing that I ne...
Simon_Knox_1115
Nimbostratus
Dec 13, 2005Hello,
I've done some digging around and come up with this (which might be a bit simplistic and optomistic):
when CLIENT_ACCEPTED {
TCP::collect 300
}
when CLIENT_DATA {
if { [TCP::payload] contains "dbafa" } {
TCP::payload replace 0 0 "master"
pool SQL-WiP
}
}
What I'm really confused with is how to know what he offset and length variables should be for the TCP::payload replace command. I've done some packet inspection and the database name seems to be right at the very end of the data.
Can anyone help?
Simon
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