[Spacewalk-list] Database error when installing Space-Walk 2.7

[Felipe Westfields]

Interesting - LC_ALL *was* originally blank - here's what I got from
running that export command a few times (notice how the error messages
change)

[root at spacewalk ~]# export LC_ALL=en-us.UTF8
-bash: warning: setlocale: LC_ALL: cannot change locale (en-us.UTF8): No
such file or directory
-bash: warning: setlocale: LC_ALL: cannot change locale (en-us.UTF8)
[root at spacewalk ~]#
[root at spacewalk ~]# export LC_ALL=en-us.UTF8
-bash: warning: setlocale: LC_ALL: cannot change locale (en-us.UTF8)
-bash: warning: setlocale: LC_ALL: cannot change locale (en-us.UTF8)
[root at spacewalk ~]# locale
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or
directory

LANG=en_US.UTF-8

LC_CTYPE="en-us.UTF8"

LC_NUMERIC="en-us.UTF8"

LC_TIME="en-us.UTF8"

LC_COLLATE="en-us.UTF8"

LC_MONETARY="en-us.UTF8"

LC_MESSAGES="en-us.UTF8"

LC_PAPER="en-us.UTF8"

LC_NAME="en-us.UTF8"

LC_ADDRESS="en-us.UTF8"

LC_TELEPHONE="en-us.UTF8"

LC_MEASUREMENT="en-us.UTF8"

LC_IDENTIFICATION="en-us.UTF8"

LC_ALL=en-us.UTF8

[root at spacewalk ~]# export
LC_ALL="en-us.UTF8"

-bash: warning: setlocale: LC_ALL: cannot change locale
(en-us.UTF8)

-bash: warning: setlocale: LC_ALL: cannot change locale
(en-us.UTF8)

[root at spacewalk ~]# locale
locale: Cannot set LC_CTYPE to default locale: No such file or
directory

locale: Cannot set LC_MESSAGES to default locale: No such file or
directory

locale: Cannot set LC_ALL to default locale: No such file or
directory

LANG=en_US.UTF-8

LC_CTYPE="en-us.UTF8"
LC_NUMERIC="en-us.UTF8"
LC_TIME="en-us.UTF8"
LC_COLLATE="en-us.UTF8"
LC_MONETARY="en-us.UTF8"
LC_MESSAGES="en-us.UTF8"
LC_PAPER="en-us.UTF8"
LC_NAME="en-us.UTF8"
LC_ADDRESS="en-us.UTF8"
LC_TELEPHONE="en-us.UTF8"
LC_MEASUREMENT="en-us.UTF8"
LC_IDENTIFICATION="en-us.UTF8"
LC_ALL=en-us.UTF8


On Fri, Feb 2, 2018 at 6:12 AM, DiOrio, Max <Max.DiOrio at ieeeglobalspec.com>
wrote:

> Oh, you will need to uninstall and reinstall postgres for it to use the
> new locale
>
> Sent from Nine <http://www.9folders.com/>
> ------------------------------
> *From:* Felipe Westfields <felipe.westfields at gmail.com>
> *Sent:* Thursday, February 1, 2018 10:55 PM
> *To:* spacewalk-list at redhat.com
> *Subject:* [Spacewalk-list] Database error when installing Space-Walk 2.7
>
> I'm installing Spacewalk on CentOS 7, Spacewalk 2.7, following the
> instructions on this page:
>
> https://github.com/spacewalkproject/spacewalk/wiki/HowToInstall
>
> I install the the necessary repos, all seems well. I run this line:
>
> pacewalk-setup-postgresql create --db spacewalk --user dbadmin --password
> password --address *
>
> And this is the error that comes up. I ran through the install
> instructions twice  and gotten the same error both times.
>
> Redirecting to /bin/systemctl start postgresql.service
> createdb: database creation failed: ERROR:  new encoding (UTF8) is
> incompatible with the encoding of the template database (SQL_ASCII)
> HINT:  Use the same encoding as in the template database, or use template0
> as template.
>
> What do I need to do to get past this error?
>
> FW
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20180202/a5b613e7/attachment.htm>