Leonardo Canessa master-bob
master-bob
/ gist:e57b7a6f4cd3dd7d828cc3860e56ebb8
Created
August 18, 2016 19:52
Oracle PL/SQL Create Samigo metadata, WIP - doesn't work ...
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| set serveroutput on; | |
| DECLARE | |
| CURSOR c1 IS SELECT DISTINCT ASSESSMENTID FROM SAM_PUBLISHEDMETADATA_T; | |
| CURSOR c2(p_ass_id in NUMBER) is SELECT LABEL FROM SAM_PUBLISHEDMETADATA_T WHERE ASSESSMENTID = p_ass_id; | |
| l_found NUMBER(1); | |
| total NUMBER(38); | |
| found NUMBER(38); | |
| BEGIN | |
| total := 0; | |
| found := 0; |
master-bob
/ createUsers.py
Last active
September 10, 2019 15:58
A script used to create users on a Sakai 11.x server using Python3 and zeep.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| """ | |
| Python3 | |
| """ | |
| import os | |
| import sys | |
| import csv | |
| from zeep import Client | |
| ##################### EDIT HERE ##################### |
master-bob
/ gist:33d09a8ef0ece6873b921e63523c91c5
Created
May 20, 2016 12:59
SQLTransientException w/HikariCP 2.4.6
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2016-05-20 08:39:08,160 DEBUG sakai housekeeper com.zaxxer.hikari.pool.HikariPool - sakai - Pool stats (total=100, active=100, idle=0, waiting=3) | |
| 2016-05-20 08:39:08,247 WARN sakai housekeeper com.zaxxer.hikari.pool.ProxyLeakTask - Connection leak detection triggered for oracle.jdbc.driver.T4CConnection@301e3c83, stack trace follows | |
| java.lang.Exception: Apparent connection leak detected | |
| at org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260) | |
| at org.sakaiproject.event.impl.ClusterEventTracking.writeBatchEvents(ClusterEventTracking.java:378) | |
| at org.sakaiproject.event.impl.ClusterEventTracking.run(ClusterEventTracking.java:570) | |
| at java.lang.Thread.run(Thread.java:745) | |
| 2016-05-20 08:39:33,247 DEBUG org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerBySpringCGLIB$$d42ec2bd com.zaxxer.hikari.pool.HikariPool - sakai - Timeout failure stats (total=100, active=100, idle=0, waiting=7) | |
| 2016-05-20 08:39:33,247 WARN org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerBySpr |
master-bob
/ gist:cdb3ea99250bce0cb8350a51be7fe057
Created
May 13, 2016 17:26
Sakai 11.x SQLTRansientConnectionExceptions
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2016-05-13 13:17:49,041 WARN org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerBySpringCGLIB$$d42ec2bd org.sakaiproject.event.impl.ClusterEventTracking - org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerBySpringCGLIB$$d42ec2bd@15998ce3.writeBatchEvents: java.sql.SQLTransientConnectionException: sakai - Connection is not available, request timed out after 30000ms. | |
| java.sql.SQLTransientConnectionException: sakai - Connection is not available, request timed out after 30000ms. | |
| at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196) | |
| at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:147) | |
| at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:99) | |
| at org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260) | |
| at org.sakaiproject.event.impl.ClusterEventTracking.writeBatchEvents(ClusterEventTracking.java:400) | |
| at org.sakaiproject.event.impl.ClusterEventTracking.run(ClusterEventTracking.java:570) | |
| at java.lang.Thread.run(T |
master-bob
/ clean_tomcat.sh
Last active
May 17, 2017 17:24
— forked from mtheoryx/clean_tomcat.sh
A simple script to completely clean tomcat between Sakai deployments
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # created by Leonardo Canessa | |
| # Modified from mtheoryx | |
| # lcanessa1@udayton.edu | |
| # simple script to clean tomcat prior to deploying sakai | |
| # $CATALINA_HOME assumed to be a symlink (/opt/tomcat) to an apache-tomcat-X.Y.Z folder | |
| tomcatVersion=`ls -l $CATALINA_HOME` | |
| tomcat8=false | |
| tomcat7=false |