|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #45357 sybase-ct fails against sybase-15_0 on 64-bit centos 5
Submitted: 2008-06-25 19:48 UTC Modified: 2010-08-31 14:28 UTC
Avg. Score:4.9 ± 0.3
Reproduced:11 of 11 (100.0%)
Same Version:8 (72.7%)
Same OS:8 (72.7%)
From: temmel at jcvi dot org Assigned: thekid (profile)
Status: Closed Package: Sybase-ct (ctlib) related
PHP Version: 5.2.9 OS: Centos 5 x86_64
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
Solve the problem:
34 - 30 = ?
Subscribe to this entry?

 [2008-06-25 19:48 UTC] temmel at jcvi dot org
I'm running into problems with php + sybase_ct under 64-bit Centos.  I get a sybase_select_db failure after successfully performing a sybase_connect.

CentOS release 5 (Final)
Linux speedy 2.6.18-53.1.4.el5 #1 SMP Wed Nov 14 10:37:27 EST 2007 x86_64 x86_64 x86_64 GNU/Linux


Using php-5.2-dev snap (php5.2-200806251230)...

Modified configure to use 64-bit libs:

 LIBS="-lintl64  $LIBS"
       LIBS="-lcs64 $LIBS"
       LIBS="-lct64 $LIBS"
       LIBS="-lcomn64 $LIBS"
       LIBS="-lintl64 $LIBS"
     SYBASE_CT_LIBS="-L$SYBASE_CT_LIBDIR -lcs64 -lct64 -lcomn64 -lintl64"
       LIBS="-lsybtcl64 $LIBS"

./configure --prefix=/opt/software/php-dev --with-sybase-ct=/usr/local/packages/sybase

Bug #16069 (ICONV transliteration failure) [ext/iconv/tests/bug16069.phpt]
iconv stream filter [ext/iconv/tests/iconv_stream_filter.phpt]
Test array_slice() function : usage variations - Pass different data types as $offset arg [ext/standard/tests/array/array_slice_variation2.phpt]
Test array_slice() function : usage variations - Pass different data types as $length arg [ext/standard/tests/array/array_slice_variation3.phpt]
Test lstat() and stat() functions: usage variations - effects of touch() on link [ext/standard/tests/file/lstat_stat_variation6.phpt]
Test lstat() and stat() functions: usage variations - writing data into file [ext/standard/tests/file/lstat_stat_variation7.phpt]
Test setlocale() function : usage variations - setting system locale as null [ext/standard/tests/strings/setlocale_variation4.phpt]
Test setlocale() function : usage variations - Setting system locale as empty string [ext/standard/tests/strings/setlocale_variation5.phpt]
Sybase-CT bug #22403 (crash when executing a stored procedure without parameters) [ext/sybase_ct/tests/bug22403.phpt]
Sybase-CT bug #26407 (Result set fetching broken around transactions) [ext/sybase_ct/tests/bug26407.phpt]
Sybase-CT bug #27843 (notices when query is a stored procedure) [ext/sybase_ct/tests/bug27843.phpt]
Sybase-CT bug #28354 (sybase_free_result crash) [ext/sybase_ct/tests/bug28354.phpt]
Sybase-CT bug #29064 (Exact numeric/decimal/money datatypes lose precision) [ext/sybase_ct/tests/bug29064.phpt]
Sybase-CT bug #30312 (sybase_unbuffered_query calls) [ext/sybase_ct/tests/bug30312.phpt]
Sybase-CT bug #6339 (invalid Sybase-link resource) [ext/sybase_ct/tests/bug6339.phpt]
Sybase-CT application name [ext/sybase_ct/tests/test_appname.phpt]
Sybase-CT connectivity [ext/sybase_ct/tests/test_connect.phpt]
Sybase-CT connection-based server message handler [ext/sybase_ct/tests/test_connectionbased_msghandler.phpt]
Sybase-CT sybase_fetch_object [ext/sybase_ct/tests/test_fetch_object.phpt]
Sybase-CT sybase_field_* functions [ext/sybase_ct/tests/test_fields.phpt]
Sybase-CT select LONG_MAX / LONG_MIN [ext/sybase_ct/tests/test_long.phpt]
Sybase-CT server message handler [ext/sybase_ct/tests/test_msghandler.phpt]
Sybase-CT server message handler [ext/sybase_ct/tests/test_msghandler_handled.phpt]
Sybase-CT query without storing [ext/sybase_ct/tests/test_query_nostore.phpt]
Sybase-CT select and types [ext/sybase_ct/tests/test_types.phpt]
Sybase-CT unbuffered query [ext/sybase_ct/tests/test_unbuffered_query.phpt]

