<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Hi,</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">We are on postgres boat as well - and yes, UTF-8 is our default setting for all OpenStack databases.</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Cheers,</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">NM </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div> <div id="bloop_sign_1394554424258871040" class="bloop_sign"><span style="font-family:helvetica,arial;font-size:13px"></span>-- <br>Nick Maslov<br><span>Sent with Airmail</span></div> <br><p style="color:#000;">On March 10, 2014 at 11:25:39 PM, gustavo panizzo <gfa> (<a href="mailto:gfa@zumbi.com.ar">gfa@zumbi.com.ar</a>) wrote:</gfa></p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>adding -operators, removing -dev
<br>
<br>On 03/10/2014 02:24 PM, Chris Friesen wrote:
<br>>
<br>> Hi,
<br>>
<br>> I'm using havana and recent we ran into an issue with heat related to
<br>> character sets.
<br>>
<br>> In heat/db/sqlalchemy/api.py in user_creds_get() we call
<br>> _decrypt() on an encrypted password stored in the database and then
<br>> try to convert the result to unicode. Today we hit a case where this
<br>> errored out with the following message:
<br>>
<br>> UnicodeDecodeError: 'utf8' codec can't decode byte 0xf2 in position 0:
<br>> invalid continuation byte
<br>>
<br>> We're using postgres and currently all the databases are using
<br>> SQL_ASCII as the charset.
<br>>
<br>> I see that in icehouse heat will complain if you're using mysql and
<br>> not using UTF-8. There doesn't seem to be any checks for other
<br>> databases though.
<br>>
<br>> It looks like devstack creates most databases as UTF-8 but uses latin1
<br>> for nova/nova_bm/nova_cell. I assume this is because nova expects to
<br>> migrate the db to UTF-8 later. Given that those migrations specify a
<br>> character set only for mysql, when using postgres should we explicitly
<br>> default to UTF-8 for everything?
<br>after running openstack with postgres for a year i can tell you. use
<br>UTF-8 on your db.
<br>our db were encoded SQL_ASCII on install time and sooner or later we had
<br>issues, recreating db on UTF-8 fixed them
<br>
<br>
<br>--
<br>1AE0 322E B8F7 4717 BDEA BF1D 44BB 1BA7 9F6C 6333
<br>
<br>
<br>_______________________________________________
<br>OpenStack-operators mailing list
<br>OpenStack-operators@lists.openstack.org
<br>http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
<br></div></div></span></blockquote></body></html>