We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Need help with Installation Step-I Configure the OpenClinica Application

! I am installing OpenClinica Database following below instruction,
https://github.com/OpenClinica/OpenClinica/wiki/Install-OpenClinica-v3.6-and-higher-on-Windows#A7

I think I successfully finished from step A to H—I could verify that the Tomcat is fully started “INFO: Server Startup in 930 ms”
However, I have some problem with Step-I, “Configure the OpenClinica Application ”

Would you please help to configure the datainfo.properties file in attached?
The password I selected when I set-up PostreSQL is: isd
Other settings are default value.

Please let me know if you need more information.
Thank you!

#############################################################################
# 1 - Database Configuration
#
# Database configuration is done with the following 6

properties
# The dbType options are either postgres or oracle.
# Enter the user name and password to access the database in
# dbUser and dbPass.
# The db field is for

the name of the database and provide the port
# in dbPort.
# dbHost can be a URL, IP address or localhost
#
# REQUIRED
#############################################################################
dbType=${dbType}
dbUser=${dbUser}
dbPass=${dbPass}
db=${db}
dbPort=${dbPort}
dbHost=

${dbHost}

#############################################################################
# 2 - filePath
#
# File Path is the string which declares the
# repository for

all uploaded and generated
# files in the system, including CRFs and
# data sets. The directory should NOT be
# accessible by the web server.
#
# REQUIRED.
#############################################################################
filePath=${catalina.home}/${WEBAPP.lower}.data/

#############################################################################
# 3 - Attached File Location
# Location for files if item data type is "file". If it has

been kept empty,
# "filePath" will be used as the attached file location.
# This will be a sub folder within the filePath location only.
# You may configure a full

path that points to a directory outside of the filePath.
# If you configure a full path, it must have a trailing slash.
# Example = /usr/local/attached_file/ or C:\

\attached_file\\
#
# NOT REQUIRED
#############################################################################
# attached_file_location=

#############################################################################
# 4 - user_account_notification
#
# User Account Notification is the method by
# which new

users are sent their passwords.
# Users can be sent passwords via email,
# or the password can be displayed on the screen
# to the administrator, who is instructed to
#

write it down and physically give it to the user
# in question. The default is email.
#
# REQUIRED.
#############################################################################
userAccountNotification=email

#############################################################################
# 5 - adminEmail
#
# The Admin Email is the field to set the administrator's
# email for a

given server. It is also used for
# replies to the email messages sent by the system.
#
# REQUIRED
#############################################################################
[email protected]

#############################################################################
# 6- Spring Based Email System
#
# Configure the Email SMTP host below. If the host
#

requires a username and password make sure
# mail.smtp(s).auth is set to true.
# Configure mail protocol via mail.protocol, Valid options
# would be smtp or smtps.
#

Configure smtp over ttls by setting mail.smtp(s).starttls.enable
# to true.
# Configure connection timeout. Preconfigred to 5 secs
#############################################################################
mailHost=mail.smtp.com
mailPort=25
mailProtocol=smtp
mailUsername=
mailPassword=
mailSmtpAuth=false
mailSmtpStarttls.enable=false
mailSmtpsAuth=false
mailSmtpsStarttls.enable=false
mailSmtpConnectionTimeout=100
[email protected]

#############################################################################
# 8 - sysURL
#
# The web address for the system. It can either be an external
# address

(demo.openclinica.org) or an internal IP
# address (192.168.2.000).
# NOTE: If you reconfigure the address or port in some later
# step, such as by configuring SSL,

you will need to come back
# and update this file. You will also need to restart tomcat
# for changes to this take effect.
#
# REQUIRED
#############################################################################
sysURL=http://localhost:8080/${WEBAPP}/MainMenu

#############################################################################
# 9 - max_inactive_interval
#
# This is maximum time interval between client requests.

That is,
# if users leave any page open without sending a request to the
# server, after this time interval, when users attempt sending
# request they will be directed

to login page.
#
# REQUIRED
#############################################################################
maxInactiveInterval=3600

#############################################################################
# 11 - Logging configuration

# SysLog support has been fully implemented in OpenClinica,

but by default has been turned off.
# Every piece of code that could send information to the syslog server has not been reviewed
# and cleaned to ensure it is

entirely readable and useful. This will be an ongoing effort
# and resolved in a future release. Please use the SysLog support at your own risk.
#
# Specify the log

location - local/syslog/both
#
log.dir=${catalina.home}/logs/openclinica
logLocation=local
#
# Specify logging level - trace/debug/info/warn/error
logLevel=info
syslog.host=localhost
syslog.port=514

#############################################################################
# 12- News/About
# On the OpenClinica login screen,

there will be a box to the right of the login section
# which can contain an RSS feed. You can configure what RSS feed is used in the rss.rl field.
# If you do not

want the RSS feed, please comment out rss.url and rss.more and uncomment
# about.text1 and about.text2. These two fields can be used for any free form text that

you
# you want to appear on the OpenClinica login page.
# the default feed is http://clinicalresearch.wordpress.com/feed/
# default value for rss.more


Comments

  • GerbenRienkGerbenRienk Posts: 808 ✭✭✭
    Hi,
    Did you complete step G. Set Up the PostgreSQL Database ?
    If so, you should have a user clinica and a database openclinica.
    Then the first part of your datainfo.properties would look something like:
    dbType=postgres
    dbUser=clinica
    dbPass=clinica
    db=openclinica
    dbPort=5432
    dbHost=localhost
    etc.
    Kind regards,
    Gerben Rienk
  • TziporaTzipora Posts: 21
    I have the same problem.
    what do i need to write in "dbHost"?
    just "localHost" or something else?

    in addition,
    i didn't understand what is the URL for openClinica?
  • BinaryVisionBinaryVision Posts: 42
    If PostgreSQL is installed on the same server as Tomcat then dbHost can be localhost (aka 127.0.0.1).

    the URL can be left dynamic as is if you are using for development purposes only. However, it is sent to users in emails from the system, so you may want to explicitly change it. If a user clicks on the link with 'localhost' in the address that obviously won't resolve

    If you're just running locally, and not public online, Tomcat is running on the default HTTP port 8080, then the URL could be defined as http://theserver'sIP:8080/{WEBAPP} {WEBAPP} is case sensitive and should be the name of your WAR in Tomcat\Webapps folder (default is OpenClinica unless you renamed). e.g. http://10.0.0.50:8080/OpenClinica (the MainMenu is not required). Once you install an SSL cert and change your connector in server.xml, you would have to change this URL as well to the correct URL if port 443 then https and no port number, if port 8443, then https and :8443 is needed in the URL
  • TziporaTzipora Posts: 21
    complicated...

    I uploaded my datainfo file. can you please check if it is OK. My purpose is to develop from my pc and distribute surveys so people will be able to fill them from all over the world by the web

    maybe, in future I will need SSL too.
Sign In or Register to comment.