Skip to content

Instantly share code, notes, and snippets.

View matthewtckr's full-sized avatar

Matt Tucker matthewtckr

  • Pentaho
  • Orlando, FL
View GitHub Profile
@matthewtckr
matthewtckr / PDI_UDJC_HashAllStrings.java
Created July 7, 2017 19:33
Hash All Strings in Row
import java.math.BigInteger;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.util.HashMap;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
List stringFields;
MessageDigest digest;
@matthewtckr
matthewtckr / fortigate.cnf
Created July 6, 2017 14:34
Fortigate SSL Configuration
[ req ]
default_bits = 2048
distinguished_name = req_distinguished_name
req_extensions = req_ext
[ req_distinguished_name ]
countryName = US
stateOrProvinceName = Florida
localityName = Orlando
organizationName = Acme Corporation
commonName = 172.20.48.1
@matthewtckr
matthewtckr / get_md5_config_files.osx.sh
Last active May 19, 2017 20:30
Pentaho Server Comparison
#!/bin/sh
find $(pwd) -type f \( -name "*.xml" -or -name "*.properties" -or -name "*.sh" -or -name "*.cfg" \) -print0 | xargs -0 tar -czf $(basename $PWD)_config.tar.gz
find $(pwd) -type f -print0 | xargs -0 stat -f '%N%t%Su:%Sg%t%Lp%n' | while read LINE
do
FILE=$(echo $LINE | awk '{print $1}')
OWNER=$(echo $LINE | awk '{print $2}')
FILEPERM=$(echo $LINE | awk '{print $3}')
MD5SUM=$(md5 $FILE | awk '{print $NF}')
echo -e "$FILE\t$MD5SUM\t$OWNER\t$FILEPERM"
@matthewtckr
matthewtckr / additional web-xml entries.txt
Created September 15, 2016 16:29
Pentaho Backups without Credentials
<filter-mapping>
<filter-name>Proxy Trusting Filter</filter-name>
<url-pattern>/api/repo/files/backup</url-pattern>
</filter-mapping>
# Resize Disk 1
vboxmanage clonemedium disk "C:\Users\mtucker\VirtualBox VMs\MapR-Sandbox-For-Hadoop-4.0.2\MapR-Sandbox-For-Hadoop-4.0.2-disk1.vmdk" "C:\Users\mtucker\VirtualBox VMs\MapR-Sandbox-For-Hadoop-4.0.2\MapR-Sandbox-For-Hadoop-4.0.2-disk1.vdi" --format VDI
C:\Program Files\Oracle VM VirtualBox>vboxmanage modifymedium "C:\Users\mtucker\VirtualBox VMs\MapR-Sandbox-For-Hadoop-4.0.2\MapR-Sandbox-For-Hadoop-4.0.2-disk1.vdi" --resize 100000
# Change VM Config to point to VDI, instead of VMDK
# Boot with GParted Live CD, add new partition
# Boot normally, add partition to LVM, extend LVM, and resize mount point
# Configure a FQDN hostname
sudo yum -y install krb5-libs krb5-server krb5-workstation
# Download and modify https://gist.githubusercontent.com/matthewtckr/eaf6180c3edd7d4ce025/raw/config_server.sh
@matthewtckr
matthewtckr / PDI-CE-Remove-OSGI.md
Last active August 12, 2018 13:47
Remove OSGI from PDI 6.0 Client

Note:

Unsupported configuration, some functionality (Hadoop, MongoDB, etc) may be lost by removing OSGI. That said, this makes PDI start up much, much quicker

Steps:

Required:

  • Remove plugins/pentaho-big-data-plugin
@matthewtckr
matthewtckr / MongoShard.bat
Last active May 7, 2019 11:54
MongoDB Sharding Example
REM
REM Setup a MongoDB Sharded Cluster
REM
REM Reference: http://cookbook.mongodb.org/operations/convert-replica-set-to-replicated-shard-cluster/
REM More Info: http://www.kchodorow.com/blog/2010/08/09/sharding-and-replica-sets-illustrated/
REM
REM Download and Unpack MongoDB Software
REM
SET URL="https://fastdl.mongodb.org/win32/mongodb-win32-x86_64-2008plus-2.6.11.zip"
@matthewtckr
matthewtckr / config_server.sh
Last active May 10, 2018 02:26
CentOS Kerberos Configuration
#!/bin/bash
# Configure Script Settings
# KDC Server Name, admin user, non-admin user, default password
HOSTNAME=kerberos.muppets.com
ADMINUSER=mtucker
NORMALUSER=pentaho
PASSWORD=Pentaho123
@matthewtckr
matthewtckr / Schema.xsd
Created March 27, 2015 20:52
PDI-13661
<?xml version="1.0" encoding="UTF-8" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<!-- definition of simple elements -->
<xs:element name="orderperson" type="xs:string"/>
<xs:element name="name" type="xs:string"/>
<xs:element name="address" type="xs:string"/>
<xs:element name="city" type="xs:string"/>
<xs:element name="country" type="xs:string"/>
<xs:element name="title" type="xs:string"/>
@matthewtckr
matthewtckr / IAM-S3-Policy
Last active August 29, 2015 14:17
PDI-7538: S3 Steps with IAM Users
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": "s3:ListAllMyBuckets",
"Resource": "arn:aws:s3:::*"
},
{
"Effect": "Allow",