Common Linux commands you need to know to manage an Amazon EC2 Linux server

BASICS OF CONNECTING

STEP 1 - YOU NEED A PPK KEY FILE FOR SECURITY

Putty: www.putty.org

1a) Use puttygen to generate a .ppk file from the amazon .pem key file.

1b) Launch Putty.

Put in Hostname: ec2-user@youripaddress port 22

Connection type: ssh

Go to ssH, auth, . Point to your private key file (ppk file):

STEP 2 - USE WINSCP TO CONNECT AND EDIT FILES

A) Download WinSCP: www.winscp.net

B) Hostname: put in your IP address

C) Username: ec2-user

D) Use the PPK encryption file as your password.

STEP 3 - CONNECTING TO MY SQL

How to create a HEIDI connection to MYSQL database on Amazon ec2:

Heidi SQL: http://www.heidisql.com/

https://vtvlab.wordpress.com/2011/12/13/connect-to-mysql-server-from-heidisql-with-ssh/

Good comparison of SQL versions:

http://troels.arvin.dk/db/rdbms/#insert

MANAGING PHP

EDIT PHP.ini with PUTTY:

1) sudo nano /etc/php.ini

2) Make a change

3) To restart apache: sudo service httpd restart

Edit .htaccess (httpd.conf)

1) sudo nano /etc/httpd/conf/httpd.conf

2) Make and change and save

3) Restart service sudo service httpd restart

To view PHP log:

sudo nano /var/log/httpd/error_log

To view log view of default sendmail log function:

sudo nano /var/log/maillog

MANAGING HARD DRIVES

To check hard drive space from putty:

df -h

To see partition detail:

lsblk

Shows you partition size.

Modify the volume size from AWS management console.

Connect to your instance via SSH.

Expand the size on the volume partition eg.

Resize the volume partition

TO FIND LARGE FILES:

sudo find / -type f -size +10M -exec ls -lh {} \;

TO DELETE A FILE:

sudo rm /var/log/httpd/ssl_error_log-20200614

Managing large log files:

Some log files get so big that you can't even open them. But you can look at the first or last 100 entries:

sudo tail -n100 /var/log/httpd/ssl_error_log

sudo head -n100 /var/log/httpd/ssl_error_log

If using HTML glyphecons and fonts don't work and you get a CORS message, edit httpd file:

<FilesMatch ".(eot|ttf|otf|woff|woff2)">

Header set Access-Control-Allow-Origin "http://etfanalyst.com"

</FilesMatch>