pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mariusz Pękala <skoot@qi.pl>
To: pgsql-php@postgresql.org
Subject: Re: Unable to connect to PostgreSQL Server: Permission denied
Date: Tue, 4 Apr 2006 23:26:32 +0200
Message-ID: <20060404212632.GA9480@cthulhu.sdi.tpnet.pl> (raw)
In-Reply-To: <20060404193510.A15256@vlo>
References: <20060403170611.19617.qmail@webmail47.rediffmail.com>
	<20060403200123.GB9357@cthulhu.sdi.tpnet.pl>
	<20060404193510.A15256@vlo>

On 2006-04-04 19:35:10 +0200 (Tue, Apr), Pawel Bernat wrote:
> On Mon, Apr 03, 2006 at 10:01:23PM +0200, Mariusz Pękala wrote:
> > Telnet is not the best tool for binary protocols.
> > You may try netcat (nc), but anyway - this test is not significant
> > here.
> It doesn't matter here.

Okay, you're saying my English isn't perfect ? :-)

> > Don't let the untrusted parameters to go into query. Someone may call
> > your page like this:
> > http://example.com/add-entry.php?Email=a';); delete from Addresses; --
> Nothing wrong will happen.

Why?
Unless I really overlooked something, I would humbly disagree.

1) It is possible to put a few sql requests in one string.

2) Relying on 'magic_quotes_gpc' and *possible* addslashes() is a bad thing,
IMHO.

So, where is my mistake?


-- 
No virus found in this outgoing message.
Checked by "grep -i virus $MESSAGE"
Trust me.

view thread (7+ messages)

Message-ID: <20060404212632.GA9480@cthulhu.sdi.tpnet.pl>
Permalink:  ../20060404212632.GA9480@cthulhu.sdi.tpnet.pl/
Also on:    postgresql.org/message-id/20060404212632.GA9480@cthulhu.sdi.tpnet.pl

 · 

reply

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: skoot@qi.pl
  Subject: Re: Unable to connect to PostgreSQL Server: Permission denied
  In-Reply-To: <20060404212632.GA9480@cthulhu.sdi.tpnet.pl>
  References: <20060403170611.19617.qmail@webmail47.rediffmail.com> <20060403200123.GB9357@cthulhu.sdi.tpnet.pl> <20060404193510.A15256@vlo> <20060404212632.GA9480@cthulhu.sdi.tpnet.pl>

* 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