[ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to 6.2.6-1.el7
Darrell Budic
budic at onholyground.com
Fri Feb 5 06:28:55 UTC 2016
After changing the owner of engine to “engine”, I was able to upgrade normally, so that looks like it was my problem.
Thanks for the pointers!
> On Feb 4, 2016, at 3:40 PM, Darrell Budic <budic at onholyground.com> wrote:
>
> 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 <mperina at redhat.com> wrote:
>>
>>
>>
>> ----- Original Message -----
>>> From: "Eli Mesika" <emesika at redhat.com>
>>> To: "Martin Perina" <mperina at redhat.com>
>>> Cc: "Marcelo Leandro" <marceloltmm at gmail.com>, "Darrell Budic" <budic at onholyground.com>, "users" <users at 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" <mperina at redhat.com>
>>>> To: "Marcelo Leandro" <marceloltmm at gmail.com>
>>>> Cc: "Darrell Budic" <budic at onholyground.com>, "Eli Mesika"
>>>> <emesika at redhat.com>, "users" <users at 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" <marceloltmm at gmail.com>
>>>>> To: "Martin Perina" <mperina at 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 <mperina at 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" <budic at onholyground.com>
>>>>>>> To: "Marcelo Leandro" <marceloltmm at gmail.com>
>>>>>>> Cc: "Martin Perina" <mperina at redhat.com>, "users" <users at 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 <marceloltmm at 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 <mperina at redhat.com>:
>>>>>>>>> Hi,
>>>>>>>>>
>>>>>>>>> what distribution are you using? What is postgresql version?
>>>>>>>>>
>>>>>>>>> Thanks
>>>>>>>>>
>>>>>>>>> Martin Perina
>>>>>>>>>
>>>>>>>>> ----- Original Message -----
>>>>>>>>>> From: "Marcelo Leandro" <marceloltmm at gmail.com>
>>>>>>>>>> To: "users" <users at 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 at ovirt.org
>>>>>>>>>> http://lists.ovirt.org/mailman/listinfo/users
>>>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Users mailing list
>>>>>>>> Users at ovirt.org
>>>>>>>> http://lists.ovirt.org/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
More information about the Users
mailing list