djrobby

-- this is a random comment
-- anything prefixed by two dashes is a comment
-- and will not be executed by the database

-- to start the interactive session on the command prompt
-- type: $ sqlite3
-- something will be printed and then you'll see another prompt like this
-- sqlite>

djrobby

-- When SQLite is compiled with the JSON1 extensions it provides builtin tools
-- for manipulating JSON data stored in the database. 
-- This is a gist showing SQLite return query data as a JSON object.
-- https://www.sqlite.org/json1.html

-- An example table with some data
CREATE TABLE users (
  id INTEGER PRIMARY KEY NOT NULL, 
  full_name TEXT NOT NULL, 
  email TEXT NOT NULL, 

djrobby

diff --git a/ext/openssl/extconf.rb b/ext/openssl/extconf.rb
index 8c04cb5..132d803 100644
--- a/ext/openssl/extconf.rb
+++ b/ext/openssl/extconf.rb
@@ -104,6 +104,9 @@
 have_func("SSLv2_method")
 have_func("SSLv2_server_method")
 have_func("SSLv2_client_method")
+have_func("SSLv3_method")
+have_func("SSLv3_server_method")

djrobby

diff --git a/ext/openssl/ossl_ssl.c b/ext/openssl/ossl_ssl.c
--- a/ext/openssl/ossl_ssl.c
+++ b/ext/openssl/ossl_ssl.c
@@ -107,6 +107,18 @@
     OSSL_SSL_METHOD_ENTRY(TLSv1),
     OSSL_SSL_METHOD_ENTRY(TLSv1_server),
     OSSL_SSL_METHOD_ENTRY(TLSv1_client),
+#if defined(HAVE_TLSV1_2_METHOD) && defined(HAVE_TLSV1_2_SERVER_METHOD) && \
+        defined(HAVE_TLSV1_2_CLIENT_METHOD)
+    OSSL_SSL_METHOD_ENTRY(TLSv1_2),

djrobby

#!/bin/sh
# Based on instructions from
# https://docs.dash.org/en/stable/masternodes/setup-testnet.html
#
# See https://www.vultr.com/docs/vultr-startup-scripts-quickstart-guide
# for details of using Vultr startup scripts

# Add new user
USERNAME=yourusernamehere # Username to create

djrobby

#!/bin/bash

cat << EOF
#=============================================================================#
#                             Startup Boot Script                             #
# --------------------------------------------------------------------------- #
# Platform : Vultr VPS (Debian 9)                                             #
# Author   : KaiserKatze <[email protected]>                                  #
# --------------------------------------------------------------------------- #
# This startup script is saved to `/tmp/firstboot.exec` after execution.      #

djrobby

# Startup script for Ubuntu 17.04 VPS on Vultr (Dev machine and cloud server)

# add a new user @todo: make this a one-liner
# adduser stvhwrd
# usermod -aG sudo stvhwrd

## MANUALLY LOG OUT AS ROOT AND LOG IN AS NEW USER

# OPTIONAL: to add ssh key, assuming that you have ssh-copy-id installed on local machine and your keypair is in ~/.ssh and named id_rsa:
# Locally, i.e. on your laptop.  eg. ssh-copy-id [email protected]

djrobby

diff --git a/ext/openssl/extconf.rb b/ext/openssl/extconf.rb
index bfb1ea4..eaa2557 100644
--- a/ext/openssl/extconf.rb
+++ b/ext/openssl/extconf.rb
@@ -104,6 +104,15 @@ have_func("OPENSSL_cleanse")
 have_func("SSLv2_method")
 have_func("SSLv2_server_method")
 have_func("SSLv2_client_method")
+have_func("SSLv3_method")
+have_func("SSLv3_server_method")

djrobby

alias nx='/bin/bash ~/.scripts/nx.sh' # NginX scripts

djrobby

#!/bin/bash
#https://www.libvips.org/install.html
VERSION="8.12.2"
echo ""
echo "---------------------------------"
echo "|     AUTO COMPILE LIBVIPS       |"
echo "---------------------------------"
echo ""
echo "-----------------------"
echo "Installing cgif"