Update databases/sqlrelay to 1.0.0.

sqlrelay 1.0.0
- updated md5 pwdenc to use rudiments md5 class
- solved a long-standing hang that could occur if the database password
  expired while sqlrelay was running, and the sqlr-scaler attempted to
  start new connections
- added convertcase, convertcasedoublequotes, and removedoublequotes
  parameters to normalize translation module
- added ColumnCaseName parameter to ODBC driver
- fixed a subtle bug in the ODBC driver that caused the first row to be
  skipped if columns were not bound
- added -backtrace option for debugging
- fixed mysql connection module so it can use the statement API on
  Windows
- fixed semaphore reference-before-init bug in sqlrservercontroller
- added support for db, debug, columnnamecase, dontgetcolumninfo,
  nullsasnulls, and lazyconnect connect-string options to all drivers
  (though in some they are camel-case and others lower-case)
- in DB-abstraction-layer drivers, the debug, dontgetcolumninfo,
  nullsasnulls, lazyconnect, krb, and tls connect-string options now
  support any yes/no equivalent such as yes, Yes, y, Y, true, True, 1,
  (and similar for no)
- fixed a regression that could cause crashes in the C#/ADO driver when
  binding null or date values
- added all parameters to ODBC config screen
- removed calls to mysql_stmt_store_result/mysql_stmt_num_rows from
  mysql connection to improve performance. mysql connection doesn't know
  the total number of rows prior to full fetch now (which is consistent
  with most other databases).
- updated postgresql connection to use an unnamed cursor instead of
  naming it and having to deallocate it over an over
- tweaked skipWhitespaceAndComments and related methods to use
  charstring::isNullOrEmpty and character::isWhitespace
- replaced regular expression comparisons in sap/freetds connections
  with simpler charstring comparisons
- updated db2 connection to reuse the statement instead of recreating it
  with each prepare
- made column-lookup by name case sensitive to improve performance
- fixed nagle-disable and sizing of socket read/write buffers
- changed default maxcursors to 5
- fixed an uninitialized variable in the firebird connection
- python api's are installed in dist-packages subdirectory on systems
  that have that instead of site-packages
- added route-entire-session option to router modules

sqlrelay 0.67.0
- general documenation clean-up
- added missing all: target to man/Makefile
- mysql_info in drop-in library for mysql returns NULL instead of "" now
- mysql_errno in the drop-in library now returns the error number from
  the DB, instead of CR_UNKNOWN_ERROR, if no error map is provided, and
  the backend database is known to be mysql
- mysql_refresh in the drop-in library works with options other than
  REFRESH_GRANT now
- mysql_shutdown/kill in the drop-in library return 1 on failure now
  rather than 2000
- date/time and timestamp types are recognized as binary types now
- year/timestamp types are recognized as unsigned types now
- TINY/MEDIUM/LONG_TEXT types are recognized as blobs now
- mapping date/time to MYSQL_TYPE_DATE/TIME, rather than
  MYSQL_TYPE_DATETIME is the default in the drop-in library now and
  SQLR_MAP_DATETIME_TO_DATE has been removed
- mysql drop-in library sets column flags correctly now
- mysql drop-in library runs appropriate kill/shutdown queries now
- mysql connection uses non-stmt api for "show *" queries now
- mysql drop-in library runs "show processlist" for mysql_list_processes
- mysql drop-in library supports date/time/datetime input binds now
  instead of just treating them all as datetimes
- connection modules differentiate between date/time/datetime binds now
  instead of just treating them all as datetimes
- added result set row translation module framework
- updated firebird connection module to the fieldstruct.textbuffer
  instead of fieldbuffer for non-text to text translations
- added support for negative times in mysql connection module and
  drop-in library
- added translation-failure event
- general refactoring of server module API
- consolidated sqlr-scaler code
- fixed a 1-byte empty-blob memory leak in the client
- /etc/alternatives/java_sdk is preferred, if found, now

3 files changed, 28 insertions, 17 deletions

diff --git a/databases/sqlrelay/patches/patch-configure b/databases/sqlrelay/patches/patch-configure
index 448fce341dd..77da3268acb 100644
--- a/databases/sqlrelay/patches/patch-configure
+++ b/databases/sqlrelay/patches/patch-configure
@@ -1,11 +1,21 @@
-$NetBSD: patch-configure,v 1.5 2016/10/21 14:16:34 fhajny Exp $
+$NetBSD: patch-configure,v 1.6 2017/01/16 13:13:13 fhajny Exp $
 
+Cripple iODBC check, we're using UnixODBC and it was getting in the way.
 Fix Python 3 lookup.
 Fix Ruby support.
 
---- configure.orig	2016-07-26 07:55:32.000000000 +0000
+--- configure.orig	2016-12-20 08:40:38.000000000 +0000
 +++ configure
-@@ -32419,12 +32419,12 @@ then
+@@ -26775,7 +26775,7 @@ fi
+ 
+ 
+ 
+-SEARCHPATH=$ODBCPATH
++SEARCHPATH=OFF_$ODBCPATH
+ NAME=iodbc
+ HEADER=sql.h
+ LIBNAME=iodbc
+@@ -32426,12 +32426,12 @@ then
  
  			for i in "3.9" "3.8" "3.7" "3.6" "3.5" "3.4" "3.3" "3.2" "3.1" "3.0"
  			do
@@ -20,7 +30,7 @@ Fix Ruby support.
  					then
  						PYTHON3INCLUDES="-I$PYTHON3PATH/include/python$i"
  						PYTHON3DIR="$PYTHON3PATH/lib/python$i"
-@@ -32914,7 +32914,7 @@ print CONFIG["arch"]
+@@ -32938,7 +32938,7 @@ print CONFIG["arch"]
  print "\n"
  print "ruby_version = "
  begin
diff --git a/databases/sqlrelay/patches/patch-src_api_nodejs_package__in.json b/databases/sqlrelay/patches/patch-src_api_nodejs_package__in.json
new file mode 100644
index 00000000000..32ec522ecb5
--- /dev/null
+++ b/databases/sqlrelay/patches/patch-src_api_nodejs_package__in.json
@@ -0,0 +1,14 @@
+$NetBSD: patch-src_api_nodejs_package__in.json,v 1.1 2017/01/16 13:13:13 fhajny Exp $
+
+npm hates version schemes longer than semver.
+
+--- src/api/nodejs/package_in.json.orig	2016-12-20 08:40:41.000000000 +0000
++++ src/api/nodejs/package_in.json
+@@ -1,6 +1,6 @@
+ {
+ 	"name" : "sqlrelay",
+-	"version" : "@SQLR_VERSION@.0",
++	"version" : "@SQLR_VERSION@",
+ 	"main" : "build/Release/sqlrelay.node",
+ 	"description" : "SQL Relay module for node.js",
+ 	"homepage" : "http://sqlrelay.sourceforge.net",
diff --git a/databases/sqlrelay/patches/patch-src_loggers_custom__sc.cpp b/databases/sqlrelay/patches/patch-src_loggers_custom__sc.cpp
deleted file mode 100644
index ed60a08e065..00000000000
--- a/databases/sqlrelay/patches/patch-src_loggers_custom__sc.cpp
+++ /dev/null
@@ -1,13 +0,0 @@
-$NetBSD: patch-src_loggers_custom__sc.cpp,v 1.1 2014/05/27 09:55:04 joerg Exp $
-
---- src/loggers/custom_sc.cpp.orig	2014-05-23 17:02:08.000000000 +0000
-+++ src/loggers/custom_sc.cpp
-@@ -131,7 +131,7 @@ bool custom_sc::run(sqlrlistener *sqlrl,
- 
- 	// get the client IP, it's needed for some events
- 	const char	*clientaddr="unknown";
--	if (sqlrcon && sqlrcon->cont->connstats->clientaddr) {
-+	if (sqlrcon && sqlrcon->cont->connstats->clientaddr[0]) {
- 		clientaddr=sqlrcon->cont->connstats->clientaddr;
- 	}
-