Hide Forgot
Description of problem: The create_db.sh script expects to find the file uuid-ossp.sql in a hardcoded location of /usr/share/pgsql/contrib/uuid-ossp.sql. The problem is that this file is not always installed in that location. Depending on the OS and the way the the postgresql components were installed, the file uuid-ossp.sql could be found in one of several locations. Two I know of are: /usr/share/postgresql/8.4/contrib/uuid-ossp.sql /usr/local/pgsql/share/contrib/uuid-ossp.sql How reproducible: whenever uuid-ossp.sql is not installed in the hardcoded path Actual results: The message: "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" Expected results: The script finds or asks for the location of the file so that the script can continue.
Created a patch for this, let me know what you think... Change-Id: I101338cc8cb685583277049a08f1aad06f37ad97 http://gerrit.ovirt.org/#change,162
when a patch has been posted, bugzilla can be moved to POST status: "POST: A patch or solution believed to resolve this matter has been proposed"
Fixed in: http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commit;h=d64bc2b8f8ba99593f8cda0e511789c64ffb1be4
my uuid-ossp.sql is in the default location /usr/share/pgsql/contrib/, but Istill encountered this problem. I don't know why. then I use ./create_db_devel.sh -u postgres -f /usr/share/pgsql/contrib/uuid-ossp.sql and still failed. psql:/usr/share/pgsql/contrib/uuid-ossp.sql:9: ERROR: could not access file "$libdir/uuid-ossp": 没有那个文件或目录 psql:/usr/share/pgsql/contrib/uuid-ossp.sql:14: ERROR: could not access file "$libdir/uuid-ossp": 没有那个文件或目录 psql:/usr/share/pgsql/contrib/uuid-ossp.sql:19: ERROR: could not access file "$libdir/uuid-ossp": 没有那个文件或目录 psql:/usr/share/pgsql/contrib/uuid-ossp.sql:24: ERROR: could not access file "$libdir/uuid-ossp": 没有那个文件或目录 psql:/usr/share/pgsql/contrib/uuid-ossp.sql:29: ERROR: could not access file "$libdir/uuid-ossp": 没有那个文件或目录 psql:/usr/share/pgsql/contrib/uuid-ossp.sql:34: ERROR: could not access file "$libdir/uuid-ossp": 没有那个文件或目录 psql:/usr/share/pgsql/contrib/uuid-ossp.sql:39: ERROR: could not access file "$libdir/uuid-ossp": 没有那个文件或目录 psql:/usr/share/pgsql/contrib/uuid-ossp.sql:44: ERROR: could not access file "$libdir/uuid-ossp": 没有那个文件或目录 psql:/usr/share/pgsql/contrib/uuid-ossp.sql:49: ERROR: could not access file "$libdir/uuid-ossp": 没有那个文件或目录 psql:/usr/share/pgsql/contrib/uuid-ossp.sql:54: ERROR: could not access file "$libdir/uuid-ossp": 没有那个文件或目录
I have Fedora17 clean install; postgresql-contrib-9.1.3-3.fc17.x86_64 installed, but no uuid-ossp.sql file on my file system. The whole /usr/share/pgsql/contrib dir is empty execpt one file sepgqsl.sql. And of course, I fail to run create_db.sh script.
closing ON_QA bugs as oVirt 3.1 was released: http://www.ovirt.org/get-ovirt/
Created attachment 674891 [details] Change regular expression for matching all psql 9.X version