因为有时候有那么一个需求，需要云数据库开放外网地址，但是有个别云运营商是没有提供这个操作的，经过几番头脑风暴后，想起了nginx上又一个–with-stream模块可以把内网ip端口映射到外网地址去！这不就解决了这个需求啦吗！！！
首先查看nginx有没有这个模块，没有就编译安装：
[root@cml ~]# /usr/local/nginx/sbin/nginx -V
nginx version: openresty/1.9.7.4
built by gcc 4.8.5 20150623 (Red Hat 4.8.5-16) (GCC)
built with OpenSSL 1.0.2k-fips 26 Jan 2017
TLS SNI support enabled
configure arguments: –prefix=/usr/local/nginx –with-cc-opt=-O2 –add-module=../ngx_devel_kit-0.2.19 –add-module=../echo-nginx-module-0.58 –add-module=../xss-nginx-module-0.05 –add-module=../ngx_coolkit-0.2rc3 –add-module=../set-misc-nginx-module-0.30 –add-module=../form-input-nginx-module-0.11 –add-module=../encrypted-session-nginx-module-0.04 –add-module=../drizzle-nginx-module-0.1.9 –add-module=../srcache-nginx-module-0.30 –add-module=../ngx_lua-0.10.2 –add-module=../ngx_lua_upstream-0.05 –add-module=../headers-more-nginx-module-0.29 –add-module=../array-var-nginx-module-0.05 –add-module=../memc-nginx-module-0.16 –add-module=../redis2-nginx-module-0.12 –add-module=../redis-nginx-module-0.3.7 –add-module=../rds-json-nginx-module-0.14 –add-module=../rds-csv-nginx-module-0.07 –with-ld-opt=-Wl,-rpath,/usr/local/luajit/lib –conf-path=/etc/nginx/nginx.conf –user=www –group=www –with-http_stub_status_module –with-http_gzip_static_module –with-http_realip_module –with-http_ssl_module –add-module=/root/src/gnosek-nginx-upstream-fair-a18b409 –add-module=/root/src/ngx_cache_purge-2.3 –add-module=/root/src/nginx-http-concat –with-http_v2_module –with-stream
编译安装：
cd /root/src cd openresty-1.11.2.5 ./configure --prefix=/usr/local --conf-path=/etc/nginx/nginx.conf --user=www --group=www --with-http_stub_status_module --with-http_gzip_static_module --with-http_realip_module --with-http_ssl_module --add-module=/root/src/gnosek-nginx-upstream-fair-a18b409 --add-module=/root/src/ngx_cache_purge-2.3 --add-module=/root/src/nginx-http-concat --with-luajit --with-http_v2_module --with-http_drizzle_module --with-stream if make -j8;then make install else exit 1 fi mkdir -p /etc/nginx/vhost mkdir -p /usr/local/nginx/temp mkdir -p /usr/local/nginx/cache chown www:www /usr/local/nginx/temp chown www:www /usr/local/nginx/cache /bin/cp -f /root/src/nginx.conf /etc/nginx/nginx.conf
开始配置stream
[root@cml ~]# vim /etc/nginx/nginx.conf
user www www;
.................
stream {
upstream mysql_3306 {
server 192.168.1.5:3306;
}
server {
listen 3306;
proxy_connect_timeout 20s;
proxy_pass mysql_3306;
}
}
重启nginx：
[root@cml ~]# /usr/local/nginx/sbin/nginx -t
[root@cml ~]# /usr/local/nginx/sbin/nginx -s reload
测试：
测试使用外网地址已经连得上了