lua nginx mysql_nginx+lua学习笔记

一. 本地linux环境搭建

1. 安装vmware

3. centos关闭防火墙(当然只是方便学习用才关闭)/etc/init.d/iptables stop

4. 添加用户 useradd test

passwd test

5. 配置ssh

vim /etc/ssh/sshd_config

service sshd restart

二. 安装nginx(openresty)

wget "http://openresty.org/download/ngx_openresty-1.5.8.1.tar.gz"

tar xzvf ngx_openresty-1.5.8.1.tar.gz

yum install gcc

yum install readline-devel pcre-devel openssl-devel

./configure

gmake

gmake install

三. 配置nginx

PATH=/usr/local/openresty/nginx/sbin:$PATH

export PATH

vim /usr/local/openresty/nginx/conf/nginx.conf

比如：

worker_processes  1;

error_log logs/error.log;

events {

worker_connections 1024;

}

http {

server {

listen 8080;

location / {

default_type text/html;

content_by_lua '

ngx.say("

hello, world

")

';

}

}

}

四. nginx操作mysql

1. 修改nginx.conf

worker_processes  1;

error_log  /log/nginx/logs/error.log;

events {

worker_connections  1024;

}

http {

include       mime.types;

default_type  application/octet-stream;

log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '

'$status $body_bytes_sent "$http_referer" '

'"$http_user_agent" "$http_x_forwarded_for"';

access_log  /log/nginx/logs/access.log  main;

sendfile        on;

keepalive_timeout  65;

lua_package_path "/usr/local/openresty/nginx/conf/lua/?.lua;;";

server {

listen       8000;

server_name  localhost;

location / {

root   html;

index  index.html index.htm;

}

error_page   500 502 503 504  /50x.html;

location = /50x.html {

root   html;

}

location = /interface{

default_type 'text/plain';

content_by_lua_file conf/lua/interface.lua;

}

}

}

2. 编写lua脚本

-------dbUtil.lua

dbUtil = {}

function dbUtil.getCon()

if not ngx.ctx.dbCon then

local mysql = require "resty.mysql"

local db, err = mysql:new()

if not db then

ngx.log(ngx.ERR, "failed to instantiate mysql: ", err)

return false, nil

end

db:set_timeout(6000)

local ok, err, errinfo, sqlstate = db:connect{

host = "xxx",

port = xxx,

database = "xxx",

user = "xxx",

password = "xxx",

max_packet_size = 1024 * 1024

}

if not ok then

ngx.log(ngx.ERR, "failed to connect: ", err, ": ", errno, " ", sqlstate)

return false, nil

end

ngx.ctx.dbCon = db

end

return true, ngx.ctx.dbCon

end

function dbUtil.closeCon(dbCon)

if not dbCon then return end

local ok, err = dbCon:set_keepalive(10000, 3000)

if not ok then

ngx.say("failed to set keepalive: ", err)

dbCon:close()

return

end

end

return dbUtil

---------interface.lua

local dbutil  = require("dbutil")

local args = ngx.req.get_uri_args()

if args == nil then

ngx.say("{}")

end

local md5 = args["md5"]

if not md5 then

ngx.exit(400)

elseif string.len(tostring(md5)) ~= 32 then

ngx.exit(400)

end

if not cjson then cjson = require "cjson" end

local status, db = dbutil.getCon()

if not status then

ngx.exit(500)

end

local sql = "SELECT xxx FROM xxx WHERE MD5='" .. md5 .. "'"

local res, err, errno, sqlstate = db:query(sql)

if res then

ngx.say(cjson.encode(res))

else

ngx.say(err, errno,sqlstate)

end

dbutil.closeCon(db)

分享到：

2014-02-21 15:55

浏览 1141

分类:互联网

评论