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

rpaprocki · 2016-08-26T06:58:37+00:00

Hello! On Sun, Aug 28, 2016 at 6:17 PM, Soojin Nam wrote: > Thank you for openresty 1.11.2.1 release. > > The version of lua-resty-upload in this o...

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

rpaprocki

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 descriptive. Is there an entry in the error log? Have you confirmed that your MySQL server is accessible via the host/port/name/password you provide?

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

For instance this is how it looks like:

Lua File:

local _M = {}

function _M.check_sql()

local mysql = require "resty.mysql"
local db, err = mysql:new()
...

end

function _M.init_timers()

if ( ngx.worker.id() ~= nil ) then
local ok, err = ngx.timer.at(10, _M.check_sql)
end

end

return _M

Nginx Config:

init_worker_by_lua '
whmcs = require "lua/ext_sql"
whmcs.init_timers()
';

Em quinta-feira, 25 de agosto de 2016 18:57:16 UTC-3, Fr3DBr escreveu:
Hi, guys.

I have a .lua file, which I an including towards my nginx.conf file. Although, when I try to use mysql from it, it hangs exactly here:

local mysql = require "resty.mysql"

I'm using openresty (latest version) and mysql is surely included there, but I'm not sure why using the resty.mysql extension inside a regular .lua file isn't working (even tho it is included through nginx config file).

Any light ? :D

.