Difference: LbSoftConfDb2 (3 vs. 4)

Revision 42019-03-19 - StefanGabrielChitic

Line: 1 to 1
 
META TOPICPARENT name="LHCbDevOps"

LbSoftConfDb2

Added:
>
>

Architecture

LbSoftConfDb2 is web service that provides a Neo4j database used to store the dependencies of the LHCb software projects.

The project is composed of 2 packages:

  • a client side package that contains all the clients. The clients connect to the server side application using XML RPC via HTTP requests. The communication is done for clients that only query the databse using non-authe requests, while the database modifications are done using SSO auth requests.
  • a server side package. It provides 2 XML RPC servers: one for non-auth requests and the other one for auth-requests. The SSO auth is managed by a revers Apache proxy. The data exchange with the Neo4j server is executed only the main component of the application.
 

Service Maintenance and DevOps:

Code location for libraries involved in the project:

Line: 44 to 53
  This section will be updated over time with procedures in order to facilitate the DevOps.
Added:
>
>

LbSoftDb2 server code update procedure:

  1. Activate the newly created virtualenv: source ./migrationEnv/bin/activate
  2. Install the migration library: pip install --extra-index-url https://cern.ch/lhcb-pypi/simple/ --trusted-host cern.ch lbsoftconfdb2server --upgrade
  3. Restart the lbSdbServerReadOnly demon: systemctl restart lbSdbServerReadOnly
  4. Verify the restart was ok: systemctl status lbSdbServerReadOnly
    ...
    Listening for '127.0.0.1' on port '8080'...
  5. Restart the lbSdbServerWrite demon: systemctl restart lbSdbServerWrite
  6. Verify the restart was ok: systemctl status lbSdbServerWrite
    ...
    Listening for '127.0.0.1' on port '8090'...
  7. Restart Apache demon: systemctl restart httpd
 

LbSoftDb to LbSoftDb2 database migration procedure:

In order to migrate the LbSoftDb 1 database to the LbSoftDb2, you need to connect to any lxplus nodes and:

Line: 117 to 140
 
  1. Assign execution permissions to the cgi-bin: chmod a+x /var/www/cgi-bin/*
  2. Verify that the apache proxy is working. Go in your browser to https://lbsoftdb.cern.ch/read/. If you get Service Unavailable means that the proxy is not working. The solution is to disable the SEL Linux: /usr/sbin/setsebool -P httpd_can_network_connect 1. If you get a Error response. Error code 501. means that the service is working.
  3. Congrats! You've made it wink
Deleted:
<
<

Architecture

LbSoftConfDb2 is web service that provides a Neo4j database used to store the dependencies of the LHCb software projects.

The project is composed of 2 packages:

  • a client side package that contains all the clients. The clients connect to the server side application using XML RPC via HTTP requests. The communication is done for clients that only query the databse using non-authe requests, while the database modifications are done using SSO auth requests.
  • a server side package. It provides 2 XML RPC servers: one for non-auth requests and the other one for auth-requests. The SSO auth is managed by a revers Apache proxy. The data exchange with the Neo4j server is executed only the main component of the application.
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback