install pdo_dblib on php 7.4.30

PTYNETWORK

Hello how can I install pdo_dblib on php 7.4.30 ?

aaPanel_Kern

PTYNETWORK
Hello, this extension tries to install manually

cd /tmp
wget http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
tar zxvf freetds-stable.tgz
cd freetds-0.91
./configure --prefix=/usr/local/freetds --with-tdsver=8.0 --enable-msdblib --enable-dbmfix
make && make install


cd /www/server/php/74/src/ext/pdo_dblib/

/www/server/php/74/bin/phpize

./configure --with-php-config=/www/server/php/74/bin/php-config --with-pdo-dblib=/usr/local/freetds

make && make install

echo 'extension=pdo_dblib.so' >> /www/server/php/74/etc/php.ini
echo 'extension=pdo_dblib.so' >> /www/server/php/74/etc/php-cli.ini
/etc/init.d/php-fpm-74 restart

PTYNETWORK

thank millions, I could install this extension

PTYNETWORK

I´ve got installed, however the websites is not doing connection with the database. I don´t have any issue with another hosting platform.

aaPanel_Kern

PTYNETWORK
Can the website server connect to port 1433 of the database?
telnet ip 1433

PTYNETWORK

yes the vps where installed the sqlserver with the database, the port is enabled. The website server under aapanel is online but is not working, but if I test under another platform I don´t have that issue of connection.

Example I test on this lab:
This is not working (Local Network)
VPS1: Website Server (aapanel) ----> connect with -----> VPS2: Sqlserver + DataBase (Port 1433 Enabled)

This is not working (VPS1 public connection VPS_PUBLIC)
VPS1: Website Server (aapanel) ----> connect with -----> VPS_PUBLIC: Sqlserver + DataBase (Port 1433 Enabled)

This is working fine
Website Server (another platform hosting working on centos) -----> VPS_PUBLIC: Sqlserver + DataBase (Port 1433 Enabled)

This is working fine
Website Server (another platform hosting working on centos) -----> VP1: Sqlserver + DataBase (Port 1433 Enabled)

So I could consider something is missed on the aapanel with the pdo_dblib that is not working properly.

PTYNETWORK

I could solved on this way.

/usr/local/freetds/etc/freetds.con
Uncommented TDS protocol version and updated.

tds version = 8.0
Added mssql below examples.

[mssql]
host =
Port = 1433
tds version = 8.0

Bumb1ebe

PTYNETWORK

I have same issue, followed your guide did not help.

aaPanel_Kern

Bumb1ebe

https://prnt.sc/3wDwMWncNOju

aaPanel_Kern

Bumb1ebe
Is your php 7.4? If not, please replace it according to the actual php path

sevin

I have the same problem I need to install pdo_dblib in php 7.4 and I don't think how I want to install the webengine and I can't either

PTYNETWORK

sevin You have to follow the step given by aaPanel_Kern .

I have installed the webengine without issues.

aaPanel_Kern

Hello, if there is no extension provided by the panel, you need to install it manually

sevin

PTYNETWORK
how did you resolve it