what do I wrong???

This is a multi-part message in MIME format.

------=_NextPart_000_0008_01C2C3DA.6D803200
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

$conn_string =3D "host=3Dx.x.x.x port=3D5432 dbname=3Dxxxx user=3DCOMPAX pa=
ssword=3Dxxxx";
$connect =3D pg_connect($conn_string);

RESULT:

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

------=_NextPart_000_0008_01C2C3DA.6D803200
Content-Type: text/html;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

Re: what do I wrong???

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=20
postmaster with the -i option or is 'tcpip_tocket =3D true' in=20
postgresql.conf?

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

Matthew.

On Saturday, January 25, 2003, at 04:57 AM, Borsos J=F3zsef wrote:

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

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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

how to start with postgreSQL?

--0-88821889-1043797192=:20839
Content-Type: text/plain; charset=us-ascii


how can I do to create users, create a data base and make it work in postgreSQL? I can do it on mySQL but not in postgreSQL , they are not supossed to be the same? I have php 4 in mandrake 9 , and i'm doing local tests on my pc , but i don't have lan, i will apreciate the help of anyone who helps me.



---------------------------------
_root.paulSutcliffe;






---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
--0-88821889-1043797192=:20839
Content-Type: text/html; charset=us-ascii

how can I do to create users, create a data base and make it work in postgreSQL? I can do it on mySQL but not in postgreSQL , they are not supossed to be the same? I have php 4 in mandrake 9 , and i'm doing local tests on my pc , but i don't have lan, i will apreciate the help of anyone who helps me.

Re: how to start with postgreSQL?

On Tue, 28 Jan 2003, _root.paulSutcliffe wrote:

>
> how can I do to create users, create a data base and make it work in
> postgreSQL? I can do it on mySQL but not in postgreSQL , they are not
> supossed to be the same? I have php 4 in mandrake 9 , and i'm doing
> local tests on my pc , but i don't have lan, i will apreciate the help
> of anyone who helps me.

No, they're not the same, and sadly for your future database experiences,
this is one area in which most databases are not the same.

you'll need to take a quick tour of the administrators guide:

http://www.postgresql.org/docs/view.php?version=7.3&file=adm in.html

the quick skinny is that you can use the command line tools as the
postgres super user (su - to root, then su - to postgres) to create
databases and users to start.

createuser
createdb

should work.

but you really need to read the administrators guide a bit to get a feel
for the things you'll likely need to know.

We'll teach ya to fish, we won't fish for ya...


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: how to start with postgreSQL?

This is a multi-part message in MIME format.

------=_NextPart_000_0002_01C2C787.946A44E0
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit

No, they are not supposed to be the same. Use the 'createdb' and
'createuser' command-line programs to set it up. Or even read the manual...

Chris
-----Original Message-----
From: pgsql-php-owner@postgresql.org
[mailto:pgsql-php-owner@postgresql.org]On Behalf Of _root.paulSutcliffe
Sent: Wednesday, 29 January 2003 7:40 AM
To: pgsql-php@postgresql.org
Subject: [PHP] how to start with postgreSQL?


how can I do to create users, create a data base and make it work in
postgreSQL? I can do it on mySQL but not in postgreSQL , they are not
supossed to be the same? I have php 4 in mandrake 9 , and i'm doing local
tests on my pc , but i don't have lan, i will apreciate the help of anyone
who helps me.




------------------------------------------------------------ ----------------
--
_root.paulSutcliffe;







------------------------------------------------------------ ----------------
--
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

------=_NextPart_000_0002_01C2C787.946A44E0
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Re: how to start with postgreSQL?

My email is now catch all and do not know which one i used to subscribe to
this list. How do I ger unsubscribed?=0D
=0D
Randy


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: what do I wrong???

> 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


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

Re: what do I wrong???

This is a multi-part message in MIME format.

------=_NextPart_000_000B_01C2CDF0.733CBA40
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable


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


Hi Jozsef,

Ther is my code (db_connect.php):

//********************************************************** *************=
**********
// db_connect.php
//
// 1. Connect to the server
// 2. Connect to the database with the username=3Dpostgres and pw=3Dpo=
stgre$
//
//********************************************************** *************=
**********

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

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

if(!$serverconn)
{
echo "ERROR: Connection to Server failed!";
exit;
}

$dbconn =3Dpg_pconnect("dbname=3D$db user=3D$dbusername password=3D$dbuse=
rpw");

if(!$dbconn)
{
echo "ERROR: Connection to Database failed!";
exit;
}
?>


Borsos J=F3zsef wrote:

$conn_string =3D "host=3Dx.x.x.x port=3D5432 dbname=3Dxxxx user=3DCOMPA=
X password=3Dxxxx";
$connect =3D pg_connect($conn_string);

RESULT:

Warning: pg_connect() [function.pg-connect]: Unable to connect to Postg=
reSQL 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 Postgre=
SQL server: fe_sendauth: no password supplied . in C:\Inetpub\wwwroot\Borso=
s\db_connect.php on line 17
ERROR: Connection to Server failed!
------=_NextPart_000_000B_01C2CDF0.733CBA40
Content-Type: text/html;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable