Oracle Portal: Get visitor IP Address

From: Tiago Rocha <please.see.link.at.signature.for.email.address_at_zaz.com.br>
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.net
Received on Tue Apr 06 2004 - 20:59:10 CEST

Original text of this message