I suspect that’s my problem, my database isn’t owned by engine: engine=# \l List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------+----------+----------+-------------+-------------+-------------------- --- engine | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
This is almost certainly my fault though, one too many upgrades from old versions and/or a slightly botched restore process. Would I be better off setting “engine” as the owner of the engine database then (thinking forward here)? -Darrell > On Feb 4, 2016, at 10:22 AM, Martin Perina <mper...@redhat.com> wrote: > > > > ----- Original Message ----- >> From: "Eli Mesika" <emes...@redhat.com> >> To: "Martin Perina" <mper...@redhat.com> >> Cc: "Marcelo Leandro" <marcelol...@gmail.com>, "Darrell Budic" >> <bu...@onholyground.com>, "users" <users@ovirt.org> >> Sent: Thursday, February 4, 2016 5:17:24 PM >> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to 6.2.6-1.el7 >> >> >> >> ----- Original Message ----- >>> From: "Martin Perina" <mper...@redhat.com> >>> To: "Marcelo Leandro" <marcelol...@gmail.com> >>> Cc: "Darrell Budic" <bu...@onholyground.com>, "Eli Mesika" >>> <emes...@redhat.com>, "users" <users@ovirt.org> >>> Sent: Thursday, February 4, 2016 6:12:34 PM >>> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to >>> 6.2.6-1.el7 >>> >>> Hi, >>> >>> so it seems, that for some strange reason, user 'engine' cannot create >>> schema in 'engine' database although it should be an owner of this db. >>> I double checked that on all our testing databases this works fine and >>> also if you created engine db according to doc (either automatically >>> by engine-setup or manually in case of remote db) this should work. >>> >>> So you can try to execute following command which adds proper >>> permissions to 'engine' db user (please adapt according to you setup): >>> >>> >>> su - postgres -c "psql --command=\"GRANT ALL ON DATABASE >>> @ENGINE_DB_DATABASE@ TO @ENGINE_DB_USER@;\"" >>> >>> The correct output should be: >>> >>> GRANT >>> >>> If it's successful, please execute engine-setup again to verify that >>> above step fixed the issue. >> >> Martin, should that be added to engine-setup ? > > I don't this so, because for all other users I know of this works fine > (if engine db is created according to doc, engine db user is an owner > of db so he can create new schemas). > > But let's wait for reply ... > >> >>> >>> Thanks >>> >>> Martin Perina >>> >>> ----- Original Message ----- >>>> From: "Marcelo Leandro" <marcelol...@gmail.com> >>>> To: "Martin Perina" <mper...@redhat.com> >>>> Sent: Thursday, February 4, 2016 1:40:36 PM >>>> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to >>>> 6.2.6-1.el7 >>>> >>>> Hello Martin, >>>> >>>> Indeed there´s an issue here. Runnig your command, I got this error: >>>> ERROR: permission denied for database engine , I'm investigating >>>> deeper >>>> >>>> Thanks >>>> >>>> 2016-02-04 6:18 GMT-03:00 Martin Perina <mper...@redhat.com>: >>>>> Hi, >>>>> >>>>> I just verified that upgrades on both Centos 6.7 and Centos 7.2 works >>>>> fine, >>>>> so there's something bad with psql on you machines :-( >>>>> >>>>> Could you please execute following steps and send me result? >>>>> >>>>> 1. Please take a look at your engine db configuration in >>>>> /etc/ovirt-engine/engine.conf.d/10-setup-database.conf >>>>> >>>>> 2. Please replace variables (@VAR@) with real values according to your >>>>> db setup and execute following command on engine host (or VM in >>>>> case of hosted engine): >>>>> >>>>> LC_ALL="C" PGPASSWORD="@ENGINE_DB_PASSWORD@" psql -w >>>>> --pset=tuples_only=on --host="@ENGINE_DB_HOST@" >>>>> --port="@ENGINE_DB_PORT@" --username="@ENGINE_DB_USER@" >>>>> --dbname="@ENGINE_DB_DATABASE@" --set ON_ERROR_STOP=1 --no-psqlrc >>>>> --command="CREATE SCHEMA aaa_jdbc_x AUTHORIZATION @ENGINE_DB_USER@;" >>>>> || >>>>> die "Cannot execute sql command" >>>>> >>>>> Correct output should be: >>>>> >>>>> CREATE SCHEMA >>>>> >>>>> >>>>> Thanks a lot >>>>> >>>>> Martin Perina >>>>> >>>>> ----- Original Message ----- >>>>>> From: "Darrell Budic" <bu...@onholyground.com> >>>>>> To: "Marcelo Leandro" <marcelol...@gmail.com> >>>>>> Cc: "Martin Perina" <mper...@redhat.com>, "users" <users@ovirt.org> >>>>>> Sent: Thursday, February 4, 2016 6:17:21 AM >>>>>> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to >>>>>> 6.2.6-1.el7 >>>>>> >>>>>> I just hit a similar problem, but on Centos 6.7, postgres (PostgreSQL) >>>>>> 8.4.20. Looks like a permission error for me? >>>>>> >>>>>> 2016-02-03 22:52:42 DEBUG otopi.context context._executeMethod:142 >>>>>> Stage >>>>>> misc >>>>>> ME >>>>>> THOD >>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.aaajdbc.Plugin._misc >>>>>> 2016-02-03 22:52:42 INFO >>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.aa >>>>>> ajdbc aaajdbc._setupSchema:97 Creating/refreshing Engine 'internal' >>>>>> domain >>>>>> datab >>>>>> ase schema >>>>>> 2016-02-03 22:52:42 DEBUG >>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.a >>>>>> aajdbc plugin.executeRaw:828 execute: >>>>>> ['/usr/share/ovirt-engine-extension-aaa-jd >>>>>> bc/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', >>>>>> 'engine', >>>>>> '-d', >>>>>> 'engine', '-e', 'aaa_jdbc', '-l', >>>>>> '/var/log/ovirt-engine/setup/ovirt-engine-setu >>>>>> p-20160203224629-uy91s0.log', '-c', 'apply'], executable='None', >>>>>> cwd='None', >>>>>> env >>>>>> ={'LESSOPEN': '||/usr/bin/lesspipe.sh %s', 'LOGNAME': 'root', 'USER': >>>>>> 'root', >>>>>> 'P >>>>>> ATH': '/sbin:/bin:/usr/sbin:/usr/bin', 'HOME': '/root', 'LANG': >>>>>> 'en_US.UTF-8', ' >>>>>> TERM': 'xterm-color', 'SHELL': '/bin/bash', 'SHLVL': '1', >>>>>> 'G_BROKEN_FILENAMES': >>>>>> '1', 'HISTSIZE': '1000', 'SUDO_USER': 'telsin', 'USERNAME': 'root', >>>>>> 'PYTHONPATH' >>>>>> : '/usr/share/ovirt-engine/setup/bin/..::', 'SUDO_UID': '699600001', >>>>>> 'KRB5CCNAME >>>>>> ': 'FILE:/tmp/krb5cc_699600001_5oRWEw', 'MAIL': >>>>>> '/var/spool/mail/telsin', >>>>>> 'DBFUN >>>>>> C_DB_PGPASSFILE': '/tmp/tmpqzrQIw', 'SUDO_COMMAND': '/bin/bash', >>>>>> 'SUDO_GID': >>>>>> '69 >>>>>> 9600001', 'HOSTNAME': 'ovirt.int.ohgnetworks.com', 'PWD': >>>>>> '/home/telsin', >>>>>> 'OTOPI >>>>>> _LOGFILE': >>>>>> '/var/log/ovirt-engine/setup/ovirt-engine-setup-20160203224629-uy91s0 >>>>>> .log', 'LS_COLORS': >>>>>> 'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd= >>>>>> 40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30 >>>>>> ;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:* >>>>>> .lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31: >>>>>> *.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31 >>>>>> :*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01; >>>>>> 31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif >>>>>> =01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:* >>>>>> .xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=0 >>>>>> 1;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*. >>>>>> ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;3 >>>>>> 5:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli= >>>>>> 01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cg >>>>>> m=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36: >>>>>> *.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=0 >>>>>> 1;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xs >>>>>> pf=01;36:', 'OTOPI_EXECDIR': '/home/telsin'} >>>>>> ********* QUERY ********** >>>>>> select 1; >>>>>> ************************** >>>>>> >>>>>> 1 >>>>>> >>>>>> ********* QUERY ********** >>>>>> copy ( >>>>>> SELECT COUNT(schema_name) >>>>>> FROM information_schema.schemata >>>>>> WHERE schema_name = 'aaa_jdbc' >>>>>> ) to stdout with delimiter as '|'; >>>>>> ************************** >>>>>> >>>>>> ********* QUERY ********** >>>>>> CREATE SCHEMA aaa_jdbc AUTHORIZATION engine; >>>>>> ************************** >>>>>> >>>>>> 2016-02-03 22:52:43 DEBUG >>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.a >>>>>> aajdbc plugin.executeRaw:878 execute-result: >>>>>> ['/usr/share/ovirt-engine-extension >>>>>> -aaa-jdbc/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', >>>>>> 'engine', >>>>>> '-d', 'engine', '-e', 'aaa_jdbc', '-l', >>>>>> '/var/log/ovirt-engine/setup/ovirt-engi >>>>>> ne-setup-20160203224629-uy91s0.log', '-c', 'apply'], rc=1 >>>>>> 2016-02-03 22:52:43 DEBUG >>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.a >>>>>> aajdbc plugin.execute:936 execute-output: >>>>>> ['/usr/share/ovirt-engine-extension-aa >>>>>> a-jdbc/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', >>>>>> 'engine', >>>>>> '- >>>>>> d', 'engine', '-e', 'aaa_jdbc', '-l', >>>>>> '/var/log/ovirt-engine/setup/ovirt-engine- >>>>>> setup-20160203224629-uy91s0.log', '-c', 'apply'] stdout: >>>>>> Creating custom schema aaa_jdbc ... >>>>>> >>>>>> 2016-02-03 22:52:43 DEBUG >>>>>> otopi.plugins.ovirt_engine_setup.ovirt_engine.config.a >>>>>> aajdbc plugin.execute:941 execute-output: >>>>>> ['/usr/share/ovirt-engine-extension-aa >>>>>> a-jdbc/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', >>>>>> 'engine', >>>>>> '- >>>>>> d', 'engine', '-e', 'aaa_jdbc', '-l', >>>>>> '/var/log/ovirt-engine/setup/ovirt-engine- >>>>>> setup-20160203224629-uy91s0.log', '-c', 'apply'] stderr: >>>>>> ERROR: permission denied for database engine >>>>>> FATAL: Cannot execute sql command: --no-psqlrc --command=CREATE SCHEMA >>>>>> aaa_jdbc >>>>>> AUTHORIZATION engine; >>>>>> >>>>>> 2016-02-03 22:52:43 DEBUG otopi.context context._executeMethod:156 >>>>>> method >>>>>> except >>>>>> ion >>>>>> Traceback (most recent call last): >>>>>> File "/usr/lib/python2.6/site-packages/otopi/context.py", line 146, >>>>>> in >>>>>> _execut >>>>>> eMethod >>>>>> method['method']() >>>>>> File >>>>>> >>>>>> "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-en >>>>>> gine/config/aaajdbc.py", line 379, in _misc >>>>>> self._setupSchema() >>>>>> File >>>>>> >>>>>> "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-en >>>>>> gine/config/aaajdbc.py", line 138, in _setupSchema >>>>>> oenginecons.EngineDBEnv.PGPASS_FILE >>>>>> File "/usr/lib/python2.6/site-packages/otopi/plugin.py", line 946, >>>>>> in >>>>>> execute >>>>>> command=args[0], >>>>>> RuntimeError: Command >>>>>> '/usr/share/ovirt-engine-extension-aaa-jdbc/dbscripts/sche >>>>>> ma.sh' failed to execute >>>>>> 2016-02-03 22:52:43 ERROR otopi.context context._executeMethod:165 >>>>>> Failed >>>>>> to >>>>>> exe >>>>>> cute stage 'Misc configuration': Command >>>>>> '/usr/share/ovirt-engine-extension-aaa- >>>>>> jdbc/dbscripts/schema.sh' failed to execute >>>>>> >>>>>> This hosted engine has been through several upgrades if it makes a >>>>>> difference. Any workarounds available? >>>>>> >>>>>> Thanks, >>>>>> >>>>>> -Darrell >>>>>> >>>>>> >>>>>>> On Feb 3, 2016, at 4:17 AM, Marcelo Leandro <marcelol...@gmail.com> >>>>>>> wrote: >>>>>>> >>>>>>> Hello Martin, >>>>>>> >>>>>>> SO version: >>>>>>> CentOS Linux release 7.2.1511 (Core) >>>>>>> >>>>>>> >>>>>>> Postgresql version: >>>>>>> postgres=# SELECT version(); >>>>>>> >>>>>>> version >>>>>>> >>>>>>> -------------------------------------------------------------------------------------------------------------- >>>>>>> >>>>>>> PostgreSQL 9.2.14 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) >>>>>>> 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit >>>>>>> >>>>>>> >>>>>>> Thanks. >>>>>>> >>>>>>> 2016-02-03 4:40 GMT-03:00 Martin Perina <mper...@redhat.com>: >>>>>>>> Hi, >>>>>>>> >>>>>>>> what distribution are you using? What is postgresql version? >>>>>>>> >>>>>>>> Thanks >>>>>>>> >>>>>>>> Martin Perina >>>>>>>> >>>>>>>> ----- Original Message ----- >>>>>>>>> From: "Marcelo Leandro" <marcelol...@gmail.com> >>>>>>>>> To: "users" <users@ovirt.org> >>>>>>>>> Sent: Wednesday, February 3, 2016 3:39:58 AM >>>>>>>>> Subject: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to >>>>>>>>> 6.2.6-1.el7 >>>>>>>>> >>>>>>>>> hello, >>>>>>>>> i have problem for update with ovirt. >>>>>>>>> erro msg: >>>>>>>>> >>>>>>>>> [ ERROR ] Failed to execute stage 'Misc configuration': Command >>>>>>>>> '/usr/share/ovirt-engine-extension-aaa-jdbc/dbscripts/schema.sh' >>>>>>>>> failed to execute >>>>>>>>> >>>>>>>>> >>>>>>>>> setup.log: >>>>>>>>> https://copy.com/nOhoxwI8kPzm6fO0 >>>>>>>>> >>>>>>>>> anybody can help me ? >>>>>>>>> >>>>>>>>> Thanks. >>>>>>>>> _______________________________________________ >>>>>>>>> Users mailing list >>>>>>>>> Users@ovirt.org >>>>>>>>> http://lists.ovirt.org/mailman/listinfo/users >>>>>>>>> >>>>>>> _______________________________________________ >>>>>>> Users mailing list >>>>>>> Users@ovirt.org >>>>>>> http://lists.ovirt.org/mailman/listinfo/users _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users