Nginx转发MySQL端口及添加stream模块
1.在nginx.conf的http同级添加stream配置
stream {
upstream mysql_server{
server 192.168.23.25:3306;
}
server {
listen 8560;
proxy_pass mysql_server;
}
}
http {
....
}
启动nginx后发现报错如下，找不到stream模块，该模块在nginx1.9版本后才支持的:nginx: [emerg] unknown directive "stream" in /usr/local/nginx//conf/nginx.conf:118
2.查看nginx编译模块
portal@host02[/lvdata/portal/install/nginx/sbin]$ ./nginx -V
nginx version: nginx/1.26.0
built by gcc 4.8.5 20150623 (Red Hat 4.8.5-44) (GCC)
built with OpenSSL 1.0.2k-fips 26 Jan 2017
TLS SNI support enabled
configure arguments: --prefix=../nginx --with-http_ssl_module
3.重新编译nginx
3.1下载相同版本的nginx并解压
portal@host02[/lvdata/portal]$ tar -xvf nginx-1.26.0.tar.gz
3.2重新编译
重新编译，指定--prefix的路径，即nginx安装路径，后面nginx生成的logs等都在此目录下面，只执行make即可，请不要执行后面的install命令，编译后切换到objs目录，即可看到重新生成的nginx文件，备份好的原来的nginx，拷贝新生成的覆盖原来的重启即可。
portal@host02[/lvdata/portal/nginx-1.26.0]$ ./configure --prefix=/lvdata/portal/install/nginx --with-http_ssl_module --with-http_v2_module --with-http_gzip_static_module --with-http_sub_module --with-stream
portal@host02[/lvdata/portal/nginx-1.26.0]$ make
portal@host02[/lvdata/portal/nginx-1.26.0]$ cd objs
portal@host02[/lvdata/portal/nginx-1.26.0/objs]$ ll
total 7880
-rw-rw-r-- 1 portal portal 22613 Nov 2 11:09 autoconf.err
-rw-rw-r-- 1 portal portal 53112 Nov 2 11:09 Makefile
-rwxrwxr-x 1 portal portal 7861920 Nov 2 11:10 nginx
-rw-rw-r-- 1 portal portal 5585 Nov 2 11:10 nginx.8
-rw-rw-r-- 1 portal portal 7595 Nov 2 11:09 ngx_auto_config.h
-rw-rw-r-- 1 portal portal 657 Nov 2 11:09 ngx_auto_headers.h
-rw-rw-r-- 1 portal portal 8654 Nov 2 11:09 ngx_modules.c
-rw-rw-r-- 1 portal portal 92688 Nov 2 11:10 ngx_modules.o
drwxrwxr-x 9 portal portal 91 Nov 2 11:09 src
portal@host02[/lvdata/portal/nginx-1.26.0/objs]$ cp nginx /lvdata/portal/install/nginx/sbin
注意:如果prefix路径指定得不对，启动提示报错如下:
portal@host02[/lvdata/portal/install/nginx/sbin]$ ./nginx -s reload
nginx: [alert] could not open error log file: open() "/lvdata/portal/nginx-1.26.0/logs/error.log" failed (2: No such file or directory)
2024/11/02 11:00:13 [notice] 16812#0: signal process started
2024/11/02 11:00:13 [error] 16812#0: open() "/lvdata/portal/nginx-1.26.0/logs/nginx.pid" failed (2: No such file or directory)
3.3重启Nginx
portal@host02[/lvdata/portal/install/nginx/sbin]$ cd /lvdata/portal/install/nginx/sbin
portal@host02[/lvdata/portal/install/nginx/sbin]$ ./nginx -s reload