Solved! I replaced postgresql 9.4 with default postgresql 9.2.23 for el7 and now " spacewalk-setup --answer-file=/root/spacewalk-answer-file" works as expected.
On Fri, Mar 30, 2018 at 10:18 AM, Vitaly Y. | ServerBee < vitaly.yakove...@serverbee.net> wrote: > Got it. > > But I prepared my external PostgreSQL installation by other ansible role > before running of spacewalk-setup script . > > Also Populate_db stage work out correctly and I can see all needed tables > inside spacewalk pgsql database. > > I understand that problem can be from other side and the error can be not > explicit. > > I’m still trying to find solution. > > El El vie, mar. 30, 2018 a las 09:16, Andrei Popenta < > andrei.pope...@visma.com> escribió: > >> Hi, >> >> I am sorry it didn't work for you. I had the same problem and the >> workaround suggested by Eric Burgueño fixed the installation. >> "you need to initialise the database **before** running spacewalk-setup. >> >> BR, >> Andrei >> >> On Thu, Mar 29, 2018 at 9:45 PM, Vitaly Y. | ServerBee < >> vitaly.yakove...@serverbee.net> wrote: >> >>> 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/sh >>>> ow_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_b >>>>> ase.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 >>> >> >> _______________________________________________ >> 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