Author:
erics, Posted on Tuesday, January 21st, 2020 at 6:01:23pm
|
|
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, Posted on Tuesday, January 21st, 2020 at 10:40:40am
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, Posted on Monday, January 20th, 2020 at 8:08:13am
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, Posted on Friday, January 10th, 2020 at 2:30:39pm
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, Posted on Friday, January 10th, 2020 at 12:04:42pm
|
|
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, Posted on Wednesday, December 11th, 2019 at 2:39:49pm
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 the use of the parentheses, which I have found to be required for proper behavior.
For more information, please see: https://perldoc.perl.org/functions/exec.html
Categories: How-To's, Technology Tags: Arg, Args, Argument, Arguments, bash, Exec, Execute, perl, Program, sh, Shell, System | No comments
Author:
erics, Posted on Monday, December 2nd, 2019 at 8:15:31am
Not pushed + most recent commit:
Categories: How-To's, Technology Tags: amend, Change, git, howto, modify, tips | No comments
Author:
erics, Posted on Tuesday, November 26th, 2019 at 12:57:23pm
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 (maximum) width of an actual tab character.
shiftwidth
The size of an “indent”. It’s also measured in spaces, so if your code base indents with tab characters then you want shiftwidth to equal the number of tab characters times tabstop. This is also used by things like the =, > and < commands.
softtabstop
Setting this to a non-zero value other than tabstop will make the tab key (in insert mode) insert a combination of spaces (and possibly tabs) to simulate tab stops at this width.
expandtab
Enabling this will make the tab key (in insert mode) insert spaces instead of tab characters. This also affects the behavior of the retab command.
smarttab
Enabling this will make the tab key (in insert mode) insert spaces or tabs to go to the next indent of the next tabstop when the cursor is at the beginning of a line (i.e. the only preceding characters are whitespace).
Categories: How-To's, Technology Tags: convert, expandtab, howto, shiftwidth, smarttab, softtabstop, Space, spaces, Tab, Tabs, tabstop, tips, vi, vim | No comments
Author:
erics, Posted on Sunday, November 24th, 2019 at 9:00:34am
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, Posted on Tuesday, November 19th, 2019 at 1:56:03pm
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 as wpautop.
Thank to a bit of research, I found the following solution, recorded here in case the original blog post becomes unavailable.
- Create the file
wp-content/plugins/disable-wpautop/disable_wpautop.php based on the code below the procedure.
- WordPress » Admin » Plugins » Activate “Disable wpautop”
- Go to the page or post to disable the auto-paragraph feature on
- If the Screen Options tool is not visible below, locate the Screen Options button in the upper right corner, open it and check the box labeled Custom Fields.
- Locate the Custom Fields tool box below, and inside of it the header “Add New Custom Field:”, and under that click on “Enter New”.
- Enter
wpautop as the Name, and false as the Value, then click the “Add Custom Field” button.
- Click the ‘Update’ button to save the settings.
|
|
cd wp-content/plugins/ mkdir disable-wpautop cd disable-wpautop vi disable_wpautop.php |
wp-content/plugins/disable-wpautop/disable_wpautop.php:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
<?php /* * Plugin Name: Disable wpautop * Plugin URI: https://grahamwalters.me/2014/03/07/disable-wpautop-on-specific-postspages/ * Author: Graham Walters * Author URI: https://grahamwalters.me * Version: 1.1 * Description: Disable wpautop on posts/pages with custom field 'wpautop' == false. */ function custom_wpautop($content) { if (get_post_meta(get_the_ID(), 'wpautop', true) == 'false') return $content; else return wpautop($content); } remove_filter('the_content', 'wpautop'); add_filter('the_content', 'custom_wpautop'); |
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
