notbugIf you buy from Amazon USA, please support us by using this link.
Port details
mysql-udf Set of user-defined functions for the MySQL server
0.3_3 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port

There is no maintainer for this port.
Any concerns regarding this port should be directed to the FreeBSD Ports mailing list via ports@FreeBSD.org search for ports maintained by this maintainer
Port Added: 10 Apr 2008 16:31:12
License: not specified in port
This package adds several user-defined statistics functions
to the MySQL server providing the ability to:

    * calculate the median of any values,
    * calculate the skewness and kurtosis of a distribution of value
    * retrieve the effective length of the longest value in a STRING column,
    * get the longest value from a STRING column,
    * calculate the faculty of a value,
    * calculate linear regression parameters (intercept, slope, correlation
      coefficent) of any values

WWW: http://mysql-udf.sourceforge.net/
SVNWeb : Homepage : PortsMon
    Pseudo-pkg-plist information, but much better, from make generate-plist
    Expand this list (16 items)
  1. lib/mysql/plugin/udf_colwidth.so
  2. lib/mysql/plugin/udf_confidence_higher.so
  3. lib/mysql/plugin/udf_confidence_lower.so
  4. lib/mysql/plugin/udf_correlation.so
  5. lib/mysql/plugin/udf_faculty.so
  6. lib/mysql/plugin/udf_geomean.so
  7. lib/mysql/plugin/udf_intercept.so
  8. lib/mysql/plugin/udf_kurtosis.so
  9. lib/mysql/plugin/udf_longest.so
  10. lib/mysql/plugin/udf_median.so
  11. lib/mysql/plugin/udf_noverm.so
  12. lib/mysql/plugin/udf_skewness.so
  13. lib/mysql/plugin/udf_slope.so
  14. lib/mysql/plugin/udf_stdnorm_density.so
  15. lib/mysql/plugin/udf_stdnorm_dist.so
  16. lib/mysql/plugin/udf_weightedavg.so
  17. Collapse this list.

To install the port: cd /usr/ports/databases/mysql-udf/ && make install clean
To add the package: pkg install mysql-udf

PKGNAME: mysql-udf

distinfo:

TIMESTAMP = 1467549429
SHA256 (mysql-udf-0.3.tar.gz) = d9115aeecccfc06ccdc209a761a6a4d0dba70f15c9319ab76d173b04737beaf2
SIZE (mysql-udf-0.3.tar.gz) = 6714


NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Library dependencies:
  1. libmysqlclient.so.18 : databases/mysql56-client
There are no ports dependent upon this port

Configuration Options
     No options to configure

USES:
mysql

pkg-message:
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/

Master Sites:
  1. http://cytranet.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  2. http://downloads.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  3. http://excellmedia.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  4. http://freefr.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  5. http://jaist.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  6. http://kent.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  7. http://nchc.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  8. http://netcologne.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  9. http://netix.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  10. http://superb-dca2.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  11. http://superb-sea2.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  12. http://ufpr.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  13. http://vorboss.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  14. https://cytranet.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  15. https://downloads.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  16. https://excellmedia.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  17. https://freefr.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  18. https://jaist.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  19. https://kent.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  20. https://nchc.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  21. https://netcologne.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  22. https://netix.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  23. https://superb-dca2.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  24. https://superb-sea2.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  25. https://ufpr.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/
  26. https://vorboss.dl.sourceforge.net/project/mysql-udf/mysql-udf/mysql-udf-0.3/

Number of commits found: 15

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
18 Sep 2018 20:09:03
Original commit files touched by this commit  0.3_3
Revision:480077
emaste search for other commits by this committer
databases/mysql-udf: enable PIC on arm64 and i386, for lld

Shared objects should be built as PIC, and lld enforces this by default.
Add aarch64 and i386 cases to the existing set of per-arch CFLAGS, and
remove the BROKEN_aarch64.

Approved by:	portmgr (lld blanket)
Sponsored by:	The FreeBSD Foundation
07 Jul 2018 06:44:07
Original commit files touched by this commit  0.3_2
Revision:474058
linimon search for other commits by this committer
Mark these ports as broken on aarch64, and, where appropriate, armvX.

