[Superceded/OLD:2019-11-15] ERPNext manual install on Debian Buster 10.x

sed -i '/#Port 22/Port 22022/' /etc/ssh/sshd_config;
systemctl restart ssh

sudo useradd -m -d /home/frappe -s /bin/bash erpnext001;
passwd erpnext001;  #erpnextpassword

touch /etc/sudoers.d/erpnext; chmod 644 /etc/sudoers.d/erpnext;
cat <<EOF > /etc/sudoers.d/erpnext
erpnext001 ALL=(ALL:ALL) ALL
EOF
service sudo restart

#Set some variables to make life a bit easier - NB!!! these values are NOT safe for live systems, so please don't use them
RootPWD="rootpassword";
ERPNextPWD="erpnextpassword";
MySQLpwd="mysqlpwd";
#echo "root:$RootPWD;ssh:$sshPWD;erpnext:$ERPNextPWD;mysql:$MySQLpwd;"  #uncomment to show these for debug/info

#IF you didn't set up the ERPNext user, add them now, with sudo rights.
sudo useradd -m -d /home/frappe -s /bin/bash erpnext001;
passwd erpnext001;  #erpnextpassword
sudo usermod -aG sudo erpnext001; #NB!!

sudo apt install -y sshfs gcc wget binutils net-tools dnsutils lsof dirmngr \
  curl ca-certificates apt-transport-https software-properties-common \
  mc git-core build-essential network-manager;

#Add MySQL server: 1) Signing key for mariaDB, and then 2) Install
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xF1656F24C74CD1D8
sudo apt install -y mariadb-client mariadb-server
  #1) Test the install: 
  mysql -u root
  exit
  #2) Also good idea to secure things, and add some permissions - the last 2 of these lines [optional] allow LAN access to the DB server.
  #mysqladmin -uroot password "$MySQLpwd"   #IF you want to just change/set the password, use this line instead
  mysql_secure_installation
  #Set some GRANT permissions/access
  mysql -uroot -p$MySQLpwd -Bse "GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.%.%.%' IDENTIFIED BY '$MySQLpwd' WITH GRANT OPTION;"
  mysql -uroot -p$MySQLpwd -Bse "GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '$MySQLpwd' WITH GRANT OPTION;"
  mysql -uroot -p$MySQLpwd -Bse "GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.0.%.%' IDENTIFIED BY '$MySQLpwd' WITH GRANT OPTION;"
  mysql -uroot -p$MySQLpwd -Bse "GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.%.%' IDENTIFIED BY '$MySQLpwd' WITH GRANT OPTION;"

sudo systemctl stop apache2
#Shouldn't be installed, but if it is, disable it otherwise nginx install will FAIL
sudo apt install nginx -y       #install nginx
  #3)- Test the install by opening a browser to the IP address of the VM: http://192.168.1.249

#npm/node
curl -sL https://deb.nodesource.com/setup_10.x | sudo bash -   #####v10.x (you can use v8 by changing the relevant bit to "setup_8.x")
sudo apt update && sudo apt install -y nodejs

## To install the Yarn package manager, run:
curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | sudo apt-key add -
echo "deb https://dl.yarnpkg.com/debian/ stable main" | sudo tee /etc/apt/sources.list.d/yarn.list
sudo apt update && sudo apt install -y yarn
  #4)- Test the installs: 
  node -v && npm -v && yarn -v
    #v10.16.3 && 6.9.0 && 1.17.3 (in our case)

sudo apt install redis-server -y
  #5) Test the install: 
    redis-server -v

#6) wkhtmltopdf - the default apt-get version is outdated. Install pre-reqs, and then a manual/latest version
sudo apt install -y xfonts-75dpi fontconfig libxrender1 xfonts-base
wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.5/wkhtmltox_0.12.5-1.stretch_amd64.deb
sudo dpkg --install wkhtmltox_0.12.5-1.stretch_amd64.deb

