Compile php5-sybase_ct-5.2.9 with freetds-devel-0.82.1_1,1 in FreeBSD

Dear Sir,

I'm running almost 300 boxes of FreeBSD with PHP 5.2.9 as my Web
Application front-end.

Because my backend DB Server is Sybase ASE 15.0.2, I need to re-build my
php5-sybase_ct-5.2.9 with FreeTDS 0.82(or above). Or I will encounter truncated
problem when column type is Char(n), VarChar(n), Binary(n), and VarBinary(n)
datatypes where n is more than 255 bytes.

Could you please do me a favor ?

Best Regards!

P.S.
1.The following is compiling Error message :<
/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybas e_ct/php_sybase_ct.c:809:
warning: cast from pointer to integer of different size
/bin/sh /usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybas e_ct/libtool
--mode=link cc -DPHP_ATOM_INC
-I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/syb ase_ct/include
-I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/syb ase_ct/main
-I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/syb ase_ct
-I/usr/local/include/php -I/usr/local/include/php/main
-I/usr/local/include/php/TSRM -I/usr/local/include/php/Zend
-I/usr/local/include/php/ext -I/usr/local/include/php/ext/date/lib
-I/usr/local/include -I/usr/local/include/php -DHAVE_CONFIG_H -O3
-fno-strict-aliasing -pipe -march=opteron -o ./sybase_ct.la
-export-dynamic -avoid-version -prefer-pic -module -rpath
/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybas e_ct/modules
php_sybase_ct.lo -lsybtcl -lintl -lcomn -lct -lcs -R/usr/local/lib
-L/usr/local/lib
cc -shared .libs/php_sybase_ct.o -Wl,--rpath -Wl,/usr/local/lib
-Wl,--rpath -Wl,/usr/local/lib -lsybtcl /usr/local/lib/libintl.so
-L/usr/local/lib -lcomn /usr/local/lib/libct.so -L/usr/lib -lcs
-march=opteron -Wl,-soname -Wl,sybase_ct.so -o ./.libs/sybase_ct.so
/usr/bin/ld: cannot find -lsybtcl
*** Error code 1

Stop in /usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybas e_ct.


2.The following are the FreeTDS log:
============================================================ ======
15:51:06.317420 48508 (net.c:542):Received packet
0000 25 00 00 01 0a 05 30 31-30 30 34 00 01 00 b7 00 |%.....01 004.....|
0010 43 68 61 72 61 63 74 65-72 20 6f 72 20 62 69 6e |Characte r or bin|
0020 61 72 79 20 64 61 74 61-20 72 65 74 75 72 6e 65 |ary data returne|
0030 64 20 66 72 6f 6d 20 41-64 61 70 74 69 76 65 20 |d from A daptive |
0040 53 65 72 76 65 72 20 68-61 73 20 62 65 65 6e 20 |Server h as been |
0050 74 72 75 6e 63 61 74 65-64 2e 20 54 68 65 20 63 |truncate d. The c|
0060 6c 69 65 6e 74 20 61 70-70 6c 69 63 61 74 69 6f |lient ap plicatio|
0070 6e 20 64 6f 65 73 20 6e-6f 74 20 73 75 70 70 6f |n does n ot suppo|
0080 72 74 20 6d 6f 72 65 20-74 68 61 6e 20 32 35 35 |rt more than 255|
0090 20 62 79 74 65 73 20 6f-66 20 64 61 74 61 20 61 | bytes o f data a|
00a0 73 20 61 20 72 65 73 75-6c 74 20 63 6f 6c 75 6d |s a resu lt colum|
00b0 6e 20 6f 72 20 6f 75 74-70 75 74 20 70 61 72 61 |n or out put para|
00c0 6d 65 74 65 72 2e 0a 06-64 6f 72 6f 72 6f 00 01 |meter... dororo..|
00d0 00 fd 10 00 02 00 01 00-00 00 |........ ..|
============================================================ ======
i.e. Sybase ASE 15.0.2 response:"Character or binary data returned
from Adaptive Server has been truncated. The client application does
not support more than 255 bytes of data as a result column or output
parameter."

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Compile php5-sybase_ct-5.2.9 with freetds-devel-0.82.1_1,1in FreeBSD ports will Failed!

Hello;

I had several problem installing Sybase 15 64 bit with php 5, I was
using sybase open client libraries and with some twinking I got it to
work, with compile warnings. Have you tried the native Sybase client
libraries?

