[pkgsrc/trunk]: pkgsrc/databases Update databases/sqlrelay and sub-packages t...

[fhajny <fhajny%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/79f7876e253c
branches:  trunk
changeset: 354185:79f7876e253c
user:      fhajny <fhajny%pkgsrc.org@localhost>
date:      Fri Oct 21 14:16:34 2016 +0000

description:
Update databases/sqlrelay and sub-packages to 0.66.0.

New features:

- Notification Modules
- Connection Schedules
- Query Router Modules

Full changelog:

- fixed mysql set isolation level query
- updated mysql connection to run commit/rollback at the end of every
  session even if only selects were run, to make sure metadata locks are
  released
- renamed sqlrclientexitstatus_t to clientsessionexitstatus_t
- updated all db connection modules to reinit the column count during
  prepare rather than execute
- fixed bug where server-side errors set by conn/cursor->setError()
  could inadverntantly be overriden during the next call to
  conn/cursor->errorMessage()
- added several more queries to mysql stmt-api blacklist
- configure option --disable-odbc-driver actually works now
- filters can specify an error string and error number now
- added support for systemd
- fixed a memory leak by applying and updating a patch from Kasyanov
  Dmitry to deallocate the error message in C++ API destructor
- legacy_stdio_definitions.lib is now included when building ODBC with
  VS2015
- added support for PHP7
- added -wait option to sqlr-start for non-Windows
- disabled -disable-new-window option to sqlr-start for non-Windows
- non-ascii character encodings work with the C# API now
- rudiments prompt class is used instead of using readline directly now
- renamed "logger-events" to just "events"
- added notification framework and "events" module
- added connection schedule framework and "cron" module
- applied sec/usec patch from samchuck at neowiz to custom_nw logger to
  fix subtle time calculation error
- applied a patch from samchuck at neowiz to the sqlrclient protocol
  module to deallocate storage for bind variables after logging the
  query to resolve a reference-after-free bug
- added router module framework with "regex", "userlist" and
  "clientiplist" modules
- when router detects a possible integrity violation now, it raises an
  event which can be logged or trigger a notification and disables the
  instance
- router calls begin, commit, and rollback on all connections now, even
  if they're executed as queries rather than using the api methods
- removed tls_userlist/krb_userlist auth modules and updated the
  userlist auth module to support tls and kerberos auth
- converted most of the doc source to wikitext
- fixed ODBC driver bug that could corrupt memory and trick the driver
  manager into thinking that some basic functions are unavailable
- ODBC SQLTables works more correctly now
- fixed an ODBC bug that caused the first row to be fetched twice when
  using SQLBindCol

diffstat:

 databases/p5-sqlrelay/Makefile             |   3 +-
 databases/php-sqlrelay/Makefile            |   5 +-
 databases/py-sqlrelay/Makefile             |  13 +++++--
 databases/ruby-sqlrelay/Makefile           |   3 +-
 databases/sqlrelay-freetds/Makefile        |   3 +-
 databases/sqlrelay-mysql/Makefile          |   3 +-
 databases/sqlrelay-nodejs/Makefile         |   3 +-
 databases/sqlrelay-odbc/Makefile           |   3 +-
 databases/sqlrelay-pgsql/Makefile          |   3 +-
 databases/sqlrelay-sqlite/Makefile         |   3 +-
 databases/sqlrelay/Makefile                |   5 +-
 databases/sqlrelay/Makefile.common         |   5 +-
 databases/sqlrelay/PLIST                   |  15 +++++++-
 databases/sqlrelay/buildlink3.mk           |   5 +-
 databases/sqlrelay/distinfo                |  12 +++---
 databases/sqlrelay/patches/patch-configure |  50 ++++++++++++------------------
 16 files changed, 63 insertions(+), 71 deletions(-)

diffs (truncated from 373 to 300 lines):

diff -r a92649d83dd5 -r 79f7876e253c databases/p5-sqlrelay/Makefile
--- a/databases/p5-sqlrelay/Makefile    Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/p5-sqlrelay/Makefile    Fri Oct 21 14:16:34 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2016/10/07 18:25:41 adam Exp $
+# $NetBSD: Makefile,v 1.11 2016/10/21 14:16:34 fhajny Exp $
 
 PKGNAME=               p5-${DISTNAME}
-PKGREVISION=           1
 COMMENT=               Perl module for SQL Relay
 
 .include "../../databases/sqlrelay/Makefile.common"
diff -r a92649d83dd5 -r 79f7876e253c databases/php-sqlrelay/Makefile
--- a/databases/php-sqlrelay/Makefile   Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/php-sqlrelay/Makefile   Fri Oct 21 14:16:34 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2016/10/07 18:25:41 adam Exp $
+# $NetBSD: Makefile,v 1.7 2016/10/21 14:16:34 fhajny Exp $
 
 PKGNAME=               ${PHP_PKG_PREFIX}-${DISTNAME}
-PKGREVISION=           1
 COMMENT=               PHP extension for SQL Relay
 EXTRACT_SUFX=          .tar.gz
 
@@ -9,7 +8,7 @@
 
 LICENSE=               gnu-gpl-v2 AND php
 
-PHP_VERSIONS_ACCEPTED= 56
+PHP_VERSIONS_ACCEPTED= 56 70
 
 CONFIGURE_ARGS+=       --with-php-prefix=${BUILDLINK_PREFIX.php}
 
diff -r a92649d83dd5 -r 79f7876e253c databases/py-sqlrelay/Makefile
--- a/databases/py-sqlrelay/Makefile    Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/py-sqlrelay/Makefile    Fri Oct 21 14:16:34 2016 +0000
@@ -1,19 +1,24 @@
-# $NetBSD: Makefile,v 1.7 2016/10/07 18:25:41 adam Exp $
+# $NetBSD: Makefile,v 1.8 2016/10/21 14:16:34 fhajny Exp $
 
 PKGNAME=               ${PYPKGPREFIX}-${DISTNAME}
-PKGREVISION=           1
 COMMENT=               Python extension for SQL Relay
 
 .include "../../databases/sqlrelay/Makefile.common"
 
 LICENSE=               modified-bsd
 
+.include "../../lang/python/pyversion.mk"
+
+.if ${PYPKGPREFIX} == "py27"
+CONFIGURE_ARGS+=       --disable-python3
 CONFIGURE_ARGS+=       --with-python-prefix=${PREFIX}
+.else
+CONFIGURE_ARGS+=       --disable-python2
+CONFIGURE_ARGS+=       --with-python3-prefix=${PREFIX}
+.endif
 
 BUILD_DIRS=            src/api/python
 
-PYTHON_VERSIONS_INCOMPATIBLE=  34 35 # not yet ported as of 0.55
-
 PY_PATCHPLIST=         yes
 
 .include "../../databases/sqlrelay/buildlink3.mk"
diff -r a92649d83dd5 -r 79f7876e253c databases/ruby-sqlrelay/Makefile
--- a/databases/ruby-sqlrelay/Makefile  Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/ruby-sqlrelay/Makefile  Fri Oct 21 14:16:34 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2016/10/07 18:25:41 adam Exp $
+# $NetBSD: Makefile,v 1.6 2016/10/21 14:16:34 fhajny Exp $
 
 COMMENT=               Ruby extension for SQL Relay
-PKGREVISION=           1
 
 .include "../../databases/sqlrelay/Makefile.common"
 
diff -r a92649d83dd5 -r 79f7876e253c databases/sqlrelay-freetds/Makefile
--- a/databases/sqlrelay-freetds/Makefile       Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/sqlrelay-freetds/Makefile       Fri Oct 21 14:16:34 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.8 2016/10/07 18:25:41 adam Exp $
+# $NetBSD: Makefile,v 1.9 2016/10/21 14:16:35 fhajny Exp $
 
 PKGNAME=               ${DISTNAME:S/sqlrelay/sqlrelay-freetds/}
-PKGREVISION=           2
 COMMENT=               FreeTDS support for SQL Relay
 
 .include "../../databases/sqlrelay/Makefile.common"
diff -r a92649d83dd5 -r 79f7876e253c databases/sqlrelay-mysql/Makefile
--- a/databases/sqlrelay-mysql/Makefile Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/sqlrelay-mysql/Makefile Fri Oct 21 14:16:34 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2016/10/07 18:25:41 adam Exp $
+# $NetBSD: Makefile,v 1.6 2016/10/21 14:16:35 fhajny Exp $
 
 PKGNAME=               ${DISTNAME:S/sqlrelay/sqlrelay-mysql/}
-PKGREVISION=           1
 COMMENT=               MySQL support for SQL Relay
 
 .include "../../databases/sqlrelay/Makefile.common"
diff -r a92649d83dd5 -r 79f7876e253c databases/sqlrelay-nodejs/Makefile
--- a/databases/sqlrelay-nodejs/Makefile        Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/sqlrelay-nodejs/Makefile        Fri Oct 21 14:16:34 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2016/10/07 18:25:41 adam Exp $
+# $NetBSD: Makefile,v 1.6 2016/10/21 14:16:35 fhajny Exp $
 
 PKGNAME=               ${DISTNAME:S/sqlrelay/sqlrelay-nodejs/}
-PKGREVISION=           1
 COMMENT=               node.js API for SQL Relay
 
 .include "../../databases/sqlrelay/Makefile.common"
diff -r a92649d83dd5 -r 79f7876e253c databases/sqlrelay-odbc/Makefile
--- a/databases/sqlrelay-odbc/Makefile  Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/sqlrelay-odbc/Makefile  Fri Oct 21 14:16:34 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.8 2016/10/07 18:25:41 adam Exp $
+# $NetBSD: Makefile,v 1.9 2016/10/21 14:16:35 fhajny Exp $
 
 PKGNAME=               ${DISTNAME:S/sqlrelay/sqlrelay-odbc/}
-PKGREVISION=           1
 COMMENT=               ODBC support for SQL Relay
 
 .include "../../databases/sqlrelay/Makefile.common"
diff -r a92649d83dd5 -r 79f7876e253c databases/sqlrelay-pgsql/Makefile
--- a/databases/sqlrelay-pgsql/Makefile Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/sqlrelay-pgsql/Makefile Fri Oct 21 14:16:34 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2016/10/09 21:41:58 wiz Exp $
+# $NetBSD: Makefile,v 1.7 2016/10/21 14:16:35 fhajny Exp $
 
 PKGNAME=               ${DISTNAME:S/sqlrelay/sqlrelay-pgsql/}
-PKGREVISION=           2
 COMMENT=               PostgreSQL support for SQL Relay
 
 .include "../../databases/sqlrelay/Makefile.common"
diff -r a92649d83dd5 -r 79f7876e253c databases/sqlrelay-sqlite/Makefile
--- a/databases/sqlrelay-sqlite/Makefile        Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/sqlrelay-sqlite/Makefile        Fri Oct 21 14:16:34 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2016/10/07 18:25:42 adam Exp $
+# $NetBSD: Makefile,v 1.10 2016/10/21 14:16:35 fhajny Exp $
 
 PKGNAME=               ${DISTNAME:S/sqlrelay/sqlrelay-sqlite/}
-PKGREVISION=           1
 COMMENT=               SQLite support for SQL Relay
 
 .include "../../databases/sqlrelay/Makefile.common"
diff -r a92649d83dd5 -r 79f7876e253c databases/sqlrelay/Makefile
--- a/databases/sqlrelay/Makefile       Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/sqlrelay/Makefile       Fri Oct 21 14:16:34 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.49 2016/10/07 18:25:31 adam Exp $
+# $NetBSD: Makefile,v 1.50 2016/10/21 14:16:34 fhajny Exp $
 
 COMMENT=               Database connection pooling middleware and API
-PKGREVISION=           2
 
 .include "../../databases/sqlrelay/Makefile.common"
 
@@ -12,7 +11,7 @@
                        --disable-mysql --disable-odbc --disable-oracle         \
                        --disable-perl --disable-php --disable-postgresql       \
                        --disable-python --disable-ruby --disable-sqlite        \
-                       --disable-sybase --disable-tcl --disable-nodejs
+                       --disable-sap --disable-tcl --disable-nodejs
 
 INSTALL_MAKE_FLAGS+=   EXAMPLEDIR=${DESTDIR}${EGDIR}
 
diff -r a92649d83dd5 -r 79f7876e253c databases/sqlrelay/Makefile.common
--- a/databases/sqlrelay/Makefile.common        Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/sqlrelay/Makefile.common        Fri Oct 21 14:16:34 2016 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.12 2016/07/01 17:02:39 fhajny Exp $
+# $NetBSD: Makefile.common,v 1.13 2016/10/21 14:16:34 fhajny Exp $
 # used by databases/p5-sqlrelay/Makefile
 # used by databases/php-sqlrelay/Makefile
 # used by databases/py-sqlrelay/Makefile
@@ -11,7 +11,7 @@
 # used by databases/sqlrelay-sqlite/Makefile
 # used by databases/sqlrelay/Makefile
 
-DISTNAME=              sqlrelay-0.65.0
+DISTNAME=              sqlrelay-0.66.0
 CATEGORIES=            databases
 MASTER_SITES=          ${MASTER_SITE_SOURCEFORGE:=sqlrelay/}
 
@@ -47,4 +47,3 @@
 
 .include "../../devel/rudiments/buildlink3.mk"
 .include "../../mk/pthread.buildlink3.mk"
-.include "../../mk/readline.buildlink3.mk"
diff -r a92649d83dd5 -r 79f7876e253c databases/sqlrelay/PLIST
--- a/databases/sqlrelay/PLIST  Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/sqlrelay/PLIST  Fri Oct 21 14:16:34 2016 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.17 2016/07/01 17:02:39 fhajny Exp $
+@comment $NetBSD: PLIST,v 1.18 2016/10/21 14:16:34 fhajny Exp $
 bin/sqlr-cachemanager
 bin/sqlr-connection
 bin/sqlr-export
@@ -54,10 +54,8 @@
 lib/pkgconfig/sqlrelay-c++.pc
 lib/pkgconfig/sqlrelay-c.pc
 libexec/sqlrelay/sqlrauth_database.${SOEXT}
-libexec/sqlrelay/sqlrauth_krb_userlist.${SOEXT}
 libexec/sqlrelay/sqlrauth_proxied.${SOEXT}
 libexec/sqlrelay/sqlrauth_sqlrelay.${SOEXT}
-libexec/sqlrelay/sqlrauth_tls_userlist.${SOEXT}
 libexec/sqlrelay/sqlrauth_userlist.${SOEXT}
 libexec/sqlrelay/sqlrconfig_xmldom.${SOEXT}
 libexec/sqlrelay/sqlrconnection_router.${SOEXT}
@@ -68,6 +66,7 @@
 libexec/sqlrelay/sqlrlogger_custom_sc.${SOEXT}
 libexec/sqlrelay/sqlrlogger_debug.${SOEXT}
 libexec/sqlrelay/sqlrlogger_slowqueries.${SOEXT}
+libexec/sqlrelay/sqlrnotification_events.${SOEXT}
 libexec/sqlrelay/sqlrparser_default.${SOEXT}
 libexec/sqlrelay/sqlrprotocol_sqlrclient.${SOEXT}
 libexec/sqlrelay/sqlrpwdenc_crypt.${SOEXT}
@@ -76,6 +75,10 @@
 libexec/sqlrelay/sqlrquery_sqlrcmdcstat.${SOEXT}
 libexec/sqlrelay/sqlrquery_sqlrcmdgstat.${SOEXT}
 libexec/sqlrelay/sqlrresultsettranslation_reformatdatetime.${SOEXT}
+libexec/sqlrelay/sqlrrouter_clientiplist.${SOEXT}
+libexec/sqlrelay/sqlrrouter_regex.${SOEXT}
+libexec/sqlrelay/sqlrrouter_userlist.${SOEXT}
+libexec/sqlrelay/sqlrschedule_cron_userlist.${SOEXT}
 libexec/sqlrelay/sqlrtranslation_normalize.${SOEXT}
 man/man1/sqlr-export.1
 man/man1/sqlr-import.1
@@ -602,6 +605,7 @@
 share/doc/sqlrelay/features/queryfiltering.html
 share/doc/sqlrelay/features/queryrouting.html
 share/doc/sqlrelay/features/resultsetcaching.html
+share/doc/sqlrelay/features/schedules.html
 share/doc/sqlrelay/features/substitutionandbindvars.html
 share/doc/sqlrelay/features/suspendedtx.html
 share/doc/sqlrelay/features/throttling.html
@@ -614,6 +618,7 @@
 share/doc/sqlrelay/images/arm-linux-uclibc.png
 share/doc/sqlrelay/images/blackray.png
 share/doc/sqlrelay/images/cluster.png
+share/doc/sqlrelay/images/dayshift.png
 share/doc/sqlrelay/images/fetch-many.png
 share/doc/sqlrelay/images/fetch-one.png
 share/doc/sqlrelay/images/firebird.png
@@ -642,6 +647,7 @@
 share/doc/sqlrelay/images/netbsd-sparc.png
 share/doc/sqlrelay/images/netbsd-vax-thumb.png
 share/doc/sqlrelay/images/netbsd-vax.png
+share/doc/sqlrelay/images/nightshift.png
 share/doc/sqlrelay/images/openbsd-i386-thumb.png
 share/doc/sqlrelay/images/openbsd-i386.png
 share/doc/sqlrelay/images/openbsd-sparc-thumb.png
@@ -678,8 +684,11 @@
 share/doc/sqlrelay/modules/auths.html
 share/doc/sqlrelay/modules/filters.html
 share/doc/sqlrelay/modules/loggers.html
+share/doc/sqlrelay/modules/notifications.html
 share/doc/sqlrelay/modules/pwdencs.html
 share/doc/sqlrelay/modules/resultsettranslations.html
+share/doc/sqlrelay/modules/routers.html
+share/doc/sqlrelay/modules/schedules.html
 share/doc/sqlrelay/modules/sqlr-connection-oracletest-querylog.2899.html
 share/doc/sqlrelay/modules/sqlr-connection.1871.html
 share/doc/sqlrelay/modules/sqlr-listener.1869.html
diff -r a92649d83dd5 -r 79f7876e253c databases/sqlrelay/buildlink3.mk
--- a/databases/sqlrelay/buildlink3.mk  Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/sqlrelay/buildlink3.mk  Fri Oct 21 14:16:34 2016 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: buildlink3.mk,v 1.5 2016/10/07 18:25:31 adam Exp $
+# $NetBSD: buildlink3.mk,v 1.6 2016/10/21 14:16:34 fhajny Exp $
 
 BUILDLINK_TREE+=       sqlrelay
 
@@ -6,12 +6,11 @@
 SQLRELAY_BUILDLINK3_MK:=
 
 BUILDLINK_API_DEPENDS.sqlrelay+=       sqlrelay>=0.43
-BUILDLINK_ABI_DEPENDS.sqlrelay+=       sqlrelay>=0.65.0nb2
+BUILDLINK_ABI_DEPENDS.sqlrelay+=       sqlrelay>=0.66.0
 BUILDLINK_PKGSRCDIR.sqlrelay?=         ../../databases/sqlrelay
 
 .include "../../devel/rudiments/buildlink3.mk"
 .include "../../mk/pthread.buildlink3.mk"
-.include "../../mk/readline.buildlink3.mk"
 .endif # SQLRELAY_BUILDLINK3_MK
 
 BUILDLINK_TREE+=       -sqlrelay
diff -r a92649d83dd5 -r 79f7876e253c databases/sqlrelay/distinfo
--- a/databases/sqlrelay/distinfo       Fri Oct 21 13:57:10 2016 +0000
+++ b/databases/sqlrelay/distinfo       Fri Oct 21 14:16:34 2016 +0000
@@ -1,12 +1,12 @@
-$NetBSD: distinfo,v 1.20 2016/07/01 17:02:39 fhajny Exp $
+$NetBSD: distinfo,v 1.21 2016/10/21 14:16:34 fhajny Exp $
 
-SHA1 (sqlrelay-0.65.0.tar.gz) = 7649fc14a95009ffaeb56f12abe70e526c4eb099
-RMD160 (sqlrelay-0.65.0.tar.gz) = f83b9372da1283bd35f62761c522c0cdd25dd536