Red Hat Bugzilla – Bug 829958
spacewalk-setup is very unfriendly about handling if postgresql plpgsql is not created
Last modified: 2012-11-01 12:22:59 EDT
Description of problem: Following the directions at https://fedorahosted.org/spacewalk/wiki/HowToInstall results in an generic error that the database could not be populated. The helpful error message that plpgsql must be loaded is hidden away in /var/log/rhn/populate_db.log Given the project is now called spacewalk, this seems like an odd location for a spacewalk novice to go searching for logs. Also, this log location is never stated in HowToInstall or by the output of the spacewalk-setup script. Version-Release number of selected component (if applicable): 1.7 How reproducible: Always Steps to Reproduce: 1.Install CentOS 6 2.Follow the instructions at https://fedorahosted.org/spacewalk/wiki/HowToInstall 3. Actual results: spacewalk-setup script outputs: "Could not populate database." Expected results: If the postgresql user provided to the script has superuser access, then I expect the script to attempt to issue the create language plpgsql itself. For any error where the script fails to populate the database, my expectation is that the location of the populate_db.log would be provided as part of the error message. Additional info:
(In reply to comment #0) > > The helpful error message that plpgsql must be loaded is hidden away in > /var/log/rhn/populate_db.log Given the project is now called spacewalk, > this seems like an odd location for a spacewalk novice to go searching for > logs. Also, this log location is never stated in HowToInstall or by the > output of the spacewalk-setup script. I've now amended the HowToInstall page with reference to /var/log/rhn. > Expected results: > If the postgresql user provided to the script has superuser access, then I > expect the script to attempt to issue the create language plpgsql itself. The expectation is really wrong here -- Spacewalk expects the plpgsql language to be created in the database beforehand -- please see https://fedorahosted.org/spacewalk/wiki/PostgreSQLServerSetup.