oeon

Essentially, the problem is that the default SSL cert for Postgres /etc/ssl/certs/ssl-cert-snakeoil.pem does not have enough information when copied over to the Guest machine running PowerBI which is trying to connect to Postgres, specifically, the Common Name field.

There are various posts out there about this e.g. https://community.powerbi.com/t5/Desktop/PostgreSQL-powerbi-desktop-connection-error/m-p/90689. This one was good to point me at npgsql 3.1.8 specifically https://blogs.msdn.microsoft.com/chmitch/2018/06/04/complete-guide-to-setting-up-power-bi-connecting-to-postgres-w-refresh-enabled/

1. create a new SSL certificate (roughly) following these guides: https://uit.stanford.edu/service/ssl/selfsigned + https://www.postgresql.org/docs/9.1/static/ssl-tcp.html be sure to set the Common Name field value to the IP address of the server which is hosting the Postgres instance you're connecting to from PowerBI. -days 3650 will set the expiration in 10 years, default is 30 days if not specified.

oeon

Homebrew build logs for osgeo/osgeo4mac/qgis2 on macOS 10.12.5
Build date: 2017-05-26 12:13:28

oeon

Homebrew build logs for qgis/qgisdev/qgis3-dev on macOS 10.12.5
Build date: 2017-05-15 15:40:08

oeon

oeon

1. brew install sendemail
2. Allow less secure apps to access your account https://support.google.com/accounts/answer/6010255?hl=en
3. python delete.py; sendemail -f username@gmail.com -t 5558675309@vtext.com -m "Hello, World" -o tls=yes -s smtp.gmail.com -xu username -xp password

Providers

What's my SMS Email address?

• AT&T 10DigitPhoneNumber@txt.att.net
• Example: 9055556543@txt.att.net

oeon

function b2a(a) {
  var c, d, e, f, g, h, i, j, o, b = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=", k = 0, l = 0, m = "", n = [];
  if (!a) return a;
  do c = a.charCodeAt(k++), d = a.charCodeAt(k++), e = a.charCodeAt(k++), j = c << 16 | d << 8 | e, 
  f = 63 & j >> 18, g = 63 & j >> 12, h = 63 & j >> 6, i = 63 & j, n[l++] = b.charAt(f) + b.charAt(g) + b.charAt(h) + b.charAt(i); while (k < a.length);
  return m = n.join(""), o = a.length % 3, (o ? m.slice(0, o - 3) :m) + "===".slice(o || 3);
}

function a2b(a) {
  var b, c, d, e = {}, f = 0, g = 0, h = "", i = String.fromCharCode, j = a.length;

oeon

oeon

#!/bin/bash
INPUT=fire_hydrants.csv
OLDIFS=$IFS
IFS=,
[ ! -f $INPUT ] && { echo "$INPUT file not found"; exit 99; }
while read -a csv_line
do
	mv ${csv_line[0]}.pdf ${csv_line[8]}-${csv_line[0]}.pdf
done < $INPUT

oeon

here's the original UPDATE statement we're wanting to automate when there's an UPDATE on another table

UPDATE hydrant_grid SET point_count = (SELECT count(*)
FROM fire_hydrant_inventory WHERE status='true' AND ST_Intersects(fire_hydrant_inventory.the_geom, hydrant_grid.the_geom))

here's the trigger and function

CREATE OR REPLACE FUNCTION updatecount()
RETURNS trigger AS $$

oeon

import urllib2
import datetime
def timeStamped(fname, fmt='%Y-%m-%d-%H-%M-%S_{fname}'):
    return datetime.datetime.now().strftime(fmt).format(fname=fname)
url = 'https://web.fulcrumapp.com/shares/6e158acd08cacfad.csv'
u = urllib2.urlopen(url)
localFile = open('fulcrum_data.csv', 'w')
localFile.write(u.read())
localFile.close()
with open(timeStamped('fulcrum_data.csv'),'w') as outf: