[Spacewalk-list] RHNSearch Database Connection

[Jeremy Darr]

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/6c916d2f/attachment.htm>