[ipac] HIP search server not working?

[Jonathan Rochkind]

Hooray, that was it! Thanks so much Brian.

Even more mysteriously, my data source in both cases was called 
'horizon'. But not true! On my production server, it was called 
'horizon', and on my test server it was called 'Horizon'. Took me a 
while to notice that. The difference in capitalization was messing 
things up. But IBConsole wouldn't actually let me change capitalization 
for some reason! When I tried to change 'horizon' to 'Horizon', 
IBConsole just ignored the change, I guess it's algorithm for deciding 
if you've really made a change or not is case insensitive. Ack. So I 
just went and edited my file at 
/jboss/server/default/deploy/10sybase-ds.xml to change the case there, 
so it would match what was in IB. [Thanks to some previous HIP lister 
for pointing me to that file for another problem].

And now everything works. Man, this stuff can get tricky sometime.

Thanks so much to the list, as usual. Wouldn't be able to get anything 
done without y'all.

Jonathan

Brian Dunten wrote:
> Are you running your test HIP instance against a test database with a
> different name and/or server than the one in productino?
>
> If that is the case, you probably need to change the Horizon data source
> information in the test instance's admin database.  
>
> You will need to have access to Interbase's Ibconsole.  If I recall
> correctly, if your HIP instance is on Windows you should have a copy
> already installed on that server.  Unix/Linux users may have to install
> it on a Windows machine.
>
> You can set up a connection to your test admin database in Ibconsole,
> then log in and view the tables.  The two tables that need to be updated
> are "SOURCE" and "SOURCE_HORIZON".
>
> You should shut down all of the HIP-related processes other than
> Ibserver before making these changes.
>
> For "SOURCE", go to the data tab and find the name of your production
> Horizon database enclosed by <maindb></maindb> tags.  Change it to the
> test database name, then click "Commit & Refresh".
>
> For the "SOURCE_HORIZON" table, go to the data tab and change the
> "SOURCE_NAME" column to the name of your test databse.  Again, click
> "Commit & Refresh" to save the change.
>
> When you restart the HIP processes, it should be able to connect to the
> test database correctly.
>
> Brian Dunten
> Web Developer
> Indianapolis-Marion County Public Library
> http://www.imcpl.org
>
>
> -----Original Message-----
> From: ipac-bounces at lists.tblc.org [mailto:ipac-bounces at lists.tblc.org]
> On Behalf Of Jonathan Rochkind
> Sent: Thursday, June 14, 2007 9:23 AM
> To: Dynix's Horizon Information Portal,formerly iPac (discussion)
> Subject: [ipac] HIP search server not working?
>
>
> Thanks for the advice on querrying Sybase vs. querrying the HIP indexes.
>
> But now I have another problem, I'm afraid. We run a test/development 
> instance of HIP, which I've messed up somehow. Apparently our SD 
> contract doesn't cover any support for a test instance, so you guys are 
> my only hope.
>
> At first, I couldn't get any HIP or HIP admin pages to display at all, I
>
> just got an XSL error message. Apparently I corrupted the .gdb database 
> somehow. SD did suggest this to me, before closing my issue and telling 
> me I wasn't paying for support for a test instance.
>
> So I made a transportable backup of my production HIP .gdb, and restored
>
> that to my test instance. This did get me a step ahead, now I can access
>
> HIP admin and do get pages returned. However, all of the search boxes 
> are missing from my HIP pages. This is behavior I associate with not 
> having a search server running, but my search server IS running (I 
> started it, I can see the process in the 'ps').
>
> Anyone have any idea what might be going on? Could there be some setting
>
> in the .gdb I copied from production to test, that I need to change for 
> some reason in test?
>
> Like I say, you guys are my only hope at this point.
>
> Jonathan
> _______________________________________________
> ipac mailing list
> ipac at lists.tblc.org
> http://lists.tblc.org/mailman/listinfo/ipac
>
> _______________________________________________
> ipac mailing list
> ipac at lists.tblc.org
> http://lists.tblc.org/mailman/listinfo/ipac
>
>   

-- 
Jonathan Rochkind
Sr. Programmer/Analyst
The Sheridan Libraries
Johns Hopkins University
410.516.8886 
rochkind (at) jhu.edu