Bug 770679 - [ovirt-dwh] - Cannot Create the ovirt_history database using the create_db.sh script
Summary: [ovirt-dwh] - Cannot Create the ovirt_history database using the create_db.sh...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: oVirt
Classification: Retired
Component: ovirt-engine-dwh
Version: unspecified
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 3.1
Assignee: Yaniv Lavi
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-12-28 09:57 UTC by David Botzer
Modified: 2014-01-14 00:02 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-08-09 08:06:29 UTC
oVirt Team: ---


Attachments (Terms of Use)

Description David Botzer 2011-12-28 09:57:25 UTC
Description of problem:
Cannot Create the ovirt_history database using the create_db.sh script 
The file /usr/share/pgsql/contrib/uuid-ossp.sql does not exist

Version-Release number of selected component (if applicable):
Pre-Integration

How reproducible:
Always

Steps to Reproduce:
1.git clone ovirt-dwh, ovirt-engine
2.run from the ovirt-dwh folder the create_db.sh script-->
ovirt-dwh/data-warehouse/historydbscripts_postgres
  
Actual results:
The file /usr/share/pgsql/contrib/uuid-ossp.sql does not exist

Expected results:
Should create the ovirt-dwh history db

Additional info:

./create_db.sh -u postgres 

The file /usr/share/pgsql/contrib/uuid-ossp.sql does not exist. It is possible the postgresql-contrib package was not installed
In order to install the package please perform:

yum provides postgresql-contrib
This will determine which package should be installed. For example, for fedora 14 it should be: postgresql-contrib-8.4.7-1.fc14.x86_64

yum install package-name
For example, for fedora 14 it should be: yum install postgresql-contrib-8.4.7-1.fc14.x86_64
After installation is done, please run create_db.sh script again

Comment 1 Yaniv Lavi 2012-01-10 11:56:49 UTC
Fixed in:
http://gerrit.ovirt.org/810



Yaniv

Comment 2 Itamar Heim 2012-08-09 08:06:29 UTC
closing ON_QA bugs as oVirt 3.1 was released:
http://www.ovirt.org/get-ovirt/


Note You need to log in before you can comment on or make changes to this bug.