首页 > 编程 > PHP > 正文

centos6.4下安装freetds使php支持mssql

2019-11-15 01:29:09
字体:
来源:转载
供稿:网友
centos6.4下安装freetds使php支持mssql

centos版本:6.4

php版本5.3.17

没有安装之前的情况:nginx+php+MySQL+FPM-FCGI

接下来安装步骤如下:

1、打开http://www.freetds.org/,进入到http://www.freetds.org/software.html页面.下载FreeTDS-stable.tgz.

也可以直接 wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-stable.tgz.

安装很简单。步骤如下:

1.1、进入到你下载的目录然后解压。tar -zxvf freetds-stable.tgz

1.2、cd freetds-0.91 (我目前下载的版本是0.91)

1.3、编译: ./configure --PRefix=/usr/local/freetds --with-tdsver=7.1 --enable-msdblib

主要参数说明:--with-tdsver设置FreeTDS的版本,我这里设置了7.1是为了能连接SQL2005

--enable-msdblib是是否允许Microsoft数据库函数库,这里为允许;

1.4、make

1.5、make install

2、安装好之后,进行一下测试:

2.1、cd /usr/local/freetds/bin

2.2、./tsql -C

2.3、如果安装成功,则显示:

2.4、配置freetds.conf

2.5、打开freetds.conf, vi /usr/local/freetds/etc/freetds.conf

2.6、在A typical Microsoft server 下面添加我们要连接数据库的一些信息

[mssql_info]

host = 192.168.1.2

port = 1433

tds version = 7.0

3、由于之前没有把mssql的扩展编译进来。所以接下来还需要动态编译一下。我们这里利用phpize来实现。

3.1、解压php-5.3.17.tar.gz的源包。

3.2、进入php/ext/mssql

3.3、执行/usr/local/php/bin/phpize

3.4、./configure --with-php-config=/usr/local/bin/php-config --with-mssql=/usr/local/freetds

3.5、make

3.6、make install

3.7、生成module目录中提取mssql.so复制到/usr/local/php/lib/php/extensions/中

3.8、.配置php.ini中extension_dir='/usr/local/php/lib/php/extensions/'

3.9、添加一行extension=mssql.so;

3.10、重启nginx.

最后检查是否正常:

