Debian Bug report logs - #266917
enable mssql extension

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: Bozhan Boiadzhiev <edmon@oohaa.net>

To: Debian Bug Tracking System <submit@bugs.debian.org>

Subject: php4: missing php-mssql

Date: Thu, 19 Aug 2004 20:56:03 +0300

Package: php4
Version: 4:4.3.8-2
Severity: normal

I don't know if this can solve missign of mssql_init and other functions
but i read that is because of missing such func in sybase pacakge.
And that php verion > 4.3.3 has this functions if they are compiled in
given way.
Sorry for bad explaining i have readed all of this here:
http://www.devarticles.com/c/a/PHP/Executing-Microsoft-SQL-Server-Stored-Procedure-from-PHP-on-Linux/5/

Regards
Bozhan


-- System Information:
Debian Release: 3.1
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.4.26-1-686
Locale: LANG=C, LC_CTYPE=C

Versions of packages php4 depends on:
ii  apache-common               1.3.31-2     Support files for all Apache webse
ii  debconf [debconf-2.0]       1.4.30       Debian configuration management sy
ii  libbz2-1.0                  1.0.2-1      A high-quality block-sorting file 
ii  libc6                       2.3.2.ds1-13 GNU C Library: Shared libraries an
ii  libdb4.2                    4.2.52-16    Berkeley v4.2 Database Libraries [
ii  libexpat1                   1.95.6-8     XML parsing C library - runtime li
ii  libmm13                     1.3.0-3      Shared memory library - runtime
ii  libpcre3                    4.5-1.1      Perl 5 Compatible Regular Expressi
ii  libssl0.9.7                 0.9.7d-4     SSL shared libraries
ii  mime-support                3.28-1       MIME files 'mime.types' & 'mailcap
ii  zlib1g                      1:1.2.1.1-5  compression library - runtime

-- debconf information:
  php4/update_apache_php_ini: true

Message #10 received at 266917@bugs.debian.org (full text, mbox, reply):

From: Bozhan Boiadzhiev <edmon@oohaa.net>

To: 266917@bugs.debian.org

Subject: add

Date: Thu, 19 Aug 2004 23:16:12 +0300

i have php4-sybase and libct1 installed and
mssql_query is aviable but mssql_init it not ...

Message #15 received at 266917-done@bugs.debian.org (full text, mbox, reply):

From: Steve Langasek <vorlon@debian.org>

To: Bozhan Boiadzhiev <edmon@oohaa.net>, 266917-done@bugs.debian.org

Subject: Re: Bug#266917: php4: missing php-mssql

Date: Thu, 19 Aug 2004 13:00:20 -0700

[Message part 1 (text/plain, inline)]

On Thu, Aug 19, 2004 at 08:56:03PM +0300, Bozhan Boiadzhiev wrote:
> Package: php4
> Version: 4:4.3.8-2
> Severity: normal

> I don't know if this can solve missign of mssql_init and other functions
> but i read that is because of missing such func in sybase pacakge.
> And that php verion > 4.3.3 has this functions if they are compiled in
> given way.

This is provided by the php4-sybase package.

-- 
Steve Langasek
postmodern programmer

[signature.asc (application/pgp-signature, inline)]

Message #20 received at 266917@bugs.debian.org (full text, mbox, reply):

From: Steve Langasek <vorlon@debian.org>

To: 266917@bugs.debian.org

Subject: Re: php4: missing php-mssql

Date: Thu, 19 Aug 2004 13:24:46 -0700

[Message part 1 (text/plain, inline)]

A quick examination of the PHP sources shows that the mssql_init
function is only provided by the mssql extension, not by either of the
sybase extensions.  The mssql extension does seem to be the
best-maintained upstream, so it would probably be a good idea to change
to this extension for Debian if someone can verify there are no
regressions.

It would also be a good idea for upstream to stop duplicating efforts by
shipping two of these modules, but anyway.

-- 
Steve Langasek
postmodern programmer

[signature.asc (application/pgp-signature, inline)]

Message #27 received at 266917@bugs.debian.org (full text, mbox, reply):

From: Bozhan Boiadzhiev <edmon@oohaa.net>

To: 266917@bugs.debian.org

Subject: compile

Date: Fri, 20 Aug 2004 13:22:23 +0300

Following this 
http://www.devarticles.com/c/a/PHP/Executing-Microsoft-SQL-Server-Stored-Procedure-from-PHP-on-Linux/5/
and adding it to debian php4 src and enabling mssql 
(--whit-mssql=share,usr) i even compiled php4-mssql as debian package.
I installed it but it can't work together with sybase-ct, so i disable 
it in php.ini and leave only mssql.so.

But i can't make this example to work properly:
|
if we have this procedure:

CREATE PROCEDURE [procedure]
(
  @sval varchar(50) OUTPUT,
  @intval int OUTPUT,
  @floatval decimal(6,4) OUTPUT
) AS

if @intval is null
  select '@intval is null' as answer
else   
  select '@intval is NOT null' as answer

set @sval='Hello ' + @sval
set @intval=@intval+1
set @floatval=@floatval+1

return 10

We can use this PHP code:

<?php

$conn=mssql_connect("myhost","user","pwd");

if ($conn) {
  mssql_select_db("mydb",$conn);
 
  $stmt=mssql_init("procedure",$conn);
  mssql_bind($stmt,"RETVAL",&$val,SQLINT4);

  $ival=11;
  $fval=2.1416;
  $sval="Frank";
 
  mssql_bind($stmt,"@sval",&$sval,SQLVARCHAR,TRUE);   
  mssql_bind($stmt,"@intval",&$ival,SQLINT4,TRUE);
  mssql_bind($stmt,"@floatval",&$fval,SQLFLT8,TRUE);
 
  $result=mssql_execute($stmt);

  $arr=mssql_fetch_row($result);
  print ("Answer: " . $arr[0] . "<br>" );
  print ("RETVAL = $val ; intval = $ival ; floatval = $fval ; string = 
$sval");
 
  mssql_close($conn);
}
else print("ooops!");
?>
it executes but $ival $fval $sval are not as they expected.
Executing procedure on MsSQL server increments int values with 1 and add 
Hello to $sval,
but with php i get same values ||$ival=11; $fval=2.1416;  $sval="Frank";|

Message #32 received at 266917@bugs.debian.org (full text, mbox, reply):

From: Bozhan Boiadzhiev <edmon@oohaa.net>

To: 266917@bugs.debian.org

Subject: any resolution?

Date: Wed, 01 Sep 2004 12:54:32 +0300

Is there some plan of resolution of this issue?
I am not very happy recompiling php4 with every update.:(

Thanks
Bozhan

Message #43 received at 266917-done@bugs.debian.org (full text, mbox, reply):

From: Ondřej Surý <ondrej@sury.org>

To: 266917-done@bugs.debian.org

Subject: Re: #266917: enable mssql extension

Date: Tue, 25 Aug 2009 15:54:08 +0200

Version: 5.2.4-1

From Debian changelog:

  * Switch php5-sybase to use the mssql extension instead of the sybase_ct
    extension.  Closes: #418734, #329065.

Ondrej
-- 
Ondřej Surý <ondrej@sury.org>
http://blog.rfc1925.org/

Send a report that this bug log contains spam.