PHP MSSQL extension with cPanel

[Xtrm2Matt]

Hi,

I've been in contact with support a bit regarding this, and also looked on the forum but having a slight problem.

I followed the following instructions (http://forums.cpanel.net/showthread....hlight=MSSQL):

1-. Download freetds -> www.freetds.org

2-. tar -zxvf freetds-stable-tgz

3-. cd freetds-*

4-. ./configure --prefix=/usr/local/freetds --with-tdsver=8.0 --enable-msdblib --enable-dbmfix --with-gnu-ld

5-. make

6-. make install

7-. /usr/local/freetds/bin/tsql -S <ip of the server> -U <User SQL>

8-. Add the next text in freetds.conf ( /usr/local/freetds/etc )
[TDS]
host = <ip of the Server with Sql>
port = 1433
tds version = 8.0

9-. Add the following line in the file /etc/ld.so.conf and run ldconfig -v:
/usr/local/freetds/lib

10- Recompile PHP with --with-mssql=/usr/local/freetds flag.

I added '--with-mssql=/usr/local/freetds' to /var/cpanel/easy/apache/rawopts/all_php5

I'm trying to re-build Apache/PHP with above, but it's erroring on the following part:

checking for MSSQL support via FreeTDS... yes
configure: error: Directory /usr/local/freetds is not a FreeTDS installation
directory

A 'whereis freetds' shows that the install dir is right:

[root@web rawopts]# whereis freetds
freetds: /usr/local/etc/freetds.conf /usr/local/freetds

Anyone have any ideas? I'm quite a newbie to Linux, and just followed the instructions above.

Cheers

[Xtrm2Matt]

I've overcome this by installing CentOS 5. Runs perfect now.

[wildbrn]

all is ok but, this comand

10- Recompile PHP with --with-mssql=/usr/local/freetds flag.

who I recompile?

[Xtrm2Matt]

all is ok but, this comand

10- Recompile PHP with --with-mssql=/usr/local/freetds flag.

who I recompile?

Log into WHM, and just re-compile Apache. It'll read from the /var/cpanel/easy/apache/rawopts/all_php5 file that you want custom build parameters

[FTNET]

Same error:

checking for MSSQL support via FreeTDS... yes
configure: error: Directory /usr/local/freetds is not a FreeTDS installation directory

[FTNET]

Problem FIXED!

[Gibberish]

Can you please state how you fixed it?

[Aldweb]

Same error:

checking for MSSQL support via FreeTDS... yes
configure: error: Directory /usr/local/freetds is not a FreeTDS installation directory

How to fix problem?

Thanks

[furtif]

Hey

A little question:

[TDS]
host = <ip of the Server with Sql>

"ip of the server with sql" = ip of MS SQL server ?

I have a lot of account on cpanel/whm server, and i try to install php_msssql for one account only. If i add this file, all account can acces to MS SQL server ?

Thanks you and sorry for my english

[david510]

It should be the ip of the MSSQL server