How to execute SQLs in the docker Postgres db
Task: Write script to execute SQL commands in the docker Prostgers DB Script: Import dump file: Done.
Tag: DevOps
How to Set all directories to 755 and all files to 644
Task: set different attributes for files and directories Solution: Done.
Install Java on Raspberry Pi
Task: Install Java on Raspberry Pi Implementation: Update system:sudo apt updatesudo apt upgrade Install java:sudo apt install default-jdk Check it…
Monitor periodically linux ordered processes
Task: Monitor processes on the linux instance order by CPU usage Solution Use next command (displays top 15 rows): ps…
AWS get list of ec2 ids by beanstalk environment name
Task: Get list of EC2 instances Id(s) by beanstalk environment name Solution: envname=”wp-env” for ec2Id in $(aws elasticbeanstalk describe-environment-resources –environment-name…
Linux: /dev/ttyUSB0: Permission denied
Problem: Can’t connect to the Arduino device. Solution: Run next command(s) under root user: usermod -a -G dialout scalan usermod…
Liquibase: Index.exists exception fix
Task: Fix index exists precondition exception Solution: Instead of using index exists liquibase tag use sql to check index exists.…
Docker: How to copy file from container to local computer
Task: Copy some file from container to local computer Solution: docker cp <container>:<path><filename.ext> <localpath> Example: docker cp nginx:/var/log/mylog.log . Done.
Git: How to compare two branches
Task: Compare two different git branches Solution: git diff branch1 branch2 Note: compare by specific file type git diff branch1…
Add php imap.so library on osX
Task: Add imap.so library on Mac osX Implementation (run commands in the console): Done.
Install MariaDB on Ubuntu
Task: Install mariaDB server on Ubuntu Implementation: Update packages:sudo apt updatesudo apt upgrade Install MariaDB server package:sudo apt install mariadb-server…
Add WAF to WP site
Task: add WAF service to WP site Implementation steps: Create WebACL Add rulesets:AWS-AWSManagedRulesCommonRuleSetAWS-AWSManagedRulesWordPressRuleSetAWS-AWSManagedRulesSQLiRuleSetAWS-AWSManagedRulesPHPRuleSetAWS-AWSManagedRulesKnownBadInputsRuleSet Disable next rules in the AWS-AWSManagedRulesCommonRuleSet:SizeRestrictions_BODYGenericRFI_BODYCrossSiteScripting_BODYGenericRFI_QUERYARGUMENTS Done.