nginx 通过内网图片地址，外网访问实现

描述：数据库中的图片地址是局域网地址，或者图片抓拍机返回的

1.修改nginx配置文件 

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  logs/access.log  main;

    sendfile        on;
    #tcp_nopush     on;

    #keepalive_timeout  0;
    keepalive_timeout  65;

    #gzip  on;

    server {
        listen       28950;
        server_name  localhost;
		resolver 8.8.8.8 ipv6=off;
		location ~/angentImg/ {
			if ($query_string ~*  ^(.*)type=image&pic_url=(.*)$){
				set $pic_url $2;
				# set $pic_url $arg_pic_url
				proxy_pass $pic_url;
			}
		}
	
    }


}

2.访问方式

http://xxx/angentImg/?type=image&pic_url=http://xxx

3.修改数据库中的图片地址

SELECT
CONCAT("http://103.221.88.2:18010/angentImg/?type=image&pic_url=",v.ThroughSmartImgUrl) as ThroughSmartImgUrl ,
v.VehicleNO,
v.VehicleColor,
v.VehicleType,
v.VehicleBrand,
v.VehicleSeries,
v.ChannelName,
v.ThroughTime
FROM vehiclehistory v 
WHERE v.VehicleNO <> '-'