> Davor Ocelic <[EMAIL PROTECTED]> wrote: > > On Mon, 5 Feb 2007 09:27:58 -0600 "Christopher D Clausen" > > <[EMAIL PROTECTED]> wrote: > >> Davor Ocelic <[EMAIL PROTECTED]> wrote: > >> > Adam, here are working mysql instructions: > >> > > >> > http://wiki.hcoop.net/wiki/DaemonAdmin/MySQL > >> > > >> > (The first part of it, which is appropriately marked, applies to > >> > both MySQL and Postgres).
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'. Please provide help in further troubleshooting. -doc _______________________________________________ HCoop-SysAdmin mailing list [email protected] http://hcoop.net/cgi-bin/mailman/listinfo/hcoop-sysadmin
