AWS_build_script.txt

#ODK Tools - Installation script tested in Ubuntu server 22.04

sudo add-apt-repository universe
sudo add-apt-repository multiverse

wget https://dev.mysql.com/get/mysql-apt-config_0.8.32-1_all.deb
sudo dpkg -i ./mysql-apt-config_0.8.32-1_all.deb

sudo apt-get update

sudo apt-get install -y build-essential qtbase5-dev qtbase5-private-dev qtdeclarative5-dev libqt5sql5-mysql cmake jq libboost-all-dev unzip zlib1g-dev automake libmysqlclient-dev mysql-client sqlite3 libqt5sql5-sqlite golang-go mysql-shell openjdk-17-jre-headless

cd /opt

sudo wget https://github.com/BurntSushi/xsv/releases/download/0.13.0/xsv-0.13.0-x86_64-unknown-linux-musl.tar.gz
sudo tar xvfz xsv-0.13.0-x86_64-unknown-linux-musl.tar.gz
sudo cp xsv /bin

cd /opt

sudo git clone https://github.com/qlands/csv2xlsx.git
cd csv2xlsx
sudo go build
sudo cp csv2xlsx /bin

sudo git clone https://github.com/qlands/odktools.git
sudo mkdir odktools-deps
cd odktools-deps

sudo wget https://github.com/jmcnamara/libxlsxwriter/archive/refs/tags/v1.1.8.tar.gz
sudo wget https://github.com/stachenov/quazip/archive/refs/tags/v1.4.tar.gz

sudo git clone https://github.com/rgamble/libcsv.git


cd /opt/odktools-deps


sudo tar xvfz v1.4.tar.gz
cd /opt/odktools-deps/quazip-1.4
sudo mkdir build
cd /opt/odktools-deps/quazip-1.4/build
sudo cmake -DCMAKE_C_FLAGS:STRING="-fPIC" -DCMAKE_CXX_FLAGS:STRING="-fPIC" ..
sudo make
sudo make install
cd /opt/odktools-deps

sudo ln -s /usr/bin/aclocal-1.16 /usr/bin/aclocal-1.14
sudo ln -s /usr/bin/automake-1.16 /usr/bin/automake-1.14

sudo tar xvfz v1.1.8.tar.gz
cd libxlsxwriter-1.1.8
sudo mkdir build
cd build
sudo cmake ..
sudo make
sudo make install
cd ../..

cd libcsv
sudo ./configure
sudo make
sudo make install

cd /opt/odktools

sudo qmake
sudo make