Skip to content

Instantly share code, notes, and snippets.

@asiraky

asiraky/gist:4ea5136e54c8df2de3fb6689f0a5ce18

Created March 24, 2021 07:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save asiraky/4ea5136e54c8df2de3fb6689f0a5ce18 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save asiraky/4ea5136e54c8df2de3fb6689f0a5ce18 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. asiraky created this gist Mar 24, 2021.
    21 changes: 21 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,21 @@
    #run through the steps detailed here to install the odbc drivers for Ubuntu 20
    https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15#ubuntu17

    #then force pecl to use 7.2
    sudo pecl -d php_suffix=7.2 install sqlsrv-5.3.0
    sudo pecl -d php_suffix=7.2 install pdo_sqlsrv-5.3.0

    sudo bash -c 'echo "extension=sqlsrv.so" > /etc/php/7.2/mods-available/sqlsrv.ini'
    sudo bash -c 'echo "extension=pdo_sqlsrv.so" > /etc/php/7.2/mods-available/pdo_sqlsrv.ini'

    # Link new ini to fpm
    sudo bash -c 'ln -s /etc/php/7.2/mods-available/sqlsrv.ini /etc/php/7.2/fpm/conf.d/20-sqlsrv.ini'
    sudo bash -c 'ln -s /etc/php/7.2/mods-available/pdo_sqlsrv.ini /etc/php/7.2/fpm/conf.d/30-pdo_sqlsrv.ini'
    # Link new ini to cli
    sudo bash -c 'ln -s /etc/php/7.2/mods-available/sqlsrv.ini /etc/php/7.2/cli/conf.d/20-sqlsrv.ini'
    sudo bash -c 'ln -s /etc/php/7.2/mods-available/pdo_sqlsrv.ini /etc/php/7.2/cli/conf.d/30-pdo_sqlsrv.ini'
    sudo service php7.2-fpm restart

    sudo phpenmod -v 7.3 sqlsrv pdo_sqlsrv

    sudo /etc/init.d/php7.2-fpm restart