# When will mod\_auth\_mysql in nginx will be available?

**URL:** <https://www.ruby-forum.com/t/when-will-mod-auth-mysql-in-nginx-will-be-available/184238>\
**Category:** NGINX\
**Created:** [February 27, 2010, 1:26am UTC](https://www.ruby-forum.com/t/when-will-mod-auth-mysql-in-nginx-will-be-available/184238 "2010-02-27T01:26:09Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![lhmwzy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/90db22/32.png) [@lhmwzy](https://www.ruby-forum.com/u/lhmwzy)\
**Post date:** [February 27, 2010, 1:26am UTC](https://www.ruby-forum.com/t/when-will-mod-auth-mysql-in-nginx-will-be-available/184238/1 "2010-02-27T01:26:09Z")

</div>

I see the post:

Posted by Igor S. (Guest)  
on 16.03.2009 13:40  
(Received via mailing list)

On Mon, Mar 16, 2009 at 01:19:20PM +0100, Manlio P. wrote:

> Written from scratch, implementing the MySQL wire protocol?  
> Yes.

> By the way, after having implemented a pure PostgreSQL client in Python,  
> I tried to do the same with MySQL; but protocol design is very bad,  
> compared to PostgreSQL, so I gave up; it does not make sense to waste  
> time with MySQL, IMHO,

It’s already wasted :). The reamining part is parsing mysql response.

---

<div class="post-metadata">

**Author:** ![lhmwzy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/90db22/32.png) [@lhmwzy](https://www.ruby-forum.com/u/lhmwzy)\
**Post date:** [February 27, 2010, 1:54am UTC](https://www.ruby-forum.com/t/when-will-mod-auth-mysql-in-nginx-will-be-available/184238/2 "2010-02-27T01:54:50Z")

</div>

-------- Original-Nachricht --------

> Datum: Sat, 27 Feb 2010 08:25:25 +0800  
> Von: lhmwzy [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> An: [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> Betreff: When will mod\_auth\_mysql in nginx will be available?

> > By the way, after having implemented a pure PostgreSQL client in Python,  
> > I tried to do the same with MySQL; but protocol design is very bad,  
> > compared to PostgreSQL, so I gave up; it does not make sense to waste  
> > time with MySQL, IMHO,
> 
> It’s already wasted :). The reamining part is parsing mysql response.

Why not using ngx\_http\_auth\_pam\_module  
([http://web.iti.upv.es/~sto/nginx/](http://web.iti.upv.es/~sto/nginx/))? I am using it since long time to  
authenticate against MySQL and against PostgreSQL without any issues so  
far.

> * * *
> 
> nginx mailing list  
> [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> [mailman.nginx.org archive](http://nginx.org/mailman/listinfo/nginx)

–  
Sicherer, schneller und einfacher. Die aktuellen Internet-Browser -  
jetzt kostenlos herunterladen! [http://portal.gmx.net/de/go/atbrowser](http://portal.gmx.net/de/go/atbrowser)

---

<div class="post-metadata">

**Author:** ![lhmwzy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/90db22/32.png) [@lhmwzy](https://www.ruby-forum.com/u/lhmwzy)\
**Post date:** [February 27, 2010, 2:01am UTC](https://www.ruby-forum.com/t/when-will-mod-auth-mysql-in-nginx-will-be-available/184238/3 "2010-02-27T02:01:16Z")

</div>

On Fri, Feb 26, 2010 at 4:54 PM, Steve [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Why not using ngx\_http\_auth\_pam\_module ([http://web.iti.upv.es/~sto/nginx/](http://web.iti.upv.es/~sto/nginx/))? I am using it since long time to authenticate against MySQL and against PostgreSQL without any issues so far.

Best question: when will nginx support pluggable modules and not  
require them at compile time? 🙂

---

<div class="post-metadata">

**Author:** ![lhmwzy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/90db22/32.png) [@lhmwzy](https://www.ruby-forum.com/u/lhmwzy)\
**Post date:** [February 27, 2010, 2:21am UTC](https://www.ruby-forum.com/t/when-will-mod-auth-mysql-in-nginx-will-be-available/184238/4 "2010-02-27T02:21:45Z")

</div>

-------- Original-Nachricht --------

> Datum: Fri, 26 Feb 2010 17:00:37 -0800  
> Von: Michael S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> An: [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> Betreff: Re: When will mod\_auth\_mysql in nginx will be available?

> On Fri, Feb 26, 2010 at 4:54 PM, Steve [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> > Why not using ngx\_http\_auth\_pam\_module  
> > ([http://web.iti.upv.es/~sto/nginx/](http://web.iti.upv.es/~sto/nginx/))? I am using it since long time to authenticate against MySQL and against  
> > PostgreSQL without any issues so far.
> 
> Best question: when will nginx support pluggable modules and not  
> require them at compile time? 🙂

Best response: when we (the community) help Igor and the other nginx  
developers changing the source code to support that.

IMHO Igor would not mind if YOU or ANY one else here requesting  
pluggable modules would send him a patch enabling that in nginx.

> * * *
> 
> nginx mailing list  
> [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> [mailman.nginx.org archive](http://nginx.org/mailman/listinfo/nginx)

–  
Sicherer, schneller und einfacher. Die aktuellen Internet-Browser -  
jetzt kostenlos herunterladen! [http://portal.gmx.net/de/go/chbrowser](http://portal.gmx.net/de/go/chbrowser)

---

<div class="post-metadata">

**Author:** ![lhmwzy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/90db22/32.png) [@lhmwzy](https://www.ruby-forum.com/u/lhmwzy)\
**Post date:** [February 27, 2010, 3:12am UTC](https://www.ruby-forum.com/t/when-will-mod-auth-mysql-in-nginx-will-be-available/184238/5 "2010-02-27T03:12:05Z")

</div>

Can it be run with lastest 0.8.33?

2010/2/27 Steve [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid):

---

<div class="post-metadata">

**Author:** ![lhmwzy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/90db22/32.png) [@lhmwzy](https://www.ruby-forum.com/u/lhmwzy)\
**Post date:** [February 27, 2010, 4:43am UTC](https://www.ruby-forum.com/t/when-will-mod-auth-mysql-in-nginx-will-be-available/184238/6 "2010-02-27T04:43:58Z")

</div>

On Sat, Feb 27, 2010 at 8:25 AM, lhmwzy [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> > By the way, after having implemented a pure PostgreSQL client in Python,  
> > I tried to do the same with MySQL; but protocol design is very bad,  
> > compared to PostgreSQL, so I gave up; it does not make sense to waste  
> > time with MySQL, IMHO,
> 
> It’s already wasted :). The reamining part is parsing mysql response.

I’m not sure if our ngx\_drizzle[1] module will help you to talk to  
mysql (clusters) from within nginx in this context. We’re already  
using ngx\_drizzle + mysql to do simple password login for our  
application. 100% nginx config scripting.

Cheers,  
-agentzh

[1] [GitHub - openresty/drizzle-nginx-module: an nginx upstream module that talks to mysql and drizzle by libdrizzle · GitHub](http://github.com/chaoslawful/drizzle-nginx-module)

---

<div class="post-metadata">

**Author:** ![lhmwzy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/90db22/32.png) [@lhmwzy](https://www.ruby-forum.com/u/lhmwzy)\
**Post date:** [February 27, 2010, 10:51am UTC](https://www.ruby-forum.com/t/when-will-mod-auth-mysql-in-nginx-will-be-available/184238/7 "2010-02-27T10:51:28Z")

</div>

Hello!

On Sat, Feb 27, 2010 at 01:54:36AM +0100, Steve wrote:

[…]

> Why not using ngx\_http\_auth\_pam\_module  
> ([http://web.iti.upv.es/~sto/nginx/](http://web.iti.upv.es/~sto/nginx/))? I am using it since long  
> time to authenticate against MySQL and against PostgreSQL  
> without any issues so far.

PAM is blocking.

Maxim D.

---

<div class="post-metadata">

**Author:** ![lhmwzy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/90db22/32.png) [@lhmwzy](https://www.ruby-forum.com/u/lhmwzy)\
**Post date:** [February 27, 2010, 4:46am UTC](https://www.ruby-forum.com/t/when-will-mod-auth-mysql-in-nginx-will-be-available/184238/8 "2010-02-27T04:46:19Z")

</div>

On Sat, Feb 27, 2010 at 9:21 AM, Steve [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> IMHO Igor would not mind if YOU or ANY one else here requesting pluggable modules would send him a patch enabling that in nginx.

Yeah, it’s been an important item on our TODO list for long. Static  
linking does not work very well for RPM/etc packaging in a corporation  
environment.

Cheers,  
-agentzh
