Basic Auth - MySQL/PgSQL Backend

Server NGINX
1

I was wondering what options are available for using BasicAuth using
Either MySQL or PostGres backend to store users.

2

Hi,

I was wondering what options are available for using BasicAuth using
Either MySQL or PostGres backend to store users.

You can do this with ngx_http_auth_request [1] with either ngx_drizzle
[2]
(for Drizzle/MariaDB/MySQL/Percona) or ngx_postgres [3] (for
PostgreSQL).

Working example for ngx_postgres is available in its README (Sample
configuration #4).

[1] ngx_http_auth_request_module: log
[2] GitHub - openresty/drizzle-nginx-module: an nginx upstream module that talks to mysql and drizzle by libdrizzle · GitHub
[3] GitHub - FRiCKLE/ngx_postgres: upstream module that allows nginx to communicate directly with PostgreSQL database. · GitHub

Best regards,
Piotr S. < [email protected] >

3

Thanks.

I didnt see the example in the README?
Sample #4?

Thanks Again.

David.

4

Hi,

I didnt see the example in the README?
Sample #4?

Then look again, it’s there.

Best regards,
Piotr S. < [email protected] >

5

I am not sure which readme you are referring to;

I see your name is listed here;

Is this the file you are talking about?

Thanks.

6

Hi,

I am not sure which readme you are referring to;

“Working example for ngx_postgres is available in its README (Sample
configuration #4).” should be self-explanatory :wink:

I see your name is listed here;

GitHub - openresty/drizzle-nginx-module: an nginx upstream module that talks to mysql and drizzle by libdrizzle · GitHub

I’m listed in the other one as well.

Is this the file you are talking about?

Nope, I’m talking about ngx_postgres’s one.

Best regards,
Piotr S. < [email protected] >

7

Thanks.

I really appreciate it;

That (surprisingly!) was the only one I didnt look at.

Thanks again.