[Spacewalk-list] RHNSearch Database Connection

[Jeremy Darr]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140919/0a03d4be/attachment.htm>