While here, pet portlint and modernize.

Approved by:	portmgr (tier-2 blanket)
03 Jul 2016 12:43:28
Original commit files touched by this commit  0.3_2
Revision:417969
brnrd search for other commits by this committer
databases/mysql-udf: Fix building with MariaDB

  - Work around MySQL's include/mysql/mysql directory
    - Add -I ${LOCALBASE}/include to CFLAGS
  - Move from USE_MYSQL to USES= mysql

PR:		199556
19 May 2016 10:21:25
Original commit files touched by this commit  0.3_2
Revision:415498
amdmi3 search for other commits by this committer
- Fix trailing whitespace in pkg-descrs, categories [a-f]*

Approved by:	portmgr blanket
20 Dec 2014 17:40:54
Original commit files touched by this commit  0.3_2
Revision:375020
bapt search for other commits by this committer
Cleanup plist
16 May 2014 03:29:50
Original commit files touched by this commit  0.3_2
Revision:354194
vanilla search for other commits by this committer
Support STAGEDIR.
20 Sep 2013 16:13:49
Original commit files touched by this commit  0.3_2
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
29 Nov 2011 21:53:32
Original commit files touched by this commit  0.3_2
pawel search for other commits by this committer
- Install files to correct plugins path [1]
- Do silent cat pkg-message

http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_plugin_dir

PR:             ports/162562 [1]
Submitted by:   Panagiotis Christias <p.christias@noc.ntua.gr> [1]

Feature safe:   yes
22 Oct 2011 23:50:23
Original commit files touched by this commit  0.3_1
eadler search for other commits by this committer
- remove maintainer tags from pkg-descr

Approved by:    portmgr
Approved by:    bapt (mentor)
17 Oct 2011 04:35:02
Original commit files touched by this commit  0.3_1
dougb search for other commits by this committer
Remove references to mysql 323 and 40, most commonly of the form:

IGNORE_WITH_MYSQL=     323 40
09 Aug 2011 15:41:30
Original commit files touched by this commit  0.3_1
mm search for other commits by this committer
Transfer maintainer back to ports@FreeBSD.org

Approved by:    maintainer (myself)
20 Mar 2011 12:54:45
Original commit files touched by this commit  0.3_1
miwi search for other commits by this committer
- Get Rid MD5 support
19 Mar 2011 13:15:34
Original commit files touched by this commit  0.3_1
ale search for other commits by this committer
Bump PORTREVISION for ports linking to default libmysqlclient.
22 Aug 2009 00:18:43
Original commit files touched by this commit  0.3
amdmi3 search for other commits by this committer
- Switch SourceForge ports to the new File Release System: categories starting
with D
10 Apr 2008 16:30:29
Original commit files touched by this commit  0.3
mm search for other commits by this committer
This package adds several user-defined statistical functions
to the MySQL server providing the ability to:

    * calculate the median of any values,
    * calculate the skewness and kurtosis of a distribution of value
    * retrieve the effective length of the longest value in a STRING column,
    * get the longest value from a STRING column,
    * calculate the faculty of a value,
    * calculate linear regression parameters (intercept, slope, correlation
      coefficent) of any values

WWW: http://mysql-udf.sourceforge.net/

Number of commits found: 15

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
mantisSep 25
openjpeg*Sep 25
mediawiki127Sep 22
mediawiki129Sep 22
mediawiki130Sep 22
rubygem-smart_proxy_dynflowSep 22
asterisk13Sep 21
asterisk15Sep 21
firefoxSep 21
firefox-esrSep 21
moodle31Sep 18
moodle33Sep 18
firefox*Sep 15
firefox-esr*Sep 15
joomla3Sep 15

15 vulnerabilities affecting 121 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2018-09-25 17:12:35


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 35312
Broken 51
Deprecated 322
Ignore 303
Forbidden 5
Restricted 162
No CDROM 74
Vulnerable 36
Expired 8
Set to expire 308
Interactive 0
new 24 hours 3
new 48 hours20
new 7 days127
new fortnight244
new month1021

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2018 Dan Langille. All rights reserved.