[Spacewalk-list] can not join a client to spacewalk master server

[Robert Paschedag]

Am 28. Januar 2018 12:31:15 MEZ schrieb "Afify, Sherif S (IBS)" <Sherif.Afify at se1.bp.com>:
>I am getting the below error when I try to register client to spacewalk
> , any ideas?
>
>
>
>
>
>[Sun Jan 28 11:27:10.469571 2018] [:error] [pid 31001] Exception
>Handler Information
>
>[Sun Jan 28 11:27:10.469572 2018] [:error] [pid 31001] Traceback (most
>recent call last):
>
>[Sun Jan 28 11:27:10.469582 2018] [:error] [pid 31001]   File
>"/usr/lib/python2.7/site-packages/spacewalk/server/apacheHandler.py",
>line 87, in headerParserHandler
>
>[Sun Jan 28 11:27:10.469585 2018] [:error] [pid 31001]    
>rhnSQL.initDB()
>
>[Sun Jan 28 11:27:10.469586 2018] [:error] [pid 31001]   File
>"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/__init__.py",
>line 158, in initDB
>
>[Sun Jan 28 11:27:10.469588 2018] [:error] [pid 31001]    
>raise_with_tb(e, sys.exc_info()[2])
>
>[Sun Jan 28 11:27:10.469589 2018] [:error] [pid 31001]   File
>"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/__init__.py",
>line 145, in initDB
>
>[Sun Jan 28 11:27:10.469591 2018] [:error] [pid 31001]    
>__init__DB(backend, host, port, username, password, database, sslmode,
>sslrootcert)
>
>[Sun Jan 28 11:27:10.469593 2018] [:error] [pid 31001]   File
>"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/__init__.py",
>line 57, in __init__DB
>
>[Sun Jan 28 11:27:10.469652 2018] [:error] [pid 31001]    
>__DB.connect()
>
>[Sun Jan 28 11:27:10.469655 2018] [:error] [pid 31001]   File
>"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
>line 194, in connect
>
>[Sun Jan 28 11:27:10.469656 2018] [:error] [pid 31001]     return
>self.connect(reconnect=reconnect - 1)
>
>[Sun Jan 28 11:27:10.469658 2018] [:error] [pid 31001]   File
>"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
>line 199, in connect
>
>[Sun Jan 28 11:27:10.469659 2018] [:error] [pid 31001]     "All
>attempts to connect to the database failed"), sys.exc_info()[2])
>
>[Sun Jan 28 11:27:10.469661 2018] [:error] [pid 31001]   File
>"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
>line 184, in connect
>
>[Sun Jan 28 11:27:10.469663 2018] [:error] [pid 31001]     self.dbh =
>psycopg2.connect(" ".join("%s=%s" % (k, re.escape(str(v))) for k, v in
>dsndata.items()))
>
>[Sun Jan 28 11:27:10.469664 2018] [:error] [pid 31001]   File
>"/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 164, in
>connect
>
>[Sun Jan 28 11:27:10.469666 2018] [:error] [pid 31001]     conn =
>_connect(dsn, connection_factory=connection_factory, async=async)
>
>[Sun Jan 28 11:27:10.469667 2018] [:error] [pid 31001] SQLConnectError:
>(None, None, 'rhnschema', 'All attempts to connect to the database
>failed')
>
>[Sun Jan 28 11:27:10.469672 2018] [:error] [pid 31001]

Check the credentials in /etc/rhn/rhn.conf.

Normally, these are

db: rhnschema
user: rhnuser
pw: rhnpw

Try to login manually with these. If it works, check in conf file, if there is something different.

Robert