pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
what do I wrong???
4+ messages / 3 participants
[nested] [flat]

* what do I wrong???
@ 2003-01-24 17:57 Borsos József <pgsql-php@borsos.hu>
  2003-01-28 04:19 ` Re: what do I wrong??? Matthew Horoschun <mhoroschun@canprint.com.au>
  2003-02-06 14:00 ` Re: what do I wrong??? Borsos József <pgsql-php@Borsos.hu>
  0 siblings, 2 replies; 4+ messages in thread

From: Borsos József @ 2003-01-24 17:57 UTC (permalink / raw)
  To: pgsql-php

$conn_string = "host=x.x.x.x port=5432 dbname=xxxx user=COMPAX password=xxxx";
  $connect = pg_connect($conn_string);

RESULT:

Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: Password authentication failed for user 'COMPAX' . in xxx on line 4

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: what do I wrong???
  2003-01-24 17:57 what do I wrong??? Borsos József <pgsql-php@borsos.hu>
@ 2003-01-28 04:19 ` Matthew Horoschun <mhoroschun@canprint.com.au>
  1 sibling, 0 replies; 4+ messages in thread

From: Matthew Horoschun @ 2003-01-28 04:19 UTC (permalink / raw)
  To: Borsos József <pgsql-php@borsos.hu>; +Cc: pgsql-php

Hi Borsos,

Could be a lot of different things.

1. What does pg_hba.conf contain?

2. You appear to be connecting using TCP/IP. Have you started 
postmaster with the -i option or is 'tcpip_tocket = true' in 
postgresql.conf?

3. Can you connect using the same host, port, dbname, user and password 
using the psql command-line client?

Matthew.

On Saturday, January 25, 2003, at 04:57  AM, Borsos József wrote:

> $conn_string = "host=x.x.x.x port=5432 dbname=xxxx user=COMPAX 
> password=xxxx";
>   $connect = pg_connect($conn_string);
>  
> RESULT:
>  
> Warning: pg_connect() [function.pg-connect]: Unable to connect to 
> PostgreSQL server: Password authentication failed for user 'COMPAX' . 
> in xxx on line 4
>

--
Matthew Horoschun
Network Administrator
CanPrint Communications Pty. Ltd.




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: what do I wrong???
  2003-01-24 17:57 what do I wrong??? Borsos József <pgsql-php@borsos.hu>
@ 2003-02-06 14:00 ` Borsos József <pgsql-php@Borsos.hu>
  1 sibling, 0 replies; 4+ messages in thread

From: Borsos József @ 2003-02-06 14:00 UTC (permalink / raw)
  To: Mileta Vinerte <mvinerte@cbnco.com>; +Cc: pgsql-php


  ----- Original Message ----- 
  From: Mileta Vinerte 
  To: Borsos József 
  Sent: Tuesday, January 28, 2003 3:04 PM
  Subject: Re: [PHP] what do I wrong???


  Hi Jozsef,

  Ther is my code  (db_connect.php):

  <?php
  //*********************************************************************************
  //       db_connect.php
  //
  //      1. Connect to the server
  //    2. Connect to the database with the username=postgres and pw=postgre$
  //
  //*********************************************************************************

  $server="172.30.30.27";
  $port="5432";
  $db="doors";
  $dbusername="postgres";
  $dbuserpw="postgre$";

  //connect to server
  $serverconn =pg_Connect($server, $port,$db);

      if(!$serverconn)
          {
          echo "ERROR: Connection to Server failed!";
          exit;
          }
          
  $dbconn =pg_pconnect("dbname=$db user=$dbusername password=$dbuserpw");
          
          if(!$dbconn)
          {
          echo "ERROR: Connection to Database failed!";
          exit;
          }
  ?>        


  Borsos József wrote:

    $conn_string = "host=x.x.x.x port=5432 dbname=xxxx user=COMPAX password=xxxx";
      $connect = pg_connect($conn_string);

    RESULT:

    Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: Password authentication failed for user 'COMPAX' . in xxx on line 4



  Thanks for helping, but this is the answer:

  Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: fe_sendauth: no password supplied . in C:\Inetpub\wwwroot\Borsos\db_connect.php on line 17
  ERROR: Connection to Server failed!

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: what do I wrong???
@ 2003-02-03 14:30 Matthew Horoschun <mhoroschun@canprint.com.au>
  0 siblings, 0 replies; 4+ messages in thread

From: Matthew Horoschun @ 2003-02-03 14:30 UTC (permalink / raw)
  To: Borsos József <pgsql-php@Borsos.hu>; +Cc: pgsql-php


> Thank You for answer.
>
> 1. and 2. I don't no, becouse I'm not administrator on server. 
> PostgreSQL
> server 7.1 and RedHut Linux x.xx
> 3. Yes when I connet to the server with SSH client PuTTY for windows.
>
> My Web server run on Win2000, and PHP code is on IIS 5.0 server. I 
> mean it
> is a problem with crypt() routine.


It would be a good idea to contact your system administrator and ask 
them 1 and 2, otherwise you'll be wasting your time with trial and 
error.

Alternatively, if you have SSH access to the machine then you could try 
working both out for yourself (do a process listing, see if you have 
read access to postgresql.conf and pg_hba.conf)

How do you know its a problem with the crypt() routine? I can't see how 
that could be related, unless I'm missing something significant.

Matthew.


--
Matthew Horoschun
Network Administrator
CanPrint Communications Pty. Ltd.

Mobile:		0417 282 378
Direct:		(02) 6295 4544
Telephone:	(02) 6295 4422
Facsimile: 	(02) 6295 4473




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2003-02-06 14:00 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-24 17:57 what do I wrong??? Borsos József <pgsql-php@borsos.hu>
2003-01-28 04:19 ` Matthew Horoschun <mhoroschun@canprint.com.au>
2003-02-06 14:00 ` Borsos József <pgsql-php@Borsos.hu>
2003-02-03 14:30 Re: what do I wrong??? Matthew Horoschun <mhoroschun@canprint.com.au>

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