Skip to content

Instantly share code, notes, and snippets.

@boynoiz
Created June 5, 2017 05:20
Show Gist options
  • Save boynoiz/374f47d7fa1bc06e09b86ef638de45ab to your computer and use it in GitHub Desktop.
Save boynoiz/374f47d7fa1bc06e09b86ef638de45ab to your computer and use it in GitHub Desktop.
This is a part of PDO MSSQL Driver setup in docker
..........
# Add PHP MSSQL Driver Extension
RUN curl ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.1.tar.gz --create-dirs -o /usr/src/phpmssql/unixODBC-2.3.1.tar.gz
RUN tar -zxf /usr/src/phpmssql/unixODBC-2.3.1.tar.gz -C /usr/src/phpmssql/
RUN sudo -i export CPPFLAGS="-DSIZEOF_LONG_INT=8"
RUN echo "Configuring the unixODBC 2.3.1 Driver Manager"
RUN cd /usr/src/phpmssql/unixODBC-2.3.1 && ./configure --prefix=/usr --libdir=/usr/lib64 --sysconfdir=/etc --disable-gui --disable-drivers --enable-iconv --with-iconv-char-enc=UTF8 --with-iconv-ucode-enc=UTF16LE
RUN echo "Building and Installing the unixODBC 2.3.1 Driver Manager"
RUN cd /usr/src/phpmssql/unixODBC-2.3.1 && sudo make && sudo make install
RUN echo "Downloading the Microsoft ODBC Driver 13 for SQL Server"
RUN curl "https://meetsstorenew.blob.core.windows.net/contianerhd/Ubuntu%2013.0%20Tar/msodbcsql-13.0.0.0.tar.gz?st=2016-10-18T17%3A29%3A00Z&se=2022-10-19T17%3A29%3A00Z&sp=rl&sv=2015-04-05&sr=b&sig=cDwPfrouVeIQf0vi%2BnKt%2BzX8Z8caIYvRCmicDL5oknY%3D" --create-dirs -o /usr/src/phpmssql/msodbcsql-13.0.0.0.tar.gz
RUN tar -zxf /usr/src/phpmssql/msodbcsql-13.0.0.0.tar.gz -C /usr/src/phpmssql/
RUN sudo ldd /usr/src/phpmssql/msodbcsql-13.0.0.0/lib64/libmsodbcsql-13.0.so.0.0
RUN sudo echo "/usr/lib64" >> /etc/ld.so.conf
RUN sudo ldconfig
RUN echo "Installing the Microsoft ODBC Driver 13 for SQL Server"
RUN chmod +x /usr/src/phpmssql/msodbcsql-13.0.0.0/install.sh
RUN cd /usr/src/phpmssql/msodbcsql-13.0.0.0 && ./install.sh install --force --accept-license
RUN pecl install sqlsrv-4.1.8preview && pecl install pdo_sqlsrv-4.1.8preview
RUN touch /etc/php/7.1/mods-available/sqlsrv.ini && echo "extension=sqlsrv.so" > /etc/php/7.1/mods-available/sqlsrv.ini
RUN touch /etc/php/7.1/mods-available/pdo_sqlsrv.ini && echo "extension=pdo_sqlsrv.so" > /etc/php/7.1/mods-available/pdo_sqlsrv.ini
RUN phpenmod pdo_sqlsrv sqlsrv
RUN echo "Cleaning up"
RUN cd / && rm -rf /usr/src/phpmssql
..........
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment