[Spacewalk-list] RHNSearch Database Connection

[Tomas Lestach]

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" <jeremy.darr at gmail.com>
> To: spacewalk-list at redhat.com
> 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
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list