FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

We also have a status page: https://freshports.wordpress.com/

Port details
mysql-udf Set of user-defined functions for the MySQL server
0.3_2 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: 13

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
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: 13

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
curl*Dec 11
linux-c7-curl*Dec 11
wiresharkDec 10
procmail*Dec 08
opensslDec 07
firefoxDec 05
firefox-esrDec 05
linux-firefoxDec 05
linux-seamonkeyDec 05
seamonkeyDec 05
waterfoxDec 05
mybbDec 02
varnish4Dec 02
varnish5Dec 02
asterisk13Dec 01

14 vulnerabilities affecting 78 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2017-12-11 14:55:48


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 32120
Broken 121
Deprecated 43
Ignore 356
Forbidden 0
Restricted 173
No CDROM 77
Vulnerable 44
Expired 14
Set to expire 35
Interactive 0
new 24 hours 8
new 48 hours11
new 7 days77
new fortnight18993
new month48558

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