biolocal:Veil

From Wiki CEINGE

Jump to: navigation, search

Veil is a shared postgres library, used to introduce complex access control onto the DB.

To install Veil on a RedHat based ditribution, be sure to have the devel package of your postgres installation: 

yum update postgresql-devel

The base postgres RPMs will be installed in the following paths: 

pgconfigdir=/var/lib/pgsql/data
pgbindir=/usr/bin
pgincludedir=/usr/include/pgsql
pglibdir=/usr/lib
pgsharedir=/usr/share


Download the Veil packet: 

wget http://pgfoundry.org/frs/download.php/1601/Veil-0.9.6.tar.gz


Compile and install it: 

cd /usr/local/src
tar xvzf /downloadpath/Veil-0.9.6.tar.gz
cd Veil-0.9.6
./configure --prefix=/usr --with-pgconfigdir=/var/lib/pgsql/data --with-pgbindir=/usr/bin \ --with-pgincludedir=/usr/include/pgsql --with-pglibdir=/usr/lib --with-pgsharedir=/usr/share
make
make install


Configure postgres server to load the new shared object: 

vi /var/lib/pgsql/data/postgresql.conf

look for the shared_libriries directive and add the following: 

shared_preload_libraries = 'veil.so'

Restart the postgres server.


For other OSs or postgres installation not based on binary packets, the procedure is very similar; just pay attention to set the correct postgres paths in the configure command.

Retrieved from "http://mediawiki.ceinge.unina.it/index.php/biolocal:Veil"
Personal tools