X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4437E53794 for ; Mon, 9 May 2005 16:30:43 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75507-07 for ; Mon, 9 May 2005 19:30:38 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 7FE5652A3D for ; Mon, 9 May 2005 16:30:36 -0300 (ADT) Received: (qmail 23879 invoked from network); 9 May 2005 19:30:36 -0000 Received: from w080.z064003242.bna-tn.dsl.cnc.net (HELO ?192.168.1.22?) (64.3.242.80) by 0 with SMTP; 9 May 2005 19:30:36 -0000 Mime-Version: 1.0 (Apple Message framework v622) Content-Transfer-Encoding: quoted-printable Message-Id: <9379c1a188ee92d15850274c61436ad3@sitening.com> Content-Type: text/plain; charset=WINDOWS-1252; format=flowed To: PGSQL Admin From: Thomas F.O'Connell Subject: Re: IMPORTANT: two new PostgreSQL security problems found Date: Mon, 9 May 2005 14:30:34 -0500 X-Mailer: Apple Mail (2.622) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/99 X-Sequence-Number: 17528 I put together a little Perl script (which assumes proper installation=20= of both DBI and DBD::Pg and that template1 exists) that takes care of=20 the character conversion vulnerability: http://www.sitening.com/postgresql-update-2005-1 I've run this on my development servers, and it seems to have had the=20 anticipated effect, but, as always, more eyeballs help. If anyone notes=20= any potential showstoppers, I'll gladly update the script. I don't have tsearch2 installed anywhere, so I didn't bother with that,=20= but this script could probably be easily modified to address that=20 vulnerability. -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i=99 http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005=