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

    OpenSpecimen v2.0.beta.01 release

    Announcements
    #1

    OpenSpecimen v2.0.beta.01 has been released.

    New build is available for download under Releases.

    View the Release notes to see the list of bugs fixed and features implemented in this build.
    Instructions to deploy the build is available at Deployment guide.

    The current build supports fresh deployment only. The upgrade from previous versions will be supported in the upcoming releases.

    OpenSpecimen Deployment Error
    #2

    Hi, for the mysql version there is no sql dump to do a fresh deployment

    #3

    Hi @vmoreno,

    The sql dump is not required any more. You just need to create an empty database and follow the steps mentioned in the deployment guide. That will automatically take care of creating tables and other things.

    ~Nitesh

    #4

    Thanks,
    It worked now, but it seems the mysql database requires in /etc/my.cnf the option
    lower_case_table_names=1

    I found that in some post of version 1.0. This is unfortunate because it may break other databases the mysql sever may have with mixed or uppercase table names.
    The problems are related to at least 9 tables of openspecimen:
    DATABASECHANGELOG
    DATABASECHANGELOGLOCK
    DYEXTN_CONTAINERS
    DYEXTN_ID_SEQ
    OS_CONTAINER_POSITIONS
    OS_STORAGE_CONTAINERS
    OS_STOR_CONTAINER_CPS
    OS_STOR_CONT_SPEC_CLASSES
    OS_STOR_CONT_SPEC_TYPES

    You could probably remove this requirement by renaming these tables to lowercase.
    If I am right and lower_case_table_names=1 is a requirement it should be mentioned in steps to deployment to help new users.

    #5

    Hi @vmoreno,

    Thanks for the feedback. These both issues(case sensitivity and INNODB DB engine) are legacy issues. We have them in the TODO list to fix in next build.

    Sorry for the inconvenience.

    ~Nitesh