diff options
| author | Ion-Mihai Tetcu <itetcu@FreeBSD.org> | 2007-01-10 00:11:24 +0000 |
|---|---|---|
| committer | Ion-Mihai Tetcu <itetcu@FreeBSD.org> | 2007-01-10 00:11:24 +0000 |
| commit | 66f90343a0acfea7819f7058c26c6d8a20a83237 (patch) | |
| tree | 2601b8761b8f7ada442831ef5b68208dbdd07148 /sysutils | |
| parent | 38331eb4a834e1068c876a0d0f1d5232d5148371 (diff) | |
| download | ports-66f90343a0acfea7819f7058c26c6d8a20a83237.tar.gz ports-66f90343a0acfea7819f7058c26c6d8a20a83237.zip | |
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.
Bump PORTREVISION.
PR: 107721
Submitted by: Dan Langille (maintainer)
Notes
Notes:
svn path=/head/; revision=181934
Diffstat (limited to 'sysutils')
| -rw-r--r-- | sysutils/bacula-server/Makefile | 1 | ||||
| -rw-r--r-- | sysutils/bacula-server/files/patch-src-cats-grant_postgresql_privileges.in | 28 |
2 files changed, 29 insertions, 0 deletions
diff --git a/sysutils/bacula-server/Makefile b/sysutils/bacula-server/Makefile index 85b99421fbd1..d1c14e07230c 100644 --- a/sysutils/bacula-server/Makefile +++ b/sysutils/bacula-server/Makefile @@ -7,6 +7,7 @@ PORTNAME= bacula DISTVERSION= 2.0.0 +PORTREVISION= 1 CATEGORIES= sysutils MASTER_SITES= ${MASTER_SITE_SOURCEFORGE} MASTER_SITE_SUBDIR= bacula diff --git a/sysutils/bacula-server/files/patch-src-cats-grant_postgresql_privileges.in b/sysutils/bacula-server/files/patch-src-cats-grant_postgresql_privileges.in new file mode 100644 index 000000000000..286482cdbb2e --- /dev/null +++ b/sysutils/bacula-server/files/patch-src-cats-grant_postgresql_privileges.in @@ -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 |