To be more specific and to correct my previous post, I made the following changes:
https://bugzilla.redhat.com/attachment.cgi?id=931659&action=diff https://github.com/spacewalkproject/spacewalk/commit/4073abaf7bc7f17b738bcc0ca64e657ab9d074bf I did these separately and tried both methods, neither adjusted where rhn-search looked for the database. - Jeremy On Thu, Oct 2, 2014 at 11:28 AM, Jeremy Darr <[email protected]> wrote: > So I took the changes shown in > https://bugzilla.redhat.com/attachment.cgi?id=931659&action=diff and > applied this to the current 2.1 branch, built the package and installed it > on my application server. This did not alter the behavior of rhn-search in > the slightest. Am I missing something here (other changes that need to be > done) or is this working for someone else? > > - Jeremy > > On Wed, Sep 24, 2014 at 3:27 AM, Tomas Lestach <[email protected]> > wrote: > >> Thank you for the provided information. >> >> I fixed the issue for spacewalk nightly [1]. >> The patch available in bugzilla [2] does not consider embedded PG >> installations. >> >> Regards, >> -- >> Tomas Lestach >> Red Hat Satellite Engineering, Red Hat >> >> [1] >> https://github.com/spacewalkproject/spacewalk/commit/4073abaf7bc7f17b738bcc0ca64e657ab9d074bf >> [2] https://bugzilla.redhat.com/show_bug.cgi?id=1085033#c1 >> >> >> ----- Original Message ----- >> > From: "Jeremy Darr" <[email protected]> >> > To: [email protected] >> > Sent: Tuesday, September 23, 2014 6:34:25 PM >> > Subject: Re: [Spacewalk-list] RHNSearch Database Connection >> > >> > >> > >> > >> > Currently I have all necessary information for this connection: >> > >> > >> > >> > [root@my_host ~]# egrep 'db_(host|name|port)' /etc/rhn/rhn.conf >> > db_name = swdb00 >> > db_host = my_db_host >> > db_port = 5432 >> > >> > >> > I will be testing the patch submitted earlier in this thread tomorrow >> > evening during a maintenance window for my Spacewalk installation. I >> > will let everyone know whether that fixes the issue. >> > >> > >> > - Jeremy >> > >> > >> > On Tue, Sep 23, 2014 at 2:07 AM, Tomas Lestach < [email protected] >> > > wrote: >> > >> > >> > Hello, >> > >> > what does >> > # egrep 'db_(host|name|port)' /etc/rhn/rhn.conf >> > say? >> > >> > Regards, >> > -- >> > Tomas Lestach >> > Red Hat Satellite Engineering, Red Hat >> > >> > >> > >> > >> > ----- Original Message ----- >> > > From: "Jeremy Darr" < [email protected] > >> > > To: [email protected] >> > > Sent: Saturday, September 20, 2014 1:06:35 AM >> > > Subject: [Spacewalk-list] RHNSearch Database Connection >> > > >> > > >> > > >> > > Recently, while attempting to migrate Spacewalk from a CentOS5 to a >> > > CentOS6 server, we encountered an issue with rhnsearch. It appears >> > > that rhnsearch believes that the database is found at 'localhost' >> > > as >> > > opposed to the server that the database lives on. Odd thing is, >> > > every other piece of software for Spacewalk communicates with the >> > > database just fine. Here is the output when running an >> > > "/etc/init.d/rhnsearch cleanindex" command: >> > > >> > > >> > > >> > > >> > > INFO: Initializing c3p0 pool... >> > > com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, >> > > acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, >> > > autoCommitOnClose -> false, automaticTestTable -> null, >> > > breakAfterAcquireFailure -> false, checkoutTimeout -> 0, >> > > connectionCustomizerClassName -> >> > > com.redhat.satellite.search.config.translator.RhnConnectionCustomizer, >> > > connectionTesterClassName -> >> > > com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> >> > > qzsrcd9411kwsxn1wwivba|69af0db6, >> > > debugUnreturnedConnectionStackTraces -> false, description -> null, >> > > driverClass -> org.postgresql.Driver, factoryClassLocation -> null, >> > > forceIgnoreUnresolvedTransactions -> false, identityToken -> >> > > qzsrcd9411kwsxn1wwivba|69af0db6, idleConnectionTestPeriod -> 0, >> > > initialPoolSize -> 3, jdbcUrl -> jdbc:postgresql:swdb00 , >> > > maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime >> > > -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, >> > > maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> >> > > 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> >> > > 0, preferredTestQuery -> null, properties -> {user=******, >> > > password=******}, propertyCycle -> 0, testConnectionOnCheckin -> >> > > false, testConnectionOnCheckout -> false, >> > > unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies >> > > -> false ] >> > > >> > > I'm not certain where to set configuration values for the following >> > > from the above output: >> > > >> > > jdbcUrl -> jdbc:postgresql:swdb00 >> > > >> > > >> > > Does anyone happen to know where this configuration value lives? >> > > >> > > - Jeremy >> > >> > >> > > _______________________________________________ >> > > Spacewalk-list mailing list >> > > [email protected] >> > > https://www.redhat.com/mailman/listinfo/spacewalk-list >> > >> > _______________________________________________ >> > Spacewalk-list mailing list >> > [email protected] >> > https://www.redhat.com/mailman/listinfo/spacewalk-list >> > >> > >> > _______________________________________________ >> > Spacewalk-list mailing list >> > [email protected] >> > https://www.redhat.com/mailman/listinfo/spacewalk-list >> >> _______________________________________________ >> Spacewalk-list mailing list >> [email protected] >> https://www.redhat.com/mailman/listinfo/spacewalk-list >> > >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
