From: Bill Hernandez <pgsql@mac-specialist.com>
To: pgsql-admin@postgresql.org
Subject: $_SERVER['SERVER_ADDR'] ; returns wrong value "::1"
Date: Wed, 15 Jun 2005 23:58:11 -0500
Message-ID: <BED67113.D2E5%pgsql@mac-specialist.com> (raw)
In-Reply-To: <10056.1118894915@sss.pgh.pa.us>
On 6/15/05 11:08 PM, "Tom Lane" <tgl@sss.pgh.pa.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: pgsql@mac-specialist.com
Subject: Re: $_SERVER['SERVER_ADDR'] ; returns wrong value "::1"
In-Reply-To: <BED67113.D2E5%pgsql@mac-specialist.com>
References: <10056.1118894915@sss.pgh.pa.us> <BED67113.D2E5%pgsql@mac-specialist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox