Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Installing iHub with existing Postgres server
tokorhon
<p>Hello!</p>
<p> </p>
<p>I'm trying to install iHub on a Windows7 (64-bit) machine, but the installation fails probably because there is already a running Postgres server instance on this machine.</p>
<p> </p>
<p>setupiHub.log says:</p>
<pre class="_prettyXprint">
setupootbpg:
[echo] Starting setup OOTB PostgreSQL database.
init.ootbpg:
[echo] Initializing PostgreSQL for Actuate.
initpostgresql:
setenv:
format.system.name:
[exec] The files belonging to this database system will be owned by user "myusername".
[exec] This user must also own the server process.
[exec]
[exec] The database cluster will be initialized with locale "English_United States.1252".
[exec] The default text search configuration will be set to "english".
[exec]
[exec] creating directory C:/Actuate3/modules/BIRTiHub/iHub/data/postgresql/data ... initdb: could not create directory "C:/Actuate3/modules/BIRTiHub/iHub/data/postgresql": Permission denied
[exec] Result: 1
BUILD FAILED</pre>
<p>How can I set iHub to use the already installed Postgres?</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
Find more posts tagged with
Comments
Clement Wong
<p>The iHub can co-exist with a previously installed PostgreSQL server. The one that comes with the iHub is a low profile one used to manage the meta-data of the iHub volume.</p>
<p> </p>
<p>Thank you for including the setup log. Regarding the error message "<span>creating directory C</span><span>:</span><span>/Actuate3/</span><span>modules</span><span>/</span><span>BIRTiHub</span><span>/</span><span>iHub</span><span>/</span><span>data</span><span>/</span><span>postgresql</span><span>/</span><span>data </span><span>...</span><span> initdb</span><span>:</span><span> could </span><span>not</span><span> create directory </span><span>"C:/Actuate3/modules/BIRTiHub/iHub/data/postgresql"</span><span>:</span><span> </span><span>Permission</span><span> denied", what Windows user are you installing the iHub? Is the user an administrator, or is part of the Administrator group? A workaround would be to create an C:\Actuate3 folder, and explicitly assign read/write access to the user you are installing and have it propagate recursively, before you run the install .exe.</span></p>
<p> </p>
<p>Should you require additional assistance, we can have a local Support Engineer contact you. Please PM me with your contact information and which country you reside in.</p>
tokorhon
<p>Thank you for your answer! I was able to setup iHub by creating directory "<span>C:/Actuate3/modules/BIRTiHub/iHub/data/postgresql" manually and setting enough permissions for it.</span></p>
<p> </p>
<p><span>Does iHub always use internal Postgres or can I use a company's Postgres server as metadata database?</span></p>
Clement Wong
<p>Yes, iHub 3.1.1 supports the following for Database Software for iHub Server Encyclopedia @ <a data-ipb='nomediaparse' href='
http://developer.actuate.com/resources/supported-products/ihub/birt-ihub3-1-1'>http://developer.actuate.com/resources/supported-products/ihub/birt-ihub3-1-1</a></p>
;
<pre class="_prettyXprint _lang-nocode">
Database Servers Server Versions
Oracle 11g R1 & R2,
12c R1: 12.1.0.2.0 (Patchset as of July 2014)
PostgreSQL Database 9.2 (provided with our products)
</pre>