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
[3] GitHub - FRiCKLE/ngx_postgres: upstream module that allows nginx to communicate directly with PostgreSQL database.

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

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.