labeneator

# OK
Note the 'MM' parameter to date_trunc

In [65]: qry ="""
   SELECT 
       trunc(employees.hire_date, 'MM') AS "employees.hire_date_monthly", 
       coalesce(sum(employees.salary), 0) AS "employees.salary_sum" 
FROM 
   employees JOIN departments ON employees.department_id = departments.department_id 

labeneator

obfuscated = map( lambda x: int(x, 16),  "65 65 65 41 03 11 1c 15".split(" "))
original =  map( lambda x: int(x, 16), "00 00 00 24 66 74 79 70".split(" "))

print obfuscated
# [101, 101, 101, 65, 3, 17, 28, 21]

print original
# [0, 0, 0, 36, 102, 116, 121, 112]

# Every place we have a 0 in the original, the obfuscated file has 101. Sounds suspicious... ;)

labeneator

def deobs_pluralsight(fpath, target_dir):
    fname = os.path.basename(fpath)
    target_fname = fname.replace('psv', 'mp4')
    target_file_path = os.path.join(target_dir, target_fname)

    with open(target_file_path, "wb") as ofh:
        for byte in bytearray(open(fpath, "rb").read()):
            ofh.write(chr(byte ^ 101))

labeneator

 ❯ PATH=$PATH:/Applications/Postgres.app/Contents/Versions/9.6/bin/                                                                                                                                  [19:16:16]

# add languages to postgres
 ❯ psql
CREATE EXTENSION plpythonu;


 ❯ /usr/local/madlib/bin/madpack -s madlib -p postgres  -c postgres@localhost:5432/pypos install -v                                                                                                  [19:16:19]
madpack.py: INFO : Arguments: Namespace(command=['install'], connstr=['postgres@localhost:5432/pypos'], keeplogs=False, platform=['postgres'], schema=['madlib'], testcase='', tmpdir='/tmp/', verbose=True)
madpack.py: INFO : Testing database connection...

labeneator

# Download and install the dmg for postgres.app
# Download the madlib dmg and install it

# Change your version appropriately
❯ PATH=$PATH:/Applications/Postgres.app/Contents/Versions/9.6/bin/                                                                                                                                  [19:16:16]

# add languages to postgres
 ❯ psql
CREATE EXTENSION plpythonu;

labeneator

* * * * * root /usr/local/bin/send_metrics.sh

labeneator

* * * * * root python /usr/local/bin/send_apc_metrics.py  --carbon-host metrics.yourcompany.co.ke 2>&1 | logger -t "apc_metrics"

labeneator

* * * * * root /usr/local/bin/send_metrics.sh

labeneator

#include <File.au3>


WinWaitActive("Microsoft Excel (Product Activation Failed)")

$file = "c:\kra_vat.csv"
FileOpen($file, 0)

labeneator

BIND - delegate a sub domain for a zone

The scenario:

• DNS zone myzone.com defined in BIND.
• Authoritative name server at 123.16.123.1.
• Subzone sub.myzone.com with an authoritative name server at 123.16.123.10.
• Wishing to forward sub-zone to authoritative name server.

Config

$ORIGIN myzone.com.