[Spacewalk-list] spacewalk-hostname-rename failed
Wilkinson, Matthew
MatthewWilkinson at alliantenergy.com
Wed Jul 18 16:22:58 UTC 2018
if you manually installed postgres, then it will not be part of the spacewalk-service script.
So I'd do some more checking to ensure you have the right credentials for postgres and you can login to it. E.g.
# su - postgres
$ psql
to make sure you can connect. You also might have to check your postgres DB connection settings to ensure it's configured properly.
--Matthew Wilkinson
-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Yakin, Francis
Sent: Wednesday, July 18, 2018 10:56
To: Robert Paschedag; spacewalk-list at redhat.com; spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] spacewalk-hostname-rename failed
[This is an external email. Be cautious with links, attachments and responses.]
**********************************************************************
Robert and Mathew,
>>Postgres IS bundled with spacewalk-service... At least in every installation I know of if it uses the "internal" postgres DB.
But, why when I restart the spacewalk-service restart, it doesn’t show "postgresql" stop and start it, it seems the script doesn't do postgres.
[root at ala-spacewalk-poc ~]# spacewalk-service restart
Shutting down spacewalk services...
Redirecting to /bin/systemctl stop taskomatic.service
Stopping cobblerd (via systemctl): [ OK ]
Redirecting to /bin/systemctl stop rhn-search.service
Redirecting to /bin/systemctl stop osa-dispatcher.service
Redirecting to /bin/systemctl stop httpd.service
Redirecting to /bin/systemctl stop tomcat.service
Redirecting to /bin/systemctl stop jabberd.service
Done.
Starting spacewalk services...
Redirecting to /bin/systemctl start jabberd.service
Redirecting to /bin/systemctl start tomcat.service
Waiting for tomcat to be ready ...
Redirecting to /bin/systemctl start httpd.service
Redirecting to /bin/systemctl start osa-dispatcher.service
Redirecting to /bin/systemctl start rhn-search.service
Starting cobblerd (via systemctl): [ OK ]
Redirecting to /bin/systemctl start taskomatic.service
Done.
And Postgres never stop and still running when I ran "spacewalk-hostname-rename"
But, the error still mention database connection is not available
[root at ala-spacewalk-prod ~]# spacewalk-hostname-rename https://urldefense.proofpoint.com/v2/url?u=http-3A__147.11.147.159&d=DwIGaQ&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=kqt35gvvp7wKOsQ-qgLb6OyqyeTgOBxCTk6UkDPwpqg&s=OgGbJE6WIs4G4g1084iAAjzSYC8qcq29G9Ug1LMJwsw&e=
Validating IP ... OK
=============================================
hostname: https://urldefense.proofpoint.com/v2/url?u=http-3A__ala-2Dspacewalk-2Dprod.wrs.com&d=DwIGaQ&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=kqt35gvvp7wKOsQ-qgLb6OyqyeTgOBxCTk6UkDPwpqg&s=5wIAgET0zO4gOE_1EQEpihqSj2DmZNqeRJ9er5gi524&e=
ip: https://urldefense.proofpoint.com/v2/url?u=http-3A__147.11.147.159&d=DwIGaQ&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=kqt35gvvp7wKOsQ-qgLb6OyqyeTgOBxCTk6UkDPwpqg&s=OgGbJE6WIs4G4g1084iAAjzSYC8qcq29G9Ug1LMJwsw&e=
=============================================
Stopping spacewalk services ... OK
Testing DB connection ... FAILED
Your database isn't running.
Fix the problem and run /bin/spacewalk-hostname-rename again
Is there any bugs with spacewalk-hostname-rename script??
Does anyone have any recommendation to make it to work?
Thanks
Francis
-----Original Message-----
From: Robert Paschedag [mailto:robert.paschedag at web.de]
Sent: Tuesday, July 17, 2018 8:55 PM
To: spacewalk-list at redhat.com; Yakin, Francis; spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] spacewalk-hostname-rename failed
Am 18. Juli 2018 03:32:02 MESZ schrieb "Yakin, Francis" <Francis.Yakin at windriver.com>:
>Another thing, postgres is not bundled with spacewalk-service. So, it's
>not restart when I run "spacewalk-service restart"
>Should I stop the postgres manually before I run
>"spacewalk-hostname-rename"? And then restart it before "Starting
>spacewalk services...?
Postgres IS bundled with spacewalk-service... At least in every installation I know of if it uses the "internal" postgres DB.
And no... You have to explicitly start postgres, before you call spacewalk-hostname-rename so it can connect to the database.
Like Matthew said.
Robert
>
>Francis
>
>From: Yakin, Francis
>Sent: Tuesday, July 17, 2018 2:14 PM
>To: spacewalk-list at redhat.com
>Subject: RE: spacewalk-hostname-rename failed
>
>Postgres
>
>
>I did that, I use spacewalk-service restart before I ran
>"spacewalk-hostname-rename" script
>
>[root at ala-spacewalk-prod ~]# spacewalk-service restart
>Shutting down spacewalk services...
>Redirecting to /bin/systemctl stop taskomatic.service
>Stopping cobblerd (via systemctl): [ OK ]
>Redirecting to /bin/systemctl stop rhn-search.service
>Redirecting to /bin/systemctl stop osa-dispatcher.service
>Redirecting to /bin/systemctl stop httpd.service
>Redirecting to /bin/systemctl stop tomcat.service
>Redirecting to /bin/systemctl stop jabberd.service
>Done.
>Starting spacewalk services...
>Redirecting to /bin/systemctl start jabberd.service
>Redirecting to /bin/systemctl start tomcat.service
>Waiting for tomcat to be ready ...
>Redirecting to /bin/systemctl start httpd.service
>Redirecting to /bin/systemctl start osa-dispatcher.service
>Redirecting to /bin/systemctl start rhn-search.service
>Starting cobblerd (via systemctl): [ OK ]
>Redirecting to /bin/systemctl start taskomatic.service
>Done.
>
>[root at ala-spacewalk-prod ~]# spacewalk-hostname-rename https://urldefense.proofpoint.com/v2/url?u=http-3A__147.11.147.159&d=DwIGaQ&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=kqt35gvvp7wKOsQ-qgLb6OyqyeTgOBxCTk6UkDPwpqg&s=OgGbJE6WIs4G4g1084iAAjzSYC8qcq29G9Ug1LMJwsw&e=
>Validating IP ... OK
>=============================================
>hostname: https://urldefense.proofpoint.com/v2/url?u=http-3A__ala-2Dspacewalk-2Dprod.wrs.com&d=DwIGaQ&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=kqt35gvvp7wKOsQ-qgLb6OyqyeTgOBxCTk6UkDPwpqg&s=5wIAgET0zO4gOE_1EQEpihqSj2DmZNqeRJ9er5gi524&e=
>ip: https://urldefense.proofpoint.com/v2/url?u=http-3A__147.11.147.159&d=DwIGaQ&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=kqt35gvvp7wKOsQ-qgLb6OyqyeTgOBxCTk6UkDPwpqg&s=OgGbJE6WIs4G4g1084iAAjzSYC8qcq29G9Ug1LMJwsw&e=
>=============================================
>Stopping spacewalk services ... OK
>Testing DB connection ... FAILED
>Your database isn't running.
>Fix the problem and run /bin/spacewalk-hostname-rename again
>
>
>Francis
>
>
>From: spacewalk-list-bounces at redhat.com
>[mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Wilkinson,
>Matthew
>Sent: Tuesday, July 17, 2018 1:55 PM
>To: spacewalk-list at redhat.com
>Subject: Re: [Spacewalk-list] spacewalk-hostname-rename failed
>
>which DB are you using postgres or oracle? If you used the
>spacewalk-service command to stop with the bundled DB, it will stop
>postgres and you'll have to start it up before you run the command.
>
>--Matthew Wilkinson
>
>From: spacewalk-list-bounces at redhat.com
>[mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Yakin, Francis
>Sent: Tuesday, July 17, 2018 15:39
>To: spacewalk-list at redhat.com
>Subject: [Spacewalk-list] spacewalk-hostname-rename failed
>
>[This is an external email. Be cautious with links, attachments and
>responses.]
>________________________________
>
>Hi All,
>
>I encountered this issue when I try to run "spacewalk-hostname-rename"
>script
>
>
>[root at ala-spacewalk-prod init.d]# /bin/spacewalk-hostname-rename
>https://urldefense.proofpoint.com/v2/url?u=http-3A__147.11.147.159&d=DwIGaQ&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=kqt35gvvp7wKOsQ-qgLb6OyqyeTgOBxCTk6UkDPwpqg&s=OgGbJE6WIs4G4g1084iAAjzSYC8qcq29G9Ug1LMJwsw&e=
>Validating IP ... OK
>=============================================
>hostname: https://urldefense.proofpoint.com/v2/url?u=http-3A__ala-2Dspacewalk-2Dprod.wrs.com&d=DwIGaQ&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=kqt35gvvp7wKOsQ-qgLb6OyqyeTgOBxCTk6UkDPwpqg&s=5wIAgET0zO4gOE_1EQEpihqSj2DmZNqeRJ9er5gi524&e=
>ip: https://urldefense.proofpoint.com/v2/url?u=http-3A__147.11.147.159&d=DwIGaQ&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=kqt35gvvp7wKOsQ-qgLb6OyqyeTgOBxCTk6UkDPwpqg&s=OgGbJE6WIs4G4g1084iAAjzSYC8qcq29G9Ug1LMJwsw&e=
>=============================================
>Stopping spacewalk services ... OK
>Testing DB connection ... FAILED
>Your database isn't running.
>Fix the problem and run /bin/spacewalk-hostname-rename again
>
>Francis Yakin | IT System Admin | direct: 510-749-2027
>500 Wind River Way, Alameda, CA 94501
>[cid:image001.png at 01D12D0C.E17713F0]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.windriver.com_&d=DwMFAg&c=GUDVeAVg1gjs_GJkmwL1m3gEzDND7NeJG5BIAX_2yRE&r=zxSMv3Yyn0u8GiLjBm805qsHQ-PQnlWklaJFaNwJsRdou0Rx32Ld6bt57-Tq1kdA&m=5gxv-oyYguavxooD6KV1W941gpXl9o3gebqrkNukZrw&s=vJ6SRJMhwHwyi1fM62NUzpQqpcyeyLzJbAF0xYoCFsk&e=>
>AN INTEL COMPANY
--
sent from my mobile device
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
More information about the Spacewalk-list
mailing list