[Spacewalk-list] RHNSearch Database Connection

[Paul Robert Marino]

here is the bugzilla ticket https://bugzilla.redhat.com/show_bug.cgi?id=1085033
As I said some one attached a patch but I haven't had time to vet it yet.


On Sun, Sep 21, 2014 at 6:31 PM, Paul Robert Marino <prmarino1 at gmail.com> wrote:
> 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.darr at 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