Comments on Enabling MSSQL for PHP5 On Debian Lenny (testing)

Atleast give proper credit next time. I posted my howto on my site for everyone to use, and i dont mind seeing 90% of it here ( with slight mods ), but atleast include a link or say thanks or whatever.

http://shiny.ma3x.net/2007/11/28/enabling-mssql-for-php5-under-debian-lenny-testing

I wanted to enable myssql too on one of my older website and i have to say that the tutorial is very clear and easy to follow. I did get a few weird errors, but by typing: apt-get install build-essential debhelper like you said, it worked perfecly! I just want to say thanks :)

Megan from credit card live!

Hi!

Thanks for this great tutorial, it served well to my purpose in Debian Etch with a very few changes: It also helped me to understand better how the debian source packages can be easily modified.

 In my case, I had to do this:

1.  In the debian/control file, erase the field "(= ${Source-Version})" that comes after "php-common" in the "Depends:" line for php5-sybase and php5-mssql.
2.  Instead of installing the default php5-sybase package from the official repo, just install the compiled one along the new customized php5-mssql package.
3.  Reboot/Reload your Apache2 et voilà!

Of course you could just use the php5-sybase package, but if you cannot miss some features and you cannot upgrade to Lenny, it's fine.

 Hope it helps.

I am currently using "PHP 5.2.7-0.dotdeb.1" and when I try to run apt-get build-dep php5 the following is returned:

    apt-get build-dep php5
    Reading package lists... Done
    Building dependency tree... Done
    Package libmysqlclient14-dev is not available, but is referred to by another package.
    This may mean that the package is missing, has been obsoleted, or
    is only available from another source
    However the following packages replace it:
    libalps-heap1-dev
    E: Package libmysqlclient14-dev has no installation candidate
    E: Failed to satisfy Build-Depends dependency for php5: libmysqlclient14-dev

 I have removed libmysqlclient14-dev with --purge switch. I have installed libalps-heap1-dev. I have found some older deb sources to see if the dependency can be built from those. I have tried apt-get --fix-broken
apt-get --ignore-missing

Can someone help and let me know how to ignore the dependency or use the alternative libalps-heap1-dev to build-dep.

Thank You.

Hi, 

I have error when dpkg-buildpackage used:

make[1]: *** [ext/imap/php_imap.lo] B??d 1 
make[1]: Opuszczenie katalogu `/usr/src/php5-5.2.6/apache2-build' 
make: *** [build-apache2-stamp] B??d 2 
dpkg-buildpackage: niepowodzenie: debian/rules build zwróci? status b??du 2

translation: dpkg-buildpackage: failure: debian/rules binary gave error exit status 2

debian/rules is set as in tutorial:

..."--with-mysql=shared,/usr \
  --with-mssql=shared,/usr/local/freetds \
  --with-mysqli=shared,/usr/bin/mysql_config \"...

What I am doing bad?

Guys, on debian etch or upper, there is no php5-mssql package. That is included into php5-sybase package, just install it and there is the mssql support. :) Refer: http://packages.debian.org/search?keywords=php5-sybase

Very good dude! thx....

apt-get install tsdodbc -> package not found...

dpkg-buildpackage does not work: "could not resolve path to ltmain""