Skip to content

Instantly share code, notes, and snippets.

View agrohe21's full-sized avatar

Andy Grohe agrohe21

5 followers · 1 following
View GitHub Profile
@agrohe21
agrohe21 / CRaSH Command Pentaho connection
Created March 14, 2014 22:21
@Grab(group='org.codehaus.groovy.modules.http-builder', module='http-builder', version='0.7')
import groovyx.net.http.RESTClient
import static groovyx.net.http.ContentType.*
import org.crsh.text.ui.UIBuilder
UIBuilder ui = new UIBuilder();
def http = new RESTClient( 'http://localhost:8080/pentaho/' )
def resp = http.get( path: 'content/ws-run/soapConnectionService/getConnections', query: [userid: 'admin', password: 'password'] )
@agrohe21
agrohe21 / gist:9630680
Created March 18, 2014 22:00
CRaSH pba command
@Grab(group='org.codehaus.groovy.modules.http-builder', module='http-builder', version='0.7')
import groovyx.net.http.RESTClient
import static groovyx.net.http.ContentType.*
import org.crsh.text.ui.UIBuilder;
import org.crsh.cli.Command;
import org.crsh.cli.Usage;
import org.crsh.cli.Option;
@agrohe21
agrohe21 / import mondrian file to pentaho server
Created September 22, 2014 15:00
./import-export.sh
--import
--url=http://localhost:8080/pentaho
--username=admin
--password=password
--file-path=/home/pentaho/SteelWheels.xml
--resource-type=datasource
--datasource-type=analysis
--analysis-datasource=sampledata
--catalog=SteelWheels
@agrohe21
agrohe21 / mondrian_log4j.xml
Last active March 25, 2023 16:58
<!-- Mondrian -->
<appender name="MONDRIAN" class="org.apache.log4j.DailyRollingFileAppender">
<param name="File" value="/home/pentaho/pentaho/server/biserver-ee/logs/mondrian.log"/>
<param name="Append" value="true"/>
<param name="DatePattern" value="'.'yyyy-MM-dd"/>
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d %-5p (%t) [%c] %m%n"/>
</layout>
</appender>
@agrohe21
agrohe21 / prd_log4j.xml
Last active April 2, 2019 13:51
<!-- PRDPERF Add This file appender to output aggregated performance statistics -->
<appender name="PerformanceFileAppender" class="org.apache.log4j.DailyRollingFileAppender">
<param name="File" value="/home/pentaho/pentaho/server/biserver-ee/logs/prd-perfStats.log"/>
<param name="Append" value="true"/>
<!-- Rollover at midnight each day -->
<param name="DatePattern" value="'.'yyyy-MM-dd"/>
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d{dd.MM.yyyy.HH.mm.ss.SSS}||%t||%m%n"/>
</layout>
</appender>
@agrohe21
agrohe21 / http_server.xml
Created June 3, 2016 14:22
<!-- 4.x -->
<Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs" prefix="http_access." suffix=".log" pattern="%t|%a|%m|%p|%U|%q|%s|%S|%u|%D|%T|%B|%{User-agent}i|%{Referer}i|%A|%{Content-Type}o|%{SECURITY_PRINCIPAL}s" resolveHosts="false"/>
<!-- 5.0 with user -->
<Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs" prefix="http_access" suffix=".log" pattern="%t|%a|%m|%p|%U|%q|%s|%S|%u|%D|%T|%B|%{User-agent}i|%{Referer}i|%A|%{Content-Type}o|%{SPRING_SECURITY_LAST_USERNAME}s" resolveHosts="false"/>
<!-- 5.0 without user -->
<Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs" prefix="http_access." suffix=".log" pattern="%t|%a|%m|%p|%U|%q|%s|%S|%u|%D|%T|%B|%{User-agent}i|%{Referer}i|%A|%{Content-Type}o" resolveHosts="false"/>
@agrohe21
agrohe21 / thread_log4j.xml
Created June 3, 2016 14:24
<!-- Uncomment this param in PENTAHOFILE appender section
comment out current ConversionPattern. This adds active thread and other details -->
<param name="ConversionPattern" value="%d %-5r %-5p [%c] (%t:%x) %m%n"/>
@agrohe21
agrohe21 / Catalina_rotate
Last active May 23, 2017 15:29
/home/pentaho/pentaho/server/pentaho-server/tomcat/logs/catalina.out {
rotate 90
daily
copytruncate
compress
missingok
size 50M
}
@agrohe21
agrohe21 / curl_run_monitor
Last active December 21, 2016 15:53
sleep 30
curl -i -u admin:password -m 30 http://localhost:8080/pentaho/api/repos/%3Apublic%3AMonitor%3ABIS%3Ajvm_log.xaction/generatedContent >> /dev/null
@agrohe21
agrohe21 / sample_kettle.properties
Created June 23, 2016 17:08
PROJECT_DIR=/home/pentaho/projects
KETTLE_REDIRECT_STDERR=Y
KETTLE_REDIRECT_STDOUT=Y
KETTLE_MAX_LOGGING_REGISTRY_SIZE=10000
KETTLE_LOG_MARK_MAPPINGS=Y
KETTLE_JOB_LOG_SCHEMA=pentaho_dilogs
KETTLE_JOB_LOG_DB=live_logging_info
KETTLE_JOB_LOG_TABLE=job_logs