[Spacewalk-list] RHNSearch Database Connection

[Jeremy Darr]

To be more specific and to correct my previous post, I made the following
changes:

https://bugzilla.redhat.com/attachment.cgi?id=931659&action=diff
https://github.com/spacewalkproject/spacewalk/commit/4073abaf7bc7f17b738bcc0ca64e657ab9d074bf

I did these separately and tried both methods, neither adjusted where
rhn-search looked for the database.

- Jeremy

On Thu, Oct 2, 2014 at 11:28 AM, Jeremy Darr <jeremy.darr at gmail.com> wrote:

> 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 <tlestach at redhat.com>
> 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" <jeremy.darr at gmail.com>
>> > To: spacewalk-list at redhat.com
>> > 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 at 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 < tlestach at redhat.com
>> > > 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" < 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
>> >
>> > _______________________________________________
>> > Spacewalk-list mailing list
>> > Spacewalk-list at redhat.com
>> > https://www.redhat.com/mailman/listinfo/spacewalk-list
>> >
>> >
>> > _______________________________________________
>> > Spacewalk-list mailing list
>> > Spacewalk-list at redhat.com
>> > https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20141002/5d2bc667/attachment.htm>