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 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 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
Author:
erics, November 19th, 2019
Normally, there is an option in the Screen Options menu to show or hide the Custom Fields tool. If this option is missing, you may have the plugin Advanced Custom Fields (ACF) version 5.5.13 or greater installed and active because ACF removes the Custom Fields tool to improve page load speed. If you do have […]
Categories: How-To's, Technology Tags: ACF, add_filter, Advanced Custom Fields, Custom, Custom Fields, Fields, Filter, functions.php, howto, meta, Settings, tips, WordPress, Wordpress Custom Fields
| No comments
Author:
erics, September 12th, 2019
Needed to build a feature for a Bookstore tool to have an optional sequence number for the Custom Post Type “books” that would allow items with a seq number to float to the top of the list and be sorted by seq #. The rest of the books would show underneath, sorted alphabetically.
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 |
$querytop = get_posts(array( 'post_type' => 'books', 'numberposts' => -1, 'orderby' => 'meta_value', 'meta_key' => 'book_seq', 'order' => 'ASC', 'meta_query' => array( // meta query takes an array of arrays, watch out for this! array( 'key' => 'book_seq', 'value' => array('', 'NULL'), 'compare' => 'NOT IN' ) ) )); $querybottom = get_posts(array( 'post_type' => 'books', 'numberposts' => -1, 'orderby' => 'post_title', 'order' => 'ASC', 'meta_query' => array( // meta query takes an array of arrays, watch out for this! array( 'key' => 'book_seq', 'compare' => 'NOT EXISTS' ) ) )); $query = array_merge($querytop, $querybottom); |
Categories: How-To's, Technology Tags: bottom, Compare, cpt, Exists, Filter, Float, get_posts, howto, key, meta_key, meta_value, NOT EXISTS, NOT IN, Order, OrderBy, post_type, Query, Seq, Sequence, sort, tips, top, Value, WordPress
| No comments
