From pillesoft@yahoo.co.uk Mon Mar 18 15:20:25 2002 Received: from web14708.mail.yahoo.com (web14708.mail.yahoo.com [216.136.224.125]) by postgresql.org (Postfix) with SMTP id 2CCEF479033 for ; Mon, 18 Mar 2002 10:20:25 -0500 (EST) Message-ID: <20020318152029.68484.qmail@web14708.mail.yahoo.com> Received: from [195.228.79.33] by web14708.mail.yahoo.com via HTTP; Mon, 18 Mar 2002 07:20:29 PST Date: Mon, 18 Mar 2002 07:20:29 -0800 (PST) From: Ivan Horvath Subject: connecting from php To: pgslq-php MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200203/37 X-Sequence-Number: 1006 hi All, i set up in the pg_hba.conf file the md5 password encyption method for the client authentication. i try to connect to the database from another machine with the psql client tool - it is working. i try to connect with php script it is not working! please help me! Ivan ===== Best Regards, Ivan Horvath Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ __________________________________________________ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ From rhunter@enterasys.com Mon Mar 18 15:29:12 2002 Received: from ctron-dnm.ctron.com (ctron-dnm.enterasys.com [12.25.1.120]) by postgresql.org (Postfix) with ESMTP id 8E2DC476DC5 for ; Mon, 18 Mar 2002 10:29:12 -0500 (EST) Received: (from uucp@localhost) by ctron-dnm.ctron.com (8.8.7/8.8.7) id KAA15958; Mon, 18 Mar 2002 10:39:04 -0500 (EST) Received: from unknown(134.141.77.96) by ctron-dnm.ctron.com via smap (4.1) id xma015925; Mon, 18 Mar 02 10:38:30 -0500 Received: by cnc-exc1.enterasys.com with Internet Mail Service (5.5.2653.19) id ; Mon, 18 Mar 2002 10:27:04 -0500 Message-ID: <59358A738F45D51186A30008C74CE250E814E7@slc-exc1.ctron.com> From: "Hunter, Ray" To: "'Ivan Horvath'" , pgslq-php Subject: Re: connecting from php Date: Mon, 18 Mar 2002 10:27:57 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C1CE91.7B32EF80" X-Archive-Number: 200203/38 X-Sequence-Number: 1007 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C1CE91.7B32EF80 Content-Type: text/plain How are you trying to connect to postgres with php? Thank you, Ray Hunter Firmware Engineer ENTERASYS NETWORKS -----Original Message----- From: Ivan Horvath [mailto:pillesoft@yahoo.co.uk] Sent: Monday, March 18, 2002 8:20 AM To: pgslq-php Subject: [PHP] connecting from php hi All, i set up in the pg_hba.conf file the md5 password encyption method for the client authentication. i try to connect to the database from another machine with the psql client tool - it is working. i try to connect with php script it is not working! please help me! Ivan ===== Best Regards, Ivan Horvath Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ __________________________________________________ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster ------_=_NextPart_001_01C1CE91.7B32EF80 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: [PHP] connecting from php

How are you trying to connect to postgres with php?



Thank you,

Ray Hunter
Firmware Engineer

ENTERASYS NETWORKS


-----Original Message-----
From: Ivan Horvath [mailto:pillesoft@yahoo.co.uk]
Sent: Monday, March 18, 2002 8:20 AM
To: pgslq-php
Subject: [PHP] connecting from php


hi All,

i set up in the pg_hba.conf file the md5 password
encyption method for the client authentication.
i try to connect to the database from another machine
with the psql client tool - it is working.
i try to connect with php script it is not working!
please help me!

Ivan


=3D=3D=3D=3D=3D
Best Regards,

Ivan Horvath

Anyone who has never made a mistake has never tried anyth= ing new.

/Albert Einstein/

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/

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

------_=_NextPart_001_01C1CE91.7B32EF80-- From devrim@oper.metu.edu.tr Mon Mar 18 15:30:00 2002 Received: from oper.metu.edu.tr (oper.metu.edu.tr [144.122.201.20]) by postgresql.org (Postfix) with ESMTP id 929A847908D for ; Mon, 18 Mar 2002 10:30:00 -0500 (EST) Received: from localhost (devrim@localhost) by oper.metu.edu.tr (8.11.6/linuxconf) with ESMTP id g2IFTgg23365; Mon, 18 Mar 2002 17:29:42 +0200 Date: Mon, 18 Mar 2002 17:29:42 +0200 (EET) From: Devrim GUNDUZ To: Ivan Horvath Cc: pgslq-php Subject: Re: connecting from php In-Reply-To: <20020318152029.68484.qmail@web14708.mail.yahoo.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200203/39 X-Sequence-Number: 1008 Hi, If you paste the php line and error message that you are getting, we can easily help you. Otherwise, all we can do could be just guessing what is happening there.... Regards and best wishes, Devrim GUNDUZ devrim@oper.metu.edu.tr devrim.gunduz@linux.org.tr devrimg@tr.net Web : http://devrim.oper.metu.edu.tr ------------------------------------------------------------------ On Mon, 18 Mar 2002, Ivan Horvath wrote: > hi All, > > i set up in the pg_hba.conf file the md5 password > encyption method for the client authentication. > i try to connect to the database from another machine > with the psql client tool - it is working. > i try to connect with php script it is not working! > please help me! > > Ivan > > > ===== > Best Regards, > > Ivan Horvath > > Anyone who has never made a mistake has never tried anything new. > > /Albert Einstein/ > > __________________________________________________ > Do You Yahoo!? > Yahoo! Sports - live college hoops coverage > http://sports.yahoo.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > From pillesoft@yahoo.co.uk Mon Mar 18 15:36:06 2002 Received: from web14708.mail.yahoo.com (web14708.mail.yahoo.com [216.136.224.125]) by postgresql.org (Postfix) with SMTP id 6F13B476BB7 for ; Mon, 18 Mar 2002 10:36:06 -0500 (EST) Message-ID: <20020318153610.72251.qmail@web14708.mail.yahoo.com> Received: from [195.228.79.33] by web14708.mail.yahoo.com via HTTP; Mon, 18 Mar 2002 07:36:10 PST Date: Mon, 18 Mar 2002 07:36:10 -0800 (PST) From: Ivan Horvath Subject: Re: connecting from php To: Devrim GUNDUZ Cc: pgslq-php In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200203/40 X-Sequence-Number: 1009 thank you for the fast answer, here is the php code: $conn = pg_Connect("host=192.168.1.30 port=5432 dbname=PMS2500 user=web password=web"); here is the error message: Warning: Unable to connect to PostgreSQL server: fe_sendauth: authentication type 5 not supported in c:\program files\apache group\apache\htdocs\test\masodik.php on line 8 Ivan --- Devrim GUNDUZ wrote: > > Hi, > > If you paste the php line and error message that you > are getting, we can > easily help you. > > Otherwise, all we can do could be just guessing what > is happening > there.... > > Regards and best wishes, > > > Devrim GUNDUZ > > devrim@oper.metu.edu.tr > devrim.gunduz@linux.org.tr > devrimg@tr.net > > Web : http://devrim.oper.metu.edu.tr > ------------------------------------------------------------------ > > > On Mon, 18 Mar 2002, Ivan Horvath wrote: > > > hi All, > > > > i set up in the pg_hba.conf file the md5 password > > encyption method for the client authentication. > > i try to connect to the database from another > machine > > with the psql client tool - it is working. > > i try to connect with php script it is not > working! > > please help me! > > > > Ivan > > > > > > ===== > > Best Regards, > > > > Ivan Horvath > > > > Anyone who has never made a mistake has never > tried anything new. > > > > /Albert Einstein/ > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Sports - live college hoops coverage > > http://sports.yahoo.com/ > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > ===== Best Regards, Ivan Horvath Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ __________________________________________________ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ From devrim@oper.metu.edu.tr Mon Mar 25 16:13:38 2002 Received: from oper.metu.edu.tr (oper.metu.edu.tr [144.122.201.20]) by postgresql.org (Postfix) with ESMTP id 9ADD2475425 for ; Mon, 25 Mar 2002 11:13:38 -0500 (EST) Received: from localhost (devrim@localhost) by oper.metu.edu.tr (8.11.6/linuxconf) with ESMTP id g2PGDSW27309; Mon, 25 Mar 2002 18:13:28 +0200 Date: Mon, 25 Mar 2002 18:13:28 +0200 (EET) From: Devrim GUNDUZ To: Ivan Horvath Cc: pgslq-php Subject: Re: connecting from php In-Reply-To: <20020318153610.72251.qmail@web14708.mail.yahoo.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200203/45 X-Sequence-Number: 1014 Hi, This lines are taken from pg_hba.conf : # md5: Same as "password", but the password is encrypted while # being sent over the network. This method is preferable to # "password" except for pre-7.2 clients that don't support it. # NOTE: md5 can use usernames stored in secondary password # files but ignores passwords stored there. The pg_shadow # password will always be used. I mean, could it be you're not running earlier versions of PostgreSQL? Best regards, Devrim On Mon, 18 Mar 2002, Ivan Horvath wrote: > thank you for the fast answer, > > here is the php code: > $conn = pg_Connect("host=192.168.1.30 port=5432 > dbname=PMS2500 user=web password=web"); > > here is the error message: > Warning: Unable to connect to PostgreSQL server: > fe_sendauth: authentication type 5 not supported in > c:\program files\apache > group\apache\htdocs\test\masodik.php on line 8 > > Ivan > > --- Devrim GUNDUZ wrote: > > > > Hi, > > > > If you paste the php line and error message that you > > are getting, we can > > easily help you. > > > > Otherwise, all we can do could be just guessing what > > is happening > > there.... > > > > Regards and best wishes, > > > > > > Devrim GUNDUZ > > > > devrim@oper.metu.edu.tr > > devrim.gunduz@linux.org.tr > > devrimg@tr.net > > > > Web : http://devrim.oper.metu.edu.tr > > > ------------------------------------------------------------------ > > > > > > On Mon, 18 Mar 2002, Ivan Horvath wrote: > > > > > hi All, > > > > > > i set up in the pg_hba.conf file the md5 password > > > encyption method for the client authentication. > > > i try to connect to the database from another > > machine > > > with the psql client tool - it is working. > > > i try to connect with php script it is not > > working! > > > please help me! > > > > > > Ivan > > > > > > > > > ===== > > > Best Regards, > > > > > > Ivan Horvath > > > > > > Anyone who has never made a mistake has never > > tried anything new. > > > > > > /Albert Einstein/ > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Yahoo! Sports - live college hoops coverage > > > http://sports.yahoo.com/ > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > > TIP 4: Don't 'kill -9' the postmaster > > > > > > > > > > ===== > Best Regards, > > Ivan Horvath > > Anyone who has never made a mistake has never tried anything new. > > /Albert Einstein/ > > __________________________________________________ > Do You Yahoo!? > Yahoo! Sports - live college hoops coverage > http://sports.yahoo.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Devrim GUNDUZ devrim@oper.metu.edu.tr devrim.gunduz@linux.org.tr devrimg@tr.net Web : http://devrim.oper.metu.edu.tr ------------------------------------------------------------------ From pillesoft@yahoo.co.uk Tue Mar 26 08:52:00 2002 Received: from web14706.mail.yahoo.com (web14706.mail.yahoo.com [216.136.224.123]) by postgresql.org (Postfix) with SMTP id 628F447595E for ; Tue, 26 Mar 2002 03:52:00 -0500 (EST) Message-ID: <20020326085201.14627.qmail@web14706.mail.yahoo.com> Received: from [195.228.79.33] by web14706.mail.yahoo.com via HTTP; Tue, 26 Mar 2002 00:52:01 PST Date: Tue, 26 Mar 2002 00:52:01 -0800 (PST) From: Ivan Horvath Subject: Re: connecting from php To: Devrim GUNDUZ Cc: pgslq-php In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200203/46 X-Sequence-Number: 1015 Hi, i've checked it, i use exactly 7.2, but it is working with cygwin on w2k os. Ivan --- Devrim GUNDUZ wrote: > > Hi, > > This lines are taken from pg_hba.conf : > > # md5: Same as "password", but the password > is encrypted while > # being sent over the network. This > method is preferable to > # "password" except for pre-7.2 > clients that don't support it. > # NOTE: md5 can use usernames stored > in secondary password > # files but ignores passwords stored > there. The pg_shadow > # password will always be used. > > > I mean, could it be you're not running earlier > versions of PostgreSQL? > > Best regards, > Devrim > > On Mon, 18 Mar 2002, Ivan Horvath wrote: > > > thank you for the fast answer, > > > > here is the php code: > > $conn = pg_Connect("host=192.168.1.30 port=5432 > > dbname=PMS2500 user=web password=web"); > > > > here is the error message: > > Warning: Unable to connect to PostgreSQL server: > > fe_sendauth: authentication type 5 not supported > in > > c:\program files\apache > > group\apache\htdocs\test\masodik.php on line 8 > > > > Ivan > > > > --- Devrim GUNDUZ wrote: > > > > > > Hi, > > > > > > If you paste the php line and error message that > you > > > are getting, we can > > > easily help you. > > > > > > Otherwise, all we can do could be just guessing > what > > > is happening > > > there.... > > > > > > Regards and best wishes, > > > > > > > > > Devrim GUNDUZ > > > > > > devrim@oper.metu.edu.tr > > > devrim.gunduz@linux.org.tr > > > devrimg@tr.net > > > > > > Web : http://devrim.oper.metu.edu.tr > > > > > > ------------------------------------------------------------------ > > > > > > > > > On Mon, 18 Mar 2002, Ivan Horvath wrote: > > > > > > > hi All, > > > > > > > > i set up in the pg_hba.conf file the md5 > password > > > > encyption method for the client > authentication. > > > > i try to connect to the database from another > > > machine > > > > with the psql client tool - it is working. > > > > i try to connect with php script it is not > > > working! > > > > please help me! > > > > > > > > Ivan > > > > > > > > > > > > ===== > > > > Best Regards, > > > > > > > > Ivan Horvath > > > > > > > > Anyone who has never made a mistake has never > > > tried anything new. > > > > > > > > /Albert Einstein/ > > > > > > > > > __________________________________________________ > > > > Do You Yahoo!? > > > > Yahoo! Sports - live college hoops coverage > > > > http://sports.yahoo.com/ > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > > TIP 4: Don't 'kill -9' the postmaster > > > > > > > > > > > > > > > > ===== > > Best Regards, > > > > Ivan Horvath > > > > Anyone who has never made a mistake has never > tried anything new. > > > > /Albert Einstein/ > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Sports - live college hoops coverage > > http://sports.yahoo.com/ > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org > > > > -- > > Devrim GUNDUZ > > devrim@oper.metu.edu.tr > devrim.gunduz@linux.org.tr > devrimg@tr.net > > Web : http://devrim.oper.metu.edu.tr > ------------------------------------------------------------------ > > > > ===== Best Regards, Ivan Horvath Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ From miguel@ipatimup.pt Tue Mar 26 10:30:57 2002 Received: from mail.ipatimup.pt (peterpan.ipatimup.pt [194.65.114.74]) by postgresql.org (Postfix) with ESMTP id 99A6A474E4E for ; Tue, 26 Mar 2002 05:30:57 -0500 (EST) Received: from ipatimup.pt (localhost [127.0.0.1]) by mail.ipatimup.pt (8.11.6/8.11.6-IPATIMUP) with SMTP id g2QAKmU19923; Tue, 26 Mar 2002 10:20:48 GMT Received: from 213.13.176.13 (proxying for 10.20.110.136) (SquirrelMail authenticated user miguel) by www.ipatimup.pt with HTTP; Tue, 26 Mar 2002 10:20:48 -0000 (WET) Message-ID: <28880.213.13.176.13.1017138048.squirrel@www.ipatimup.pt> Date: Tue, 26 Mar 2002 10:20:48 -0000 (WET) Subject: Re: connecting from php From: "Miguel Carvalho" To: In-Reply-To: <20020326085201.14627.qmail@web14706.mail.yahoo.com> References: <20020326085201.14627.qmail@web14706.mail.yahoo.com> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal Cc: , Reply-To: miguel@ipatimup.pt X-Mailer: SquirrelMail (version 1.2.2) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200203/47 X-Sequence-Number: 1016 > Hi, > > i've checked it, i use exactly 7.2, but it is working > with cygwin on w2k os. I'm not shure, but i think that cygwin doesnt come with encription support....so md5, crypt, etc authentication methods will not work. Have installed postgresql from source or via RPM files? If a have said anything wrong, please correct me. Regards Miguel Carvalho From pillesoft@yahoo.co.uk Tue Mar 26 10:43:27 2002 Received: from web14703.mail.yahoo.com (web14703.mail.yahoo.com [216.136.224.120]) by postgresql.org (Postfix) with SMTP id 89B88474E4E for ; Tue, 26 Mar 2002 05:43:27 -0500 (EST) Message-ID: <20020326104329.68625.qmail@web14703.mail.yahoo.com> Received: from [195.228.79.33] by web14703.mail.yahoo.com via HTTP; Tue, 26 Mar 2002 02:43:29 PST Date: Tue, 26 Mar 2002 02:43:29 -0800 (PST) From: Ivan Horvath Subject: Re: connecting from php To: miguel@ipatimup.pt Cc: devrim@oper.metu.edu.tr, pgsql-php@postgresql.org In-Reply-To: <28880.213.13.176.13.1017138048.squirrel@www.ipatimup.pt> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200203/48 X-Sequence-Number: 1017 Hi, i've installed it from source Ivan --- Miguel Carvalho wrote: > > Hi, > > > > i've checked it, i use exactly 7.2, but it is > working > > with cygwin on w2k os. > > I'm not shure, but i think that cygwin doesnt come > with encription > support....so md5, crypt, etc authentication methods > will not work. > > Have installed postgresql from source or via RPM > files? > > If a have said anything wrong, please correct me. > > Regards > Miguel Carvalho > > ===== Best Regards, Ivan Horvath Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/