Building mysql-udf-0.3_2.txz (origin /buildshare/ports/355755/databases/mysql-udf) for powerpc-10-0 on XXX slot2: created x distfiles/ x distfiles/mysql-udf-0.3.tar.gz x packages/ x packages/cmake-2.8.12.1_4.txz x packages/pkg-1.2.7_2.txz x packages/mysql55-client-5.5.37.txz x packages/cmake-modules-2.8.12.1_1.txz ELF ldconfig path: /lib /usr/lib /usr/lib/compat Make depends ===> mysql-udf-0.3_2 depends on file: /usr/local/sbin/pkg - not found ===> Verifying install for /usr/local/sbin/pkg in /buildshare/ports/355755/ports-mgmt/pkg ===> Installing existing package /packages/pkg-1.2.7_2.txz Installing pkg-1.2.7_2... done If you are upgrading from the old package format, first run: # pkg2ng ===> Returning to build of mysql-udf-0.3_2 ===> mysql-udf-0.3_2 depends on shared library: libmysqlclient.so.18 - not found ===> Verifying for libmysqlclient.so.18 in /buildshare/ports/355755/databases/mysql55-client ===> Installing existing package /packages/mysql55-client-5.5.37.txz Installing mysql55-client-5.5.37... done ===> Returning to build of mysql-udf-0.3_2 Make install ===> mysql-udf-0.3_2 depends on file: /usr/local/sbin/pkg - found ===> Fetching all distfiles required by mysql-udf-0.3_2 for building ===> Extracting for mysql-udf-0.3_2 => SHA256 Checksum OK for mysql-udf-0.3.tar.gz. ===> Patching for mysql-udf-0.3_2 ===> Applying FreeBSD patches for mysql-udf-0.3_2 ===> mysql-udf-0.3_2 depends on shared library: libmysqlclient.so.18 - found (/usr/local/lib/mysql/libmysqlclient.so.18) ===> Configuring for mysql-udf-0.3_2 ===> Building for mysql-udf-0.3_2 cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_colwidth.o udf_colwidth.cc && cc -shared -o udf_colwidth.so udf_colwidth.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_colwidth.cc:30: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_confidence_higher.o udf_confidence_higher.cc && cc -shared -o udf_confidence_higher.so udf_confidence_higher.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_confidence_higher.cc:35: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_confidence_lower.o udf_confidence_lower.cc && cc -shared -o udf_confidence_lower.so udf_confidence_lower.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_confidence_lower.cc:35: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_correlation.o udf_correlation.cc && cc -shared -o udf_correlation.so udf_correlation.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_correlation.cc:33: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_faculty.o udf_faculty.cc && cc -shared -o udf_faculty.so udf_faculty.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_faculty.cc:29: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_geomean.o udf_geomean.cc && cc -shared -o udf_geomean.so udf_geomean.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_geomean.cc:31: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_intercept.o udf_intercept.cc && cc -shared -o udf_intercept.so udf_intercept.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_intercept.cc:33: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_kurtosis.o udf_kurtosis.cc && cc -shared -o udf_kurtosis.so udf_kurtosis.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_kurtosis.cc:31: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_longest.o udf_longest.cc && cc -shared -o udf_longest.so udf_longest.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_longest.cc:30: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_median.o udf_median.cc && cc -shared -o udf_median.so udf_median.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_median.cc:31: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_noverm.o udf_noverm.cc && cc -shared -o udf_noverm.so udf_noverm.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_noverm.cc:31: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_skewness.o udf_skewness.cc && cc -shared -o udf_skewness.so udf_skewness.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_skewness.cc:31: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_slope.o udf_slope.cc && cc -shared -o udf_slope.so udf_slope.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_slope.cc:33: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_stdnorm_density.o udf_stdnorm_density.cc && cc -shared -o udf_stdnorm_density.so udf_stdnorm_density.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_stdnorm_density.cc:31: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_stdnorm_dist.o udf_stdnorm_dist.cc && cc -shared -o udf_stdnorm_dist.so udf_stdnorm_dist.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_stdnorm_dist.cc:33: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" cd /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf && cc -O2 -pipe -fno-strict-aliasing -I/usr/local/include/mysql -c -o udf_weightedavg.o udf_weightedavg.cc && cc -shared -o udf_weightedavg.so udf_weightedavg.o In file included from /usr/local/include/mysql/my_global.h:351, from udf_weightedavg.cc:32: /usr/include/sys/timeb.h:42:2: warning: #warning "this file includes which is deprecated" ===> Staging for mysql-udf-0.3_2 ===> Generating temporary packing list /bin/mkdir -p /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_colwidth.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_colwidth.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_confidence_higher.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_confidence_higher.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_confidence_lower.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_confidence_lower.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_correlation.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_correlation.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_faculty.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_faculty.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_geomean.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_geomean.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_intercept.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_intercept.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_kurtosis.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_kurtosis.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_longest.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_longest.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_median.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_median.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_noverm.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_noverm.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_skewness.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_skewness.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_slope.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_slope.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_stdnorm_density.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_stdnorm_density.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_stdnorm_dist.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_stdnorm_dist.so install -s -o root -g wheel -m 555 /obj/buildshare/ports/355755/databases/mysql-udf/work/mysql-udf/udf_weightedavg.so /obj/buildshare/ports/355755/databases/mysql-udf/work/stage/usr/local/lib/mysql/plugin/udf_weightedavg.so ====> Compressing man pages (compress-man) ===> Installing for mysql-udf-0.3_2 ===> Checking if databases/mysql-udf already installed ===> Registering installation for mysql-udf-0.3_2 Installing mysql-udf-0.3_2... done To add the custom functions to your MySQL server use the following syntax: (you may install only the functions you need): CREATE AGGREGATE FUNCTION median RETURNS REAL SONAME 'udf_median.so'; CREATE AGGREGATE FUNCTION correlation RETURNS REAL SONAME 'udf_correlation.so'; CREATE AGGREGATE FUNCTION intercept RETURNS REAL SONAME 'udf_intercept.so'; CREATE AGGREGATE FUNCTION slope RETURNS REAL SONAME 'udf_slope.so'; CREATE AGGREGATE FUNCTION skewness RETURNS REAL SONAME 'udf_skewness.so'; CREATE AGGREGATE FUNCTION kurtosis RETURNS REAL SONAME 'udf_kurtosis.so'; CREATE FUNCTION confidence_higher RETURNS REAL SONAME 'udf_confidence_higher.so'; CREATE FUNCTION confidence_lower RETURNS REAL SONAME 'udf_confidence_lower.so'; CREATE FUNCTION stdnorm_density RETURNS REAL SONAME 'udf_stdnorm_density.so'; CREATE FUNCTION stdnorm_dist RETURNS REAL SONAME 'udf_stdnorm_dist.so'; CREATE AGGREGATE FUNCTION geomean RETURNS REAL SONAME 'udf_geomean.so'; CREATE AGGREGATE FUNCTION weightedavg RETURNS REAL SONAME 'udf_weightedavg.so'; CREATE FUNCTION noverm RETURNS INTEGER SONAME 'udf_noverm.so'; CREATE FUNCTION faculty RETURNS REAL SONAME 'udf_faculty.so'; CREATE AGGREGATE FUNCTION COLWIDTH RETURNS INTEGER SONAME 'udf_colwidth.so'; CREATE AGGREGATE FUNCTION LONGEST RETURNS STRING SONAME 'udf_longest.so'; Example for deinstalling a function: DROP FUNCTION median; For function descriptions, see the following webpage: http://mysql-udf.sourceforge.net/ Make package ===> Building package for mysql-udf-0.3_2 slot2: removed