<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="Generator" content="Microsoft Word 14 (filtered medium)"> <style></style> </head> <body lang="EN-US" link="blue" vlink="purple"> <div class="WordSection1"> Here we go, these were the steps that we followed to install Spacewalk:<o:p></o:p> <o:p> </o:p> To setting up spacewalk repo:<o:p></o:p> rpm -Uvh <a href="http://yum.spacewalkproject.org/2.6/RHEL/7/x86_64/spacewalk-repo-2.6-0.el7.noarch.rpm"> http://yum.spacewalkproject.org/2.6/RHEL/7/x86_64/spacewalk-repo-2.6-0.el7.noarch.rpm</a><o:p></o:p> <pre style="background:#F6F8FA"><o:p> </o:p></pre> <pre style="background:#F6F8FA">Epel repo:<o:p></o:p></pre> <pre style="background:#F6F8FA">rpm -Uvh <a href="https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm">https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm</a><o:p></o:p></pre> <o:p> </o:p> Contrib package in master and slave node of postgresql:<o:p></o:p> Yum install postgresql-contrib<o:p></o:p> <o:p> </o:p> On spacewalk server:<o:p></o:p> <pre style="background:#F6F8FA">yum install spacewalk-setup-postgresql<o:p></o:p></pre> <pre style="background:#F6F8FA"><o:p> </o:p></pre> And we create a new database on master node of postgresql with this information:<o:p></o:p> <pre style="background:#F6F8FA">su - postgres -c 'PGPASSWORD=spacepw; createdb -E UTF8 spaceschema ; createlang plpgsql spaceschema ; createlang pltclu spaceschema ; yes $PGPASSWORD | createuser -P -sDR spaceuser'<o:p></o:p></pre> <o:p> </o:p> After that, as suggested by spacewalk guide:<o:p></o:p> <![if !supportLists]>· <![endif]>Pg_hba.conf (of master/slave node of postgresql):<o:p></o:p> local spaceschema spaceuser md5<o:p></o:p> host spaceschema spaceuser 192.168.0.0/16 md5 <o:p></o:p> <o:p> </o:p> increase maximal number of connections to 600:<o:p></o:p> <pre style="background:#F6F8FA">echo max_connections = 600 >>/var/lib/pgsql/data/postgresql.conf<o:p></o:p></pre> <pre style="background:#F6F8FA"><o:p> </o:p></pre> When we try again to setting up Spacewalk, the output its:<o:p></o:p> # spacewalk-setup --external-postgresql <o:p></o:p> ** Database: Setting up database connection for PostgreSQL backend.<o:p></o:p> ** Database: Populating database.<o:p></o:p> The Database has schema. Would you like to clear the database [Y]? Y<o:p></o:p> ** Database: Clearing database.<o:p></o:p> ** Database: Shutting down spacewalk services that may be using DB.<o:p></o:p> ** Database: Services stopped. Clearing DB.<o:p></o:p> ** Database: Re-populating database.<o:p></o:p> *** Progress: ###########################<o:p></o:p> * Configuring tomcat.<o:p></o:p> * Setting up users and groups.<o:p></o:p> ** GPG: Initializing GPG and importing key.<o:p></o:p> * Performing initial configuration.<o:p></o:p> * Configuring apache SSL virtual host.<o:p></o:p> ** Skipping SSL virtual host configuration.<o:p></o:p> * Configuring jabberd.<o:p></o:p> * Creating SSL certificates.<o:p></o:p> ** SSL: Generating CA certificate.<o:p></o:p> ** SSL: Deploying CA certificate.<o:p></o:p> ** SSL: Generating server certificate.<o:p></o:p> ** SSL: Storing SSL certificates.<o:p></o:p> * Deploying configuration files.<o:p></o:p> * Update configuration in database.<o:p></o:p> * Setting up Cobbler..<o:p></o:p> * Restarting services.<o:p></o:p> ((%%))<o:p></o:p> Tomcat failed to start properly or the installer ran out of tries. Please check /var/log/tomcat*/catalina.out for errors.<o:p></o:p> <pre style="background:#F6F8FA"><o:p> </o:p></pre> <o:p> </o:p> Ouput of some lines of postgresql logs…<o:p></o:p> 2018-02-13 13:36:18.975 EST [3221] FATAL: sorry, too many clients already<o:p></o:p> 2018-02-13 13:36:18.976 EST [3222] FATAL: sorry, too many clients already<o:p></o:p> 2018-02-13 13:36:18.977 EST [3223] FATAL: sorry, too many clients already<o:p></o:p> 2018-02-13 13:37:22.100 EST [3271] WARNING: there is no transaction in progress<o:p></o:p> 2018-02-13 13:37:22.103 EST [3271] WARNING: there is no transaction in progress<o:p></o:p> 2018-02-13 13:37:22.120 EST [3271] WARNING: there is no transaction in progress<o:p></o:p> 2018-02-13 13:37:22.147 EST [3271] WARNING: there is no transaction in progress<o:p></o:p> 2018-02-13 13:37:22.179 EST [3271] WARNING: there is no transaction in progress<o:p></o:p> <o:p> </o:p> For setting up Pgpool-II cluster we follow the next steps:<o:p></o:p> <o:p> </o:p> <![if !supportLists]>· <![endif]>Pgpool-II version 3.6.7 (subaruboshi) installed with three nodes. <o:p></o:p> <o:p> </o:p> Spacewalk guide says 600 connections are necessary to be opened, so in pgpool.conf we set:<o:p></o:p> # - Concurrent session and pool size -<o:p></o:p> #Originally set in 32<o:p></o:p> num_init_children = 200<o:p></o:p> # Number of concurrent sessions allowed<o:p></o:p> # (change requires restart)<o:p></o:p> max_pool = 3<o:p></o:p> # Number of connection pool caches per connection<o:p></o:p> # (change requires restart)<o:p></o:p> Where num_init_children * max_pool = connections permitted (<a href="http://www.pgpool.net/mediawiki/index.php/Relationship_between_max_pool,_num_init_children,_and_max_connections">http://www.pgpool.net/mediawiki/index.php/Relationship_between_max_pool,_num_init_children,_and_max_connections</a>)<o:p></o:p> <o:p> </o:p> Ouput of some lines of pgpool-II logs…<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 3266 statement: " drop schema if exists rpm cascade ;" message: "drop cascades to 5 other objects"<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: backend [0]: NOTICE: drop cascades to 5 other objects<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 3266 statement: " drop schema if exists rhn_exception cascade ;" message: "drop cascades to 3 other objects"<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: backend [0]: NOTICE: drop cascades to 3 other objects<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 3266 statement: " drop schema if exists rhn_config cascade ;" message: "drop cascades to 8 other objects"<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: backend [0]: NOTICE: drop cascades to 8 other objects<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 3266 statement: " drop schema if exists rhn_server cascade ;" message: "drop cascades to 20 other objects"<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: backend [0]: NOTICE: drop cascades to 20 other objects<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 3266 statement: " drop schema if exists rhn_entitlements cascade ;" message: "drop cascades to 8 other objects"<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: backend [0]: NOTICE: drop cascades to 8 other objects<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 3266 statement: " drop schema if exists rhn_bel cascade ;" message: "schema "rhn_bel" does not exist, skipping"<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: backend [0]: NOTICE: schema "rhn_bel" does not exist, skipping<o:p></o:p> 2018-01-27 10:09:04: pid 22707: LOG: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 3266 statement: " drop schema if exists rhn_cache cascade ;" message: "drop cascades to 3 other objects"<o:p></o:p> <o:p> </o:p> And:<o:p></o:p> <o:p> </o:p> 2018-01-27 10:10:27: pid 22162: LOG: fork a new child process with pid: 22935<o:p></o:p> 2018-01-27 10:10:27: pid 22636: ERROR: unable to read data from frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22636: DETAIL: EOF encountered with frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22929: ERROR: unable to read data from frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22929: DETAIL: EOF encountered with frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22740: LOG: selecting backend connection<o:p></o:p> 2018-01-27 10:10:27: pid 22740: DETAIL: failback event detected, discarding existing connections<o:p></o:p> 2018-01-27 10:10:27: pid 22811: ERROR: unable to read data from frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22811: DETAIL: EOF encountered with frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22757: ERROR: unable to read data from frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22757: DETAIL: EOF encountered with frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22925: ERROR: unable to read data from frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22925: DETAIL: EOF encountered with frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22749: ERROR: unable to read data from frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22749: DETAIL: EOF encountered with frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22752: ERROR: unable to read data from frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22752: DETAIL: EOF encountered with frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22919: ERROR: unable to read data from frontend<o:p></o:p> 2018-01-27 10:10:27: pid 22919: DETAIL: EOF encountered with frontend<o:p></o:p> <o:p> </o:p> Regards,<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <div> Eduardo Capistran | Principal Linux Engineer | IS Server Operations <o:p></o:p> Herbalife Nutrition | Camino al ITESO No. 8900 INT 1A, Col El Mante, Tlaquepaque, Jalisco 45609<o:p></o:p> x6452 + 5954 | +52 (33) 37705400 x5954 | +52 (1) 333-808-6131 | <a href="mailto:eduardocap@herbalife.com">eduardocap@herbalife.com </a><o:p></o:p> </div> <o:p> </o:p> <div> <div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"> From: Avi Miller [mailto:avi.miller@oracle.com] Sent: jueves, 15 de febrero de 2018 11:17 a.m. To: Eduardo Capistrán Cc: spacewalk-list@redhat.com; Server Ops_Linux Subject: Re: [External] [Spacewalk-list] Spacewak 2.7 and PgPool-II integration problems<o:p></o:p> </div> </div> <o:p> </o:p> Hey Eduardo<o:p></o:p> <div> <o:p></o:p> <div> On 15 Feb 2018, at 7:12 pm, Eduardo Capistrán <<a href="mailto:eduardocap@herbalife.com">eduardocap@herbalife.com</a>> wrote:<o:p></o:p> </div> <o:p> </o:p> <div> <div> Thanks for your reply Avi,<o:p></o:p> </div> <div> <o:p></o:p> </div> <div> We have installed spacewalk 2.7 in Oracle Linux using the embedded postgresql method without problem since version 1.9.<o:p></o:p> </div> </div> <div> <o:p> </o:p> </div> <div> That's good to know. <o:p></o:p> </div> <o:p></o:p> <div> <div> We are now trying to move to a HA architecture and we are facing these kind of problems.<o:p></o:p> </div> <div> Any success case you know making usage of porsgres cluster with pgpool-II ?<o:p></o:p> </div> </div> <o:p> </o:p> </div> <div> To be honest, we don't test (or support) PostgreSQL or pgpool. We do test and support Spacewalk with Oracle Database RAC, but I guess that's not an option here. :) <o:p></o:p> </div> <div> <o:p> </o:p> </div> <div> I would suggest perhaps providing the configuration steps you followed exactly in mode detail so that any PostgreSQL/pgpool experts can chime in, because the original email didn't have much detail on how you configured Spacewalk during installation.<o:p></o:p> </div> <div> <o:p> </o:p> </div> <div> Cheers,<o:p></o:p> </div> <div> Avi<o:p></o:p> </div> <o:p> </o:p> <div> -- Oracle <<a href="http://www.oracle.com">http://www.oracle.com</a>> Avi Miller | Product Management Director | +61 (3) 8616 3496 Oracle Linux and Virtualization 417 St Kilda Road, Melbourne, Victoria 3004 Australia <o:p></o:p> </div> <o:p> </o:p> </div> </body> </html>