pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedconnecting from php
8+ messages / 4 participants
[nested] [flat]
* connecting from php
@ 2002-03-18 15:20 Ivan Horvath <pillesoft@yahoo.co.uk>
0 siblings, 1 reply; 8+ messages in thread
From: Ivan Horvath @ 2002-03-18 15:20 UTC (permalink / raw)
To: pgsql-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/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: connecting from php
@ 2002-03-18 15:27 Hunter, Ray <rhunter@enterasys.com>
0 siblings, 0 replies; 8+ messages in thread
From: Hunter, Ray @ 2002-03-18 15:27 UTC (permalink / raw)
To: 'Ivan Horvath' <pillesoft@yahoo.co.uk>; pgsql-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
=====
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: connecting from php
@ 2002-03-18 15:29 Devrim GUNDUZ <devrim@oper.metu.edu.tr>
parent: Ivan Horvath <pillesoft@yahoo.co.uk>
0 siblings, 1 reply; 8+ messages in thread
From: Devrim GUNDUZ @ 2002-03-18 15:29 UTC (permalink / raw)
To: Ivan Horvath <pillesoft@yahoo.co.uk>; +Cc: pgsql-php
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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: connecting from php
@ 2002-03-18 15:36 Ivan Horvath <pillesoft@yahoo.co.uk>
parent: Devrim GUNDUZ <devrim@oper.metu.edu.tr>
0 siblings, 1 reply; 8+ messages in thread
From: Ivan Horvath @ 2002-03-18 15:36 UTC (permalink / raw)
To: Devrim GUNDUZ <devrim@oper.metu.edu.tr>; +Cc: pgsql-php
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 <devrim@oper.metu.edu.tr> 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/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: connecting from php
@ 2002-03-25 16:13 Devrim GUNDUZ <devrim@oper.metu.edu.tr>
parent: Ivan Horvath <pillesoft@yahoo.co.uk>
0 siblings, 1 reply; 8+ messages in thread
From: Devrim GUNDUZ @ 2002-03-25 16:13 UTC (permalink / raw)
To: Ivan Horvath <pillesoft@yahoo.co.uk>; +Cc: pgsql-php
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 <devrim@oper.metu.edu.tr> 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
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: connecting from php
@ 2002-03-26 08:52 Ivan Horvath <pillesoft@yahoo.co.uk>
parent: Devrim GUNDUZ <devrim@oper.metu.edu.tr>
0 siblings, 1 reply; 8+ messages in thread
From: Ivan Horvath @ 2002-03-26 08:52 UTC (permalink / raw)
To: Devrim GUNDUZ <devrim@oper.metu.edu.tr>; +Cc: pgsql-php
Hi,
i've checked it, i use exactly 7.2, but it is working
with cygwin on w2k os.
Ivan
--- Devrim GUNDUZ <devrim@oper.metu.edu.tr> 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 <devrim@oper.metu.edu.tr> 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/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: connecting from php
@ 2002-03-26 10:20 Miguel Carvalho <miguel@ipatimup.pt>
parent: Ivan Horvath <pillesoft@yahoo.co.uk>
0 siblings, 1 reply; 8+ messages in thread
From: Miguel Carvalho @ 2002-03-26 10:20 UTC (permalink / raw)
To: pillesoft@yahoo.co.uk; +Cc: devrim@oper.metu.edu.tr; pgsql-php
> 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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: connecting from php
@ 2002-03-26 10:43 Ivan Horvath <pillesoft@yahoo.co.uk>
parent: Miguel Carvalho <miguel@ipatimup.pt>
0 siblings, 0 replies; 8+ messages in thread
From: Ivan Horvath @ 2002-03-26 10:43 UTC (permalink / raw)
To: miguel@ipatimup.pt; +Cc: devrim@oper.metu.edu.tr; pgsql-php
Hi,
i've installed it from source
Ivan
--- Miguel Carvalho <miguel@ipatimup.pt> 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/
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2002-03-26 10:43 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-18 15:20 connecting from php Ivan Horvath <pillesoft@yahoo.co.uk>
2002-03-18 15:29 ` Devrim GUNDUZ <devrim@oper.metu.edu.tr>
2002-03-18 15:36 ` Ivan Horvath <pillesoft@yahoo.co.uk>
2002-03-25 16:13 ` Devrim GUNDUZ <devrim@oper.metu.edu.tr>
2002-03-26 08:52 ` Ivan Horvath <pillesoft@yahoo.co.uk>
2002-03-26 10:20 ` Miguel Carvalho <miguel@ipatimup.pt>
2002-03-26 10:43 ` Ivan Horvath <pillesoft@yahoo.co.uk>
2002-03-18 15:27 Re: connecting from php Hunter, Ray <rhunter@enterasys.com>
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