Linux 下 PHP 5.2.x 连接 SQL Server 数据库 FreeTDS 配置笔记

金山游戏KSG-逍遥网招聘系统工程师

轻量级开源简单队列服务 HTTPSQS 1.3 版本发布

大 | 中 | 小

[

2010-6-25 18:00 | by 张宴 ]

　　CentOS 5.4 Linux 下的 PHP（FastCGI）需要连接相关部门的SQL Server 2000数据库，配置了扩展FreeTDS扩展。

　　1、编译安装FreeTDS

mkdir -p /data0/software/
cd /data0/software/
wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
tar zxvf freetds-stable.tgz
cd freetds-0.82/
./configure --prefix=/usr/local/webserver/freetds --with-tdsver=8.0 --enable-msdblib
make && make install
cd ../

echo "/usr/local/webserver/freetds/lib/" > /etc/ld.so.conf.d/freetds.conf
ln -s /usr/local/webserver/freetds/lib/libsybdb.so.5.0.0 /usr/local/webserver/freetds/lib/libsybdb.so.4
/sbin/ldconfig

rm -f /usr/local/webserver/freetds/etc/freetds.conf
vi /usr/local/webserver/freetds/etc/freetds.conf

　　输入以下内容：

引用

[global]
        # TDS protocol version
;       tds version = 4.2

        # Whether to write a TDSDUMP file for diagnostic purposes
        # (setting this to /tmp is insecure on a multi-user system)
;       dump file = /tmp/freetds.log
;       debug flags = 0xffff

        # Command and connection timeouts
;       timeout = 10
;       connect timeout = 10

        # If you get out-of-memory errors, it may mean that your client
        # is trying to allocate a huge buffer for a TEXT field.
        # Try setting 'text size' to a more reasonable limit
        text size = 64512

        host = mssql.yourdomain.com
        port = 1433
        tds version = 8.0
        client charset = UTF-8

　　2、编译安装PHP自带MSSQL扩展
　　进入本地已存在的php-5.2.XX源码包目录：

cd /data0/software/php-5.2.XX/ext/mssql/
/usr/local/webserver/php/bin/phpize
./configure --with-php-config=/usr/local/webserver/php/bin/php-config --with-mssql=/usr/local/webserver/freetds/
make && make install

　　3、在php.ini配置文件中增加mssql.so

vi /usr/local/webserver/php/etc/php.ini

　　增加一行：

引用

extension = "mssql.so"

　　4、重启PHP FastCGI

/usr/local/webserver/php/sbin/php-fpm restart

　　5、测试文件（test_mssql.php）：

技术大类 » PHP/JS/Shell | 评论(30) | 引用(0) | 阅读(13225)

juner

2010-12-26 16:14

perfect,非常感谢

moro

2011-10-12 16:16

张SIR 你好，请问一下 FREETDS 怎样支持GBK的编码

louis vuitton uk

2011-11-22 17:12

This louis vuitton uk for sale belongs to the sounding just what are termed as Louis Vuitton vintage best sellers, many other products and services for the reason that range appearing companies.You will easily notice the unfold zippers of this coach outlet store online. That is the decoration. There are some inside pockets for you as well. They are easy to match your clothes and to carry.Let us inspire your inner beauty with fine christian louboutin sale. Purse the elegance in bridal wedding. Enjoy the fashion.

armani watches

2011-11-23 10:13

If you are looking for armani Bags, our armani watches Handbags Canada outlet store is your first choice. We promise Original Packing and Best Discount,3-5 Workdays To Your Door!If you buy bags and purses of the latest new designs from the louis vuitton outlet now, you can enjoy special discounts. What else are you waiting for?After you choose the right kind of plants and the size pot for the plant.

wedding520

2011-12-27 15:53

ワイドネックライン、'V'ネックやボートネックラインは、一般にキャップスリーブとドレスのために選ばれている。ボートスタイルのネックラインと幅広いネックラインのためには、オフショルダーのキャップスリーブを追加することができます。オフショルダーのウエディングドレスは、数年以来、結婚式の摩耗で人気のパターンになっても流行で、今日でもあります。カラードレス格安.のこのスタイルで素敵に見える模様のオフショルダーの袖に行く同じシースのサテンからステッチ/オフショルダーのキャップスリーブの上に薄いと飾ったときに裾フレアのビットとシースのサテンのイブニングドレスとスパゲッティネックラインがすごい見えます。

freetds

2012-2-23 17:38

张大哥，我这边开发还需要 dblib 可是这个在这里再添加就会出现 --with-pdo-dblib=/usr/local/webserver/freetds/

configure: error: Cannot find FreeTDS in known installation directories。。

能帮忙解决下疑问嘛

fly

2012-3-29 10:14

http://webvk.com

jevonszmx

2012-4-24 23:07

我们网站一般使用freetds+unixODBC架构，效果也非常完美。

Hogan

2012-5-10 17:51

Mentre youre gestione di problemi complessi tra cui PAYE insieme con le imprese del prelievo, l'idea è sicuramente intelligente per acquisire specializzata fare qualcosa di sicuro si sta usando la vostra organizzazione. Self-employmentSelf lavoratori uomini e donne potrebbe anche fare pieno uso Hogan dei ragionieri in tutta Stansted, quando hanno l'effetto della loro prelievo unico e sì, è spesso sconcertante. Stare di fronte a una buona varietà prelievo può essere schiacciante, di conseguenza, il

hogan280

2012-5-10 18:05

Non tanto è stato fatto perché le accuse della ragazza giovane non si pensava in primo luogo. Né come la segnalazione di Hogan questo caso potrebbe portare ad un simile tipo di stereotipo e mito attorno alla violenza sessuale.

分页： 2/2