Advance

How to Install MSSQL PHP Extension on WHM/cPanel Linux Server

Richard 6 Min Read
How to Install MSSQL PHP Extension on WHM-cPanel Linux Server

Tutorial Install MSSQL PHP Extension on WHM/cPanel Linux Server.

For enabling MSSQL PHP extension we can’t use EasyApache. We need to install FreeTDS and configure it on the server. Currently, there are no available scripts for direct downloading MSSQL, there is no way to enable MSSQL via cPanel itself since this is not part of EasyApache. You can always follow the steps noted here to try to manual installation of MSSQL.

Install MSSQL PHP Extension on Linux Server

Before the MSSQL installation, you need to install below modules on the server :

  • 1) unixODBC
  • 2) freeTDS
  • 3) mssql.so
Recommended Article: How to use Fail2ban to secure Linux Server

Install MSSQL using the following steps :

1) Install unixODBC package using the below command.

wget http://www.unixodbc.org/unixODBC-2.2.14-p2.tar.gz  tar -xvf unixODBC-2.2.12.tar.gz  cd unixODBC-2.2.12  ./configure -prefix=/usr/local -enable-gui=no  make  make install  

2) Install freeTDS package using the below command.

Download from ftp://ftp.freetds.org/pub/freetds/old/0.82/freetds-0.82.tar.gz

wget ftp://ftp.freetds.org/pub/freetds/old/0.82/freetds-0.82.tar.gz  tar -xvf freetds-0.82.tar.gz  ./configure -with-tdsver=8.0 -with-unixODBC=/usr/local  make  make install  

3) Configure FreeTDS

FreeTDS is a set of library functions that combined with the UnixODBC driver, allows your Linux server and applications to support MSSQL server.

Locate the freetds.conf configuration file in the server, the default location will be in /usr/local/etc/freetds.conf

[MSHOSTNAME]  host = MSHOSTNAME  port = 1433  tds version = 8.0  

4) In cPanel server most of the extensions files are located on /home/cpeasyapache/src/php-x.x.x/ext. So navigate to that folder and do the below command to install MSSQL.

cd /home/cpeasyapache/src/php-x.x.x/ext/mssql  phpize  ./configure  make  make install  

The above commands will install MSSQL on the server and a copy of mssql.so in the installed extensions directory. Check and make sure that mssql.so is there and add the following to php.ini using the below command.

php -i | grep php.ini  

Configuration File (php.ini) Path => /opt/cpanel/ea-php56/root/etc

Loaded Configuration File => /opt/cpanel/ea-php56/root/etc/php.ini

vi /opt/cpanel/ea-php56/root/etc/php.ini    extension=”mssql.so”  

Restart httpd for enable the changes:

service httpd restart

Check the installed modules using the below command:

php -m | grep mssql  mssql  
View More Posts
Richard
Eldernode Writer
We Are Waiting for your valuable comments and you can be sure that it will be answered in the shortest possible time.

Leave Your Comment

Your email address will not be published.

We are by your side every step of the way

Think about developing your online business; We will protect it compassionately

We are by your side every step of the way

+18054214518

7 days a week, 24 hours a day