From owner-announce-jp@jp.FreeBSD.org Mon Jan  7 10:03:20 2002
Received: (from daemon@localhost)
	by castle.jp.FreeBSD.org (8.11.6+3.4W/8.11.3) id g0713KT54923;
	Mon, 7 Jan 2002 10:03:20 +0900 (JST)
	(envelope-from owner-announce-jp@jp.FreeBSD.org)
Date: Mon, 07 Jan 2002 00:57:32 +0900 (JST)
Message-Id: <20020107.005732.80887038.hrs@eos.ocn.ne.jp>
To: announce-jp@jp.FreeBSD.org
From: Hiroki Sato <hrs@eos.ocn.ne.jp>
In-Reply-To: <200201050104.g0514Xw93049@freefall.freebsd.org>
References: <200201050104.g0514Xw93049@freefall.freebsd.org>
X-Mailer: Mew version 2.1 on Emacs 20.7 / Mule 4.0 (HANANOEN)
Mime-Version: 1.0
Content-Type: Text/Plain; charset=iso-2022-jp
Content-Transfer-Encoding: 7bit
X-ML-maintainer: owner-announce-jp@jp.FreeBSD.org
Precedence: list
X-Distribute: distribute version 2.1 (Alpha) patchlevel 24e+011218
X-Sequence: announce-jp 892
Subject: Re: ANNOUNCE: FreeBSD Ports Security Advisory FreeBSD-SA-02:03.mod_auth_pgsql
Errors-To: owner-announce-jp@jp.FreeBSD.org
Sender: owner-announce-jp@jp.FreeBSD.org



FreeBSD $B%;%-%e%j%F%#4+9p(B $BF|K\8lHG(B
=============================================================================
FreeBSD-SA-02:03 (2002-01-04)
 * mod_auth_pgsql port authentication bypass
