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