Skip to content

Instantly share code, notes, and snippets.

View jschroed91's full-sized avatar

Josh Schroeder jschroed91

30 followers · 82 following
View GitHub Profile
@jschroed91
jschroed91 / README.md
Last active October 6, 2023 13:57
Installing pdo-dblib + freeTDS with MAMP 5 and php 7.1 on macOS

macOS pdo-dblib and freetds with MAMP 5

Note that this was written Jan 9th, 2019, and I personally have not tested this since then. It's possible it will still work for your machine, but I can't guarantee it.

Based on some comments, it looks like someone may have had success with it Dec 22, 2020 too.

Prerequisites

  • This was tested with MAMP 5, but probably works with other versions
  • This was tested with php 7.1.20 that was installed via MAMP interface
@jschroed91
jschroed91 / keybase.md
Created July 19, 2018 05:22
keybase.md

Keybase proof

I hereby claim:

  • I am jschroed91 on github.
  • I am jschroeder (https://keybase.io/jschroeder) on keybase.
  • I have a public key ASAfQs9u5jbbG77OYhTRm4xzVUtUKWnwen9xS6xWIWhl3wo

To claim this, I am signing this object:

@jschroed91
jschroed91 / installopenssh76.sh
Last active October 3, 2020 08:50
Install openSSH 7.6 on Ubuntu 14.04
#!/bin/bash
echo "Installing deps..."
sudo apt-get install libssl-dev zlib1g-dev libpam0g-dev xz-utils
sudo apt-get remove openssh-server
echo "Downloading and extracting sources..."
wget http://ftp.openbsd.org/pub/OpenBSD/OpenSSH/portable/openssh-7.6p1.tar.gz
wget http://www.linuxfromscratch.org/patches/downloads/openssh/openssh-7.6p1-openssl-1.1.0-1.patch
tar -xf openssh-7.6p1.tar.gz
@jschroed91
jschroed91 / generated grep.txt
Last active March 15, 2017 17:14
proposal:auditlog:xml-ids --only-final-versions
(4/1498 - 0.27% - 4 hrs remaining - 418.0 MiB) [EB2-15][0] Generated xml id: IEBC2015_AppxA_SubChA1_SecA106.2
(4/1498 - 0.27% - 4 hrs remaining - 420.0 MiB) [EB2-15][0] Generated xml id: IEBC2015_AppxA_SubChA1_SecA107.1
(4/1498 - 0.27% - 4 hrs remaining - 420.0 MiB) [EB2-15][0] Generated xml id: IEBC2015_AppxA_SubChA1_SecA108.1
(4/1498 - 0.27% - 5 hrs remaining - 420.0 MiB) [EB2-15][0] Generated xml id: IEBC2015_AppxA_SubChA1_SecA113.7
(4/1498 - 0.27% - 5 hrs remaining - 420.0 MiB) [EB2-15][0] Generated xml id: IEBC2015_AppxA_SubChA2_SecA206.2
(4/1498 - 0.27% - 5 hrs remaining - 420.0 MiB) [EB2-15][0] Generated xml id: IEBC2015_AppxA_SubChA5_SecA505.1
(51/1498 - 3.4% - 1 hr remaining - 510.3 MiB) [EB33-15][0] Generated xml id: IEBC2015_AppxB_SecB101.3
(51/1498 - 3.4% - 1 hr remaining - 512.3 MiB) [EB33-15][0] Generated xml id: IEBC2015_AppxB_SecB101.4
(51/1498 - 3.4% - 1 hr remaining - 512.3 MiB) [EB33-15][0] Generated xml id: IEBC2015_AppxB_SecB102.2.3
(643/1498 - 42.92% - 11 mins remaining - 971.0 MiB) [RB2
@jschroed91
jschroed91 / ibc2015_frontmatter.xml
Last active February 22, 2017 20:50
<?xml version="1.0" encoding="UTF-8"?>
<section xmlns="http://www.w3.org/1999/xhtml" xmlns:epub="http://www.idpf.org/2007/ops" xmlns:m="http://www.w3.org/1998/Math/MathML" id="IBC2015_frontmatter" class="frontmatter" epub:type="frontmatter">
<section id="IBC2015_titlepage" class="title_page" epub:type="titlepage">
<p>
<span class="content_center">
<img src="Images/Cover.jpg" alt="Cover" />
</span>
</p>
<p class="title_page_acronym">
<span class="content_center">
@jschroed91
jschroed91 / gist:fed38c9401a7978080f9e22876b70a70
Created February 9, 2017 06:51
<div style="text-align: center; width: 200px;">
<div style="line-height: 20px; padding: 20px; color: #333333; background: #ffffff;">#ffffff</div>
<div style="line-height: 20px; padding: 20px; color: #333333; background: #fafafa;">#fafafa</div>
<div style="line-height: 20px; padding: 20px; color: #333333; background: #f9f9f9;">#f9f9f9</div>
<div style="line-height: 20px; padding: 20px; color: #333333; background: #f6f6f6;">#f6f6f6</div>
<div style="line-height: 20px; padding: 20px; color: #333333; background: #f5f5f5;">#f5f5f5</div>
<div style="line-height: 20px; padding: 20px; color: #333333; background: #f1f2f2;">#f1f2f2</div>
<div style="line-height: 20px; padding: 20px; color: #333333; background: #eef0f2;">#eef0f2</div>
<div style="line-height: 20px; padding: 20px; color: #333333; background: #ebebeb;">#ebebeb</div>
<div style="line-height: 20px; padding: 20px; color: #333333; background: #ebeaea;">#ebeaea</div>
@jschroed91
jschroed91 / output
Last active January 26, 2017 17:19
explain query
+----+-------------+------------+--------+--------------------------------------------------------------------------+-----------------------+---------+------------------------------+-------+--------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+------------+--------+--------------------------------------------------------------------------+-----------------------+---------+------------------------------+-------+--------------------------+
| 1 | PRIMARY | <derived2> | ALL | NULL | NULL | NULL | NULL | 28189 | Using where |
| 1 | PRIMARY | er | eq_ref | PRIMARY | PRIMARY | 4 |
@jschroed91
jschroed91 / multiline.html
Created January 11, 2017 13:47
html line length
<!-- ... -->
<div class="dropdown">
<button
type="button"
class="btn btn-secondary dropdown-toggle"
id="dropdownDemoButton"
data-toggle="dropdown"
aria-haspopup="true"
aria-expanded="false"
@jschroed91
jschroed91 / gist:e2e2305399f7ac7a2f6879bb5df2c60a
Created January 6, 2017 17:16
empty nodes
map {
"node": <td xmlns="http://www.w3.org/1999/xhtml" class="border_left border_right" rowspan="1" colspan="1"/>,
"id": "IFC2015_Pt01_Ch01_SubCh02_Sec105.6.21"
}
map {
"node": <td xmlns="http://www.w3.org/1999/xhtml" class="border_left border_right" rowspan="1" colspan="1"/>,
"id": "IFC2015_Pt01_Ch01_SubCh02_Sec105.6.21"
}
map {
"node": <td xmlns="http://www.w3.org/1999/xhtml" class="border_left border_right" rowspan="1" colspan="1"/>,
@jschroed91
jschroed91 / examples.xml
Last active December 15, 2016 15:32
ICCCT-413 - Example XML structures for Exceptions, Numbered Lists, and Adding images/equations into sections
<?xml version="1.0" encoding="UTF-8"?>
<div xmlns="http://www.w3.org/1999/xhtml" xmlns:epub="http://www.idpf.org/2007/ops" xmlns:m="http://www.w3.org/1998/Math/MathML" >
<!--Unordered List-->
<ul class="no_mark">
<li>
<p>– Fire Safety (Chapters 7, 8, 9, 14, 26)</p>
</li>
<li>
<p>– Means of Egress (Chapters 10,11, Appendix E)</p>
</li>