# nginx lua

**Repository Path**: abke/lua-nginx

## Basic Information

- **Project Name**: nginx lua
- **Description**: nginx lua redis  mysql
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2019-08-05
- **Last Updated**: 2022-09-16

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 功能

使用 openresty 代理 记录请求和响应的内容 用于调试


## 模式
请求 
    客户端->openresty->php-fpm
响应
    php-fpm->openresty->客户端

## 安装 openresty
```
wget https://openresty.org/download/openresty-1.15.8.1.tar.gz
tar -zxvf openresty-1.15.8.1.tar.gz
cd openresty-1.15.8.1
./configure
make && make install
```

复制 lib/config.example.lua 到 lib/config.lua
修改 mysql 配置 

```
lib/config.lua
```

## openresty 配置, server 里加入
```
lua_package_path "/home/web/lua/lib/?.lua;;";
server{
    location / {
        root   /home/web/lua;
        more_set_headers 'Content-Type: text/html';
        content_by_lua_file /home/web/lua/$uri.lua;
        # 开发时关闭代码缓存
        lua_code_cache off; 
    }
}
```


##  记录请求的内容的配置

```
lua_package_path "/home/web/lua/lib/?.lua;;";
server {
    server_name api.com;
    listen 8080 ;
    body_filter_by_lua_file /home/web/lua/httpLog.lua;
    root /www/;
    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }
    location ~ \.php$ {
        fastcgi_pass 127.0.0.1:9000;
        fastcgi_index  index.php;
        fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
        include        fastcgi_params;
    }
}

```


## 测试

访问
http://localhost/demo/mysql

http://localhost/demo/redis

说明
要开启代码缓存 连接池才有用


### 创建表的 SQL

```
CREATE TABLE `debug_http_logs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `host` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `uri` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `args` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `header` text COLLATE utf8mb4_unicode_ci,
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `requestBody` longtext COLLATE utf8mb4_unicode_ci,
  `responseStatus` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `responseBody` longtext COLLATE utf8mb4_unicode_ci,
  `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `host` (`host`)
) ENGINE=InnoDB AUTO_INCREMENT=481366 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='nginx 请求日志';

```