From: Eckhard Hoeffner <e-hoeffner@fifoost.org>
To: pgsql-php@postgresql.org
Subject: Re: php-postgres-apache Security
Date: Sun, 19 May 2002 14:45:01 +0200
Message-ID: <20020519124501.GB11674@fifoost.org> (raw)
In-Reply-To: <20020519114355.66376.qmail@web12606.mail.yahoo.com>
References: <20020519114355.66376.qmail@web12606.mail.yahoo.com>
* ameen eetemadi <ameen78101@yahoo.com> [19 05 02 13:43]:
>I am writing php on a
>server(OS:linux,WebServer:apache) that other users can
>write cgi and have shell on it .
>I want to connect to a postgres server in my php file
>without asking username and password !
>then I must write the username and password in this
>file .
>Then other users can read it and drop my database .
>
>can I connect to the postgres through .php file
>without a security bog?
I think there are two possible solutions:
I
As far as I know the php-scripts are running under the User-ID of
the web server, for example "www-data" if you are using Debian.
So you can do the following:
1. Create a directory: mkdir /*/file/.
2. Write a file which includes for example just:
<?php
$db = pg_connect("dbname=db user=user host=host password=pass");
?>
then: => chmod to 400
=> chown to www-data
3. If you want to connect to the database, use in the php-script
require("/path/to/the/file/filename");
4. Make shure nobody else can get the user www-data.
II
You must limit the rights of the users for the db, for example make
shure, that you have something like
local all password
host public_db 127.0.0.1 255.255.255.0 password
local my_db reject
host my_db 192.168.1.12 255.255.255.0 crypt
in your pg_hba.conf.
--
--//--\\--
Eckhard Hoeffner
e-hoeffner@fifoost.org
Tal 44
D-80331 München
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: e-hoeffner@fifoost.org
Subject: Re: php-postgres-apache Security
In-Reply-To: <20020519124501.GB11674@fifoost.org>
References: <20020519114355.66376.qmail@web12606.mail.yahoo.com> <20020519124501.GB11674@fifoost.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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