php5-mssql

[hogman23]

I upgraded a server to Edgy and had some problems with php. I need php5-mssql installed but it tells me "Package php5-mssql is not available, but is referred to by another package.". How can I tell what package it is referred to now?
Thanks

[az]

There never has been a php5-mssql package.

[hogman23]

There never has been a php5-mssql package.

This is the output from 'dpkg -l php5-mssql' on my dapper server:

ii php5-mssql 5.1.2-1ubuntu3.4 MSSQL module for php5

This is the output from the same on my Edgy Server:

pn php5-mssql <none> (no description available)


It is installed on my Dapper server, but what package do you use to mssql on Edgy???

[hogman23]

This is strange, it looks like they combined the php5-mssql install with something else, but I can't figure out what.

[hogman23]

Ok, here is the fix to get php5-mssql installed:

Install the Debian Package tools:

apt-get install build-essential debhelper

Then, download the PHP5 Source Files:

apt-get source php5

Get the dependencies for building PHP5:

apt-get build-dep php5

cd to the directory php5-5.1.2/debian and vi the file modulelist. Insert a line above the one that says:

mysql MySQL

with the contents

mssql MSSQL

Next, edit the file rules and search for

–with-mysql=shared,/usr

Insert the following above it:

–with-mssql=shared,/usr

Make sure not to forget the backslash on the end.Now, we must edit the “control” file in the same directory. Add this to the end of the file:

Package: php5-mssql
Architecture: any
Depends: ${shlibs:Depends}, ${misc:Depends}, ${php:Depends}, php5-common (= ${Source-Version})
Description: MSSQL module for php5
 This package provides a module for MSSQL using FreeTDS.
 .
 PHP5 is an HTML-embedded scripting language. Much of its syntax is borrowed
 from C, Java and Perl with a couple of unique PHP-specific features thrown
 in. The goal of the language is to allow web developers to write
 dynamically generated pages quickly.

Move up a directory:

cd ..

Now run:

dpkg-buildpackage

This will compile PHP5 and create the debs in the parent directory. This process takes a while, so relax.

When that is finished, cd to the parent directory and you will see your deb files.

Now, to install php5-mssql:

dpkg -i php5-mssql_5.1.6-1ubuntu2.1_i386.deb

The majority of the information from this post came from the following URL:
http://panthar.org/2006/06/15/php-wi...on-ubuntu-606/

[az]

Why is that dissabled in the source? Are there licencing issues?

[hogman23]

I'm not sure if it's a bug or what, but we had no problems installing it when the server was Dapper. When we did an in-place upgrade to Edgy, the package wasn't available anymore. So either, the package isn't there in the edgy repos, or there is another package that installs php5-mssql, but I couldn't find it if there is.

[hogman23]

Oh yeah, another "note to self", Don't compile PHP5 from the server, because for some reason it uninstalls PHP5 from the server when you do that and you have to go back and reinstall everything. Also, when PHP5 get's uninstalled, or course it removes PHP5 from mods-enabled in Apache2.

That took me 10 minutes to figure out...DUH!

[az]

So either, the package isn't there in the edgy repos, or there is another package that installs php5-mssql, but I couldn't find it if there is.

There is no php5-mssql package in any release of Ubuntu.

[hogman23]

There is no php5-mssql package in any release of Ubuntu.

Hmm, I wish I knew what installed it on the old server then, that would have saved me a bunch of work.