Shyam Sundar C S shyam
shyam
/ ffencode.txt
Created
January 16, 2021 17:07
— forked from jemekite/ffencode.txt
ffmpeg preserve metadata
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ffmpeg -i input.mp4 -vcodec h264 -acodec aac -map_metadata 0 output.mp4 |
shyam
/ aws-cf-logs
Last active
October 9, 2020 15:15
— forked from shapeshed/aws-cf-logs
Fetch AWS Cloudfront Logs, decompress, combine into a single file and remove comments
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env bash | |
| BUCKET=$1 | |
| CWD=$(pwd) | |
| if [[ -n $1 ]]; then | |
| aws s3 sync s3://$BUCKET/cf-logs . | |
| cat *.gz > combined.log.gz | |
| find $CWD ! -name 'combined.log.gz' -name '*.gz' -type f -exec rm -f {} + | |
| gzip -d combined.log.gz |
shyam
/ postgres_queries_and_commands.sql
Created
July 21, 2016 05:44
— forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(query_start, clock_timestamp()), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(query_start, clock_timestamp()), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
shyam
/ Disable strict mode in homebrew mysql
Last active
August 29, 2015 14:06
— forked from flori/Disable strict mode in homebrew mysql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (ffr@ffr:mysql [master] ❷ ->0)$ cat /usr/local/opt/mysql/my.cnf | |
| [mysqld] | |
| sql_mode=NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES |
shyam
/ gist:1940844
Created
February 29, 2012 13:30
— forked from lelayf/gist:1929949
Procedure for installing and setting Sun JDK Java 6 on Amazon Linux AMI 64bit
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Get latest Sun Java SDK in v6 from Oracle | |
| wget http://download.oracle.com/otn-pub/java/jdk/6u31-b04/jdk-6u31-linux-x64-rpm.bin | |
| # make it exec | |
| chmod +x jdk-6u31-linux-x64-rpm.bin | |
| # Install Java | |
| sudo ./jdk-6u31-linux-x64-rpm.bin | |
| # Check if the default java version is set to sun jdk |