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 <FilesMatch ".(eot|ttf|otf|woff|woff2)"> Header set Access-Control-Allow-Origin "http://etfanalyst.com" </FilesMatch> |
Linux >