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

[DiOrio, Max]

Check to make sure you have glibc-i18n installed.  Sounds like you’re missing the locale


Max DiOrio
Global Systems Administrator

From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Felipe Westfields
Sent: Friday, February 2, 2018 9:00 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Database error when installing Space-Walk 2.7

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<mailto: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<mailto:felipe.westfields at gmail.com>>
Sent: Thursday, February 1, 2018 10:55 PM
To: spacewalk-list at redhat.com<mailto: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<mailto: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/9df4da75/attachment.htm>