PostgreSQL Proxy

Hi everybody,

 

I'm writing a PostgreSql Proxy iRule but i was stuck at the authentication phase. The PostgreSQL DB is configured for MD5 authentication mechanism, for now, i would like the iRule authenticate the user against a Datagroup in which i would have the username and password data for all users (preferentially, the password data as an md5 hash value). Here, i'm attaching the PostgreSQL protocol conversation images, starting with the startup message and finishing with the Auth Success, of course, after the tcp connection establishment; the client is the IP Address 10.2.x.92, and the PostgreSQL DB server is 10.3.x.150, the username is admin, and the password is admin too. is there any ideas on how to do that?

 

Regards,