Date: Thu, 26 Mar 2009 16:34:20 +0800 From: James Chang <james.technew@gmail.com> To: freebsd-ports@freebsd.org Subject: Compile php5-sybase_ct-5.2.9 with freetds-devel-0.82.1_1, 1 in FreeBSD ports will Failed! Message-ID: <a951c2910903260134k7b35af6u5690233541889b0b@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
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 ? Or my boss will ask me kill
these FreeBSD Box and install Linux on these boxes (in order to use
sybase's Open
Client, which ONLY support Linux).If so, it will be nightmare scenario:<
Best Regards!
P.S.
1.The following is compiling Error message :<
/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_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/sybase_ct/libtool
--mode=link cc -DPHP_ATOM_INC
-I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/include
-I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_ct/main
-I/usr/ports/databases/php5-sybase_ct/work/php-5.2.9/ext/sybase_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/sybase_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/sybase_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."
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?a951c2910903260134k7b35af6u5690233541889b0b>