<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Thanks for your Reply<br>
<br>
Y solved this issue.<br>
<br>
With this URL:<br>
<br>
<a class="moz-txt-link-freetext" href="https://github.com/tommybotten/mod_log_sql/commit/23e52d480edcd8406f0338c6a64167a3298985d1">https://github.com/tommybotten/mod_log_sql/commit/23e52d480edcd8406f0338c6a64167a3298985d1</a><br>
<br>
Regards.<br>
<br>
Fabián M. Sales.<br>
<br>
On 10/03/15 13:50, Daniël Mostertman wrote:<br>
</div>
<blockquote cite="mid:54FF20DF.8020005@mostertman.org" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">Hi Fabián,<br>
<br>
You most likely put nginx in front of Apache.<br>
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.<br>
<br>
You might want to look into passing the IP of the visitor to
your backend (Apache).<br>
A good example can be found easily with a search engine, like
this:<br>
<br>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.daveperrett.com/articles/2009/08/10/passing-ips-to-apache-with-nginx-proxy/">http://www.daveperrett.com/articles/2009/08/10/passing-ips-to-apache-with-nginx-proxy/</a><br>
<br>
Hope this helps,<br>
<br>
Daniël<br>
<br>
Fabián M Sales schreef op 10-3-2015 om 17:48:<br>
</div>
<blockquote cite="mid:54FF2047.9000107@donweb.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">Any idea?<br>
<br>
Thanks.<br>
On 04/03/15 15:18, Fabián M Sales wrote:<br>
</div>
<blockquote cite="mid:54F74C8B.80007@donweb.com" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
Hello List.<br>
<br>
<span id="result_box" class="" lang="en"><span class="hps">I</span>
use <span class="hps">mod_log_sql</span><span>-1.10</span>
<span class="hps">compiled into</span> <span class="hps">Apache
/</span> <span class="hps">2.4.7</span> <span
class="hps">and</span> <span class="hps">write</span> <span
class="hps">correctly in</span> <span class="hps">MySQL.</span><br>
<br>
<span class="hps">In</span> <span class="hps">the</span> <span
class="hps">nginx</span> <span class="hps">web</span> <span
class="hps">server</span> <span class="hps">with</span> <span
class="hps">the</span> <span class="hps">IP</span> <span
class="hps alt-edited">writer</span> <span class="hps">in</span>
<span class="hps">MySQL</span> <span class="hps">is the</span>
<span class="hps">IP</span> <span class="hps">of the</span>
<span class="hps">webserver</span> <span class="hps">and</span>
<span class="hps">not</span> <span class="hps">the client
IP</span> <span class="hps">to access the</span> <span
class="hps">website.</span><br>
<br>
<span class="hps">You might still</span> <span class="hps">be</span>
<span class="hps">able to write</span> <span class="hps">the
client IP</span> <span class="hps atn">and non-</span><span>IP</span>
<span class="hps">using</span> <span class="hps">nginx</span>
<span class="hps">webserver</span><span class="">?</span></span><br>
<br>
<div class="moz-signature">-- <br>
<meta http-equiv="CONTENT-TYPE" content="text/html;
charset=ISO-8859-1">
<title>Firma Institucional</title>
<meta name="GENERATOR" content="LibreOffice 4.0.2.2 (Linux)">
<meta name="CREATED" content="0;0">
<meta name="CHANGEDBY" content="Fabian ">
<meta name="CHANGED" content="20140910;15295200">
<meta name="CHANGEDBY" content="Fabian ">
<meta name="CHANGEDBY" content="Fabian ">
<!--<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style type="text/css">
<!--
P { font-family: "Times New Roman"; font-size: 12pt }
TD P { font-family: "Times New Roman"; font-size: 12pt }
P.msonormal { margin-bottom: 0cm; font-family: "Times New Roman"; font-size: 12pt }
A:link { color: #0000ff }
A:visited { color: #0000ff }
--></style></div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
nginx mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:nginx@nginx.org">nginx@nginx.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.nginx.org/mailman/listinfo/nginx">http://mailman.nginx.org/mailman/listinfo/nginx</a></pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- </div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
nginx mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:nginx@nginx.org">nginx@nginx.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.nginx.org/mailman/listinfo/nginx">http://mailman.nginx.org/mailman/listinfo/nginx</a></pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
nginx mailing list
<a class="moz-txt-link-abbreviated" href="mailto:nginx@nginx.org">nginx@nginx.org</a>
<a class="moz-txt-link-freetext" href="http://mailman.nginx.org/mailman/listinfo/nginx">http://mailman.nginx.org/mailman/listinfo/nginx</a></pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<meta http-equiv="CONTENT-TYPE" content="text/html;
charset=ISO-8859-1">
<title>Firma Institucional</title>
<meta name="GENERATOR" content="LibreOffice 4.0.2.2 (Linux)">
<meta name="CREATED" content="0;0">
<meta name="CHANGEDBY" content="Fabian ">
<meta name="CHANGED" content="20140910;15295200">
<meta name="CHANGEDBY" content="Fabian ">
<meta name="CHANGEDBY" content="Fabian ">
<!--<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style type="text/css">
<!--
P { font-family: "Times New Roman"; font-size: 12pt }
TD P { font-family: "Times New Roman"; font-size: 12pt }
P.msonormal { margin-bottom: 0cm; font-family: "Times New Roman"; font-size: 12pt }
A:link { color: #0000ff }
A:visited { color: #0000ff }
-->
</style>
<p class="msonormal" style="margin-bottom: 0.5cm"> </p>
<table cellpadding="0" cellspacing="0" width="100%"
bgcolor="#ffffff">
<tbody>
<tr>
<td style="border: none; padding: 0cm" width="137">
<p class="msonormal" align="CENTER"><a name="_x0000_i1025"></a><img
src="cid:part7.08080706.07080102@donweb.com"
name="gráficos1" align="BOTTOM" height="54"
width="110" border="0"></p>
</td>
<td style="border-top: none; border-bottom: none;
border-left: 1.00pt solid #cccccc; border-right: none;
padding-top: 0cm; padding-bottom: 0cm; padding-left:
0.28cm; padding-right: 0cm" bgcolor="#f0f0f0">
<p style="margin-bottom: 0.25cm"><font face="Arial"><font
style="font-size: 8pt" size="1"><b>Fabián</b></font></font>
<font face="Arial"><font style="font-size: 8pt" size="1"><b>M.
Sales<br>
</b></font></font><font face="Arial"><font
style="font-size: 8pt" size="1">Soporte Técnico
& I.T.I Linux </font></font> </p>
<p style="margin-bottom: 0.25cm"><font face="Arial"><font
style="font-size: 8pt" size="1"><b>DonWeb </b></font></font><font
face="Arial"><font style="font-size: 8pt" size="1"><br>
La Actitud Es Todo<br>
</font></font><a href="www.DonWeb.com" target="_blank"><font
color="#000000"><font face="Arial"><font
style="font-size: 8pt" size="1">www.DonWeb.com</font></font></font></a></p>
<p class="msonormal"> </p>
</td>
</tr>
</tbody>
</table>
<hr size="2">
<p class="msonormal" style="margin-bottom: 0.5cm"><font
face="Arial"><font style="font-size: 9pt" size="2"><span
lang="es-AR">Nota
de confidencialidad: Este mensaje y archivos adjuntos al
mismo son
confidenciales, de uso exclusivo para el destinatario del
mismo. La
divulgación</span></font></font> <font face="Arial"><font
style="font-size: 9pt" size="2"><span lang="es-AR">y/o
uso del mismo sin autorización</span></font></font> <font
face="Arial"><font style="font-size: 9pt" size="2"><span
lang="es-AR">por
parte de DonWeb.com queda prohibida.<br>
</span></font></font><font face="Arial"><font
style="font-size: 9pt" size="2">DonWeb.com
no se hace responsable del mensaje por la falsificación</font></font>
<font face="Arial"><font style="font-size: 9pt" size="2">y/o
alteración</font></font>
<font face="Arial"><font style="font-size: 9pt" size="2">del
mismo.<br>
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.<br>
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.<br>
DonWeb.com shall not be liable for the message
if altered or falsified.<br>
If you are not the intended addressee of
this message, please cancel it immediately and inform the
sender<br>
Nota
de Confidencialidade: Esta mensagem e seus eventuais anexos
podem
conter dados confidenciais ou privilegiados.<br>
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.<br>
É proibida a retenção,
distribuição, divulgação ou utilização de quaisquer
informações
aqui contidas.<br>
Por favor, informenos sobre o recebimento indevido
desta mensagem, retornando-a para o autor.</font></font></p>
</div>
</body>
</html>