Re: Oracle Portal: Get visitor IP Address

[Quoted] On 7 Apr 2004 08:59:15 -0800, yf110_at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
>
>Of course you understand that many many many browsers will be arriving
>through proxies, so the ip you see is commonly not the computer running
>the browser, and that the same browser can reach you with multiple ip
>addresses.

Yes, I understand that. Actually, the initial main objective of this is know how many access are made within our intranet (which is very large and cover the entire city, all our offices have a direct conection and all machines have the same IP from our firewall) to separe from visits made by potential customers. Even if the same browser gives me two different IPs, that's fine, because both will be on the same IP range. And there is dialup conections, that change the IP for every conection... I don't plan to use the IPs for nothing more than find out what ISP or network is being used. And count page-views, so we can justify that expensive Oracle box we made management buy...

[Quoted] Do you know what's funny and sad at the same time? Yesterday evening, before leaving work, I put the code Robert gave me (tks again Robert) on the production database and went home. This morning, I performed a select on the log table and there was the first entry at 2am. That's weird, who would be looking for health care insurance at 2am? So I traced that IP and found that was a robot based in San Francisco (US), probably looking for email addresses to spam...

-- 
Tiago Rocha
Recife - Brasil
www.diariodastrilhas.cjb.net