sallyhall/mssql_ci.md

## 4 changes: 2 additions & 2 deletions gistfile1.txt → mssql_ci.md
@@ -1,4 +1,4 @@

    #Things that didn't work:
#Things that didn't work:

    # Things that didn't work:
# Things that didn't work:


    I started by adding a service to the test
I started by adding a service to the test

    step, using the same Docker image and passing the env vars the test used.
step, using the same Docker image and passing the env vars the test used.
@@ -73,7 +73,7 @@ This failed because it needed Libnettle 3.4.1. So I added a step to install nett

        && sudo make install
    && sudo make install

    ```
```


    What finally did work:
What finally did work:

    # What finally did work:
# What finally did work:


    Nettle installed successfully, but I still got the error `Libnettle 3.4.1 was
Nettle installed successfully, but I still got the error `Libnettle 3.4.1 was

    not found.` when installing GnuTLS. At this point, I had exhausted my limited
not found.` when installing GnuTLS. At this point, I had exhausted my limited


## 94 changes: 94 additions & 0 deletions gistfile1.txt
@@ -0,0 +1,94 @@

    #Things that didn't work:
#Things that didn't work:


    I started by adding a service to the test
I started by adding a service to the test

    step, using the same Docker image and passing the env vars the test used.
step, using the same Docker image and passing the env vars the test used.


    ```yml
```yml

    name: Tests
name: Tests

        runs-on: ubuntu-latest
    runs-on: ubuntu-latest

        services:
    services:

          mssql:
      mssql:

            image: mcr.microsoft.com/mssql/server:2022-latest
        image: mcr.microsoft.com/mssql/server:2022-latest

            env:
        env:

              MSSQL_SA_PASSWORD: yourStrongPassword1
          MSSQL_SA_PASSWORD: yourStrongPassword1

              ACCEPT_EULA: "Y"
          ACCEPT_EULA: "Y"

            ports:
        ports:

              - 1433:1433
          - 1433:1433

        steps: - name: Checkout code
    steps: - name: Checkout code

        uses: actions/checkout@v3
    uses: actions/checkout@v3


    ....
....

    ```
```


    The test step was already installing FreeTDS, which TinyTDS depends on. When I
