[Spacewalk-list] RHNSearch Database Connection

[Paul Robert Marino]

this was fixed in the nightly which is the bleeding edge build 2.1 is
an old version now in general the spacewalk project doesn't back port
patches to previous versions.
For now you can use the old workaround which is to use an iptables
rule to forward the port on your loopback to the real database server

On Fri, Oct 3, 2014 at 5:31 PM, Jeremy Darr <jeremy.darr at gmail.com> wrote:
> As said, I applied both in sequence. Patch #1 did not help. Patch #2 also
> did not help. My process for this was:
>
> git clone -b SPACEWALK-2.1 https://github.com/spacewalkproject/spacewalk
> cd spacewalk/search-server/spacewalk-search/
> [apply patch]
> tito build --rpm --test
> [transfer rpm to app server]
> rpm -ev spacewalk-search
> rpm -ivh [local spacewalk-search package]
> /etc/init.d/rhn-search cleanindex
>
> The relevant piece that I expected to change did not and looks like this:
>
> jdbcUrl -> jdbc:postgresql:swdb00
>
> My current server that I'm migrating away from (mentioned in my original
> post) appears to have the full URL (
> https://www.redhat.com/archives/spacewalk-list/2014-September/msg00114.html
> ):
>
> jdbcUrl -> jdbc:postgresql://my_database_host:5432/swdb00
>
> Any other thoughts on what might be going wrong?
>
> - Jeremy
>
> On Fri, Oct 3, 2014 at 1:58 AM, Tomas Lestach <tlestach at redhat.com> wrote:
>>
>> > 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.
>>
>>
>> Hello,
>>
>> bugzilla patch in Comment#1 isn't correct. I would not apply it.
>> The github patch should be sufficient for rhn-search to connect to
>> external PG database.
>>
>>
>> Regards,
>> --
>> Tomas Lestach
>> Red Hat Satellite Engineering, Red Hat
>>
>> _______________________________________________
>> 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