通过lua文件访问mysq报错

rodin.chn · 2014-06-10T15:49:37+00:00

Hi folks! I am happy to announce the new formal release, 1.7.0.1, of the OpenResty bundle: http://openresty.org/#Download Special thanks go to all our...

通过lua文件访问mysq报错

rodin.chn

请教一个问题噢~~(通过邮件发送了，不过我在论坛没有收到，所有又在论坛发一次)

需求说明：

根据输入参数，通过lua文件查询mysql，并且返回对应的输出数据，然后根据数据的不同去做后续工作.

配置文件摘录：

server {

listen 8080;

server_name localhost;

root html;

index index.html index.htm;

location / {

set_by_lua_file $res conf/limit_mysql.lua $arg_uid;

}

error_page 500 502 503 504 /50x.html;

location = /50x.html {

root html;

}

错误提示：

*1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:

[C]: in function 'tcp'

/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'

/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*

stack traceback: [C]: in function 'tcp'

/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'

2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:

[C]: in function 'tcp' /usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'

mysql.lua提示错误的那几行代码是：

/usr/local/openresty/lualib/resty/mysql.lua

457 function _M.new(self)

458 local sock, err = tcp()

459 if not sock then

460 return nil, err

461 end

462 return setmetatable({ sock = sock }, mt)

463 end

smallfish.xy

nginx-lua文档里已经明确set_by_lua禁用cosocket函数（tcp）：https://github.com/openresty/lua-nginx-module/#set_by_lua

换其他*_by_lua实现吧

smallfish http://chenxiaoyu.org

On Tue, Jun 10, 2014 at 3:49 PM, R <rodi...@gmail.com> wrote:

请教一个问题噢~~(通过邮件发送了，不过我在论坛没有收到，所有又在论坛发一次)

需求说明：
根据输入参数，通过lua文件查询mysql，并且返回对应的输出数据，然后根据数据的不同去做后续工作.

配置文件摘录：
server {
listen 8080;
server_name localhost;
root html;
index index.html index.htm;

location / {
set_by_lua_file $res conf/limit_mysql.lua $arg_uid;
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root html;
}
}

错误提示：
*1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:
[C]: in function 'tcp'
/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*

stack traceback: [C]: in function 'tcp'
/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:
[C]: in function 'tcp' /usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

mysql.lua提示错误的那几行代码是：
/usr/local/openresty/lualib/resty/mysql.lua

457 function _M.new(self)
458 local sock, err = tcp()
459 if not sock then

460 return nil, err
461 end
462 return setmetatable({ sock = sock }, mt)
463 end

--

rodin.chn

这个我看过，但是需要把lua脚本写在nginx.conf里面，这样的话感觉比较别扭。

在 2014年6月10日星期二UTC+8下午4时05分03秒，smallfish写道：

nginx-lua文档里已经明确set_by_lua禁用cosocket函数（tcp）：https://github.com/openresty/lua-nginx-module/#set_by_lua

换其他*_by_lua实现吧

--
smallfish http://chenxiaoyu.org

On Tue, Jun 10, 2014 at 3:49 PM, R <rodi...@gmail.com> wrote:

请教一个问题噢~~(通过邮件发送了，不过我在论坛没有收到，所有又在论坛发一次)

需求说明：
根据输入参数，通过lua文件查询mysql，并且返回对应的输出数据，然后根据数据的不同去做后续工作.

配置文件摘录：
server {
listen 8080;
server_name localhost;
root html;
index index.html index.htm;

location / {
set_by_lua_file $res conf/limit_mysql.lua $arg_uid;
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root html;
}
}

错误提示：
*1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:
[C]: in function 'tcp'
/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*

stack traceback: [C]: in function 'tcp'
/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:
[C]: in function 'tcp' /usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

mysql.lua提示错误的那几行代码是：
/usr/local/openresty/lualib/resty/mysql.lua

457 function _M.new(self)
458 local sock, err = tcp()
459 if not sock then

460 return nil, err
461 end
462 return setmetatable({ sock = sock }, mt)
463 end

--

smallfish.xy

为什么要把代码写在nginx.conf里？我的意思是说换access_by_lua或者content实现。

smallfish http://chenxiaoyu.org

2014-06-10 16:40 GMT+08:00 R <rodi...@gmail.com>:

这个我看过，但是需要把lua脚本写在nginx.conf里面，这样的话感觉比较别扭。

在 2014年6月10日星期二UTC+8下午4时05分03秒，smallfish写道：

nginx-lua文档里已经明确set_by_lua禁用cosocket函数（tcp）：https://github.com/openresty/lua-nginx-module/#set_by_lua

换其他*_by_lua实现吧

--
smallfish http://chenxiaoyu.org

On Tue, Jun 10, 2014 at 3:49 PM, R <rodi...@gmail.com> wrote:

请教一个问题噢~~(通过邮件发送了，不过我在论坛没有收到，所有又在论坛发一次)

需求说明：
根据输入参数，通过lua文件查询mysql，并且返回对应的输出数据，然后根据数据的不同去做后续工作.

配置文件摘录：
server {
listen 8080;
server_name localhost;
root html;
index index.html index.htm;

location / {
set_by_lua_file $res conf/limit_mysql.lua $arg_uid;
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root html;
}
}

错误提示：
*1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:
[C]: in function 'tcp'

/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*

stack traceback: [C]: in function 'tcp'
/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:

[C]: in function 'tcp' /usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

mysql.lua提示错误的那几行代码是：
/usr/local/openresty/lualib/resty/mysql.lua

457 function _M.new(self)
458 local sock, err = tcp()
459 if not sock then

460 return nil, err
461 end
462 return setmetatable({ sock = sock }, mt)
463 end

--

--

rodin.chn

对啊，这种形式吧？

location /lua {

access_by_lua '

ngx.say(ngx.get_phase())

ngx.exit(200)

}

access_by_lua 里面不就是代码么？这个是在nginx.conf 里面吧？

在 2014年6月10日星期二UTC+8下午4时50分55秒，smallfish写道：

为什么要把代码写在nginx.conf里？我的意思是说换access_by_lua或者content实现。

--
smallfish http://chenxiaoyu.org

2014-06-10 16:40 GMT+08:00 R <rodi...@gmail.com>:

这个我看过，但是需要把lua脚本写在nginx.conf里面，这样的话感觉比较别扭。

在 2014年6月10日星期二UTC+8下午4时05分03秒，smallfish写道：

nginx-lua文档里已经明确set_by_lua禁用cosocket函数（tcp）：https://github.com/openresty/lua-nginx-module/#set_by_lua

换其他*_by_lua实现吧

--
smallfish http://chenxiaoyu.org

On Tue, Jun 10, 2014 at 3:49 PM, R <rodi...@gmail.com> wrote:

请教一个问题噢~~(通过邮件发送了，不过我在论坛没有收到，所有又在论坛发一次)

需求说明：
根据输入参数，通过lua文件查询mysql，并且返回对应的输出数据，然后根据数据的不同去做后续工作.

配置文件摘录：
server {
listen 8080;
server_name localhost;
root html;
index index.html index.htm;

location / {
set_by_lua_file $res conf/limit_mysql.lua $arg_uid;
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root html;
}
}

错误提示：
*1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:
[C]: in function 'tcp'

/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*

stack traceback: [C]: in function 'tcp'
/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:

[C]: in function 'tcp' /usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

mysql.lua提示错误的那几行代码是：
/usr/local/openresty/lualib/resty/mysql.lua

457 function _M.new(self)
458 local sock, err = tcp()
459 if not sock then

460 return nil, err
461 end
462 return setmetatable({ sock = sock }, mt)
463 end

--

--

lancelijade

access_by_lua_file

Lance

2014-06-10 16:55 GMT+08:00 R <rodi...@gmail.com>:

对啊，这种形式吧？
location /lua {
access_by_lua '
ngx.say(ngx.get_phase())

ngx.exit(200)
';
}
access_by_lua 里面不就是代码么？这个是在nginx.conf 里面吧？

在 2014年6月10日星期二UTC+8下午4时50分55秒，smallfish写道：
为什么要把代码写在nginx.conf里？我的意思是说换access_by_lua或者content实现。

--
smallfish http://chenxiaoyu.org

2014-06-10 16:40 GMT+08:00 R <rodi...@gmail.com>:

这个我看过，但是需要把lua脚本写在nginx.conf里面，这样的话感觉比较别扭。

在 2014年6月10日星期二UTC+8下午4时05分03秒，smallfish写道：

nginx-lua文档里已经明确set_by_lua禁用cosocket函数（tcp）：https://github.com/openresty/lua-nginx-module/#set_by_lua

换其他*_by_lua实现吧

--
smallfish http://chenxiaoyu.org

On Tue, Jun 10, 2014 at 3:49 PM, R <rodi...@gmail.com> wrote:

请教一个问题噢~~(通过邮件发送了，不过我在论坛没有收到，所有又在论坛发一次)

需求说明：
根据输入参数，通过lua文件查询mysql，并且返回对应的输出数据，然后根据数据的不同去做后续工作.

配置文件摘录：
server {
listen 8080;
server_name localhost;
root html;
index index.html index.htm;

location / {
set_by_lua_file $res conf/limit_mysql.lua $arg_uid;
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root html;
}
}

错误提示：
*1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:
[C]: in function 'tcp'

/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*

stack traceback: [C]: in function 'tcp'
/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:

[C]: in function 'tcp' /usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

mysql.lua提示错误的那几行代码是：
/usr/local/openresty/lualib/resty/mysql.lua

457 function _M.new(self)
458 local sock, err = tcp()
459 if not sock then

460 return nil, err
461 end
462 return setmetatable({ sock = sock }, mt)
463 end

--

--

--

rodin.chn

access_by_lua_file file.lua; 这个没法传入输入参数，也没法获取输出参数吧？

我想在file.lua里面获取到mysql的数据，然后根据这个信息去做下一步的操作。比如我传入用户的uid，然后我在mysql里面查询，如果有这个用户我就允许他访问后端的服务，如果没有这个用户我就返回HTTP 403;

在 2014年6月10日星期二UTC+8下午5时41分52秒，Lance Li写道：

access_by_lua_file

Lance

2014-06-10 16:55 GMT+08:00 R <rodi...@gmail.com>:

对啊，这种形式吧？
location /lua {
access_by_lua '
ngx.say(ngx.get_phase())

ngx.exit(200)
';
}
access_by_lua 里面不就是代码么？这个是在nginx.conf 里面吧？

在 2014年6月10日星期二UTC+8下午4时50分55秒，smallfish写道：
为什么要把代码写在nginx.conf里？我的意思是说换access_by_lua或者content实现。

--
smallfish http://chenxiaoyu.org

2014-06-10 16:40 GMT+08:00 R <rodi...@gmail.com>:

这个我看过，但是需要把lua脚本写在nginx.conf里面，这样的话感觉比较别扭。

在 2014年6月10日星期二UTC+8下午4时05分03秒，smallfish写道：

nginx-lua文档里已经明确set_by_lua禁用cosocket函数（tcp）：https://github.com/openresty/lua-nginx-module/#set_by_lua

换其他*_by_lua实现吧

--
smallfish http://chenxiaoyu.org

On Tue, Jun 10, 2014 at 3:49 PM, R <rodi...@gmail.com> wrote:

请教一个问题噢~~(通过邮件发送了，不过我在论坛没有收到，所有又在论坛发一次)

需求说明：
根据输入参数，通过lua文件查询mysql，并且返回对应的输出数据，然后根据数据的不同去做后续工作.

配置文件摘录：
server {
listen 8080;
server_name localhost;
root html;
index index.html index.htm;

location / {
set_by_lua_file $res conf/limit_mysql.lua $arg_uid;
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root html;
}
}

错误提示：
*1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:
[C]: in function 'tcp'

/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*

stack traceback: [C]: in function 'tcp'
/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:

[C]: in function 'tcp' /usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

mysql.lua提示错误的那几行代码是：
/usr/local/openresty/lualib/resty/mysql.lua

457 function _M.new(self)
458 local sock, err = tcp()
459 if not sock then

460 return nil, err
461 end
462 return setmetatable({ sock = sock }, mt)
463 end

--

--

--

lancelijade

set $env 'dev';
content_by_lua_file xx.lua;

试试这样的写法，在 xx.lua 里 ngx.var.env 访问

Lance

2014-06-10 17:49 GMT+08:00 R <rodi...@gmail.com>:

access_by_lua_file file.lua; 这个没法传入输入参数，也没法获取输出参数吧？
我想在file.lua里面获取到mysql的数据，然后根据这个信息去做下一步的操作。比如我传入用户的uid，然后我在mysql里面查询，如果有这个用户我就允许他访问后端的服务，如果没有这个用户我就返回HTTP 403;

在 2014年6月10日星期二UTC+8下午5时41分52秒，Lance Li写道：

access_by_lua_file

Lance

2014-06-10 16:55 GMT+08:00 R <rodi...@gmail.com>:

对啊，这种形式吧？
location /lua {
access_by_lua '
ngx.say(ngx.get_phase())

ngx.exit(200)
';
}
access_by_lua 里面不就是代码么？这个是在nginx.conf 里面吧？

在 2014年6月10日星期二UTC+8下午4时50分55秒，smallfish写道：
为什么要把代码写在nginx.conf里？我的意思是说换access_by_lua或者content实现。

--
smallfish http://chenxiaoyu.org

2014-06-10 16:40 GMT+08:00 R <rodi...@gmail.com>:

这个我看过，但是需要把lua脚本写在nginx.conf里面，这样的话感觉比较别扭。

在 2014年6月10日星期二UTC+8下午4时05分03秒，smallfish写道：

nginx-lua文档里已经明确set_by_lua禁用cosocket函数（tcp）：https://github.com/openresty/lua-nginx-module/#set_by_lua

换其他*_by_lua实现吧

--
smallfish http://chenxiaoyu.org

On Tue, Jun 10, 2014 at 3:49 PM, R <rodi...@gmail.com> wrote:

请教一个问题噢~~(通过邮件发送了，不过我在论坛没有收到，所有又在论坛发一次)

需求说明：
根据输入参数，通过lua文件查询mysql，并且返回对应的输出数据，然后根据数据的不同去做后续工作.

配置文件摘录：
server {
listen 8080;
server_name localhost;
root html;
index index.html index.htm;

location / {
set_by_lua_file $res conf/limit_mysql.lua $arg_uid;
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root html;
}
}

错误提示：
*1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:
[C]: in function 'tcp'

/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*

stack traceback: [C]: in function 'tcp'
/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'

/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:

[C]: in function 'tcp' /usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

mysql.lua提示错误的那几行代码是：
/usr/local/openresty/lualib/resty/mysql.lua

457 function _M.new(self)
458 local sock, err = tcp()
459 if not sock then

460 return nil, err
461 end
462 return setmetatable({ sock = sock }, mt)
463 end

--

--

--

--

rodin.chn

这样是可以的。那xx.lua里面的数据如何返回到上一层呢？

在 2014年6月10日星期二UTC+8下午5时51分35秒，Lance Li写道：

            set $env 'dev';
            content_by_lua_file xx.lua;

试试这样的写法，在 xx.lua 里 ngx.var.env 访问

Lance

2014-06-10 17:49 GMT+08:00 R <rodi...@gmail.com>:

access_by_lua_file file.lua; 这个没法传入输入参数，也没法获取输出参数吧？
我想在file.lua里面获取到mysql的数据，然后根据这个信息去做下一步的操作。比如我传入用户的uid，然后我在mysql里面查询，如果有这个用户我就允许他访问后端的服务，如果没有这个用户我就返回HTTP 403;

在 2014年6月10日星期二UTC+8下午5时41分52秒，Lance Li写道：

access_by_lua_file

Lance

2014-06-10 16:55 GMT+08:00 R <rodi...@gmail.com>:

对啊，这种形式吧？
location /lua {
access_by_lua '
ngx.say(ngx.get_phase())

ngx.exit(200)
';
}
access_by_lua 里面不就是代码么？这个是在nginx.conf 里面吧？

在 2014年6月10日星期二UTC+8下午4时50分55秒，smallfish写道：
为什么要把代码写在nginx.conf里？我的意思是说换access_by_lua或者content实现。

--
smallfish http://chenxiaoyu.org

2014-06-10 16:40 GMT+08:00 R <rodi...@gmail.com>:

这个我看过，但是需要把lua脚本写在nginx.conf里面，这样的话感觉比较别扭。

在 2014年6月10日星期二UTC+8下午4时05分03秒，smallfish写道：

nginx-lua文档里已经明确set_by_lua禁用cosocket函数（tcp）：https://github.com/openresty/lua-nginx-module/#set_by_lua

换其他*_by_lua实现吧

--
smallfish http://chenxiaoyu.org

On Tue, Jun 10, 2014 at 3:49 PM, R <rodi...@gmail.com> wrote:

请教一个问题噢~~(通过邮件发送了，不过我在论坛没有收到，所有又在论坛发一次)

需求说明：
根据输入参数，通过lua文件查询mysql，并且返回对应的输出数据，然后根据数据的不同去做后续工作.

配置文件摘录：
server {
listen 8080;
server_name localhost;
root html;
index index.html index.htm;

location / {
set_by_lua_file $res conf/limit_mysql.lua $arg_uid;
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root html;
}
}

错误提示：
*1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:
[C]: in function 'tcp'

/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*

stack traceback: [C]: in function 'tcp'
/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'

/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:

[C]: in function 'tcp' /usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

mysql.lua提示错误的那几行代码是：
/usr/local/openresty/lualib/resty/mysql.lua

457 function _M.new(self)
458 local sock, err = tcp()
459 if not sock then

460 return nil, err
461 end
462 return setmetatable({ sock = sock }, mt)
463 end

--

--

--

--

rodin.chn

在xx.lua里面给ngx.var.env赋值就可以了。谢谢啊~~~

在 2014年6月10日星期二UTC+8下午6时00分47秒，R写道：

这样是可以的。那xx.lua里面的数据如何返回到上一层呢？

在 2014年6月10日星期二UTC+8下午5时51分35秒，Lance Li写道：
            set $env 'dev';
            content_by_lua_file xx.lua;

试试这样的写法，在 xx.lua 里 ngx.var.env 访问

Lance

2014-06-10 17:49 GMT+08:00 R <rodi...@gmail.com>:

access_by_lua_file file.lua; 这个没法传入输入参数，也没法获取输出参数吧？
我想在file.lua里面获取到mysql的数据，然后根据这个信息去做下一步的操作。比如我传入用户的uid，然后我在mysql里面查询，如果有这个用户我就允许他访问后端的服务，如果没有这个用户我就返回HTTP 403;

在 2014年6月10日星期二UTC+8下午5时41分52秒，Lance Li写道：

access_by_lua_file

Lance

2014-06-10 16:55 GMT+08:00 R <rodi...@gmail.com>:

对啊，这种形式吧？
location /lua {
access_by_lua '
ngx.say(ngx.get_phase())

ngx.exit(200)
';
}
access_by_lua 里面不就是代码么？这个是在nginx.conf 里面吧？

在 2014年6月10日星期二UTC+8下午4时50分55秒，smallfish写道：
为什么要把代码写在nginx.conf里？我的意思是说换access_by_lua或者content实现。

--
smallfish http://chenxiaoyu.org

2014-06-10 16:40 GMT+08:00 R <rodi...@gmail.com>:

这个我看过，但是需要把lua脚本写在nginx.conf里面，这样的话感觉比较别扭。

在 2014年6月10日星期二UTC+8下午4时05分03秒，smallfish写道：

nginx-lua文档里已经明确set_by_lua禁用cosocket函数（tcp）：https://github.com/openresty/lua-nginx-module/#set_by_lua

换其他*_by_lua实现吧

--
smallfish http://chenxiaoyu.org

On Tue, Jun 10, 2014 at 3:49 PM, R <rodi...@gmail.com> wrote:

请教一个问题噢~~(通过邮件发送了，不过我在论坛没有收到，所有又在论坛发一次)

需求说明：
根据输入参数，通过lua文件查询mysql，并且返回对应的输出数据，然后根据数据的不同去做后续工作.

配置文件摘录：
server {
listen 8080;
server_name localhost;
root html;
index index.html index.htm;

location / {
set_by_lua_file $res conf/limit_mysql.lua $arg_uid;
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root html;
}
}

错误提示：
*1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:
[C]: in function 'tcp'

/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*

stack traceback: [C]: in function 'tcp'
/usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'

/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

2014/06/10 14:45:37 [error] 9541#0: *1 failed to run set_by_lua*: /usr/local/openresty/lualib/resty/mysql.lua:458: API disabled in the context of set_by_lua*stack traceback:

[C]: in function 'tcp' /usr/local/openresty/lualib/resty/mysql.lua:458: in function 'new'
/usr/local/openresty/nginx/conf/limit_mysql.lua:2: in function </usr/local/openresty/nginx/conf/limit_mysql.lua:1>, client: 127.0.0.1, server: localhost, request: "GET / HTTP/1.1", host: "127.0.0.1:8080"

mysql.lua提示错误的那几行代码是：
/usr/local/openresty/lualib/resty/mysql.lua

457 function _M.new(self)
458 local sock, err = tcp()
459 if not sock then

460 return nil, err
461 end
462 return setmetatable({ sock = sock }, mt)
463 end

--

--

--

--