Test script:

 $con = sybase_connect("SYBIL", "access", "access") or die ("sybase_connect failure\n");
 sybase_select_db("pfgrc_dev4") or die ("sybase_select_db failure\n");
 $qry = sybase_query("select * from z_logins", $con);
 echo sybase_result($qry, 1, 1);

Script results:

% /opt/software/php-dev/bin/php test.php
sybase_select_db failure


sybase-configm4_5.3.3.diff (last revision 2010-08-23 14:14 UTC by royanee at yahoo dot com)
sybase-configm4_updated.diff (last revision 2010-08-20 20:35 UTC by royanee at yahoo dot com)

Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2008-07-02 10:16 UTC] mul at rentapacs dot de
Had the same problem on SLES10 SP1 x86_64 running ASE Express Edition 15.0.2. The patch to ext/sybase_ct/config.m4 from Bug #35945 worked for me except that library names needed an additional 'syb' prefix:

e.g. -lct -> -lsybct64

HTH ... Michael
 [2008-09-18 06:30 UTC] radha_krishna_komal at yahoo dot com
I have Some Store Procedure And If We Do not Open That Store 
Procedure up to few time than it gives Wrong Result.And When We Open 
That Store Procedure And Close Than it Gives me Right Result.
I want to tell You that I require the Recompile The Store Procedure 
Automatically After few Days Without Open That because I have Somuch 
Store Procedure That Take Much Time
 [2008-11-09 13:12 UTC]
Please see if works for you.
 [2009-04-27 16:56 UTC]
Did the patch above fix this or not? Also update version field if you 
can still reproduce this with the latest PHP version(s).
 [2009-04-27 17:59 UTC] temmel at jcvi dot org
No, the patch did not fix the problem.
 [2009-05-17 20:53 UTC]
How did you test? Did you regenerate configure before running it again?
 [2009-05-25 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2010-08-20 19:57 UTC] royanee at yahoo dot com
After these steps:
 cd ext/sybase_ct;
 patch -p2 < sybase-configm4.diff;

checking for Sybase-CT support... yes, shared
./configure: line 21483: syntax error: unexpected end of file

However, if I replace "else if" with "elif" and switch the test -f from "$SYBASE_CT_INCDIR/libsybct64" to "$SYBASE_CT_LIBDIR/", it compile successfully. I'll try attaching my updated patch.
 [2010-08-20 22:39 UTC] royanee at yahoo dot com
Updated the patch again after debugging an issue where the severity level was either very large number or 116. It needed the -DSYB_LP64 CFLAG and now is able to correctly parse server communications, severity levels and query results.

Tested successfully on RHEL 5 x86_64, using PHP 5.3.2.
 [2010-08-22 11:52 UTC]
-Status: No Feedback +Status: Duplicate
 [2010-08-22 11:52 UTC]
This one looks like a duplicate of bug #50827 to me, which I fixed by a similar patch and committed that to SVN (trunk, 5_3, 5_2). So compiling PHP with sybase_ct w/ 64-bit libraries should work just fine by now. If not, can you provide a patch against current SVN?
 [2010-08-23 16:21 UTC] royanee at yahoo dot com
Thanks thekid. I was trying to build on 5.3.2 and none of the bugs I was able to find (#45357 and #35954) had the fix in yet, so I was happy to see that 5.3.3 was further along. Unfortunately, the "file_exists" check on the libsybct in INCDIR did not work on my installation. I only have the Open Client, so a recursive search of the installation directory only has the and libsybct64.a in the LIBDIR. I updated the patch on this Bug, because I wasn't sure where else to put it.
 [2010-08-28 17:16 UTC]
I'll look into this the beginning of next week - looks like this can be committed as-is.
 [2010-08-31 14:27 UTC]
Automatic comment from SVN on behalf of thekid
Log: - Add &quot;.so&quot; suffix to checks on libsybct[64] bundles
# See patch by royanee at yahoo dot com @ bug #45357
 [2010-08-31 14:28 UTC]
Automatic comment from SVN on behalf of thekid
Log: - MFT: Add &quot;.so&quot; suffix to checks on libsybct[64] bundles
# See patch by royanee at yahoo dot com @ bug #45357
 [2010-08-31 14:28 UTC]
-Status: Duplicate +Status: Closed
 [2010-08-31 14:28 UTC]
friebe@banane ~/devel/php/PHP_TRUNK/ext/sybase_ct
$ svn ci -m '- Add ".so" suffix to checks on libsybct[64] bundles
> # See patch by royanee at yahoo dot com @ bug #45357' config.m4
Sending        config.m4
Transmitting file data .
Committed revision 302917.

Also commited to PHP_5_3 branch.
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Wed Jun 29 20:05:45 2022 UTC