connecting to windows sql server from linux server

 1.install freetds


To manually install `freetds-0.63.tar.gz`, follow these steps:


 1. Extract the Archive

Navigate to the directory containing `freetds-0.63.tar.gz` and extract it:

bash

cd /path/to/directory

tar -xzf freetds-0.63.tar.gz

cd freetds-0.63



 2. Configure the Installation

Configure FreeTDS with a prefix specifying the installation directory (e.g., `/usr/local/freetds`). This directory is where PHP will expect FreeTDS to be installed:

bash

./configure --prefix=/usr/local/freetds



If there are specific options or database configurations you need, add them during this step (for example, to enable certain database support).


 3. Compile and Install FreeTDS

Run the following commands to compile and install FreeTDS:

bash

make

make install



 4. Verify the Installation

Ensure FreeTDS is installed in the specified directory:

bash

ls /usr/local/freetds

[root@server-157-173-195-211 freetds-0.63]# ls /usr/local/freetds

bin etc include lib man share


sudo yum install freetds-devel unixODBC unixODBC-devel

run above cmd else will encounter error

configure: error: Don't know how to define struct flock on this system, set --enable-opcache=no


 5. Rebuild PHP with FreeTDS Support

Now that FreeTDS is installed, you can attempt to rebuild PHP.


cd /usr/local/directadmin/custombuild


./build used_configs | grep configure.php


 

PHP (default) configuration file: /usr/local/directadmin/custombuild/configure/php/configure.php56

phpMyAdmin configuration file: /usr/local/directadmin/custombuild/configure/phpmyadmin/config.inc.php


/usr/local/directadmin/custombuild/configure/php


check above location for custom PHP config with PHP versions


 --enable-intl \

        --with-mssql=/usr/local/freetds



cd /usr/local/directadmin/custombuild

./build php n

Check if MS Sql is intalled.

php -m|grep mssql
mssql


If you're referring to the legacy MSSQL module (for connecting PHP to Microsoft SQL Server), note that the MSSQL extension for PHP was deprecated and removed in PHP 7+. The modern equivalent for Microsoft SQL Server is the sqlsrv extension, which is the recommended method for connecting to SQL Server from PHP.



sudo apt-get install unixodbc unixodbc-dev
yum install unixODBC-devel

cd /usr/local/directadmin/scripts/custom
wget https://raw.githubusercontent.com/poralix/directadmin-utils/master/php/php-extension.sh -O php-extension.sh
chmod 750 php-extension.sh
./php-extension.sh install sqlsrv
./php-extension.sh install pdo_sqlsrv


root@server-192-227-112-104:/usr/local/directadmin/scripts/custom# php -m | grep sqlsrv
pdo_sqlsrv
sqlsrv



vi /usr/local/freetds/etc/freetds.conf


[myserver]

        host = 115.112.240.105

        # host = ntmachine.domain.com

        port = 1433

        tds version = 7.0


[myserver3]

        host = 192.227.108.64

        port = 1433

        tds version = 7.0


[myserver2]

        host = 192.227.65.65

        port = 1433

        tds version = 7.0


[myserver1]

        host = 154.27.75.96

        port = 1433

        tds version = 7.0




      'host' => 'localhost',

      'user' => 'rcautomat_in',

      'password' => 'automation',

      'database' => 'rcautomat_in',

      'port' => 3306,

Comments

Post a Comment

Popular posts from this blog

cpanel exam CPSP Answers

 Which of the following options best describes the role of Shared Hosting on a web server? Providing hosting for a single website owned by different people on multiple servers. Providing hosting for a single website owned by one person on one server. Providing hosting for multiple websites owned by different people on one server. Providing hosting for multiple websites owned by one person on one server. 3 Which of the following capabilities can a cPanel account user perform easily from within the cPanel account interface without the aid of a system administrator? File and configuration management. Relocating the physical server. Upgrading server hardware and equipment. Installing new database software. 1 File and configuration management. Which of the following options best describes a core benefit to using cPanel & WHM, as a web hosting provider operating on a cPanel & WHM environment? cPanel users are able to create new virtualization resources to help host their web appl...
Read more

How to install zimbra collaboration suite 8.8.11 on CentOS 7

Check system requirements  https://wiki.zimbra.com/wiki/Zimbra_Releases/8.7.0/Single_Server_Installation#System_Requirements prerequisites Before we get started, here are a few things that are required before we proceed with the installation. A clean installation of Centos 7 A Fully Qualified Domain (FQDN) for your server(Example mail.geekybum.com) An external DNS server with both A and MX records for your server to point to your Zimbra mail server IP Address A static IP Address assigned to network interface. Step 1: Root login to server through SSH Step 2: Install required packages for zimbra coloboration suite installation yum -y install unzip net-tools sysstat openssh-clients perl-core libaio nmap-ncat libstdc++.so Initial server setup To get started we need to configure a hostname for our server and a static IP address. vi /etc/hosts 135.125.30.56 mail.geekybum.com mail Replace the system hostname and FQDN values accordingly in order to match your ow...
Read more

awstats installation

Set Up AWStats for Nginx on Ubuntu sudo apt-get install awstats add access log file to generate stats using this server { # ... all your other config ... access_log /var/log/nginx/yourdomain.com.access.log ; # ... all your other config ... } /etc/nginx/sites-available vi awstats.parleproducts.com.conf cd /etc/awstats/ vi awstats.parleproducts.com.conf #path to your nginx log file LogFile="/var/log/nginx/parleproducts.com.access.log" # Domain of your vhost SiteDomain="parleproducts.com" # Directory where to store the awstats data DirData="/var/lib/awstats/" # Other domains/subdomain you want included from your logs, for example the www subdomain HostAliases="www.parleproducts.com" # If you customized your log format above add this line: LogFormat = ""%host %other %logname %time1 %methodurl %code %bytesd %refererquot %uaquot"" # If you did not, uncomment and use this line: #...
Read more