# Ngx\_drizzle v0.0.8 and ngx\_rds\_json v0.05

**URL:** <https://www.ruby-forum.com/t/ngx-drizzle-v0-0-8-and-ngx-rds-json-v0-05/187057>\
**Category:** NGINX\
**Created:** [April 16, 2010, 10:32am UTC](https://www.ruby-forum.com/t/ngx-drizzle-v0-0-8-and-ngx-rds-json-v0-05/187057 "2010-04-16T10:32:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![agentzh](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/4da419/32.png) [@agentzh](https://www.ruby-forum.com/u/agentzh)\
**Post date:** [April 16, 2010, 10:32am UTC](https://www.ruby-forum.com/t/ngx-drizzle-v0-0-8-and-ngx-rds-json-v0-05/187057/1 "2010-04-16T10:32:54Z")

</div>

Hi, folks!

On behalf of the ngx\_dbd team, I’m happy to announce the new releases  
of the ngx\_drizzle and ngx\_rds\_json modules.

Here’s a brief list of (major) changes since their last releases:

- Fixed a nasty bug in ngx\_drizzle’s connection pool. Now the  
drizzle\_keepalive directive’s overflow=reject option works for real  
now. Thanks Piotr S. for reporting this issue. (agentzh)

- Updated the Resty DBD Stream (RDS) format to version 0.0.3 which  
specifies that SQL NULL field values are represented by setting field  
length == (uint32\_t) -1 and empty trailing data section. Thanks Piotr  
Sikora for reporting this issue. (agentzh)

- ngx\_drizzle and ngx\_json now both supports RDS v0.0.3 and can  
differentiate SQL NULL values and SQL empty strings (""). (agentzh)

- Now we postpone the header sending action after we parse the RDS  
header. So errors in RDS headers can result in proper 500 response  
headers. Thanks Piotr S. for suggesting this. (agentzh)

- Fixed a small bug in ngx\_rds\_json that may cause random hang. (This  
bug also appeared in my fork of ngx\_eval, fixed there as well.)  
(agentzh)

- ngx\_drizzle now returns 500 Internal Server Error instead of 502  
Bad Gateway for bad SQL queries, bad tables, DB connection failures.  
(Piotr S.)

- Fixed a bug that could cause double free in ngx\_drizzle. (Piotr  
Sikora)

- ngx\_drizzle now works with libdrizzle 0.7 and 0.8.

Piotr S. does have more fixes and/or improvements in his  
ngx\_postgres module that is expected to be back-ported to ngx\_drizzle  
some time in the near future 🙂

Have fun!  
-agentzh

P.S. The original creator of the ngx\_drizzle project, chaoslawful, is  
currently working on ngx\_lua and he’s got something runnable already.  
We’ll make the first public release of ngx\_lua in the near future.  
Stay tuned!

---

<div class="post-metadata">

**Author:** ![agentzh](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/4da419/32.png) [@agentzh](https://www.ruby-forum.com/u/agentzh)\
**Post date:** [April 16, 2010, 10:37am UTC](https://www.ruby-forum.com/t/ngx-drizzle-v0-0-8-and-ngx-rds-json-v0-05/187057/2 "2010-04-16T10:37:35Z")

</div>

On Fri, Apr 16, 2010 at 4:32 PM, agentzh [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Hi, folks!
> 
> On behalf of the ngx\_dbd team, I’m happy to announce the new releases  
> of the ngx\_drizzle and ngx\_rds\_json modules.

Oops, forgot to give the download links for these modules:

ngx\_drizzle v0.0.8  
[http://github.com/chaoslawful/drizzle-nginx-module/tarball/v0.0.8](http://github.com/chaoslawful/drizzle-nginx-module/tarball/v0.0.8)

ngx\_rds\_json v0.05  
[http://github.com/agentzh/rds-json-nginx-module/tarball/v0.05](http://github.com/agentzh/rds-json-nginx-module/tarball/v0.05)

ngx\_drizzle is a non-blocking upstream module for mysql, drizzle, and  
sqlite. Its project page is on GitHub:

```
http://github.com/chaoslawful/drizzle-nginx-module

```

ngx\_rds\_json is an output filter module that can format the Resty DBD  
Stream (RDS) outputs of ngx\_drizzle and other database driver modules  
to JSON. Its project page is also on GitHub:

```
http://github.com/agentzh/rds-json-nginx-module

```

Cheers,  
-agentzh

---

<div class="post-metadata">

**Author:** ![agentzh](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/4da419/32.png) [@agentzh](https://www.ruby-forum.com/u/agentzh)\
**Post date:** [April 16, 2010, 10:50am UTC](https://www.ruby-forum.com/t/ngx-drizzle-v0-0-8-and-ngx-rds-json-v0-05/187057/3 "2010-04-16T10:50:28Z")

</div>

Is there a module for nginx that can support auth based on mysql  
authentication?  
The user and password are stored in mysql.

like  
location /secret  
{  
auth\_basic “Restricted”;  
auth\_pass mysql;  
}

2010/4/16 agentzh [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid):

---

<div class="post-metadata">

**Author:** ![agentzh](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/4da419/32.png) [@agentzh](https://www.ruby-forum.com/u/agentzh)\
**Post date:** [April 16, 2010, 11:34am UTC](https://www.ruby-forum.com/t/ngx-drizzle-v0-0-8-and-ngx-rds-json-v0-05/187057/4 "2010-04-16T11:34:22Z")

</div>

just have a look at

[http://github.com/chaoslawful/drizzle-nginx-module/blob/master/README#L278](http://github.com/chaoslawful/drizzle-nginx-module/blob/master/README#L278)  
[http://github.com/chaoslawful/drizzle-nginx-module/blob/master/README#L278](http://github.com/chaoslawful/drizzle-nginx-module/blob/master/README#L278)

On Fri, Apr 16, 2010 at 4:49 PM, lhmwzy [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> > ngx\_drizzle v0.0.8  
> > ngx\_rds\_json is an output filter module that can format the Resty DBD  
> > [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> > [mailman.nginx.org archive](http://nginx.org/mailman/listinfo/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)

–  
Regards,

æž—é’(Kindy Lin)
