NGINX and mod_log_sql

Hello List.

I use mod_log_sql-1.10 compiled into Apache / 2.4.7 and write correctly
in MySQL.

In the nginx web server with the IP writer in MySQL is the IP of the
webserver and not the client IP to access the website.

You might still be able to write the client IP and non-IP using nginx
webserver?

Any idea?

Thanks.

Hi Fabi?n,

You most likely put nginx in front of Apache.
If that’s the case, then chances are that you see the address in your
logs that nginx contacts Apache from, instead of the user connecting to
nginx.

You might want to look into passing the IP of the visitor to your
backend (Apache).
A good example can be found easily with a search engine, like this:

http://www.daveperrett.com/articles/2009/08/10/passing-ips-to-apache-with-nginx-proxy/

Hope this helps,

Dani?l

Fabi?n M Sales schreef op 10-3-2015 om 17:48:

Thanks for your Reply

Y solved this issue.

With this URL:

https://github.com/tommybotten/mod_log_sql/commit/23e52d480edcd8406f0338c6a64167a3298985d1

Regards.

Fabi?n M. Sales.

On 10/03/15 13:50, Dani?l Mostertman wrote:

On 04/03/15 15:18, Fabi?n M Sales wrote:


nginx mailing list
[email protected]
http://mailman.nginx.org/mailman/listinfo/nginx


Firma Institucional

Fabi?n *M. Sales
*Soporte T?cnico & I.T.I Linux

*DonWeb *
La Actitud Es Todo
www.DonWeb.com


Nota de confidencialidad: Este mensaje y archivos adjuntos al mismo son
confidenciales, de uso exclusivo para el destinatario del mismo. La
divulgaci?n y/o uso del mismo sin autorizaci?n por parte de DonWeb.com
queda prohibida.
DonWeb.com no se hace responsable del mensaje por la falsificaci?n y/o
alteraci?n del mismo.
De no ser Ud el destinatario del mismo y lo ha recibido por error, por
favor, notifique al remitente y elim?elo de su sistema.
Confidentiality Note: This message and any attachments (the message) are
confidential and intended solely for the addressees. Any unauthorised
use or dissemination is prohibited by DonWeb.com.
DonWeb.com shall not be liable for the message if altered or falsified.
If you are not the intended addressee of this message, please cancel it
immediately and inform the sender
Nota de Confidencialidade: Esta mensagem e seus eventuais anexos podem
conter dados confidenciais ou privilegiados.
Se voc? os recebeu por engano ou n?o ? um dos destinat?rios aos quais
ela foi endere?ada, por favor destrua-a e a todos os seus eventuais
anexos ou copias realizadas, imediatamente.
? proibida a reten??o, distribui??o, divulga??o ou utiliza??o de
quaisquer informa??es aqui contidas.
Por favor, informenos sobre o recebimento indevido desta mensagem,
retornando-a para o autor.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs