$_SERVER['SERVER_ADDR'] ; returns wrong value "::1"

From: Bill Hernandez <pgsql(at)mac-specialist(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: $_SERVER['SERVER_ADDR'] ; returns wrong value "::1"
Date: 2005-06-16 04:58:11
Message-ID: BED67113.D2E5%pgsql@mac-specialist.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 6/15/05 11:08 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

Tom,

I've been lurking on the pgsql forum for some time, and today I read a reply
you had posted, and thought to myself, "He probably has a good idea what is
causing my problem", so here it is, if you don't mind taking alook at it...

My server is a G4 running OS X Server, and my current workstation is an
iMacG5 running OS X 10.4.1

I do my development on the iMacG5, which is a duplicate of the server
contents as far as the directory hierarchy is concerned. Once I have stuff
working I move a copy to the server.

When running in localhost mode on my G5 using something like
http://localhost/demo/show_items.php

$server_address = $_SERVER['SERVER_ADDR'] ; returns "::1"

function ShowArray($aArray)
{
echo "<pre>" ;
print_r($aArray) ;
echo "</pre>" ;
return ;
}

ShowArray($_SERVER) ; shows :

HTTP_USER_AGENT Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-us)
AppleWebKit/412 (KHTML, like Gecko) Safari/412

SERVER_SOFTWARE Apache/2.0.52 (Unix) DAV/2 PHP/5.0.4

HTTP_HOST localhost
SERVER_NAME localhost
SERVER_ADDR ::1
REMOTE_ADDR ::1

If I run the same page on my workstation, and access the page from the
server via the fully_qualified_domain, the

http://fully_qualified_domain/demo/show_items.php

ShowArray($_SERVER) ; shows :

SERVER_SOFTWARE Apache/1.3.33 (Darwin) DAV/1.0.3 mod_ssl/2.8.22
OpenSSL/0.9.7b LittleDutchMoose/v10.3(Build 2A82) PHP/4.3.10 mod_perl/1.26

HTTP_HOST www.my_domain_name.com
SERVER_NAME www.my_domain_name.com
SERVER_ADDR 192.168.1.47
REMOTE_ADDR 64.166.143.xxx

NetInfo shows : machines -> localhost -> 127.0.0.1

I have no clue where the "::1" is coming from ? I have several routines that
depend on the $_SERVER['SERVER_ADDR'] , and the $_SERVER['REMOTE_ADDR']

Any help would be appreciated...

Bill Hernandez
Plano, Texas

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2005-06-16 09:05:41 Re: Indexes getting corrupted.
Previous Message Tom Lane 2005-06-16 04:08:35 Re: Connecting via localhost pg-8.0.3