Bug 921524
| Summary: | ovirt-engine-setup: failed to create engine db because of locale issue | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Yair Zaslavsky <yzaslavs> |
| Component: | ovirt-engine | Assignee: | Eli Mesika <emesika> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Ilanit Stein <istein> |
| Severity: | high | Docs Contact: | |
| Priority: | high | ||
| Version: | 3.2.0 | CC: | acathrow, baumanmo, dyasny, iheim, lpeer, oourfali, oramraz, Rhev-m-bugs, wudxw, yeylon, ykaul |
| Target Milestone: | --- | ||
| Target Release: | 3.2.0 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | infra | ||
| Fixed In Version: | sf11 | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | 906416 | Environment: | |
| Last Closed: | Type: | Bug | |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | 906416 | ||
| Bug Blocks: | 948448 | ||
|
Description
Yair Zaslavsky
2013-03-14 11:19:23 UTC
please provide the output of the following comamnd
>psql -U postgres -l
ovirt-engine# psql -U postgres -l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+---------+-------+-----------------------
postgres | postgres | LATIN1 | en_US | en_US |
template0 | postgres | LATIN1 | en_US | en_US | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | LATIN1 | en_US | en_US | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)
ups sorry, please ignore comment 2, its output was from F18 and not RHEV-M Is there some other way to restore this bug beside install F18 please? 1) Follow this from psql prompt: postgres=# update pg_database set datallowconn = TRUE where datname = 'template0'; postgres=# \c template0 template0=# update pg_database set datistemplate = FALSE where datname = 'template1'; template0=# drop database template1; template0=# create database template1 with template = template0 encoding = 'LATIN1'; template0=# update pg_database set datistemplate = TRUE where datname = 'template1'; template0=# \c template1 template1=# update pg_database set datallowconn = FALSE where datname = 'template0'; 2) psql -U postgres -l verify that you got template1 with the LATIN1 encoding 3) Test the solution (In reply to comment #6) > 1) Follow this from psql prompt: > > postgres=# update pg_database set datallowconn = TRUE where datname = > 'template0'; > postgres=# \c template0 > template0=# update pg_database set datistemplate = FALSE where datname = > 'template1'; > template0=# drop database template1; > template0=# create database template1 with template = template0 encoding = > 'LATIN1'; > template0=# update pg_database set datistemplate = TRUE where datname = > 'template1'; > template0=# \c template1 > template1=# update pg_database set datallowconn = FALSE where datname = > 'template0'; > > 2) psql -U postgres -l > verify that you got template1 with the LATIN1 encoding > > 3) Test the solution How do I get to psql prompt please? Is it from rhevm cli? psql -U postgres engine Comment #6 steps can't be used to restore the problem. f18 installation is required. It is not clear to me what are the steps I should do after f18 installation. (In reply to comment #10) > It is not clear to me what are the steps I should do after f18 installation. in Bug description it says : Steps to Reproduce: run engine-setup after fresh f18 installation So, I see no other steps to follow apart of checking that on top of f18 Verified on sf-17.2: As Fedora is not supported, verification was done on rhel6.4, with hebrew language (system-config-language -> set to Hebrew; export LANG=he_IL). engine-setup was successful 3.2 has been released 3.2 has been released 3.2 has been released |