how to add extension sqlsrv & pdo_sqlsrv to php (nginx)

xXxlazharxXx

hello
how to add extension sqlsrv & pdo_sqlsrv to php (nginx)
thx 😀

aaPanel_Jose

xXxlazharxXx

Here take php73 as an example

Install the driver

yum install msodbcsql mssql-tools unixODBC-devel

Download pdo_sqlsrv extension package

wget http://pecl.php.net/get/pdo_sqlsrv-5.3.0.tgz

Unzip

tar -zxvf pdo_sqlsrv-5.3.0.tgz

Enter the decompression directory

cd pdo_sqlsrv-5.3.0

Excuting an order

/www/server/php/73/bin/phpize
./configure --with-php-config=/www/server/php/73/bin/php-config

Compile and install

make && make install

Update php.ini

Modify /www/server/php/73/etc/php.ini to find: extension = then the last extension add extension = "pdo_sqlsrv.so"

aaP_andresberry01

aaPanel_Jose
While following your instruction, I got this error:

configure: error: invalid variable name: `'

How to fix this?

xXxlazharxXx

didn't work, I have Ubuntu 18.04
i tried this code from microsoft
sudo pecl install sqlsrv sudo pecl install pdo_sqlsrv sudo su printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.3/mods-available/sqlsrv.ini printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.3/mods-available/pdo_sqlsrv.ini exit sudo phpenmod -v 7.3 sqlsrv pdo_sqlsrv
I even changed /etc/php/7.3/mods-available/ to /www/server/php/73

aaP_farhan.003

xXxlazharxXx pecl is not included in aapanel, so you have to folow above comment

aaP_tony

This sort of work, you need to enable microsoft's repo first otherwise you won't be able to install msodbcsql. For CentOS7 it is:

curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo

And after you are done, you will have to use PDO instead of sqlsrv to connect.

aaPanel_Kern

aaP_andresberry01
Hello, please take a screenshot or provide more details.

aaP_andresberry01

aaPanel_Kern
Look like this..

aaPanel_Kern

aaP_andresberry01
Replace it with this: there is an extra space above
./configure --with-php-config=/www/server/php/80/bin/php-config

aaP_andresberry01

aaPanel_Kern
It works... Thank you 😄

Ultraman

Found working tutorial https://idnetter.com/cara-install-extension-sqlsrv-dan-pdo_sqlsrv-php-7-4-di-aapanel/

Bumb1ebe

Ultraman Hey, i am getting this error https://prnt.sc/nTp4vp-K0SzL . Could you help me please?

Ultraman

you may have missed a step in the tutorial Bumb1ebe. So, reinstall PHP and try again to follow the tutorial.

aaP_webat66013

Please share steps for how to add sqlsrv or mssql extension add in php7.0 version.

OS:- 20.04.4 LTS (Focal Fossa)
aaPanelLinux panel used.

poetra4522

what extension should I install?
Thanks

aaPanel_Kern

Hello, please install the extension according to your website program

poetra4522