Hi,
Unfortunately with locale all good on my server:
# locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype |
Access privileges
-----------+----------------+----------+-------------+-------------+-----------------------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
spacewalk | spacewalk_user | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
spacewalk_user=CTc/spacewalk_user
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
=c/postgres +
| | | | |
postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
=c/postgres +
| | | | |
postgres=CTc/postgres
(4 rows)
It's another problem but I still not resolved it.
On Tue, Mar 6, 2018 at 1:34 PM, Andrei Popenta <andrei.pope...@visma.com>
wrote:
> Hi,
>
> Take a look here, it might help. https://bugzilla.redhat.com/
> show_bug.cgi?id=1524221
> Andrei
>
> On Mon, Mar 5, 2018 at 11:10 PM, Vitaly Y. | ServerBee <
> vitaly.yakove...@serverbee.net> wrote:
>
>> Hi,
>>
>> I try to setup Spacewalk server by following command:
>> # spacewalk-setup --answer-file=/root/spacewalk-answer-file
>> --external-postgresql
>>
>> I use --external-postgresql option because custom PostgreSQL 9.4 version
>> has been installed on EL7.
>>
>> # cat /root/spacewalk-answer-file
>> admin-email = root@localhost
>> ssl-set-org = O
>> ssl-set-org-unit = OU
>> ssl-set-city = L
>> ssl-set-state = P
>> ssl-set-country = US
>> ssl-password = s3cret
>> ssl-set-email = root@localhost
>> ssl-config-sslvhost = Y
>> db-backend=postgresql
>> db-name=spacewalk
>> db-user=spacewalk_user
>> db-password=s3crets3crets3crets3cret
>> db-host=localhost
>> db-port=5432
>> enable-tftp=N
>>
>> # cat /var/lib/pgsql/9.4/data/pg_hba.conf
>> # PostgreSQL Client Authentication Configuration File (Ansible)
>> # TYPE DATABASE USER ADDRESS METHOD
>> local all all peer
>> host all all 127.0.0.1/32 md5
>> host all all ::1/128 md5
>>
>>
>> From shell I can connect to PostgreSQL:
>>
>> # psql -h localhost -U spacewalk_user -W -d spacewalk
>> Password for user spacewalk_user:
>> psql (9.2.23, server 9.4.17)
>> WARNING: psql version 9.2, server version 9.4.
>> Some psql features might not work.
>> Type "help" for help.
>>
>> spacewalk=# \l
>> List of databases
>> Name | Owner | Encoding | Collate | Ctype |
>> Access privileges
>>
>> -----------+----------------+----------+-------------+------
>> -------+----------------------------------
>> -
>> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
>> spacewalk | spacewalk_user | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
>> spacewalk_user=CTc/spacewalk_user
>>
>>
>>
>> Populate_db stage finished without any errors:
>>
>> # tail /var/log/rhn/populate_db.log
>> INSERT 0 1
>> INSERT 0 1
>> INSERT 0 1
>> INSERT 0 1
>> CREATE FUNCTION
>> create_varnull_constriants
>> ----------------------------
>> 0
>> (1 row)
>>
>>
>>
>> But within next setups I always get an error:
>>
>> Preparing packages...
>> rhn-org-httpd-ssl-key-pair-sw-1.0-1.noarch
>> ERROR: there was a problem trying to initialize the database:
>>
>> Exception reported from xx.example.com
>> Time: Mon Mar 5 22:33:50 2018
>> Exception type <class 'spacewalk.server.rhnSQL.sql_base.SQLConnectError'>
>>
>> Exception Handler Information
>> Traceback (most recent call last):
>> File
>> "/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/rhn_ssl_dbstore.py",
>> line 55, in processCommandline
>> rhnSQL.initDB()
>> File
>> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/__init__.py",
>> line 158, in initDB
>> raise_with_tb(e, sys.exc_info()[2])
>> File
>> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/__init__.py",
>> line 145, in initDB
>> __init__DB(backend, host, port, username, password, database,
>> sslmode, sslrootcert)
>> File
>> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/__init__.py",
>> line 57, in __init__DB
>> __DB.connect()
>> File
>> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
>> line 194, in connect
>> return self.connect(reconnect=reconnect - 1)
>> File
>> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
>> line 199, in connect
>> "All attempts to connect to the database failed"), sys.exc_info()[2])
>> File
>> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
>> line 184, in connect
>> self.dbh = psycopg2.connect(" ".join("%s=%s" % (k, re.escape(str(v)))
>> for k, v in dsndata.items()))
>> File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line
>> 164, in connect
>> conn = _connect(dsn, connection_factory=connection_factory,
>> async=async)
>> SQLConnectError: (None, None, 'spacewalk', 'All attempts to connect to
>> the database failed')
>>
>>
>>
>> What I missed ?
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list@redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
--
Best regards,
Vitaly Yakovenko
Co-Founder & CTO at ServerBee
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
