7:11 p.m.
------=_Part_37643342_929927371.1494519067933
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Hello,=20
Not sure if I should post here, or on the dev mailling list.=20
I had a serious problem when upgrading an oVirt cluster from 3.6 to 4.0 (be=
fore updating to 4.1)=20
The error on engine-setup log was :=20
"schema.sh: FATAL: Cannot execute sql command: --file=3D/usr/share/ovirt-en=
gine/dbscripts/upgrade/04_00_0930_disallow_boot_protocol_to_be_null.sql"=20
After long hours of debuguing and analysing I found out the problem. On dat=
abase, some entries on table network_attachements had a NULL value which we=
re incompatible with the sql file above.=20
I'm guessing this is an "exotic situation" which shouldn't exist... in
theo=
ry ;)=20
Anyway, I'm fairly sure that the solution for this problem would be to patc=
h the following file 'ovirt-engine/packaging/dbscripts/upgrade/04_00_0910_d=
o_not_allow_null_boot_protocol.sql'=20
by adding the following line " update network_attachments set boot_protocol=
=3D ' NONE ' where boot_protocol is null ;"=20
If a dev want to discuss it further, I'll be happy to explain my thoughts o=
n this matter.=20
cordialement, regards,=20
=09Nelson LAMEIRAS=20
Ing=C3=A9nieur Syst=C3=A8mes et R=C3=A9seaux / Systems and Networks enginee=
r=20
Tel: +33 5 32 09 09 70=20
nelson.lameiras(a)lyra-network.com=20
www.lyra-network.com | www.payzen.eu=20
=09
=09
=09
Lyra Network, 109 rue de l'innovation, 31670 Lab=C3=A8ge, FRANCE=20
------=_Part_37643342_929927371.1494519067933
Content-Type: multipart/related;
boundary="----=_Part_37643343_1124091921.1494519067933"
------=_Part_37643343_1124091921.1494519067933
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><body><div style=3D"font-family: arial, helvetica, sans-serif;
font-s=
ize: 12pt; color:
#000000"><div>Hello,<br></div><div><br
data-mce-bogus=3D"=
1"></div><div>Not sure if I should post here, or on the dev mailling
list.<=
br data-mce-bogus=3D"1"></div><div><br
data-mce-bogus=3D"1"></div><div>I ha=
d a serious problem when upgrading an oVirt cluster from 3.6 to 4.0 (before=
updating to 4.1)<br data-mce-bogus=3D"1"></div><div><br
data-mce-bogus=3D"=
1"></div><div>The error on engine-setup log was : <br
data-mce-bogus=3D"1">=
</div><div>"schema.sh: FATAL: Cannot execute sql command:
--file=3D/usr/sha=
re/ovirt-engine/dbscripts/upgrade/04_00_0930_disallow_boot_protocol_to_be_n=
ull.sql"<br data-mce-bogus=3D"1"></div><div><br
data-mce-bogus=3D"1"></div>=
<div>After long hours of debuguing and analysing I found out the problem. O=
n database, some entries on table network_attachements had a NULL value whi=
ch were incompatible with the sql file above.<br
data-mce-bogus=3D"1"></div=
<div>I'm guessing this is an "exotic situation"
which shouldn't exist... i=
n theory ;)<br
data-mce-bogus=3D"1"></div><div><br></div><div>Anyway,
I'm f=
airly sure that the solution for this problem would be to patch the followi=
ng file 'ovirt-engine/packaging/dbscripts/upgrade/04_00_0910_do_not_allow_n=
ull_boot_protocol.sql' </div><div>by adding the following line
"<span class=
=3D"pl-k">update</span> network_attachments <span
class=3D"pl-k">set</span>=
boot_protocol<span class=3D"pl-k">=3D</span><span
class=3D"pl-s"><span cla=
ss=3D"pl-pds">'</span>NONE<span
class=3D"pl-pds">'</span></span> <span clas=
s=3D"pl-k">where</span> boot_protocol is <span
class=3D"pl-k">null</span>;"=
<br data-mce-bogus=3D"1"></div><div><br
data-mce-bogus=3D"1"></div><div>If =
a dev want to discuss it further, I'll be happy to explain my thoughts on t=
his matter. <br data-mce-bogus=3D"1"></div><div><br
data-mce-bogus=3D"1"></=
div><div data-marker=3D"__SIG_PRE__"><div>cordialement,
regards,</div><div>=
<br data-mce-bogus=3D"1"></div><table style=3D"margin: 0px;
table-layout: f=
ixed; border: none; width: 345pt; padding: 0px;" data-mce-style=3D"margin: =
0px; table-layout: fixed; border: none; width: 345pt; padding: 0px;" width=
=3D"460" cellspacing=3D"0" cellpadding=3D"0"
border=3D"0"><tbody><tr><td st=
yle=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2=
b3c7a; line-height: 16px; width: 86.25pt; text-align: left;" data-mce-style=
=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c=
7a; line-height: 16px; width: 86.25pt; text-align: left;" width=3D"115"
val=
ign=3D"top"><a href=3D"https://www.lyra-network.com/"
style=3D"border: none=
; text-decoration: none; width: 100%; display: block; clear: both;" data-mc=
e-href=3D"https://www.lyra-network.com/" data-mce-style=3D"border: none;
te=
xt-decoration: none; width: 100%; display: block; clear: both;"><img src=3D=
"cid:1db6da5091d14a0982ffcf8c4fef8a46b32a3417@zimbra" alt=3D""
data-mce-src=
=3D"/home/admin(a)lyra-network.com/corporate-documents/element-signature_logo=
_lyra_115x94.jpg" doc=3D"corporate-documents/element-signature_logo_lyra_11=
5x94.jpg" height=3D"94" width=3D"115"
border=3D"0"></a><br data-mce-bogus=
=3D"1"></td><td style=3D"margin: 0; font-size: 11px;
font-family: Arial,san=
s-serif; color: #2b3c7a; line-height: 16px; width: 258.75pt;" data-mce-styl=
e=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3=
c7a; line-height: 16px; width: 258.75pt;" width=3D"345"
valign=3D"top"><tab=
le style=3D"margin: 0; width: 258.75pt; table-layout: fixed; border: none;"=
data-mce-style=3D"margin: 0; width: 258.75pt; table-layout: fixed; border:=
none;" width=3D"345" cellspacing=3D"0"
cellpadding=3D"0" border=3D"0"><tbo=
dy><tr><td style=3D"font-size: 16px; font-family: Arial,sans-serif;
color: =
#2b3c7a; line-height: 18px; font-weight: bold;" data-mce-style=3D"font-size=
: 16px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 18px; f=
ont-weight: bold;">Nelson LAMEIRAS</td></tr><tr><td
style=3D"font-family: A=
rial,sans-serif; color: #2b3c7a; font-size: 11px; line-height: 16px;" data-=
mce-style=3D"font-family: Arial,sans-serif; color: #2b3c7a; font-size: 11px=
; line-height: 16px;">Ing=C3=A9nieur Syst=C3=A8mes et R=C3=A9seaux<span sty=
le=3D"font-family: Arial,sans-serif; color: #337ab7; font-size: 11px;" data=
-mce-style=3D"font-family: Arial,sans-serif; color: #337ab7; font-size: 11p=
x;"> / Systems and Networks
engineer</span></td></tr><tr><td style=3D"line-=
height: 16px; font-family: 'Arial',sans-serif; color: #2b3c7a; font-size: 1=
1px;" data-mce-style=3D"line-height: 16px; font-family:
'Arial',sans-serif;=
color: #2b3c7a; font-size: 11px;"><span style=3D"font-family:
Arial,sans-s=
erif; color: #2b3c7a; font-size: 11px;" data-mce-style=3D"font-family: Aria=
l,sans-serif; color: #2b3c7a; font-size: 11px;">Tel: +33 5 32 09 09 70</spa=
n></td></tr><tr><td style=3D"line-height: 16px; font-family:
'Arial',sans-s=
erif; color: #2b3c7a; font-size: 11px;" data-mce-style=3D"line-height: 16px=
; font-family: 'Arial',sans-serif; color: #2b3c7a; font-size: 11px;"><a
hre=
f=3D"mailto:nelson.lameiras@lyra-network.com" style=3D"font-size: 11px;
fon=
t-family: Arial,sans-serif; line-height: 16px; text-decoration: none;" data=
-mce-href=3D"mailto:nelson.lameiras@lyra-network.com"
data-mce-style=3D"fon=
t-size: 11px; font-family: Arial,sans-serif; line-height: 16px; text-decora=
tion: none;">nelson.lameiras(a)lyra-network.com</a><br
data-mce-bogus=3D"1"><=
/td></tr><tr><td style=3D"line-height: 16px; font-family:
'Arial',sans-seri=
f; color: #2b3c7a; font-size: 11px;" data-mce-style=3D"line-height: 16px; f=
ont-family: 'Arial',sans-serif; color: #2b3c7a; font-size: 11px;"><a
href=
=3D"https://www.lyra-network.com/" style=3D"font-size: 11px; font-family:
A=
rial,sans-serif; line-height: 16px; border: none; text-decoration: none;" d=
ata-mce-href=3D"https://www.lyra-network.com/"
data-mce-style=3D"font-size:=
11px; font-family: Arial,sans-serif; line-height: 16px; border: none; text=
-decoration: none;">www.lyra-network.com</a> <a
href=3D"https://payzen.eu" =
style=3D"font-size: 11px; font-family: Arial,sans-serif; line-height: 16px;=
border: none; text-decoration: none;" data-mce-href=3D"https://payzen.eu"
=
data-mce-style=3D"font-size: 11px; font-family: Arial,sans-serif; line-heig=
ht: 16px; border: none; text-decoration: none;"> | www.payzen.eu</a><br
dat=
a-mce-bogus=3D"1"></td></tr></tbody></table></td></tr></tbody></table><tabl=
e style=3D"margin: 0; table-layout: fixed; border: none; width: 345pt;" dat=
a-mce-style=3D"margin: 0; table-layout: fixed; border: none; width: 345pt;"=
width=3D"460" cellspacing=3D"0"
cellpadding=3D"0"><tbody><tr><td style=3D"=
margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; =
line-height: 16px; width: 24pt; text-align: left;" data-mce-style=3D"margin=
: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-h=
eight: 16px; width: 24pt; text-align: left;" width=3D"32"
valign=3D"top"><a=
href=3D"https://www.youtube.com/channel/UCrVl1CO_Jlu3KbiRH-tQ_vA" style=3D=
"border: none; text-decoration: none; margin: 0; float: left; display: inli=
ne-block; width: 32px;" data-mce-href=3D"https://www.youtube.com/channel/UC=
rVl1CO_Jlu3KbiRH-tQ_vA" data-mce-style=3D"border: none; text-decoration: no=
ne; margin: 0; float: left; display: inline-block; width: 32px;"><img src=
=3D"cid:99ac6520e8e3715f40f650ce0d5f88a03a9bd713@zimbra" alt=3D""
data-mce-=
src=3D"/home/admin(a)lyra-network.com/corporate-documents/element-signature_l=
ogo_YouTube_32x28.jpg" doc=3D"corporate-documents/element-signature_logo_Yo=
uTube_32x28.jpg" height=3D"28" width=3D"32"
border=3D"0"></a><br data-mce-b=
ogus=3D"1"></td><td style=3D"margin: 0; font-size: 11px;
font-family: Arial=
,sans-serif; color: #2b3c7a; line-height: 16px; width: 30.75pt; text-align:=
left;" data-mce-style=3D"margin: 0; font-size: 11px; font-family: Arial,sa=
ns-serif; color: #2b3c7a; line-height: 16px; width: 30.75pt; text-align: le=
ft;" width=3D"41" valign=3D"top"><a
href=3D"https://www.linkedin.com/compan=
y/lyra-network_2" style=3D"border: none; text-decoration: none; margin: 0; =
float: left; display: inline-block; width: 41px;" data-mce-href=3D"https://=
www.linkedin.com/company/lyra-network_2" data-mce-style=3D"border: none; te=
xt-decoration: none; margin: 0; float: left; display: inline-block; width: =
41px;"><img
src=3D"cid:a70d2dafceb98e64513f5a16b7d3ea0ab5a0f1f5@zimbra" dat=
a-mce-src=3D"/home/admin(a)lyra-network.com/corporate-documents/element-signa=
ture_logo_LinkedIn_41x28.jpg" doc=3D"corporate-documents/element-signature_=
logo_LinkedIn_41x28.jpg" height=3D"28" width=3D"41"
border=3D"0"></a><br da=
ta-mce-bogus=3D"1"></td><td style=3D"margin: 0; font-size:
11px; font-famil=
y: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 31.5pt; text=
-align: left;" data-mce-style=3D"margin: 0; font-size: 11px; font-family: A=
rial,sans-serif; color: #2b3c7a; line-height: 16px; width: 31.5pt; text-ali=
gn: left;" width=3D"42" valign=3D"top"><a
href=3D"https://twitter.com/LyraN=
etwork" style=3D"border: none; text-decoration: none; margin: 0; float: lef=
t; display: inline-block; width: 42px;" data-mce-href=3D"https://twitter.co=
m/LyraNetwork" data-mce-style=3D"border: none; text-decoration: none; margi=
n: 0; float: left; display: inline-block; width: 42px;"><img
src=3D"cid:a99=
4fe545de6341d6b369e33bbb18605bbbcef66@zimbra" alt=3D""
data-mce-src=3D"/hom=
e/admin(a)lyra-network.com/corporate-documents/element-signature_logo_Twitter=
_42x28.jpg" doc=3D"corporate-documents/element-signature_logo_Twitter_42x28=
.jpg" height=3D"28" width=3D"42"
border=3D"0"></a><br data-mce-bogus=3D"1">=
</td><td style=3D"margin: 0; font-size: 11px; font-family:
Arial,sans-serif=
; color: #2b3c7a; line-height: 16px; width: 258.75pt; text-align: left;" da=
ta-mce-style=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; =
color: #2b3c7a; line-height: 16px; width: 258.75pt; text-align: left;" widt=
h=3D"345" valign=3D"top"><a href=3D"https://payzen.eu"
style=3D"border: non=
e; text-decoration: none; margin: 0; float: left; display: inline-block; wi=
dth: 61px;" data-mce-href=3D"https://payzen.eu"
data-mce-style=3D"border: n=
one; text-decoration: none; margin: 0; float: left; display: inline-block; =
width: 61px;"><img
src=3D"cid:86ad24eaa2a146e1b7ee93db04f055468345dc13@zimb=
ra" alt=3D""
data-mce-src=3D"/home/admin(a)lyra-network.com/corporate-documen=
ts/element-signature_payzen_61x28.jpg" doc=3D"corporate-documents/element-s=
ignature_payzen_61x28.jpg" height=3D"28" width=3D"61"
border=3D"0"></a><br =
data-mce-bogus=3D"1"></td></tr></tbody></table><table
style=3D"margin: 0; t=
able-layout: fixed; border: none; width: 345pt;" data-mce-style=3D"margin: =
0; table-layout: fixed; border: none; width: 345pt;" width=3D"460"
cellspac=
ing=3D"0" cellpadding=3D"0"><tbody><tr><td><hr
style=3D"background: #293b79=
none repeat scroll 0% 0%; width: 100%; height: 4px; color: #293b79; margin=
: 0px;" data-mce-style=3D"background: #293b79 none repeat scroll 0% 0%; wid=
th: 100%; height: 4px; color: #293b79; margin:
0px;"></td></tr></tbody></ta=
ble><table style=3D"margin: 0; table-layout: fixed; border: none; width: 34=
5pt;" data-mce-style=3D"margin: 0; table-layout: fixed; border: none; width=
: 345pt;" width=3D"460" cellspacing=3D"0"
cellpadding=3D"0"><tbody><tr><td =
style=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: =
#2b3c7a; line-height: 16px; width: 30.75pt; text-align: left;" data-mce-sty=
le=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b=
3c7a; line-height: 16px; width: 30.75pt; text-align: left;"><div>Lyra
Netwo=
rk, 109 rue de l'innovation, 31670 Lab=C3=A8ge,
FRANCE</div></td></tr></tbo=
dy></table><div><br></div></div></div></body></html>
------=_Part_37643343_1124091921.1494519067933
Content-Type: image/jpeg; name=element-signature_logo_lyra_115x94.jpg
Content-Disposition: attachment;
filename=element-signature_logo_lyra_115x94.jpg
Content-Transfer-Encoding: base64
Content-ID: <1db6da5091d14a0982ffcf8c4fef8a46b32a3417@zimbra>
/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QOBaHR0cDov
L25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENl
aGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4
OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzEzMiA3OS4xNTkyODQsIDIwMTYvMDQvMTktMTM6
MTM6NDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5
OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHht
bG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0i
aHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1sbnM6eG1w
PSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bXBNTTpPcmlnaW5hbERvY3VtZW50SUQ9
InhtcC5kaWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1LTgxYmQtMTYwMTFjZjk5YWVjIiB4bXBNTTpEb2N1
bWVudElEPSJ4bXAuZGlkOkU1QUU4Nzk1OEExMzExRTZBNTFCRjVENEYyNDYxNTQ1IiB4bXBNTTpJ
bnN0YW5jZUlEPSJ4bXAuaWlkOkU1QUU4Nzk0OEExMzExRTZBNTFCRjVENEYyNDYxNTQ1IiB4bXA6
Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDQyAyMDE1LjUgKFdpbmRvd3MpIj4gPHhtcE1N
OkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1
LTgxYmQtMTYwMTFjZjk5YWVjIiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOmRkMGY5MmM1LTc4
YWYtY2U0NS04MWJkLTE2MDExY2Y5OWFlYyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRG
PiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv/uAA5BZG9iZQBkwAAAAAH/2wCEAAYE
BAQFBAYFBQYJBgUGCQsIBgYICwwKCgsKCgwQDAwMDAwMEAwODxAPDgwTExQUExMcGxsbHB8fHx8f
Hx8fHx8BBwcHDQwNGBAQGBoVERUaHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f
Hx8fHx8fHx8fHx8fH//AABEIAF4AcwMBEQACEQEDEQH/xACdAAEBAAIDAQEAAAAAAAAAAAAACAUH
AgMGBAEBAQADAQEAAAAAAAAAAAAAAAACBAUBAxAAAAUDAgAHDQcCBwAAAAAAAAECAwQRBQYSByFR
E7RWFzcxQSKS0nOT03RVlQgYYXEyQiMUFYEzsVJicmODOBEAAgECAwcEAgIDAAAAAAAAAAECEQNR
EwQhgbESMlIzMUGhFHEVwQUiQzT/2gAMAwEAAhEDEQA/AKpAE9b/AGQZdF3FtNpsd4l29M2DHSll
iS6w0bzsp5slqJCiLvERnTuENTRQg7bckntK15vmojj1WfMP0rc+Jy/JD7Fjt+EMueJ6bbnBN4bR
lkWdkt+XPtDaHSfjKnSHyUpTZkg+TcLSdFGRjyv3rUo0iqP8EoQkntZ7fcOy5VdrXGYxuccGW2+S
3nCecYq3oUWnU2RmfhGXAPPSXLcJNzVVT8kNVbnKKUHRmppW1/zBOSXVtZS4lpSjNtP8nLKhfcSR
alqdPXp+ERhauKKTe38nX1WfMP0qc+Jy/JHPsWO34RPLniOqz5h+lTnxOX5IfYsdvwhlzxHVZ8w/
Spz4nL8kPsWO34Qy54jqs+YfpU58Tl+SH2LHb8IZc8R1WfMP0qc+Jy/JD7Fjt+EMueJ2bCX3MH9y
LxZr7eJdxKBCkoW0/JdfaJ5mUy2a0EszL/MRHTuGGshDLTiqVf8AAst81GUGMssgAAAAE5b89s+L
+zwefPDV0fhlv4FW71oo0ZRaAAAAAAAAAAAAACdtj+3DLfNXDn7I1dX4Y7uBWtdbKJGUWQAAAACc
t+e2fF/Z4PPnhq6Pwy38Crd60UaMotAAAAAAAAAAAAABO2x/bhlvmrhz9kaur8Md3ArWutlEjKLI
AAAABOW/PbPi/s8Hnzw1dH4Zb+BVu9aKNGUWjAKzrGk5cnEjkq/nVo5RMbk3NOnkzd/uU0fgKvdH
rky5eb2I86rQz48iQAAAAAAAAABO2x/bhlvmrhz9kaur8Md3ArWutlEjKLIAAAABOW/PbPi/s8Hn
zw1dH4Zb+BVu9aKNGUWjSD//AKkj+xnzJQ0V/wA2/wDkr/7D3e7GX5DiOMfzlniMTEMPIRORIJfg
tOeCladCk/nNJH94raa1GcuVnpck4qqOrJdz4dr2yazKOhDjkxhlUGMszop98i/TOlD/AE/CNX+0
x23p27nIJXKRqeeyjdnLMd27sGSzLdEO4Xd4uWifqkhDDiFut0qrUSzQlNa9wz7g9bemjK44puiI
yuNRTOzGs53hud+gvzsYjwMVnqNfLuqUTrEck69bitZmStPc1NJIz4hy5ZtKLpKskIzk36bDHRt2
9yMsuMw9v8ejybNBc5M5s5Rp5Uy4aEZuMJSai4dPCZFStBN6a3BLne1nMyT6Uffgu8GQ5DnysXuN
mbtZx461TG1ms3kyGiLWRHXToMz8Hg7nfMQvaWMYcydTsLjcqG2BSPYnbY/twy3zVw5+yNXV+GO7
gVrXWyiRlFkAAAAAnLfntnxf2eDz54auj8Mt/Aq3etFGjKLROmdZbAxL5g/5yey6/GjREJW2wSTc
M3YpoKms0F3VcY1bNpzscqKs5UnU9pad4cG3Fefw1UWXFO7x3mULkpaJJnoM6JNC10WREak/aXGK
8tLO1/ns2HorilsNTYzar/kOQWTa+5tmmBjk+W9cKGqimkrJS68RcCkoV/yC7clGMXcXrJI8Yptq
OBsj5oEpTiNmSRESSuKSJJFwUJlzgoKv9f1P8Hrf9Db1wh/vbVJh6tH7lhbOvi5RBpr/AEqKMXR1
PZrYaC2x3Jgbawp+IZjBkwpkWS480603rSslkRU7qTOuiqFlUlEfepw6WosO61ODK9ufLsZ27f36
RkG/8q9OwXbe3PgKciMPp0uHHS22hpxRf60o1f4VC9DlsUrWjEHWdSghllknbY/twy3zVw5+yNXV
+GO7gVrXWyiRlFkAAAAAnLfntnxf2eDz54auj8Mt/Aq3etFGjKLRxU00o6qQlR8ZkRhUGMyO7W7H
7FOvUpCSZgMrfMqERqNJeCgj41qokvtMTtxcpJL3OSdFU1n8vFimPwbrnF18O55DIXybhlw8ihZm
s08RLdqVOJJC5rZqqgvSJ42V7v3MpM3dTBnyWbtBQmHFnXFpLzdXOWjW9tWo2irwPpd0pWhVPBPU
R0qILTVWx+y+STuYmQj7sxHH1Kctb7NuahnMflKW2akk3J/bvGlojqtpv8ZuJP8ACR8Ag9M8dtTu
YdErdfEJTCZKrY/L5JSySbrbCdKmicdWRLeWlJK/bs8skq+ElSacJ8HVppr3OZiP2RuxFK4W5xi3
LK2T5D8NmY8baHHnWySSeTSa6to1K8JTumn3gtM6PbtQzDYYqnqTtsf24Zb5q4c/ZGrq/DHdwK1r
rZRIyiyAAAAATlvz2z4v7PB588NXR+GW/gVbvWijRlFoADGZHjVmyO2Ltd4YOTAcUlbjJLcbJRoO
qam2pCuA+GlROFxwdV6nJRT2M+q226DbLfHt8BkmIcRtLMdlNaJQgqEVTqZ/eYjKTbqwlQ5Hb4Bp
Uk4zRpUpa1FoTQ1uEaVqPg7qiUZGffDmYodSbNZ0toaTBjk02hbTaCaQSUtu/wBxCSpQkr/MXfHe
d4iiP12z2h5k2XYMdxlSkuKbW0hSTW2kkIUZGVKpSkiI+8RApPEURydtltdQpDsRlxCtepKm0mR8
qdXKkZfn/NxjnMxQ+kcOk7bH9uGW+auHP2Rq6vwx3cCta62USMosgAAAAE5b89s+L+zwefPDV0fh
lv4FW71oo0ZRaAAAAAAAAAAAAACdtj+3DLfNXDn7I1dX4Y7uBWtdbKJGUWQAAAACb9/3mWN4cbff
WTTLUWEt1xX4UpTNeNSj+wiGtolW1LfwKt7qRuTrY226RwfSkKH1rnaz3zI4jrZ226RwfSkH1rna
xmRxHWztt0jg+lIPrXO1jMjiOtnbbpHB9KQfWudrGZHEdbO23SOD6Ug+tc7WMyOJ+o3W24WtKE5F
CUpR0SknCqZmH1rnazjuxW2pnbTfbPeGnHbXMamNtK0OLaVqJKjKtDELlqUNklQ7C5GfS6mOu+f4
XZpy4F0vMWHMbJKlsOrJKyJRVTUvtIdjZnJVSOuaXqfF1sbbdI4PpSEvrXO1nMyOJp7YiQxJ3oyi
RHcS9Hejz3GXUcKVoVOZNKi+wyOovaxUsx3cDwtdbKNGUWgAAAADX+4GzGPZveWbtcpsuO+xGTFS
iObRINCFrcIz1oWdaun3xas6qVtUSR5ztKTqeZ+lrCvely8Zj1Q9f2M8EQyEPpawr3pcvGY9UH7G
eCGQh9LWFe9Ll4zHqg/YzwQyEPpawr3pcvGY9UH7GeCGQh9LWFe9Ll4zHqg/YzwQyEc2flfwxl5t
1NzuJqbUSiI1MUqX/UOr+xmn6I5LTRaaxNg4XhNuxOHIiwX3n0SXCdWb5pMyMk6eDSlPEPDU6mV5
pteg0+nVpNI8zm+xeNZfkDt7nzprEl5Dbam2FNEgibTpKmttR97jErWslCNEkTlaUnUwP0tYV70u
XjMeqHp+xngiOQj023+zGPYReXrtbZsuQ+/GVFUiQbRoJC1ocMy0IQdatF3x5XtVK4qNInC0oups
AVT0AAAAAAAAAAAAAAAAAAAAAAAAAAAAD//Z
------=_Part_37643343_1124091921.1494519067933
Content-Type: image/jpeg; name=element-signature_logo_YouTube_32x28.jpg
Content-Disposition: attachment;
filename=element-signature_logo_YouTube_32x28.jpg
Content-Transfer-Encoding: base64
Content-ID: <99ac6520e8e3715f40f650ce0d5f88a03a9bd713@zimbra>
/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QOBaHR0cDov
L25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENl
aGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4
OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzEzMiA3OS4xNTkyODQsIDIwMTYvMDQvMTktMTM6
MTM6NDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5
OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHht
bG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0i
aHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1sbnM6eG1w
PSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bXBNTTpPcmlnaW5hbERvY3VtZW50SUQ9
InhtcC5kaWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1LTgxYmQtMTYwMTFjZjk5YWVjIiB4bXBNTTpEb2N1
bWVudElEPSJ4bXAuZGlkOjQ1REY5Njk1OEExNzExRTY5OUVDOTI1QTU3QzAwNzI0IiB4bXBNTTpJ
bnN0YW5jZUlEPSJ4bXAuaWlkOjQ1REY5Njk0OEExNzExRTY5OUVDOTI1QTU3QzAwNzI0IiB4bXA6
Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDQyAyMDE1LjUgKFdpbmRvd3MpIj4gPHhtcE1N
OkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1
LTgxYmQtMTYwMTFjZjk5YWVjIiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOmRkMGY5MmM1LTc4
YWYtY2U0NS04MWJkLTE2MDExY2Y5OWFlYyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRG
PiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv/uAA5BZG9iZQBkwAAAAAH/2wCEAAYE
BAQFBAYFBQYJBgUGCQsIBgYICwwKCgsKCgwQDAwMDAwMEAwODxAPDgwTExQUExMcGxsbHB8fHx8f
Hx8fHx8BBwcHDQwNGBAQGBoVERUaHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f
Hx8fHx8fHx8fHx8fH//AABEIABwAIAMBEQACEQEDEQH/xAB5AAADAQEAAAAAAAAAAAAAAAAABwgF
BgEAAgMBAAAAAAAAAAAAAAAAAAQCAwUBEAABBAECBAUFAAAAAAAAAAABAgMEBQARBiESEwcxUdIU
CEEik1UYEQACAQMCBQUAAAAAAAAAAAAAAQIRAwQhMVFhEiITQaHBYhX/2gAMAwEAAhEDEQA/AKpw
AnD5Hbg3JA35XxKqxmxUPVrJEaI862FuqkPp4IbI5lHQDNXBhFwbaW4tebqcMIvfYjURtz6eesv1
YzWz9fYh38zR7eX2+mu5lHV3VhaNOe8aTJgTHnweVXEBba1cQRkb8IeNtJbHYN9WpW+YY2T53inQ
4HfzZk6a4lmHGaiOSHl8EoT7mSOZR+gBIzUxU3Yklz+Be4+9DRl30N3dMOxjbyro9EzHW3MqupHc
L7qlaoX1SsFvlHl44moPpa6XXiW113FPuu3qrT5I7dfrJLUxllMRl15hQWjqBbiuXmTqCQlQx23F
rHdSqTrNFFZlDAou7vZa43xuSNaw7CPFZZhIiKbeSsqKkOuuE/aCNNHcexspW40a9Sm5bcmcH/J1
5+0rvxOenGf0o8GQ8DN7ZXxzv9vbpqrhy0huMQJCHlstocBKU+ITqANcru50ZRao9SUbLTqPvMwv
DAAwAMAP/9k=
------=_Part_37643343_1124091921.1494519067933
Content-Type: image/jpeg; name=element-signature_logo_LinkedIn_41x28.jpg
Content-Disposition: attachment;
filename=element-signature_logo_LinkedIn_41x28.jpg
Content-Transfer-Encoding: base64
Content-ID: <a70d2dafceb98e64513f5a16b7d3ea0ab5a0f1f5@zimbra>
/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QOBaHR0cDov
L25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENl
aGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4
OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzEzMiA3OS4xNTkyODQsIDIwMTYvMDQvMTktMTM6
MTM6NDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5
OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHht
bG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0i
aHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1sbnM6eG1w
PSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bXBNTTpPcmlnaW5hbERvY3VtZW50SUQ9
InhtcC5kaWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1LTgxYmQtMTYwMTFjZjk5YWVjIiB4bXBNTTpEb2N1
bWVudElEPSJ4bXAuZGlkOjY2MEYzRTFGOEExNzExRTY5QzI5OUNGQkY1MzM2MUQ1IiB4bXBNTTpJ
bnN0YW5jZUlEPSJ4bXAuaWlkOjY2MEYzRTFFOEExNzExRTY5QzI5OUNGQkY1MzM2MUQ1IiB4bXA6
Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDQyAyMDE1LjUgKFdpbmRvd3MpIj4gPHhtcE1N
OkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1
LTgxYmQtMTYwMTFjZjk5YWVjIiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOmRkMGY5MmM1LTc4
YWYtY2U0NS04MWJkLTE2MDExY2Y5OWFlYyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRG
PiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv/uAA5BZG9iZQBkwAAAAAH/2wCEAAYE
BAQFBAYFBQYJBgUGCQsIBgYICwwKCgsKCgwQDAwMDAwMEAwODxAPDgwTExQUExMcGxsbHB8fHx8f
Hx8fHx8BBwcHDQwNGBAQGBoVERUaHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f
Hx8fHx8fHx8fHx8fH//AABEIABwAKQMBEQACEQEDEQH/xAB2AAEBAQEAAAAAAAAAAAAAAAAABggH
AQEAAwEAAAAAAAAAAAAAAAAAAwQFAhAAAQMEAgICAgMBAAAAAAAAAQIDBAARBQYhEjEHMghBE1Fh
IhcRAAICAQIDCQAAAAAAAAAAAAABAgMREgQxkTIhQVGhscETMxX/2gAMAwEAAhEDEQA/ANU0Bl33
zsuzQfZcmHj8tMiMKaihDLMl1psKcQkXslSUjk8mtjZ1xdeWkVbW9RDZ/ZN8wOXkYnI7LKMuL1Lq
o+RddaIWkLHVwLAPCuf4NWYVwksqPkcNtd5V+ldr2ef7MwkaZmJsqK6p/uy9JdcbUBGcULpUog8i
9Q7uuKreEjquT1GsKxC2KAUBk37B2/6y72t1tB7X8dbIvf8Aq3mtvZfVzKlvUWWw7Dr+Dfy8rCt4
d153Z8ew0FNx3kohuxmUyFtAfFPyBUOBz+arwhKWE89L9SRtLmTuns4xj7LLaxYaGNE6SYojlJZ6
rhLUf19f89eyj4qa1t7ft449ziPWairGLQoBQHFvZ/onObht0jNxclFjMPNtNpZdS4Vj9aAk36gj
mtDb7yMIaWiGdTbySSfqnsKbdctAFh1Fm3Bwfx8fFT/ox8GcfAyk9dfX7OapuGNzj+SiPRoJcKmG
kuBRDjS2x1uAPK71DfvYzg444nUKmnk7lWcTigFAKAUAoBQCgP/Z
------=_Part_37643343_1124091921.1494519067933
Content-Type: image/jpeg; name=element-signature_logo_Twitter_42x28.jpg
Content-Disposition: attachment;
filename=element-signature_logo_Twitter_42x28.jpg
Content-Transfer-Encoding: base64
Content-ID: <a994fe545de6341d6b369e33bbb18605bbbcef66@zimbra>
/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QOBaHR0cDov
L25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENl
aGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4
OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzEzMiA3OS4xNTkyODQsIDIwMTYvMDQvMTktMTM6
MTM6NDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5
OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHht
bG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0i
aHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1sbnM6eG1w
PSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bXBNTTpPcmlnaW5hbERvY3VtZW50SUQ9
InhtcC5kaWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1LTgxYmQtMTYwMTFjZjk5YWVjIiB4bXBNTTpEb2N1
bWVudElEPSJ4bXAuZGlkOjdDMkI3MjMyOEExNzExRTY5MDUyRTk1NEIyREUwNjVCIiB4bXBNTTpJ
bnN0YW5jZUlEPSJ4bXAuaWlkOjdDMkI3MjMxOEExNzExRTY5MDUyRTk1NEIyREUwNjVCIiB4bXA6
Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDQyAyMDE1LjUgKFdpbmRvd3MpIj4gPHhtcE1N
OkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1
LTgxYmQtMTYwMTFjZjk5YWVjIiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOmRkMGY5MmM1LTc4
YWYtY2U0NS04MWJkLTE2MDExY2Y5OWFlYyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRG
PiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv/uAA5BZG9iZQBkwAAAAAH/2wCEAAYE
BAQFBAYFBQYJBgUGCQsIBgYICwwKCgsKCgwQDAwMDAwMEAwODxAPDgwTExQUExMcGxsbHB8fHx8f
Hx8fHx8BBwcHDQwNGBAQGBoVERUaHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f
Hx8fHx8fHx8fHx8fH//AABEIABwAKgMBEQACEQEDEQH/xAB3AAEBAQEBAAAAAAAAAAAAAAAABwUI
BgEBAAMBAQAAAAAAAAAAAAAAAAMEBQIBEAABAwIEBwEBAQAAAAAAAAABAgMEAAUREhMGITFBFBUH
CIEiFhEAAgIBAgQHAAAAAAAAAAAAAAERAgMxBCHBEgVBUWGBQhMV/9oADAMBAAIRAxEAPwDC9g7u
3dH33uJiNeri2wxcJQQ01JfCUNodVwCUqwSlI/AK3sGKropS0Kd7OWZMXcPsyZDdnQ7he5UFhQQ/
LZelOMoURiEqWlRAOFdumNOGqyeTYtPzFfL1df8ASm5XCTP0ey0e5eceyZu4zZc5VhjlGOFZ/cKJ
dMKNeRNhbclzrOJxQCgOSW7o5a/oKXMRFXNT5iYw/EaAUtbL61tOBKTwXglWOXrW30zgj0RUmLlb
9p3rZ/r/ANd3GxWJtm3XC8B1EO2RsEqDkng88pAP8JSnEk8ugqlt6Xy5Fa3FImyNVUI8z8nJCU7o
SOSRAA/O5qbuXx9+Rxg8ToGsssCgFAc/7q+b9xXrc11u7V3iNN3CW/JbQUuhaUuuFYBIHMA9K08e
+rWqUPgivbC25MofK25Qoq81DKjwKlJeUT+kE13+jXyZ59DKX6a9WXPYfmO+msTPJdtp6AWMuhq4
5swHPVFVN1uFkiFoS46dJSqqEgoBQCgFAKAUAoBQH//Z
------=_Part_37643343_1124091921.1494519067933
Content-Type: image/jpeg; name=element-signature_payzen_61x28.jpg
Content-Disposition: attachment; filename=element-signature_payzen_61x28.jpg
Content-Transfer-Encoding: base64
Content-ID: <86ad24eaa2a146e1b7ee93db04f055468345dc13@zimbra>
/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QOBaHR0cDov
L25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENl
aGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4
OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzEzMiA3OS4xNTkyODQsIDIwMTYvMDQvMTktMTM6
MTM6NDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5
OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHht
bG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0i
aHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1sbnM6eG1w
PSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bXBNTTpPcmlnaW5hbERvY3VtZW50SUQ9
InhtcC5kaWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1LTgxYmQtMTYwMTFjZjk5YWVjIiB4bXBNTTpEb2N1
bWVudElEPSJ4bXAuZGlkOkU1NjczQjM2OEEzNDExRTZCOEJBQ0Y4Mzg3RTEzODkyIiB4bXBNTTpJ
bnN0YW5jZUlEPSJ4bXAuaWlkOkU1NjczQjM1OEEzNDExRTZCOEJBQ0Y4Mzg3RTEzODkyIiB4bXA6
Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDQyAyMDE1LjUgKFdpbmRvd3MpIj4gPHhtcE1N
OkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1
LTgxYmQtMTYwMTFjZjk5YWVjIiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOmRkMGY5MmM1LTc4
YWYtY2U0NS04MWJkLTE2MDExY2Y5OWFlYyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRG
PiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv/uAA5BZG9iZQBkwAAAAAH/2wCEAAYE
BAQFBAYFBQYJBgUGCQsIBgYICwwKCgsKCgwQDAwMDAwMEAwODxAPDgwTExQUExMcGxsbHB8fHx8f
Hx8fHx8BBwcHDQwNGBAQGBoVERUaHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f
Hx8fHx8fHx8fHx8fH//AABEIABwAPQMBEQACEQEDEQH/xABvAAABBAMAAAAAAAAAAAAAAAAAAQUG
BwIDBAEBAAAAAAAAAAAAAAAAAAAAABAAAQQABAQEAgsBAAAAAAAAAQIDBAUAERIGITETFEEiFQfS
I1FhcYGhMlIkRMQWhhEBAAAAAAAAAAAAAAAAAAAAAP/aAAwDAQACEQMRAD8AvqZ7q7OhzZMSS9IQ
Yjy2JT/avqZbW2rSvU6lBSACOeeAljLzTzSHmVhxpxIW24k5pUlQzBBHgRgM8BBJ9fKuvcGwr3La
wgxIlfGeaagyVsJ1uOOBRUBmOSRgI0bnZgfQwdx7qDrroYZSVzBrcJ0hKM2xq+7AWBU7PTXTEShc
2svRx6MuWp5o5gjigj68BombFRKmPyTfXTPXWpzoszloaRqOelCQPKkeAwEP6lp6f6V6vYaP9Z6b
3fcr7ntuhno6vPnxwGyohb2ntbpr6Y17NdKt7Bp5+YHlPJLitKyltI0KGk+XPANVgzV1Eyyqbe3s
IMmnhsMbVaYcebDraY+XVbQ15XXFOghQVnkMBkbjcVPTUs6M5IkPbnpWa1hKlrWG7QZBp0hROnUh
xRUfHTgJDWuwtsbptVTpC1xaqhgJfkuFTji9DjoKiTmpSlq/HAcO2d11d/cuXUySJG4C0+NvbfCH
CmK2hClHUop0GQ6E+dWfAeUYBi2lY2E+zgW7twhVlHDk+7AkzFO9u2lRdjORFIEZrTmAkA+GYwDl
TwLJhjZFouxsF3NzN6r7Lj7imExHUOSHWi0TpyCdORIzzwHT/J/7n+vgLVAA5YBChBUlRSCpOelR
HEZ88sA2WG3YVhb1lnJW4VVJcXFjAgM9VxOjqKTlmVJTnp48M8Ax2+3N3J3TJu6KVAbRKisxnWpr
brh+SpasxoKf14BBD91hxE2kB+nt5Px4AEL3VGoiZSAr4qyjyOP2+fAL2nuvw/e0vDl8iT8eAbv8
Lur0vPvYXrPrfrfU6bvb59Lp6NOev83HngLBwBgDAGAMAYAwBgP/2Q==
------=_Part_37643343_1124091921.1494519067933--
------=_Part_37643342_929927371.1494519067933--
8:40 a.m.
On Thu, May 11, 2017 at 7:11 PM, Nelson Lameiras <
nelson.lameiras(a)lyra-network.com> wrote:
Hello,
Not sure if I should post here, or on the dev mailling list.
I had a serious problem when upgrading an oVirt cluster from 3.6 to 4.0
(before updating to 4.1)
The error on engine-setup log was :
"schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-
engine/dbscripts/upgrade/04_00_0930_disallow_boot_protocol_to_be_null.sql"
After long hours of debuguing and analysing I found out the problem. On
database, some entries on table network_attachements had a NULL value which
were incompatible with the sql file above.
I'm guessing this is an "exotic situation" which shouldn't exist... in
theory ;)
Anyway, I'm fairly sure that the solution for this problem would be to
patch the following file 'ovirt-engine/packaging/
dbscripts/upgrade/04_00_0910_do_not_allow_null_boot_protocol.sql'
by adding the following line "update network_attachments set boot_protocol
='NONE' where boot_protocol is null;"
If a dev want to discuss it further, I'll be happy to explain my thoughts
on this matter.
Doing the above might be enough for engine-setup to finish, but it might
introduce a risk.
Ideally we should find the root cause leading to this state and:
1. Make sure it can't happen anymore
2. Fully fix the data - might require more than just the above update.
3. Alternatively, add a check earlier and notify the user to fix this
manually.
Adding Dan for further analysis.
Thanks for the report!
Best,
cordialement, regards,
<https://www.lyra-network.com/>
Nelson LAMEIRAS
Ingénieur Systèmes et Réseaux / Systems and Networks engineer
Tel: +33 5 32 09 09 70 <+33%205%2032%2009%2009%2070>
nelson.lameiras(a)lyra-network.com
www.lyra-network.com | www.payzen.eu <https://payzen.eu>
<https://www.youtube.com/channel/UCrVl1CO_Jlu3KbiRH-tQ_vA>
<https://www.linkedin.com/company/lyra-network_2>
<https://twitter.com/LyraNetwork>
<https://payzen.eu>
------------------------------
Lyra Network, 109 rue de l'innovation, 31670 Labège, FRANCE
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
--
Didi
2749
days inactive
2752
days old
1 comments
2 participants
participants (2)
-
Nelson Lameiras -
Yedidyah Bar David