Additional Tutorials and Documentation
Space shortcuts
Space Tools

Versions Compared

Old Version 6

changes.mady.by.user Jeffrey Klann

Saved on

compared with

New Version Current

changes.mady.by.user Jeffrey Klann

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Check that the URL for the PM cell that is specified in i2b2_config_data.js in the root directory of the webclient is set correctly.
  2. SELinux might be on and causing access problems. Run sudo setenforce 0.  (If this is the problem, /var/log/audit/audit.log will have DENY messages.)
    1. Option 1 (not recommended): turn off SELinux - Run sudo setenforce 0. (Only works until reboot.)
    2. Option 2 (preferred): turn off the SELinux network connect protection - setsebool -P httpd_can_network_connect 1 (Persists across reboots.)

A user is locked out and I want to restore their access

...

You will want to enable Inter-cell SSL. See the 1.7.11 Release Notes.

I want to use Active Directory in SQLServer

If you are using SQL Server, it is possible to use Active Directory accounts for the database users (i.e., Integrated Login) in the db.properties files. To enable this, replace

<connection-url>jdbc:sqlserver://localhost:1433</connection-url>

with 

<connection-url>jdbc:sqlserver://localhost:1433;IntegratedSecurity=true;Trusted_Connection=Yes</connection-url>

Then the password field in the <security> section will be ignored and the SQLServer integrated security will be used.

How do I contribute to the i2b2 code?

...

  1. Must be tested
  2. Must include unit tests (for new features)
  3. Must include documentation (can be part of the pull request)

Tips for Optimizing i2b2 query speed

Postgres

  1. Do not use '%' in any concept code. In Postgres, this is known to prevent the database from using indexes.
  2. In Postgres, consider using table partitioning

MSSQL

  1. Use clustered columnstore indexes for the fact table.

All platforms

  1. If your fact table is extremely large, consider splitting it into multiple fact tables.
  2. ... more to come...

I can log in, but nothing else works. On the server, I see a lot of "invalid session" errors in the Wildfly log

Your database server and Wildfly server might not have the same system date and time. Make sure they are the same, and that they are in the same time zone.