Doffie
Apr 26, 2017Nimbostratus
iRule to query SQL for Auth and attributes
Hi All We are in a situation where we as a company have a lot of customer portals and would like to use the F5 to consolidate the logins. Using the LTM we would like to have a default login page and when the customer enters their credentials we would like the F5 to query a SQL database to verify their credentials as well as doing a lookup that returns the portal information to which they can be redirected to and logged in via SSO. As an example. Customer ABC logs in via LTM.
1) F5 queries SQL database to validate credentials (Username and Password)
Then
2) F5 queries SQL to get portal information. (Reply is http://xyz.com)
3) F5 redirects client to xyz.com Portal
4) F5 posts using user credentials to the portal to map user credentials.
Steps 3 and 4 I believe can be accomplished with an irule however I am not sure if steps 1 and 2 are possible. Documents point to sideband connections but I am not sure if it is even feasible.
Thanks for any assistance.