ports/108832: [patch] Problem with phppgadmin and postgresql-8.1

[Henrik Brix Andersen]

>Number:         108832
>Category:       ports
>Synopsis:       [patch] Problem with phppgadmin and postgresql-8.1
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Tue Feb 06 14:20:20 GMT 2007
>Closed-Date:
>Last-Modified:
>Originator:     Henrik Brix Andersen
>Release:        FreeBSD 6.2-STABLE i386
>Organization:
pil.dk
>Environment:
System: FreeBSD fangorn.brixandersen.dk 6.2-STABLE FreeBSD 6.2-STABLE #41: Sat Jan 27 17:06:57 CET 2007 root at fangorn.brixandersen.dk:/usr/obj/usr/src/sys/FANGORN i386


	
>Description:
Version 4.1 of phpPgAdmin has a problem with PostgreSQL 8.1 as noted
in this upstream bug report:

http://www.nabble.com/--phppgadmin-Bugs-1625413---Error-during-login-t2902473.html

	
>How-To-Repeat:
Install PostgreSQL 8.1 and attempt to use phpPgAdmin 4.1 with configuration
"$conf['owned_only'] = true".

	
>Fix:
The upstream bug report contains a fix from upstream CVS - which I
have included below as a patch against the FreeBSD port of phpPgAdmin.

	

--- phppgadmin.diff begins here ---
diff -urpN /usr/ports/databases/phppgadmin/Makefile phppgadmin/Makefile
--- /usr/ports/databases/phppgadmin/Makefile	Fri Jan 26 07:17:57 2007
+++ phppgadmin/Makefile	Tue Feb  6 15:03:38 2007
@@ -7,6 +7,7 @@
 
 PORTNAME=	phppgadmin
 PORTVERSION=	4.1
+PORTREVISION=	1
 CATEGORIES=	databases www
 MASTER_SITES=	${MASTER_SITE_SOURCEFORGE_EXTENDED}
 MASTER_SITE_SUBDIR=	${PORTNAME}
diff -urpN /usr/ports/databases/phppgadmin/files/patch-classes-database-Postgres81.php phppgadmin/files/patch-classes-database-Postgres81.php
--- /usr/ports/databases/phppgadmin/files/patch-classes-database-Postgres81.php	Thu Jan  1 01:00:00 1970
+++ phppgadmin/files/patch-classes-database-Postgres81.php	Tue Feb  6 14:01:53 2007
@@ -0,0 +1,11 @@
+--- classes/database/Postgres81.php.orig	Tue Feb  6 14:00:38 2007
++++ classes/database/Postgres81.php	Tue Feb  6 14:01:02 2007
+@@ -83,7 +83,7 @@ class Postgres81 extends Postgres80 {
+ 		if (isset($conf['owned_only']) && $conf['owned_only'] && !$this->isSuperUser($server_info['username'])) {
+ 			$username = $server_info['username'];
+ 			$this->clean($username);
+-			$clause = " AND pu.usename='{$username}'";
++			$clause = " AND pr.rolname='{$username}'";
+ 		}
+ 		else $clause = '';
+ 
--- phppgadmin.diff ends here ---


>Release-Note:
>Audit-Trail:
>Unformatted: