cruzer45’s gists

cruzer45 / fix_file_and_folder_permission.sh

Created April 12, 2018 17:43

Correct file and folder permissions for web directory

	find . -type d -exec chmod 755 {} \;
	find . -type f -exec chmod 644 {} \;

cruzer45 / query_finder.sql

Created January 25, 2017 17:59 — forked from mezis/query_finder.sql

Finding long-running queries in MySQL

	SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120)
	FROM information_schema.processlist
	WHERE command <> 'Sleep'
	AND info NOT LIKE '%PROCESSLIST%'
	ORDER BY time DESC LIMIT 50;

cruzer45 / fix_locale_ubuntu.sh

Created November 15, 2016 04:26

Ubuntu script to fix locale issue

sudo locale-gen "en_US.UTF-8" && sudo dpkg-reconfigure locales

cruzer45 / html5_video_conv.bash

Created August 27, 2016 08:44 — forked from zpea/html5_video_conv.bash

little shell script to convert video files to the various HTML5 video formats/codecs using ffmpeg. Also generates the line for embedding the video using the videoJS plugin for wordpress.

	#!/bin/bash

	#
	# video conversion script for publishing as HTML 5 video, via videojs (with hd button extension)
	# 2011 by zpea
	# feel free to use as public domain / Creative Commons CC0 1.0 (http://creativecommons.org/publicdomain/zero/1.0/)
	#

	FFMPEG=/usr/bin/ffmpeg
	HD_SUFFIX='_hd'

cruzer45 / postgres delete duplicate rows.sql

Created May 20, 2016 17:36

Postgres Delete duplicate rows

-DELETE FROM tablename
-WHERE id IN (
-  SELECT id FROM (
-    SELECT id, ROW_NUMBER() OVER (partition BY column1, column2, column3 ORDER BY id) AS rnum
-    FROM tablename
-  ) t
-  WHERE t.rnum > 1
-);

cruzer45 / clean_boot_partition.sh

Created May 18, 2016 18:00

Clean full ubuntu boot partition

dpkg --get-selections|grep 'linux-image*'|awk '{print $1}'|egrep -v "linux-image-$(uname -r)|linux-image-generic" |while read n;do apt-get -y remove $n;done

cruzer45 / freeswitch 1.6 build steps Ubuntu 14.04.sh

Last active February 4, 2021 12:28



	#add the repositories
	sudo apt-get update && sudo apt-get install -y curl
	curl http://files.freeswitch.org/repo/deb/debian/freeswitch_archive_g0.pub \| sudo apt-key add -
	echo "deb http://files.freeswitch.org/repo/deb/freeswitch-1.6/ jessie main" \| sudo tee /etc/apt/sources.list.d/freeswitch.list
	sudo apt-get update

	# install dependencies
	sudo apt-get install -y yasm nasm libyuv-dev libvpx2-dev liblua5.2-dev libvpx2-dev libvpx2 zlib1g-dev libspeex1 libopus-dev libsndfile-dev autoconf automake devscripts gawk g++ git-core 'libjpeg-dev\|libjpeg62-turbo-dev' libncurses5-dev 'libtool-bin\|libtool' make python-dev gawk pkg-config libtiff5-dev libperl-dev libgdbm-dev libdb-dev gettext libssl-dev libcurl4-openssl-dev libpcre3-dev libspeex-dev libspeexdsp-dev libsqlite3-dev libedit-dev libldns-dev libpq-dev yasm nasm unixodbc-dev unixodbc-bin unixodbc odbc-postgresql

cruzer45 / Backup.sh

Created November 25, 2015 03:03

The script i use to backup my machine.

	#!/bin/bash

	#Backup Databases
	#echo "Backing up Databases"
	#'/home/mrogers/Projects/Databases/automysqlbackup-v3.0_beta3/automysqlbackup' '/home/mrogers/Projects/Databases/automysqlbackup-v3.0_beta3/automysqlbackup.conf'

	#Sync back the directories.
	echo "Backing up Home Folder"
	#rsync -avh --progress --del /home/mrogers/ /media/mrogers/CRUZER/mrogers/
	#rsync -avh --progress --delete-before --force --stats --ignore-errors --exclude '.vdi' --exclude 'Videos/' /home/mrogers/ /media/mrogers/CRUZER/mrogers/

cruzer45 / reinstall_apps.sh

Created November 25, 2015 03:01

Script i used to use to reinstall my app on Ubuntu

	#sudo add-apt-repository ppa:webupd8team/sublime-text-3
	#sudo add-apt-repository ppa:nilarimogard/webupd8
	#sudo add-apt-repository ppa:me-davidsansome/clementine
	#sudo add-apt-repository ppa:webupd8team/java
	#sudo add-apt-repository ppa:linrunner/tlp
	#sudo add-apt-repository ppa:libreoffice/ppa
	#sudo add-apt-repository ppa:pdoes/ppa
	#sudo add-apt-repository ppa:webupd8team/y-ppa-manager
	#sudo add-apt-repository ppa:git-core/ppa
	#sudo add-apt-repository ppa:chris-lea/node.js

cruzer45 / grails_webserver_setup_java7.sh

Last active January 9, 2017 15:38

An install script to setup all the services I need for my grails applications

	sudo apt-get update && sudo apt-get dist-upgrade --yes && sudo apt-get install --yes python-software-properties software-properties-common;\
	sudo add-apt-repository ppa:webupd8team/java --yes && sudo add-apt-repository ppa:git-core/ppa --yes;\
	sudo apt-get update && sudo apt-get dist-upgrade --yes;\
	sudo apt-get install --yes git curl postgresql postgresql-contrib oracle-java7-installer nginx htop zip unzip weex;\
	curl -s http://get.sdkman.io \| bash ; source ~/.sdkman/bin/sdkman-init.sh ; \
	mkdir -p ~/tomcat/; cd ~/tomcat/; wget http://www.us.apache.org/dist/tomcat/tomcat-7/v7.0.72/bin/apache-tomcat-7.0.72.tar.gz; tar -xvf apache-tomcat-7.0.72.tar.gz ; \
	cd apache-tomcat-7.0.72/webapps/ ; rm -rf ~/tomcat/apache-tomcat-7.0.72/webapps/* ;\
	ssh-keygen; cat ~/.ssh/id_rsa.pub;\
	mkdir -p ~/app/; cd ~/app/

Maurice Rogers cruzer45