Tonight Robin was able to help me through the whole process of an install on an RPI3 - this the first how to I have seen.
 

Installing OpenCAD / Open ICSE on a Raspberry PI3. 

Download location: https://sourceforge.net/projects/openises/files/latest/download

https://sourceforge.net/projects/openises/files/MDB/Using%20Tickets%20MDB.pdf/download 

Preparing the pi:

sudo apt-get update

sudo apt-get upgrade

sudo apt-get install mariadb-server mariadb-client -y

sudo apt-get install phpmyadmin -y

If you don’t have apache or php installed yet, follow these instructions https://www.raspberrypi.org/documentation/remote-access/web-server/apache.md

sudo mkdir /var/www/html/ticketscad

cd Downloads

sudo mv tickets_331A_052819.zip /var/www/html/ticketscad

cd /var/www/html/ticketscad

sudo unzip tickets_331A_052819.zip

sudo mysql -u root -p

create database ticketscad;

GRANT ALL PRIVILEGES ON ticketscad.* TO 'ticketscad'@'%' IDENTIFIED BY 'replace with prefered password' WITH GRANT OPTION; *single line

In the browser open http://localhost/ticketscad and click on the install.php link. Follow the instructions, and hopefully you will get to a page where you need to enter the database info.

Host would be localhost, and username ticketscad, and password the one you set up above in the GRANT ALL statement.

For later reference if needed:

phpMyAdmin

User: phpmyadmin

Pass: raspberry

Tickets users created 

admin / admin

guest / guest 

## Collaboration between Robin Pringle ZL2RCL & Wade Smith VK1MIC