Re: [Spacewalk-list] RHNSearch Database Connection

[Paul Robert Marino]

This is a known bug I found it and submitted a report some time ago. Recently someone submitted a patch for it but its not throughly tested yet. I'll send yo a link to the bugzilla ticket tomorrow. 

-- Sent from my HP Pre3

---

On Sep 19, 2014 7:11 PM, Jeremy Darr <jeremy.d...@gmail.com> wrote:

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
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list