Bug 726961

Summary:	driver_postgresql.py is not able to handle password with special chars
Product:	[Community] Spacewalk	Reporter:	Alexander Yegorov <alex.yegorov>
Component:	Installation	Assignee:	Jan Pazdziora (Red Hat) <jpazdziora>
Status:	CLOSED WONTFIX	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	1.5
Target Milestone:	---
Target Release:	---
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-08-01 11:28:27 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	723481

Description Alexander Yegorov 2011-07-31 13:47:45 UTC

Description of problem:
1. spacewalk-setup is not able to run successfully, if the password contains special chars
2. /usr/bin/rhn-satellite-activate --disconnected --rhn-cert=/usr/share/spacewalk/setup/spacewalk-public.cert fails with the error about inability to connect to postgresql DB

Version-Release number of selected component (if applicable):
1.5.45

How reproducible:
Running  spacewalk-setup
Run spacewalk-setup --disconnected --answer-file=/tmp/ansfile
ansfile should contain the following value among defaults:
db-password=pass#word

Steps to Reproduce:
1. put the following into ansfile:
admin-email = root@localhost
ssl-set-org = Spacewalk Org
ssl-set-org-unit = spacewalk
ssl-set-city = My City
ssl-set-state = My State
ssl-set-country = US
ssl-password = spacewalk
ssl-set-email = root@localhost
ssl-config-sslvhost = Y
db-backend=postgresql
db-name=spaceschema
db-user=spaceuser
db-password=pass#word
db-host=host
db-port=5432
enable-tftp=Y
2.Run spacewalk-setup --disconnected --answer-file=/tmp/ansfile
3. Get the following message after  spacewalk-setup exit:
There was a problem validating the satellite certificate: 1
  
Actual results:
.....
** Activating Spacewalk.
There was a problem validating the satellite certificate: 1


Expected results:
.....
** Activating Spacewalk.
* Enabling Monitoring.
* Configuring apache SSL virtual host.
* Configuring tomcat.
* Configuring jabberd.
* Creating SSL certificates.
** SSL: Generating CA certificate.
** SSL: Deploying CA certificate.
** SSL: Generating server certificate.
** SSL: Storing SSL certificates.
* Deploying configuration files.
* Update configuration in database.
* Setting up Cobbler..
cobblerd does not appear to be running/accessible
* Restarting services.
   ((%%))
Installation complete.
Visit https://server.com to create the Spacewalk administrator account.

Additional info:

Comment 1 Jan Pazdziora (Red Hat) 2011-08-01 11:28:27 UTC

This is not about driver_postgresql.py, it's about the hash sign being used to mark comments in the config files. As such, we consider this as a known limitation.