http://mediawiki.ceinge.unina.it/index.php?action=history&feed=atom&title=biolocal%3AVeilbiolocal:Veil - Revision history2026-04-11T04:23:51ZRevision history for this page on the wikiMediaWiki 1.10.0http://mediawiki.ceinge.unina.it/index.php?title=biolocal:Veil&diff=1223&oldid=prevGianluca: Bioinfolocal:veil moved to biolocal:Veil: moving to the right namespace2008-02-18T10:55:15Z<p><a href="/index.php/Bioinfolocal:veil" title="Bioinfolocal:veil">Bioinfolocal:veil</a> moved to <a href="/index.php/biolocal:Veil" title="biolocal:Veil">biolocal:Veil</a>: moving to the right namespace</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:55, 18 February 2008</td>
</tr>
</table>Gianlucahttp://mediawiki.ceinge.unina.it/index.php?title=biolocal:Veil&diff=1182&oldid=prevGianluca: New page: 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 ...2008-02-15T10:26:29Z<p>New page: 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 ...</p>
<p><b>New page</b></p><div>Veil is a shared postgres library, used to introduce complex access control onto the DB.<br />
<br />
To install Veil on a RedHat based ditribution, be sure to have the devel package of your postgres installation:<br />
<pre><br />
yum update postgresql-devel<br />
</pre><br />
<br />
The base postgres RPMs will be installed in the following paths:<br />
<br />
<pre><br />
pgconfigdir=/var/lib/pgsql/data<br />
pgbindir=/usr/bin<br />
pgincludedir=/usr/include/pgsql<br />
pglibdir=/usr/lib<br />
pgsharedir=/usr/share<br />
</pre><br />
<br />
<br />
Download the Veil packet:<br />
<pre><br />
wget http://pgfoundry.org/frs/download.php/1601/Veil-0.9.6.tar.gz<br />
</pre><br />
<br />
<br />
Compile and install it:<br />
<pre><br />
cd /usr/local/src<br />
tar xvzf /downloadpath/Veil-0.9.6.tar.gz<br />
cd Veil-0.9.6<br />
./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<br />
make<br />
make install<br />
</pre><br />
<br />
<br />
Configure postgres server to load the new shared object:<br />
<pre><br />
vi /var/lib/pgsql/data/postgresql.conf<br />
</pre><br />
<br />
look for the shared_libriries directive and add the following:<br />
<pre><br />
shared_preload_libraries = 'veil.so'<br />
</pre><br />
<br />
Restart the postgres server.<br />
<br />
<br />
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.</div>Gianluca