# SPOD-MANAGER

## Requirements
* Linux (tested on Kernel  3.19.0-25-generic)
* Apache Web Server (local installation)
* MySql Server (local and remote installation)
* Git shell client
* ROUTE-TO_PA source code account
* Root access on local machine

## Download 

    wget http://service.routetopa.eu:7480/carspa/spod-manager/raw/master/spod-manager.sh
    chmod +x spod-manager.sh

## Actions help

    sudo ./spod-manager.sh --help
    spod-manager.sh is manager tool for SPOD application of ROUTE-TO-PA European project all rights are reserved. 2015
    list of arguments:
    -h, --help                          show commands help.
    -a, --action=ACTION                 specify an action install, uninstall, update, backup and restore.
    -m, --mysql-username=username       specify the username of mysql (*).
    -n, --mysql-password=password       specify the password of mysql server (*).
    -o, --mysql-address=address         specify the address of mysql server (deafult is localhost).
    -p, --spod-git-username=user        specify the user name of SPOD git server (*).
    -q, --spod-git-email=email          specify the email of SPOD git server (*).
    -r, --spod-git-password=password    specify the passoword of SPOD git server (*).
    -s, --spod-git-address=address:port specify the SPOD git server (deafult is service.routetopa.eu:7480).
    -w, --spod-hostname=hostname        specify the SPOD host name (example http://spod.routetopa.eu/).
    -d, --spod-database-version=db      specify the SPOD db git path located in db_dump of SPOD git core (example in backup action: oxwall_v.0.1_antares.sql, deafults is really simple SPOD and Oxwall installationi; in restore action use a local db dump).
    -b, --backup-dir=DIR                specify the directory where store the spod backup (default is current directory).
    * the arguments is required.

## Actions examples

### INSTALLATION SPOD
    
    sudo ./spod-manager.sh -a install -m root -n mysqlpass -p usergit -q emailusergit -r passgit -w http://spod.routetopa.eu/ -d oxwall_v.0.1_antares.sql

### UNINSTALLATION SPOD
    
    sudo ./spod-manager.sh -a uninstall -m root -n mysqlpass

### BACKUP SPOD

    sudo ./spod-manager.sh -a backup -m root -n mysqlpass -b ./test

### UPDATE SPOD

    sudo ./spod-manager.sh -a update -p usergit -q emailuserigit -r passgit
    
### RESTORE SPOD
    
    sudo ./spod-manager.sh -a restore -m root -n mysqlpass -d /home/user/spod-manager/oxwall_version_dump.sql