“...I've been working since 2008 with Ruby / Ruby on Rails, love a bit of Elixir / Phoenix and learning Rust. I also poke through other people's code and make PRs for OpenSource Ruby projects that sometimes make it. Currently working for InPay...”

Rob Lacey (contact@robl.me)
Senior Software Engineer, Brighton, UK

Multiline Ruby String without interpolation

Whilst trying to clean up old blog posts. I thought I’d just re-assign the whole post on the console. However, the content of the post had code examples and these examples were being interpolated. This makes sense but isn’t what I wanted. These are all (nearly) equivalent other than the new lines.

s =<<-STR
#{Time.now}
STR
# => "2017-01-17 06:43:48 -0500" 

s = %(
#{Time.now}
)
# => "\n2017-01-17 06:43:48 -0500\n"

s = %Q(
#{Time.now}
)
# => "\n2017-01-17 06:43:48 -0500\n"

But what I really want it multi-line string assignment without interpolation.

s = %q(
#{Time.now}
)
# => "\n\#{Time.now}\n"

And without the new lines.

s = %q(
#{Time.now}
).lstrip.chop
# => "\#{Time.now}"

Instagram Subscriptions

Instagram Subscriptions

Loading development environment (Rails 5.0.1)
2.3.0 :001 > puts JSON.parse(Infectious::Instagram.subscribe('http://robl.me/instagram/subscriptions/callback','dave').body).to_yaml
ETHON: Libcurl initialized
ETHON: performed EASY effective_url=https://api.instagram.com/v1/subscriptions response_code=200 return_code=ok total_time=1.394347
---
meta:
  code: 200
data:
  object: user
  object_id: 
  aspect: media
  subscription_id: 0
  callback_url: http://robl.me/instagram/subscriptions/callback
  type: subscription
  id: 0

Method#call

Not sure what to make of this at all.

class Cat
  def call(*args)
    (args).join(' ^O^ ')
  end
end

Cat.new.(:samson, :smeagol, :gimmick)

Rails 4, ActiveRecord::Base, MySQL and DISTINCT

Interesting, ActiveRecord joins issues today. Recently upgraded to Rails 4.0 and working on clearing odd occasional bugs.

Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT grapes.id, grapes.* FROM `grapes` INNER JOIN `tickets` ON `z' at line 1: SELECT `pledges`.`id` AS t0_r0, ...., DISTINCT grapes.id, grapes.* FROM `grapes` INNER JOIN `tickets` ....

We specifically need a DISTINCT in here so that we don’t end up with duplicate rows. However, overwriting the select for *eager_load*ed statements isn’t going to work, in fact it appears to just append our select causing the above error. So…

-        scope = scope.joins(:tickets).select('DISTINCT grapes.id, grapes.*')
+        scope = scope.joins(:tickets).distinct('grapes.id')

Don’t use .select(‘DISTINCT … when eager_loading is likely to kick in. You’ll end up with something like.

SELECT `grapes`.`id` AS t0_r0, ..... DISTINCT(grapes.id), grapes.* FROM grapes;

Which will break, since you can’t have two DISTINCT in a SELECT.

Do your columns contain Unicode Characters?

Want to work out if any of your columns contain Unicode Characters?

Something.where('LENGTH(data) != CHAR_LENGTH(data)').first

cannot remove 'v3.0': Directory not empty”

But it is empty???

rails@snarf:~$ ls -la /var/www/robl.me/releases/20160323235726/tmp/cache/assets/sprockets/v3.0
total 40
drwxrwxr-x 2 rails rails 36864 Dec 16 15:11 .
drwxrwxr-x 3 rails rails  4096 Mar 23  2016 ..
rails@snarf:~$ rmdir /var/www/robl.me/releases/20160323235726/tmp/cache/assets/sprockets/v3.0
rmdir: failed to remove ‘/var/www/robl.me/releases/20160323235726/tmp/cache/assets/sprockets/v3.0’: Directory not empty

ActiveSupport Date and Time formats

Just went hunting for Date and Time formats, found this.

activesupport-5.0.0.beta3/lib/active_support/locale/en.yml

en:
  date:
    formats:
      # Use the strftime parameters for formats.
      # When no format has been given, it uses default.
      # You can provide other formats here if you like!
      default: "%Y-%m-%d"
      short: "%b %d"
      long: "%B %d, %Y"

    day_names: [Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday]
    abbr_day_names: [Sun, Mon, Tue, Wed, Thu, Fri, Sat]

    # Don't forget the nil at the beginning; there's no such thing as a 0th month
    month_names: [~, January, February, March, April, May, June, July, August, September, October, November, December]
    abbr_month_names: [~, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec]
    # Used in date_select and datetime_select.
    order:
      - year
      - month
      - day

  time:
    formats:
      default: "%a, %d %b %Y %H:%M:%S %z"
      short: "%d %b %H:%M"
      long: "%B %d, %Y %H:%M"
    am: "am"
    pm: "pm"

# Used in array.to_sentence.
  support:
    array:
      words_connector: ", "
      two_words_connector: " and "
      last_word_connector: ", and "
  number:
    # Used in NumberHelper.number_to_delimited()
    # These are also the defaults for 'currency', 'percentage', 'precision', and 'human'
    format:
      # Sets the separator between the units, for more precision (e.g. 1.0 / 2.0 == 0.5)
      separator: "."
      # Delimits thousands (e.g. 1,000,000 is a million) (always in groups of three)
      delimiter: ","
      # Number of decimals, behind the separator (the number 1 with a precision of 2 gives: 1.00)
      precision: 3
      # If set to true, precision will mean the number of significant digits instead
      # of the number of decimal digits (1234 with precision 2 becomes 1200, 1.23543 becomes 1.2)
      significant: false
      # If set, the zeros after the decimal separator will always be stripped (eg.: 1.200 will be 1.2)
      strip_insignificant_zeros: false

    # Used in NumberHelper.number_to_currency()
    currency:
      format:
        # Where is the currency sign? %u is the currency unit, %n the number (default: $5.00)
        format: "%u%n"
        unit: "$"
        # These five are to override number.format and are optional
        separator: "."
        delimiter: ","
        precision: 2
        significant: false
        strip_insignificant_zeros: false

    # Used in NumberHelper.number_to_percentage()
    percentage:
      format:
        # These five are to override number.format and are optional
        # separator:
        delimiter: ""
        # precision:
        # significant: false
        # strip_insignificant_zeros: false
        format: "%n%"

    # Used in NumberHelper.number_to_rounded()
    precision:
      format:
        # These five are to override number.format and are optional
        # separator:
        delimiter: ""
        # precision:
        # significant: false
        # strip_insignificant_zeros: false

    # Used in NumberHelper.number_to_human_size() and NumberHelper.number_to_human()
    human:
      format:
        # These five are to override number.format and are optional
        # separator:
        delimiter: ""
        precision: 3
        significant: true
        strip_insignificant_zeros: true
      # Used in number_to_human_size()
      storage_units:
        # Storage units output formatting.
        # %u is the storage unit, %n is the number (default: 2 MB)
        format: "%n %u"
        units:
          byte:
            one:   "Byte"
            other: "Bytes"
          kb: "KB"
          mb: "MB"
          gb: "GB"
          tb: "TB"
          pb: "PB"
          eb: "EB"
      # Used in NumberHelper.number_to_human()
      decimal_units:
        format: "%n %u"
        # Decimal units output formatting
        # By default we will only quantify some of the exponents
        # but the commented ones might be defined or overridden
        # by the user.
        units:
          # femto: Quadrillionth
          # pico: Trillionth
          # nano: Billionth
          # micro: Millionth
          # mili: Thousandth
          # centi: Hundredth
          # deci: Tenth
          unit: ""
          # ten:
          #   one: Ten
          #   other: Tens
          # hundred: Hundred
          thousand: Thousand
          million: Million
          billion: Billion
          trillion: Trillion
          quadrillion: Quadrillion

MySQL, Updates with Joins and clearing annoying locks

mysql> UPDATE logs LEFT JOIN ip_ranges ON logs.ip_int BETWEEN ip_ranges.start_ip AND ip_ranges.end_ip SET logs.country = ip_ranges.country_code WHERE logs.country IS NULL;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
mysql> show open tables where in_use>0;
+-----------------------------------+---------------+--------+-------------+
| Database                          | Table         | In_use | Name_locked |
+-----------------------------------+---------------+--------+-------------+
| production | logs |      2 |           0 |
| production | ip_ranges     |      2 |           0 |
+-----------------------------------+---------------+--------+-------------+
2 rows in set (0.00 sec)

mysql> show processlist;
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host      | db                                | Command | Time | State        | Info                                                                                                 |
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
|  1 | root | localhost |production | Sleep   |   14 |              | NULL                                                                                                 |
|  4 | root | localhost | production | Query   | 3857 | Sending data | SELECT COUNT(*) FROM `download_logs` JOIN ip_ranges ON ip_int BETWEEN ip_ranges.start_ip AND ip_rang |
|  5 | root | localhost | production | Query   | 3563 | Sending data | UPDATE `logs` JOIN ip_ranges ON ip_int BETWEEN ip_ranges.start_ip AND ip_ranges.end_ip SET  |
|  8 | root | localhost | production | Query   |    0 | init         | show processlist                                                                                     |
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)

mysql> kill 4;
Query OK, 0 rows affected (0.00 sec)

mysql> show processlist;
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host      | db                                | Command | Time | State        | Info                                                                                                 |
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
|  1 | root | localhost | production | Sleep   |   46 |              | NULL                                                                                                 |
|  5 | root | localhost | production | Query   | 3595 | Sending data | UPDATE `download_logs` JOIN ip_ranges ON ip_int BETWEEN ip_ranges.start_ip AND ip_ranges.end_ip SET  |
|  8 | root | localhost | production | Query   |    0 | init         | show processlist                                                                                     |
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)

mysql> kill 5;
Query OK, 0 rows affected (0.00 sec)

mysql> show processlist;
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
| Id | User | Host      | db                                | Command | Time | State | Info             |
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
|  1 | root | localhost | production | Sleep   |   59 |       | NULL             |
|  8 | root | localhost | production | Query   |    0 | init  | show processlist |
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
2 rows in set (0.00 sec)

mysql> kill 1;
Query OK, 0 rows affected (0.00 sec)

mysql> show processlist;
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
| Id | User | Host      | db                                | Command | Time | State | Info             |
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
|  8 | root | localhost | production | Query   |    0 | init  | show processlist |
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
1 row in set (0.00 sec)

mysql> UPDATE logs LEFT JOIN ip_ranges ON logs.ip_int BETWEEN ip_ranges.start_ip AND ip_ranges.end_ip SET logs.country = ip_ranges.country_code WHERE logs.country IS NULL;

Installing EventMachine on Mac OSX

Robs-iMac:pledge_core roblacey$ gem install eventmachine -v 1.0.7
Building native extensions.  This could take a while...
ERROR:  Error installing eventmachine:
	ERROR: Failed to build gem native extension.

    /Users/roblacey/.rvm/rubies/ruby-2.2.2/bin/ruby -r ./siteconf20161214-75988-ryo2ti.rb extconf.rb
checking for rb_trap_immediate in ruby.h,rubysig.h... no
checking for rb_thread_blocking_region()... no
checking for ruby/thread.h... yes
checking for rb_thread_call_without_gvl() in ruby/thread.h... yes
checking for inotify_init() in sys/inotify.h... no
checking for __NR_inotify_init in sys/syscall.h... no
checking for writev() in sys/uio.h... yes
checking for rb_thread_fd_select()... yes
checking for rb_fdset_t in ruby/intern.h... yes
checking for rb_wait_for_single_fd()... yes
checking for rb_enable_interrupt()... no
checking for rb_time_new()... yes
checking for sys/event.h... yes
checking for sys/queue.h... yes
checking for clock_gettime()... yes
checking for CLOCK_MONOTONIC_RAW in time.h... yes
checking for CLOCK_MONOTONIC in time.h... yes
creating Makefile

make "DESTDIR=" clean

make "DESTDIR="
compiling binder.cpp
In file included from binder.cpp:20:
./project.h:116:10: fatal error: 'openssl/ssl.h' file not found
#include <openssl/ssl.h>
         ^
1 error generated.
make: *** [binder.o] Error 1

make failed, exit code 2

Gem files will remain installed in /Users/roblacey/.rvm/gems/ruby-2.2.2@rails41-trunk/gems/eventmachine-1.0.7 for inspection.
Results logged to /Users/roblacey/.rvm/gems/ruby-2.2.2@rails41-trunk/extensions/x86_64-darwin-14/2.2.0-static/eventmachine-1.0.7/gem_make.out
Robs-iMac:pledge_core roblacey$ cat /Users/roblacey/.rvm/gems/ruby-2.2.2@rails41-trunk/extensions/x86_64-darwin-14/2.2.0-static/eventmachine-1.0.7/gem_make.out
/Users/roblacey/.rvm/rubies/ruby-2.2.2/bin/ruby -r ./siteconf20161214-75988-ryo2ti.rb extconf.rb
checking for rb_trap_immediate in ruby.h,rubysig.h... no
checking for rb_thread_blocking_region()... no
checking for ruby/thread.h... yes
checking for rb_thread_call_without_gvl() in ruby/thread.h... yes
checking for inotify_init() in sys/inotify.h... no
checking for __NR_inotify_init in sys/syscall.h... no
checking for writev() in sys/uio.h... yes
checking for rb_thread_fd_select()... yes
checking for rb_fdset_t in ruby/intern.h... yes
checking for rb_wait_for_single_fd()... yes
checking for rb_enable_interrupt()... no
checking for rb_time_new()... yes
checking for sys/event.h... yes
checking for sys/queue.h... yes
checking for clock_gettime()... yes
checking for CLOCK_MONOTONIC_RAW in time.h... yes
checking for CLOCK_MONOTONIC in time.h... yes
creating Makefile

make "DESTDIR=" clean

make "DESTDIR="
compiling binder.cpp
In file included from binder.cpp:20:
./project.h:116:10: fatal error: 'openssl/ssl.h' file not found
#include <openssl/ssl.h>
         ^
1 error generated.
make: *** [binder.o] Error 1

make failed, exit code 2
Robs-iMac:pledge_core roblacey$ gem install eventmachine -v '1.0.7' -- --with-cppflags=-I/usr/local/opt/openssl/include
Building native extensions with: '--with-cppflags=-I/usr/local/opt/openssl/include'
This could take a while...
Successfully installed eventmachine-1.0.7
Parsing documentation for eventmachine-1.0.7
Installing ri documentation for eventmachine-1.0.7
Done installing documentation for eventmachine after 4 seconds
1 gem installed

Google Drive Access

Grrrr….. Faraday::SSLError: SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed

https://github.com/google/google-api-ruby-client/issues/253

Robs-iMac:epic-invite roblacey$ brew update
Error: /usr/local is not writable. You should change the ownership
and permissions of /usr/local back to your user account:
  sudo chown -R $(whoami) /usr/local
Robs-iMac:epic-invite roblacey$ brew updatesudo chown -R $(whoami) /usr/local
Robs-iMac:epic-invite roblacey$ sudo chown -R $(whoami) /usr/local
Password:
Robs-iMac:epic-invite roblacey$ brew update
Updated Homebrew from b77a695 to 34f08a9.
Updated 2 taps (homebrew/core, homebrew/services).
==> New Formulae
alot                              gitversion                        libngspice                        openssl@1.1                       sslsplit
amqp-cpp                          gmic                              libosmium                         osmfilter                         svgcleaner
apache-zeppelin                   gofabric8                         libsquish                         osrm-backend                      termbox
archi-steam-farm                  grafana                           libuninameslist                   p11-kit                           terraform-provisioner-ansible
armor                             gron                              linkerd                           pacparser                         terragrunt
borg                              hana                              liquigraph                        pdftoedn                          timewarrior
coffeescript                      hashcat                           loc                               piknik                            tldr
compose2kube                      hesiod                            locateme                          presto                            treefrog
consul-backinator                 hg-fast-export                    luaver                            pybind11                          ttyd
csvtomd                           hopenpgp-tools                    metricbeat                        pyinvoke                          ttygif
dbhash                            hostess                           mfterm                            questdb                           twarc
direvent                          httpdiff                          micro                             rancher-cli                       typescript
dscanner                          httpstat                          mikutter                          rclone                            urbit
elvish                            jsonlint                          minimesos                         ripgrep                           vaulted
eventql                           jumanpp                           minio-mc                          rmlint                            wdc
feedgnuplot                       jxrlib                            modd                              shyaml                            wego
folly                             kube-aws                          mpage                             snap-telemetry                    willgit
fsevents-tools                    lean-cli                          nats-streaming-server             sonar-scanner                     xcenv
git-remote-hg                     lego                              neatvi                            sql-translator                    yarn
git-series                        libbdplus                         nmh                               sqldiff                           zsh-git-prompt
gitless                           libdivecomputer                   nvc                               ssh-audit                         zstd
==> Updated Formulae
abcm2ps                           dropbear                          httping                           mksh                              rocksdb
abi-compliance-checker            dropbox-uploader                  hub                               mkvtoolnix                        rolldice
abook                             dspdfviewer                       hugo                              mldonkey                          roswell
ace                               dtach                             hunspell                          mlogger                           rswift
acmetool                          dub                               hydra                             mlt                               rtags
acpica                            duplicity                         hyper                             mmix                              rtv
activemq                          dvm                               hyperscan                         mobile-shell                      ruby
advancecomp                       dwarfutils                        i2p                               mogenerator                       ruby-build
afflib                            dwdiff                            ibex                              monetdb                           runit
afl-fuzz                          dxpy                              ice                               mongo-c                           rush
agedu                             dynamodb-local                    icu4c                             mongodb                           rust
aha                               efl                               idris                             mongoose                          s-search
airspy                            eigen                             imagemagick ✔                     monit                             s6
akka                              ejabberd                          imapsync                          monkeysphere                      saltstack
algernon                          ekg2                              infer                             mono                              sane-backends
allegro                           elasticsearch                     influxdb                          moreutils                         sassc
amap                              elixir                            inspircd                          mosquitto                         sbcl
amazon-ecs-cli                    elixirscript                      internetarchive                   mozjpeg                           sbt
ammonite-repl                     emacs                             ios-deploy                        mpc                               scala
android-ndk                       emacs-clang-complete-async        ios-sim                           mpd                               schismtracker
anjuta                            embulk                            ios-webkit-debug-proxy            mpfr                              scons
ansible                           emp                               ipbt                              mpg123                            scour
ansible-cmdb                      emscripten                        iperf3                            mpich                             scriptcs
ansifilter                        enca                              ipfs                              mpop                              scw
ansiweather                       epic5                             ironcli                           mpv                               sdcc
antigen                           eris                              irrlicht                          msitools                          sdcv
antlr                             erlang                            irssi                             msktutil                          sdl2
apache-flink                      esniper                           isc-dhcp                          msmtp                             sdl_image
apache-spark                      etcd                              iso-codes                         mtools                            selenium-server-standalone
apktool                           evince                            ispc                              mtr                               ser2net
app-engine-go-32                  exercism                          jack                              mu                                serf
app-engine-go-64                  exim                              jansson                           multimarkdown                     sf-pwgen
app-engine-java                   exploitdb                         jasper                            multirust                         sfcgal
app-engine-python                 fabio                             jbake                             mutt                              sflowtool
appscale-tools                    fabric                            jboss-forge                       mvtools                           sfml
apr                               fastd                             jemalloc                          mycli                             shadowsocks-libev
apr-util                          fdk-aac-encoder                   jena                              mypy                              shairport-sync
aqbanking                         fdroidserver                      jenkins                           mysql ✔                           shared-mime-info
arangodb                          fdupes                            jenkins-job-builder               mysql-sandbox                     shellcheck
argon2                            ffind                             jetty                             mysqltuner                        shellinabox
argus-clients                     ffmbc                             jfrog-cli-go                      nanopb-generator                  shpotify
argyll-cms                        ffmpeg ✔                          jlog                              nasm                              siege
aria2                             ffmpegthumbnailer                 jmxtrans                          natalie                           sift
artifactory                       ffms2                             joe                               ncdu                              signify-osx
asciidoc                          fftw                              jpegoptim ✔                       ncmpc                             sile
asciinema2gif                     file-roller                       jq                                ncmpcpp                           simple-tiles
asciiquarium                      filebeat                          jruby                             ncrack                            sjk
asio                              fio                               jsdoc3                            neo4j                             skinny
assh                              fish                              json-fortran                      neofetch                          sleuthkit
at-spi2-atk                       flake8                            json-glib                         neon                              slimerjs
at-spi2-core                      flatbuffers                       jsoncpp                           netpbm                            smali
atk                               flatcc                            jsonnet                           nettle                            smartmontools
ats2-postiats                     fleetctl                          jsonpp                            newlisp                           smlnj
aubio                             flex                              jsonschema2pojo                   nexus                             sngrep
augeas                            flow                              kafka                             nghttp2                           socat
aurora-cli                        flowgrind                         kapacitor                         nginx                             sops
autoconf-archive                  fluent-bit                        kawa                              nickle                            source-highlight
autoenv                           flvmeta                           kerl                              nifi                              sourcekitten
autojump                          fmt                               kes                               nim                               spatialite-gui
avro-c                            fobis                             kettle                            nmap                              spatialite-tools
awf                               fontconfig                        keybase                           node ✔                            spdylay
aws-apigateway-importer           fontforge                         khal                              node-build                        spidermonkey
aws-elasticbeanstalk              fonttools                         khard                             nodeenv                           spring-loaded
aws-sdk-cpp                       ford                              kibana                            nomad                             sqlite
aws-shell                         format-udf                        kitchen-sync                      noti                              sqlite-analyzer
awscli                            freeipmi                          knot                              notmuch                           sqlmap
azure-cli                         freeling                          kobalt                            nsd                               ssdb
b2-tools                          freeradius-server                 konoha                            nspr                              sshguard
babl                              freetds                           kore                              nss                               sshuttle
bacula-fd                         freetype ✔                        kotlin                            ntl                               ssllabs-scan
baobab                            fstar                             kpcli                             nvm                               sslscan
basex                             fswatch                           kubernetes-cli                    nzbget                            sslyze
bash                              fuseki                            kyua                              oauth2_proxy                      storm
bash-git-prompt                   fwup                              languagetool                      ocamlbuild                        stout
bash-preexec                      fzf                               latex2html                        offlineimap                       strongswan
bashdb                            galen                             latexml                           ola                               stunnel
bazel                             gammaray                          launch                            omega                             subliminal
bdw-gc                            gammu                             launch4j                          oniguruma                         subnetcalc
bear                              gauche                            lbdb                              ooniprobe                         supersonic
beecrypt                          gauge                             ldapvi                            open-babel                        supervisor
bfg                               gawk                              ldc                               open-mpi                          suricata
bgpq3                             gcc                               ldns                              open-scene-graph                  svtplay-dl
bib-tool                          gcovr                             le                                opencc                            swagger-codegen
bibtexconv                        gd                                leaps                             openconnect                       swi-prolog
bind                              gdal                              ledger                            opencsg                           swift
binutils                          gdb                               legit                             opendbx                           swiftgen
binwalk                           gdk-pixbuf                        leiningen                         openhmd                           swiftlint
bitrise                           gdl                               lensfun                           openjpeg                          swig
blackbox                          gdm                               leveldb                           openrtsp                          syncthing
bmake                             geckodriver                       lfe                               openshift-cli                     syncthing-inotify
boost                             gedit                             libass                            openssl ✔                         sysdig
boost-bcp                         gegl                              libatomic_ops                     openvdb                           szl
boost-build                       generate-json-schema              libbluray                         openvpn                           taglib ✔
boost-python                      geoserver                         libbson                           ophcrack                          tailor
botan                             ghc                               libbtbb                           orc                               takt
brew-gem                          ghex                              libcddb                           oscats                            tarantool
brotli                            ginac                             libcdio                           osh                               tbb
bsdconv                           git                               libcdr                            osm-pbf                           tbox
buku                              git-annex                         libcec                            osm2pgrouting                     tccutil
c-ares                            git-archive-all                   libcouchbase                      osm2pgsql                         tcpkali
cabal-install                     git-cola                          libdap                            osmosis                           telegraf
cadaver                           git-credential-manager            libdrawtext                       osquery                           terminal-notifier
caddy                             git-extras                        libebur128                        owfs                              terraform
caf                               git-fixup                         libetonyek                        oysttyer                          texinfo
cake                              git-flow-avh                      libexosip                         packer                            texmath
calabash                          git-fresh                         libflowmanager                    paket                             tgui
calc                              git-imerge                        libfreenect                       pam_yubico                        the_platinum_searcher
carina                            git-lfs                           libftdi                           pandoc                            the_silver_searcher
carthage                          git-octopus                       libgaiagraphics                   pandoc-citeproc                   thefuck
cask                              git-secret                        libgcrypt                         pandoc-crossref                   tig
cassandra                         git-town                          libgda                            pango                             tile38
castxml                           git-when-merged                   libgee                            pangomm                           tin
cattle                            gitbucket                         libgeotiff                        paperkey                          tinc
cayley                            giter8                            libgetdata                        parallel                          tinyproxy
ccache                            gitg                              libgit2                           pass                              tippecanoe
ccextractor                       gitlab-ci-multi-runner            libgit2-glib                      passenger                         titan-server
cconv                             gjs                               libgraphqlparser                  passpie                           tmux
cereal                            gjstest                           libgsf                            pazpar2                           tmux-mem-cpu-load
cern-ndiff                        glade                             libicns                           pcap_dnsproxy                     todolist
certbot                           glib                              libiscsi                          pcb2gcode                         tomcat
certigo                           glib-networking                   libjson-rpc-cpp                   pce                               tor
ceylon                            glibmm                            libksba ✔                         pdal                              torsocks
cfr-decompiler                    glide                             liblastfm                         pdf2htmlex                        trafficserver
cgal                              glm                               liblwgeom                         pdnsrec                           transcrypt
cgdb                              global                            libmagic                          pdsh                              translate-shell
cgrep                             globus-toolkit                    libmicrohttpd                     peco                              translate-toolkit
chaiscript                        glyr                              libmill                           peg                               typesafe-activator
chapel                            gnatsd                            libmongoclient                    percona-server                    uchardet
charm                             gnome-builder                     libmspub                          percona-toolkit                   uhd
charm-tools                       gnome-icon-theme                  libmtp                            pgbadger                          unbound
cheat                             gnome-themes-standard             libnfs                            pgcli                             uncrustify
checkstyle                        gnu-apl                           libnotify                         pgroonga                          unrar
chisel                            gnu-complexity                    libosinfo                         pgrouting                         upscaledb
chromedriver ✔                    gnu-smalltalk                     libosip                           pick                              urweb
citus                             gnu-tar                           libpeas                           picocom                           uwsgi
cjdns                             gnu-units                         libphonenumber                    pidcat                            vala
clang-format                      gnumeric                          libpng ✔                          pillar                            valabind
clearlooks-phenix                 gnupg ✔                           libpointing                       pius                              valgrind
cli53                             gnupg2                            libprotoident                     pkg-config ✔                      vapoursynth
clib                              gnuplot                           libqalculate                      planck                            varnish
cliclick                          gnuradio                          librasterlite                     plantuml                          vault
clipper                           gnutls                            libraw                            platformio                        vc4asm
clisp                             go                                librdkafka                        plowshare                         vcdimager
clutter-gst                       goaccess                          libreadline-java                  pmd                               vdirsyncer
clutter-gtk                       gobject-introspection             libressl                          pngcrush                          vegeta
cmake                             godep                             libsamplerate                     poco                              verilator
cmocka                            goffice                           libscrypt                         pod2man                           vert.x
coccinelle                        gollum                            libsigc++                         ponyc                             vim
cocoapods                         google-benchmark                  libsoup                           poppler                           vmtouch
codequery                         googler                           libspatialite                     postgis                           vnstat
cogl                              gor                               libspiro                          postgres-xc                       voldemort
collectd                          gosu                              libssh2                           postgresql                        voltdb
commandbox                        govendor                          libstrophe                        pre-commit                        voms
conan                             gpgme                             libswiften                        predictionio                      vowpal-wabbit
concurrencykit                    gphoto2                           libtess2                          premake                           vte3
consul                            gpm                               libtiff ✔                         primesieve                        vultr
consul-template                   gprof2dot                         libtorrent-rasterbar              privoxy                           wakatime-cli
convox                            gputils                           libu2f-host                       profanity                         wartremover
coq                               gqlplus                           libuv                             progress                          watch
corectl                           gradle                            libvirt                           proguard                          watchman
coturn                            grails                            libvisio                          proj                              watson
couchdb                           graphicsmagick                    libvpx                            prometheus                        webkitgtk
cppcheck                          graphite2                         libxml++3                         proof-general                     weboob
cpprestsdk                        graphviz                          libxmp                            protobuf                          wellington
creduce                           grib-api                          libxslt                           protobuf-c                        wgetpaste
cromwell                          gringo                            libyaml ✔                         protobuf-swift                    whatmp3
cryptopp                          groonga                           liquibase                         psgrep                            wildfly-as
crystal-lang                      gsettings-desktop-schemas         lldpd                             pulledpork                        wimlib
csfml                             gsl                               llnode                            purescript                        wine
cucumber-cpp                      gsoap                             llvm                              pushpin                           winetricks
curl                              gspell                            lmdb                              pwntools                          wireguard-tools
dar                               gssdp                             lnav                              pwsafe                            wireshark
darcs                             gssh                              logentries                        pyenv                             with-readline
darkice                           gst-editing-services              logstash                          pyenv-virtualenv                  wolfssl
dash                              gst-libav                         logtalk                           pygobject3                        wrangler
datetime-fortran                  gst-plugins-bad                   luajit                            pypy                              wxmac
datomic                           gst-plugins-base                  luaradio                          pyqt5                             x264 ✔
davix                             gst-plugins-good                  lynis                             python                            x265
dbus                              gst-plugins-ugly                  m-cli                             python3                           xapian
dc3dd                             gst-python                        macosvpn                          qbs                               xcproj
dcmtk                             gst-validate                      macvim                            qca                               xctool
dcraw                             gstreamer                         mailhog                           qemu                              xmake
ddar                              gstreamermm                       mailutils                         qjackctl                          xonsh
debianutils                       gtk+                              makepkg                           qscintilla2                       xorriso
deheader                          gtk+3                             mapnik                            qt5                               yadm
deis                              gtk-gnutella                      mapserver                         quantlib                          yafc
deisctl                           gtk-vnc                           mariadb                           quazip                            yank
deja-gnu                          gtkextra                          mas                               quilt                             yara
dependency-check                  gtkmm                             matlab2tikz                       qwt                               yash
depqbf                            gtkmm3                            mawk                              qxmpp                             yaz
devd                              gtksourceview3                    mbedtls                           radare2                           yazpp
devhelp                           gucharmap                         mbelib                            rainbarf                          yle-dl
devtodo                           guile                             mdbtools                          rakudo-star                       you-get
dieharder                         gupnp                             mdds                              rancher-compose                   youtube-dl
diff-pdf                          gupnp-av                          mdk                               rapidjson                         yubico-piv-tool
diff-so-fancy                     gupnp-tools                       mdp                               rbenv-binstubs                    z3
digdag                            gwyddion                          mdv                               re2                               zbackup
discount                          gx                                media-info                        readline ✔                        zebra
distribution                      gx-go                             mediaconch                        reattach-to-user-namespace        zenity
ditaa                             gxml                              memcached ✔                       rebar                             zero-install
djview4                           h2o                               mercurial                         redis ✔                           zeromq
dmd                               hadolint                          meson                             redpen                            zile
dnscrypt-wrapper                  hadoop                            mesos                             remarshal                         zimg
docker                            harfbuzz                          metabase                          remctl                            znapzend
docker-cloud                      haskell-stack                     metaproxy                         renameutils                       zookeeper
docker-compose                    hbase                             metashell                         repo                              zorba
docker-machine                    hebcal                            mg                                reposurgeon                       zpaq
docker-machine-driver-xhyve       heroku                            mg3a                              rethinkdb                         zplug
docker-machine-nfs                hh                                micropython                       rfcmarkup                         zsh-autosuggestions
docker-swarm                      highlight                         midnight-commander                rgxg                              zsh-completions
dockutil                          highlighting-kate                 mighttpd2                         rhash                             zsh-navigation-tools
doctl                             hive                              miller                            rhino                             zsh-syntax-highlighting
dovecot                           hledger                           minio                             riemann                           zurl
doxygen                           homebank                          mitmproxy                         riemann-client
dpkg                              httpie                            mkdocs                            rlwrap
==> Renamed Formulae
geode -> apache-geode                     racket -> minimal-racket                  sonar -> sonarqube                        stash-cli -> atlassian-cli
==> Deleted Formulae
aeskeyfind              curaengine              fugu                    lftp                    pyqwt                   sgfutils                treeline
aget                    cuty_capt               geany                   libdbusmenu-qt          pyside                  shiboken                txt2man
apt-cacher-ng           czmqpp                  gimp                    libechonest             pyside-tools            slony                   ucspi-tools
automoc4                dircproxy               git-stree               libmarisa               qbzr                    sonar-runner            valkyrie
box2d                   disco                   idcomments              libnice                 qwtpolar                sqliteman               wyrd
bzr-explorer            dwarf                   jing                    libqglviewer            rbenv-readline          sqsh                    yap
caudec                  elementary              jless                   openlitespeed           rcssserver              swish-e
cfitsio                 evas-generic-loaders    jsdoc-toolkit           orpie                   rfcdiff                 tevent
class-dump              ezlupdate               kjell                   pgtap                   rsense                  tlassemble
coin                    frescobaldi             lastfmlib               puddletag               samba                   trang
==> Migrating HOMEBREW_REPOSITORY (please wait)...
==> Migrated HOMEBREW_REPOSITORY to /usr/local/Homebrew!
Homebrew no longer needs to have ownership of /usr/local. If you wish you can
return /usr/local to its default ownership with:
  sudo chown root:wheel /usr/local
Robs-iMac:epic-invite roblacey$ sudo chown root:wheel /usr/local
Robs-iMac:epic-invite roblacey$ brew upgrade openssl
==> Upgrading 1 outdated package, with result:
openssl 1.0.2j
==> Upgrading openssl
==> Downloading https://homebrew.bintray.com/bottles/openssl-1.0.2j.sierra.bottle.tar.gz
######################################################################## 100.0%
==> Pouring openssl-1.0.2j.sierra.bottle.tar.gz
==> Using the sandbox
==> Caveats
A CA file has been bootstrapped using certificates from the SystemRoots
keychain. To add additional certificates (e.g. the certificates added in
the System keychain), place .pem files in
  /usr/local/etc/openssl/certs

and run
  /usr/local/opt/openssl/bin/c_rehash

This formula is keg-only, which means it was not symlinked into /usr/local.

Apple has deprecated use of OpenSSL in favor of its own TLS and crypto libraries

Generally there are no consequences of this for you. If you build your
own software and it requires this formula, you'll need to add to your
build variables:

    LDFLAGS:  -L/usr/local/opt/openssl/lib
    CPPFLAGS: -I/usr/local/opt/openssl/include
    PKG_CONFIG_PATH: /usr/local/opt/openssl/lib/pkgconfig

==> Summary
 /usr/local/Cellar/openssl/1.0.2j: 1,695 files, 12M