steven.



James Chang wrote:
> Dear Sir,
>
> I'm running almost 300 boxes of FreeBSD with PHP 5.2.9 as my Web
> Application front-end.
>
> Because my backend DB Server is Sybase ASE 15.0.2, I need to re-build my
> php5-sybase_ct-5.2.9 with FreeTDS 0.82(or above). Or I will encounter truncated
> problem when column type is Char(n), VarChar(n), Binary(n), and VarBinary(n)
> datatypes where n is more than 255 bytes.
>
> Could you please do me a favor ?
>
> Best Regards!
>
> P.S.
> 1.The following is compiling Error message :<
> /usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybas e_ct/php_sybase_ct.c:809:
> warning: cast from pointer to integer of different size
> /bin/sh /usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybas e_ct/libtool
> --mode=link cc -DPHP_ATOM_INC
> -I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/syb ase_ct/include
> -I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/syb ase_ct/main
> -I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/syb ase_ct
> -I/usr/local/include/php -I/usr/local/include/php/main
> -I/usr/local/include/php/TSRM -I/usr/local/include/php/Zend
> -I/usr/local/include/php/ext -I/usr/local/include/php/ext/date/lib
> -I/usr/local/include -I/usr/local/include/php -DHAVE_CONFIG_H -O3
> -fno-strict-aliasing -pipe -march=opteron -o ./sybase_ct.la
> -export-dynamic -avoid-version -prefer-pic -module -rpath
> /usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybas e_ct/modules
> php_sybase_ct.lo -lsybtcl -lintl -lcomn -lct -lcs -R/usr/local/lib
> -L/usr/local/lib
> cc -shared .libs/php_sybase_ct.o -Wl,--rpath -Wl,/usr/local/lib
> -Wl,--rpath -Wl,/usr/local/lib -lsybtcl /usr/local/lib/libintl.so
> -L/usr/local/lib -lcomn /usr/local/lib/libct.so -L/usr/lib -lcs
> -march=opteron -Wl,-soname -Wl,sybase_ct.so -o ./.libs/sybase_ct.so
> /usr/bin/ld: cannot find -lsybtcl
> *** Error code 1
>
> Stop in /usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybas e_ct.
>
>
> 2.The following are the FreeTDS log:
> ============================================================ ======
> 15:51:06.317420 48508 (net.c:542):Received packet
> 0000 25 00 00 01 0a 05 30 31-30 30 34 00 01 00 b7 00 |%.....01 004.....|
> 0010 43 68 61 72 61 63 74 65-72 20 6f 72 20 62 69 6e |Characte r or bin|
> 0020 61 72 79 20 64 61 74 61-20 72 65 74 75 72 6e 65 |ary data returne|
> 0030 64 20 66 72 6f 6d 20 41-64 61 70 74 69 76 65 20 |d from A daptive |
> 0040 53 65 72 76 65 72 20 68-61 73 20 62 65 65 6e 20 |Server h as been |
> 0050 74 72 75 6e 63 61 74 65-64 2e 20 54 68 65 20 63 |truncate d. The c|
> 0060 6c 69 65 6e 74 20 61 70-70 6c 69 63 61 74 69 6f |lient ap plicatio|
> 0070 6e 20 64 6f 65 73 20 6e-6f 74 20 73 75 70 70 6f |n does n ot suppo|
> 0080 72 74 20 6d 6f 72 65 20-74 68 61 6e 20 32 35 35 |rt more than 255|
> 0090 20 62 79 74 65 73 20 6f-66 20 64 61 74 61 20 61 | bytes o f data a|
> 00a0 73 20 61 20 72 65 73 75-6c 74 20 63 6f 6c 75 6d |s a resu lt colum|
> 00b0 6e 20 6f 72 20 6f 75 74-70 75 74 20 70 61 72 61 |n or out put para|
> 00c0 6d 65 74 65 72 2e 0a 06-64 6f 72 6f 72 6f 00 01 |meter... dororo..|
> 00d0 00 fd 10 00 02 00 01 00-00 00 |........ ..|
> ============================================================ ======
> i.e. Sybase ASE 15.0.2 response:"Character or binary data returned
> from Adaptive Server has been truncated. The client application does
> not support more than 255 bytes of data as a result column or output
> parameter."
>
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php