Bug 770679

Summary: [ovirt-dwh] - Cannot Create the ovirt_history database using the create_db.sh script
Product: [Retired] oVirt Reporter: David Botzer <dbotzer>
Component: ovirt-engine-dwhAssignee: Yaniv Lavi <ylavi>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: unspecifiedCC: acathrow, iheim, pstehlik, yeylon, ykaul
Target Milestone: ---   
Target Release: 3.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-08-09 08:06:29 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

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/