Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 96CB99FB2BF for ; Wed, 14 Mar 2007 15:07:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 55200-06 for ; Wed, 14 Mar 2007 15:07:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by postgresql.org (Postfix) with ESMTP id 72BCB9FB284 for ; Wed, 14 Mar 2007 15:07:01 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id x4so334751nfb for ; Wed, 14 Mar 2007 11:07:00 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Wqj72MNkNUEihuHPar4xvUaiY1hzeuRMNDS1hzd0U6QjIWWIINyGk2h0vw+tXZR9clSpJ7sqcc8AaC+f3hX4tXbB5q4fh6SWiEDAct+t3qDRe6YLADBx6XADobftkNpdrxuuOf0BJdXVBOpfBIS0gEdf4tf2ii2ZAiRpGVqVa/o= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=rxg6P/YRdy/JsJmgNvUdZADPMPG8Rm4u+d0X/dcWLPeylYDElfRT5HCH7AvTslDW30bmFadUBv8avPLCaPpBKo0xHsg6in79qErGcmIfGbT5WddYBfnB+BG4JKI943oHwipPUTkjbdL/2gUPIwsuvJwyt+mvs9QcPOOtRK8mx5o= Received: by 10.78.158.11 with SMTP id g11mr1355163hue.1173895620034; Wed, 14 Mar 2007 11:07:00 -0700 (PDT) Received: by 10.78.160.6 with HTTP; Wed, 14 Mar 2007 11:06:59 -0700 (PDT) Message-ID: <6b8c0db0703141106u6e136d4mc97df5b4ed0d17fc@mail.gmail.com> Date: Wed, 14 Mar 2007 14:06:59 -0400 From: "=?ISO-8859-1?Q?Valent=EDn_Orfila?=" To: "Matthew Terenzio" Subject: Re: Problems in connecting to postgreSQL using PHP Cc: "Kitty Yuen" , pgsql-php@postgresql.org In-Reply-To: <6b8c0db0703120641j4539003ck49f28edb02408ae9@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_33554_18530516.1173895619919" References: <6b8c0db0703120637r2b7e010pbc3f2e403f61531e@mail.gmail.com> <6b8c0db0703120641j4539003ck49f28edb02408ae9@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.459 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_50_60, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/45 X-Sequence-Number: 3757 ------=_Part_33554_18530516.1173895619919 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Kitty, Try try using this function: pg_pconnect("host=3D$servidor dbname=3D$base user=3D$usuario password=3D$password");, I mean, use the connection script = I'm going to paste below. 2007/3/12, Valent=EDn Orfila : > > here is the script again > > $servidor =3D "localhost"; > $base =3D "databasename"; //change it > $usuario =3D "postgresuser"; //change it > $password =3D "postgresuserpassword"; //change it > > pg_pconnect("host=3D$servidor dbname=3D$base user=3D$usuario > password=3D$password"); > > ?> > > 2007/3/12, Valent=EDn Orfila : > > > > Hi!!! I'm Venezuelan and I don't know how to speak english very well, s= o > > excuse me if i make a mistake. > > > > About the connection: Did you do your script by yourself?, or copied a > > functional one? > > > > As Thomas Schindler said, send us any PHP errors or the pg_hba.conf ? > > > > Here is my connection script, it is completly good check it out to see > > if you have anything wrong > > > > > $servidor =3D "localhost"; > > $base =3D "databasename"; //change it > > $usuario =3D "postgresuser"; //change it > > $password =3D "postgresuser"; //change it > > > > pg_pconnect("host=3D$servidor dbname=3D$base user=3D$usuario > > password=3D$password"); > > > > ?> > > > > That's all what I can do for now > > > > 2007/3/12, Matthew Terenzio < matt@jobsforge.com>: > > > > > > Could you provide any PHP errors or the pg_hba.conf ? > > > > > > On Mar 12, 2007, at 12:25 AM, Kitty Yuen wrote: > > > > > > > Hi, > > > > > > > > I am trying to connect my postgreSQL with PHP in localhost. I have > > > > start up the server with -i flag ( i.e. postmaster -D > > > > /usr/local/pgsql/data -i &) and edit the pg_hba.conf. However, I > > > still > > > > cannot connect with the database. But, when I tried to remote acces= s > > > > the database through SSH and I can connect with it. > > > > > > > > Would you please offer any suggestions or solutions? > > > > > > > > Manythanks, > > > > Kitty3A > > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > TIP 2: Don't 'kill -9' the postmaster > > > > > > > > > > > -- > > > > ***********************************************************************= **** > > Ministerio de Planificaci=F3n y Desarrollo de la Rep=FAblica Bolivarian= a de > > Venezuela > > Direcci=F3n de Planes de Personal > > > > Jos=E9 Valent=EDn Orfila Brice=F1o > > Programador II > > > > Tel=E9fonos: Celular: (0416) 4131418 > > > > E-mail: valentinorfila@gmail.com > > valentinorfila@hotmail.com > > josevalentinorfila@yahoo.com > > > > Messenger: valentinorfila@hotmail.com > > > > Skype: valentinorfila > > valentinorfila@gmail.com > > ***********************************************************************= **** > > > > > > > -- > > *************************************************************************= ** > Ministerio de Planificaci=F3n y Desarrollo de la Rep=FAblica Bolivariana = de > Venezuela > Direcci=F3n de Planes de Personal > > Jos=E9 Valent=EDn Orfila Brice=F1o > Programador II > > Tel=E9fonos: Celular: (0416) 4131418 > > E-mail: valentinorfila@gmail.com > valentinorfila@hotmail.com > josevalentinorfila@yahoo.com > > Messenger: valentinorfila@hotmail.com > > Skype: valentinorfila > valentinorfila@gmail.com > *************************************************************************= ** > > --=20 *************************************************************************** Ministerio de Planificaci=F3n y Desarrollo de la Rep=FAblica Bolivariana de Venezuela Direcci=F3n de Planes de Personal Jos=E9 Valent=EDn Orfila Brice=F1o Programador II Tel=E9fonos: Celular: (0416) 4131418 E-mail: valentinorfila@gmail.com valentinorfila@hotmail.com josevalentinorfila@yahoo.com Messenger: valentinorfila@hotmail.com Skype: valentinorfila valentinorfila@gmail.com *************************************************************************** ------=_Part_33554_18530516.1173895619919 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Kitty,

