Thread: requiring a password to connect
Hi all,
I am using postgresql in conjunction with php. The following code works to
establish a database connection:
$db = pgConnect("dbname=mydb user=myuser");
I would prefer it if this would fail to connect. Is there a command line
switch I can use to start the postmaster that will require a password to be
passed in the connection string? Or do I need to recompile postgresql with
a particular option to achieve the desired behavior? I have experienced the
above on 6.5.3, 7.0.2 and 7.1.2.
Thank you very much for your time,
~c
obviously, i meant pg_Connect not pgConnect
+-----Original Message-----
+From: pgsql-novice-owner@postgresql.org
+[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of charlie derr
+Sent: Wednesday, June 27, 2001 7:45 AM
+To: pgsql-novice@postgresql.org
+Subject: [NOVICE] requiring a password to connect
+
+
+Hi all,
+
+ I am using postgresql in conjunction with php. The
+following code works to
+establish a database connection:
+
+$db = pgConnect("dbname=mydb user=myuser");
+
+
+ I would prefer it if this would fail to connect. Is there
+a command line
+switch I can use to start the postmaster that will require a password to be
+passed in the connection string? Or do I need to recompile postgresql with
+a particular option to achieve the desired behavior? I have
+experienced the
+above on 6.5.3, 7.0.2 and 7.1.2.
+
+ Thank you very much for your time,
+ ~c
+
+
+---------------------------(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
+
If i'm understanding you correctly (and I'm a newbie) you need to edit the
/data/pg_hba.conf file this is where you can set up your permissions to not
trust local connections.. (by default it is set up to trust local)
Travis
-----Original Message-----
From: charlie derr [mailto:wrong@crosswinds.net]
Sent: Wednesday, June 27, 2001 7:26 AM
To: pgsql-novice@postgresql.org
Subject: RE: [NOVICE] requiring a password to connect
obviously, i meant pg_Connect not pgConnect
+-----Original Message-----
+From: pgsql-novice-owner@postgresql.org
+[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of charlie derr
+Sent: Wednesday, June 27, 2001 7:45 AM
+To: pgsql-novice@postgresql.org
+Subject: [NOVICE] requiring a password to connect
+
+
+Hi all,
+
+ I am using postgresql in conjunction with php. The
+following code works to
+establish a database connection:
+
+$db = pgConnect("dbname=mydb user=myuser");
+
+
+ I would prefer it if this would fail to connect. Is there
+a command line
+switch I can use to start the postmaster that will require a password to be
+passed in the connection string? Or do I need to recompile postgresql with
+a particular option to achieve the desired behavior? I have
+experienced the
+above on 6.5.3, 7.0.2 and 7.1.2.
+
+ Thank you very much for your time,
+ ~c
+
+
+---------------------------(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
+
---------------------------(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
Hey,
Apart from the other suggestions, it might be that your web-server owner
has a user in pgsql, with no password. I doubt this is the case, but
thought I'd mention it anyway :)
> I am using postgresql in conjunction with php. The following
> code works to
>establish a database connection:
>
>$db = pgConnect("dbname=mydb user=myuser");
>
>
> I would prefer it if this would fail to connect. Is there a
> command line
>switch I can use to start the postmaster that will require a password to be
>passed in the connection string? Or do I need to recompile postgresql with
>a particular option to achieve the desired behavior? I have experienced the
>above on 6.5.3, 7.0.2 and 7.1.2.
>
> Thank you very much for your time,
> ~c
-----------------
Chris Smith
http://www.squiz.net/