YogSottot

    if ($request_uri = /) { 
      set $test  A; 
    } 
  
    if ($host ~* teambox.com) { 
      set $test  "${test}B"; 
    } 
  
    if ($http_cookie !~* "auth_token") { 
      set $test  "${test}C"; 

YogSottot

Setting up a SSL Cert from Comodo

I use Namecheap.com as a registrar, and they resale SSL Certs from a number of other companies, including Comodo.

These are the steps I went through to set up an SSL cert.

Purchase the cert

YogSottot

#!/bin/bash

database='database'
user='user'
pass='pass'

charset='utf8mb4'
collate='utf8mb4_unicode_ci'

echo "Changing charset of database: $database"

YogSottot

This is a sequel to "Postfix: relay to authenticated SMTP".

I would like to send mail from two different Gmail accounts using Postfix. Here is the relevant section in the Postfix documentation: Configuring Sender-Dependent SASL authentication.

As a concrete example, here's how to set up two Gmail accounts (only relevant sections of the config files are listed below):

/etc/postfix/main.cf:
    # sender-dependent sasl authentication
    smtp_sender_dependent_authentication = yes

sender_dependent_relayhost_maps = hash:/etc/postfix/sender_relay

YogSottot

from MySQLdb import connect

conn = connect(user="[user]", passwd= "[password]", host="[host]")
cur = conn.cursor()

cur.execute("show databases;")
dbs_to_update = filter(
  lambda db: db not in ('information_schema', 'mysql', 'performance_schema'),
	[dbname[0] for dbname in cur.fetchall()])