sql
5 TopicsMenthod to redirect based on DYNAMIC IP list from external source...
We have a situation that happens daily - certain browser and OS combination loops our login page uncontrollably. We have looked into the issue, and even modified our application to address 99% of the time. However we still get a few hundred of these a day, and they can loop 10K times in an hour. During very busy times this can cause undue load on our system. We then have the ultimate fallback, which is to manually add these to a data group list, and throw them over to a static page that tells them to close their browser and reboot. Here's the simple rule we use: when HTTP_REQUEST { if { [class match [IP::client_addr] equals ps_redirect_quarantine] } { HTTP::redirect "http://docs.xyz.com/docs/portal/browser_error.html" } } Once this is done, we remove the IP and carry on. We have written a PL/SQL procedure on the back end to populate a table in our application database in realtime with the "offenders". What I want to do is find a way to get that data into the data group list. It does not have to be instant, once a minute would be sufficient. Even once every 5 would work. I found a lot of people asking similar questions, and no real solutions. One suggested we may be able to "scrape" this from an html doc if we serve up the data that way. (We could do that) but how would I approach that on the irule side? Or if there is a simpler way. Thanks in advance265Views0likes3CommentsForwarding IP Causing IP conflict
I have a some VIPs setup as forwarding IPs. The destination IPs are actual IPs of Microsoft clustered SQL Resources. Everything was working fine yesterday. I was routing SQL through the F5 with these VIP. One of the Clustered nodes rebooted and the service migrated over to the other node. IP conflict errors started flagging and the SQL resources will not start up unless I disable the VIP. Anyone know a way around this or why this is happening? am I using the wrong setting?236Views0likes2CommentsSQL LB
We have two SharePoint SQL Clusters that currently traverse through an ASA firewall to talk with the SharePoint WFEs. The ASA is getting hammered and is dropping packets because SQL is over utilizing it. What we are wanting to do is send that SQL traffic through the F5 instead. Is there a feasible solution for this? Can we LB? Honestly just routing the traffic through there would be enough for us. I am just not sure how you would do that with the two SQL clusters... Guessing make two VIP and then route traffic to each cluster IP? Current Setup: SPCLUSTER1 192.168.1.1 -Node1 192.168.1.2 -Node2 192.168.1.3 SPCLUSTER2 192.168.2.1 -Node1 192.168.2.2 -Node2 192.168.2.3281Views0likes3Comments