January 2014 - Users - oVirt List Archives

[Users] vdsm-python-cpopen is obsoleted by python-cpopen
by Robert Story 31 Jan '14

31 Jan '14

--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--

2 2

[Users] engine-backup restore how to
by Steve Dainard 30 Jan '14

30 Jan '14

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.

3 6

Re: [Users] How to setup FreeBSD 8.3 Guest on oVirt 3.3
by Dresel Christopher 30 Jan '14

30 Jan '14

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.

2 2

[Users] Weird crash of oVirt-3.3.2-el6
by Joop 30 Jan '14

30 Jan '14

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

3 4

[Users] Error: "The following Network Interfaces were specified more than once:"
by Alan Murrell 30 Jan '14

30 Jan '14

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

3 6

[Users] two node ovirt cluster with HA
by Jaison peter 30 Jan '14

30 Jan '14

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

6 18

[Users] Ovirt 3.4 - Fail to set permissions to VM
by Jonas Israelsson 30 Jan '14

30 Jan '14

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)

3 3

[Users] engine reports and dwh setup in 3.3.2
by Gianluca Cecchi 29 Jan '14

29 Jan '14

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=shari… for reports: https://drive.google.com/file/d/0BwoPbcrMv8mvUWJmS1dFbTU1cTA/edit?usp=shari… 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=shari… 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

5 19

[Users] Storage unresponsive after sanlock
by Trey Dockendorf 29 Jan '14

29 Jan '14

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

2 5

[Users] How to setup FreeBSD 8.3 Guest on oVirt 3.3
by Dresel Christopher 29 Jan '14

29 Jan '14

--_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_--

3 2