=============================================================================

 $B$3$N%a!<%k$O(B, announce-jp $B$KN.$l$?(B

  Subject: ANNOUNCE: FreeBSD Ports Security Advisory FreeBSD-SA-02:03.mod_auth_pgsql
  From: FreeBSD Security Advisories <security-advisories@FreeBSD.ORG>
  Date: Fri, 4 Jan 2002 17:04:33 -0800 (PST)
  Message-Id: <200201050104.g0514Xr93057@freefall.freebsd.org>
  X-Sequence: announce-jp 886

 $B$rF|K\8lLu$7$?$b$N$G$9(B. 

 $B86J8$O(B PGP $B=pL>$5$l$F$$$^$9$,(B, $B$3$NF|K\8lLu$O(B PGP $B=pL>$5$l$F$$$^$;$s(B. 
 $B=$@5%Q%C%AEy$NFbMF$,2~$6$s$5$l$F$$$J$$$3$H$r3NG'$9$k$?$a$K(B PGP $B=pL>$N(B
 $B%A%'%C%/$r9T$J$&$K$O(B, $B86J8$r;2>H$7$F$/$@$5$$(B. 

 $BF|K\8lLu$*$h$S(B, $B%_%i!<%5%$%HMxMQ$N>\:Y$K$D$$$F$O(B, $BJ8Kv$N!V(BA. FreeBSD
 $B%;%-%e%j%F%#4+9p(B $BF|K\8lHG$K$D$$$F!W$r$4Mw$/$@$5$$(B.


                                     [$BK]Lu<T(B: $B:4F#(B $B9-@8(B <hrs@jp.FreeBSD.org>]
--($B$3$3$+$i(B)
=============================================================================
FreeBSD-SA-02:03                                            Security Advisory
                                                                FreeBSD, Inc.

$B%H%T%C%/(B:	mod_auth_pgsql $B$N(B port $B$K$*$1$kG'>Z$N5!G=ITA4(B
                (mod_auth_pgsql port authentication bypass)

$BJ,N`(B:		ports
$B%b%8%e!<%k(B:	mod_auth_pgsql
$B9pCNF|(B:		2002-01-04
$B%/%l%8%C%H(B:	RUS CERT <URL:http://cert.uni-stuttgart.de/>
$B1F6AHO0O(B:	$B=$@5F|0JA0$N(B Ports Collection
$B=$@5F|(B:		2001-10-02 11:33:49 UTC
FreeBSD $B$K8GM-$+(B:	NO


I.   $BGX7J(B - Background

mod_auth_pgsql $B$O(B, Apache $B%&%'%V%5!<%P$K$*$$$F%f!<%6$d%0%k!<%W$NG'>Z$K(B
PostgreSQL $B%G!<%?%Y!<%9$rMxMQ$G$-$k$h$&$K$9$k$?$a$N(B Apache $B%b%8%e!<%k$G$9(B.


II.  $BLdBj$N>\:Y(B - Problem Description

mod_auth_pgsql $B$N(B port $B$N(B mod_auth_pgsql-0.9.9 $B$h$jA0$N%P!<%8%g%s$K$O(B,
$B%j%b!<%H%f!<%6$,G$0U$N(B SQL $B%3!<%I$r<B9T$G$-$k$H$$$&%;%-%e%j%F%#>e$N(B
$B<eE@$,4^$^$l$F$$$^$9(B.  mod_auth_pgsql $B$O(B, PostgreSQL $B%5!<%P$G<B9T$5$l$k(B
$B%f!<%6>pJs$r8!:w$9$k$?$a$N(B SQL $B<B9TJ8$r9=@.$9$k$N$G$9$,(B,
$B%j%b!<%H%f!<%6$K$h$C$F;XDj$5$l$?%f!<%6L>$O(B, $B0BA4@-$N8!::$r(B
$B$^$C$?$/<u$1$:$K$=$N$^$^(B SQL $B<B9TJ8$KA^F~$5$l$F$7$^$C$F$$$^$9(B.

mod_auth_pgsql $B$N(B port $B$O%G%U%)%k%H$G%$%s%9%H!<%k$5$l$k$b$N$G$O$J$/(B,
$B!V(BFreeBSD $B%7%9%F%`$N0lIt!W$r9=@.$9$k$b$N$G$b$"$j$^$;$s(B.
$B$=$l$i$O(B 6000 $B$r1[$($k%5!<%I%Q!<%F%#@=%"%W%j%1!<%7%g%s$,$9$0$K(B
$B%$%s%9%H!<%k$G$-$k7A$G<}$a$i$l$F$$$k(B FreeBSD Ports Collection $B$N0lIt$G$9(B.
$B$3$NLdBj$O(B FreeBSD 4.4 $B$N%j%j!<%98e$KH/8+!&=$@5$5$l$?$?$a(B,
FreeBSD 4.4 $B$K$O$3$NLdBj$K$h$k%;%-%e%j%F%#>e$N<eE@$,4^$^$l$F$$$^$9(B.

FreeBSD $B$G$O(B, $B$3$N$h$&$J%5!<%I%Q!<%F%#@=%"%W%j%1!<%7%g%s$N%;%-%e%j%F%#(B
$BLdBj$KBP$7$F(B, $BFC$K2?$+$r<gD%$9$k$3$H$O$"$j$^$;$s(B ($BLuCm(B: Ports Collection $B$K(B
$BF~$C$F$$$k$+$i$H$$$C$F(B, FreeBSD $B$N3+H/<T$?$A$,$=$N%"%W%j%1!<%7%g%s$,(B
$B0BA4$G$"$k$HI>2A$7$?$o$1$G$O$"$j$^$;$s(B).  $B$?$@$7(B, $B%;%-%e%j%F%#LdBj$KBP$7$F(B
$BBg$-$J1F6A$r;}$D$h$&$J(B ports $B$KBP$9$k%;%-%e%j%F%#4F::$rDs6!$9$Y$/(B,
$B8=:_EXNOCf$G$9(B.


III. $B1F6AHO0O(B - Impact

$B%j%b!<%H$N%f!<%6$OG'>Z$N:]$K%f!<%6L>ItJ,$KG$0U$N(B SQL $B%3!<%I$rA^F~$7(B,
$B$3$N%;%-%e%j%F%#>e$N<eE@$r0-MQ$G$-$k4m81@-$,$"$j$^$9(B.  $BFC$K(B, $B967b<T$,(B
mod_auth_pgsql $B$KBP$7$F(B, $B%f!<%6G'>Z$K8GDj$N%Q%9%o!<%I%O%C%7%e$r;H$o$;$k(B
$B$3$H$,$G$-$k2DG=@-$,$"$j$^$9(B.  $B$3$l$K$h$j(B, $B3F%f!<%6$9$Y$F$KBP$9$kG'>Z$r(B
$BDL2a$7$F%&%'%V%5!<%P$N%G!<%?$rIT@5$K%"%/%;%9$9$k$3$H$,2DG=$G$9(B.


IV.  $B2sHrJ}K!(B - Workaround

1) mod_auth_pgsql $B$N(B port/package $B$,%$%s%9%H!<%k$5$l$F$$$k>l9g$O(B,
   $B$=$l$r%7%9%F%`$+$i:o=|$7$^$9(B.


V.   $B2r7h:v(B - Solution

1) Ports Collection $BA4BN$r%"%C%W%0%l!<%I$7(B mod_auth_pgsql $B$N(B port $B$r:F9=C[$9$k(B.

2) $B8E$$(B ($BLuCm(B: mod_auth_pgsql $B$N(B) package $B$r%7%9%F%`$+$i:o=|$7(B,
   $B=$@5F|0J9_$K:n@.$5$l$??7$7$$(B package $B$r0J2<$N>l=j$+$i(B
   $B<hF@$7$F%$%s%9%H!<%k$9$k(B.

[i386]
ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/i386/packages-4-stable/www/mod_auth_pgsql-0.9.9.tgz
ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/i386/packages-5-current/www/mod_auth_pgsql-0.9.9.tgz

[alpha]
$B8=;~E@$G$O(B alpha $B%"!<%-%F%/%A%cMQ$N(B package $B$O<+F0@8@.$5$l$F$$$^$;$s(B.
$B$3$l$O(B, $B9=C[$N$?$a$N%^%7%s%j%=!<%9$,ITB-$7$F$$$k$?$a$G$9(B.

3) mod_auth_pgsql $B$N?7$7$$(B port $B%9%1%k%H%s$r0J2<$N>l=j$+$i%@%&%s%m!<%I$7(B,
   $B$=$l$r;H$C$F(B port $B$r:F9=C[$9$k(B.

http://www.freebsd.org/ports/

4) $B>e5-(B (3) $B$NA`:n$r<+F0E*$K9T$J$&(B portcheckout $B%f!<%F%#%j%F%#$r;H$&(B.
   portcheckout $B$N(B port $B$O(B /usr/ports/devel/portcheckout $B$K$"$j$^$9(B.
   $B$^$?(B, portcheckout $B$N(B package $B$,0J2<$N>l=j$+$iF~<j2DG=$G$9(B.

ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/i386/packages-4-stable/devel/portcheckout-2.0.tgz
ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/i386/packages-5-current/devel/portcheckout-2.0.tgz


VI.  $B=$@5$N>\:Y(B - Correction details

$B<!$NI=$O(B, $B:#2s=$@5$5$l$?(B FreeBSD $B$N%=!<%9%U%!%$%k$N(B
$FreeBSD$ $B%j%S%8%g%sHV9f$G$9(B.

$B%Q%9L>(B                                                       $B%j%S%8%g%sHV9f(B
- -------------------------------------------------------------------------
ports/www/mod_auth_pgsql/Makefile                                     1.3
ports/www/mod_auth_pgsql/distinfo                                     1.2
- -------------------------------------------------------------------------


VII. $B;29M;qNA(B - References

<URL:http://cert.uni-stuttgart.de/advisories/apache_auth.php>


A.   FreeBSD $B%;%-%e%j%F%#4+9p(B $BF|K\8lHG$K$D$$$F(B

$BF|K\8lLu$O(B FreeBSD $BF|K\8l%I%-%e%a%s%F!<%7%g%s%W%m%8%'%/%H(B (doc-jp) $B$,(B
$B;29M$N$?$a$KDs6!$9$k$b$N$G$9(B.  $B2a5n$NF|K\8lHG%;%-%e%j%F%#4+9p$O(B

 http://www.FreeBSD.org/ja/security/

$B$K$^$H$a$i$l$F$$$^$9(B.  

$B$?$@$7(B, $BK]Lu<T$*$h$S(B doc-jp $B$O(B, $B$=$NFbMF$K$D$$$F$$$+$J$kJ]>Z$b(B
$B$$$?$7$^$;$s$N$G$4Cm0U$/$@$5$$(B.  $BF|K\8lLu$K$D$$$F$N$40U8+(B, $B$4MWK>(B,
$B$*Ld$$9g$o$;Ey$O(B doc-jp@jp.FreeBSD.org $B$^$G$*4j$$$7$^$9(B.

$B$3$N4+9p$NCf$G>R2p$5$l$F$$$k(B WWW $B%5%$%H(B http://www.FreeBSD.org/ $B$*$h$S(B
FTP $B%5%$%H(B ftp://ftp.FreeBSD.org/ $B$K$O(B, $BF|K\$N%_%i!<%5%$%H$,B8:_$7$^$9(B.
$B%M%C%H%o!<%/$N:.;($r4KOB$9$k$?$a(B, $B$^$:$O%_%i!<%5%$%H$NMxMQ$r(B
$B9MN8$9$k$h$&$*4j$$$7$^$9(B.

$BF|K\$N%_%i!<%5%$%H$rMxMQ$9$k$K$O(B,
http://www.FreeBSD.org/ $B$r(B http://www.jp.FreeBSD.org/www.freebsd.org/ $B$K(B,
ftp://ftp.FreeBSD.org/ $B$r(B ftp://ftp.jp.FreeBSD.org/ $B$K(B,
$B$=$l$>$lCV$-49$($F$/$@$5$$(B.

$BB>$NCO0h$r4^$`(B, $B%_%i!<%5%$%H$K4X$9$k>\:Y$O(B,

 http://www.FreeBSD.org/handbook/mirror.html ($B1QJ8(B)
 http://www.FreeBSD.org/ja/handbook/mirror.html ($BF|K\8lLu(B)

$B$K$^$H$a$i$l$F$$$^$9(B.

