Authentication through MySQL

beatstar101 · 2016-06-29T13:22:12+00:00

Hello! On Tue, Jun 28, 2016 at 5:46 PM, Robert Paprocki wrote: > We all know about the perils/joy of sharing data via the module-level > variables &gt...

Authentication through MySQL

beatstar101

Hello,

I am trying to set a basic authentication in my nginx server.

My aim is to set authentication in such a way that user provide username and password and i pass there in my sql query.

Then if the response is valid the user could sign in. otherwise it block the user.

Can anyone please tell mw how to get over it.

agentzh

Hello!

On Tue, Jun 28, 2016 at 10:22 PM, jugraj singh wrote:
> I am trying to set a basic authentication in my nginx server.
> My aim is to set authentication in such a way that user provide username and
> password and i pass there in my sql query.
> Then if the response is valid the user could sign in. otherwise it block the
> user.
> Can anyone please tell mw how to get over it.
>

I think you just need to combine the ngx_lua module, lua-resty-mysql
library and the ngx_coolkit module. All of them are OpenResty
components. Consult their official documentation for more details.

Regards,
-agentzh