[Users] engine-setup fails on CentOS 6.4 because of postgresql

Hello, Installed ovirt engine from the official repos, but engine-setup fails because of the database. Logs here: http://paste.fedoraproject.org/35360/77293137/ http://paste.fedoraproject.org/35361/76773031/ I'm not really any good with postgresql, what is the problem? Thanks, Lucian -- Sent from the Delta quadrant using Borg technology! Nux! www.nux.ro

Hi, ----- Original Message -----
From: "Nux!" <nux@li.nux.ro> To: users@ovirt.org Sent: Wednesday, August 28, 2013 11:14:55 AM Subject: [Users] engine-setup fails on CentOS 6.4 because of postgresql
Hello,
Installed ovirt engine from the official repos, but engine-setup fails because of the database. Logs here: http://paste.fedoraproject.org/35360/77293137/ http://paste.fedoraproject.org/35361/76773031/
This file says: createdb: database creation failed: ERROR: encoding UTF8 does not match locale en_GB DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1. Can you try with a UTF-8 locale? -- Didi

On 28.08.2013 09:23, Yedidyah Bar David wrote:
Hi,
----- Original Message -----
From: "Nux!" <nux@li.nux.ro> To: users@ovirt.org Sent: Wednesday, August 28, 2013 11:14:55 AM Subject: [Users] engine-setup fails on CentOS 6.4 because of postgresql
Hello,
Installed ovirt engine from the official repos, but engine-setup fails because of the database. Logs here: http://paste.fedoraproject.org/35360/77293137/ http://paste.fedoraproject.org/35361/76773031/
This file says: createdb: database creation failed: ERROR: encoding UTF8 does not match locale en_GB DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1.
Can you try with a UTF-8 locale?
Hi What exactly should I do? I tried changing lc_ stuff in postgresql.conf to en_GB.UTF-8 but it doesn't help. -- Sent from the Delta quadrant using Borg technology! Nux! www.nux.ro

----- Original Message -----
From: "Nux!" <nux@li.nux.ro> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, August 28, 2013 11:59:59 AM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
On 28.08.2013 09:23, Yedidyah Bar David wrote:
Hi,
----- Original Message -----
From: "Nux!" <nux@li.nux.ro> To: users@ovirt.org Sent: Wednesday, August 28, 2013 11:14:55 AM Subject: [Users] engine-setup fails on CentOS 6.4 because of postgresql
Hello,
Installed ovirt engine from the official repos, but engine-setup fails because of the database. Logs here: http://paste.fedoraproject.org/35360/77293137/ http://paste.fedoraproject.org/35361/76773031/
This file says: createdb: database creation failed: ERROR: encoding UTF8 does not match locale en_GB DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1.
Can you try with a UTF-8 locale?
Hi
What exactly should I do? I tried changing lc_ stuff in postgresql.conf to en_GB.UTF-8 but it doesn't help.
Eli?

Hi, ----- Original Message -----
From: "Nux!" <nux@li.nux.ro> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, August 28, 2013 11:59:59 AM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
On 28.08.2013 09:23, Yedidyah Bar David wrote:
Hi,
----- Original Message -----
From: "Nux!" <nux@li.nux.ro> To: users@ovirt.org Sent: Wednesday, August 28, 2013 11:14:55 AM Subject: [Users] engine-setup fails on CentOS 6.4 because of postgresql
Hello,
Installed ovirt engine from the official repos, but engine-setup fails because of the database. Logs here: http://paste.fedoraproject.org/35360/77293137/ http://paste.fedoraproject.org/35361/76773031/
This file says: createdb: database creation failed: ERROR: encoding UTF8 does not match locale en_GB DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1.
Can you try with a UTF-8 locale?
Hi
What exactly should I do? I tried changing lc_ stuff in postgresql.conf to en_GB.UTF-8 but it doesn't help.
I think it's the OS's locale. What do you have in /etc/locale.conf ? You can try changing that to: LANG="en_US.UTF-8" Then login again (or just open a new shell), and verify that it worked by running: locale and verifying that there are no errors. -- Didi

