Forum Discussion
jwight1464
Nimbostratus
May 15, 2012TCP Universal Persistence not saving
We are currently working on a MS SQL server persistence iRule that will read the TCP::payload for a certain SQL parameter that we are passing and save the value in the uie table for persistence looku...
Richard__Harlan
May 17, 2012Historic F5 Account
I think part of the problem here is you are setting a persist entry before the LTM has made a LB choice. The LTM is accepting the connection and doing a data collect on the third packet, it is then using the data from the third packet to make the persist setting but at this time there is no selected pool member for the persist to happen on. The next client data though should have a connection built and when the persist command is run you should get a result back.
if you look through the MySql Proxy iRule
https://devcentral.f5.com/wiki/iRules.MySQL-Proxy.ashx
You can see the persist statement is not called till the session has been auth.
A way around what you are doing would be to peform the persist in LB_SELECTED and set persistence there.
Again I could be wrong but with the info I see, I think this is a good starting point to look at the problem. Thanks
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