Page History

1. Install Apache httpdTest the data warehouse (DWH) database connectivity and responsiveness. This will make setup and troubleshooting much easier. Depending on your base OS configuration, you may or may not have psql installed. For this test, we will assume psql is NOT installed. From the pre-install worksheet, obtain the username, host, and dbname from row 1.

yum -y install httpd

...

 postgresql
echo 'select ucid from xml.t_patent_document_values limit 5;' | psql -U<user> -h<host> <dbname>

Results should be similar to what is shown below:

   ucid
-------------
US-952687-A
US-954232-A
US-950468-A
US-946897-A
US-950860-A

(5 rows)

2. Test Solr for connectivity and responsiveness. This will also make things easier during the installation process. From the pre-install worksheet, obtain the host and port information from row 3.

yumwget -O-y install epel-release

...

-q 'http://<host>:<port>/alexandria-v2.1/alexandria/select?q=*:*&rows=0'

Results should be similar to what is shown below:

{ 
  "responseHeader":{   
    "zkConnected":true,   
    "status":0,   
    "QTime":4,   
    "params":{     
      "q":"*:*",     
      "rows":"0"}}, 
  "response":{"numFound":114455167,"start":0,"maxScore":1.0,"docs":[]
  }}

3. Install the appropriate repository for your operating system using the command listed in the Repository column below. If necessary, adjust the code to reflect the version you are using.

sudo dnf -y install \
 https://repo.ificlaims.com/ifi-claims-direct/

rocky/

8/x86_64/ifi-claims-direct-

1.0

-1.

el8.x86_64.rpm

sudo yum -y install \

 https://repo.ificlaims.com/ifi-claims-direct/

amzn2/x86_64/ifi-claims-direct-

1.0

-1.

amzn2.x86_64.rpm

yum -y install \
 https://repo.ificlaims.com/ifi-claims-direct/fedora/27/x86_64/ifi-claims-direct-beta-0.0.2-1.fc27.x86_64.rpm

4. Install the Alexandria library4. Install CDWS and CDWI. Both packages will be installed in /usr/share/perl5/vendor_perl. The Alexandria library will also be installed as part of these packages.

yum -y install perl-Alexandria-Library

...

CDWS

...

yum -y install perl-Alexandria-CDWSCDWI

6. Install the Perl modules.

5. In order to run CDWS/CDWI as an Apache VHOST, copy the following template configuration files.

CDWS:

yum -y install \
  perl-opencp /usr/share/perl5/vendor_perl/Alexandria/CDWS/etc/claims-direct/alexandria-cdws-apache.conf.template \
  perl-Catalyst* \
  perl-Module-Install \
  perl-DBD-Pg \
  perl-XML-LibXML /etc/httpd/conf.d/alexandria-cdws-apache.conf

CDWI:

cp /usr/share/perl5/vendor_perl/Alexandria/CDWI/etc/claims-direct/alexandria-cdwi-apache.conf.template \
  perl-XML-LibXSLT \
  perl-CPAN

...

 /etc/httpd/conf.d/alexandria-cdwi-apache.conf

6. Ensure that the application configuration files are globally accessible.

CDWS:

export PATH=/opt/fv/bin:$PATH
export PERL5LIB=/opt/fv/lib/perl5:$PERL5LIB

8. Reinstall CDWS. Edit the code in the following steps to reflect the latest version of CDWS.

cp /usr/share/perl5/vendor_perl/Alexandria/CDWS/etc/claims-direct/alexandria-cdws.conf.template \
    /etc/alexandria-cdws.conf

CDWI:

wgetcp http:/usr/share/alexandria.fairviewresearch.com/software/Alexandria-CDWS-x.x.tar.gz

9. Decompress and extract the CDWS tarball.

tar zxvf Alexandria-CDWS-x.x.tar.gz

10. Change to the Alexandria directory.

cd Alexandria-CDWS-x.x

11. It is recommended to install CLAIMS Direct software into /opt/fv using the INSTALL_BASE argument to Makefile.PL, e.g.:

perl Makefile.PL INSTALL_BASE=/opt/fv --alldeps

12. Build the Perl packages.

make

13. Install the Perl packages.

make install

...

perl5/vendor_perl/Alexandria/CDWI/etc/claims-direct/alexandria-cdwi.conf.template \
    /etc/alexandria-cdwi.conf

7. Change to the apache directory.

cd /etc/httpd/conf.d

8. Using a text editor, set the ServerName in the alexandria-cdw(s|i)-apache.conf files. This should be a fully qualified domain name, not an IP address. Make sure that the VirtualHost parameter is set to reflect port 80. See below: 

In alexandria-cdws-apache.conf: ServerName cdws.yourdomain.com
                                                    <VirtualHost *:80>

In alexandria-cdwi-apache.conf: ServerName cdwi.yourdomain.com
                                                    <VirtualHost *:80>

9. In the /etc directory, edit the alexandria-cdws.conf file. Using a text editor, find the parameter tags referenced in the pre-install worksheet. Make all necessary changes to the file using the information previously collected. For example:

<Model::Users>
  dsn dbi:Pg:dbname=users;host=xxx.xxx.xxx.xx;port=xxxx
  user USER
  username USERNAME
  password PASSWORD
</Model::Users>

10. In order for the applications to function properly, credentials need to be stored where the application can retrieve them. CLAIMS Direct uses a simple "users" database preconfigured with an admin user (user: admin, password: PASSWORD). This database needs to be created either in a separate PostgreSQL instance, or together with the alexandria database. The following will create the user database on a PostgreSQL server:

cd cat /usr/share/perl5/vendor_perl/Alexandria/CDWS/etc/httpdclaims-direct/conf.d && ln -s /opt/fv/lib/perl5/Alexandria/CDWS/alexandria-cdws-apache.conf z01.conf

...

users.sql \
    | psql -Ualexandria -h<IP-ADDRESS-OF-POSTGRESQL> postgres

11. Change the directory.

cd /etc/httpd/conf

1612. Depending on distribution, you may also need to adjust the permissions to the root root Directory in httpd.conf. Using a text editor, edit the main directory config as follows:

<Directory />
    AllowOverride none
    Require all granted
</Directory>

1713. Enable and restart httpd.

systemctl enable httpd.service

...

; systemctl restart httpd.

...

systemctl restart httpd.serviceservice