The test step was already installing FreeTDS, which TinyTDS depends on. When I

    originally set it up, all the documentation I found pointed me toward [getting
originally set it up, all the documentation I found pointed me toward [getting

    the source and building and installing it](https://github.com/rails-sqlserver/tiny_tds?tab=readme-ov-file#install). I followed advice in documentation
the source and building and installing it](https://github.com/rails-sqlserver/tiny_tds?tab=readme-ov-file#install). I followed advice in documentation

    and ended up installing it like this:
and ended up installing it like this:


    ```yml
```yml

    - name: Install freetds
- name: Install freetds

      run: |
  run: |

        sudo apt-get install -y build-essential wget \
    sudo apt-get install -y build-essential wget \

        && wget http://www.freetds.org/files/stable/freetds-1.1.24.tar.gz \
    && wget http://www.freetds.org/files/stable/freetds-1.1.24.tar.gz \

        && tar -xzf freetds-1.1.24.tar.gz \
    && tar -xzf freetds-1.1.24.tar.gz \

        && cd freetds-1.1.24 \
    && cd freetds-1.1.24 \

        && ./configure --prefix=/usr/local --with-tdsver=7.3 \
    && ./configure --prefix=/usr/local --with-tdsver=7.3 \

        && sudo make \
    && sudo make \

        && sudo make install
    && sudo make install

    ```
```


    Now when I ran specs on CI, I got an error saying that the connection failed. I
Now when I ran specs on CI, I got an error saying that the connection failed. I

    first confirmed the host and port I was using to connect to the local service.
first confirmed the host and port I was using to connect to the local service.

    When I changed either of these, I got a new error message saying that the
When I changed either of these, I got a new error message saying that the

    database server could not be found, so I was confident the host and port were
database server could not be found, so I was confident the host and port were

    correct. After a bunch of googling, I found a [related GitHub
correct. After a bunch of googling, I found a [related GitHub

    issue](https://github.com/rails-sqlserver/tiny_tds/issues/441) which points to a
issue](https://github.com/rails-sqlserver/tiny_tds/issues/441) which points to a

    [problem with the TLS handshake on
[problem with the TLS handshake on

    FreeTDS](https://github.com/FreeTDS/freetds/issues/299). [This
FreeTDS](https://github.com/FreeTDS/freetds/issues/299). [This

    comment](https://github.com/FreeTDS/freetds/issues/299#issuecomment-620729458)
comment](https://github.com/FreeTDS/freetds/issues/299#issuecomment-620729458)

    suggested using GnuTLS instead of OpenSSL for FreeTDS. I added a step to install
suggested using GnuTLS instead of OpenSSL for FreeTDS. I added a step to install

    GnuTLS in the GitHub workflow for running tests:
GnuTLS in the GitHub workflow for running tests:


    ```yml
```yml

    - name: Install gnutls
- name: Install gnutls

     run: |
 run: |

       wget https://www.gnupg.org/ftp/gcrypt/gnutls/v3.6/gnutls-3.6.16.tar.xz \
   wget https://www.gnupg.org/ftp/gcrypt/gnutls/v3.6/gnutls-3.6.16.tar.xz \

       && tar -xf gnutls-3.6.16.tar.xz \
   && tar -xf gnutls-3.6.16.tar.xz \

       && cd gnutls-3.6.16 \
   && cd gnutls-3.6.16 \

       && ./configure --prefix=/usr/local \
   && ./configure --prefix=/usr/local \

       && sudo make \
   && sudo make \

       && sudo make install
   && sudo make install

    ```
```


    This failed because it needed Libnettle 3.4.1. So I added a step to install nettle:
This failed because it needed Libnettle 3.4.1. So I added a step to install nettle:


    ```yml
```yml

    - name: Install nettle
- name: Install nettle

      run: |
  run: |

        wget https://ftp.gnu.org/gnu/nettle/nettle-3.4.1.tar.gz \
    wget https://ftp.gnu.org/gnu/nettle/nettle-3.4.1.tar.gz \

        && tar -xzf nettle-3.4.1.tar.gz \
    && tar -xzf nettle-3.4.1.tar.gz \

        && cd nettle-3.4.1 \
    && cd nettle-3.4.1 \

        && ./configure --prefix=/usr/local --disable-openssl --enable-shared \
    && ./configure --prefix=/usr/local --disable-openssl --enable-shared \

        && sudo make \
    && sudo make \

        && sudo make install
    && sudo make install

    ```
```


    What finally did work:
What finally did work:


    Nettle installed successfully, but I still got the error `Libnettle 3.4.1 was
Nettle installed successfully, but I still got the error `Libnettle 3.4.1 was

    not found.` when installing GnuTLS. At this point, I had exhausted my limited
not found.` when installing GnuTLS. At this point, I had exhausted my limited

    understanding of package management on unix and reached out for help.
understanding of package management on unix and reached out for help.

    [Mike](https://thoughtbot.com/blog/authors/mike-burns) jumped in to help and
[Mike](https://thoughtbot.com/blog/authors/mike-burns) jumped in to help and

    noted that the FreeTDS package on Debian stable is version 1.3.17, and it uses
noted that the FreeTDS package on Debian stable is version 1.3.17, and it uses

    GnuTLS by default. This means that I could replace all the messy wget/tar/make
GnuTLS by default. This means that I could replace all the messy wget/tar/make

    attempts with calls to apt-get:
attempts with calls to apt-get:


    ```yml
```yml

    - name: Install gnutls
- name: Install gnutls

      run: |
  run: |

        sudo apt-get install gnutls-bin
    sudo apt-get install gnutls-bin


    - name: Install freetds
- name: Install freetds

      run: |
  run: |

       sudo apt-get install -y freetds-bin freetds-common freetds-dev libct4 libsybdb5
   sudo apt-get install -y freetds-bin freetds-common freetds-dev libct4 libsybdb5

    ```
```