agrohe21’s gists

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 / 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 / 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 / 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 / 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 / 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 / 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 / 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 / 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'] )

Andy Grohe agrohe21