Try try using this function: pg_pconnect(&= quot;host=3D$servidor dbname=3D$base user=3D$usuario password=3D$password&q= uot;);, I mean, use the connection script I'm going to paste below.
=
<?  /*---------------*/
    $se= rvidor =3D "localhost";
     $base =3D "databasename"; //change i= t
     $usuario =3D "postgresuser"; //chan= ge it
     $password =3D "postgresuserpa= ssword"; //change it
  
  = ;   pg_pconnect("host=3D$servidor dbname=3D$base user=3D$usu= ario password=3D$password");=20
  
?>



<= div>2007/3/12, Valent=EDn Orfila <valentinorfila@gmail.com>:<= blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 2= 04, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> here is the script again

<?  /*-----------= ----*/
    $servidor =3D "localhost";
     $base =3D "databasename"; //change i= t
     $usuario =3D "postgresuser"; //chan= ge it
     $password =3D "postgresuserpa= ssword"; //change it
  
  = ;   pg_pconnect("host=3D$servidor dbname=3D$base user=3D$usu= ario password=3D$password");=20
  
?>

2= 007/3/12, Valent=EDn Orfila <valentinorfila@gmail.com >:
Hi!!! I'm Venezuelan and I don't know how to speak english very wel= l, so excuse me if i make a mistake.

About the connection: Did you d= o your script by yourself?, or copied a functional one?

As Thomas Schindler said, send us any PHP errors or the pg_hba.conf ?
Here is my connection script, it is completly good check it out to se= e if you have anything wrong

<?  /*---------------*/
&nbs= p;   $servidor =3D "localhost";
     $base =3D "databasename"; //change i= t
     $usuario =3D "postgresuser"; //chan= ge it
     $password =3D "postgresuser"; /= /change it
  
     pg_pconnect("h= ost=3D$servidor dbname=3D$base user=3D$usuario password=3D$password");= =20
  
?>

That's all what I can do for now
<= br>
2007/3/12, Matthew Terenzio < matt@jobsforge.com>:
Could you provide any PHP errors or the pg_hba.conf ?

On Mar 12, 200= 7, at 12:25 AM, Kitty Yuen wrote:

> Hi,
>
> I am try= ing to connect my postgreSQL with PHP in localhost. I have
> start up= the server with -i flag ( i.e. postmaster -D
> /usr/local/pgsql/data -i &) and edit the pg_= hba.conf. However, I still
> cannot connect with the database. But, w= hen I tried to remote access
> the database through SSH and I can con= nect with it.
>
> Would you please offer any suggestions or solutions?
&= gt;
> Manythanks,
> Kitty3A


-----------------------= ----(end of broadcast)---------------------------
TIP 2: Don't '= kill -9' the postmaster



--
******= *********************************************************************
Mi= nisterio de Planificaci=F3n y Desarrollo de la Rep=FAblica Bolivariana de V= enezuela=20
Direcci=F3n de Planes de Personal

Jos=E9 Valent=EDn Orfila Brice=F1o
Programador II

Tel=E9= fonos: Celular: (0416) 4131418

E-mail: valentinorfila@gmail.com
       &= nbsp;   valentinorfila@hotmail.com
       = ;    joseva= lentinorfila@yahoo.com

Messenger: valentinorfila@hotmail.com

Skype: valentinorfila
        &n= bsp;  valentinorfila@gmail= .com
***************************************************************= ************



--
**********************************= *****************************************
Ministerio de Planificaci=F3n = y Desarrollo de la Rep=FAblica Bolivariana de Venezuela=20
Direcci=F3n de Planes de Personal

Jos=E9 Valent=EDn Orfila Brice=F1o
Programador II

Tel=E9= fonos: Celular: (0416) 4131418

E-mail: valentinorfila@gmail.com
       &= nbsp;   valentinorfila@hotmail.com
       = ;    joseva= lentinorfila@yahoo.com

Messenger: valentinorfila@hotmail.com

Skype: valentinorfila
        &n= bsp;  valentinorfila@gmail= .com
***************************************************************= ************



--
**********= *****************************************************************
Minist= erio de Planificaci=F3n y Desarrollo de la Rep=FAblica Bolivariana de Venez= uela=20
Direcci=F3n de Planes de Personal

Jos=E9 Valent=EDn Orfila Brice= =F1o
Programador II

Tel=E9fonos: Celular: (0416) 4131418

= E-mail: valentinorfila@gmail.co= m
           valentinorfila@hotmail.com
 &nb= sp;         josevalentinorfila@yahoo.com

Messenger:= valentinorfila@hotmail.com

Skype: valentinorfila
  =          valentinorfila@gmail.com
*************************= ************************************************** ------=_Part_33554_18530516.1173895619919--