You are here

TicketsCAD install on a RPI3

5 posts / 0 new
Last post
VK1MIC
TicketsCAD install on a RPI3

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

 
VK1MIC
To be honest, I thought this

To be honest, I thought this post would have got more comments.

W

AB7PA
Your contribution is important

Wade, I understand your concern, but one thing to keep in mind is that your forum post has become part of the AREDN "permanent record" so people for years to come can refer to the important work you've documented.  A lower than expected number of immediate comments doesn't mean your post isn't important.  For years to come people can refer to your how-to and receive benefit.  Everyone thanks you guys for the work you put into this effort for the benefit of the entire community.  Much appreciated!

K5DLQ
K5DLQ's picture
Nice work Wade!  

Nice work Wade!
 

KM6SLF
KM6SLF's picture
Those are great instructions.

Those are great instructions. I may set one up. Thanks!

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer