From owner-freebsd-ports@FreeBSD.ORG Thu Mar 26 08:57:06 2009 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 33BCB1065707 for ; Thu, 26 Mar 2009 08:57:06 +0000 (UTC) (envelope-from james.technew@gmail.com) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.183]) by mx1.freebsd.org (Postfix) with ESMTP id 0A3FD8FC23 for ; Thu, 26 Mar 2009 08:57:05 +0000 (UTC) (envelope-from james.technew@gmail.com) Received: by wa-out-1112.google.com with SMTP id m38so304603waf.27 for ; Thu, 26 Mar 2009 01:57:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type:content-transfer-encoding; bh=S5tlU9DGFDyPYEa8Gwj9lXjkpXh1fYIhif0byt+oE+o=; b=kL4pX5ryD0C75zyLUqYRVmhZFg/ewIuFCYQa5Qs6Wj0HsIxRSmTRUeXhAff3aiExHC L1hIW6wYYWXFz9CeM1X8RXwtx1bW4HVa3GjE754bvv6XELGAm1Wzx4t7nr1aXiWv358N UJm36uvjRTaXbTD2eeDoXCsEneO9k/UrPPtX4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type :content-transfer-encoding; b=c8/mgKib4DwglCtqDxiYexEaAyjWgVCR/opC+uHASFxT15e86rX7Evv3heqypJHr11 LHq7v6dvL44iq+SkC7vhwEUi8yffO4o/9xs+zyHpllDhvd3QrBo1DWUg6ZVlH3aJzX2q 9aBRPz2F8fJc6dRjy2ccGj+DHFdMS8W74tBao= MIME-Version: 1.0 Received: by 10.114.61.1 with SMTP id j1mr413782waa.207.1238056460364; Thu, 26 Mar 2009 01:34:20 -0700 (PDT) Date: Thu, 26 Mar 2009 16:34:20 +0800 Message-ID: From: James Chang To: freebsd-ports@freebsd.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Subject: Compile php5-sybase_ct-5.2.9 with freetds-devel-0.82.1_1, 1 in FreeBSD ports will Failed! X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 26 Mar 2009 08:57:07 -0000 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."