ip8p3XrmsMkVRFEVRFHW92u1KFN/WVotvhTN9w10le97yuMl+Knuo75OiKIqiKIq6UrU+ieJb+ZTiZOStvLS8sYVNdlV6PpVv8ztSFEVRFEVRl6zW/8odRVEURVEURR2waIspiqIoiqIoiraYoiiKoiiKomiLKYqiKIqiKOobbTFFURRFURRFfXtHW/zXX3/913//z18AAADAqby+LR4ANMF004YjDrTEjNOGthg4MaabNhxxoCVmnDa0xcCJMd204YgDLTHjtKEtBk6M6aYNRxxoiRmnDW0xcGJMN2044kBLzDhtFLXFxhjxdn3jxh0CuzjsdMObHOSIE6dQ4iAzDs20aov7zhpjnJ83eBd/L44f2a6P75Zu7jtb2dUUuPlXcdh4I1Hano8BWnoksr37XpsmOIXaES/G42L5P6C0vZy+I+IUqtAWa9OyLbbWztk75nfpRdq74Gfe3W/2nY02z5G91haPzObljeSnpe3A7rZHdv9p7Wfa4uB0Skd8Uzz2nRW3B4mb7ifvi4dhIE6hBm2xNi3bYtd1U1/snXXOGueTltY7Y7tebnOzrXOUV9ticR1i+7fJ8ka424d+0cA7bI7svvvBUvEVFI745ngUty+3xwguPjpxCm1oi7Vp2hb7vrO268clCD8FsXfhmsW0KctmofedEnzDarEYx6vLGPmACvGxgLfaGtk/nfmgK76CWsBGm0rxKGxfbm5+5404hRLFjPX+q/ItTqttWzyMfbF30ZLw3BcHDXJwdluW3LNp3WPzucVJQFdyvL68UY9pchzNbGyL/Yftfr37uaCFR9piMR6n78Vzi1cWi4eBOIUypYz9cuZm3L0V9u5mzG9WHi6hcVs89J211tquD8O6durEvHD87GqxmN2lHE+2i0G/Mc2BBsTp1n9a892YH1N/86uzP1Z6HZzFO1aLx89+jG/k1T4JTZxCn/qHXG/GfY1fGz4lvFXrtnjJ3ySUrXNWXKaI7vnEucWj1UROljEqyxv5Twl07KUc2X33w7ifwzAM/acdb+AC3nJu8fLNhuVi4hSarLwjR098Oc3bYnlL+AHp+NPPcxv97JUo6omcjAzvIm4Xx4uPWHg6wCtVIrv/tObDc122i/nzK1EIp6VVYjZukolTaMNqsTYHaYvD04qH6PKb8dJFeDpc6QKc+ZuAYhDnURuGeynHK8Lx5DjaqEX2r85+d/6n47psV/Ke6xZviNkJcQpVyh+5c/G5xXTGF3GQf+Uu7opXbfu4dCiP2qGwXDF/zTNaHA/sqD7d/Icx3/mw3aUc4XJRxCn0KH/kLu6DveMjd9dwiLb48S53Wc9YvV8exPWli2S7eK98DLCLlenGddkuZ9+2mDiFNkf4iyhaOkRbDOA5TDdtOOJAS8w4bWiLgRNjumnDEQdaYsZpQ1sMnBjTTRuOONASM04b2mLgxJhu2nDEgZaYcdrQFgMnxnTThiMOtMSM0+YtbTEAAABwOq9vi/fu9QEtmG7acMSBlphx2tAWAyfGdNOGIw60xIzThrYYODGmmzbjEb8ZQ1HUNWrvUEGEthg4MaabNnNbvPcTAVR4d8Yyl4+Gthg4MaabNrTFQEu0xdqcsC3uO2u7fvNwE/w/Z6T//8SNG3cI7Iu2WJvLt8UkNg6Ftlibtm2xd2bySGcb29wWj2mYfxWHjTcSpe35GGAXtMXaFNvivrNivIqp23fWOF95mNLe3onExgE9krHefa9OKwlt8dG0a4v7zpoliL17Omzftlqc/LS0HTgO2mJtCm2xd1G83m8WU3elLZb31gaJjUPZnrH9p7WfD3c1tMVH06wtzmJ4Dt6+s7brnDHGdfIKRbBwYbt+aYvn7UKbLC4SbP82WXsId/vnv3TgVWiLtZHbYrnNraZupS0u/jSL3CW9rQ3v450ppXQQ+OFDkNg4ps0Z23c/nvkLJG3x0bRqi4WcnYIzXtAIxt9jNFq4GJbV4iV4l1spMSvN2hpDPqBCfCygjWJke/9V+RanVVktTlNwJXVXVovzTBUiN0xv7+Zdzj9fuUuGxMbRbG2Lfzrz8czbKrTFR7NvW2ycL50UMW8Nsjb6Sbhd7ovDFYVkSz5s2LD2UM9QQhbtlSL7y5mbcfdW2LubMb9bvhGOt9lybnFwCkU5dTefWxz0ulnkRuk9Dwi74vpdIiQ2DmhjW+w/bPfrmf3TFh/NMVaLiydMSHccx4efCJkHB8RgLYVssl1M4Y1RC7RU/4Trzbiv8WvDp4S3Wr8SxbzU+/xqcWlvWeTG6X3vguOF4fpdZiQ2jknM2P7Tmu/G/Jj+T/7V2R/yX/ZW0RYfzVHOLe6TjfPWUlucryJLVuMyWWOorD3kPyVtsbuVlQx64svZcIG2OTSfPbdY3psUuUmP651xvu+stMBcuEuMxMbRlDO2734Y93MYhqH/tOONJ9AWH80BrkQRpOSS1cu5xdmZaPm5xdJnpetxmYwM7yJuF8cniF20x2qxNnJb7F188bXw826PX4misDchctMe1ztjrV32vOEudyQ2jqmSsf2nNR/+ueuyzWiLj+YA1y1Oz04bf+zcsjU+zU24EoV8sTcxJfMcDJO3FLIV4XhCFo2VP3Ln4nOL6YwvovKROzENwxMZlpfu9PQG4RRkaW9Z5GY9bvoJ6Q13mZHYOKBaS/Ors9+d/+meuC7bjLb4aE74r9w9Is/BobCWMH/NA1QcDxxB+SN3cR/sHR+5u4Yn/5W7B86a2BOJjaOptzT+w5jvT37YbkRbfDSXbYvzlKyvKyTbxXvlY4B9HWS6oZmn//Hnedn2mN0xiY1jWsnYZ6/LNqMtPprLtsWABkw3bZ5uiwE84d0Zy1w+Gtpi4MSYbtrQFgMt0RZrQ1sMnBjTTRvaYqAl2mJtaIuBE2O6aTO3xRRFXaP2DhVEaIuBE2O6acMRB1pixmnzlrYYAAAAOJ3Xt8V79/qAFkw3bTjiQEvMOG1oi4ETY7ppwxEHWmLGaUNbDJwY000bjjjQEjNOG9pi4MSYbtpwxIGWmHHa0BYDJ8Z004YjDrTEjNNmj7a476zt+iZ/vJkJLg1opMsEihs37hDYC5GtzXGOOKEKDY4z49DGrm1x31mzcD4ZZEzSPYfjpT3kexmmqM2/isPGG4nS9nwM0BiRrc2TRzwPz5F3wua+s3mSBghV6EHGarN7WzyFr3dRS9t31lqb5fc8wjvnh/X4npnNCxvJT0vbgSMgsrV56ohL4XlvlYPNc2e8LVcJVWhAxmrTsC2W13qn8I2DeOycvVtbwNiwqpGvQGz/NlnYCHf7wO8YeBsiWxv5iPedNa6bItb5eRXYdn0pJ7Otc/NczVVCFaqQsdo0a4uDoJVWi6WuODkLOVjMkPZaIQaxWVvAyAdUiI8FvFsxsr3/qnyL0yq3xVM8emfmReD70sLG8JwWIjbkKqEKJchYbVq1xcnCcP3c4qUbjj+dF4wP3wU04k4mJliuSLbkw4YNCxv1gCbB0VIpsr+cuRl3j2nvbsb83nKyEQ6vGLBzUoq35fDM22Lj/APnFhOquDwyVptWbXF4PoR4bnHf2fDEtoBw1Yp57WNbfA9xapcSPNkuRvzGHAfaqL3B593NuK/xa8OnhLd6si2e1cJz02oxoQpVyFhtGq4W19vi5ZtshVjoi6fBj380ZJCyOFnAqCxs5D8lyrGjlfPeyOvL+dO2OEraZ84tHhGqUIKM1abZucXLcvGyLiyuFqc5Pt3Ru/jjd1tXiytZnIwM7yJuF8eLj1h+RsArsZKhzTNtsRiez16JglCFKmSsNg2vRDF/NNo56dziYiAvfXE2ePt1i4c4c/OQDWO9lOAV4XgSHM1Uplt83hupfRFPrRZL4Tn9XMjONFfTVCVUoQcZq42Kf/w5D9mhsFAxf83TWRwP7Kv8cZA4o73j4yDX8JaA3XwB+BmhCiXIWG0u3hbnEVxftEi2i/fKxwB7OdR0QwNvOuLzAvFqd0yoQhUyVpuLt8XAtTHdtOGIAy0x47ShLQZOjOmmDUccaIkZpw1tMXBiTDdtOOJAS8w4bWiLgRNjumnDEQdaYsZpQ1sMnBjTTRuOONASM06bt7TFAAAAwOm8vi3eu9cHtGC6acMRB1pixmlDWwycGNNNG4440BIzThvaYuDEmG7acMSBlphx2tAWAyfGdNOGIw60xIzThrYYODGmmzYccaAlZpw2WtpiY4x4u75x4w6BvTwy3bz77vwbnwtaOGbAvhBZjUO5/IxDomFb3HfWTGzXz9u9Ezb3nTXxS3jfWdv103+2GzMx/yoOG28kStvzMUBj2yO7/7T2c/PMaTdbgz2aB6Z239lkuHeP3H/bo4e/BnHM6oDggV7zdxL5iCeHID8iZ0BW44Boi7Vp1hZ7Z5ac9u5+s+9stHl+VSnG+sNt8chsXoFIflraDhzB5sjuux/b+6SGs7Xv3DQi3v+a9EGf6oofevTVXrMwYGq9aYs3IatxKLTF2rRqi+WYzrbOL8fy+pNz4dJM8JpcWqcRlwq2f5usQIS7ffg3DbzB1sj+6czH5jZpp9n6YDMXj4664uxR+s7arnPV3nTt0Vf77uqAXVaLpV/R8qtIjkL1lxY8/fDvTPMu4+NcOjRkNc6HtlibpqvF0huQyUvFlKCb35ZdIrf8oiQmpllbacgHVIiPBbzbxsj2H7b7tX2v+8zWR9d7w4cNH0l4lA0L0SuP/uxScbD7PVaL43bW+ehXEZ6IsvJLW36/fWettfMO4t/ZvMf4ccdBZDXOqJix3n9VvsVp7XNucfCmbP5CO2f3lhfa8MVGztpwXSHZkg8bNqxA1JOUqEVL4nTrP635bsyPaTb86uyPR/rNofVsnR7twcZxedykK84epXo2x5ZH/7Ol4qFJW5wYH25+3OlG9KsIW9b6L236pu+s831n06Y7GRY9bvkhYmQ1DqjU0nw5czPu3gp7dzPm90nPW0JsjytRzEtRf77+lL4YpFErxmspaPPTYhZvDFygjfJ067sfxv0chmHoP+144xkNZ+vjZ8ROdwgfR3yULR9JqDz6ny4VDzt+5G45z0FY4Q2P4MovbfwD3Bvi6JvpAePDev8Dx2vPZDVOp9bSeHcz7mv82vAp4a12uUDbHNGPnq1YX38qWg3NZKWhsgKR/5TMxY4q063/tObD//F12VrO1oc/Njc+stS/ZePWd1x89D9eKi48q6c8/JG7+3ne0RnDfTpswy/NO9v5aDHYu6UFzptu78yyrlx4iAxZjaNZaWnoiS+nVVs8B+gQndH2wGfbp7xNwjV8QZo/Mj+rh2YyMryLuF0cnyB80VItsn919rvzP90D12UbNZytQduUXABjm6TnKzxKqS0uPXp0brW0EvzYgPuGva5E0Xc2frZBh5yfATyUfmnjScXhucjWpcc/PFt5HBL/gslqnA6rxdo0/cjdJHq5CN9bW5IyfcctWBFKP82cv30XEbMyT8Mwf0tRWxGOJ2rRTH0lw38Y8/2hD9vd79dutkb3faJxjHu+/AnNjyIu5xYePWn587s+MuDZKzMXPHGBtqglD//IpWMr/9LiP2lyEb/7HaO/omR/zSGrcT7lj9y5+NxiOuOLOMy/cvfwaYUPyNNwKKwozF/zGBXHA/tamW4PXZdtu3fOVtQ9HrDxQvWm80l2Q1bjaMofuYv7YO/4yN01HKYtDlYSXvh6m2dlfXUh2S7eKx8D7GWva2q+Y7Zii0ePePpXmKO2xWQ1jonrFmtzoLYYwKOYbtpwxIGWmHHa0BYDJ8Z004YjDrTEjNOGth

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表