Oracle Portal: Get visitor IP Address
Date: Tue, 06 Apr 2004 15:59:10 -0300
Message-ID: <4uu5705vhjgndrmc299e7gkg40f9k9bcgv_at_4ax.com>
Hi!
[Quoted] [Quoted] I have developed a nice portal for a health insurance company and now big boss wants to record the [Quoted] [Quoted] IP of the people who are visiting the website, he wants to do more or less what those counters do [Quoted] (the one I remember is thecounter.com, but there are others.), so he can decide where he should [Quoted] concentrate on advertising...
I searched at asktom.oracle.com and found some examples and I came to this:
[Quoted] Insert into the_log_table ( ip#, dt_visita )
Select sys_context( 'userenv', 'ip_address' ),
SysDate
from dual ;
As you see, I'm using sys_context, but it gets the IP of the machine which is conected to the [Quoted] database, and it's always the internal IP of the web server. 192.***** This code is right at the [Quoted] main "portlet", in a way that it's impossible to have access to the website without going through that insert.
[Quoted] Is there any way, any package, something that I can use to get the IP address of the visitor of the page?
[Quoted] portal version is 3.0.9.8.5 (latest patch level for portal v1), DB is 8.1.7.4 and Apache is under [Quoted] SuSe 7.3
Thanks in Advance and forgive my bad english!
-- Tiago Rocha Recife - Brasil www.diariodastrilhas.cjb.netReceived on Tue Apr 06 2004 - 20:59:10 CEST