From: "Marcelo Leandro" <marceloltmm(a)gmail.com>
To: "Martin Perina" <mperina(a)redhat.com>
Cc: "Eli Mesika" <emesika(a)redhat.com>, "users"
<users(a)ovirt.org>
Sent: Friday, February 5, 2016 2:28:55 PM
Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to 6.2.6-1.el7
I had the same problem from the other server , I had to wheel the command:
psql -U engine -c "DELETE from command_entities;" <database name>
after the update.
but now it's ok.
Thanks to your report this is covered by [1] and it will be fixed in 3.6.3.
Martin Perina
[1]
2016-02-05 10:11 GMT-03:00 Martin Perina <mperina(a)redhat.com>:
> Great to hear! Let me know if there are still any other issues with the
> upgrade.
>
> Thanks
>
> Martin Perina
>
>
> ----- Original Message -----
>> From: "Marcelo Leandro" <marceloltmm(a)gmail.com>
>> To: "Martin Perina" <mperina(a)redhat.com>
>> Cc: "Eli Mesika" <emesika(a)redhat.com>, "users"
<users(a)ovirt.org>
>> Sent: Friday, February 5, 2016 1:02:37 PM
>> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to
>> 6.2.6-1.el7
>>
>> Thanks Martin,
>> my problem resolved after the command :
>>
>> su - postgres -c "psql --command=\"ALTER DATABASE engine OWNER TO
>> engine;\""
>>
>> i haven't ideia what started the problem,
>> i restore backup following the link:
>>
http://www.ovirt.org/User:Adrian15/oVirt_engine_migration
>>
>> very thanks.
>>
>> 2016-02-05 7:00 GMT-03:00 Martin Perina <mperina(a)redhat.com>:
>> > Hi,
>> >
>> > I'm not sure what you did to your setup, but looking at all setup logs
>> > there's one big issue:
>> >
>> > ERROR: must be owner of database engine
>> >
>> > So, in over to by pass this you need to make sure that owner of db
>> > 'engine' is user 'engine'. To do that please execute:
>> >
>> > su - postgres -c "psql --command=\"ALTER DATABASE engine OWNER
TO
>> > engine;\""
>> >
>> > When done, please make sure you perform upgrade from 3.5 yo 3.6
>> > properly:
>> >
>> > 1. Add 3.6 repo to your machine
>> >
>> > 2. Execute:
>> > yum update 'ovirt-engine-setup*'
>> >
>> > 3. Execute:
>> > engine-setup
>> >
>> >
>> > If it still doesn't work please send latest setup log.
>> >
>> > Thanks
>> >
>> > Martin Perina
>> >
>> >
>> >
>> > ----- Original Message -----
>> >> From: "Marcelo Leandro" <marceloltmm(a)gmail.com>
>> >> To: "Darrell Budic" <budic(a)onholyground.com>
>> >> Cc: "Martin Perina" <mperina(a)redhat.com>, "Eli
Mesika"
>> >> <emesika(a)redhat.com>, "users" <users(a)ovirt.org>
>> >> Sent: Friday, February 5, 2016 2:44:16 AM
>> >> Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to
>> >> 6.2.6-1.el7
>> >>
>> >> i try update, but the problem persists and now the ovirt not start.
>> >>
>> >> attached the setup.log, I tried three times:
>> >>
>> >> 1- i have problem with connection and the process closed
>> >> 2-return erro :
>> >> [ ERROR ] Failed to execute stage 'Misc configuration':
Command
>> >>
'/usr/share/ovirt-engine-extension-aaa-jdbc/dbscripts/schema.sh'
>> >> failed to execute
>> >> i see that que yum have problem :
>> >> run command:
>> >> yum clean expire-cache
>> >> and yum it's ok now.
>> >> 3- return erro:
>> >> [ ERROR ] Failed to execute stage 'Misc configuration':
Command
>> >>
'/usr/share/ovirt-engine-extension-aaa-jdbc/dbscripts/schema.sh'
>> >> failed to execute
>> >>
>> >> now the ovirt not start.
>> >>
>> >> erro the boot.log
>> >>
>> >> 22:15:55,237 INFO [org.jboss.modules] JBoss Modules version 1.1.1.GA
>> >> 22:16:05,538 INFO [org.jboss.msc] JBoss MSC version 1.0.2.GA
>> >> 22:16:05,614 INFO [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final
>> >> "Brontes" starting
>> >> 22:16:05,988 ERROR [org.jboss.as.server] JBAS015956: Caught exception
>> >> during boot:
>> >> org.jboss.as.controller.persistence.ConfigurationPersistenceException:
>> >> JBAS014676: Failed to parse configuration
>> >> at
>> >>
org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:141)
>> >> [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]
>> >> at
>> >> org.jboss.as.server.ServerService.boot(ServerService.java:266)
>> >> [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]
>> >> at
>> >>
org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:155)
>> >> [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]
>> >> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_95]
>> >> Caused by: javax.xml.stream.XMLStreamException: ParseError at
>> >> [row,col]:[4,1]
>> >> Message: Unexpected element '{urn:jboss:domain:2.1}server'
>> >> at
>> >>
org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:108)
>> >> [staxmapper-1.1.0.Final.jar:1.1.0.Final]
>> >> at
>> >>
org.jboss.staxmapper.XMLMapperImpl.parseDocument(XMLMapperImpl.java:69)
>> >> [staxmapper-1.1.0.Final.jar:1.1.0.Final]
>> >> at
>> >>
org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:133)
>> >> [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]
>> >> ... 3 more
>> >>
>> >> 22:16:06,012 FATAL [org.jboss.as.server] JBAS015957: Server boot has
>> >> failed in an unrecoverable manner; exiting. See previous messages for
>> >> details.
>> >> 22:16:06,040 INFO [org.jboss.as] JBAS015950: JBoss AS 7.1.1.Final
>> >> "Brontes" stopped in 3ms
>> >>
>> >> additional information:
>> >> [root@srv-ovirt01 ~]# cat
>> >> /etc/ovirt-engine/engine.conf.d/10-setup-jboss.conf
>> >> JBOSS_HOME="/usr/share/ovirt-engine-jboss-as"
>> >> i try this
https://bugzilla.redhat.com/show_bug.cgi?id=1062318 but no
>> >> have success
>> >>
>> >>
>> >> thanks.
>> >>
>> >> 2016-02-04 18:40 GMT-03:00 Darrell Budic
<budic(a)onholyground.com>:
>> >> > 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(a)redhat.com>
>> >> >> wrote:
>> >> >>
>> >> >>
>> >> >>
>> >> >> ----- Original Message -----
>> >> >>> From: "Eli Mesika" <emesika(a)redhat.com>
>> >> >>> To: "Martin Perina" <mperina(a)redhat.com>
>> >> >>> Cc: "Marcelo Leandro"
<marceloltmm(a)gmail.com>, "Darrell Budic"
>> >> >>> <budic(a)onholyground.com>, "users"
<users(a)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(a)redhat.com>
>> >> >>>> To: "Marcelo Leandro"
<marceloltmm(a)gmail.com>
>> >> >>>> Cc: "Darrell Budic"
<budic(a)onholyground.com>, "Eli Mesika"
>> >> >>>> <emesika(a)redhat.com>, "users"
<users(a)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(a)gmail.com>
>> >> >>>>> To: "Martin Perina"
<mperina(a)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(a)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(a)onholyground.com>
>> >> >>>>>>> To: "Marcelo Leandro"
<marceloltmm(a)gmail.com>
>> >> >>>>>>> Cc: "Martin Perina"
<mperina(a)redhat.com>, "users"
>> >> >>>>>>> <users(a)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(a)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(a)redhat.com>:
>> >> >>>>>>>>> Hi,
>> >> >>>>>>>>>
>> >> >>>>>>>>> what distribution are you using?
What is postgresql version?
>> >> >>>>>>>>>
>> >> >>>>>>>>> Thanks
>> >> >>>>>>>>>
>> >> >>>>>>>>> Martin Perina
>> >> >>>>>>>>>
>> >> >>>>>>>>> ----- Original Message -----
>> >> >>>>>>>>>> From: "Marcelo
Leandro" <marceloltmm(a)gmail.com>
>> >> >>>>>>>>>> To: "users"
<users(a)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(a)ovirt.org
>> >> >>>>>>>>>>
http://lists.ovirt.org/mailman/listinfo/users
>> >> >>>>>>>>>>
>> >> >>>>>>>>
_______________________________________________
>> >> >>>>>>>> Users mailing list
>> >> >>>>>>>> Users(a)ovirt.org
>> >> >>>>>>>>
http://lists.ovirt.org/mailman/listinfo/users
>> >> >
>> >>
>>