Ubuntu
freetds package

PHP5-MSSQL package needed

Bug #374925 reported by Seth.Griffin
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
freetds (Ubuntu)
Invalid
Undecided
Unassigned

Bug Description

Binary package hint: php5-sybase

Description: Ubuntu 9.04
Release: 9.04

libapache2-mod-php5:
  Installed: 5.2.6.dfsg.1-3ubuntu4.1
  Candidate: 5.2.6.dfsg.1-3ubuntu4.1
  Version table:
 *** 5.2.6.dfsg.1-3ubuntu4.1 0
        500 http://us.archive.ubuntu.com jaunty-updates/main Packages
        500 http://security.ubuntu.com jaunty-security/main Packages
        100 /var/lib/dpkg/status
     5.2.6.dfsg.1-3ubuntu4 0
        500 http://us.archive.ubuntu.com jaunty/main Packages

freetds-dev:
  Installed: 0.82-4
  Candidate: 0.82-4
  Version table:
 *** 0.82-4 0
        500 http://us.archive.ubuntu.com jaunty/main Packages
        100 /var/lib/dpkg/status

Problem: There is no package for Microsoft SQL Server support in PHP on Ubuntu.
Failed solutions: using php5-sybase package.

When using php5-sybase querying ntext data (unicode text) Microsoft SQL Server 2000 gives the following error:

"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."

Successful solutions:

Reconfigure and re-build .deb packages for libapache2-mod-php5 and freetds-dev.

Reconfigure libapache2-mod-php5:

http://panthar.org/2006/06/15/php-with-mssql-on-ubuntu-606/

Reconfigure freetds-dev:

Changed this line in debian/rules

--with-tdsver=4.2
to
--with-tdsver=8.0

Why this works:

1. The mssql module in php was built to query sql server, not sybase.
2. SQL Server 2000 requires at least version 7 but works best with version 8. I have not tested this on SQL server 2005 or above.

Proposed solution:

Package php5-mssql for out of the box pdo-dblib support and mssql_* function support.

If sybase works with tdsver 8.0, then it is my recommendation that freetds-dev be modified to build to that version rather than 4.2.

If sybase does not work with 8.0, then it is my recommendation that an additional freetds8.0-dev package be provided to work with php5-mssql.

If you need more information, package diffs, or anything else, please ask, I'll be happy to provide them.

Regards,
Seth

Revision history for this message
Ondřej Surý (ondrej) wrote :

Have you checked contents of php5-sybase before you submitted this bug report? Just rethorical question, since you apparently didn't: http://packages.ubuntu.com/jaunty/i386/php5-sybase/filelist

Unfortunatelly you didn't even read comments in [Bug 87063].

And unfortunatelly you have mixed two bug reports together. Seems like you have a problem with tdsver and not php5-mssql.

Revision history for this message
Ondřej Surý (ondrej) wrote :

Feel free to report bug report against freetds with only relevant parts, this bug report is a quite mixed together with talk about php5.

Revision history for this message
Ondřej Surý (ondrej) wrote :

Reassigning to freetds.

affects: php5 (Ubuntu) → freetds (Ubuntu)
Revision history for this message
Steve Langasek (vorlon) wrote :

The only request here pertaining to the freetds package is to rebuild with a different --with-tdsver option. This only affects the default protocol version that's used; you can always override this in the configuration in /etc/freetds/freetds.conf for a given connection, or even change the default for your host the same way. 4.2 is still the least common denominator protocol version (to the extent that there is one), so I don't think this should be changed in the package.

Changed in freetds (Ubuntu):
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.