Hi Akki,
hope you're doing well these days.
On Tue, Jul 20, 2021 at 02:05:41PM +0530, awani227 wrote:
> Hi,
>
> I'm using 'nginx/1.21.1' for load balancing TCP connection for DBs
> like Teradata, Netezza, Oracle and MySQL. I'm using stream directive
> for it as per the guidance
> 'https://docs.nginx.com/nginx/admin-guide/load-balancer/tcp-udp-load-balancer/' .
>
> Following is my stream configuration (/etc/nginx/nginx.conf)
>
> stream {
>
> log_format timed_combined '$remote_addr - [$time_local] $session_time $msec $status $protocol ua="$upstream_addr" "$upstream_connect_time" "$upstream_response_time"';
> access_log /var/log/nginx/access.log timed_combined;
>
> upstream stream_backend_mysql {
> hash $remote_addr;
> server 192.168.122.251:3306;
> server 192.168.122.252:3306;
> }
>
> server {
> listen 3306;
> proxy_pass stream_backend_mysql;
> proxy_connect_timeout 1s;
> }
> }
>
> I'm able to establish connection for mysql in this setup, but when
> I'm adding the log_format directive nginx is giving following error,
>
> 'nginx: [emerg] unknown "upstream_response_time" variable'
The $upstream_response_time embedded variable is available with
ngx_http_upstream module,
https://nginx.org/en/docs/http/ngx_http_upstream_module.html#variables
For ngx_stream_upstream you can utilize the following variables:
https://nginx.org/en/docs/stream/ngx_stream_upstream_module.html#variables
--
Sergey
_______________________________________________
nginx mailing list
nginx@nginx.org
http://mailman.nginx.org/mailman/listinfo/nginx