On 28.08.2013 10:13, Yedidyah Bar David wrote:
I think it's the OS's locale. What do you have in /etc/locale.conf ? You can try changing that to:
LANG="en_US.UTF-8"
Then login again (or just open a new shell), and verify that it worked by running:
locale
and verifying that there are no errors.
Hi, It worked after I reinitialised the DB like this: initdb --locale=C -E UNICODE -D /var/lib/pgsql/data Might be nice to be able to specify/force this from /etc/sysconfig or similar, this is not very user friendly. :-) Thanks for your help! Lucian -- Sent from the Delta quadrant using Borg technology! Nux! www.nux.ro

----- Original Message -----
From: "Nux!" <nux@li.nux.ro> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, August 28, 2013 1:49:25 PM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
On 28.08.2013 10:13, Yedidyah Bar David wrote:
I think it's the OS's locale. What do you have in /etc/locale.conf ? You can try changing that to:
LANG="en_US.UTF-8"
Then login again (or just open a new shell), and verify that it worked by running:
locale
and verifying that there are no errors.
Hi,
It worked after I reinitialised the DB like this:
initdb --locale=C -E UNICODE -D /var/lib/pgsql/data
Might be nice to be able to specify/force this from /etc/sysconfig or similar, this is not very user friendly. :-)
Thanks for your help!
This is strange! We use standard way to create the database: fedora: /usr/bin/postgresql-setup rhel/centos /etc/init.d/postgresql initdb Both run: $SU -l postgres -c "$PGENGINE/initdb --pgdata='$PGDATA' --auth='ident'" >> "$PGLOG" 2>&1 < /dev/null So we cannot provide parameters to this process... And we cannot specify locale environment variables as it uses su. Eli, is there any solution for this?
Lucian
-- Sent from the Delta quadrant using Borg technology!
Nux! www.nux.ro _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

On 08/28/2013 01:56 PM, Alon Bar-Lev wrote:
----- Original Message -----
From: "Nux!" <nux@li.nux.ro> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, August 28, 2013 1:49:25 PM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
On 28.08.2013 10:13, Yedidyah Bar David wrote:
I think it's the OS's locale. What do you have in /etc/locale.conf ? You can try changing that to:
LANG="en_US.UTF-8"
Then login again (or just open a new shell), and verify that it worked by running:
locale
and verifying that there are no errors.
Hi,
It worked after I reinitialised the DB like this:
initdb --locale=C -E UNICODE -D /var/lib/pgsql/data
Might be nice to be able to specify/force this from /etc/sysconfig or similar, this is not very user friendly. :-)
Thanks for your help!
This is strange!
We use standard way to create the database: fedora: /usr/bin/postgresql-setup rhel/centos /etc/init.d/postgresql initdb
Both run: $SU -l postgres -c "$PGENGINE/initdb --pgdata='$PGDATA' --auth='ident'" >> "$PGLOG" 2>&1 < /dev/null
So we cannot provide parameters to this process... And we cannot specify locale environment variables as it uses su.
Eli, is there any solution for this?
Eli - ping? Eyal - we need a job running setup in all locales, say nightly... Thanks, Itamar

