Re: [openresty-en] Re: Lua/Nginx - MySQL

rpaprocki · 2016-08-26T07:06:01+00:00

Can you post a full, minimal, reproducible example of the issue? And can you clarify exactly why the issue is? "It hangs" is not terrible descripti...

Re: [openresty-en] Re: Lua/Nginx - MySQL

rpaprocki

Hi,

On Thu, Aug 25, 2016 at 4:02 PM, Fr3DBr <fr...@gmail.com> wrote:

Hi,

When I said it hangs, I mean it hangs because I've added logging output to a simple txt file before each line of code, and it hangs as soon this line is going to be parsed:
local mysql = require "resty.mysql"

It doesn't moves further, since it hangs there. Get it now ?

Perhaps try checking your tcp connectivity with tcpdump to ensure you can connect to your MySQL server from the box on which you're running your ngx + lua? Also, try enable debug logging in Nginx (make sure Nginx is compiled with --with-debug); lua tcpsock calls are debugged pretty thoroughly at the debug level, so can watch how Nginx is string to communicate to the remote TCP server.

So I wanted to know what could be missing to it work, or if I'm allowed to do this or not at all (in an external lua file, loaded by nginx.conf via require).

Yes, you can do it via external module. Sounds like you need to troubleshoot your TCP connectivity (see above).