The Adapter uses the SHRINE user to run queries on i2b2's CRC.
To set up the standard SHRINE application user, you will need to connect to the i2b2pm database and insert entries for this user (NB: the actual database name may be different from what is displayed here, but the essential element is that you should locate the tables below in the correct database and schema before proceeding):
A brief note of explanation is in order for the insert statement for the PM_USER_DATA table. The value for the password field is actually a modified MD5 hash of the actual password. However, to the best of our knowledge, a standard MD5 algorithm does not always generate the correct hash in this situation. Instead, the following python script should be used to generate the hash:
You should save this code to your local disk (for the purpose of this example, you should name it "i2b2_hash_generator.py"), set its execute bit, and then run the command below. If your syntax is correct, the program should display the correct hash that you can use to create the user as indicated above: