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. Thanks Martin Perina ----- Original Message -----
From: "Marcelo Leandro" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@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@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@onholyground.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Martin Perina" <mperina@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 <marceloltmm@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@redhat.com>:
Hi,
what distribution are you using? What is postgresql version?
Thanks
Martin Perina
----- Original Message -----
From: "Marcelo Leandro" <marceloltmm@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
----- Original Message -----
From: "Martin Perina" <mperina@redhat.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" <emesika@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 ?
Thanks
Martin Perina
----- Original Message -----
From: "Marcelo Leandro" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@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@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@onholyground.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Martin Perina" <mperina@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 <marceloltmm@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@redhat.com>:
Hi,
what distribution are you using? What is postgresql version?
Thanks
Martin Perina
----- Original Message ----- > From: "Marcelo Leandro" <marceloltmm@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
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" <budic@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" <mperina@redhat.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" <emesika@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" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@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@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@onholyground.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Martin Perina" <mperina@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 <marceloltmm@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@redhat.com>: > Hi, > > what distribution are you using? What is postgresql version? > > Thanks > > Martin Perina > > ----- Original Message ----- >> From: "Marcelo Leandro" <marceloltmm@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
This worked for me, thanks. command:su - postgres -c "psql --command=\"GRANT ALL ON DATABASE @ENGINE_DB_DATABASE@ TO @ENGINE_DB_USER@;\"" output: GRANT after it: command: 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" output: "CREATE SCHEMA" tonight i try update and reply if worked. thanks. 2016-02-04 13:22 GMT-03:00 Martin Perina <mperina@redhat.com>:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" <budic@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" <mperina@redhat.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" <emesika@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" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@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@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@onholyground.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Martin Perina" <mperina@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 <marceloltmm@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@redhat.com>: >> Hi, >> >> what distribution are you using? What is postgresql version? >> >> Thanks >> >> Martin Perina >> >> ----- Original Message ----- >>> From: "Marcelo Leandro" <marceloltmm@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
----- Original Message -----
From: "Marcelo Leandro" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Eli Mesika" <emesika@redhat.com>, "Darrell Budic" <budic@onholyground.com>, "users" <users@ovirt.org> Sent: Thursday, February 4, 2016 5:55:09 PM Subject: Re: [ovirt-users] Problem update ovirt 3.5.6.2-1.el7 to 6.2.6-1.el7
This worked for me, thanks. command:su - postgres -c "psql --command=\"GRANT ALL ON DATABASE @ENGINE_DB_DATABASE@ TO @ENGINE_DB_USER@;\""
output: GRANT
after it:
command: 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"
output: "CREATE SCHEMA"
Great to hear, please drop above created testing schema (it's not needed any more) by changing SQL part of above command: "DROP SCHEMA aaa_jdbc_x;"
tonight i try update and reply if worked.
thanks.
2016-02-04 13:22 GMT-03:00 Martin Perina <mperina@redhat.com>:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" <budic@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" <mperina@redhat.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" <emesika@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" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@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@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@onholyground.com> > To: "Marcelo Leandro" <marceloltmm@gmail.com> > Cc: "Martin Perina" <mperina@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 > > <marceloltmm@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@redhat.com>: > >> Hi, > >> > >> what distribution are you using? What is postgresql version? > >> > >> Thanks > >> > >> Martin Perina > >> > >> ----- Original Message ----- > >>> From: "Marcelo Leandro" <marceloltmm@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 > >
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@redhat.com> wrote:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" <budic@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" <mperina@redhat.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" <emesika@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" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@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@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@onholyground.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Martin Perina" <mperina@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 <marceloltmm@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@redhat.com>: >> Hi, >> >> what distribution are you using? What is postgresql version? >> >> Thanks >> >> Martin Perina >> >> ----- Original Message ----- >>> From: "Marcelo Leandro" <marceloltmm@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
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@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@redhat.com> wrote:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" <budic@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" <mperina@redhat.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" <emesika@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" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@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@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@onholyground.com> > To: "Marcelo Leandro" <marceloltmm@gmail.com> > Cc: "Martin Perina" <mperina@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 <marceloltmm@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@redhat.com>: >>> Hi, >>> >>> what distribution are you using? What is postgresql version? >>> >>> Thanks >>> >>> Martin Perina >>> >>> ----- Original Message ----- >>>> From: "Marcelo Leandro" <marceloltmm@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
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@gmail.com> To: "Darrell Budic" <budic@onholyground.com> Cc: "Martin Perina" <mperina@redhat.com>, "Eli Mesika" <emesika@redhat.com>, "users" <users@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@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@redhat.com> wrote:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" <budic@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" <mperina@redhat.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" <emesika@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" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@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@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@onholyground.com> >> To: "Marcelo Leandro" <marceloltmm@gmail.com> >> Cc: "Martin Perina" <mperina@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 <marceloltmm@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@redhat.com>: >>>> Hi, >>>> >>>> what distribution are you using? What is postgresql version? >>>> >>>> Thanks >>>> >>>> Martin Perina >>>> >>>> ----- Original Message ----- >>>>> From: "Marcelo Leandro" <marceloltmm@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
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@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@gmail.com> To: "Darrell Budic" <budic@onholyground.com> Cc: "Martin Perina" <mperina@redhat.com>, "Eli Mesika" <emesika@redhat.com>, "users" <users@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@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@redhat.com> wrote:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" <budic@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" <mperina@redhat.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" <emesika@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" <marceloltmm@gmail.com> > To: "Martin Perina" <mperina@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@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@onholyground.com> >>> To: "Marcelo Leandro" <marceloltmm@gmail.com> >>> Cc: "Martin Perina" <mperina@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 <marceloltmm@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@redhat.com>: >>>>> Hi, >>>>> >>>>> what distribution are you using? What is postgresql version? >>>>> >>>>> Thanks >>>>> >>>>> Martin Perina >>>>> >>>>> ----- Original Message ----- >>>>>> From: "Marcelo Leandro" <marceloltmm@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
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@gmail.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Eli Mesika" <emesika@redhat.com>, "users" <users@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@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@gmail.com> To: "Darrell Budic" <budic@onholyground.com> Cc: "Martin Perina" <mperina@redhat.com>, "Eli Mesika" <emesika@redhat.com>, "users" <users@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@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@redhat.com> wrote:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" <budic@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" <mperina@redhat.com> > To: "Marcelo Leandro" <marceloltmm@gmail.com> > Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" > <emesika@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" <marceloltmm@gmail.com> >> To: "Martin Perina" <mperina@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@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@onholyground.com> >>>> To: "Marcelo Leandro" <marceloltmm@gmail.com> >>>> Cc: "Martin Perina" <mperina@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 >>>>> <marceloltmm@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@redhat.com>: >>>>>> Hi, >>>>>> >>>>>> what distribution are you using? What is postgresql version? >>>>>> >>>>>> Thanks >>>>>> >>>>>> Martin Perina >>>>>> >>>>>> ----- Original Message ----- >>>>>>> From: "Marcelo Leandro" <marceloltmm@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
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. 2016-02-05 10:11 GMT-03:00 Martin Perina <mperina@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@gmail.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Eli Mesika" <emesika@redhat.com>, "users" <users@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@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@gmail.com> To: "Darrell Budic" <budic@onholyground.com> Cc: "Martin Perina" <mperina@redhat.com>, "Eli Mesika" <emesika@redhat.com>, "users" <users@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@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@redhat.com> wrote:
----- Original Message ----- > From: "Eli Mesika" <emesika@redhat.com> > To: "Martin Perina" <mperina@redhat.com> > Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" > <budic@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" <mperina@redhat.com> >> To: "Marcelo Leandro" <marceloltmm@gmail.com> >> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" >> <emesika@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" <marceloltmm@gmail.com> >>> To: "Martin Perina" <mperina@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@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@onholyground.com> >>>>> To: "Marcelo Leandro" <marceloltmm@gmail.com> >>>>> Cc: "Martin Perina" <mperina@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 >>>>>> <marceloltmm@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@redhat.com>: >>>>>>> Hi, >>>>>>> >>>>>>> what distribution are you using? What is postgresql version? >>>>>>> >>>>>>> Thanks >>>>>>> >>>>>>> Martin Perina >>>>>>> >>>>>>> ----- Original Message ----- >>>>>>>> From: "Marcelo Leandro" <marceloltmm@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
----- Original Message -----
From: "Marcelo Leandro" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Eli Mesika" <emesika@redhat.com>, "users" <users@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] https://bugzilla.redhat.com/show_bug.cgi?id=1303163
2016-02-05 10:11 GMT-03:00 Martin Perina <mperina@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@gmail.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Eli Mesika" <emesika@redhat.com>, "users" <users@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@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@gmail.com> To: "Darrell Budic" <budic@onholyground.com> Cc: "Martin Perina" <mperina@redhat.com>, "Eli Mesika" <emesika@redhat.com>, "users" <users@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@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@redhat.com> > wrote: > > > > ----- Original Message ----- >> From: "Eli Mesika" <emesika@redhat.com> >> To: "Martin Perina" <mperina@redhat.com> >> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" >> <budic@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" <mperina@redhat.com> >>> To: "Marcelo Leandro" <marceloltmm@gmail.com> >>> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" >>> <emesika@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" <marceloltmm@gmail.com> >>>> To: "Martin Perina" <mperina@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@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@onholyground.com> >>>>>> To: "Marcelo Leandro" <marceloltmm@gmail.com> >>>>>> Cc: "Martin Perina" <mperina@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 >>>>>>> <marceloltmm@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@redhat.com>: >>>>>>>> Hi, >>>>>>>> >>>>>>>> what distribution are you using? What is postgresql version? >>>>>>>> >>>>>>>> Thanks >>>>>>>> >>>>>>>> Martin Perina >>>>>>>> >>>>>>>> ----- Original Message ----- >>>>>>>>> From: "Marcelo Leandro" <marceloltmm@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
Thank you all for help. 2016-02-05 10:35 GMT-03:00 Martin Perina <mperina@redhat.com>:
----- Original Message -----
From: "Marcelo Leandro" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Eli Mesika" <emesika@redhat.com>, "users" <users@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] https://bugzilla.redhat.com/show_bug.cgi?id=1303163
2016-02-05 10:11 GMT-03:00 Martin Perina <mperina@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@gmail.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Eli Mesika" <emesika@redhat.com>, "users" <users@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@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@gmail.com> To: "Darrell Budic" <budic@onholyground.com> Cc: "Martin Perina" <mperina@redhat.com>, "Eli Mesika" <emesika@redhat.com>, "users" <users@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@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@redhat.com> >> wrote: >> >> >> >> ----- Original Message ----- >>> From: "Eli Mesika" <emesika@redhat.com> >>> To: "Martin Perina" <mperina@redhat.com> >>> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" >>> <budic@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" <mperina@redhat.com> >>>> To: "Marcelo Leandro" <marceloltmm@gmail.com> >>>> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" >>>> <emesika@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" <marceloltmm@gmail.com> >>>>> To: "Martin Perina" <mperina@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@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@onholyground.com> >>>>>>> To: "Marcelo Leandro" <marceloltmm@gmail.com> >>>>>>> Cc: "Martin Perina" <mperina@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 >>>>>>>> <marceloltmm@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@redhat.com>: >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> what distribution are you using? What is postgresql version? >>>>>>>>> >>>>>>>>> Thanks >>>>>>>>> >>>>>>>>> Martin Perina >>>>>>>>> >>>>>>>>> ----- Original Message ----- >>>>>>>>>> From: "Marcelo Leandro" <marceloltmm@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 >
On Fri, Feb 5, 2016 at 2:02 PM, Marcelo Leandro <marceloltmm@gmail.com> wrote:
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.
Please note that the above page is very old and unmaintained, and should only be used to get some detailed reference about the process. It also mentions in bold, close to the beginning, "This howto is intended for oVirt 3.1 version." Please use the tool engine-backup and related pages about it. If you encounter problems please report them. Thanks! Best regards,
2016-02-05 7:00 GMT-03:00 Martin Perina <mperina@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@gmail.com> To: "Darrell Budic" <budic@onholyground.com> Cc: "Martin Perina" <mperina@redhat.com>, "Eli Mesika" <emesika@redhat.com>, "users" <users@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@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@redhat.com> wrote:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" <budic@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" <mperina@redhat.com> > To: "Marcelo Leandro" <marceloltmm@gmail.com> > Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" > <emesika@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" <marceloltmm@gmail.com> >> To: "Martin Perina" <mperina@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@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@onholyground.com> >>>> To: "Marcelo Leandro" <marceloltmm@gmail.com> >>>> Cc: "Martin Perina" <mperina@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 <marceloltmm@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@redhat.com>: >>>>>> Hi, >>>>>> >>>>>> what distribution are you using? What is postgresql version? >>>>>> >>>>>> Thanks >>>>>> >>>>>> Martin Perina >>>>>> >>>>>> ----- Original Message ----- >>>>>>> From: "Marcelo Leandro" <marceloltmm@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
-- Didi
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@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@redhat.com> wrote:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Martin Perina" <mperina@redhat.com> Cc: "Marcelo Leandro" <marceloltmm@gmail.com>, "Darrell Budic" <budic@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" <mperina@redhat.com> To: "Marcelo Leandro" <marceloltmm@gmail.com> Cc: "Darrell Budic" <budic@onholyground.com>, "Eli Mesika" <emesika@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" <marceloltmm@gmail.com> To: "Martin Perina" <mperina@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@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@onholyground.com> > To: "Marcelo Leandro" <marceloltmm@gmail.com> > Cc: "Martin Perina" <mperina@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 <marceloltmm@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@redhat.com>: >>> Hi, >>> >>> what distribution are you using? What is postgresql version? >>> >>> Thanks >>> >>> Martin Perina >>> >>> ----- Original Message ----- >>>> From: "Marcelo Leandro" <marceloltmm@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
participants (5)
-
Darrell Budic -
Eli Mesika -
Marcelo Leandro -
Martin Perina -
Yedidyah Bar David