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