----- Original Message -----
From: "Alon Bar-Lev" <alonbl@redhat.com> To: "Nux!" <nux@li.nux.ro>, "Eli Mesika" <emesika@redhat.com> Cc: "Yedidyah Bar David" <didi@redhat.com>, users@ovirt.org Sent: Wednesday, August 28, 2013 1:56:19 PM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
----- Original Message -----
From: "Nux!" <nux@li.nux.ro> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, August 28, 2013 1:49:25 PM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
On 28.08.2013 10:13, Yedidyah Bar David wrote:
I think it's the OS's locale. What do you have in /etc/locale.conf ? You can try changing that to:
LANG="en_US.UTF-8"
Then login again (or just open a new shell), and verify that it worked by running:
locale
and verifying that there are no errors.
Hi,
It worked after I reinitialised the DB like this:
initdb --locale=C -E UNICODE -D /var/lib/pgsql/data
Might be nice to be able to specify/force this from /etc/sysconfig or similar, this is not very user friendly. :-)
Thanks for your help!
This is strange!
We use standard way to create the database: fedora: /usr/bin/postgresql-setup rhel/centos /etc/init.d/postgresql initdb
Both run: $SU -l postgres -c "$PGENGINE/initdb --pgdata='$PGDATA' --auth='ident'" >> "$PGLOG" 2>&1 < /dev/null
So we cannot provide parameters to this process... And we cannot specify locale environment variables as it uses su.
Eli, is there any solution for this?
Alon Our original create_db.sh script (3.2) had this line : createdb --username=${USERNAME} --host=${SERVERNAME} --port=${PORT} ${DATABASE} -e -E UTF8 --lc-collate en_US.UTF8 --lc-ctype en_US.UTF8 -T template0 I know that in 3.3 , DB is created differently, you should make sure that the -E UTF8 --lc-collate en_US.UTF8 --lc-ctype en_US.UTF8 are used when DB is created
Lucian
-- Sent from the Delta quadrant using Borg technology!
Nux! www.nux.ro _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Nux!" <nux@li.nux.ro>, "Yedidyah Bar David" <didi@redhat.com>, users@ovirt.org Sent: Wednesday, September 18, 2013 1:03:53 PM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
----- Original Message -----
From: "Alon Bar-Lev" <alonbl@redhat.com> To: "Nux!" <nux@li.nux.ro>, "Eli Mesika" <emesika@redhat.com> Cc: "Yedidyah Bar David" <didi@redhat.com>, users@ovirt.org Sent: Wednesday, August 28, 2013 1:56:19 PM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
----- Original Message -----
From: "Nux!" <nux@li.nux.ro> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, August 28, 2013 1:49:25 PM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
On 28.08.2013 10:13, Yedidyah Bar David wrote:
I think it's the OS's locale. What do you have in /etc/locale.conf ? You can try changing that to:
LANG="en_US.UTF-8"
Then login again (or just open a new shell), and verify that it worked by running:
locale
and verifying that there are no errors.
Hi,
It worked after I reinitialised the DB like this:
initdb --locale=C -E UNICODE -D /var/lib/pgsql/data
Might be nice to be able to specify/force this from /etc/sysconfig or similar, this is not very user friendly. :-)
Thanks for your help!
This is strange!
We use standard way to create the database: fedora: /usr/bin/postgresql-setup rhel/centos /etc/init.d/postgresql initdb
Both run: $SU -l postgres -c "$PGENGINE/initdb --pgdata='$PGDATA' --auth='ident'" >> "$PGLOG" 2>&1 < /dev/null
So we cannot provide parameters to this process... And we cannot specify locale environment variables as it uses su.
Eli, is there any solution for this?
Alon Our original create_db.sh script (3.2) had this line :
createdb --username=${USERNAME} --host=${SERVERNAME} --port=${PORT} ${DATABASE} -e -E UTF8 --lc-collate en_US.UTF8 --lc-ctype en_US.UTF8 -T template0
I know that in 3.3 , DB is created differently, you should make sure that the -E UTF8 --lc-collate en_US.UTF8 --lc-ctype en_US.UTF8 are used when DB is created
Fixed[1] [1] http://gerrit.ovirt.org/#/q/Id742da121c75d4268bdd9dddfb6e2ee48434ff2e,n,z
Lucian
-- Sent from the Delta quadrant using Borg technology!
Nux! www.nux.ro _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (5)
-
Alon Bar-Lev
-
Eli Mesika
-
Itamar Heim
-
Nux!
-
Yedidyah Bar David