daotest job

[Ohad Basan]

Hello

I have been working on updating the job
http://jenkins.ovirt.org/job/ovirt_engine_dao_unit_tests/5369/consoleFull
it used to run createdb.sh with user engine
Now Eli instructed me to make the following change - create use engine and run create schema.

sudo -u postgres psql -d template1 -c 'create role engine;' || :
sudo -u postgres psql -d template1 -c 'ALTER ROLE engine WITH login' || :
sudo -u postgres dropdb engine || :
sudo -u postgres psql -d template1 -c 'create database engine owner engine;'
./create_schema.sh -u engine -d engine 
#./create_db.sh -u postgres -d ${JOB_NAME}_${BUILD_NUMBER}

that will require changing the sudo permissions of the jenkins user
http://gerrit.ovirt.org/#/c/22196/1

despite these changes this job is still failing
rg.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: FATAL: database "ovirt_engine_dao_unit_tests_5369" does not exist
can anyone plz assist?


Thanks,

Ohad