In this page, you will learn how to perform the basic IT maintenance & troubleshooting for Health Facilities.

All of the following procedures must be applied by a local IT coordinator or if the IT coordinator allows it, a technician on the Health Facility.

- If any equipment has any issue that stops it from working, you may try turning it off and on and see if that helps - If the equipment is stolen / lost / definitely broken, you shall order the same equipment and reapply the settings written in the installation SOP

- If for any reasons the tablets do not work anymore, you may restart the Raspberry to see if this solves the issue. To do so, simply unplug the USB-C cable wait a few seconds and plug it back in. Wait 3 mins and see if your issue is solved. - If the issue persists, you need to perform the localData install SOP on the Raspberry PI once again.

- To execute security updates, you will need a USB keyboard and a screen with an HDMI/micro-HDMI cable - Plug the screen and keyboard in the Raspberry PI, and login with the normal User / Password - Execute the command: git pull - Then: shutdown -r 0

- Check if the tablet is connected to the correct Wi-Fi (Dynamic) - Reboot the router by unplugging it / plugging in back OR by long pressing the power button until no more lights can be seen from it, then press shortly on it to turn it back on - Check with a phone User that has the same operator as the 4G router if there is a general internet issue

• WinSCP
  • WinSCP is a free SFTP, SCP, Amazon S3, WebDAV, and FTP client for Windows.
  • This tool will help you to access all files on your server and for example to retrieve a json in the failures folder or a log file.
• Putty
  • PuTTY is a free and open-source terminal emulator, serial console and network file transfer application. It supports several network protocols, including SCP, SSH, Telnet, rlogin, and raw socket connection. It can also connect to a serial port.
  • This will help you connect directly to your server.
• pgAdmin
  • pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
  • This tool will help you to retrieve information from the medAL-data database for example

• All available artisan commands Details on every artisan available commands
• dokku More information on Dokku commands
• dokku-postgres More information on Postgres Dokku container
• dokku-logs Know more about Dokku logs management
• psql Every available psql commands
• pg_dump Backup the database
• pg_dumpall Backup all the database
• pg_restore Restore a backup

Useful Linux basics commands If you want to know more about the commands you'll have to use

Exemple to retrieve a zip file

scp zip1.zip username@<server_ip>:/var/lib/dokku/data/storage/<app_name>/app/cases_zip/2XlcgspHJlCuqDPQFJhzLZaR5s0SGPDAOdwxlMWw.zip

Exemple to count the number of medical cases which are not yet syncronize with REDCap inside the PostgreSQL database

dokku postgres:enter <postgres_container_name> psql -U postgres <postgres_database_name> -c "SELECT count(*) FROM public.medical_cases where redcap=false"

Exemple to retrieve every environnement variables

    sudo dokku <app_name> config:show
    # Exemple to retrieve CREATOR_ALGORITHM_URL environnement variables
    sudo dokku <app_name> config:get CREATOR_ALGORITHM_URL

Exemple to set a environnement variable

    sudo dokku <app_name> config:set MAIL_USERNAME="exemple@mail.com"
    # You can also add the --no-restart flag to set STUDY_ID environnement variable without restarting the app
    sudo dokku <app_name> config:set STUDY_ID="Dynamic Tanzania" --no-restart

* medAL-//creator// troubleshooting guide * medAL-//reader// troubleshooting guide * medAL-//hub// troubleshooting guide * medAL-//data// troubleshooting guide