Mau3189

### Keybase proof

I hereby claim:

  * I am mau3189 on github.
  * I am mroldan (https://keybase.io/mroldan) on keybase.
  * I have a public key whose fingerprint is 6216 1FD5 D1B7 5BF5 0606  2DF8 9C27 7607 674F 066D

To claim this, I am signing this object:

Mau3189

require 'slack-ruby-client'

TOKEN = 'AUTH TOKEN'.freeze
CHANNEL = 'CHANNEL ID'.freeze
MESSAGES_PER_REQUEST = 1_000 # 1000 is the limit per request

# :nodoc:
class LogChannelHistory
  def initialize
    Slack.configure { |config| config.token = TOKEN }

Mau3189

Remove MySQL completely

1. Open the Terminal

2. Use mysqldump to backup your databases

3. Check for MySQL processes with: ps -ax | grep mysql

4. Stop and kill any MySQL processes

5. Analyze MySQL on HomeBrew:

brew remove mysql

Mau3189

SELECT "datasources"."id" AS "datasource_id", "users"."id" AS "user_id"
FROM "datasource_restricted_companies"
INNER JOIN "datasources"
  ON "datasources"."id" = "datasource_restricted_companies"."datasource_id"
INNER JOIN "users"  
  ON "users"."company_id" = "datasource_restricted_companies"."company_id"
WHERE "datasources"."access_level" = 'restricted'

Mau3189

#!/usr/bin/ruby

# README
# gem install aws-sdk
# add this to bashrc
# export HT_DEV_AWS_ACCESS_KEY_ID=????
# export HT_DEV_AWS_SECRET_ACCESS_KEY=????
# put your pem file in ~/.ssh and chmod 0400
# for more info see; https://rubygems.org/gems/aws-sdk

Mau3189

require 'net/ftp'

CONTENT_SERVER_DOMAIN_NAME = "one-of-the-ftp-server.thought-sauce.com.hk"
CONTENT_SERVER_FTP_LOGIN = "saucy-ftp-server-login"
CONTENT_SERVER_FTP_PASSWORD = "saucy-ftp-server-password"


# LOGIN and LIST available files at default home directory
Net::FTP.open(CONTENT_SERVER_DOMAIN_NAME, CONTENT_SERVER_FTP_LOGIN, CONTENT_SERVER_FTP_PASSWORD) do |ftp|
  files = ftp.list

Mau3189

#!/usr/bin/env ruby

require 'rubygems'
require 'aws-sdk'

# Should we create a special user restricted to S3 only?
AWS.config(
	access_key_id: '', 
	secret_access_key: ''
)