• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
    •

    Trouble Deploying OS in Tomcat 7

    Technical Questions
    #1

    I have gone through the steps in https://openspecimen.atlassian.net/wiki/pages/viewpage.action?pageId=1115955 to deploy OS to Tomcat 7. Some essential steps I had to make for on fresh install (after a few Foreign Key Constraint errors thrown by MySQL ) were:

    SHOW VARIABLES LIKE ‘%FOREIGN_KEY%’;

    If the FOREIGN_KEY_CHECKS=ON then execute the query below

    SET GLOBAL FOREIGN_KEY_CHECKS=0;

    and remember to set it back when you are done

    SET GLOBAL FOREIGN_KEY_CHECKS=1;

    After going through these and the steps in the link above, the application was installed successfully but on accessing the app at http://localhost:8080/openspecimen I get a black page. There are not error to report either from the logs. So far the only plugin I have compiled is os-miabis.jar. Any heads up on why this might be the case? Your insights are greatly appreciated.

    Regards,
    Caesar Olima

    #2

    Hi @caesarolima,

    If you are using Linux server to deploy OS, can you please make sure you have set the mysql’s case-sensitivity flag. To set it please follow steps in below link.

    https://openspecimen.atlassian.net/wiki/x/fAYR

    After performing the above configuration, you’ll have to drop the existing database and create new.
    You need not to make any changes for disabling the foreign key constraints as this may cause issues in future.

    If you face any issue, then please provide us tomcat log from ${TOMCAT_HOME}/logs directory.

    Thanks
    Satish Lakhani

    #3

    Hello @Satish_Lakhani,

    I have installed the application on a Windows 7 environment. The one of the settings for mysql server is:
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

    Don’t know if this should affect the running/setup of the application.

    Thanks,
    Caesar

    #4

    Hi @caesarolima,

    Here “sql_mode” can not be the issue and i also tried with the same sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES, and i was able to deploy OpenSpecimen successfully.

    Can you also make sure the default storage engine of your mysql server is set to InnoDB, as other storage engine like MyISAM does not support foreign keys. You can set default storage engine by following steps mentioned here.

    Thanks,
    Satish

    #5

    Hello @Satish_Lakhani,

    I think by default the MySQL 5.7 should come with InnoDB set as the default storage engine,I think since version 5.5 or maybe earlier, but I can set this explicitly to see if there is any changes. Additionally, let me drop and recreate the database and see if there is any change to this issue.

    Thanks,
    Caesar