ericandrewlewis

Setting up a WordPress site on AWS

This tutorial walks through setting up AWS infrastructure for WordPress, starting at creating an AWS account. We'll manually provision a single EC2 instance (i.e an AWS virtual machine) to run WordPress using Nginx, PHP-FPM, and MySQL.

This tutorial assumes you're relatively comfortable on the command line and editing system configuration files. It is intended for folks who want a high-level of control and understanding of their infrastructure. It will take about half an hour if you don't Google away at some point.

If you experience any difficulties or have any feedback, leave a comment. 🐬

Coming soon: I'll write another tutorial on a high availability setup for WordPress on AWS, including load-balancing multiple application servers in an auto-scaling group and utilizing RDS.

hassansin

Model::

  /*Select*/
  select('col1','col2')
  ->select(array('col1','col2'))
  ->select(DB::raw('businesses.*, COUNT(reviews.id) as no_of_ratings, IFNULL(sum(reviews.score),0) as rating'))  
  ->addSelect('col3','col4')
  ->distinct() // distinct select
  
  /*From*/

jeffjohnson9046

## I just ran into this after initializing a Visual Studio project _before_ adding a .gitignore file (like an idiot).  
## I felt real dumb commiting a bunch of files I didn't need to, so the commands below should do the trick.  The first two commands
## came from the second answer on this post:  http://stackoverflow.com/questions/7527982/applying-gitignore-to-committed-files

# See the unwanted files:
git ls-files -ci --exclude-standard

# Remove the unwanted files: 
git ls-files -ci --exclude-standard -z | xargs -0 git rm --cached

superbiche

/*
 * Inserts a new key/value before the key in the array.
 *
 * @param $key
 *   The key to insert before.
 * @param $array
 *   An array to insert in to.
 * @param $new_key

renchap

Prerequisites : the letsencrypt CLI tool

This method allows your to generate and renew your Lets Encrypt certificates with 1 command. This is easily automatable to renew each 60 days, as advised.

You need nginx to answer on port 80 on all the domains you want a certificate for. Then you need to serve the challenge used by letsencrypt on /.well-known/acme-challenge. Then we invoke the letsencrypt command, telling the tool to write the challenge files in the directory we used as a root in the nginx configuration.

I redirect all HTTP requests on HTTPS, so my nginx config looks like :

server {

MatthewVance

#!/usr/bin/env bash

# make script exit if a simple command fails and
# make script print commands being executed
set -e -x

# names of latest versions of each package
export VERSION_PCRE=pcre-8.38
export VERSION_OPENSSL=openssl-1.0.2f
export VERSION_NGINX=nginx-1.9.11

Informatic

1. Format your storage
2. Configure networking (it's easiest with LuCI, or just take a look at OpenWRT howtos)
3. Configure /storage by adding proper options in /etc/config/fstab, or, again, just clicking around in LuCI
4. opkg update && opkg install tor
5. Copy proper configuration, namely /etc/tor/torrc and /etc/config/uhttpd
6. Reboot (or /etc/init.d/uhttpd restart && /etc/init.d/tor restart)
7. Check /etc/tor/hidden_service/hostname for your public .onion address
8. ...
9. PROFIT!

ariefbayu

<?php
$loader = require __DIR__.'/vendor/autoload.php';
use Longman\TelegramBot\Request;


$API_KEY = '--botfather-api-keu--';
$BOT_NAME = '--bofather-bot-name--';

$telegram = new Longman\TelegramBot\Telegram($API_KEY, $BOT_NAME);

simonluijk

#!/usr/bin/env python
import argparse
import qrcode


def main():
    parser = argparse.ArgumentParser(description='Generate QR code for OTP.')
    parser.add_argument('user', nargs=1)
    parser.add_argument('key', nargs=1)
    parser.add_argument('issuer', nargs=1)

zauberstuhl

#!/bin/bash

echo -n "Name your client (MyBot): "
read client_name

echo -n "Define your pod address (with https://): "
read domain

cookie_file="/tmp/.cookie"
openid_url="$domain/api/openid_connect"