[Spacewalk-list] can not join a client to spacewalk master server
Afify, Sherif S (IBS)
Sherif.Afify at se1.bp.com
Mon Jan 29 09:16:28 UTC 2018
Hi Michael, I can login to the rhnschema and can view what inside the tables and the logs do not show that the database have issue . You still see it’s a database ?
id | parent_channel | org_id | channel_arch_id | label | basedir | name | summary | description | product_name_id | gpg_key_url
| gpg_key_id | gpg_key_fp | end_of_life | checksum_type_id | receiving_updates | last_modified | last_synced | channel_product_id | channel_access | maint_name | maint_email | maint_phone |
support_policy | created | modified
-----+----------------+--------+-----------------+-------------------------------------+-----------+-------------------------------------+-------------------------------------+-------------+-----------------+-----------------------------------------------------------
----+------------+----------------------------------------------------+-------------+------------------+-------------------+-------------------------------+-------------------------------+--------------------+----------------+------------+-------------+-------------+
----------------+-------------------------------+-------------------------------
115 | 101 | 1 | 513 | centos-6-mysql56-x86_64 | /dev/null | centos-6-mysql56-x86_64 | centos-6-mysql56-x86_64 | | | http://repo.mysql.com/RPM-GPG-KEY-mysql
| 5072E1F5 | A4A9 4068 76FC BD3C 4567 70C8 8C71 8D3B 5072 E1F5 | | 2 | Y | 2018-01-22 18:49:06.72883+00 | 2018-01-22 18:49:06.72883+00 | | private | | | |
| 2018-01-21 20:37:25.513221+00 | 2018-01-21 20:37:25.513221+00
121 | 102 | 1 | 513 | centos-7-epel-x86_64 | /dev/null | centos-7-epel-x86_64 | centos-7-epel-x86_64 | | | http://ftp.utexas.edu/epel/RPM-GPG-KEY-EPEL-7Server
| 352C64E5 | 91E9 7D7C 4A5E 96F1 7F3E 888F 6A2F AEA2 352C 64E5 | | 2 | Y | 2018-01-23 00:50:53.821018+00 | 2018-01-23 00:50:53.821018+00 | | private | | | |
| 2018-01-21 20:38:03.416908+00 | 2018-01-21 20:38:03.416908+00
117 | 102 | 1 | 513 | centos-7-centosplus-x86_64 | /dev/null | centos-7-centosplus-x86_64 | centos-7-centosplus-x86_64 | | | https://www.centos.org/keys/RPM-GPG-KEY-CentOS-7
| F4A80EB5 | 6341 AB27 53D7 8A78 A7C2 7BB1 24C6 A8A7 F4A8 0EB5 | | 2 | Y | 2018-01-22 21:59:56.158346+00 | 2018-01-22 21:59:56.158346+00 | | private | | | |
| 2018-01-21 20:38:03.224814+00 | 2018-01-21 20:38:03.224814+00
110 | 101 | 1 | 513 | centos-6-centosplus-x86_64 | /dev/null | centos-6-centosplus-x86_64 | centos-6-centosplus-x86_64 | | | https://www.centos.org/keys/RPM-GPG-KEY-CentOS-6
| C105B9DE | 69B3 0F26 BA2B 3AA4 C27C E4F5 3B75 CF79 D0FF 3D16 | | 2 | Y | 2018-01-22 16:19:34.10245+00 | 2018-01-22 16:19:34.10245+00 | | private | | | |
| 2018-01-21 20:37:21.896316+00 | 2018-01-21 20:37:21.896316+00
105 | 101 | 1 | 513 | spacewalk-centos-6-x86_64 | /dev/null | spacewalk-centos-6-x86_64 | spacewalk-centos-6-x86_64 | | | http://yum.spacewalkproject.org/RPM-GPG-KEY-spacewalk-2015
| B8002DE1 | A5FC 508C DD3C C46D 3C3B 4612 DCC9 81CD B800 2DE1 | | 2 | Y | 2018-01-23 09:26:30.866451+00 | 2018-01-23 09:26:30.866451+00 | | private | | | |
| 2018-01-21 20:31:24.43819+00 | 2018-01-21 20:31:24.43819+00
106 | 102 | 1 | 513 | spacewalk-centos-7-x86_64 | /dev/null | spacewalk-centos-7-x86_64 | spacewalk-centos-7-x86_64 | | | http://yum.spacewalkproject.org/RPM-GPG-KEY-spacewalk-2015
| B8002DE1 | A5FC 508C DD3C C46D 3C3B 4612 DCC9 81CD B800 2DE1 | | 2 | Y | 2018-01-23 09:26:32.166595+00 | 2018-01-23 09:26:32.166595+00 | | private | | | |
| 2018-01-21 20:31:24.506322+00 | 2018-01-21 20:31:24.506322+00
125 | 104 | 1 | 513 | rhel-6-server-rhn-tools-x86_64 | /dev/null | rhel-6-server-rhn-tools-x86_64 | rhel-6-server-rhn-tools-x86_64 | | | https://ramhpcls149.bp.com/pub/gpg/RPM-GPG-KEY-redhat-rele
ase | FD431D51 | 567E 347A D004 4ADE 55BA 8A5F 199E 2F91 FD43 1D51 | | 2 | Y | 2018-01-23 08:50:48.59904+00 | 2018-01-23 04:41:04.196299+00 | | private | | | |
| 2018-01-21 23:28:10.562081+00 | 2018-01-21 23:28:10.562081+00
107 | 104 | 1 | 513 | spacewalk-rhel-6-x86_64 | /dev/null | spacewalk-rhel-6-x86_64 | spacewalk-rhel-6-x86_64 | | | http://yum.spacewalkproject.org/RPM-GPG-KEY-spacewalk-2015
| B8002DE1 | A5FC 508C DD3C C46D 3C3B 4612 DCC9 81CD B800 2DE1 | | 2 | Y | 2018-01-23 09:26:33.386933+00 | 2018-01-23 09:26:33.386933+00 | | private | | | |
| 2018-01-21 20:31:24.562138+00 | 2018-01-21 20:31:24.562138+00
123 | 103 | 1 | 513 | rhel-7-server-rhn-tools-x86_64 | /dev/null | rhel-7-server-rhn-tools-x86_64 | rhel-7-server-rhn-tools-x86_64 | | | https://ramhpcls149.bp.com/pub/gpg/RPM-GPG-KEY-redhat-rele
ase | FD431D51 | 567E 347A D004 4ADE 55BA 8A5F 199E 2F91 FD43 1D51 | | 2 | Y | 2018-01-23 08:50:49.719502+00 | 2018-01-23 08:50:49.719502+00 | | private | | | |
| 2018-01-21 23:27:36.123755+00 | 2018-01-21 23:27:36.123755+00
114 | 101 | 1 | 513 | centos-6-epel-x86_64 | /dev/null | centos-6-epel-x86_64 | centos-6-epel-x86_64 | | | http://ftp.utexas.edu/epel/RPM-GPG-KEY-EPEL-6
| 0608B895 | 8C3B E96A F230 9184 DA5C 0DAE 3B49 DF2A 0608 B895 | | 2 | Y | 2018-01-22 18:34:44.18046+00 | 2018-01-22 18:34:44.18046+00 | | private | | | |
| 2018-01-21 20:37:22.118944+00 | 2018-01-21 20:37:22.118944+00
109 | 101 | 1 | 513 | centos-6-storage-gluster-3.8-x86_64 | /dev/null | centos-6-storage-gluster-3.8-x86_64 | centos-6-storage-gluster-3.8-x86_64 | | | https://www.centos.org/keys/RPM-GPG-KEY-CentOS-6
| C105B9DE | 69B3 0F26 BA2B 3AA4 C27C E4F5 3B75 CF79 D0FF 3D16 | | 2 | Y | 2018-01-22 18:51:01.691783+00 | 2018-01-22 18:51:01.691783+00 | | private | | | |
| 2018-01-21 20:37:21.830426+00 | 2018-01-21 20:37:21.830426+00
119 | 102 | 1 | 513 | centos-7-extras-x86_64 | /dev/null | centos-7-extras-x86_64 | centos-7-extras-x86_64 | | | https://www.centos.org/keys/RPM-GPG-KEY-CentOS-7
| F4A80EB5 | 6341 AB27 53D7 8A78 A7C2 7BB1 24C6 A8A7 F4A8 0EB5 | | 2 | Y | 2018-01-23 00:57:16.618305+00 | 2018-01-23 00:57:16.618305+00 | | private | | | |
| 2018-01-21 20:38:03.318005+00 | 2018-01-21 20:38:03.318005+00
118 | 102 | 1 | 513 | centos-7-opstools-x86_64 | /dev/null | centos-7-opstools-x86_64 | centos-7-opstools-x86_64 | | | https://www.centos.org/keys/RPM-GPG-KEY-CentOS-7
| F4A80EB5 | 6341 AB27 53D7 8A78 A7C2 7BB1 24C6 A8A7 F4A8 0EB5 | | 2 | Y | 2018-01-23 01:00:21.259919+00 | 2018-01-23 01:00:21.259919+00 | | private | | | |
| 2018-01-21 20:38:03.27399+00 | 2018-01-21 20:38:03.27399+00
116 | 102 | 1 | 513 | centos-7-storage-gluster-3.8-x86_64 | /dev/null | centos-7-storage-gluster-3.8-x86_64 | centos-7-storage-gluster-3.8-x86_64 | | | https://www.centos.org/keys/RPM-GPG-KEY-CentOS-7
| F4A80EB5 | 6341 AB27 53D7 8A78 A7C2 7BB1 24C6 A8A7 F4A8 0EB5 | | 2 | Y | 2018-01-23 01:00:46.844063+00 | 2018-01-23 01:00:46.844063+00 | | private | | | |
| 2018-01-21 20:38:03.17603+00 | 2018-01-21 20:38:03.17603+00
111 | 101 | 1 | 513 | centos-6-contrib-x86_64 | /dev/null | centos-6-contrib-x86_64 | centos-6-contrib-x86_64 | | | https://www.centos.org/keys/RPM-GPG-KEY-CentOS-6
| C105B9DE | 69B3 0F26 BA2B 3AA4 C27C E4F5 3B75 CF79 D0FF 3D16 | | 2 | Y | 2018-01-22 16:19:34.579962+00 | 2018-01-22 16:19:34.579962+00 | | private | | | |
| 2018-01-21 20:37:21.954257+00 | 2018-01-21 20:37:21.954257+00
122 | 102 | 1 | 513 | centos-7-mysql57-x86_64 | /dev/null | centos-7-mysql57-x86_64 | centos-7-mysql57-x86_64 | | | http://repo.mysql.com/RPM-GPG-KEY-mysql
| 5072E1F5 | A4A9 4068 76FC BD3C 4567 70C8 8C71 8D3B 5072 E1F5 | | 2 | Y | 2018-01-21 20:38:05.249522+00 | | | private | | | |
| 2018-01-21 20:38:05.249522+00 | 2018-01-21 20:38:05.249522+00
104 | | 1 | 513 | rhel-6-base-x86_64 | /dev/null | RHEL-6-base-x86_64 | RHEL-6-base-x86_64 | | |
| | | | 2 | Y | 2018-01-23 09:23:33.141788+00 | 2018-01-23 04:39:47.497547+00 | | private | | | |
| 2018-01-21 20:30:09.709786+00 | 2018-01-21 20:30:09.709786+00
124 | 103 | 1 | 513 | rhel-7-server-rt-x86_64 | /dev/null | rhel-7-server-rt-x86_64 | rhel-7-server-rt-x86_64 | | | https://ramhpcls149.bp.com/pub/gpg/RPM-GPG-KEY-redhat-rele
ase | FD431D51 | 567E 347A D004 4ADE 55BA 8A5F 199E 2F91 FD43 1D51 | | 2 | Y | 2018-01-23 09:23:35.781249+00 | 2018-01-23 09:23:35.781249+00 | | private | | | |
| 2018-01-21 23:27:38.65687+00 | 2018-01-21 23:27:38.65687+00
103 | | 1 | 513 | rhel-7-base-x86_64 | /dev/null | RHEL-7-base-x86_64 | RHEL-7-base-x86_64 | | |
| | | | 2 | Y | 2018-01-23 08:49:59.51807+00 | 2018-01-23 08:49:59.51807+00 | | private | | | |
| 2018-01-21 20:30:07.689714+00 | 2018-01-21 20:30:07.689714+00
101 | | 1 | 513 | centos-6-base-x86_64 | /dev/null | Centos-6-base-x86_64 | Centos-6-base-x86_64 | | | http://ftp.utexas.edu/centos/7/os/x86_64/RPM-GPG-KEY-CentO
S-6 | C105B9DE | 69B3 0F26 BA2B 3AA4 C27C E4F5 3B75 CF79 D0FF 3D16 | | 2 | Y | 2018-01-22 21:02:26.400065+00 | 2018-01-22 16:08:04.954028+00 | | private | | | |
| 2018-01-21 20:30:07.537645+00 | 2018-01-21 20:30:07.537645+00
126 | 104 | 1 | 513 | rhel-6-server-rt-x86_64 | /dev/null | rhel-6-server-rt-x86_64 | rhel-6-server-rt-x86_64 | | | https://ramhpcls149.bp.com/pub/gpg/RPM-GPG-KEY-redhat-rele
ase | FD431D51 | 567E 347A D004 4ADE 55BA 8A5F 199E 2F91 FD43 1D51 | | 2 | Y | 2018-01-23 04:41:04.507716+00 | 2018-01-23 04:41:04.507716+00 | | private | | | |
--More--
________________________________
Afify, Sherif S (IBS):
> I am getting the below error when I try to register client to spacewalk , any ideas?
...
> [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]
Hello Afify,
Your database is not running, you have to fix it first.
I'm afraid if the error message above didn't help you to find out what's
the problem you should better ask some more experienced admin in your
company to take care of this server.
Regards,
--
Michael Mráka
System Management Engineering, Red Hat
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20180129/b54cf544/attachment.htm>
More information about the Spacewalk-list
mailing list