Bug#431044: [php-maint] Bug#431044: Apache child exits on sql server functions

[Walter Doekes]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi debian folk.

 It's possible that the problem is also specific to tables containing
 non-ASCII data.  You mentioned that the problem was not reproducible
 for you when using sqsh; could you also provide a sample result set
 for a query that succeeds with sqsh and fails with php5-sybase?

I don't think it's the same bug, but it's really close.
Please take a look at this one:
http://bugs.php.net/bug.php?id=33693
If also concerns sybase-ct and iconv.


See this sample script connecting to a MS SQL server:

?php
putenv('TDSVER=7.0');
$db = sybase_connect($server, $username, $password);
sybase_select_db('MODULES', $db);
sybase_query(DROP TABLE test_tbl);
sybase_query(CREATE TABLE test_tbl
  (a INT, b NVARCHAR(255), c UNIQUEIDENTIFIER));
sybase_query(INSERT INTO test_tbl VALUES
  (1, N'Hello World', NEWID()));
if (($q1 = sybase_query(SELECT a, b FROM test_tbl)))
print_r(sybase_fetch_row($q1));
if (($q2 = sybase_query(SELECT a, b, c FROM test_tbl)))
print_r(sybase_fetch_row($q2));
?


This outputs:

Array
(
[0] = 1
[1] = Hello World
)
error_handler: Data-conversion resulted in overflow.
Segmentation fault


If you replace the TDSVER=7.0 with TDSVER=4.2 you get:

Array
(
[0] = 1
[1] = Hello World
)
Array
(
[0] = 1
[1] = Hello World
[2] = 244ebbc892d6f24694ab8a08836fa86d
)


Obviously it would be better if this is fixed upstream. But this bug has
existed since 2005 and for me personally I only need it fixed in Debian
and Ubuntu ;-)

Regards,
Walter Doekes


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG/iRcHeLk+LNJZ18RAnUpAKC9VUo8SPsVd+S0S08dSzGg2O9SZgCgp5Yr
tTYtwWKyCMYzzHjUYk4tP9M=
=skrN
-END PGP SIGNATURE-




-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]

Bug#431044: [php-maint] Bug#431044: Apache child exits on sql server functions

[Steve Langasek]

Hi Andrea,

On Fri, Jun 29, 2007 at 09:43:27AM +0200, Andrea Cerisara wrote:
 When a php script reaches the first sql server function, the
 process that handles the connection exits, and Apache reports:

 apache2: iconv.c:357: tds_iconv_open: Assertion `ret == 0' failed.
 [Thu Jun 28 13:54:48 2007] [notice] child pid 18191 exit signal Aborted (6)

  From phpinfo() LANG is set to C, and the default charset is ISO-8859-1.
  From locale command LANG is set to [EMAIL PROTECTED]

 I' m using Debian GNU/Linux 4.0, kernel 2.4.27-2-686,
 php5-5.2.0-8+etch1 and libc6 2.3.6.ds1-13.

I haven't been able to reproduce this problem in a test environment.  Can
you provide a test script that shows the error?

It's possible that the problem is also specific to tables containing
non-ASCII data.  You mentioned that the problem was not reproducible for you
when using sqsh; could you also provide a sample result set for a query that
succeeds with sqsh and fails with php5-sybase?

Cheers,
-- 
Steve Langasek   Give me a lever long enough and a Free OS
Debian Developer   to set it on, and I can move the world.
[EMAIL PROTECTED]   http://www.debian.org/


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]