Date: Tue, 9 Jan 2007 18:19:42 -0500 (EST) From: Dan Langille <dan@langille.org> To: FreeBSD-gnats-submit@FreeBSD.org Cc: Dan Langille <dan@langille.org> Subject: ports/107721: [MAINTAINER-UPDATE] sysutils/bacula-server upgrade fix database permissions Message-ID: <20070109231942.C0B233EC4@xeon.unixathome.org> Resent-Message-ID: <200701092320.l09NKARx095092@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 107721
>Category: ports
>Synopsis: [MAINTAINER-UPDATE] sysutils/bacula-server upgrade fix database permissions
>Confidential: no
>Severity: non-critical
>Priority: medium
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: maintainer-update
>Submitter-Id: current-users
>Arrival-Date: Tue Jan 09 23:20:10 GMT 2007
>Closed-Date:
>Last-Modified:
>Originator: Dan Langille
>Release: FreeBSD 4.9-STABLE i386
>Organization:
The FreeBSD Diary
>Environment:
System: FreeBSD xeon.unixathome.org 4.9-STABLE FreeBSD 4.9-STABLE #2: Wed Mar 3 08:16:24 EST 2004 dan@polo.unixathome.org:/usr/obj/usr/src/sys/XEON i386
>Description:
>How-To-Repeat:
>Fix:
Add some patches to upgrade scripts so that PostgreSQL database permissions
are correct. When upgrading and using PostgreSQL, be sure to run first the
update_postgresql_tables and then the grant_postgresql_privileges script.
These patches have been sent upstream, and are in CVS, but not yet released.
--- bacula-server.diff begins here ---
diff -ruN /usr/ports/sysutils/bacula-server/Makefile bacula-server/Makefile
--- /usr/ports/sysutils/bacula-server/Makefile Sat Jan 6 05:28:07 2007
+++ bacula-server/Makefile Tue Jan 9 17:50:55 2007
@@ -7,6 +7,7 @@
PORTNAME= bacula
DISTVERSION= 2.0.0
+PORTREVISION= 1
CATEGORIES= sysutils
MASTER_SITES= ${MASTER_SITE_SOURCEFORGE}
MASTER_SITE_SUBDIR= bacula
diff -ruN /usr/ports/sysutils/bacula-server/files/patch-src-cats-grant_postgresql_privileges.in bacula-server/files/patch-src-cats-grant_postgresql_privileges.in
--- /usr/ports/sysutils/bacula-server/files/patch-src-cats-grant_postgresql_privileges.in Wed Dec 31 19:00:00 1969
+++ bacula-server/files/patch-src-cats-grant_postgresql_privileges.in Tue Jan 9 17:52:06 2007
@@ -0,0 +1,28 @@
+Index: grant_postgresql_privileges.in
+===================================================================
+RCS file: /cvsroot/bacula/bacula/src/cats/grant_postgresql_privileges.in,v
+retrieving revision 1.9
+diff -u -b -r1.9 grant_postgresql_privileges.in
+--- src/cats/grant_postgresql_privileges.in 6 Nov 2005 18:04:08 -0000 1.9
++++ src/catsgrant_postgresql_privileges.in 9 Jan 2007 22:49:01 -0000
+@@ -28,6 +28,9 @@
+ grant all on storage to ${USER};
+ grant all on device to ${USER};
+ grant all on status to ${USER};
++grant all on location to ${USER};
++grant all on locationlog to ${USER};
++grant all on log to ${USER};
+
+ -- for sequences on those tables
+
+@@ -44,7 +47,9 @@
+ grant select, update on storage_storageid_seq to ${USER};
+ grant select, update on mediatype_mediatypeid_seq to ${USER};
+ grant select, update on device_deviceid_seq to ${USER};
+-
++grant select, update on location_locationid_seq to ${USER};
++grant select, update on locationlog_loclogid_seq to ${USER};
++grant select, update on log_logid_seq to ${USER};
+
+ END-OF-DATA
+ then
diff -ruN /usr/ports/sysutils/bacula-server/files/patch-src-cats-update_postgresql_tables.in bacula-server/files/patch-src-cats-update_postgresql_tables.in
--- /usr/ports/sysutils/bacula-server/files/patch-src-cats-update_postgresql_tables.in Wed Dec 31 19:00:00 1969
+++ bacula-server/files/patch-src-cats-update_postgresql_tables.in Tue Jan 9 17:52:16 2007
@@ -0,0 +1,20 @@
+Index: update_postgresql_tables.in
+===================================================================
+RCS file: /cvsroot/bacula/bacula/src/cats/update_postgresql_tables.in,v
+retrieving revision 1.30
+diff -u -b -r1.30 update_postgresql_tables.in
+--- src/cats/update_postgresql_tables.in 27 Jul 2006 01:58:42 -0000 1.30
++++ src/cats/update_postgresql_tables.in 9 Jan 2007 22:49:20 -0000
+@@ -1,10 +1,10 @@
+ #!/bin/sh
+ #
+-# Shell script to update PostgreSQL tables from version 1.38 to 1.39
++# Shell script to update PostgreSQL tables from version 1.38 to 2.0.0 or higher
+ #
+ echo " "
+ echo "This script will update a Bacula PostgreSQL database from version 9 to 10"
+-echo " which is needed to convert from Bacula version 1.38.x to 1.39.x or higher"
++echo " which is needed to convert from Bacula version 1.38.x to 2.0.0 or higher"
+ echo "Depending on the size of your database,"
+ echo "this script may take several minutes to run."
+ echo " "
--- bacula-server.diff ends here ---
>Release-Note:
>Audit-Trail:
>Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070109231942.C0B233EC4>