sudo apt install python-pip -y
sudo apt install libmariadbclient-dev -y
sudo apt install python-mysqldb -y
sudo apt install python-pdfkit -y
sudo apt install libssl-dev -y
pip install --upgrade setuptools
sudo apt install -y python-virtualenv
sudo apt install -y python-pip-whl python-distribute python3-cxx-dev python3-dev

#Added this [2019-11-15] to address the botocore problem 
#ERROR: botocore 1.13.18 has requirement python-dateutil<2.8.1,>=2.1; python_version >= “2.7”, but you’ll have python-dateutil 2.8.1 which is incompatible.
sudo apt install -y python-dateutil -y
#

pip install --upgrade mysqlclient   #this replaces MySQL-python[pip] because that one gives me nightmares
  ##IF this doesn' work, I found this on stackoverflow:
  #pip install --upgrade --only-binary :all: mysqlclient
#IF you'd like to test this before proceeding... normally, one would go into python, import MySQLdb, and try to connect - eg.
python
import MySQLdb
def main():
  db = MySQLdb.connect(host = "localhost", user = "root", passwd = "mysqlpwd", db = "mysql")
  if (db):
    print "Connection successful"
  else:
    print "Connection unsuccessful"
#Need a blank line here, so press [ENTER] before you run main()
main()
  #Should show "Connection successful", and then you can exit python
quit()



#Check which pip/mysql modules are available...
pip list | grep -i mysql
    #mysqlclient                   1.4.4  

#Needed for production mode
sudo apt install supervisor -y

#Tune the DB (should be done before the frappe installs, otherwise it will warn you to make these changes before it proceeds)
#nano /etc/mysql/my.cnf - OR - create a conf.d version in one of /etc/mysql/conf.d/ or /etc/mysql/mariadb.conf.d/
#I have chosen what seems like a sensible name to me (mariadb4ERPNext.conf), but it can be anything you prefer.

#The values in the .conf file are based on 2GB RAM - you can adjust them up/down if your PC has different specs.
#cat <<EOF > /etc/mysql/mariadb.conf.d/mariadb4ERPNext.conf
#NB        ^ (overwrites)
cat <<EOF >> /etc/mysql/my.cnf
#NB       ^^ (appends)

