Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B03D847669F for ; Wed, 16 Oct 2002 15:53:11 -0400 (EDT) Received: from mailout02.sul.t-online.com (mailout02.sul.t-online.com [194.25.134.17]) by postgresql.org (Postfix) with ESMTP id 7E7814763D2 for ; Wed, 16 Oct 2002 15:53:10 -0400 (EDT) Received: from fwd11.sul.t-online.de by mailout02.sul.t-online.com with smtp id 181uEA-0008Qv-04; Wed, 16 Oct 2002 21:53:10 +0200 Received: from fraxinus.reticulum (520013531845-0001@[217.85.8.55]) by fmrl11.sul.t-online.com with esmtp id 181uE0-1L17RoC; Wed, 16 Oct 2002 21:53:00 +0200 Received: from ks by fraxinus.reticulum with local (Exim 3.35 #1 (Debian)) id 181u46-0000Eu-00 for ; Wed, 16 Oct 2002 21:42:46 +0200 Date: Wed, 16 Oct 2002 21:42:46 +0200 From: knut.suebert@web.de To: PGSQL Subject: SQL-injection attack? (Re: Help with urlencode and rawurlencode) Message-ID: <20021016194246.GB833@fraxinus.reticulum> References: <034A824BAA3FBA4CA0CBEF1031A02F3519F1FE@zablv02001.vodacom.corp> <3DAAEEDA.C9FC89C6@postgresql.org> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-15 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3DAAEEDA.C9FC89C6@postgresql.org> User-Agent: Mutt/1.4i X-No-Archive: yes X-Sender: 520013531845-0001@t-dialin.net X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/40 X-Sequence-Number: 1555 Justin Clift schrieb: > "Duncan Adams (DNS)" wrote: > > > ......host_table.hostname ilike \'%omc%\' order by.... > > on the next page. > > It sounds like you have the PHP variable "magic_quotes_gpc" set On in > your "php.ini" configuration file. If you turn this off (can't remember > if it's possible with a function) then it will probably fix your > problem. Had the same problem here a few minutes ago. If you don't want to turn off magic_quotes_gpc globally (for most things it is very useful, IMHO), try "stripslashes()" for problematic strings. I'm not sure, but stripping slashes could offer a possibility of inserting "SQL-injection" attacks. Think about "'; delete from table xyz; select '" typed into a search field. More complicated queries to get the table names of a db could be possible. Maybe it helps, if queries containing a ";" are rejected. Knut Sübert