RT Upgrade

# Install dependencies #
apt install perl gzip zip libcpanel-json-xs-perl dbconfig-common debconf fonts-droid-fallback exim4 fonts-noto-hinted libapache-session-perl libbusiness-hours-perl libcgi-emulate-psgi-perl libcgi-pm-perl libcgi-psgi-perl libclass-accessor-perl libconvert-color-perl libcrypt-eksblowfish-perl libcrypt-ssleay-perl libcrypt-x509-perl libcss-minifier-xs-perl libcss-squish-perl libdata-guid-perl libdata-ical-perl libdata-page-pageset-perl libdate-extract-perl libdate-manip-perl libdatetime-format-natural-perl libdatetime-locale-perl libdatetime-perl libdbi-perl libdbix-searchbuilder-perl libdevel-globaldestruction-perl libemail-address-list-perl libemail-address-perl libfile-sharedir-perl libfile-which-perl libgd-graph-perl libgd-text-perl libgnupg-interface-perl libgraphviz-perl libhtml-formattext-withlinks-andtables-perl libhtml-formattext-withlinks-perl libhtml-mason-perl libhtml-mason-psgihandler-perl libhtml-quoted-perl libhtml-rewriteattributes-perl libhtml-scrubber-perl libhttp-message-perl libipc-run-perl libipc-run3-perl libjavascript-minifier-xs-perl liblist-moreutils-perl liblocale-maketext-fuzzy-perl liblocale-maketext-lexicon-perl liblog-dispatch-perl libmailtools-perl libmime-tools-perl libmime-types-perl libmodule-refresh-perl libmodule-versions-report-perl libnet-cidr-perl libnet-ip-perl libnet-ldap-perl libnet-ssleay-perl libperlio-eol-perl libplack-perl libregexp-common-net-cidr-perl libregexp-common-perl libregexp-ipv6-perl librole-basic-perl libscope-upper-perl libstring-shellquote-perl libsymbol-global-name-perl libtext-autoformat-perl libtext-password-pronounceable-perl libtext-quoted-perl libtext-template-perl libtext-wikiformat-perl libtext-wrapper-perl libtime-parsedate-perl libtimedate-perl libtree-simple-perl libuniversal-require-perl liburi-perl libwww-perl libxml-rss-perl libxml-simple-perl libdbd-mysql-perl lsb-base rsyslog ucf libhtml-formatexternal-perl w3m build-essential gcc time tree -y

#sudo apt-get remove libjson-xs-perl
#sudo apt-get install libcpanel-json-xs-perl

# Configure system #
/usr/sbin/adduser --system --group rt

# Configure CPAN #
cpan
> o conf prerequisites_policy follow
> o conf build_requires_install_policy yes
> o conf commit
> q

# Download RT #
rt_version="4.0.7"
wget https://download.bestpractical.com/pub/rt/release/rt-${rt_version}.tar.gz
tar xzpvf rt-${rt_version}.tar.gz -C /tmp/ && rm rt-${rt_version}.tar.gz && cd /tmp/rt-${rt_version}

# Configure setup #
./configure --with-web-user=www-data --with-web-group=www-data --enable-graphviz --enable-gd
make testdeps
make fixdeps
make install

chmod -R  u+rwX,go-w,go+rX /opt/rt4/share/html /opt/rt4/local/html /opt/rt4/share/po /opt/rt4/local/po
chown -R root /opt/rt4/share/html /opt/rt4/local/html /opt/rt4/share/po /opt/rt4/local/po
chgrp -R bin /opt/rt4/share/html /opt/rt4/local/html /opt/rt4/share/po /opt/rt4/local/po
chmod 0770 /opt/rt4/var/mason_data /opt/rt4/var/session_data
chown -R www-data /opt/rt4/var/mason_data /opt/rt4/var/session_data
chgrp -R www-data /opt/rt4/var/mason_data /opt/rt4/var/session_data

# Install SQL server #
apt install mariadb-server -y
service mysql restart

make initialize-database

# Download update version #
rt_version="4.4.3"
wget https://download.bestpractical.com/pub/rt/release/rt-${rt_version}.tar.gz
tar xzpvf rt-${rt_version}.tar.gz -C /tmp/ && rm rt-${rt_version}.tar.gz && cd /tmp/rt-${rt_version}
make testdeps
make fixdeps

# Setup upgrade #
export PERL_USE_UNSAFE_INC=1
./configure --with-web-user=www-data --with-web-group=www-data --enable-graphviz --enable-gd
make upgrade

chmod -R u+rwX,go-w,go+rX /opt/rt4/share/html /opt/rt4/local/html /opt/rt4/share/po /opt/rt4/local/po /opt/rt4/share/static /opt/rt4/local/static
chown -R root /opt/rt4/share/html /opt/rt4/local/html /opt/rt4/share/po /opt/rt4/local/po /opt/rt4/share/static/opt/rt4/local/static
chgrp -R bin /opt/rt4/share/html /opt/rt4/local/html /opt/rt4/share/po /opt/rt4/local/po /opt/rt4/share/static /opt/rt4/local/static
chmod 0770 /opt/rt4/var/mason_data /opt/rt4/var/session_data
chown -R www-data /opt/rt4/var/mason_data /opt/rt4/var/session_data
chgrp -R www-data /opt/rt4/var/mason_data /opt/rt4/var/session_data

make upgrade-database