From: "Nux!" <nux(a)li.nux.ro&gt; To: users(a)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/

From: "Nux!" <nux(a)li.nux.ro&gt; To: "Yedidyah Bar David" <didi(a)redhat.com&gt; Cc: users(a)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(a)li.nux.ro&gt; >> To: users(a)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.

----- Original Message ----- > From: "Nux!" <nux(a)li.nux.ro&gt; > To: "Yedidyah Bar David" <didi(a)redhat.com&gt; > Cc: users(a)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?

From: "Eli Mesika" <emesika(a)redhat.com&gt; To: "Alon Bar-Lev" <alonbl(a)redhat.com&gt; Cc: "Nux!" <nux(a)li.nux.ro&gt;, "Yedidyah Bar David" <didi(a)redhat.com&gt;, users(a)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(a)redhat.com&gt; > To: "Nux!" <nux(a)li.nux.ro&gt;, "Eli Mesika" <emesika(a)redhat.com&gt; > Cc: "Yedidyah Bar David" <didi(a)redhat.com&gt;, users(a)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(a)li.nux.ro&gt; > > To: "Yedidyah Bar David" <didi(a)redhat.com&gt; > > Cc: users(a)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(a)ovirt.org > > http://lists.ovirt.org/mailman/listinfo/users > > >