[Users] vdsm-python-cpopen is obsoleted by python-cpopen
by Robert Story
--Sig_/Lottk3k7HLb.l+RAotF_X1I
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Hello,
Any status on the pthon-cpopen obsoleted issue? Or any work-arounds? BZ is
here: https://bugzilla.redhat.com/show_bug.cgi?id=3D1056470. I can't instal=
l add an el6 host to my cluster.. :-/
--> Processing Dependency: vdsm-python-cpopen for package: vdsm-xmlrpc-4.13=
.3-2.el6.noarch
Package vdsm-python-cpopen is obsoleted by python-cpopen, but obsoleting pa=
ckage does not provide for requirements
--> Finished Dependency Resolution
Error: Package: vdsm-xmlrpc-4.13.3-2.el6.noarch (ovirt-3.3.2)
Requires: vdsm-python-cpopen
Available: python-cpopen-1.3-1.el6.x86_64 (epel)
vdsm-python-cpopen =3D 4.13.2
Available: vdsm-python-cpopen-4.12.1-2.el6.i686 (ovirt-stable)
vdsm-python-cpopen =3D 4.12.1-2.el6
Available: vdsm-python-cpopen-4.12.1-4.el6.i686 (ovirt-stable)
vdsm-python-cpopen =3D 4.12.1-4.el6
Available: vdsm-python-cpopen-4.13.0-9.el6.i686 (ovirt-stable)
vdsm-python-cpopen =3D 4.13.0-9.el6
Available: vdsm-python-cpopen-4.13.0-11.el6.i686 (ovirt-stable)
vdsm-python-cpopen =3D 4.13.0-11.el6
Available: vdsm-python-cpopen-4.13.2-1.el6.i686 (ovirt-3.3.2)
vdsm-python-cpopen =3D 4.13.2-1.el6
Available: vdsm-python-cpopen-4.13.3-2.el6.i686 (ovirt-3.3.2)
vdsm-python-cpopen =3D 4.13.3-2.el6
You could try using --skip-broken to work around the problem
Robert
--
Senior Software Engineer @ Parsons
--Sig_/Lottk3k7HLb.l+RAotF_X1I
Content-Type: application/pgp-signature; name=signature.asc
Content-Disposition: attachment; filename=signature.asc
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)
iEYEARECAAYFAlLqtv8ACgkQ7/fVLLY1mniCwQCfdPHEJ37Xw+LWC9A/aU0/xWJw
gf4AoIMNVRg5N1Hv+tg8kD/Xg83eknxp
=mx3j
-----END PGP SIGNATURE-----
--Sig_/Lottk3k7HLb.l+RAotF_X1I--
10 years, 9 months
[Users] engine-backup restore how to
by Steve Dainard
There doesn't seem to be any solid documentation on how to use the
engine-backup restore function, and I'm not able to restore a backup.
The best I've come up with is:
1. Install engine on new host
2. Stop engine
3. run engine-backup --mode=restore --file=filename --log=logfile
Fail.
Log shows:
psql: FATAL: password authentication failed for user "engine"
2014-01-29 18:20:30 10285: FATAL: Can't connect to the database
4. engine-backup --mode=restore --file=engine.bak --log=logfile
--change-db-credentials --db-host=localhost --db-user=engine
--db-name=engine --db-password='newpassword'
Fails with same error.
5. change user to postgres, drop the old db, create a new db named engine,
set password for engine user same as 'newpassword'
6. engine-backup --mode=restore --file=engine.bak --log=logfile
--change-db-credentials --db-host=localhost --db-user=engine
--db-name=engine --db-password='newpassword'
Restoring...
Rewriting /etc/ovirt-engine/engine.conf.d/10-setup-database.conf
Note: you might need to manually fix:
- iptables/firewalld configuration
- autostart of ovirt-engine service
You can now start the engine service and then restart httpd
Done.
7. start ovirt-engine, restart httpd, browse to web ui
Blank page, no content.
8. stop firewall, browse to web ui
Blank page, no content
9. Engine log contains:
2014-01-29 18:35:56,973 INFO [org.ovirt.engine.core.utils.LocalConfig]
(MSC service
thread 1-40) Value of property "SENSITIVE_KEYS" is
",ENGINE_DB_PASSWORD,ENGINE_PKI_TR
UST_STORE_PASSWORD,ENGINE_PKI_ENGINE_STORE_PASSWORD".
2014-01-29 18:35:57,330 ERROR [org.ovirt.engine.core.bll.Backend] (MSC
service thread
1-25) Error in getting DB connection. The database is inaccessible.
Original exception is: BadSqlGrammarException: CallableStatementCallback;
bad SQL grammar [{call checkdbconnection()}]; nested exception is
org.postgresql.util.PSQLException: ERROR: function checkdbconnection() does
not exist
Hint: No function matches the given name and argument types. You might
need to add explicit type casts.
Position: 15
2014-01-29 18:35:58,336 ERROR [org.ovirt.engine.core.bll.Backend] (MSC
service thread 1-25) Error in getting DB connection. The database is
inaccessible. Original exception is: UncategorizedSQLException:
CallableStatementCallback; uncategorized SQLException for SQL [{call
checkdbconnection()}]; SQL state [25P02]; error code [0]; ERROR: current
transaction is aborted, commands ignored until end of transaction block;
nested exception is org.postgresql.util.PSQLException: ERROR: current
transaction is aborted, commands ignored until end of transaction block
*Steve Dainard *
IT Infrastructure Manager
Miovision <http://miovision.com/> | *Rethink Traffic*
519-513-2407 ex.250
877-646-8476 (toll-free)
*Blog <http://miovision.com/blog> | **LinkedIn
<https://www.linkedin.com/company/miovision-technologies> | Twitter
<https://twitter.com/miovision> | Facebook
<https://www.facebook.com/miovision>*
------------------------------
Miovision Technologies Inc. | 148 Manitou Drive, Suite 101, Kitchener, ON,
Canada | N2C 1L3
This e-mail may contain information that is privileged or confidential. If
you are not the intended recipient, please delete the e-mail and any
attachments and notify us immediately.
10 years, 9 months
Re: [Users] How to setup FreeBSD 8.3 Guest on oVirt 3.3
by Dresel Christopher
Thank you, I already found your repo and I'm testing.
The custom property is selectable via the GUI, the hook gets called, but I don't know why it don’t work - it seems like the custom property does not get passed to the hook :/
-----Original Message-----
From: René Koch [mailto:rkoch@linuxland.at]
Sent: Mittwoch, 29. Jänner 2014 20:51
To: Joop; Dresel Christopher
Cc: users(a)ovirt.org
Subject: Re: [Users] How to setup FreeBSD 8.3 Guest on oVirt 3.3
On Wed, 2014-01-29 at 19:27 +0100, Joop wrote:
> Dresel Christopher <dresel(a)fhwn.ac.at> wrote:
> >Hi,
> >
> >I’m using oVirt 3.3 and trying to setup a FreeBSD 8.3 Guest machine.
> >The machine hangs after the booting screen - I already googled about
> >this, but didn’t find any helpful articles.
> >
> >Cluster uses “Intel Penryn Family“, the VM is configured with 1
> >virtual CPU as suggested in one of the threads I found on the internet.
> You're probably looking at x2pic cpu flag problems. A vdsm hook might help. Have posted to proxmox forum about this. Also, solaris seems affected, has been discussed on this list.
>
For Solaris I wrote a hook which can be found here (works fine for Solaris 10/11 on Intel CPUs):
https://github.com/ovido/ovirt-stuff/tree/master/hooks
Don't know if this is needed for (older versions of) FreeBSD, too.
Regards,
René
> Joop
>
________________________________
Fachhochschule Wiener Neustadt für Wirtschaft und Technik Ges.m.b.H.
University of Applied Sciences Wiener Neustadt for Business and Engineering Ltd., Austria
Johannes Gutenberg-Straße 3
2700 Wiener Neustadt
Austria, Europe
ATU: 37772406
Firmenbuchnummer: 77005v
Firmenbuchgericht: Landesgericht Wiener Neustadt
DVR: 0769665
Der Inhalt dieses E-Mails ist ausschliesslich fuer den bezeichneten Adressaten bestimmt. Jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder Weitergabe des Inhalts dieses E-Mails durch unberechtigte Dritte ist unzulaessig. Wir bitten Sie, sich mit dem Absender des E-Mails in Verbindung zu setzen, falls Sie nicht der Adressat dieses E-Mails sind und das Material von Ihrem Computer zu loeschen.
This e-mail and any attachments are confidential and intended solely for the addressee. The perusal, publication, copying or dissemination of the contents of this e-mail by unauthorised third parties is prohibited. If you are not the intended recipient of this e-mail, please delete it and immediately notify the sender.
10 years, 10 months
[Users] Weird crash of oVirt-3.3.2-el6
by Joop
Hi All,
Just saw that something has gone 'wrong' in my oVirt installation and I
can't make sense of it.
Full logs are placed in a save place but I would like to start with the
following from /var/log/message on ovirt04:
Jan 30 07:31:52 ovirt04 vdsm TaskManager.Task ERROR
Task=`2a424ca3-19f6-4e01-9e42-ec377655c6f1`::Unexpected
error#012Traceback (most recent call last):#012 File
"/usr/share/vdsm/storage/task.py", line
857, in _run#012 return fn(*args, **kargs)#012 File
"/usr/share/vdsm/logUtils.py", line 45, in wrapper#012 res = f(*args,
**kwargs)#012 File "/usr/share/vdsm/storage/hsm.py", line 3049, in get
VolumeSize#012 apparentsize = str(volClass.getVSize(dom, imgUUID,
volUUID, bs=1))#012 File "/usr/share/vdsm/storage/fileVolume.py", line
418, in getVSize#012 return int(sdobj.oop.os.stat(volPath
).st_size / bs)#012 File
"/usr/share/vdsm/storage/remoteFileHandler.py", line 312, in
callCrabRPCFunction#012 raise Exception("No free file handlers in
pool")#012Exception: No free file handlers in
pool
From that point on it goes downhill. Ovirt04 was the SPM, that got
transferred to ovirt02, all VM's on ovirt04 are set to paused, but only
in the logs and the webui. In real life they are running fine (virsh -r
list on ovirt04 confirms that).
I can select all paused VM's and 'run' them and that clears up de webui
and doesn't harm the VM's sofar as I can tell but shouldn't be necessary.
Joop
10 years, 10 months
[Users] Error: "The following Network Interfaces were specified more than once:"
by Alan Murrell
I have noticed what seems to me to be a quirk, but wanted to see if
this is correct behaviour, or perhaps my configuration.
I am running a test install ov oVirt 3.3.2 in an all-in-one install.
My test box only has one physical NIC, so I am using that for
management/external network access, and I have create a dummy
interface called "dummy_0" to be used for the VMs.
I created four networks, each assigned their own VLAN (I am wanted to
simulate a "real-world" . I added the first network ("VLAN001") to
"dummy_0" with no problem (I was able to save the configuration). The
system created the "dummy_0.1".
When I tried to add another network ("VLAN002") to "dummy_0" and save
it, I got the following error:
--- START ---
Error while executing action:
local_host:
Cannot setup Networks. The following Network Interfaces were
specified more than once: dummy_0.1.
--- END ---
I found that in the "Setup Host Network" if I dragged "VLAN001" off
dummy_0 to the right under "Required", and left "VLAN002" on
"dummy_0", I could save it, and "VLAN001" appeared to remain active on
the host. Indeed, when I went back into "Setup Host Network", both
"VLAN001" and "VLAN002" were showing up on "dummy_0".
However, if I highlight "VLAN002" under "Networks" and click on the
"Hosts" tab, the "Network Interface" is showing a red down arrow,
indicating it is not up. The "Network Interface" for "VLAN001" is a
green up arrow. I have refreshed several times and at this point in
time, have left it for almost thirty minutes, but it remains as a red
down arrow. The same is true for the other two networks I tried
adding: I was able to add them as above, but they are also showing a
red down arrow.
My questions:
1.) Is doing what I had to do to add additional networks to an
interface normal, or is it a quirk of using a dummy interface?
2.) Any ideas why my additional networks are showing a red down
arrow? Again, maybe a quirk of using a dummy interface?
I am going to leave it overnight and see what happens (maybe some
background process needs to run??), but if that does not work, I am
sure I can scrounge up another NIC in the next couple of days and
install it into my test server to see if it does the same thing.
Thanks, in advance.
-Alan
10 years, 10 months
[Users] two node ovirt cluster with HA
by Jaison peter
Hi all ,
I was setting a two node ovirt cluster with ovirt engine on seperate node .
I completed the configuration and tested VM live migrations with out any
issues . Then for checking cluster HA I powered down one host and expected
vms running on that host to be migrated to the other one . But nothing
happened , Engine detected host as un-rechable and marked it as
non-operational and vm ran on that host went to 'unknown state' . Is that
not possible to setup a fully HA ovirt cluster with two nodes ? or else is
that my configuration problem ? please advice .
Thanks & Regards
Alex
10 years, 10 months
[Users] Ovirt 3.4 - Fail to set permissions to VM
by Jonas Israelsson
Greetings.
I have set up oVirt to use Openldap for its users store. I managed to
make two users SuperUser but now when trying to add a third as a normal
user and give him permission to a VM it fails. From the log I see it
complains about duplicate key violations.
No matter what user I try to add to this vm I get the same error. Maybe
it's beyond me but I really do not understand why It wants to add
something to the users table (since the user is already there), sounds
like a bug to me..
Anyone else have the same setup as me, and have this working ?
[root@dashboard ovirt-engine]# tail -100 engine.log
2014-01-28 10:19:14,655 INFO
[org.ovirt.engine.core.bll.AddPermissionCommand]
(org.ovirt.thread.pool-6-thread-26) [5c95fa5a] Running command:
AddPermissionCommand internal: false. Entities affected : ID:
18bcf10a-6f63-44ea-8a9b-70f423476473 Type: StoragePool, ID:
aaa00000-0000-0000-0000-123456789aaa Type: System
2014-01-28 10:19:14,658 ERROR
[org.ovirt.engine.core.bll.AddPermissionCommand]
(org.ovirt.thread.pool-6-thread-26) [5c95fa5a] Command
org.ovirt.engine.core.bll.AddPermissionCommand throw exception:
org.springframework.dao.DuplicateKeyException:
CallableStatementCallback; SQL [{call insertuser(?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?)}]; ERROR: duplicate key value violates unique constraint
"users_domain_external_id_unique"
Where: SQL statement "INSERT INTO users(department, domain, email,
groups, name, note, role, active, surname, user_id, username, group_ids,
external_id) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9
, $10 , $11 , $12 , $13 )"
PL/pgSQL function "insertuser" line 2 at SQL statement; nested exception
is org.postgresql.util.PSQLException: ERROR: duplicate key value
violates unique constraint "users_domain_external_id_unique"
Where: SQL statement "INSERT INTO users(department, domain, email,
groups, name, note, role, active, surname, user_id, username, group_ids,
external_id) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9
, $10 , $11 , $12 , $13 )"
PL/pgSQL function "insertuser" line 2 at SQL statement
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1030)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1064)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:388)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:351)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:181)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.ovirt.engine.core.dao.DbUserDAODbFacadeImpl.save(DbUserDAODbFacadeImpl.java:119)
[dal.jar:]
at
org.ovirt.engine.core.bll.AddPermissionCommand.executeCommand(AddPermissionCommand.java:94)
[bll.jar:]
at
org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:1114)
[bll.jar:]
at
org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:1199)
[bll.jar:]
at
org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:1875)
[bll.jar:]
at
org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:210)
[utils.jar:]
at
org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInRequired(TransactionSupport.java:149)
[utils.jar:]
at
org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:118)
[utils.jar:]
at
org.ovirt.engine.core.bll.CommandBase.execute(CommandBase.java:1219)
[bll.jar:]
at
org.ovirt.engine.core.bll.CommandBase.executeAction(CommandBase.java:351) [bll.jar:]
at
org.ovirt.engine.core.bll.MultipleActionsRunner.executeValidatedCommand(MultipleActionsRunner.java:179)
[bll.jar:]
at
org.ovirt.engine.core.bll.MultipleActionsRunner.runCommands(MultipleActionsRunner.java:151)
[bll.jar:]
at
org.ovirt.engine.core.bll.MultipleActionsRunner$2.run(MultipleActionsRunner.java:160)
[bll.jar:]
at
org.ovirt.engine.core.utils.threadpool.ThreadPoolUtil$InternalWrapperRunnable.run(ThreadPoolUtil.java:97)
[utils.jar:]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[rt.jar:1.7.0_51]
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[rt.jar:1.7.0_51]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
violates unique constraint "users_domain_external_id_unique"
Where: SQL statement "INSERT INTO users(department, domain, email,
groups, name, note, role, active, surname, user_id, username, group_ids,
external_id) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9
, $10 , $11 , $12 , $13 )"
PL/pgSQL function "insertuser" line 2 at SQL statement
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
at
org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:297)
at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
at
org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1066)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1014)
[spring-jdbc.jar:3.1.1.RELEASE]
... 23 more
2014-01-28 10:19:14,673 ERROR
[org.ovirt.engine.core.bll.AddPermissionCommand]
(org.ovirt.thread.pool-6-thread-26) [5c95fa5a] Transaction rolled-back
for command: org.ovirt.engine.core.bll.AddPermissionCommand.
2014-01-28 10:19:14,681 INFO
[org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
(org.ovirt.thread.pool-6-thread-26) [5c95fa5a] Correlation ID: 5c95fa5a,
Call Stack: null, Custom Event ID: -1, Message: User isrjo failed to
grant permission for Role SuperUser on Data Center Elementary to
User/Group Non interactive user.
2014-01-28 10:21:07,003 INFO
[org.ovirt.engine.core.bll.AddPermissionCommand]
(org.ovirt.thread.pool-6-thread-49) [398c89f9] Running command:
AddPermissionCommand internal: false. Entities affected : ID:
0e5c1425-c9d9-46d3-a9f2-f5a6278ab748 Type: VM, ID:
aaa00000-0000-0000-0000-123456789aaa Type: System
2014-01-28 10:21:07,006 ERROR
[org.ovirt.engine.core.bll.AddPermissionCommand]
(org.ovirt.thread.pool-6-thread-49) [398c89f9] Command
org.ovirt.engine.core.bll.AddPermissionCommand throw exception:
org.springframework.dao.DuplicateKeyException:
CallableStatementCallback; SQL [{call insertuser(?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?)}]; ERROR: duplicate key value violates unique constraint
"users_domain_external_id_unique"
Where: SQL statement "INSERT INTO users(department, domain, email,
groups, name, note, role, active, surname, user_id, username, group_ids,
external_id) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9
, $10 , $11 , $12 , $13 )"
PL/pgSQL function "insertuser" line 2 at SQL statement; nested exception
is org.postgresql.util.PSQLException: ERROR: duplicate key value
violates unique constraint "users_domain_external_id_unique"
Where: SQL statement "INSERT INTO users(department, domain, email,
groups, name, note, role, active, surname, user_id, username, group_ids,
external_id) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9
, $10 , $11 , $12 , $13 )"
PL/pgSQL function "insertuser" line 2 at SQL statement
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1030)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1064)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:388)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:351)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:181)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.ovirt.engine.core.dao.DbUserDAODbFacadeImpl.save(DbUserDAODbFacadeImpl.java:119)
[dal.jar:]
at
org.ovirt.engine.core.bll.AddPermissionCommand.executeCommand(AddPermissionCommand.java:94)
[bll.jar:]
at
org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:1114)
[bll.jar:]
at
org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:1199)
[bll.jar:]
at
org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:1875)
[bll.jar:]
at
org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:210)
[utils.jar:]
at
org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInRequired(TransactionSupport.java:149)
[utils.jar:]
at
org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:118)
[utils.jar:]
at
org.ovirt.engine.core.bll.CommandBase.execute(CommandBase.java:1219)
[bll.jar:]
at
org.ovirt.engine.core.bll.CommandBase.executeAction(CommandBase.java:351) [bll.jar:]
at
org.ovirt.engine.core.bll.MultipleActionsRunner.executeValidatedCommand(MultipleActionsRunner.java:179)
[bll.jar:]
at
org.ovirt.engine.core.bll.MultipleActionsRunner.runCommands(MultipleActionsRunner.java:151)
[bll.jar:]
at
org.ovirt.engine.core.bll.MultipleActionsRunner$2.run(MultipleActionsRunner.java:160)
[bll.jar:]
at
org.ovirt.engine.core.utils.threadpool.ThreadPoolUtil$InternalWrapperRunnable.run(ThreadPoolUtil.java:97)
[utils.jar:]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[rt.jar:1.7.0_51]
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[rt.jar:1.7.0_51]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[rt.jar:1.7.0_51]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
violates unique constraint "users_domain_external_id_unique"
Where: SQL statement "INSERT INTO users(department, domain, email,
groups, name, note, role, active, surname, user_id, username, group_ids,
external_id) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9
, $10 , $11 , $12 , $13 )"
PL/pgSQL function "insertuser" line 2 at SQL statement
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
at
org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:297)
at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
at
org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1066)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1)
[spring-jdbc.jar:3.1.1.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1014)
[spring-jdbc.jar:3.1.1.RELEASE]
... 23 more
engine=# select * from users ;
user_id | name | surname |
domain | username | groups | department | role | email |
note | last_admin_check_status | group_ids |
external_id | active
--------------------------------------+----------+------------+---------------+----------+--------+------------+------+----------------------+------+-------------------------+-----------+-------------
--------------------------------------------+--------
fdfc627c-d875-11e0-90f0-83df133b58cc | admin | |
internal | admin | | | |
| | t | | \375\374b|\3
30u\021\340\220\360\203\337\023;X\314 | t
d384ad4e-1ea1-4f52-8886-ca628772dc85 | Håkan | Persson |
elementary.se | perhk | | | |
hakan(a)violaberg.nu | | t | |
\021\270\332
&\334\320\0202\233\257\307_\221\007\374\362 | t
8f787629-9957-41ed-90bb-cb38baa7d9c0 | Jonas | Israelsson |
elementary.se | isrjo | | | |
jonas(a)wehay.com | | t | |
\020\322\340
H\334\320\0202\233\214\307_\221\007\374\362 | t
f1a9336d-1d39-44e3-b843-b78aba2be54b | Jonathan | Poulain |
elementary.se | poujo | | | |
jonatahan(a)sofiero.se | | f | |
9%\346p\352(
\0202\210s\323v\335VO\334 | t
(4 rows)
10 years, 10 months
[Users] engine reports and dwh setup in 3.3.2
by Gianluca Cecchi
Hello,
I have some questions regarding wheat in subject fro 3.3.2.
In November I upgraded my AIO install from fc18 3.2.3 to fc19 3.3.1 following:
http://www.ovirt.org/OVirt_3.2_to_3.3_upgrade
All went ok.
In Fc18 reports and DWH worked ok if I rememebr correctly.
Probably in November I didn't run any setup again for dwh and
reports... after upgrade
This is a test/home server
Today I updated to 3.3.2 without problems and tried upgrade of dwh and
reports too.
One problem I found is that upgrading from f18 to f19, now my postgres
user cannot directly connect to db without password.
I see that my pg_hba.conf is now this way
local all all md5
host ovirtenginereports engine_reports 0.0.0.0/0 md5
host ovirtenginereports engine_reports ::0/0 md5
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
so that running
ovirt-engine-dwh-setup
aborted because of db connections such as
2013-12-21 14:27:47::DEBUG::common_utils::908::root:: retcode = 0
2013-12-21 14:27:47::DEBUG::common_utils::864::root:: Executing
command --> '/bin/su -l postgres -c /usr/bin/psql -U postgres -d
template1 -tAc "select 1;"' in working directory '/root'
2013-12-21 14:27:47::DEBUG::common_utils::906::root:: output =
2013-12-21 14:27:47::DEBUG::common_utils::907::root:: stderr =
Password for user postgres:
psql: fe_sendauth: no password supplied
I temporarily solved putting this entry for unix domains local access
in my pg-hba.conf and restarting the db service
local all postgres trust
and dwh setup completed ok with this ouptut below where I see a
possible bug in the initial username request
But what if a fresh install? Would the setup give the same error for
default fc19 restricted postgres setup?
Also, It asks me if I want to create it and instead of asking the
username it suddenly outputs an error also at first input
But then it asks the username again and all goes well.
The first request shouldn't give error...
[root@tekkaman ~]# ovirt-engine-dwh-setup
Welcome to ovirt-engine-dwh setup utility
This utility can configure a read only user for DB access. Would you
like to do so? (yes|no): yes
Error: user name cannot be empty
Provide a username for read-only user : ovirt_ruser
Provide a password for read-only user:
Warning: Weak Password.
Re-type password:
Should postgresql be setup with secure connection? (yes|no): yes
Existing DB was found on the system. The size of the detected DB is 27
MB, free space in the backup folder /var/lib/ovirt-engine/backups is
approximately 10.0 GB.
The upgrade utility can backup the existing database. The time and
space required for the database backup depend on its size. The
detected DB size is 27 MB. This process takes time, and in some cases
(for instance, when the size is few GBs) may take few hours to
complete. Would you like to continue and backup the existing database?
Answering "no" will skip the backup step and continue the upgrade
without backing up the database (yes|no): yes
Are you sure you would like to continue and backup database
ovirt_engine_history?
Answering "no" will stop the upgrade (yes|no): yes
Backing up the DB... [ DONE ]
Upgrade DB... [ DONE ]
Creating read-only user... [ DONE ]
Setting DB connectivity... [ DONE ]
Starting ovirt-engine... [ DONE ]
Starting oVirt-ETL... [ DONE ]
Successfully installed ovirt-engine-dwh.
The installation log file is available at:
/var/log/ovirt-engine/ovirt-engine-dwh-setup-2013_12_21_14_56_37.log
The DB was backed up as
'/var/lib/ovirt-engine/backups/ovirt-engine-history.backup.2013_12_21_14_58_21'
The DB backup was created with compression. You must use "pg_restore"
command if you need to recover the DB from the backup.
For reports setup I got instead this kind of error in war deploy
[root@tekkaman ~]# ovirt-engine-reports-setup
Welcome to ovirt-engine-reports setup utility
In order to proceed the installer must stop the ovirt-engine service
Would you like to stop the ovirt-engine service (yes|no): yes
Stopping ovirt-engine... [ DONE ]
Editing XML files... [ DONE ]
Setting DB connectivity... [ DONE ]
Exporting scheduled reports... [ DONE ]
Exporting current users... [ DONE ]
Deploying Server... [ ERROR ]
Failed step import-minimal-ce of JasperReports Server
Error encountered while installing ovirt-engine-reports, please
consult the log file:
/var/log/ovirt-engine/ovirt-engine-reports-setup-2013_12_21_14_59_36.log
and in log
[advanced-sql] Executing resource:
/usr/share/jasperreports-server/buildomatic/install_resources/sql/postgresql/quartz.ddl
[advanced-sql] 0 rows affected
[advanced-sql] 5 of 153 SQL statements executed successfully
BUILD SUCCESSFUL
Total time: 2 seconds
2013-12-21 15:00:23::DEBUG::common_utils::1028::root:: stderr =
[advanced-sql] Failed to execute: create table JIAccessEvent ( id
int8 not null, user_id int8 not null, event_date timestamp not null,
resource_id int8 not null, updating bool not null, primary key (id) )
[advanced-sql] org.postgresql.util.PSQLException: ERROR: relation
"jiaccessevent" already exists
I uploaded both dwh and reports logs
dwh
see the zip of various attempts and engine.log here
https://drive.google.com/file/d/0BwoPbcrMv8mvcHcxRDRpSUNpQXM/edit?usp=sha...
for reports:
https://drive.google.com/file/d/0BwoPbcrMv8mvUWJmS1dFbTU1cTA/edit?usp=sha...
The problem is that now, without the reports war, if I try to run
setup for the engine again I get:
--== CONFIGURATION PREVIEW ==--
Database name : engine
Database secured connection : False
Database host : localhost
Database user name : engine
Database host name validation : False
Datbase port : 5432
NFS setup : True
NFS mount point : /ISO
Firewall manager : iptables
Configure WebSocket Proxy : True
Host FQDN : tekkaman.localdomain.local
Set application as default page : True
Configure Apache SSL : False
[ INFO ] Backing up database to
'/var/lib/ovirt-engine/backups/engine-20131221151714.ttpGbB.sql'.
[ INFO ] Updating database schema
[ ERROR ] Failed to execute stage 'Misc configuration': [Errno 2] No
such file or directory:
'/var/lib/ovirt-engine/deployments/ovirt-engine-reports.war'
[ INFO ] Yum Performing yum transaction rollback
[ INFO ] Rolling back database schema
[ INFO ] Clearing database engine
[ INFO ] Restoring database engine
[ INFO ] Stage: Clean up
Log file is located at
/var/log/ovirt-engine/setup/ovirt-engine-setup-20131221151617.log
[ INFO ] Stage: Pre-termination
[ INFO ] Stage: Termination
[ ERROR ] Execution of upgrade failed
see log here:
https://drive.google.com/file/d/0BwoPbcrMv8mveklYRjZSck9mSm8/edit?usp=sha...
BTW: note the cosmetical bug of mmisprinting the word "Database" in
port numebr line
Datbase port : 5432
ANy input to solve reports and engine-setup problem appreciated.
On thing I noticed about dhw is that in
/etc/ovirt-engine/ovirt-engine-dwh
I have
[root@tekkaman ovirt-engine-dwh]# ll
total 8
-rw-rw----. 1 root root 1373 Dec 21 14:58 Default.properties
-rw-rw----. 1 ovirt ovirt 1052 Oct 17 18:16 Default.properties.rpmnew
[root@tekkaman ovirt-engine-dwh]# diff Default.properties
Default.properties.rpmnew
7c7
< ovirtEngineHistoryDbUser=engine_history
---
> ovirtEngineHistoryDbUser=postgres
9c9
< ovirtEngineHistoryDbPassword=0489TGUU
---
> ovirtEngineHistoryDbPassword=
17c17
< ovirtEngineDbUser=engine
---
> ovirtEngineDbUser=postgres
19,27c19
< ovirtEngineDbPassword=passw0rd
<
< #Connection Definition to Engine Health Status Portal
< ## Connection Protocol (SSL or Unencrypted)
< ovirtEnginePortalConnectionProtocol=https
< ## Portal Address (JBoss' Location)
< ovirtEnginePortalAddress=tekkaman.localdomain.local
< ## Portal Port (JBoss' Port)
< ovirtEnginePortalPort=443
---
> ovirtEngineDbPassword=
43d34
< etlVersion=3.3.2
the password lines were encrypted during upgrade; previously there was
plain password.
And also etlVersion that contained 3.2 now contains current version
So I presume it wwent ok
Gianluca
10 years, 10 months
[Users] Storage unresponsive after sanlock
by Trey Dockendorf
I setup my first oVirt instance since 3.0 a few days ago and it went
very well, and I left the single host cluster running with 1 VM over
the weekend. Today I come back and the primary data storage is marked
as unresponsive. The logs are full of entries [1] that look very
similar to a knowledge base article on RHEL's website [2].
This setup is using NFS over RDMA and so far the ib interfaces report
no errors (via `ibcheckerrs -v <LID> 1`). Based on a doc on ovirt
site [3] it seems this could be due to response problems. The storage
system is a new purchase and not yet in production so if there's any
advice on how to track down the cause that would be very helpful.
Please let me know what additional information would be helpful as
it's been about a year since I've been active in the oVirt community.
Thanks
- Trey
[1]: http://pastebin.com/yRpSLKxJ
[2]: https://access.redhat.com/site/solutions/400463
[3]: http://www.ovirt.org/SANLock
10 years, 10 months
[Users] How to setup FreeBSD 8.3 Guest on oVirt 3.3
by Dresel Christopher
--_000_9B9655665ED7604FA398BAA731A9059E2CE5D61EVERENA5fhwnacat_
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
SGksDQoNCknigJltIHVzaW5nIG9WaXJ0IDMuMyBhbmQgdHJ5aW5nIHRvIHNldHVwIGEgRnJlZUJT
RCA4LjMgR3Vlc3QgbWFjaGluZS4gVGhlIG1hY2hpbmUgaGFuZ3MgYWZ0ZXIgdGhlIGJvb3Rpbmcg
c2NyZWVuIC0gIEkgYWxyZWFkeSBnb29nbGVkIGFib3V0IHRoaXMsIGJ1dCBkaWRu4oCZdCBmaW5k
IGFueSBoZWxwZnVsIGFydGljbGVzLg0KDQpDbHVzdGVyIHVzZXMg4oCcSW50ZWwgUGVucnluIEZh
bWlseeKAnCwgdGhlIFZNIGlzIGNvbmZpZ3VyZWQgd2l0aCAxIHZpcnR1YWwgQ1BVIGFzIHN1Z2dl
c3RlZCBpbiBvbmUgb2YgdGhlIHRocmVhZHMgSSBmb3VuZCBvbiB0aGUgaW50ZXJuZXQuDQoNClN0
aWxsIG5vIGx1Y2sgOi8NCg0KX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18NCg0KRmFj
aGhvY2hzY2h1bGUgV2llbmVyIE5ldXN0YWR0IGbDvHIgV2lydHNjaGFmdCB1bmQgVGVjaG5payBH
ZXMubS5iLkguDQpVbml2ZXJzaXR5IG9mIEFwcGxpZWQgU2NpZW5jZXMgV2llbmVyIE5ldXN0YWR0
IGZvciBCdXNpbmVzcyBhbmQgRW5naW5lZXJpbmcgTHRkLiwgQXVzdHJpYQ0KSm9oYW5uZXMgR3V0
ZW5iZXJnLVN0cmHDn2UgMw0KMjcwMCBXaWVuZXIgTmV1c3RhZHQNCkF1c3RyaWEsIEV1cm9wZQ0K
QVRVOiAzNzc3MjQwNg0KRmlybWVuYnVjaG51bW1lcjogNzcwMDV2DQpGaXJtZW5idWNoZ2VyaWNo
dDogTGFuZGVzZ2VyaWNodCBXaWVuZXIgTmV1c3RhZHQNCkRWUjogMDc2OTY2NQ0KRGVyIEluaGFs
dCBkaWVzZXMgRS1NYWlscyBpc3QgYXVzc2NobGllc3NsaWNoIGZ1ZXIgZGVuIGJlemVpY2huZXRl
biBBZHJlc3NhdGVuIGJlc3RpbW10LiBKZWRlIEZvcm0gZGVyIEtlbm50bmlzbmFobWUsIFZlcm9l
ZmZlbnRsaWNodW5nLCBWZXJ2aWVsZmFlbHRpZ3VuZyBvZGVyIFdlaXRlcmdhYmUgZGVzIEluaGFs
dHMgZGllc2VzIEUtTWFpbHMgZHVyY2ggdW5iZXJlY2h0aWd0ZSBEcml0dGUgaXN0IHVuenVsYWVz
c2lnLiBXaXIgYml0dGVuIFNpZSwgc2ljaCBtaXQgZGVtIEFic2VuZGVyIGRlcyBFLU1haWxzIGlu
IFZlcmJpbmR1bmcgenUgc2V0emVuLCBmYWxscyBTaWUgbmljaHQgZGVyIEFkcmVzc2F0IGRpZXNl
cyBFLU1haWxzIHNpbmQgdW5kIGRhcyBNYXRlcmlhbCB2b24gSWhyZW0gQ29tcHV0ZXIgenUgbG9l
c2NoZW4uDQoNClRoaXMgZS1tYWlsIGFuZCBhbnkgYXR0YWNobWVudHMgYXJlIGNvbmZpZGVudGlh
bCBhbmQgaW50ZW5kZWQgc29sZWx5IGZvciB0aGUgYWRkcmVzc2VlLiBUaGUgcGVydXNhbCwgcHVi
bGljYXRpb24sIGNvcHlpbmcgb3IgZGlzc2VtaW5hdGlvbiBvZiB0aGUgY29udGVudHMgb2YgdGhp
cyBlLW1haWwgYnkgdW5hdXRob3Jpc2VkIHRoaXJkIHBhcnRpZXMgaXMgcHJvaGliaXRlZC4gSWYg
eW91IGFyZSBub3QgdGhlIGludGVuZGVkIHJlY2lwaWVudCBvZiB0aGlzIGUtbWFpbCwgcGxlYXNl
IGRlbGV0ZSBpdCBhbmQgaW1tZWRpYXRlbHkgbm90aWZ5IHRoZSBzZW5kZXIuDQo=
--_000_9B9655665ED7604FA398BAA731A9059E2CE5D61EVERENA5fhwnacat_
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: base64
PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy
bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt
YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj
cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv
VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg
Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv
ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl
PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6
IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m
YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy
IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws
IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBjbTsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ
Zm9udC1zaXplOjExLjBwdDsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsInNhbnMtc2VyaWYiOw0K
CW1zby1mYXJlYXN0LWxhbmd1YWdlOkVOLVVTO30NCmE6bGluaywgc3Bhbi5Nc29IeXBlcmxpbmsN
Cgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCWNvbG9yOiMwNTYzQzE7DQoJdGV4dC1kZWNvcmF0
aW9uOnVuZGVybGluZTt9DQphOnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9sbG93ZWQNCgl7
bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCWNvbG9yOiM5NTRGNzI7DQoJdGV4dC1kZWNvcmF0aW9u
OnVuZGVybGluZTt9DQpzcGFuLkVtYWlsU3R5bGUxNw0KCXttc28tc3R5bGUtdHlwZTpwZXJzb25h
bC1jb21wb3NlOw0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIiwic2Fucy1zZXJpZiI7DQoJY29sb3I6
d2luZG93dGV4dDt9DQouTXNvQ2hwRGVmYXVsdA0KCXttc28tc3R5bGUtdHlwZTpleHBvcnQtb25s
eTsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsInNhbnMtc2VyaWYiOw0KCW1zby1mYXJlYXN0LWxh
bmd1YWdlOkVOLVVTO30NCkBwYWdlIFdvcmRTZWN0aW9uMQ0KCXtzaXplOjYxMi4wcHQgNzkyLjBw
dDsNCgltYXJnaW46NzAuODVwdCA3MC44NXB0IDIuMGNtIDcwLjg1cHQ7fQ0KZGl2LldvcmRTZWN0
aW9uMQ0KCXtwYWdlOldvcmRTZWN0aW9uMTt9DQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5
XT48eG1sPg0KPG86c2hhcGVkZWZhdWx0cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0iMTAyNiIgLz4N
CjwveG1sPjwhW2VuZGlmXS0tPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVsYXlv
dXQgdjpleHQ9ImVkaXQiPg0KPG86aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+DQo8L286
c2hhcGVsYXlvdXQ+PC94bWw+PCFbZW5kaWZdLS0+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJERS1B
VCIgbGluaz0iIzA1NjNDMSIgdmxpbms9IiM5NTRGNzIiPg0KPGRpdiBjbGFzcz0iV29yZFNlY3Rp
b24xIj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkhpLDxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9
Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48
c3BhbiBsYW5nPSJFTi1VUyI+SeKAmW0gdXNpbmcgb1ZpcnQgMy4zIGFuZCB0cnlpbmcgdG8gc2V0
dXAgYSBGcmVlQlNEIDguMyBHdWVzdCBtYWNoaW5lLiBUaGUgbWFjaGluZSBoYW5ncyBhZnRlciB0
aGUgYm9vdGluZyBzY3JlZW4gLSAmbmJzcDtJIGFscmVhZHkgZ29vZ2xlZCBhYm91dCB0aGlzLCBi
dXQgZGlkbuKAmXQgZmluZCBhbnkgaGVscGZ1bCBhcnRpY2xlcy48bzpwPjwvbzpwPjwvc3Bhbj48
L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+PG86cD4mbmJzcDs8
L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMi
PkNsdXN0ZXIgdXNlcyDigJxJbnRlbCBQZW5yeW4gRmFtaWx54oCcLCB0aGUgVk0gaXMgY29uZmln
dXJlZCB3aXRoIDEgdmlydHVhbCBDUFUgYXMgc3VnZ2VzdGVkIGluIG9uZSBvZiB0aGUgdGhyZWFk
cyBJIGZvdW5kIG9uIHRoZSBpbnRlcm5ldC48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFz
cz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+
PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMiPlN0aWxsIG5vIGx1
Y2sgOi88bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8L2Rpdj4NCjxicj4NCjxocj4NCjxmb250IGZh
Y2U9IlZlcmRhbmEiIGNvbG9yPSJHcmF5IiBzaXplPSIxIj48YnI+DQpGYWNoaG9jaHNjaHVsZSBX
aWVuZXIgTmV1c3RhZHQgZsO8ciBXaXJ0c2NoYWZ0IHVuZCBUZWNobmlrIEdlcy5tLmIuSC48YnI+
DQpVbml2ZXJzaXR5IG9mIEFwcGxpZWQgU2NpZW5jZXMgV2llbmVyIE5ldXN0YWR0IGZvciBCdXNp
bmVzcyBhbmQgRW5naW5lZXJpbmcgTHRkLiwgQXVzdHJpYTxicj4NCkpvaGFubmVzIEd1dGVuYmVy
Zy1TdHJhw59lIDM8YnI+DQoyNzAwIFdpZW5lciBOZXVzdGFkdDxicj4NCkF1c3RyaWEsIEV1cm9w
ZTxicj4NCkFUVTogMzc3NzI0MDY8YnI+DQpGaXJtZW5idWNobnVtbWVyOiA3NzAwNXY8YnI+DQpG
aXJtZW5idWNoZ2VyaWNodDogTGFuZGVzZ2VyaWNodCBXaWVuZXIgTmV1c3RhZHQ8YnI+DQpEVlI6
IDA3Njk2NjU8YnI+DQpEZXIgSW5oYWx0IGRpZXNlcyBFLU1haWxzIGlzdCBhdXNzY2hsaWVzc2xp
Y2ggZnVlciBkZW4gYmV6ZWljaG5ldGVuIEFkcmVzc2F0ZW4gYmVzdGltbXQuIEplZGUgRm9ybSBk
ZXIgS2VubnRuaXNuYWhtZSwgVmVyb2VmZmVudGxpY2h1bmcsIFZlcnZpZWxmYWVsdGlndW5nIG9k
ZXIgV2VpdGVyZ2FiZSBkZXMgSW5oYWx0cyBkaWVzZXMgRS1NYWlscyBkdXJjaCB1bmJlcmVjaHRp
Z3RlIERyaXR0ZSBpc3QgdW56dWxhZXNzaWcuIFdpciBiaXR0ZW4gU2llLA0KIHNpY2ggbWl0IGRl
bSBBYnNlbmRlciBkZXMgRS1NYWlscyBpbiBWZXJiaW5kdW5nIHp1IHNldHplbiwgZmFsbHMgU2ll
IG5pY2h0IGRlciBBZHJlc3NhdCBkaWVzZXMgRS1NYWlscyBzaW5kIHVuZCBkYXMgTWF0ZXJpYWwg
dm9uIElocmVtIENvbXB1dGVyIHp1IGxvZXNjaGVuLjxicj4NCjxicj4NClRoaXMgZS1tYWlsIGFu
ZCBhbnkgYXR0YWNobWVudHMgYXJlIGNvbmZpZGVudGlhbCBhbmQgaW50ZW5kZWQgc29sZWx5IGZv
ciB0aGUgYWRkcmVzc2VlLiBUaGUgcGVydXNhbCwgcHVibGljYXRpb24sIGNvcHlpbmcgb3IgZGlz
c2VtaW5hdGlvbiBvZiB0aGUgY29udGVudHMgb2YgdGhpcyBlLW1haWwgYnkgdW5hdXRob3Jpc2Vk
IHRoaXJkIHBhcnRpZXMgaXMgcHJvaGliaXRlZC4gSWYgeW91IGFyZSBub3QgdGhlIGludGVuZGVk
IHJlY2lwaWVudCBvZiB0aGlzDQogZS1tYWlsLCBwbGVhc2UgZGVsZXRlIGl0IGFuZCBpbW1lZGlh
dGVseSBub3RpZnkgdGhlIHNlbmRlci48YnI+DQo8L2ZvbnQ+DQo8L2JvZHk+DQo8L2h0bWw+DQo=
--_000_9B9655665ED7604FA398BAA731A9059E2CE5D61EVERENA5fhwnacat_--
10 years, 10 months
