Connecting to MSSQL external server in 2019

Operating System & Version
CentOS 7.7
cPanel & WHM Version
v84.0.21

AlexNuta

Registered
Feb 6, 2020
2
0
1
Montreal, Canada
cPanel Access Level
Root Administrator
Hi folks,

I have a fresh Cpanel 84.0.21 over CentOS 7.7 installed on a VPS, and I'd very much like to connect to an existing Windows-based Microsoft SQL server.
I've seen that people have successfully done this, but trying to follow and piece together information, and many many hours in, I still don't have a working solution.
Earlier suggestions from 2012 have not worked with the current version of PHP (7.3)
This is as close as I have gotten:

I have seen this thread suggested as late as 2017: https://features.cpanel.net/topic/easyapache-4-pdo_dblib-mssql-support

I downloaded the Microsoft driver from here: Download Microsoft® SQL Server® ODBC Driver 1.0 for Linux from Official Microsoft Download Center
Following the instructions there I ran ./build_dm.sh
The script downloads the older 2.3.0 version of the unixODBC driver (current version 2.3.7), then unpacks and tries to configure it.
The script fails there, with :

Code:
Configuring unixODBC 2.3.0 DriverManager ... FAILED
In the installation log file I have:

Code:
./build_dm.sh: line 188: ./configure: Permission denied
Am I correct in presuming the problem is that the script doesn't have proper permissions in the /tmp/unixODBC.8750.2847.18216 (directory changes with each attempt) subdirectory where it has unpacked the files? I am running the commands as root.
Seeing as how the script unpacks these files, how would I even go about making sure the files are thereafter editable since I don't control their unpacking directly?

I am not an experienced CentOS administrator, and I'm not sure where to go from here.
Is there a relatively current howto (later than 2017) that could help me figure out how to do this?

I realize strictly speaking this is not a Cpanel issue, but as I'm trying to work with EasyApache4 I'm hoping someone can help.

It would be great if there was a step-by-step howto to get this done under CentOS/WHM/Cpanel/EasyApache.
 
Last edited:

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,255
313
Houston

AlexNuta

Registered
Feb 6, 2020
2
0
1
Montreal, Canada
cPanel Access Level
Root Administrator
Thanks for the speedy response! I appreciate that.
I saw this page before, but a CentOS process was not listed, so I assumed they were not available for it, or not compatible with it.
As I understand it, I may be able to use the Red Hat process?

Thanks also for the information on FreeTDS. I will read up on that.