Yovko Lambrev yovko

Building signTextJS

Clone https://github.com/angelyordanov/signTextJS
Run travis/osx..install script or open it and run the steps manually
Run travis/osx..script
If all goes well you'll have a signtextjs_plus-0.0.0-macos.dmg in the repo root

How to delete Vault (AWS Glacier)

This Gist give some tips in order to remove AWS Glacier Vault with AWS CLI (ie. https://aws.amazon.com/en/cli/).

Step 1 / Retrive inventory

$ aws glacier initiate-job --job-parameters '{"Type": "inventory-retrieval"}' --vault-name YOUR_VAULT_NAME --account-id YOUR_ACCOUNT_ID --region YOUR_REGION

WordPress database clean up queries

Orphan rows
Other

	version: 0.2

	env:
	variables:
	NODE_ENV: "${env}"

	phases:
	install:
	runtime-versions:
	nodejs: 12

	#!/bin/bash
	### Copyright 2010 Manuel Carrasco Moñino. (manolo at apache.org)
	### Copyright 2016 Patrick Double (pat at patdouble.com)
	###
	### Licensed under the Apache License, Version 2.0.
	### You may obtain a copy of it at
	### http://www.apache.org/licenses/LICENSE-2.0

	###
	### A library for shell scripts which creates reports in jUnit format.

	DB="your_database_name"
	USER="your_db_user"
	PASS="your_db_pass"
	HOST="database_hostname"
	(
	echo 'ALTER DATABASE `'"$DB"'` CHARACTER SET utf8 COLLATE utf8_general_ci;'
	mysql -p $PASS -u $USER -h $HOST "$DB" -e "SHOW TABLES" --batch --skip-column-names \
	\| xargs -I{} echo 'ALTER TABLE `'{}'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;'
	) \
	\| mysql -p $PASS -u $USER -h $HOST "$DB"

	upstream phpfpm {
	server unix:/var/run/php5-fpm.sock;
	}

	upstream hhvm {
	server unix:/var/run/hhvm/hhvm.sock;
	}

	# SSL
	ssl_protocols TLSv1 TLSv1.1 TLSv1.2;