Hello, I am trying to setup ovirt-engine using this link http://www.ovirt.org/develop/developer-guide/engine/engine- development-environment/. Now when I am trying these commands I am getting following error $postgres -c "psql -d template1 -c \"create user engine password 'engine';\"" FATAL: -c psql -d template1 -c "create user engine password 'engine';" requires a value and $postgres -c "psql -d template1 -c "create database engine \ owner engine template template0 encoding 'UTF8' lc_collate \ 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';\"" FATAL: -c psql -d template1 -c "create database engine owner engine template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';" requires a value So I think the syntax given there is not right,So can anyone tell me the correct syntax.Or maybe I am doing something wrong. Thanks, Shubham _______________________________________________ Devel mailing list Devel(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/devel

I am running it as normal user because when I am running it as root user it is giving me following error "root" execution of the PostgreSQL server is not permitted. The server must be started under an unprivileged user ID to prevent possible system security compromise. See the documentation for more information on how to properly start the server.

On Wed, Mar 15, 2017 at 10:14 PM, Fred Rolland <frolland(a)redhat.com&gt; wrote: > Under which user are you running this command ? > In the guide, it is specified to run it as root. > > On Wed, Mar 15, 2017 at 6:30 PM, shubham dubey <sdubey504(a)gmail.com&gt; > > wrote: >> Hello, >> I am trying to setup ovirt-engine using this link >> http://www.ovirt.org/develop/developer-guide/engine/engine-d >> evelopment-environment/. >> Now when I am trying these commands I am getting following error >> $postgres -c "psql -d template1 -c \"create user engine >> password 'engine';\"" >> FATAL: -c psql -d template1 -c "create user engine password 'engine';" >> requires a value >> >> and >> $postgres -c "psql -d template1 -c "create database engine \ >> owner engine template template0 encoding 'UTF8' lc_collate \ >> 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';\"" >> FATAL: -c psql -d template1 -c "create database engine owner engine >> template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype >> 'en_US.UTF-8';" requires a value >> >> So I think the syntax given there is not right,So can anyone tell me the >> correct syntax.Or maybe I am doing something wrong. >> >> Thanks, >> Shubham >> >> _______________________________________________ >> Devel mailing list >> Devel(a)ovirt.org >> http://lists.ovirt.org/mailman/listinfo/devel

Hello, I am trying to setup ovirt-engine using this link http://www.ovirt.org/develop/developer-guide/engine/engine- development-environment/. Now when I am trying these commands I am getting following error $postgres -c "psql -d template1 -c \"create user engine password 'engine';\"" FATAL: -c psql -d template1 -c "create user engine password 'engine';" requires a value and $postgres -c "psql -d template1 -c "create database engine \ owner engine template template0 encoding 'UTF8' lc_collate \ 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';\"" FATAL: -c psql -d template1 -c "create database engine owner engine template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';" requires a value So I think the syntax given there is not right,So can anyone tell me the correct syntax.Or maybe I am doing something wrong. Thanks, Shubham _______________________________________________ Devel mailing list Devel(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/devel

On Wed, Mar 15, 2017 at 10:42 PM, Martin Perina <mperina(a)redhat.com&gt; wrote: > Hi, > > I think you have forgotten 'su' command at beginning, correct commands are: > > su - postgres -c "psql -d template1 -c \"create user engine password > 'engine';\"" > su - postgres -c "psql -d template1 -c \"create database engine owner > engine template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype > 'en_US.UTF-8';\"" > You can also use this: /usr/share/ovirt-engine/setup/bin/ovirt-engine-provisiondb --otopi-environment="OVESETUP_PROVISION_DB/database=str:engine OVESETUP_PROVISION_DB/user=str:engine OVESETUP_PROVISION_DB/password=str:mypassword" It should do "everything" - initdb, create user and db, configure pg, etc. If you messed up your pg setup and want to start from scratch (which you at least partially did, if you have bad permissions on pg_hba.conf), you can do this: 1. Disconnect everything that's connected to pg, if any 2. systemctl stop postgresql 3. rm -rf /var/lib/pgsql/data Then try again (following the web page or using above command). Best, > > Martin > > > On Wed, Mar 15, 2017 at 5:30 PM, shubham dubey <sdubey504(a)gmail.com&gt; wrote: >> >> Hello, >> I am trying to setup ovirt-engine using this link >> http://www.ovirt.org/develop/developer-guide/engine/engine- development-environment/. >> Now when I am trying these commands I am getting following error >> $postgres -c "psql -d template1 -c \"create user engine password >> 'engine';\"" >> FATAL: -c psql -d template1 -c "create user engine password 'engine';" >> requires a value >> >> and >> $postgres -c "psql -d template1 -c "create database engine \ >> owner engine template template0 encoding 'UTF8' lc_collate \ >> 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';\"" >> FATAL: -c psql -d template1 -c "create database engine owner engine >> template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype >> 'en_US.UTF-8';" requires a value >> >> So I think the syntax given there is not right,So can anyone tell me the >> correct syntax.Or maybe I am doing something wrong. >> >> Thanks, >> Shubham >> >> _______________________________________________ >> Devel mailing list >> Devel(a)ovirt.org >> http://lists.ovirt.org/mailman/listinfo/devel > > > > _______________________________________________ > Devel mailing list > Devel(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/devel -- Didi