Author:
erics, July 1st, 2019
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
#!/bin/sh DATE=`date` ( echo "From: Your Full Name <you@yourdomain.com>" echo "To: you@yourdomain.com" echo "Subject: AWS Instances Report for All Customers as of $DATE" cat <<EOT MIME-Version: 1.0 Content-Type: text/html Content-Disposition: inline <html> <body> <pre style="font: monospace"> EOT for profile in customer1 customer2 customer3; do for region in `aws ec2 describe-regions --output text | cut -f3`; do echo -e "\nListing Instances for profile $profile in region: '$region'..." aws ec2 describe-instances \ --filters "Name=instance-state-name,Values=running" \ --query 'Reservations[*].Instances[*].[InstanceId, PublicIpAddress, LaunchTime, InstanceType, Tags[?Key==`Name`] | [0].Value]| sort_by(@, &@[0][2])' \ --region $region \ --profile $profile \ --output table done done cat <<EOT </pre> </body> </html> EOT ) | /usr/sbin/sendmail -t |
Categories: How-To's, Technology Tags: AWS, aws ec2, Date, EC2, Email, Font, Format, howto, html, LaunchTime, mail, monospace, monospaced, Multiple, Region, Regions, SendMail, sort, Sort By, time, tips
| 
No comments
Author:
erics, June 12th, 2019
The Problem Tried to install the latest version of cpan and got stuck. Tracked it down to the dependency module Mac::SystemDirectory which was failing to build:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
cpan[1]> install Mac::SystemDirectory Reading '/var/root/.cpan/Metadata' Database was generated on Sun, 09 Jun 2019 07:17:02 GMT Running install for module 'Mac::SystemDirectory' Running make for E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz Checksum for /var/root/.cpan/sources/authors/id/E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz ok Scanning cache /var/root/.cpan/build for sizes ............................................................................DONE CPAN.pm: Building E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz HASCOMPILEREZFt/TESTUSSI.c:2:10: fatal error: 'EXTERN.h' file not found #include "EXTERN.h" ^~~~~~~~~~ 1 error generated. Couldn't execute cc -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -Os "-I/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE" -c HASCOMPILEREZFt/TESTUSSI.c -o HASCOMPILEREZFt/TESTUSSI.o: Inappropriate ioctl for device at Makefile.PL line 14. Requires a compiler Warning: No success on command[/usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE] ETHER/Mac-SystemDirectory-0.10.tar.gz /usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE -- NOT OK Running make test Make had some problems, won't test Running make install Make had some problems, won't install Failed during this command: ETHER/Mac-SystemDirectory-0.10.tar.gz : writemakefile NO '/usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE' returned status 6400 |
The Solution Use the MacOS installer command to deploy the needed files:
|
|
sudo installer -pkg /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg -target / installer: Package name is macOS_SDK_headers_for_macOS_10.14 installer: Installing at base path / installer: The install was successful. |
The, rerunning the cpan install works:
|
|
cpan[1]> install Mac::SystemDirectory ... Running make install Files found in blib/arch: installing files in blib/lib into architecture dependent library tree Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/Mac/SystemDirectory/SystemDirectory.bs Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/Mac/SystemDirectory/SystemDirectory.bundle Installing /Library/Perl/5.18/darwin-thread-multi-2level/Mac/SystemDirectory.pm Installing /usr/local/share/man/man3/Mac::SystemDirectory.3pm Appending installation info to /Library/Perl/Updates/5.18.2/darwin-thread-multi-2level/perllocal.pod ETHER/Mac-SystemDirectory-0.10.tar.gz /usr/bin/make install -- OK |
Categories: How-To's, Technology Tags: 10.14, CPAN, Error, extern.h, Fatal, Fatal Error, File not found, Header, headers, howto, Install, installer, Libraries, Library, MacOS, Mojave, not found, Package, perl, pkg, System, tips, update, upgrade, XCode
| No comments
Author:
erics, June 12th, 2019
The Problem Tried to load a Tab-delimited text file into MuSQL 5.6.43 and got the following error: mysql> LOAD DATA INFILE ‘sample.txt’ INTO TABLE test_table; ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot execute this statement Solution One mysql> SHOW VARIABLES LIKE “secure_file_priv”; Copy the file into the […]
Categories: How-To's, Technology Tags: Data, Error, File, howto, INFILE, Load, LOAD DATA, LOAD DATA INFILE, LOAD DATA LOCAL INFILE, local, mysql, Priv, Privilege, Secure, secure_file_priv, secure-file-priv, Show, SHOW VARIABLES, tips, VARIABLES
| No comments
Author:
erics, June 3rd, 2019
To display the filenames included in each commit, just add the –name-only argument to git log:
Categories: How-To's, Technology Tags: Display, File, file names, git, git log, howto, Log, names, Show, tips
| No comments
Author:
erics, May 31st, 2019
Quickref: How to Remove a file from the staging area
|
|
git rm --cached {fileName(s)} |
The Story Recently, I accidentally added some files to git’s pre-commit phase, i.e.:
|
|
shell> git status On branch master Your branch is up-to-date with 'origin/master'. Changes to be committed: (use "git reset HEAD <file>..." to unstage) new file: good1.xml new file: good2.xml new file: bad1.xml new file: bad2.xml modified: good3.xml modified: bad3.xml |
For example, here is how to handle the above situation:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
shell> git rm --cached bad1.xml bad2.xml bad3.xml shell> git status On branch master Your branch is up-to-date with 'origin/master'. Changes to be committed: (use "git reset HEAD <file>..." to unstage) new file: good1.xml new file: good2.xml modified: good3.xml Untracked files: (use "git add <file>..." to include in what will be committed) bad1.xml bad2.xml bad3.xml |
To better understand, here are the phases/states/stages that git uses: Untracked – when a file is first created, git […]
Categories: How-To's, Technology Tags: Cache, commit, committed, git, howto, modified, Remove, staged, staging, tips, untracked
| No comments
Author:
erics, May 31st, 2019
I have a task in Perl to list specific files based on pattern match, those with and those without the string “_from_”. There are two files in the directory to filter: static-east.properties static-east_from_west.properties To capture the files with the _from_ string was easy:
|
|
/^static-(.*?)_from_(.*?)\.properties$/ |
To capture the files WITHOUT the _from_ string was not quite […]
Categories: How-To's, Technology Tags: exclude, howto, Lookahead, Negative, Negative Lookahead, perl, Regex, tips, without
| No comments
Author:
erics, May 10th, 2019
I was getting rsync errors from one source host:
|
|
Corrupted MAC on input. Disconnecting: Packet corrupt |
Finally tracked it down to the application “Little Snitch”. Needed to fully uninstall it and reboot to get the problem solved.
Categories: How-To's, Technology Tags: corrupt, Corrupted MAC on input, howto, Little Snitch, MacOS, macosx, Packet corrupt, rsync, Snitch, Snow Leopard, tips
| No comments
Author:
erics, April 16th, 2019
Problem: Trying to run a yum -y update as root aborts with the following error:
|
|
The GPG keys listed for the "Percona-Release YUM repository - x86_64" repository are already installed but they are not correct for this package. Check that the correct key URLs are configured for this repository. Failing package is: sysbench-1.0.17-2.el6.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona |
The solution, found on the Percona website, is this: sudo yum update percona-release Source URL: https://www.percona.com/blog/2019/02/05/new-percona-package-signing-key-requires-update-on-rhel-and-centos/
Categories: How-To's, Technology Tags: GPG, howto, key, Keys, Percona, percona-release, release, tips, update, Yum, yum update
| No comments
Author:
erics, February 16th, 2019
As of Mac OS X Lion 10.7, Terminal provides Services for opening a new terminal window or tab at the selected folder in Finder. They also work with absolute pathnames selected in text (in any application). You can enable these services with System Preferences > Keyboard > Keyboard Shortcuts > Services. Look for “New Terminal […]
Categories: How-To's, Technology Tags: apple, Finder, howto, Keyboard, MacOS, macosx, Menu, Mojave, Open, Services, Terminal, tips, window
| No comments
Author:
erics, February 4th, 2019
Use the ssh-keygen command on a computer to which you’ve downloaded your private key .pem file; for example: First, ensure permissions will allow ssh-keygen to work: chmod 600 /path/to/the/file/your-key-pair.pem Then generate an RSA public key: ssh-keygen -y -f /path/to/the/file/your-key-pair.pem > your-key-pair.pub
Categories: How-To's, Technology Tags: .pem, .pub, Amazon, apple, AWS, cli, howto, key, key-pair, KeyPair, Linux, Mac, MacOS, macosx, Pubkey, public, Public Key, ssh-keygen, tips
| No comments
