Davor Ocelic <[EMAIL PROTECTED]> wrote: > On Sat, 10 Feb 2007 17:37:13 -0600 > "Christopher D. Clausen" <[EMAIL PROTECTED]> wrote: >> Davor Ocelic <[EMAIL PROTECTED]> wrote: >>> I went ahead with Postgres setup. See >>> >>> http://wiki.hcoop.net/wiki/DaemonAdmin/PostgreSQL >>> >>> >>> I've modified /etc/init.d/postgresql-8.1 in the same way >>> we've done for mysql. >>> (which means: >>> - Added postgres/deleuze.hcoop.net principal >>> - Exported to /etc/keytabs/postgres.keytab >>> - Added AFS user postgres.deleuze.hcoop.net with membership >>> in group postgres and group databases. >>> - Modified /etc/init.d/postgresql-8.1 to invoke k5start using >>> appropriate user and pid file >>> ). >>> >>> Looking at the log files, user postgres does obtain ticket and afs >>> token. >>> >>> However, invoking the tablespace creation command (see wiki page) >>> fails in the following way: >>> >>> sudo -u postgres psql -c >>> "CREATE TABLESPACE user_docelic OWNER docelic LOCATION '$dir'" >>> template1 >>> >>> ERROR: could not set permissions on directory >>> "/afs/hcoop.net/common/databases/docelic/postgres": Permission >>> denied >>> >>> Stracing the postgres process shows the already-seen -EACCESS >>> error on the said directory. AFS permissions for the directory are >>> 'all'. >> >> Is this still an issue? > > Yes. Any help would be appreciated.
su to postgres. run "id" do you see two high numbered groups? (e.g. is there a PAG?) Does this work if you run the daemon with your tokens? Does postgres have any weird set(e)uid / set(e)gid functionality like apache? (I know even less about postgres than about mysql.) <<CDC _______________________________________________ HCoop-SysAdmin mailing list [email protected] http://hcoop.net/cgi-bin/mailman/listinfo/hcoop-sysadmin
