Check These Out
inputfile.txt is a space-separated textfile, 1st column contains the items (id) I want to put into my SQL statement.
39 = charactercode for single tick '
$1 = first column
If inputfile.txt is a CSV-file separated by "," use FS= to define your own field-separator:
$ awk 'BEGIN {FS=","; }{printf "select * from table where id = %c%s%c;\n",39,$1,39; }' inputfile.txt
It's somewhat common ISPs to intercept DNS queries at port 53 and resolve them at their own.
To check if your ISP is intercepting your DNS queries just type this command in the terminal.
"#.abc" it's an OK answer.
But if you get something like "I am not an OpenDNS resolver.", yep, you are beign cheated by your ISP.
You might want to secure your AWS operations requiring to use a MFA token. But then to use API or tools, you need to pass credentials generated with a MFA token.
This commands asks you for the MFA code and retrieves these credentials using AWS Cli. To print the exports, you can use:
`awk '{ print "export AWS_ACCESS_KEY_ID=\"" $1 "\"\n" "export AWS_SECRET_ACCESS_KEY=\"" $2 "\"\n" "export AWS_SESSION_TOKEN=\"" $3 "\"" }'`
You must adapt the command line to include:
* $MFA_IDis ARN of the virtual MFA or serial number of the physical one
* TTL for the credentials
These are way better than fortune(6).
shows which shared lib files are pointed to by the dynamic linker.
You might want to secure your AWS operations requiring to use a MFA token. But then to use API or tools, you need to pass credentials generated with a MFA token.
This commands asks you for the MFA code and retrieves these credentials using AWS Cli. To print the exports, you can use:
`awk '{ print "export AWS_ACCESS_KEY_ID=\"" $1 "\"\n" "export AWS_SECRET_ACCESS_KEY=\"" $2 "\"\n" "export AWS_SESSION_TOKEN=\"" $3 "\"" }'`
You must adapt the command line to include:
* $MFA_IDis ARN of the virtual MFA or serial number of the physical one
* TTL for the credentials
No need to install yet another program when openssl is already installed. :-)
Translate strings from non-german to german (and vice versa) using LEO. Put it in your ~/.bashrc.
Usage:
$ leo words
To use another language other than english, use an option:
$ leo -xx words
Valid language options:
ch - chinese
en - english
es - spanish
fr - french
it - italian
pl - polish
pt - portuguese
ru - russian
The other language will always be german!
^Hexadecimal Ten minus Octal Ten is Eight(in Decimal).
$ echo "$(( 0xaf )) = $(( 0257 ))"
^Hexadecimal AF and Octal 257 are both Decimal 175.