question on configuring development machine

LabKey Support Forum (Inactive)
question on configuring development machine Ben Bimber  2010-06-29 05:30
Status: Closed
 
I recently installed win7 64-bit and had to reconfigure labkey on my development machine. I have labkey running, but have 2 questions:

1. when i start debug in intellij, the console gives this notice:

INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files (x86)\Java\jdk1.6.0_20\bin;.;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Perl\site\bin;C:\Perl\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\TortoiseSVN\bin;C:\Program Files\SlikSvn\bin\;C:\Program Files (x86)\QuickTime\QTSystem\;c:\program files (x86)\jetbrains\intellij idea 94.192\jre\jre\bin

The labkey documentation below does not say anything about adding tomcat to my path, should I? Doc here:
https://www.labkey.org/wiki/home/Documentation/page.view?name=build

2. Our production server runs 10.1. On my machine I built from the 10.2 branch. I used pg_dump to make a copy of the production server and restore the labkey, postgres and template1 databases from the production server onto my machine. I realize they are different versions, but this has worked once or twice before. I am able to start labkey on my machine and the pages look normal. However, queries are not loading. If I look in pg_admin, stuff like this is running:

    -- <QueryServiceImpl.getSelectSQL()>
    SELECT Key, ReportName, Report_Category, ReportType, ReportTitle, Visible, ContainerPath, Schema, QueryName, View, Report, DateFieldName, ReportCategory1, ReportCategory
    FROM (
    SELECT
    reports.key AS Key,
    CAST   

and this:

    -- <QueryServiceImpl.getSelectSQL()>
    SELECT *
    FROM (
    SELECT
    reports.key AS Key,
    CAST((SELECT StringValue FROM exp.ObjectProperty WHERE exp.ObjectProperty.PropertyId = 2041 AND exp.ObjectProperty.ObjectId = reports.objectid) AS VARCHAR(4000)) AS    

I think pg_admin might be cropping the SQL in what is displays. I assume these are the normal queries associated with loading a list? This list only has about 30 rows and this has been going for several hours, which just doesnt seem right. Is it possible something didn't copy properly when i did the pg_dump/restore? Are there troubleshooting steps I can take? Thanks for the help.
 
 
adam responded:  2010-06-29 12:20
On your first question, you shouldn't need to add Tomcat to your path and you can safely ignore the "Apache Tomcat Native library" warning -- most of our dev and production machines run without configuring the native runtime. If you really want to experiment with this runtime, download it from Apache if don't have it (I think it's now included in the 5.5.29 Windows installer) and add it to your path. http://tomcat.apache.org/tomcat-5.5-doc/apr.html

Beware, though: I recently tried running LabKey with the native runtime installed and ran into some problems. The web UI worked fine, but our Selenium tests and API actions failed to connect to the server. I didn't have time to investigate this... I just removed the library and everything started working again.

I believe you've been talking with Brian about your second question.

Adam