вторник, июля 31, 2007

Ubuntu 7.04 (Feisty): PHP installation with MSSQL

Ubuntu is a great Linux distribution, but MSSQL support is poor. There is nothing about MSSQL in apt-get or Synaptic package manager. This small HOWTO fixes problem. See HOWTO: PHP with MSSQL on Ubuntu 6.06 if you are using Ubuntu 6.06 or want to try another way to reach PHP with MSSQL.



Step 1. Get the sources and packages

You must have a php5, php5-dev, php5-src and freetds.

sudo apt-get install php5 php5-dev freetds
sudo apt-get source php5


Step 2. Building MSSQL module

Apt-get will unpack php5 sources into php5-5.x.x directory. Navigate to php5-5.x.x/ext/mssql:

sudo phpize
sudo ./configure --with-mssql
sudo make

After make you will see something like this:
...
Libraries have been installed in:
/home/snick/Software/php5-5.2.1/ext/mssql/modules
...

PHP modules located in /usr/lib/php5/20060613+lfs/ (change last directory if differs). Just copy new module:
sudo cp php5-5.2.1/ext/mssql/modules/mssql.so \
/usr/lib/php5/20060613+lfs


Step 3. Configuring PHP

Setup PHP to use new module:

sudo vim /etc/php5/conf.d/mssql.ini

Add text extension=mssql.so and save the file. Restart Apache.


Make sure that you correctly setup /etc/freetds/freetds.conf for your servers.

2 комментария:

Joshua комментирует...

THANK YOU SO MUCH!!!! I spent hours looking for that and after some fresh perspective, I came across your write-up.

Анонимный комментирует...

mostly the same in 7.10, except installing freetds-dev instead of freetds