Description of problem: a small bug: On the page 12.7. Migrating the Database (https://documentation-devel.engineering.redhat.com/site/documentation/en-US/Red_Hat_Satellite/5.7/html/Installation_Guide/sect-Migrating_the_Database.html#sect-Migrating_from_an_Embedded_Database_to_a_Managed_Database), there is missing one letter "L" in the word "satellite" Actual results: [root@satellite ~]# rhn-satelite stop Expected results: [root@satellite ~]# rhn-satellite stop
Sorry the page is "12.7.1. Migrating from an Embedded Database to a Managed Database"
I have a next, on the page "Migrating from a Managed Database to an Embedded Database" (https://documentation-devel.engineering.redhat.com/site/documentation/en-US/Red_Hat_Satellite/5.7/html/Installation_Guide/sect-Migrating_from_a_Managed_Database_to_an_Embedded_Database.html) paragraph No.9 <DOC paragraph No.9> Remove any values created by spacewalk-setup-postgresql from the /var/lib/pgsql/data/pg_hba.conf and /var/lib/pgsql/data/postgresql.conf files. These should appear at the very end of these files. </DOC> There is a bad path to configuration of postgresql. Sat5.7 has got postgresql from the SCL and config files are placed in the /opt/rh/postgresql92/root/var/lib/pgsql/data/. I guess, the sentence is a little ambiguous and confusing, because how the user knows, what the spacewalk-setup-postgresql created in the file "pg_hba.conf". In the file postgresql.conf there is placed a comment, but in the file pg_hba.conf isn't. All lines with the word "spacesatschema" cannot be deleted. > tail /opt/rh/postgresql92/root/var/lib/pgsql/data/pg_hba.conf local spacesatschema spacesatuser md5 host spacesatschema spacesatuser 127.0.0.1/8 md5 host spacesatschema spacesatuser ::1/128 md5 local spacesatschema postgres ident map=usermap local postgres postgres ident map=usermap host spacesatschema spacesatuser 10.0.0.0/8 md5 > tail /opt/rh/postgresql92/root/var/lib/pgsql/data/postgresql.conf effective_cache_size = 1152MB log_line_prefix = '%m ' maintenance_work_mem = 96MB max_connections = 600 shared_buffers = 384MB wal_buffers = 4MB work_mem = 2560kB bytea_output = 'escape' ### spacewalk-setup-postgresql modified values for a standalone PostgreSQL database listen_addresses='*'
The same page "Migrating from a Managed Database to an Embedded Database". <DOC paragraph No.8> Add the postgresql service to the /etc/rhn/service-list file to ensure that it is started and stopped in parallel with Red Hat Satellite. [root@satellite ~]# echo "SERVICES=\"postgresql \$SERVICES\"" >> /etc/rhn/service-list </DOC> In the Sat5.7, the service is called "postgresql92-postgresql". The command should be something as this: [root@satellite ~]# echo "SERVICES=\"postgresql92-postgresql \$SERVICES\"" >> /etc/rhn/service-list
The same page "Migrating from a Managed Database to an Embedded Database". <DOC paragraph No.7> Edit the /etc/rhn/rhn.conf file to remove the db_port and db_hostname values. [root@satellite ~]# sed -i 's/db_hostname\s*=.*/db_hostname = /' /etc/rhn/rhn.conf [root@satellite ~]# sed -i 's/db_port\s*=.*/db_port = /' /etc/rhn/rhn.conf </DOC> In rhn.conf, there is not variable "db_hostname" and I guess there never was. > grep -c db_hostname /etc/rhn/rhn.conf 0 Variable for hostname of database is called "db_host". The command should be something as this: Edit the /etc/rhn/rhn.conf file to remove the db_port and db_host values. [root@satellite ~]# sed -i 's/db_host\s*=.*/db_host = /' /etc/rhn/rhn.conf [root@satellite ~]# sed -i 's/db_port\s*=.*/db_port = /' /etc/rhn/rhn.conf
Again the page 12.7. Migrating the Database (https://documentation-devel.engineering.redhat.com/site/documentation/en-US/Red_Hat_Satellite/5.7/html/Installation_Guide/sect-Migrating_the_Database.html#sect-Migrating_from_an_Embedded_Database_to_a_Managed_Database) --------------------------------------------------------------------- The problem with path. The same problem as the comment 2. <DOC paragraph No.4> After you have installed the Managed External Database, shut it down and back up the database configuration and access control files. [root@manageddb ~]# db-control stop [root@manageddb ~]# cp /var/lib/pgsql/data/postgresql.conf ~/dbbackup [root@manageddb ~]# cp /var/lib/pgsql/data/pg_hba.conf ~/dbbackup You need to backup these files because the migration process will erase them. </DOC> <DOC paragraph No.6> Restore the database configuration and access control files from backup to the Managed Database. [root@manageddb ~]# cp ~/dbbackup/postgresql.conf /var/lib/pgsql/data/postgresql.conf [root@manageddb ~]# cp ~/dbbackup/pg_hba.conf /var/lib/pgsql/data/pg_hba.conf </DOC> --------------------------------------------------------------------- The same problem as the comment 3. <DOC No.8> Remove postgresql from the /etc/rhn/service-list file on the Satellite server. [root@satellite ~]# sed -i 's/postgresql//g' /etc/rhn/service-list </DOC> --------------------------------------------------------------------- The same problem as the comment 4. + we have to set a variable "db_port". <DOC paragraph No.6> On the Satellite server, edit the /etc/rhn/rhn.conf file and change db_hostname to the domain name of the Managed Database. For example: db_hostname = manageddb.example.com </DOC> db_host = manageddb.example.com db_port = 5432 --------------------------------------------------------------------- Very sorry, that I split this bug into small pieces. My mind process was little chaotic. :)
Okay, I've made some last minutes fixes before publishing live: comment #1 - Fixed Typo comment #2 - I've removed the line due to ambiguity comment #3 - Fixed the service name comment #4 - Changed the db_hostname to db_host comment #5 - Fixed the paths, fixed the service name, changed to db_host, and added db_port Content rebuilt here: https://documentation-devel.engineering.redhat.com/site/documentation/en-US/Red_Hat_Satellite/5.7/html/Installation_Guide/sect-Migrating_the_Database.html
I've greped the 5.7 docs and all the database locations should be fixed now.