Component DB

Prerequisites:

In order to deploy or develop Component DB, you must have some support software installed. Follow the instructions below to achieve this.

# For red-hat based linux distribution run the following:
yum install -y gcc libgcc expect zlib-devel openssl-devel openldap-devel readline-devel git make cmake sed gawk autoconf automake wget mysql mysql-libs mysql-server mysql-devel curl
# For debian based linux distributions run the following:
apt-get install wget gcc git make cmake build-essential libcurses-ocaml-dev curl expect mysql-server libmysqlclient-dev openssl libssl-dev libldap2-dev libsasl2-dev sed gawk

Deployment

For detailed deployment instructions please refer to our administrators guide.

Deployment Procedure:

# Make a new directory to hold cdb and its support directories. (replace or set DESIRED_CDB_INSTALL_DIRECTORY var with a unix directory.)
mkdir $DESIRED_CDB_INSTALL_DIRECTORY
cd $DESIRED_CDB_INSTALL_DIRECTORY 
# get the distribution of Component DB (Alternativelly download a release zip and unzip it). 
git clone https://github.com/AdvancedPhotonSource/ComponentDB.git
# Navigate inside the distribution. 
cd ComponentDb
# Build support needed for the application
make support
# load enviornment variables with new support built. 
source setup.sh    
# Create deployment configuration
make configuration
# Create a clean db for the distribution 
make clean-db
# Prepare web portal configuraiton
make configure-web-portal
# Deploy web portal
make deploy-web-portal
# Deploy REST web service
make deploy-web-service

# All done... output of the command below should print url to the deployed portal. 
echo "https://`hostname`:8181/cdb"

Development

For detailed development instructions please refer to our developers guide.

Getting Started with development:

# first make a fork of this project. 
# create a desired development directory and cdb into it
mkdir $desired_dev_directory
cd $desired_dev_directory
git clone https://github.com/AdvancedPhotonSource/ComponentDB.git

# Getting support software
cd ComponentDb
make support 
# Get Netbeans
make support-netbeans

# Load up the environment 
source setup.sh

# Prepare Dev DB    
# mysql could be installed as part of ComponentDB support by running 'make support-mysql' 
# - Afterwards run `./etc/init.d/cdb-mysql start`
# if you have mysql installed and started run...
make clean-db   # sample-db will be coming later 

# Start development
make dev-config     

# Open Netbeans
netbeans & 

Preparing Netbeans

Once netbeans is open a few steps need to be taken to prepare netbeans for CDB development.

1. Click Tools > Plugins
2. Navigate to Available Plugins and install the following:
   • nbjavac Library
   • Oracle JS Parser Implementation
   • Payara EE Common
   • Payara Common
   • Payara Server
   • Payara Tooling
3. Add payara server reference.
4. Click Window > Services
5. Right click Server > Add Server
6. Select Payara
7. Use installation location: $desired_dev_directory/support-hostname/netbeans/payara
8. Ensure Local domain is selected and hit next.
9. Leaave defaults and hit finish.
10. Open CDB Project: File > Open Project
11. Navigate to $desired_dev_directory/ComponentDB/src/java
12. Select CdbWebPortal and hit Open Project
13. If prompted install: JavaFX Implementation for linux
14. Right click CdbWebPortal and hit Resolve Data Source Problem...
15. Add Connection > Add Driver File
16. Navigate to $desired_dev_directory/ComponentDB/src/java/CdbWebPortal/lib/mysql-connector-java-*-bin.jar
17. Finish Add Connection wizard.
18. Run the project

Python Web Service Development

# Code is located in $desired_dev_directory/ComponentDB/src/python
# For web service development (Use your favorite python editor) to test run web service using:
./sbin/cdbWebService.sh

License

Copyright (c) UChicago Argonne, LLC. All rights reserved.