jschroed91

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

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

#!/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

(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

<?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

<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

+----+-------------+------------+--------+--------------------------------------------------------------------------+-----------------------+---------+------------------------------+-------+--------------------------+
| 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

<!-- ... -->

      <div class="dropdown">
        <button
          type="button"
          class="btn btn-secondary dropdown-toggle"
          id="dropdownDemoButton"
          data-toggle="dropdown"
          aria-haspopup="true"
          aria-expanded="false"

jschroed91

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

<?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>