head 1.30; access; symbols pkgsrc-2023Q4:1.30.0.10 pkgsrc-2023Q4-base:1.30 pkgsrc-2023Q3:1.30.0.8 pkgsrc-2023Q3-base:1.30 pkgsrc-2023Q2:1.30.0.6 pkgsrc-2023Q2-base:1.30 pkgsrc-2023Q1:1.30.0.4 pkgsrc-2023Q1-base:1.30 pkgsrc-2022Q4:1.30.0.2 pkgsrc-2022Q4-base:1.30 pkgsrc-2022Q3:1.29.0.8 pkgsrc-2022Q3-base:1.29 pkgsrc-2022Q2:1.29.0.6 pkgsrc-2022Q2-base:1.29 pkgsrc-2022Q1:1.29.0.4 pkgsrc-2022Q1-base:1.29 pkgsrc-2021Q4:1.29.0.2 pkgsrc-2021Q4-base:1.29 pkgsrc-2021Q3:1.27.0.6 pkgsrc-2021Q3-base:1.27 pkgsrc-2021Q2:1.27.0.4 pkgsrc-2021Q2-base:1.27 pkgsrc-2021Q1:1.27.0.2 pkgsrc-2021Q1-base:1.27 pkgsrc-2020Q4:1.25.0.12 pkgsrc-2020Q4-base:1.25 pkgsrc-2020Q3:1.25.0.10 pkgsrc-2020Q3-base:1.25 pkgsrc-2020Q2:1.25.0.8 pkgsrc-2020Q2-base:1.25 pkgsrc-2020Q1:1.25.0.4 pkgsrc-2020Q1-base:1.25 pkgsrc-2019Q4:1.25.0.6 pkgsrc-2019Q4-base:1.25 pkgsrc-2019Q3:1.25.0.2 pkgsrc-2019Q3-base:1.25 pkgsrc-2019Q2:1.24.0.10 pkgsrc-2019Q2-base:1.24 pkgsrc-2019Q1:1.24.0.8 pkgsrc-2019Q1-base:1.24 pkgsrc-2018Q4:1.24.0.6 pkgsrc-2018Q4-base:1.24 pkgsrc-2018Q3:1.24.0.4 pkgsrc-2018Q3-base:1.24 pkgsrc-2018Q2:1.24.0.2 pkgsrc-2018Q2-base:1.24 pkgsrc-2018Q1:1.23.0.10 pkgsrc-2018Q1-base:1.23 pkgsrc-2017Q4:1.23.0.8 pkgsrc-2017Q4-base:1.23 pkgsrc-2017Q3:1.23.0.6 pkgsrc-2017Q3-base:1.23 pkgsrc-2017Q2:1.23.0.2 pkgsrc-2017Q2-base:1.23 pkgsrc-2017Q1:1.22.0.2 pkgsrc-2017Q1-base:1.22 pkgsrc-2016Q4:1.21.0.2 pkgsrc-2016Q4-base:1.21 pkgsrc-2016Q3:1.20.0.2 pkgsrc-2016Q3-base:1.20 pkgsrc-2016Q2:1.19.0.6 pkgsrc-2016Q2-base:1.19 pkgsrc-2016Q1:1.19.0.4 pkgsrc-2016Q1-base:1.19 pkgsrc-2015Q4:1.19.0.2 pkgsrc-2015Q4-base:1.19 pkgsrc-2015Q3:1.17.0.2 pkgsrc-2015Q3-base:1.17 pkgsrc-2015Q2:1.14.0.2 pkgsrc-2015Q2-base:1.14 pkgsrc-2015Q1:1.13.0.4 pkgsrc-2015Q1-base:1.13 pkgsrc-2014Q4:1.13.0.2 pkgsrc-2014Q4-base:1.13 pkgsrc-2014Q3:1.11.0.2 pkgsrc-2014Q3-base:1.11 pkgsrc-2014Q2:1.10.0.2 pkgsrc-2014Q2-base:1.10 pkgsrc-2014Q1:1.7.0.4 pkgsrc-2014Q1-base:1.7 pkgsrc-2013Q4:1.7.0.2 pkgsrc-2013Q4-base:1.7 pkgsrc-2013Q3:1.6.0.16 pkgsrc-2013Q3-base:1.6 pkgsrc-2013Q2:1.6.0.14 pkgsrc-2013Q2-base:1.6 pkgsrc-2013Q1:1.6.0.12 pkgsrc-2013Q1-base:1.6 pkgsrc-2012Q4:1.6.0.10 pkgsrc-2012Q4-base:1.6 pkgsrc-2012Q3:1.6.0.8 pkgsrc-2012Q3-base:1.6 pkgsrc-2012Q2:1.6.0.6 pkgsrc-2012Q2-base:1.6 pkgsrc-2012Q1:1.6.0.4 pkgsrc-2012Q1-base:1.6 pkgsrc-2011Q4:1.6.0.2 pkgsrc-2011Q4-base:1.6 pkgsrc-2011Q3:1.5.0.18 pkgsrc-2011Q3-base:1.5 pkgsrc-2011Q2:1.5.0.16 pkgsrc-2011Q2-base:1.5 pkgsrc-2011Q1:1.5.0.14 pkgsrc-2011Q1-base:1.5 pkgsrc-2010Q4:1.5.0.12 pkgsrc-2010Q4-base:1.5 pkgsrc-2010Q3:1.5.0.10 pkgsrc-2010Q3-base:1.5 pkgsrc-2010Q2:1.5.0.8 pkgsrc-2010Q2-base:1.5 pkgsrc-2010Q1:1.5.0.6 pkgsrc-2010Q1-base:1.5 pkgsrc-2009Q4:1.5.0.4 pkgsrc-2009Q4-base:1.5 pkgsrc-2009Q3:1.5.0.2 pkgsrc-2009Q3-base:1.5 pkgsrc-2009Q2:1.4.0.8 pkgsrc-2009Q2-base:1.4 pkgsrc-2009Q1:1.4.0.6 pkgsrc-2009Q1-base:1.4 pkgsrc-2008Q4:1.4.0.4 pkgsrc-2008Q4-base:1.4 pkgsrc-2008Q3:1.4.0.2 pkgsrc-2008Q3-base:1.4 cube-native-xorg:1.3.0.24 cube-native-xorg-base:1.3 pkgsrc-2008Q2:1.3.0.22 pkgsrc-2008Q2-base:1.3 cwrapper:1.3.0.20 pkgsrc-2008Q1:1.3.0.18 pkgsrc-2008Q1-base:1.3 pkgsrc-2007Q4:1.3.0.16 pkgsrc-2007Q4-base:1.3 pkgsrc-2007Q3:1.3.0.14 pkgsrc-2007Q3-base:1.3 pkgsrc-2007Q2:1.3.0.12 pkgsrc-2007Q2-base:1.3 pkgsrc-2007Q1:1.3.0.10 pkgsrc-2007Q1-base:1.3 pkgsrc-2006Q4:1.3.0.8 pkgsrc-2006Q4-base:1.3 pkgsrc-2006Q3:1.3.0.6 pkgsrc-2006Q3-base:1.3 pkgsrc-2006Q2:1.3.0.4 pkgsrc-2006Q2-base:1.3 pkgsrc-2006Q1:1.3.0.2 pkgsrc-2006Q1-base:1.3 pkgsrc-2005Q4:1.2.0.8 pkgsrc-2005Q4-base:1.2 pkgsrc-2005Q3:1.2.0.6 pkgsrc-2005Q3-base:1.2 pkgsrc-2005Q2:1.2.0.4 pkgsrc-2005Q2-base:1.2 pkgsrc-2005Q1:1.2.0.2 pkgsrc-2005Q1-base:1.2 pkgsrc-2004Q4:1.1.1.1.0.6 pkgsrc-2004Q4-base:1.1.1.1 pkgsrc-2004Q3:1.1.1.1.0.4 pkgsrc-2004Q3-base:1.1.1.1 pkgsrc-2004Q2:1.1.1.1.0.2 pkgsrc-2004Q2-base:1.1.1.1 pkgsrc-base:1.1.1.1 TNF:1.1.1; locks; strict; comment @# @; 1.30 date 2022.12.03.15.53.40; author adam; state Exp; branches; next 1.29; commitid cgKl8mED8BOfY74E; 1.29 date 2021.10.26.10.10.06; author nia; state Exp; branches; next 1.28; commitid M6fNIkrZ0rV41jeD; 1.28 date 2021.10.07.13.35.51; author nia; state Exp; branches; next 1.27; commitid USVQpuM9JMvPLSbD; 1.27 date 2021.03.01.14.39.01; author taca; state Exp; branches; next 1.26; commitid R44eH4s6Pq7T0vJC; 1.26 date 2021.02.16.13.12.39; author adam; state Exp; branches; next 1.25; commitid e7LvcRDPPinZ7WHC; 1.25 date 2019.09.28.08.42.07; author adam; state Exp; branches; next 1.24; commitid u4fvKykGlSE6WKEB; 1.24 date 2018.05.04.14.26.41; author fhajny; state Exp; branches; next 1.23; commitid dnFXR2PNqkNqiZAA; 1.23 date 2017.06.12.17.06.18; author taca; state Exp; branches; next 1.22; commitid Fy1GJ1v6x4D1F6Vz; 1.22 date 2017.01.16.13.13.13; author fhajny; state Exp; branches; next 1.21; commitid VNeF0BpunmSP5cCz; 1.21 date 2016.10.21.14.16.34; author fhajny; state Exp; branches; next 1.20; commitid 3hKdiyQEiftIe1rz; 1.20 date 2016.07.01.17.02.39; author fhajny; state Exp; branches; next 1.19; commitid rNWqTGm4CjPQKDcz; 1.19 date 2015.11.10.10.10.39; author fhajny; state Exp; branches; next 1.18; commitid wgWI9oYUenL40xIy; 1.18 date 2015.11.03.01.56.35; author agc; state Exp; branches; next 1.17; commitid CWcfajqBx1XKtAHy; 1.17 date 2015.09.21.17.46.36; author fhajny; state Exp; branches; next 1.16; commitid Vz4iyWh6Hbw289Cy; 1.16 date 2015.09.02.12.39.33; author fhajny; state Exp; branches; next 1.15; commitid wlVxcpuyIkmV2Gzy; 1.15 date 2015.07.05.12.52.39; author joerg; state Exp; branches; next 1.14; commitid P4J6cInwDQuZ06sy; 1.14 date 2015.05.20.13.26.45; author ryoon; state Exp; branches; next 1.13; commitid cV2P7XSYwbNkGbmy; 1.13 date 2014.11.17.19.00.39; author joerg; state Exp; branches; next 1.12; commitid dzveM0GYueDDrzYx; 1.12 date 2014.10.30.11.51.34; author fhajny; state Exp; branches; next 1.11; commitid SH1gSYWjdtefEdWx; 1.11 date 2014.07.18.18.16.30; author fhajny; state Exp; branches; next 1.10; commitid xxbs4OrO8FNd7TIx; 1.10 date 2014.05.27.13.24.43; author fhajny; state Exp; branches; next 1.9; commitid FsAJWcjlCry9bbCx; 1.9 date 2014.05.27.09.55.03; author joerg; state Exp; branches; next 1.8; commitid cwXC797n2EO21aCx; 1.8 date 2014.05.22.12.50.48; author fhajny; state Exp; branches; next 1.7; commitid 9PS6dazTyohP2xBx; 1.7 date 2013.10.20.18.18.28; author joerg; state Exp; branches; next 1.6; commitid vXqI2DYy2x2pQ3ax; 1.6 date 2011.11.02.13.59.29; author fhajny; state Exp; branches; next 1.5; 1.5 date 2009.09.09.14.38.58; author joerg; state Exp; branches; next 1.4; 1.4 date 2008.10.03.18.14.46; author joerg; state Exp; branches; next 1.3; 1.3 date 2006.03.29.01.28.46; author gavan; state Exp; branches; next 1.2; 1.2 date 2005.02.23.16.33.10; author agc; state Exp; branches; next 1.1; 1.1 date 2004.04.15.10.37.24; author grant; state Exp; branches 1.1.1.1; next ; 1.1.1.1 date 2004.04.15.10.37.24; author grant; state Exp; branches; next ; desc @@ 1.30 log @sqlrelay: updated to 1.9.3 1.9.3 - added some missing SQLGetInfo() attributes to the ODBC driver backported fixes for PHP 8 backported support for Oracle 18 and 19 backported a fix for some missing map clears in postgresql protocol module backported a fix for NULL-binds in the ODBC driver backported -fdeclspec configure test for ruby with clang backported a postgresql isnull fix backported patch from Kyle to use HH24 instead of HH in default fakeinputbindvariablesdateformat string backported mysql connection segfault fix disabled PQsendQueryPrepared/PQsetSingleRowMode to fix nested query bug with postgresql backported postgresql noRowsToReturn fix 1.9.2 - ruby cursor constructor marks associated ruby connection object now updated bad-command and no-cursor-available handling in sqlrclient protocol module fixed a subtle bug that could cause closeResultSet()/clearError() not to be called between reexecutes if the previous execute resulted in an error backported support for password files in userlist auth modules 1.9.1 - fixed some missing map clears in postgresql protocol module fixed NULL-bind in the ODBC driver 1.9.0 - added missing inequality operators to end-of-bind detection fixed commit/begin without commitcount error in sqlrimportcsv fetch errors aren't returned if sqlrclient protocol version < 2 query-intercept catches "begin transaction" now query-intercept doesn't intercept various begin-type statements if the query is actually a block of sql containing commit or rollback added ncharencoding option to odbc connection to enable UTF-16 values in SQL Server nchars/nvarchars fixed a bug that caused output binds of length 8000+ to fail on SQL Server begin() runs "begin transaction" instead of just "begin" on SQL Server fixed a column-count reset bug in odbc, db2, informix, and postgresql that could cause begin queries to fail when fake transaction blocks are used object lists have correct column names for mysql, odbc, and jdbc now fixed a bug that caused rollback to be called insted of commit when endofsession="commit" and faketransactionblocks=yes are used commit/rollback is now called at the end of session when faketransactoinblocks=yes is used, whether or not the server believes it's in a transaction block, to catch cases where the begin-interceptor is intentionally bypassed sqlrimportcsv handles dates without centuries now fixed crash in replay module when table name is quoted mysql explain statements work now fixed node-gyp.js detection on ubuntu 20.04 added configure options for PHP 8.x added php/pdo module tweaks for PHP 8 mysql and postgresql protocol modules support TLS now pushed most of tls/gss code up into sqlrprotocol parent class fixed subtle issues in mysql/postgresql database modules that could sometimes cause reexecutes of the same query with the same bind variables to return no results the second time the configure script specifically looks for liberl_interface.a now updated nodejs macros for node 14+ fixed subtle bugs in Python getField, getFieldLength, and getRowLengthsDictionary functions added GVL management to the Ruby API applied patch from Igor to fix configure.vbs VC++ version detection for non-US versions @ text @$NetBSD: distinfo,v 1.29 2021/10/26 10:10:06 nia Exp $ BLAKE2s (sqlrelay-1.9.3.tar.gz) = 59f17e57399d0324b09c9c2dc3affa0ee19e286abd2bb77f18019d72aa41925f SHA512 (sqlrelay-1.9.3.tar.gz) = ad80a7be56ed5ca6eaa2ac97986c2e64ab61ad3ec895d76a3fee2d865e856877a319e16cf996ff92072249b170f2611295d9f8777c8d10c80d6eb6ab7add97e3 Size (sqlrelay-1.9.3.tar.gz) = 4903142 bytes SHA1 (patch-Makefile) = 4005ca28daec0180fe298f711b22b3d8dcf02a9a SHA1 (patch-config.mk.in) = 172f04e655d31705b107f0889d86c48db9e0919a SHA1 (patch-configure) = b00b596b6c0a8353c0aaff8503bc80e3f17febb0 SHA1 (patch-etc_Makefile) = 5c768f50a97489ea06ca586b131ef0324878f8d0 SHA1 (patch-src_api_nodejs_Makefile) = 6f0e569f25fd1e78e088b8e0cd8eb541c2c5d417 SHA1 (patch-src_api_nodejs_package__in.json) = 76e2ebc4e47d5ef38d0c96059b62460fef687d1e SHA1 (patch-src_api_ruby_getcflags.rb) = 033e26ef03db4851f493d831c37ec947662d47ee SHA1 (patch-src_api_ruby_getsitearchdir.rb) = 603c66ed45f854b833eefbcdbd58e41465fb8120 SHA1 (patch-src_api_ruby_rubyincludes1.h) = 7b06afbbdfc4d0ab4fd1288336eea795f4e1bce7 @ 1.29 log @databases: Replace RMD160 checksums with BLAKE2s checksums All checksums have been double-checked against existing RMD160 and SHA512 hashes The following distfiles could not be fetched (some may be only fetched conditionally): ./databases/cstore/distinfo D6.data.ros.gz ./databases/cstore/distinfo cstore0.2.tar.gz ./databases/cstore/distinfo data4.tar.gz @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.28 2021/10/07 13:35:51 nia Exp $ d3 3 a5 3 BLAKE2s (sqlrelay-1.8.0.tar.gz) = 71c3255b7a1876adc5d97578a0f7ec3c58107b9158ada13e892a9a67385b0a0c SHA512 (sqlrelay-1.8.0.tar.gz) = cfb430f1eb9de4c8dd5c4ee4a89a1c04ba2449cc302155bbf115cd8b50933f7fb690395cb394ce01bfb8e7d83b79168f898baafd1169383ecdfd961347679561 Size (sqlrelay-1.8.0.tar.gz) = 4684135 bytes d8 1 a8 1 SHA1 (patch-configure) = c4c00878bb377ffaed4ec3268956e6be825b7324 a11 1 SHA1 (patch-src_api_php_sql__relay.cpp) = 9e33260f4e4331874187e5b30db17d4478710385 a14 1 SHA1 (patch-src_api_ruby_sqlrelay.cpp) = 3081ffd0e2a373c14e6dd602728f72a1dfb6461b @ 1.28 log @databases: Remove SHA1 distfile hashes @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.27 2021/03/01 14:39:01 taca Exp $ d3 1 a3 1 RMD160 (sqlrelay-1.8.0.tar.gz) = 1c87f0da0d8334a23fff35e9ff1edeb3f2093111 @ 1.27 log @databases/sqlrelay: improve ruby-sqlrelay Improve ruby-sqlrelay configuration; do not try to detect installed ruby but use simply RUBY environment variable. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.26 2021/02/16 13:12:39 adam Exp $ a2 1 SHA1 (sqlrelay-1.8.0.tar.gz) = 30fe6bab49b04c091cee61d77c854d8b4674cc1d @ 1.26 log @sqlrelay: updated to 1.8.0 SQL Relay 1.8.0 This release mainly lays the groundwork for some future features, including a generic import/export framework. Some notable progress was also made on the JDBC driver, though it's still not finished. The most significant (finshed) new feature is an aes128 password encryption module. There are some bugfixes as well. A long-standing issue with postgresql that could cause results from multiple open cursors to get confused has been resolved. A subtle error that could cause counting of bind variables on the client-side to hang has been fixed. A long-standing, but apparently obscure, issue that could cause tables from other MySQL schemas to be included in a "show tables" command has been fixed. As well as various other issues. Full ChangeLog follows: unattended tests added sqlrresultsetdomnode class to c++ client API fixed datedelimiters parameter added support for SQLParamOptions with SQLUINTEGER arguments sqlr-import detects uppercase .CSV suffix now fixed a csv number-detection but in sqlr-import fixed a delete[] of a const in sqlr-import it's possible to specify a commitcount of 0 with sqlr-import now moved sqlrimportxml/csv classes into libsqlrclient moved sqlrexportxml/csv classes into libsqlrclient csv import/export is consistent now added some event methods to sqlrexport migrated parsedatetime functions to rudiments datetime class different postgresql cursors use different stmtNames now sqlrimportcsv can create a primary key that's not in the CSV now sqlrexportcsv quotes 12+ digit numbers now fixed subtle, count-related issues when validating bind variables on the client side, that could cause a hang added an aes128 pwdenc module applied a patch to fix a crash in the debug logger (missing "%s") added a tweak to getsitearchdir.rb to fix incorrect lib/lib64 reporting on some centos x64 systems fixed mysql getColumnList to distinquish proper db/schema SQL Relay 1.7.0 This release adds 2 significant features: support for the PostgreSQL client-server protocol, and a "replay" module to help automatically recover from deadlocks and lock-timeouts, but also has the usual assortment of minor bugfixes and internal changes. Full ChangeLog follows: added postgresql protocol module updated postgresql connection module to get column info pre-execute fixed postgresql connection module type oid bug added tag filter/moduledata added moduledata(s)::closeResultSet()/endTransaction()/endSession() mysql protocol returns empty lobs correctly now (not as nulls) configure replaces -lfbclient with -lgds on freebsd/firebird-2.0.3 fixed a bug that could cause sqlr-stop to try to kill pid 0 fixed unixodbc detection on solaris 11.4 added configure test for PQdescribePrepared test improvements documentation improvements split sqlrelay-crash directive into its own module deprecated drop-in replacement libraries in favor of protocol support fixed various mysql 4.x bugs sqlr-status creates statistics on heap now instead of stack, to work on platforms with a small default ulimit stack mysql stored procedure test is bypassed for older mysql tls test is bypassed for older openssl added NULL handoff socket workaround improved shutdown/crash handlers for sqlr-listener/connection fixed hang when more-than-one address was specified in the instance:addresses attribute *_null used instead of *_unset on PHP 7.4 SQL Relay 1.6.0 This release mainly addresses some recently discovered regressions, but also adds some internal features that required the minor version to be bumped. ChangeLog follows: added begin, commit, rollback events fixed array_init() calls for php-7.3 integrated my_bool fix for mysql 8.0.1+ mysql sslmode=require/prefer + bad sslca/sslcapath generates warning rather than error now (like the mysql cli) refactored various routines that parse bind variables out of queries added bindvariabledelimiters config option to define supported bind variable delimiters added fakeinputbindvariablesunicodestrings config option added bind variable delimiters config methods to c++ api replay trigger can now run a query (eg. "show engine innodb status") and log the reslits to a file when a replay condition occurs replay trigger doesn't log/replay selects by defalit now (but this is configurable) updated normalize translation to support queries containing binary data fixed a backslash-escape bug in the normalize translation refactored some sqlrclient api private methods refactored various bind-manipliation/detection methods sqlr-listener creates tmpdir now on start, if it doesn't exist (because this is often in /run, which is often a tmpfs) postgresql connection modlie forces re-fetch of column data after execute now everything uses charstring::isYes/isNo now, instead of direct comparisons against "yes" or "no" fixed subtle sqlexecdirect bug fixed subtle sqlserver max-varchar bind length bug fixed various subtle sqlserver bugs where column-info isn't valid until after execute odbc connection modlie sets column precision = column length if column precision = -1 when using odbc on front and back end, the object type works in SQLTables now reslit set translations work with "show databases/tables/etc." queries with an ODBC backend now increased oid buffer sizes in postgresql connection fixed typemangling->tablemangling typo in postgresql connection - tablemangling sholid work without typemangling now fixed a '...\\''...' parsing bug non-odbc connection modlies now return odbc-compatible(ish) table lists client info is no longer reset during endSession fixed a bug that colid cause sqlite "show tables like '...'" to crash fixed odbc unicode nlil user/password bug fixed PyString_AsString for python 3.<3 fixed bug that caused some MSSQL lobs to sometimes be returned as nlils when using ODBC on the backend fixed bug that caused some MSSQL date fields to get returned as garbage fixed a few older sqlrclient compatibility bugs fixed SQLFetch parameter type mismatch in ODBC api removed a non-c++17-compliant "register" from custom_nw logger added support for nodejs 12 SQLDriverConnect can take an inline DSN now fixed odbc maxcolumncount=-1 crash odbc, db2, and informix set bind format error now @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.25 2019/09/28 08:42:07 adam Exp $ d9 1 a9 1 SHA1 (patch-configure) = a2355371cbf9d81f8d17568ed9ff0b6788dd25f9 @ 1.25 log @py-sqlrelay: fix buidling when multiple Python versions are installed @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.24 2018/05/04 14:26:41 fhajny Exp $ d3 9 a11 9 SHA1 (sqlrelay-1.0.0.tar.gz) = 3f350a71fea8177a8e003524b6833347f741153b RMD160 (sqlrelay-1.0.0.tar.gz) = 1bc6c1ac02eb8a58c1aa8e2bacd0c8662a283aad SHA512 (sqlrelay-1.0.0.tar.gz) = 2722cd179dfcd6bbc4c78ea9149d00ec70ccd11d44cdcabe7ad48e8cddf07588477ca9edf74660d498b2a6ae9e70a9e68733090c0a2122310995f566b0807349 Size (sqlrelay-1.0.0.tar.gz) = 4194484 bytes SHA1 (patch-ad) = cc4a94941ec737abede98bdd7b19bc902f755609 SHA1 (patch-config.mk.in) = 22e8459f49e20529289e1a99b10cebaa449af0c0 SHA1 (patch-configure) = a3c6c2179e5166525fbea9661966c2180668fb46 SHA1 (patch-etc_Makefile) = 28e9cac18314f1fc725603d47cb92ec6e54d7c63 SHA1 (patch-src_api_nodejs_Makefile) = fd932cd1c76a34cc5decbe4060fc7c37174631bb @ 1.24 log @databases/sqlrelay-nodejs: Fix nodejs support, avoid built-time fetching. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.23 2017/06/12 17:06:18 taca Exp $ d9 1 a9 1 SHA1 (patch-configure) = 689820a84f671923b96f64a62de08ce266f55501 @ 1.23 log @Add fix for Ruby 2.4 and later. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.22 2017/01/16 13:13:13 fhajny Exp $ d11 1 @ 1.22 log @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 @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.21 2016/10/21 14:16:34 fhajny Exp $ d15 2 @ 1.21 log @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 @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.20 2016/07/01 17:02:39 fhajny Exp $ d3 4 a6 4 SHA1 (sqlrelay-0.66.0.tar.gz) = 08bb3cd32ce0d7d36783f3e43fa4f0035b6dd6d1 RMD160 (sqlrelay-0.66.0.tar.gz) = 21971765d9a9d6e71c0bcb8c85f2af0e746ebc7c SHA512 (sqlrelay-0.66.0.tar.gz) = df56609816c88b5a041752e6460ecd35dba4a27823c2740693c45d2727a89dbce6b0f88af746cb4b74c7d36ef619bc4fd2c9991507d18b6bf6d351f36b294293 Size (sqlrelay-0.66.0.tar.gz) = 4249607 bytes d9 1 a9 1 SHA1 (patch-configure) = 04affebca0556849cfbc3eb17f5b9481eb00631b d11 1 a14 1 SHA1 (patch-src_loggers_custom__sc.cpp) = 79e2b0a54b151e76175f549747e3392accd0b4d9 @ 1.20 log @Update databases/sqlrelay to 0.65.0 - SQL Relay now supports Kerberos encryption and authentication - SQL Relay now supports TLS/SSL encryption and authentication - Python 3 support - Node.js 4.x and higher are now correctly detected and supported. - Separate "database" and "proxied" Authentication Options - Various ODBC-related bugs have been fixed - A subtle bug that caused incompatibilities with the popular logrotate utility has been fixed - A long standing problem that occurred when using a listenertimeout with a threaded listener (the default) has been fixed. - After a graceful restart, Apache workers would get stuck in the Closing Connection state after running a PHP script that used SQL Relay. This is now fixed. See full changelog: http://software.firstworks.com/2016/03/sql-relay-0650-release-announcement.html @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.19 2015/11/10 10:10:39 fhajny Exp $ d3 4 a6 4 SHA1 (sqlrelay-0.65.0.tar.gz) = 7649fc14a95009ffaeb56f12abe70e526c4eb099 RMD160 (sqlrelay-0.65.0.tar.gz) = f83b9372da1283bd35f62761c522c0cdd25dd536 SHA512 (sqlrelay-0.65.0.tar.gz) = 7d5d18dbfd7b0c4bb39466489726c2d401b08e2c63af13c9bfb75f9c6839b7ac86caf3d03e3152cb73cf86d03b2de2f5880b41c40ffb5ef6c357886fb2aedcf7 Size (sqlrelay-0.65.0.tar.gz) = 3970412 bytes d9 1 a9 1 SHA1 (patch-configure) = 29bc9087fc814d0879c99b2772632a3034bec502 @ 1.19 log @Update databases/sqlrelay to 0.64. Remove bl3 entries that were really only part of devel/rudiments. - fixed bug in sqlrsh that caused it to filter out non-ascii characters - added informix connection module - added shutdown loop detection in sqlr-listener - fixed dbhostname/dbipaddress requests - added bind variable format validation to php pdo driver - added softttl parameter - added db/language detection to configure.vbs - added passwordfunction parameter to "sqlrelay" authentication module - added -disable-crash-handler command line option to server processes - postgresql connection module PQclear()'s the result of PQprepare() now, fixing a memory leak - updated postgresql connection module to handle invalid bind variables properly, and without crash - added various missing postgresql functions to the postgresql drop-in library, most notably PQprepare, PQexecPrepared, PQexecParams - simplified sqlrpaths/sqlrcmdline classes a bit - renamed sqlrconfigfile to sqlrconfig - implemented a modular configuration framework - config files can be loaded over protocols supported by libcurl now or http if rudiments compiled withougt libcurl support - config files can now be "link files" which just refer to other local config files, local config directories, or remote config files - updated sqlr-start and sqlr-scaler not to pass the default -config value if sqlr-start wasn't explicitly started with -config - fixed a bug that could cause sqlrsh to act funny if the last character prior to the command delimiter was a single or double quote - fixed a stacked result-set translation module bug - applied George Carrette's patch to fix potential PDO null-dereferences @ text @d1 1 a1 1 $NetBSD$ d3 4 a6 4 SHA1 (sqlrelay-0.64.tar.gz) = d285957f9e170186774b8e2ab9d58913b7785831 RMD160 (sqlrelay-0.64.tar.gz) = 85eb9ee66cf78bcd94d63b951233f1b29e738c01 SHA512 (sqlrelay-0.64.tar.gz) = 43fda7954b595d580126ab94207c056a0d284666cfa73691ce0fa9606f5c49c7d53ab7fc69bee51257d1f2d0d4c422e93de5568a663b97834a325b4d571b8694 Size (sqlrelay-0.64.tar.gz) = 3450843 bytes d8 1 a8 1 SHA1 (patch-config.mk.in) = 297ac15bc1d59bdff7236107df8b5ad7b03737e5 d10 2 a11 3 SHA1 (patch-etc_Makefile) = 128102a3eaaeba96425060f82dc8e5e94edeabd0 SHA1 (patch-src_api_nodejs_sqlrelay.cpp) = 61ae166cbb384d32dd1d2c500cce82e54a228c05 SHA1 (patch-src_api_php_sql__relay.cpp) = d589837f05e86d614bc3b71bc0459ae786193d88 @ 1.18 log @Add SHA512 digests for distfiles for databases category Problems found with existing distfiles: distfiles/D6.data.ros.gz distfiles/cstore0.2.tar.gz distfiles/data4.tar.gz distfiles/sphinx-2.2.7-release.tar.gz No changes made to the cstore or mariadb55-client distinfo files. Otherwise, existing SHA1 digests verified and found to be the same on the machine holding the existing distfiles (morden). All existing SHA1 digests retained for now as an audit trail. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.17 2015/09/21 17:46:36 fhajny Exp $ d3 4 a6 4 SHA1 (sqlrelay-0.63.tar.gz) = b71f8967269fee4bd7b0e50699276f2f01ee2a5a RMD160 (sqlrelay-0.63.tar.gz) = 381311a698a70e96aa92dfecf4910dc942e4a3fb SHA512 (sqlrelay-0.63.tar.gz) = 00e0053265fe8d797d3e826f9f45d149fcf78d2e3b2d7bd1939ffc8481ca1fd841dfc2d8c5a093667214b93dbcee8893198008f83607639a46a6a62c3f8d4dc2 Size (sqlrelay-0.63.tar.gz) = 3422788 bytes @ 1.17 log @Fix build of databases/sqlrelay-nodejs by adding nodejs>4 support. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.16 2015/09/02 12:39:33 fhajny Exp $ d5 1 @ 1.16 log @Update databases/sqlrelay to 0.63. sqlrelay 0.63 - suppressed ruby configure warning - fixed glib detection if pkg-config isn't present - fixed mono detection on freebsd - fixed node.js yes/no misreport bug in configure script - added freetds tcl test - fixed slashes in tcl tests for windows - updated docs to mention firebird buffer size parameters - updated MAX_ITEM_BUFFER_SIZE to 32768 for firebird - fixed ruby detection on fedora 22 - fixed missing export for setAuth/ResponseTimeout in ruby api - added manual include of inttypes.h in php api to work around issue with define/undef games, revealed on openbsd 5.7 - tweaked ruby cflags script for debian 8 - refactored mysql detection - tweaked unixodbc detection to also look in /usr/include/odbc - renamed "oracle8" connection plugin to "oracle" - renamed "sybase" connection plugin to "sap" - updated identity tests in api's/cmdline clients to use charstring::contains() rather than !charstring::compare() - implemented missing destructors for ADO.NET Data Provider sqlrelay 0.62 - added query filter plugin framework - added regex, string and pattern filters - added normalization translation - added reformatdatetime result set translation - fixed error in sqlrconfigfile class that could cause sqlr-start to crash if one instance defines addresses but the next doesn't - added query status flag to sqlrservercursor - tweaked odbc driver's SQLGetTypeInfo() - field name is passed into runResultSetTranslations() now - added support for maxitembuffersize, maxselectlistsize, and maxbindcount for firebird - added native api for node.js - added recognition of bigint, ubigint and uniqueidentifier fields in freetds/sybase - added nullsasnulls command to sqlrsh - added workaround for freetds empty (but non-null) text fields not getting properly converted to null-terminated empty strings - fetchatonce, maxitembuffersize and maxselectlistsize are set to defaulting values if invalid values are given for them - added lazyconnect option to PHP PDO and Perl DBI drivers (defaults to 1) - direct Transact SQL which returns a result set is now supported with Sybase/SAP/MSSQLServer/FreeTDS - added docs for authentication, query translation, query filter and result set translation modules - added -fPIC to sqlrserver-config --cflags, if supported - the "default" auth module is now called "userlist" - added database auth module that is analagous to authtier="database" - replaced passwordencryption attribute with passwordencryptionid - added --disable-postgresql8-api configure option - tweaked -Werror detection in configure script - refactored sqlr-bench build to work on windows - documentation, examples and tests are now covered by a license - reflecting modern interpretation of the GPL, The license for The SQLRelay Server (as designated in COPYING) license now carries an exception, explicitly allowing it to be linked with various non-GPL compatible libraries - license is installed now sqlrelay 0.61 skipped sqlrelay 0.60 - fixed true->false transposition in sqlrservercontroller::interceptQuery that could lead to a reLogIn loop - disabled -Werror for gcc < 2.7 - applied George Carrette's patch to fix PDO connectstring options - migrated directory/file paths info into sqlrpaths class - removed undocumented and not-so-relevent-these-days MAX_CONNECTIONS/overridemaxconnections failsafe in sqlr-start - fixed java header detection for javac located in /usr/bin - updated java api to support non-null-tolerant implementations of environment::NewStringUTF() - the perl api builds correctly on OSR5 again - the postgresql sslmode is omitted entirely from the connect string now, if it's disabled, to prevent problems with older versions of postgresql that don't support the parameter at all - mono 2.8 or greater is required now - added a datedelimiters attribute to the instance tag in sqlrelay.conf to limit what date delimiters are used when translating dates - re-added mssqlserver detection, which had been accidentally removed - fixed statically-linked build - fixed mysql lob field bug that could cause a crash @ text @d1 1 a1 1 $NetBSD$ d10 1 @ 1.15 log @Restore patch for src/api/php/sql_relay.cpp: Do not pretend that C++ is C. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.14 2015/05/20 13:26:45 ryoon Exp $ d3 3 a5 3 SHA1 (sqlrelay-0.59.tar.gz) = 0d89f1cfff4c929297f92a575bfdae43d0b7affa RMD160 (sqlrelay-0.59.tar.gz) = a0731c80048f280b71ec1dcb89bedad2b5145348 Size (sqlrelay-0.59.tar.gz) = 3224000 bytes d7 2 a8 2 SHA1 (patch-config.mk.in) = 3ac1d68eec9e71b2827a675549dc873be9a56741 SHA1 (patch-configure) = cd7598c42a3d12c3ac4874d07cfe679b3dc24b2c d11 2 a12 2 SHA1 (patch-src_api_ruby_getcflags.rb) = a08e18e15cf8b7e7aff4b50d3927d7c352ec15c3 SHA1 (patch-src_api_ruby_getsitearchdir.rb) = 89d1bee15077d009a8e9b3b98443dcc667a583da @ 1.14 log @Update to 0.59 * Fix build with Ruby 2.2. Changelog: 0.59 - updated docs, removed some Cygwin-specific info added support for login warnings made bind variable buffers dynamic on the client side added maxbindvars parameter on the server side binding a NULL to an integer works with db2 now moved getting started with DB docs into the cloud added a semaphore to ensure that the listener doesn't hand off the client to the connection until the connection is ready, elimiating a race condition on the handoff socket that could occur if the connection timed out waiting for the listener just after the listener had decided to use that connection oracle temp tables that need to be truncated at the end of the session are truncated with "truncate table xxx" now rather than "delete from xxx" oracle temp tables that need to be dropped at the end of the session are truncated first, rather than the connection re-logging in an ora-14452 error (basically indicating that a temp table can only be dropped after being truncated, or if the current session ends) does not automatically trigger a re-login any more updated cachemanager to use directory::read() directly instead of directory::getChildName(index) added cache and opencache commands to sqlrsh made cache ttl a 64-bit number added enabled="yes"/"no" parameter to logger modules updated odbc connection code to use new/delete and rudiments methods rather than malloc/free and native calls retired Ruby DBI driver fixed command line client crash when using -id "instance" with an instance that uses authtier="database" fixed bugs that could make reexecuted db2 selects fail and cause a database re-login loop tweaked spec file to remove empty directories on uninstall fixed typo that could sometimes cause a listener crash postgresql and mdbtools return error code of 1 rather than 0 for all errors now tweaked odbc driver to work with Oracle Heterogenous Agent (dblinks) fixed bugs related to autocommit with db's that support transaction blocks implemented the ODBC driver-manager dialog for windows updated windows installer to install ODBC registry settings ODBC driver copies references now fixed various bugs in sqlrconfigfile that caused sqlr-start with no -id to crash or behave strangely sometimes refactored build process to use nmake and be compatible with many different versions of MS Visual Studio updated the slow query logger to show the date/time that the query was executed consolidated c, c++ and server source/includes down a few levels implemented column-remapping for get db/table/column commands to enable different formats for mysql, odbc, etc. odbc connection correctly returns database/table lists now added support for maxselectlistsize/maxitembuffersize to MySQL connection updated mysql connection to fetch blob columns in chunks and not be bound by maxitembuffersize fixed a misspelling in sqlrelay.dtd swapped order of init directory detection, looking for /etc/init.d ahead of /etc/rc.d/init.d to resolve conflict with dkms on SuSE Enterprise C# api and tests compile and work under Mono on unix/linux now sqlr-start spawns a new window on Windows now added global temp table tracking for firebird added droptemptables parameter for firebird added globaltemptables parameter for oracle and firebird updated mysql connection to allow mysql_init to allocate a mysql struct on platforms that support mysql_init, rather than using a static struct fixed subtle noon/midnight-related bugs in date/time translation updated mysql connection to get affected rows when not using the statement api updated mysql connection not to use the statement API on windows, for now disabled mysql_change_user, for now fixed blob-input binds on firebird 0.58 - updated spawn() calls to detach on windows added support for sqlrelay.conf.d removed support for undocumented ~/.sqlrelay.conf fixed detection of oracle jdk 7 and 8 on debian and ubuntu systems added ini files for PHP and PDO modules added resultsetbuffersize, dontgetcolumninfo and nullsasnulls connect string variables to the PHP PDO driver refactored sqlr-status and removed dependency on libsqlrserver cleaned up and refactored server-side classes quite a bit fixed a bug where sqlrsh was losing the timezone when binding dates server-devel headers are now installed removed backupschema script moved triggers, translations, resultsettranslations and parser into separate project blobs work when using fake input binds now replaced sqlr-stop script with a binary (for Windows) preliminary support for server components on Windows sessionhandler="thread" is now forced on Windows added various compile flags for clang's aggressive -Wall added support for sybase 16.0 removed unnecessary -lsybdb/-lsybdb64 for sybase 15+ fixed PQreset, PQresetStart, PQresetPoll in postgresql drop-in replacement lib added debug-to-file support to PHP PDO driver fixed subtle row-fetch bug in sybase/freetds drivers that could cause the total row count to be set to garbage fixed support for older versions of perl (5.00x) fixed a bug in the DB2 connoutpection that caused blob input binds to be truncated at the first null added support for binding streams to output bind blobs in the PHP PDO driver updated PHP PDO guide with notes about bind variable formats integrated Samat Yusup's dbh driver methods for PHP PDO added stmt driver methods for suspending/resuming result sets to the PHP PDO driver added row cache to mysql drop-in replacement library to fix issues on systems with 32-bit pointers fixed subtle db2 output bind bfers the entire result set by default now implemented an ext_SQLR_Debug database handle attribute for perl DBI added support for type, length, precision, scale bind variable attributes in perl DBI output bind clobs and blobs work in perl DBI now addd support for perl DBI ParamValues, ParamTypes and ParamArrays attributes tweaked the odbc driver so it works with the jdbc-odbc bridge and jmeter added custom db/statement attributes to perl DBI for DontGetColumnInfo, GetNullsAsEmptyStrings and ResultSetBufferSize added note about JDBC-ODBC bridge removal in Oracle Java 8 made threaded listener the default tweaks to sqlr-connection/sqlr-scaler processes to deal with lack of SIGCHLD/waitpid() on windows the signal on semaphore 2 is now undone manually when sqlr-connections shut down and doesn't rely on semaphore undo's for normal operation subtly tweaked freeing of Oracle column-info buffers to work around a crash that could occur after using a cursor bind @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.13 2014/11/17 19:00:39 joerg Exp $ d10 1 @ 1.13 log @Don't pretend that C++ is C. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.12 2014/10/30 11:51:34 fhajny Exp $ d3 9 a11 8 SHA1 (sqlrelay-0.57.tar.gz) = 537733e01beb5374688f2da9642024704bc93580 RMD160 (sqlrelay-0.57.tar.gz) = 709de60d7be64ab3d98df64a78bad3f110e9562e Size (sqlrelay-0.57.tar.gz) = 3774384 bytes SHA1 (patch-ad) = b822a43854848641feba34a5331082bb95f5d419 SHA1 (patch-configure) = 72175a91d2892d5325ec619f45a5b2f571bcdbf5 SHA1 (patch-etc_Makefile) = 262968ad43d34d53b4fe65514c1351127660e12c SHA1 (patch-init_rc.sqlrelay.in) = 6d358d9396339ecee8ef3b7054750100433fb271 SHA1 (patch-src_api_php_sql__relay.cpp) = 6634d30035473a932c5e5a4a78a0573a0a879ed7 @ 1.12 log @Update sqlrelay to 0.57. Changes in 0.57: - fixed an overloaded virtual function error in sqlr-status - fixed parsing of "term as type" clauses in queries - fixed 0 vs. None error in python getRowDictionary method - tweaked php and php_pdo modules to build with php 5.6.0 on windows - updated deployment projects for windows, adding perl, php, python and java, and adding x64 support - describe/getColumnList supports synonyms with oracle now - the mysql, firebird and oracle connections return sensible errors when the format of a numeric bind variable is wrong now - fixed a bug that could cause the mysql connection to loop up if alphanumeric bind variable names were used instead of numbers - fixed a bug that could cause the database specified in the mysql connection string to be ignored - fixed a bind-variable translation bug that could cause variables not to be translated when multiple formats are used in the same query and one of them is the correct format - describing oracle tables returns key (PRI,UNI,MUL) info now - added disablekeylookup option to disable getting key information when describing oracle tables - fixed broken --with-system-libtool configure option - mysql-config --libs_r is used in preference to --libs now, solves build error with maria db on ubuntu 14.04.1 - fixed mysql drop-in lib errors with mysql_row_seek and mysql_row_tell @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.11 2014/07/18 18:16:30 fhajny Exp $ d10 1 @ 1.11 log @Update sqlrelay to 0.56. Changes: - removed VERSION from perl api bootstrap - reorganized and simplified perl api code - got perl api working on windows with ActivePerl - perl api uninstall cleans up better now - got python api working on windows with ActivePython - consolidated php include tweaks - got java api working on windows - updated pdo driver to convert float fields to strings rather than ints - updated pthread test to match rudiments pthread test - moved everything done by children of sqlwriter interface into individual translations - added plugin-based authentication framework - reorganized code tree a bit - reworked default values to enable more minimal configurations - updated configuration docs and added configuration guide - fixed cast issue with firebird 1.5 - added result set translation framework and re-implemented date translation using it - fixed millisecond->nanosecond confusion in sqlr-scaler - fixed subtle oracle instantclient version detection bug - added null input bind support to sqlrsh - fixed php pdo driver to return null rather than 0 for null integer fields and bind null rather than 0 for null integer input binds - added attribute to return nulls as nulls or empty strings to php pdo - added parameters for connecting to mysql via ssl - added a few tweaks to support DB2 < 8.0 - fixed bad return value type in python getConnectionPort method - fixed sessionhandler="thread" with listenertimeout!="0" @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.10 2014/05/27 13:24:43 fhajny Exp $ d3 3 a5 3 SHA1 (sqlrelay-0.56.tar.gz) = c859745bebe5ec4c0c514117d3fe7fcc2454433c RMD160 (sqlrelay-0.56.tar.gz) = abe9d999d12e1c44e657beb873796171f3ea12f8 Size (sqlrelay-0.56.tar.gz) = 3717761 bytes a9 1 SHA1 (patch-src_api_c++_src_sqlrcursor.cpp) = ed1faf27227bc85c006808e9928a42ed9f86cdf2 @ 1.10 log @Fix libiconv support. Fixes sqlrelay-odbc build. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.9 2014/05/27 09:55:03 joerg Exp $ d3 3 a5 3 SHA1 (sqlrelay-0.55.tar.gz) = ce47d8564e13d03b1eda8ff5d497fb056b5752e2 RMD160 (sqlrelay-0.55.tar.gz) = 9e727d2307f471ea935b5a8831a53929f0400c98 Size (sqlrelay-0.55.tar.gz) = 3644680 bytes @ 1.9 log @Fix build with clang. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.8 2014/05/22 12:50:48 fhajny Exp $ d6 2 a7 2 SHA1 (patch-ad) = c1c95f0938ed9efff7fd21392f7adeed80a86468 SHA1 (patch-configure) = 4aa35512ac7d5a97f0f511ba2432dc48a1b68159 @ 1.8 log @Update sqlrelay to 0.55. A full refactor and split-up into separate packages for the various APIs and backends. Changelog since 0.43 follows. 0.55 - fixed a sql translation bug related to exists clauses added deployment projects for windows tweaked make.batch install target to install 32-bit files under C:\Program Files (x86) added a timeout parameter to db2 and odbc connect strings fixed a bug that could cause a connection's ttl to fail because a semaphore was left signalled when another connection's ttl expired updated handoff="proxy" code to work with sessionhandler="thread" replaced waitpid call in sqlrscaler with rudiments equivalent got the server-side stuff to compile on windows added configurable fetch buffer sizes to sybase, freetds and db2 connections re-distribute themselves periodically if the database is behind a load balancer now fixed a bug that caused sqlrsh to incorrectly interpret internal commands with leading whitespace when run from a script or on the command line fixed a bug that caused cursors not to be completely cleaned up after when dynamic scaling is used fixed a bug that caused the response timeout to be handled improperly added response timeout command to sqlrsh added support for clobs/blobs with firebird fixed a blob-related bug with sqlite added support for blob input binds with db2 added support for clob/blob output binds with db2 improved clob/blob fetching with db2 inputBindClob/Blob methods work with all db's now added -Wno-unknown-pragmas flag (if it it supported) to java build for solaris 8 updated default item buffer sizes to 32768 for sybase, freetds, db2 and odbc applied Gerhard Lausser's patch to improve Oracle instantclient detection 0.54 - fixed bugs that caused problems when unopened result sets were closed added protocol identification phase to client/server protocol split client protocol handling out into its own class and abstracted it updated oracle code not to relogin when dropping tables unless a temp table with an "on commit preserve rows" was run updated server to run table-drop and session-end queries after the session-end commit/rollback, as some queries on some platforms ( ncluding drop-table on oracle) cause an implicit commit and the rollback needs to be run first replaced gettimeofday calls with calls to datetime::getSystemDateAndTime fixed a bug in slow query logger that caused it to display the wrong query time a few mingw32 tweaks fixed a few PDO driver bugs related to affected row counts and last insert id implemented PDO exceptions implemented support for PDO::ATTR_EMULATE_PREPARES by using substitution variables added foundrows and ignorespace options to mysql connect string fixed a bug where affectedRows() would return -1 for MySQL selects instead of the same value as rowCount() updated sqlr-connection code not to get db host name and ip address at startup unless logging is enabled to work around issues where people fail to put the db host name in dns fixed a subtle bind format translation bug that caused errors when translating from oracle-style binds to mysql-style if the varaibles were out of order with the placeholders in the query fixed bugs in the mysql and postgresql connection code that assumed that the bind variables were bound in order, independent of their names resolved a paradox involved in detecting whether the current mysql query needs to have its bind variables faked or not added support for client-side debug-to-file added debug-to-file support to command line clients tweaked server processes to use process::spawn instead of system() and process::fork()/process::exec() added another error string to detect down mysql database added support for a multi-threaded listener fixed a bug that could cause a crash when logging connection-level errors added back x64-detection so sybase and db2 libraries will be detected properly added support for forward-only cursors to the PDO driver fixed a bug that could cause one (and only one) dynamically spawned connection daemon to ignore its ttl added support for get/set result set buffer size to the PDO driver updated configure test for xsubpp updated configure test for tcl to support multi-arch updated configure test for python to support multi-arch added custom PDO driver attributes to access db type, version, host name, ip address and bind format added custom PDO driver attribute to get/set current database added custom PDO driver attribute to set whether or not to get column info when fetching the result set updated db2 to re-login when it sees error -30081 0.53.1 - updated the configuration and tuning docs a bit fixed a Makefile bug that caused "make clean" to be interrupted extern "C"-wrapped sys/times.h for OSR500 0.53 - added support for sqlite statement api and native binds fixed some leaks related to using sys::getHostName() added multiarch detection added PHP PDO driver fixed a bind variable translation bug where output binds followed by := would not be detected dropped zope support (for now) dropped PHP Pear DB support refactored init script - one script should work on all platforms now updated init script installation - should work on virtually all unixes added OS X launchd configuration updated the sqlr-listener to clean up files related to ipc, sockets and marking whether the db is up or down on exit sqlr-start no longer starts the cache manager added a second init script for the cache manager plugins are statically linked into libsqlrserver if the platform doesn't support shared libraries (or if --disable-shared is specified at configure time) the perl API should build with old versions of perl (5.00X) on older platforms (redhat 4.2, 5.2, 6.2, etc.) now updated postgresql bind docs added dateyyyyddmm parameter added yyyyddmm parameter to translatedates translation added SQLR_MYSQL_DATE_YYYYDDMM envrionment variable to mysql drop-in library added SQLR_ODBC_DATE_YYYYDDMM envrionment variable to odbc driver 0.52 - sqlrsh has long reported the wrong version, fixed that added csv support to sqlr-export and a -format xml|csv option replaced snprintf calls with charstring::printf calls added a test for sys/vnode.h to work around an issue with perl on SCO OSR6 added workarounds for old versions of sqlite without sqlite3_malloc and sqlite3_free with char * argument fixed error with sqlserver where "describe " would return columns in alphabetical order rather than the order they are in the table the code freetds uses to get column names from MS SQL Server works for temp tables now added informix->mssqlserver translation for select into queries added translation to convert ||'s to concat() calls or +'s added a long-missing "delete clientsock" to sqlrlistener that could cause a crash after enough time various documentation tweaks added handling for "select into" queries to temptableslocalize/sybaseize translations fixed various crashes that could occur when a query filter was used updated the query routing and filtering doc sqlrsh supports multiple commands on a single line or on the command-line now exit/quit in a sqlrsh script aborts the script now improved date/time parsing for translations and result-set conversions fixed lots of cases where const char *'s were being deleted added 64-bit build support for windows combined sqlrclient files for faster compiling converted \t to actual tab in regular expressions for posix-compatibility 0.51 - fixed minor perl DBI driver documentation issue added support for oracle 12c added support for db2 10.1 and 10.5 updated docs for oracle 12c, db2 10.1 and 10.5 and sybase 15.7 modernized database installation docs a little fixed db2/sybase detection to take the system architecture into account when searching for libs applied various build-related patches from Ville Silventoinen fixed rpm->rpmbuild in installation docs added ora-00020 to list of errors that will cause the oracle connection to attempt to re-login, per Ville Silventoinen fixed some MS SQL Server/dateddmm parameter issues and updated docs to explain the remaining issues 0.50 - fixed sqlrserver-config script to return data for libsqlrserver rather than libsqlrconnection added test for SQLROWSETSIZE for odbc that doesn't define it updated postgresql drop-in library enough to work with psycopg2-2.4 with various caveats and tweaks fixed NULL dereference in custom_nw logger added support for dbversion, show tables/databases and describe for SQL Server via freetds fixed a subtle bug that could cause the wrong triggers to be run fixed a reference-after-free in sqltranslations::removeReplacementTable fixed an uninitialized variable (sqltr) in sqlrcontroller class updated the freetds connection to support multiple cursors correctly added config parameters for reformatting dates in the result set added various query translations for mssqlserver added an mssqlserver error map for the mysql drop-in library fixed a memory leak in the freetds version-checking code added new search paths and default prefix for syllable added support for null-terminated result bind lists to the mysql drop-in library so apps can optionally bind fewer columns than come back in the result set added configure tests for php-config- 0.49 - fixed various issues that came up when cross-compiling fixed make uninstall to remove a few things that it missed fixed -pthread annoyance added -Werror to default build for most components fixed various issues revealed by -Werror added password encryption framework added rot,md5 and crypt password encryption plugins moved modules to libexec and removed the libsqlrelay_ prefix moved modules out of the connection directory and into their own directories under src reorganized code tree to compile faster updated clean targets in Makefiles to run faster fixed a bug that could cause problems when fetching from an output bind cursor under a very specific set of circumstances reorganized server code into libsqlrserver implemented the swisscomm log format as a plugin added dbHostName and dbIpAddress methods to the client API refactored authentication to remove a client-server round-trip replaced handoff="reconnect" with handoff="proxy" which uses listener-proxying to remove a client-server round-trip disabled nagle's algorithm for all sockets fixed a bug that could cause a hang if the db login failed updated reading of skip and fetch parameters not to rely on buffering refactored login error reporting fleshed out the ODBC driver significantly added docs for using SQL Relay from ODBC and JDBC refactored windows make.bat script 0.48 - integrated patches from Neowiz for: handling for oracle errors ora-01033, ora-02067 and ora-04068 bind validation when using the statement cache optionally rejecting oracle queries with duplicate bind variables sqlrconnecton::setClientInfo/getClientInfo query logging separate authentication and response timeouts on the client-side environment variables for setting timeouts sqlrelay-level errors for exceeding various bounds improved statistics gathering refactored Oracle re-prepare logic created a query logging framework implemented the current slow query log as a plugin implemented the neowiz query log format as a plugin created a custom query framework implemented the neowiz statistics gathering commands as custom queries added a test program for triggers, translations and other extensions and obscure features fixed several bugs in the informixtooracledates translation added a droplocalizedtemptables trigger added support for "global temporary" to temptableslocalize translation removed oracletemptablespreserverowsbydefault translation - temptableslocalize is much more effective fixed a bug that caused a "no server-side cursors" error to occur if when a new session is started if cursors="0" in sqlrelay.conf the client no longer aborts a result set before sending a new command, it just sends the new command, eliminating a client/server round-trip replaced sqlr-connection-"dbase" with a single sqlr-connection program that loads plugins for each database 0.47 - fixed bug that caused sqlr-export to output negative xml-entity values fixed single-quote-escaping in sqlr-export forced handoff="reconnect" for Cygwin and Linux<2.2 updated all command line programs to use the same command line argument structure added a "fields" command to sqlrsh added a -command argument to sqlrsh so commands and queries can be run from the command line directly renamed query and fields to sqlr-query and sqlr-fields improved readline detection in the configure script added getDatabase/Table/ColumnList support to odbc and mdbtools connections added detection and support for openjdk integrated patches from Neowiz for: using -g3 if available when --enable-debug is specified support for using the oracle statement cache fixing an oracle column-resource-related memory leak eliminating sqlr-start delay "using namespace rudiments" declaration fixes added a faq entry about common OCIEnvCreate errors removed default id warning from sqlr-cachemanager removed coloration from sqlrsh updated begin, commit and rollback to return errors if they fail updated firebird docs added parsing of standalone constraints in a create table query 0.46 - refactored the translation framework to mimic the trigger framework added make.batch file for building on windows added C# API and ADO.NET adapter added begin method to API's added sqlrelay.xsd added date binds applied Georgiy Kirichenko's missing flushWriteBuffer() patch fixed some subtle bugs in the Ruby DBI module that modern versions of Ruby DBI reveal fixed sql parser errors involving "not null" and union clauses added a translation to replace double-quoted string literals with single-quoted string literals fixed a sql parser bug where "group" of a group by clause could be misinterpreted as a table alias updated the scaler to poll 10 times per second and also accept a trigger from the listener to mitigate race conditions that can become problematic when connections="0" is used added C# and ADO.NET docs and updated windows documentation updated the documentation added support for waitfordowndatabase config parameter applied some odbc fixes from Chae Young-ku added explicit support for outer join operators to the sql parser dynamic-ized triggers and translations added a "matches" to "like" translation added a "serial" to "autoincrement" translation fixed debug option to query command line client added javac compile test to configure script fixed an __attribute__ problem that could occur if perl was compiled with gcc>2.95 but used on a system with only gcc-2.95 available fixed an oustanding tcl bug that caused cursors not to be created fixed several bugs related to escaping quotes refactored OS detection in configure script added \n after reading from stdin on Haiku updated docs to reflect that mysql supports ?-based bind vars 0.45 - added trigger framework added support for getting the native database error number added support for mapping native error numbers to MySQL error numbers for the mysql drop-in replacement library renamed all .C files to .cpp for windows added msvc projects for sqlrclient, sqlrclientwrapper, sqlrutil and sqlrsh and got them all working natively on windows updated code so ttl="0" works as expected updated code so dynamic scaling of cursors works as expected documented dynamic scaling of cursors somewhat fixed a few mdbtools errors column aliases work as expected now with firebird fixed a bug where if an app either enabled or disabled autocommit, that could become the default status of autocommit rather than what was set in the config file added autocommit on/off to sqlrsh fixed a bind-var-related memory leak in mysql drop-in lib fixed return values in mysql drop-in lib updated getTableList() to exclude system tables applied Benno Lange's localstatedir patch to fix a case where the localstatedir command line parameter wasn't working properly applied Renat's listener alarm handling patch 0.44 - updated postgresql drop-in lib for postgresql 8/9 compatibility updated mysql drop-in lib for mysql 5.2+ compatibility applied Renat's patch to fix the client session count in the stats added getDatabase/Table/ColumnList method/functions to API's added string inputBind method/function with length added bind variable translation added transaction block emulation @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.5 2009/09/09 14:38:58 joerg Exp $ d10 2 @ 1.7 log @Preserve const. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.6 2011/11/02 13:59:29 fhajny Exp $ d3 7 a9 11 SHA1 (sqlrelay-0.43.tar.gz) = f645332ff0dd14edd2e44643cda651d7c1c59abe RMD160 (sqlrelay-0.43.tar.gz) = 88638f122467c859db2fc5c8fbf983416c7f05bd Size (sqlrelay-0.43.tar.gz) = 1743456 bytes SHA1 (patch-ac) = e69292a2674083ffd10424e73760a0810fd629d8 SHA1 (patch-ad) = a7e7047bcaf28de96a2baab527e4b1f607deb7c6 SHA1 (patch-init__netbsd__rc.d__sqlrelay.in) = b10de222c99ab03a541c9a6a3929928c6936d0f4 SHA1 (patch-src__listener__sqlrlistener.h) = 11f977c48b8e0a01779357475373af738c81d7f3 SHA1 (patch-src_connection_sqlrcursor.h) = 7ce854ad152d2f046f32c6a2bba560e0e8531ab8 SHA1 (patch-src_connection_sqlrcursor_queryparse.C) = 0de5f1fb2388c06fa0a130cd3813e3c6c8fbff74 SHA1 (patch-src_connections_oracle8_oracle8connection.C) = 8e86b79313e42f835d82ed4578c37532022677d9 SHA1 (patch-src_connections_router_routerconnection.C) = 72ae0b42fb53a188e02bfacd704040d22236cfa6 @ 1.6 log @Updated databases/sqlrelay to 0.43 pkgsrc changes: * Added LICENSE to package and options * Pre-create neede volatile directories * Improve the NetBSD rc.d script 0.43 * updated ruby code build to take sitearch into account during includes * updated ruby code to map STR2CSTR to StringValuePtr for ruby 1.9 * updated to use rudiments' updated signalclasses * replaced calls to fork() and exit() with process class calls * updated ruby detection in configure script * added a test for Python.h to the configure script * updated tcl detection * updated db2 detection * added sed command to remove -arch args from perl build (for osx) * added charset support for all db's who's client libraries support them * updated detection of various languages and db's on various platforms * added getting started with odbc doc * updated faq with info about result sets from stored procedures 0.42 * fixed a bug causing cursor id's not to get set for some db's * updated configure script to look for client64 in addition to client for oracle intantclient on x86_64 * added setTimeout to all API's * applied some patches from Alexey Leontev * bumped BINDVARLENGTH up to 64 * applied Renat Sabitov's scaler -debug patch and 11g configure patch * applied Stephan van Egmond's sqlrsh history patch * added configure test for gmake, use it to find ruby.h * applied mingang@@taobao.com's scaler patch for -debug * added getting started notes for Oracle 11.2 on Fedora Core 12 * added test for mdb_sql_run_query and code to use it if it's there * fixed a bug that caused ping to fail after reconnecting to sybase * added configure test for xsubpp * fixed perl dbi inout bind problem * fixed code that was adding a NULL terminator to oracle clob values * applied several patches from Renat Sabitov * applied dynamic cursor patch from Cal Heldenbrand * applied Claudio Freire's normalized matching and xmlparsing patches * fixed sqlite connection to use sqlite3_malloc/free * update freetds connection to get tds version with ct_config if TDS_VERSION_NO doesn't exist * applied a fix for a bug that could cause a crash when a cursor is reused * fixed a shutdown race condition in connection daemons * moved common startup/shutdown code for connection daemons up into static methods/variables of the sqlrconnection_svr class * fixed a crash in the oracle connection daemon where OCIHandleFree was getting called on define handles that weren't created by OCIHandleAlloc * removed rebuild target from Makefiles * updated tests * refactored main() method for connections * added searches for ruby1.8, ruby19 and ruby1.9 in configure script * fixed a bug that caused addresses="" to cause the sqlr-listener not to start * added entries to FAQ about oracle instantclient and ubunu /bin/dash * updated postgresql tests to use bpchar rather than char(20) for fetching results of stored procedure * renamed interbase.create.sh to firebird.create.sh * fixed a bug that could overrun the postgresql bind array * fixed bug that caused connection daemon sockets to be double-freed on shutdown after a suspended session * precision/scale in output bind buffers is initialized now * debugstring buffers are no longer build when debug is turned off * fixed id vs. index bug when requesting a cursor and binding a cursor * refactored JNI code a bit, fixed getIntField/getLongField problem that caused problems on 64-bit machines * applied patch to make python api return decimals and integers, not just strings, refactored some of it * fixed dump tran docs in getting started with sybase to use sa * updated sybase connection to use length of cursor name rather than CS_NULLTERM to work around an odd, inconsistent bug that would cause the connection to hang sometimes * connections not spawned by scaler don't signal on the semaphore used by the scaler to wait for a connection to start now * updated bind var docs * updated faq * fixed a bug where binding an oracle cursor didn't reset some values and would cause subsequent cursor binds to fail * added note to docs about configuring sybase to dump transactions at each checkpoint * applied Renat Sabitov's patch to kill scaler-started connections which fail to signal on sem(8) because they either crashed or got hung up trying to start * fixed a bug in the mysql drop-in lib that could cause the client to run out of cursors * added a mapping between sqlite3_free and sqlite_freemem * added a fix for a race condition in the scaler * fixed a postgresql bind memory leak * applied Renat's ruby DESTDIR patch and updated helper scripts to remove $(DESTDIR) from all the variables that it outputs * applied Renat's patch to handle semaphore failures in forked listeners during shutdown * applied Renat's patch to move connection counting for scaler-spawned connections entirely into scaler itself * applied Renat's patch to reap children more regularly and refactored it a little * fixed distclean to remove perl .pm files * changed maxsessioncount default to 0, updated docs, examples 0.41 * added configure test for ruby.h * added a couple of new functions to the mysql drop-in library * updated mysql drop-in lib docs explaining how to use with PHP * added documentation for timequeries params * if SQLConnectW isn't supported, ODBC driver uses non-unicode calls * added maxsessioncount parameter and connections use it to override ttl and bleed off * applied Renat Sabitov's output bind patch * added mysql last_insert_id() note to FAQ * made it so oracle_home doesn't need to be set if oracle_sid is specified in tnsnames.ora format 0.40 * fixed readline detection in configure script * fixed an uninitialized variable in sqlr-import * changed clientSession() to call endSessionCommand() instead of endSession() so endSessionInternal() would be called every time * fixed debug option in sqlr-import and sqlr-export * fixed postgresql typemangling=no option * set dbversion to unknown if sp_version wasn't found in freetds/sybase * output bind variables' null indicator is reset now * updated postgresql typemangling * included Jesse Wagner's oracle 11g acsite patch * added +1 to inbindvars[i].valuesize for CLOB's to make sure the NULL terminator is included * postgresql connection uses PQparameterStatus if PQserverVersion doesn't exist and runs "select version()" if PQparameterStatus doesn't exist; to get the db version * added mysql-5.1 drop-in replacement lib * fixed a bug that caused result set data not to be cleaned up before a cursor is reused as a bind cursor * changed string bind length to uint32_t from uint16_t * added clearBinds() call after executeQuery() in perl dbi driver * began work on an ODBC driver * added serverVersion and clientVersion methods * incorporated Alfred Fazio's python api patches * fixed a bug where cursors might not get aborted when a client disconnects * made shared memory segment group-readable * applied Renaud Amar's HAVE_MYSQL_OPT_RECONNECT patch * added ODBC driver to spec file * added DESTDIR= to .pc files * made freetds use single-quote for escape character, other db's use backslash * made sqlr-export/import use &##; for non-printable characters, &, < and > * fixed scaler; supports -localstatedir option properly now * fixed many it's -> its typos in the documentation * changed debug so that only one binary is built and it's selected at runtime * integrated erlang api * added -localstatedir to sqlr-stop * fixed mysql (with statement api) relogin problems * removed non-functional config app * added Oracle 11g on fc9 document * added ASE 15.0.2 installation doc * made it possible to only bind to port, not socket * added test for tdsver.h 0.39 * removed oracle7 support * added OCI_OBJECT to oracle environment init * added some more error codes to oracle's dead connection test * connections don't decrement connection count when they fail to log in now :) * added -silent option to connections that scaler uses so they don't spew login errors if the db is down * fixed a bug that disabled scaling if maxlisteners was -1 (the default, which means no maximum) * freetds, db2 connection don't detach before logging in any more * added reloginatstart config parameter * fixed sendLob for oracle<8i * applied Johnny Luong's postgresql drop-in lib patch * applied Jason McClellen's perl dbi raise-error patch * sybase/freetds use CS_SEVERITY instead of msgp->severity now * added 64 bit sybase tests * postgresql only uses PQexecPrepared if PQprepare also exists * set LANG=POSIX before running ruby/make so sed's would work on non-us locales * documented how to use mysql stored procedure output parameters * applied james@@thoughtpatterns.com's perl null bind patch * applied Tim Bunce's perl dbi driver patch * suppress error message of cat $ORACLE_HOME/lib/sysliblist in configure script * added support for stored procedures which return result sets to sybase connection * added support for stored procedures which return result sets to freetds connection but it doesn't actually return anything * documented how to use sybase stored procedure result sets * fixed a bug that caused zope to get an exception when result sets are empty * configure looks for instantclient if it can't find anything in ORACLE_HOME, added --with-oracle-instantclient-prefix option * added sybase ASE 15 install doc * fixed a bug that caused the router connection to return a max of 10 rows * applied Chris Coyle's mysql auto-reconnect patch * modified countBindVariables to exclude :'s and @@'s if it finds $'s or ?'s * applied some of Tim Bunce's DBI patches * added pid cleanup to init script similar to patch supplied by Ragnar Rova * added validBind() method which will return whether a bind variable is in the query or not * fixed Yeb Havinga's db-tier authentication bug * added timequeries option * added support for Oracle OS-authentication * added some new FAQ's * mysql connection calls commit() before running the first query after each new client connection * fixed a crash in the router involving "fake begin's" * documented msql transaction weirdness and db2 relogin issues * added /opt/csw to configure script search path * improved filtering out of -x arguments in perl/ruby make commands * added -lruby, -lperl, -lpython, etc for OS X 0.38 * implemented mysql_stmt function support in mysql connection * fixed mysql_autocommit detection * fixed missing self before __getRow and __getRowRange in python db driver * implemented query filtering and routing * interbase/firebird dead-db/relogin works now * added test for 0 length result set to PySQLRDB's fetchmany method * added mysql_config sanity test to configure script * NULL's are escaped in fake input BLOB binds now * query router works pretty well now * applied Sharpinskiy Dmitry's odbc unicode patch * integrated Devananda's statistics gathering code * added support for mysql stored procedures * integrated Devananda's mysql result set updates * sqlrelay.conf.example installed as $datadir/examples/sqlrelay.conf now * integrated Andreas Behr's listener crash patch * removed erroneous reference to sqlrcon_errormessage in php pear db * another multibyte clob fix * added "delimiter" command to sqlrsh to change delimiter from ; to whatever * removed msql support * added db2 9.1 installation doc * added firebird 2.0 installation docs * router connection overrides authtier=database * fixed a bug where clients would hang if they requested a cursor when none were available * added some additional mdb 5 checks to configure script * added iconv const char parameter check to configure script * the main listener doesn't listen for clients until all of the connections have started now * added notes about tcp_tw_recycle/tcp_tw_reuse in tuning doc * ping causes the connection to relogin if it returns false now * added iconv include/library find to configure script * fixed sqlrlistener so forked listeners don't remove the pid file * switched oracle 8 column size variable type from sb4 to ub2 * if maxqueuelength>maxlisteners then scaling isn't used @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.5 2009/09/09 14:38:58 joerg Exp $ d10 4 @ 1.5 log @DESTDIR support @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.4 2008/10/03 18:14:46 joerg Exp $ d3 4 a6 6 SHA1 (sqlrelay-0.37.tar.gz) = cec442357f6644c8ac7f066fe974a25c9f315022 RMD160 (sqlrelay-0.37.tar.gz) = 2cad89fe72d6700857280e385ab03c69cd584648 Size (sqlrelay-0.37.tar.gz) = 1668069 bytes SHA1 (patch-aa) = 0684b3382e64569ed222cb19df6e5a1a4a143061 SHA1 (patch-ab) = c05dbc72d1077237efd1d01e48403a7caa38eff9 SHA1 (patch-ac) = 58c456142b9026bd9f41460f5a602aec61fc70cb d8 2 @ 1.4 log @Don't write to /etc, the init script is handled via the RC framework. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.3 2006/03/29 01:28:46 gavan Exp $ d8 1 a8 1 SHA1 (patch-ac) = 0e41838c30a460463b72bfed2791ca8045f04aed @ 1.3 log @Update sqlrelay to 0.37. There are far too many changes to list here. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.2 2005/02/23 16:33:10 agc Exp $ d9 1 @ 1.2 log @Add RMD160 digests in addition to SHA1 ones. @ text @d1 1 a1 1 $NetBSD: distinfo,v 1.1.1.1 2004/04/15 10:37:24 grant Exp $ d3 6 a8 3 SHA1 (sqlrelay-0.33.1.tar.gz) = 41d169fd4221577a594bde3415eb3c734146b746 RMD160 (sqlrelay-0.33.1.tar.gz) = 270e56f80bf688fdd34fa58ee9d44c9bf5667745 Size (sqlrelay-0.33.1.tar.gz) = 1240926 bytes @ 1.1 log @Initial revision @ text @d1 1 a1 1 $NetBSD$ d4 1 @ 1.1.1.1 log @Initial import of sqlrelay-0.33.1 into the NetBSD packages collection. SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux supporting ODBC, Oracle, MySQL, mSQL, PostgreSQL, Sybase, MS SQL Server, IBM DB2, Interbase, Lago and SQLite with APIs for C, C++, Perl, Perl-DBI, Python, Python-DB, Zope, PHP, Ruby, Ruby-DBI, TCL and Java, command line clients, a GUI configuration tool and extensive documentation. The APIs support advanced database operations such as bind variables, multi-row fetches, client side result set caching and suspended transactions. It is ideal for speeding up database-driven web-based applications, accessing databases from unsupported platforms, migrating between databases, distributing access to replicated databases and throttling database access. @ text @@