How to properly install SQLSRV on multiple versions of PHP 7+ ?

[iemand]

Hello,

I've read tons of articles, stackoverflow questions and posts on this forum already but haven't found a single solution that works.
I need to connect to a Microsoft SQL server using the sqlsrv extension: https://www.php.net/manual/en/book.sqlsrv.php to establisch a connection and run queries.

Downgrading PHP is not an option. Alternative methods can be used. At this point I just want it to work.

How do I install SQLSRV (or any other extension) to safely connect to a Microsoft SQL server?

 

[zEitEr]

Hello,

Install SQLSRV ODBC drivers for PHP from the Official repository of Microsoft for your OS version

Install the Microsoft ODBC driver for SQL Server (Linux) - ODBC Driver for SQL Server

Learn how to install the Microsoft ODBC Driver for SQL Server on Linux clients to enable database connectivity.

docs.microsoft.com

and then use pecl to build PHP extensions: pdo_sqlsrv and sqlsrv.

 

[iemand]

Hi @zEitEr, thanks for the reply.
As far as I understand it PHP is integrated within directadmin and we use custombuilds to compile it all. Right?

pecl doesn't come with directadmin out-of-the-box as far as I know (pecl: command not found errors pop up all the time).

I use CentOS 7 and the latest version of directadmin.

I also tried to build --with-mssql and --with-sqlsrv but those sadly didn't result in anything.

 

[zEitEr]

# ls -1 /usr/local/php*/bin/pecl
/usr/local/php52/bin/pecl
/usr/local/php53/bin/pecl
/usr/local/php54/bin/pecl
/usr/local/php55/bin/pecl
/usr/local/php56/bin/pecl
/usr/local/php70/bin/pecl
/usr/local/php71/bin/pecl
/usr/local/php72/bin/pecl
/usr/local/php73/bin/pecl
/usr/local/php74/bin/pecl

 

[iemand]

This is the same error I ran in to before. I know its because the folder has the noexec flag but as a newby to Linux/CentOS I don't want to mess around without knowing If i'm doing the right thing.

Can I remove the noexec flag from the tmp/pear/temp folder? If so, how?
Or is there another way to install this successfully?

Thanks for the replies!

 

[zEitEr]

You can install PECL extensions using php-extension.sh from https://github.com/poralix/directadmin-utils/tree/master/php

Yes, you can remove noexec flag temporary. Search internet and these forums for exact commands.

 

[iemand]

Alright so I got sqlsrv and pdo_sqlsrv installed but now run in to the following error:


I changed php_lda.dll to the .so extension in php.ini. Same error happens when it has the .dll extension.Do I need to manually install this?
Doesn't this come with directadmin itself?

 

[zEitEr]

.dll extension is only for Windows OS.

 

[iemand]

I understand that. When i first opened the php.ini it had the .dll extension. I changed it to .so but it isn't available (see console log).
I now tried installing it through pecl and yum but php-idap doesn't exists. Would it be safe to remove that extension?

 

[zEitEr]

The extension is not loaded, so you can remove only a directive to load it.