Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
- Original Message -
> From: "Eli Mesika"
> To: "Alon Bar-Lev"
> Cc: "Nux!" , "Yedidyah Bar David" ,
> 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"
> > To: "Nux!" , "Eli Mesika"
> > Cc: "Yedidyah Bar David" , 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!"
> > > To: "Yedidyah Bar David"
> > > 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
> > >
> >
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
- Original Message -
> From: "Alon Bar-Lev"
> To: "Nux!" , "Eli Mesika"
> Cc: "Yedidyah Bar David" , 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!"
> > To: "Yedidyah Bar David"
> > 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
> >
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
On 08/28/2013 01:56 PM, Alon Bar-Lev wrote: - Original Message - From: "Nux!" To: "Yedidyah Bar David" 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 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
- Original Message - > From: "Nux!" > To: "Yedidyah Bar David" > 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 > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
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! 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
Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
Hi, - Original Message - > From: "Nux!" > To: "Yedidyah Bar David" > 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!" > >> 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 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
- Original Message - > From: "Nux!" > To: "Yedidyah Bar David" > 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!" > >> 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? ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
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!" 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 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
Hi, - Original Message - > From: "Nux!" > 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 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[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 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
