----- Original Message ----- > From: "Marcelo Leandro" <[email protected]> > To: "Martin Perina" <[email protected]> > Cc: "Eli Mesika" <[email protected]>, "users" <[email protected]> > 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] https://bugzilla.redhat.com/show_bug.cgi?id=1303163 > > 2016-02-05 10:11 GMT-03:00 Martin Perina <[email protected]>: > > Great to hear! Let me know if there are still any other issues with the > > upgrade. > > > > Thanks > > > > Martin Perina > > > > > > ----- Original Message ----- > >> From: "Marcelo Leandro" <[email protected]> > >> To: "Martin Perina" <[email protected]> > >> Cc: "Eli Mesika" <[email protected]>, "users" <[email protected]> > >> 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 <[email protected]>: > >> > 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" <[email protected]> > >> >> To: "Darrell Budic" <[email protected]> > >> >> Cc: "Martin Perina" <[email protected]>, "Eli Mesika" > >> >> <[email protected]>, "users" <[email protected]> > >> >> 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 <[email protected]>: > >> >> > 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 <[email protected]> > >> >> >> wrote: > >> >> >> > >> >> >> > >> >> >> > >> >> >> ----- Original Message ----- > >> >> >>> From: "Eli Mesika" <[email protected]> > >> >> >>> To: "Martin Perina" <[email protected]> > >> >> >>> Cc: "Marcelo Leandro" <[email protected]>, "Darrell Budic" > >> >> >>> <[email protected]>, "users" <[email protected]> > >> >> >>> 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" <[email protected]> > >> >> >>>> To: "Marcelo Leandro" <[email protected]> > >> >> >>>> Cc: "Darrell Budic" <[email protected]>, "Eli Mesika" > >> >> >>>> <[email protected]>, "users" <[email protected]> > >> >> >>>> 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" <[email protected]> > >> >> >>>>> To: "Martin Perina" <[email protected]> > >> >> >>>>> 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 <[email protected]>: > >> >> >>>>>> 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" <[email protected]> > >> >> >>>>>>> To: "Marcelo Leandro" <[email protected]> > >> >> >>>>>>> Cc: "Martin Perina" <[email protected]>, "users" > >> >> >>>>>>> <[email protected]> > >> >> >>>>>>> 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 > >> >> >>>>>>>> <[email protected]> > >> >> >>>>>>>> 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 <[email protected]>: > >> >> >>>>>>>>> Hi, > >> >> >>>>>>>>> > >> >> >>>>>>>>> what distribution are you using? What is postgresql version? > >> >> >>>>>>>>> > >> >> >>>>>>>>> Thanks > >> >> >>>>>>>>> > >> >> >>>>>>>>> Martin Perina > >> >> >>>>>>>>> > >> >> >>>>>>>>> ----- Original Message ----- > >> >> >>>>>>>>>> From: "Marcelo Leandro" <[email protected]> > >> >> >>>>>>>>>> To: "users" <[email protected]> > >> >> >>>>>>>>>> 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 > >> >> >>>>>>>>>> [email protected] > >> >> >>>>>>>>>> http://lists.ovirt.org/mailman/listinfo/users > >> >> >>>>>>>>>> > >> >> >>>>>>>> _______________________________________________ > >> >> >>>>>>>> Users mailing list > >> >> >>>>>>>> [email protected] > >> >> >>>>>>>> http://lists.ovirt.org/mailman/listinfo/users > >> >> > > >> >> > >> > _______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
