Entries Categorized as 'How-To’s'
Author:
erics, January 21st, 2020
|
|
echo `mysql -uyourUser -pyourPassword -B --disable-column-names -e "SELECT CONCAT('DROP DATABASE ', SCHEMA_NAME, ';') FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME LIKE 'yourPrefix%';"` | mysql -uyourUser -pyourPassword -B |
Categories: How-To's, Technology Tags: Concat, Database, DB, drop, DROP DATABASE, drop database like, howto, INFORMATION_SCHEMA, INFORMATION_SCHEMA.SCHEMATA, LIKE, Match, mysql, SCHEMA_NAME, SCHEMATA, tips
| 
No comments
Author:
erics, January 21st, 2020
PROBLEM DEFINITION Bamboo Catalina error found in catalina.out:
|
|
-Djava.endorsed.dirs=/volumes/data/bamboo/current/endorsed is not supported. Endorsed standards and standalone APIs in modular form will be supported via the concept of upgradeable modules. Error: Could not create the Java Virtual Machine. Error: A fatal exception has occurred. Program will exit. |
SOLUTION SUMMARY Correct by using Java 8 instead. Do it manually using alternatives –set, or interactively using alternatives –config. MANUAL PROCEDURE – two steps, one for java and one for javac
|
|
alternatives --set java /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/java alternatives --set javac /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/javac |
INTERACTIVE PROCEDURE – two steps, one for java and one for javac
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
root@bamboo:/root # alternatives --config javac There are 3 programs which provide 'javac'. Selection Command ----------------------------------------------- + 1 /usr/lib/jvm/java-1.8.0-openjdk.x86_64/bin/javac * 2 /usr/lib/jvm/java-11-amazon-corretto/bin/javac 3 /usr/lib/jvm/java-1.7.0-openjdk.x86_64/bin/javac Enter to keep the current selection[+], or type selection number: root@bamboo:/root # alternatives --config java There are 4 programs which provide 'java'. Selection Command ----------------------------------------------- + 1 /usr/lib/jvm/jre-1.8.0-openjdk.x86_64/bin/java 2 /usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java * 3 /usr/lib/jvm/java-11-amazon-corretto/bin/java 4 /usr/lib/jvm/jre-1.7.0-openjdk.x86_64/bin/java Enter to keep the current selection[+], or type selection number: |
Categories: How-To's, Technology Tags: alternatives, Bamboo, Catalina, catalina.out, Config, Endorsed, Endorsed standards, howto, Java, Java 8, java upgrade, java.endorsed.dirs, javac, set, tips, upgrade, Yum, yum update
| No comments
Author:
erics, January 20th, 2020
PROBLEM Wordpress site broken with Javascript errors with zero plugins or themes installed. The issue followed different devices, OS’es and different browsers. SOLUTION User account corrupted. The wp_usermeta locale field had an invalid value of “regular”, and nulling the field solved the issue. DETAILS JS console shows this:
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 |
[Error] TypeError: Language code must have format 2-3 letters and. optionally, hyphen, underscore followed by 2 more letters language (mediaelement-and-player.min.js:12:7263) (anonymous function) (mediaelement-and-player.min.js:12:14817) d (mediaelement-and-player.min.js:12:259) r (mediaelement-and-player.min.js:12:414) Global Code (mediaelement-and-player.min.js:12:430) [Error] ReferenceError: Can't find variable: MediaElementPlayer (anonymous function) (mediaelement-migrate.min.js:1:363) Global Code (mediaelement-migrate.min.js:1:1179) [Error] TypeError: undefined is not a function (near '...).mediaelementplayer(e)}}},n(e.wp.mediae...') initialize (wp-mediaelement.min.js:1:855) i (load-scripts.php:2:27368) fireWith (load-scripts.php:2:28123) ready (load-scripts.php:2:29926) J (load-scripts.php:2:30282) [Error] TypeError: undefined is not an object (evaluating 'd.hasClass') (anonymous function) (wp-auth-check.min.js:1:1538) dispatch (load-scripts.php:3:12375) handle (load-scripts.php:3:9094) trigger (load-scripts.php:3:11494) trigger (load-scripts.php:8:8280) (anonymous function) (load-scripts.php:3:18873) each (load-scripts.php:2:2908) each (load-scripts.php:2:851) trigger (load-scripts.php:3:18846) (anonymous function) (heartbeat.min.js:1:2228) i (load-scripts.php:2:27368) fireWith (load-scripts.php:2:28123) x (load-scripts.php:4:22587) c (load-scripts.php:4:26778) |
Categories: How-To's, Technology Tags: Error, Errors, javascript, JS, Locale, TypeError, WordPress
| No comments
Author:
erics, January 10th, 2020
Use the -e option like so:
|
|
rsync -e "ssh -i secret.pem" {sourcespec} {targetspec} |
Categories: How-To's, Technology Tags: .pem, howto, rsync, ssh, tips
| No comments
Author:
erics, January 10th, 2020
|
|
openssl rsa -in ~/.ssh/id_rsa -out ~/.ssh/id_rsa.pem |
Categories: How-To's, Technology Tags: .pem, convert, howto, id_rsa, id_rsa.pem, id_rsa.pub, key, openssl, Private, private key, RSA, ssl, tips
| No comments
Author:
erics, December 11th, 2019
When using Perl’s exec() call, the best way to invoke it is as follows:
|
|
exec("$dir/myprog.sh",@ARGV); |
This syntax does some important things: – passes a scalar value as the first argument which exec interprets as PROGRAM – passes an array as the second argument which exec will use as the arguments to pass into PROGRAM Note […]
Categories: How-To's, Technology Tags: Arg, Args, Argument, Arguments, bash, Exec, Execute, perl, Program, sh, Shell, System
| No comments
Author:
erics, December 2nd, 2019
Not pushed + most recent commit:
Categories: How-To's, Technology Tags: amend, Change, git, howto, modify, tips
| No comments
Author:
erics, November 26th, 2019
To create indents with 4 space characters which are entered by pressing the TAB key:
|
|
set tabstop=8 softtabstop=0 expandtab shiftwidth=4 smarttab |
To make the above settings permanent add to your ~/.vimrc file. For more details on any of these see :help ‘optionname’ in vim (e.g. :help ‘tabstop’) tabstop The width of a hard tabstop measured in “spaces” — effectively the […]
Categories: How-To's, Technology Tags: convert, expandtab, howto, shiftwidth, smarttab, softtabstop, Space, spaces, Tab, Tabs, tabstop, tips, vi, vim
| No comments
Author:
erics, November 24th, 2019
xattr -r -d com.apple.quarantine {dirname} ~or~ xattr -r -d com.apple.quarantine *
Categories: How-To's, Technology Tags: apple, attr, Attribute, Change, com.apple.quarantine, comacast, Delete, directory, howto, MacOS, macosx, Quarantine, Remove, Terminal, tips, Tree, xattr
| No comments
Author:
erics, November 19th, 2019
All credit to Graham Walters for this excellent plugin and post, upon which this post is based – thank you, sir! https://grahamwalters.me/lab/disable-wpautop-on-specific-postspages/ Recently, a client was having problems using a plugin called by a shortcode. As it turned out, the JavaScript embedded in the returned content was being broken by the WordPress auto-paragraph feature known […]
Categories: How-To's, Technology Tags: add_filter, Auto-Paragraph, autop, Disable, Filter, howto, Page, POST, Prevent, remove_filter, Stop, tips, turn off, WordPress, wpautop
| No comments
