[Bug 87063] Re: [needs-packaging] Please package php5-mssql
You may want to file a new bug report for this (and refer to this one here, if useful). I don't know about details (i.e. I cannot help you), sorry. ** Changed in: php5 (Ubuntu) Assignee: Daniel Hahler (blueyed) => (unassigned) ** Changed in: php5 (Ubuntu Hardy) Assignee: Daniel Hahler (blueyed) => (unassigned) -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 87063] Re: [needs-packaging] Please package php5-mssql
Hi, I feel that this is still an issue that needs to be addressed with a package addition. The php5-sybase package is not sufficient as it is meant to handle sybase and not Microsoft SQL Server databases. When using php5-sybase to query ntext data (unicode text) Microsoft SQL Server 2000 says: "Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier." After reconfiguring and building the libapache2-mod-php5 package with mssql everything works fine. If this is a freetds issue, note that the freetds-dev package source debian/rules is configuring freetds to be built to tdsver 4.2. It has been my experience that Microsoft SQL Server 2000 works well with tdsver 8.0. If Sybase works with tdsver 8.0, then distributing a freetds-dev package built with tdsver=8.0 might solve this problem. I am willing to help you guys get more information on this to prove that this is an issue that needs attention. Let me know how I can help, and let's stick to the facts. Thanks. -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 87063] Re: [needs-packaging] Please package php5-mssql
It's such a shame that it's taken this long to elicit an explanation from the packaging team, instead of just "php5-sybase provides php5-mssql now". Obviously if php5-sybase provides true MSSQL support as well as Sybase support then this bug is not valid (any more). There are people here who know what they need from PHP, but don't know how to create Debian packages. Ondřej, if you or another packager had given the explanation you just did a lot earlier, instead of just blankly insisting that php5-sybase is enough, you'd not have had people like me, who don't know about how Debian packages are built, nagging you about needing php5-mssql. When I raised this bug it was valid. The first explanation to it being closed without a new php5-mssql package being available was your comment (https://bugs.launchpad.net/ubuntu/+source/php5/+bug/87063/comments/28) which evidently didn't explain clearly enough for people that php5-sybase now includes --with-mssql=shared. The people who've commented here are not whiners, nor are they trying to waste your time. Packagers, you can help yourselves and us by taking just a little more time to try to communicate with bug reporters and commentators more effectively, instead of regarding us as know-nothing irritations. -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 87063] Re: [needs-packaging] Please package php5-mssql
Ok, I say it once again. What is contents of your php5-sybase package? There is MSSQL.SO - so I would understand a bug asking for building separate SYBASE extension. In debian/patches/119-sybase-alias.patch we aliased SYBASE functions to MSSQL in EXT/MSSQL/PHP_MSSQL.C and php5 is built with (see debian/rules): --with-mssql=shared,/usr --with-pdo-dblib=shared,/usr And this was introduced in php 5.2.4-1. If you spent same time checking what I said (really reading changelog.Debian would be sufficient) as you spent writing you long reaction, it would save your and mine time as well. -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 87063] Re: [needs-packaging] Please package php5-mssql
Strange attitude, Ondřej. We're all just trying to make the product better so let's work together and be civil to each other. Please let me know if any of the following facts are incorrect - it may be that me (and others) are misunderstanding. PHP's mssql and sybase libraries are different. As an example, the sybase one is supported by PDO (pdo_dblib); but, unlike the mssql one, does not have transaction support. So, some users of ubuntu would like to use the mssql library provided by PHP (available by compiling with --with-mssql) instead of (or as well as) the sybase support (available by compiling with --with- sybase/--with-pdo-dblib). This would allow them to use something other than PDO and have transaction support in their connections to MSSQL databases, for example. (I know both libaries use freetds underneath - but the interfaces are not the same and the functionality available is not the same.) Because of these differences, I am just one among many others (including those who have commented on this ticket), who have had to build PHP from source (--with-mssql=shared) in order to get the mssql.so library that we want. So, given that PHP provides and supports this library in it's own distributions, and given that there is clearly a userbase who wished to use this library (as opposed to - or as well as - the one provided by php5-sybase) - and given that the work involved in generating the necessary php5-mssql package would be negligible, can we not please agree that this would be a sensible step forward to keep the community happy and improve Ubuntu's offering. (All of the above applies to Intrepid as well as Hardy and earlier releases.) (There is, of course, a php5-mssql package already - but this is just a virtual package provided by php5-sybase.) -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 87063] Re: [needs-packaging] Please package php5-mssql
Invalid since php5-sybase switched to mssql extension since 5.2.4-1. ** Changed in: php5 (Ubuntu Hardy) Status: New => Invalid -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 87063] Re: [needs-packaging] Please package php5-mssql
What is really ridiculous is that you complain just about package NAME. Have you really checked contents of php5-sybase package? /usr /usr/lib /usr/lib/php5 /usr/lib/php5/20060613+lfs /usr/lib/php5/20060613+lfs/mssql.so /usr/lib/php5/20060613+lfs/pdo_dblib.so /usr/share /usr/share/doc /etc /etc/php5 /etc/php5/conf.d /etc/php5/conf.d/mssql.ini /etc/php5/conf.d/pdo_dblib.ini /usr/share/doc/php5-sybase Sybase extension was switched to mssql some time ago in Debian, since mssql had more feature and PDO driver. And Ubuntu pulled that change and has mssql in (at least) 8.04 and 8.10. And yes I consider having two extensions with same set of functions and compiled with same underlying library as braindead. -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 87063] Re: [needs-packaging] Please package php5-mssql
+1 even if this bug is seen as a rant by some "official" people involved, nobody ever gave a reason on why this _packaging_ issue seems so hard to fix. RedHat, SuSE, Mandriva, ... to name but a few other major distributions all seem to be able to package php-mssql but obviously it seems to be impossible for ubuntu to deal with it. Ridiculous, really. -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 87063] Re: [needs-packaging] Please package php5-mssql
Why are you guys so reluctant to make such a small change to include better MS SQL Server support? Can you imagine the (correct, IMO) response from the PHP guys to a request to add better MSSQL support to the Sybase extension? I bet it would be "No, the functionality is already there in the MSSQL extension, use that instead". Even if the response is "Sure, yeah, we'll do that right away", that doesn't solve the problem for Ubuntu users now: it would take ages for the change to filter down to an Ubuntu release. It would be so easy to fix this bug properly; what's the big deal with insisting that the Sybase extension ought to be sufficient? -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 87063] Re: [needs-packaging] Please package php5-mssql
I disagree. The php5 team has already done the work to have full support within the mssql.so extension. Including the real php5-mssql package would be a very small change to incorporate that work. This is a packaging issue, not a PHP issue. -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 87063] Re: [needs-packaging] Please package php5-mssql
> we need a real php5-mssql package with true Microsoft SQL server support No, what you need to add required functionality to php5-sybase. Both extensions use SAME freetds library. It's just matter of "bug" or "lack of feature" in sybase extension. Feel free to aproach php team to fix these deficiencies. -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 87063] Re: [needs-packaging] Please package php5-mssql
It's been a while since I've been working with MSSQL, which is why I'm only just revisiting this bug. The Sybase (DBLIB) drivers do not provide all the functionality needed when using a Microsoft SQL Server DB. For example, using this driver with PDO reports that transactions and stored procedures are not supported. Providing a php5-mssql package that is really a virtual package linked to php5-sybase is not adequate: we need a real php5-mssql package with true Microsoft SQL server support, not basic compatibility using the DBLIB. ** Changed in: php5 (Ubuntu Hardy) Status: Fix Released => New -- [needs-packaging] Please package php5-mssql https://bugs.launchpad.net/bugs/87063 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to php5 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs