redirect by ip to pool

It sounds like you're adding this to your BIG-IP via the GUI, correct?

 

 

If so, try this instead:

 

 

   when CLIENT_ACCEPTED {
      if { [IP::remote_addr] == $ext_ip and [TCP::local_port] == 3306 } {
         log local0.info "accepted connection from [IP::remote_addr]"
         pool mysql
      } else {
         log local0.info "rejected connection from [IP::remote_addr]"
         reject
      }
   }

 

 

Changing the $ext_ip bit to your IP, of course.

 

 

The

 rule name { } 

pieces are only needed if you're adding this directly to the configuration file. The GUI automatically adds those around the code you paste into the text box.

 

 

Colin