[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
# Set buffer pool size to 50-80% of your computer's memory
innodb_buffer_pool_size=1024M
# Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=256M
innodb_log_buffer_size=128M
# the default here is 4MB, or maybe 16MB?? in more recent versions, which sometimes allows for disconnects in the middle of transactions
max_allowed_packet=64M

[mysql]
default-character-set = utf8mb4
EOF

cat /etc/mysql/my.cnf    #If you'd like to confirmm that things went through OK
#cat /etc/mysql/mariadb.conf.d/mariadb4ERPNext.conf  #IF you went the conf.d route

#Restart the mysql/mariadb and then check that the values are accepted
sudo systemctl restart mysql
    mysql -uroot -p$MySQLpwd -Bse "SELECT * FROM information_schema.GLOBAL_VARIABLES  WHERE variable_name LIKE '%INNODB_BUFFER_POOL_SIZE%';"
    #INNODB_BUFFER_POOL_SIZE 1073741824 (which is 1GB, as we set it above)
reboot

#Login as ##########YourFRAPPE########## user
cd ~
git clone https://github.com/frappe/bench bench-repo            #~30MB of download
sudo pip install -e bench-repo
sudo npm install -g yarn  #we seem to need this for most recent changes

#python -m pip install --user pip shows that v18.1 is already there, so either...
pip install --user --upgrade pip            #To get latest version
#OR
#python -m pip install --user pip==19.2.3
    #Previously, if there were pip errors, I downgraded to pip to 9.0.3 \
        # and things worked for me. To downgrade (shouldn't be needed) ...
    #python -m pip install --user pip==9.0.3

bench init frappe-bench --frappe-branch master && cd frappe-bench
#This will do a download of ~220MB of download

bench new-site site1.local      #which will request the mysql password you set/created above
#create Administrator password & confirm it ######[adminpassword]######
      #IF... this happens....
      #ERROR 1045 (28000): Access denied for user '8de49ae55a02e7ac'@'localhost' (using password: YES)
      DBname=$(cat ~/frappe-bench/sites/site1.local/site_config.json | awk '/db_name/ {print $2}' | sed "s/\"//g" | sed "s/,//g")
      DBpass=$(cat ~/frappe-bench/sites/site1.local/site_config.json | awk '/db_password/ {print $2}' | sed "s/\"//g")
      #
      mysql -uroot -p$MySQLpwd -Bse "GRANT ALL PRIVILEGES ON *.* TO '$DBname'@'localhost' IDENTIFIED BY '$DBpass' WITH GRANT OPTION;"
      mysql -uroot -p$MySQLpwd -Bse "GRANT ALL PRIVILEGES ON *.* TO '$DBname'@'127.0.0.1' IDENTIFIED BY '$DBpass' WITH GRANT OPTION;"
      #
      mysql -uroot -p$MySQLpwd -Bse "set password for '$DBname'@'localhost' = password('$DBpass');"
      mysql -uroot -p$MySQLpwd -Bse "set password for '$DBname'@'127.0.0.1' = password('$DBpass');"
      #delete the DB and re-run
      bench new-site site1.local
bench start
   #7) To Test Installation: IF there are issues in accessing the site @ http://192.168.1.249:8000 do a bench reinstall
reboot


#Login as FRAPPE User
cd frappe-bench
bench get-app erpnext https://github.com/frappe/erpnext --branch master
bench --site site1.local install-app erpnext
sudo bench setup production erpnext001
   #8) to switch to production as this is develop
   bench set-nginx-port site1.local 8249
      #nginx.conf already exists and this will overwrite it. Do you want to continue? [y/N]: y
   bench setup nginx
   sudo systemctl reload nginx

#At the time of writing this (2019-08-25), the result is...
#erpnext001@debERP:~/frappe-bench$ bench version
#    erpnext 11.1.49
#    frappe 11.1.44

#To upgrade to the latest v11.x.x's...
#Since the v11/v12 changes, ERPNext upgrades quite weirdly - gives a bunch of messages which loop on themselves
   #To fix... (thanks to @lasalesi who posted about this on the ERPNext forum)
      #The default .git "config" file has a section...
      [remote "upstream"]
              fetch = +refs/heads/master:refs/remotes/upstream/master
      #"master" needs to become "*" #all occurrences, NB!: without the quotes
      [remote "upstream"]
              fetch = +refs/heads/*:refs/remotes/upstream/*
#Edit the file: apps > erpnext> .git > config :
   #nano ~/frappe-bench/apps/erpnext/.git/config
      #[remote "upstream"]
      #    url = https://github.com/frappe/erpnext
      #    fetch = +refs/heads/*:refs/remotes/upstream/*
#   OR   #
sed -i.bak 's/\/master/\/*/g' ~/frappe-bench/apps/erpnext/.git/config   #replace /master with /* (copy the original file to *.bak)
#Then:
bench switch-to-branch version-11 frappe erpnext   #make sure you switch BOTH! (frappe erpnext)
#This download is ~750MB, so it takes a while
bench update --patch
#IF you want v12, then run....
bench switch-to-branch version-12 frappe erpnext --upgrade
bench update --patch #not generally a requirement, but I prefer to run it anyway

#erpnext001@debERP:~/frappe-bench$ bench version
#    erpnext 12.0.8
#    frappe 12.0.8

#adjust git config and edit from "+refs/heads/*:refs/remotes/upstream/*" to +refs/heads/*:refs/remotes/upstream/* (without quotes)
git config remote.upstream.fetch +refs/heads/*:refs/remotes/upstream/*
#check git config
git config --get remote.upstream.fetch
#There should be NO quotations...
bench switch-to-branch version-12 frappe erpnext --upgrade
bench update --patch