Trying to install Gogs on Ubuntu 16.04 - A journey

2018-08-17T08:58:00.002-07:00

sudo mysql -u root -p

mysql> SET GLOBAL innodb_fast_shutdown = 0;

sudo systemctl stop mysql.service

sudo systemctl stop mariadb.service

sudo apt remove mariadb-server

sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8

sudo sh -c "echo 'deb [arch=amd64,i386] https://mirrors.evowise.com/mariadb/repo/10.1/ubuntu '$(lsb_release -cs)' main' > /etc/apt/sources.list.d/MariaDB-10.1.list"
sudo apt-get update
sudo apt-get install mariadb-server

sudo mysql_upgrade

ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded
FATAL ERROR: Upgrade failed

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

plugin-load-add = auth_socket.so

sudo systemctl restart mariadb.service

sudo mysql_upgrade

sudo systemctl stop mysql.service
sudo apt remove mariadb-server
sudo sh -c "echo 'deb [arch=amd64,i386] https://mirrors.evowise.com/mariadb/repo/10.2/ubuntu '$(lsb_release -cs)' main' > /etc/apt/sources.list.d/MariaDB-10.2.list"
sudo apt-get update
sudo apt-get install mariadb-server mariadb-client
sudo systemctl restart mariadb.service
sudo mysql_upgrade

Error 1071: Specified key was too long; max key length is 767 bytes

Error 1071: Specified key was too long; max key length is 1000 bytes

wget -qO- https://dl.packager.io/srv/pkgr/gogs/key | sudo apt-key add -
sudo wget -O /etc/apt/sources.list.d/gogs.list \
  https://dl.packager.io/srv/pkgr/gogs/pkgr/installer/ubuntu/16.04.repo
sudo apt-get update
sudo apt-get install gogs

apt-get install wget apt-transport-https

mysql -uroot -p
create database gogs;
create user gogs;
grant privileges on gogs.* to `gogs`@`localhost` identified by 'a_fancy_password_here';
exit

cd /etc/nginx/sites-available
sudo nano gogs

server {
   listen 8080;
   server_name your_server_name_here;
   location / {
      proxy_pass http://localhost:6000;
   }
}

sudo ln -s /etc/nginx/sites-available/gogs /etc/nginx/sites-enabled/gogs

sudo service nginx restart

ufw allow 8080/tcp