[PHP-DEV] PHP 4.0 Bug #7881: sybase-ct does not report server errors From: alex <email protected>
Date: 11/19/00

From: alex <email protected>
Operating system: Linux kernel 2.2.16 (debian 2.2)
PHP version: 4.0.3pl1
PHP Bug Type: Sybase-ct (ctlib) related
Bug description: sybase-ct does not report server errors

ok, this is my php configure line:
./configure --with-apxs=/www/bin/apxs --with-sybase-ct=/opt/sybase-11.9.2 --enable-track-vars

I've got these 3 packages installed on /opt/sybase-11.9.2
sybase-ase-11.9.2-3.i386.rpm
sybase-common-11.9.2-3.i386.rpm
sybase-openclient-11.1.1-3.i386.rpm

I can query a MSSQL 7.0 server + SP2 applied with no problems, but if I ever misstype a query php won't report the sql server error and hangs the script forever.

I strace'd apache and here are part of the results:
(the cmd used was: strace -s 128 /www/bin/httpd -X)
connect(6, {sin_family=AF_INET, sin_port=htons(1433), sin_addr=inet_addr("200.32.xxx.xxx")}}, 16) = 0
ioctl(6, FIONBIO, [1]) = 0
ioctl(6, FIOASYNC, [0]) = 0
setsockopt(6, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
setsockopt(6, IPPROTO_TCP1, [1], 4) = 0
... some more not meaningfull sys calls.....
send(6, "\1\1\0\33\0\0\0\0SELECT foo FROM bar", 27, 0) = 27
recv(6, "\4\1\0?\0\0\0\0\252+\0\320\0\0\0\1\20\32\0Invalid object name \'bar\'.\5MEGA1\0\1\0\375\2\0\301\0\0\0\0\0", 3072, 0) = 63
alarm(300) = 300
alarm(0) = 300
send(6, "A", 1, MSG_OOB) = 1
recv(6,

as you can see the server reported an "Invalid object name \'bar\'." error message, but somehow php sends a MSG_OOB after that, and then waits the recv() forever. the browser keeps waiting until it times out (the browser times out, not php, it even exceeds my max_execution_time). If I kill apache then the error msg is shown, but otherwise.. it timesout and nothing is shown.

my php script was:

<?php
$c=mssql_connect($dsn,$user,$pass);
mssql_select_db($db_name);
$r = mssql_query("SELECT foo FROM bar",$c);
$row = mssql_fetch_row($r);
echo $row[0];
?>

hope you guys can help me out on this one :)

Thanks
alex <email protected> 

-- 
Edit Bug report at: http://bugs.php.net/?id=7881&edit=1

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>