| Age | Commit message (Collapse) | Author | Files | Lines |
|---|
|
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
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
Improve ruby-sqlrelay configuration; do not try to detect installed ruby
but use simply RUBY environment variable.
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
https://mail-index.netbsd.org/pkgsrc-changes/2020/01/18/msg205146.html
In the above commit, the homepage URLs were migrated from http to https,
assuming that SourceForge would use the same host names for both http and
https connections. This assumption was wrong. Their documentation at
https://sourceforge.net/p/forge/documentation/Custom%20VHOSTs/ states
that the https URLs use the domain sourceforge.io instead.
To make the homepages from the above commit reachable again, pkglint has
been extended to check for reachable homepages. This check is only
enabled when the --network command line option is given.
Each of the homepages that referred to https://$project.sourceforge.net
before was migrated to https://$project.sourceforge.io (27), and if that
was not reachable, to the fallback URL http://$project.sourceforge.net
(163).
|
|
pkglint --only "https instead of http" -r -F
With manual adjustments afterwards since pkglint 19.4.4 fixed a few
indentations in unrelated lines.
This mainly affects projects hosted at SourceForce, as well as
freedesktop.org, CTAN and GNU.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
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
|
|
|
|
|
|
- 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
|
|
|
|
original manifest.xml file and the output from "svccfg export".
|
|
|
|
|
|
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
|
