AWSUbuntu

Data

• public DNS: ec2-34-217-148-49.us-west-2.compute.amazonaws.com
• IP: 34.217.148.49
• Key Pair is the public and the private key. Key Pair Name: aws-ubuntu-magento2-test1
  • public key on server is in ~/.ssh/authorized_keys
  • PEM file is located at C:\Uwes\owncloud\documents\WendWeb\

obsolete

• public DNS: ec2-34-220-188-76.us-west-2.compute.amazonaws.com
• IP: 34.220.188.76

Magento

• new installation according to here (upgrade PHP to 7.2 before, old installation went to /var/www/html/magento2)
• create directory /var/www/html/m_<VERSION_WO_DOTS>_<INSTATLLATION_NUMBER>/
• copy Magente-CE-N.N.N_sample_data-<DATE>.tar.gz to new directory
• sudo chown -R www-data:www-data /var/www/html/<DIRECTORY>/
• sudo -u www-data tar zxf <FILENAME>
• create DB m2_2 manually by phpmyadmin
• DB-User root Password: ******
• recursively set 777 to <MAGENTO_DIR>/
• give full access e.g to SAMBA users

sudo chmod -R 777 /var/www/html/  // still write errors while executing Magento
sudo chown -R www-data:www-data /var/www/html/m2_2/
sudo -u www-data php magento <MAGENTO_CMD>

MySQL

• version

mysql -V // -> 5.7.25

• change mysql root passwort according to https://websiteforstudents.com/resetting-mysql-root-password-on-ubuntu-16-04-17-10-and-18-04-lts/

sudo /etc/init.d/mysql stop
sudo mkdir /var/run/mysqld/
sudo chown mysql /var/run/mysqld/
sudo mysqld_safe --skip-grant-tables &
ENTER
sudo mysql -u root
use mysql;
update user set authentication_string=PASSWORD("pHalloo0@1p") where User='root';
flush privileges;
exit;
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
// test
sudo mysql -u root -p

PHP

• update from 7.0 to 7.2 according to here and here (list of old libs in myphppackages.txt)
• remove 7.0 by

 sudo apt-get purge --auto-remove php7.0

PHPMyAdmin

• sudo apt-get install -y phpmyadmin
• use MySQL root password
• change PHPMyAdmin URL

cd /etc/apache2/conf-available/
alias phpmyadmin -> phpxmyadmin

• ren /var/www/html/phpmyadmin

cd /var/www/html/
mv phpmyadmin phpxmyadmin

• restart apache

sudo service apache2 restart

• correction of error in /usr/share/phpmyadmin/libraries/sql.lib.php

Samba

• installation according to here
  • user: ubuntu
  • password: Halloo0@1
  • share: HTML_SHARE
  • backup of configuration

\etc\samba\smb.conf.sik

• edit security group according to here