Information Systems:UWDOSS - Open Source Development Server

From uniWIKI
Revision as of 13:03, 15 March 2021 by Norwinu (talk | contribs)
Jump to navigation Jump to search

Overview

uwdoss.unipharm.local is a production server VM that hosts InfoNext as well as the integrations database. The software components installed on this machine constitute the majority of the modernization stack uniPHARM is using for new development, with the other component being Iptor Integrator, integration middleware that exists on xtgui.unipharm.local

The server runs Debian Linux.

History

Prior to this server, uniPHARM ran strictly Windows Server for all server applications and workloads. However, there began to be a need for open-source software. For example, Moodle and Mediawiki have been in production since 2015. These are currently being hosted on Windows, using a pre-packaged WAMP stack that arguably is better-suited for development environments. It was decided a Linux server would be useful to uniPHARM's growing need and usage of open-source software.

Installed Software

The major software components running on this server are:

  • PostgreSQL relational database (no longer used)
  • MariaDB (MySQL) relational database
  • Apache web server - Hosts the Django application through mod_wsgi, as well as the static files (HTML/CSS/Javascript)
  • Redis DB - In-memory cache for loading frequently used datasets (e.g. customer name and number)
  • Python - To run Django, and other supporting scripts.
  • Django, Django REST Framework, which are Python packages
  • Other Python packages, such as venv and mysqlclient to help support the solution

Administration

This server does not have a GUI. Instead, command-line prompt through vSphere remote console or SSH can be used. Credentials for the user and admin user are as follows: 

Generic user
Username: unipharm
Password: visionit

Dev/admin user
Username: uwddev
Password: CH3CH3O

Superuser (root)
Root user: root
Password: visionit

Python Virtual Environment (venv)

InfoNext uses a virtual environment (through the venv Python module), which is located in /uwdapps/lib/.venv/inx. To activate in a console/SSH session: source /root_path_of_venv/bin/activate

ODBC

pyodbc is installed in the inx Python virtual environment. This is for facilitating direct connections to IBM Db2. A DSN for the connection to bart is configured in /etc/odbc.ini. However, this connection is not registered in Django.

SSL certificate

Troubleshooting and administration tasks

Restart web server

  • To restart Apache: sudo systemctl restart apache2

Renew SSL certificate

  • Open
  • Run certbot renew

Other Notes

  • This server is backed up using Veeam.
Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:UWDOSS_-_Open_Source_Development_Server&oldid=13507"