pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (3+ messages)  latest in thread

Message-ID: <BED67113.D2E5%pgsql@mac-specialist.com>
Permalink:  ../BED67113.D2E5%25pgsql@mac-specialist.com/
Also on:    postgresql.org/message-id/BED67113.D2E5%pgsql@mac-specialist.com

 · 

reply

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