FreeBSD ports tree https://cgit-dev.freebsd.org/ports/atom?h=2017Q2 2017-03-26T09:49:52Z 2017-03-26T09:49:52Z Kurt Jaeger pi@FreeBSD.org 2017-03-26T09:49:52Z urn:sha1:96f080dbe5b2da4928c6e39d32ec49d9d1f9b07e databases/sqlrelay: update 1.0.0 -> 1.0.1 rudiments: - added support for EOT to codetree - added loop-avoidance to xmldomevents class - added alias support to codetree class - replaced readline with libedit - included implementation of history_truncate_file for versions of libedit that don't provide it - added --disable-wall and --disable-werror configure options sqlrelay: - updated sqlr-bench to create "db"-bench.png - added edoc-generated API docs for the Erlang API - updated some module-load error verbage - added initial support for loading Oracle, SAP/Sybase, DB2, and Informix libraries on-demand at runtime - overhauled spec file - fixed PDO driver for PHP 7 on 32-bit platforms - added permissions to all open() with O_CREAT calls - added --with-fortify configure option - fixed a segfault on ctrl-D in sqlrsh - fixed uncoordinated access to shared debugstr among listener threads by using local instances instead - added ping-loop to router connection module's logIn() method to manage cases where routed-to instances are started after the router - moved .../var/sqlrelay/tmp/*/* to .../var/run/sqlrelay - added .sock extension to sockets, .ipc extension to ipc key files, .pid extension to pid files, and .up extension to files which indicate that the db is up - changed mode of listener-connection sockets to 700 from 711 - moved .../var/sqlrelay/log to .../var/log/sqlrelay - moved .../var/sqlrelay/cache to .../var/cache/sqlrelay - libmysql*sqlrelay.so and libpqsqlrelay.so are no longer installed - replaced sockseq-generated unix socket with pid-based unix socket - updated ruby api to support unification of Fixnum and Bignum classes into Integer class - added --with-abs-max-connections configure script parameter - increased default absolute max connections to 4096 (from 512) - updated "can't open ... file" errors to mention user/group - added SQLR_MYSQL_MAP_DATE_TO_DATETIME option to mysql drop-in replacement library - fixed normalize translation not to remove spaces before unary - and ! - updated sqlrsh to set error code correctly and write errors to stderr - sqlr-cachemanager is no longer enabled at boot by default - fixed another subtle bug in the ODBC driver that caused the first row to be duplicated if columns were not bound - added --disable-wall and --disable-werror configure options 2017-02-23T04:35:17Z Bryan Drewery bdrewery@FreeBSD.org 2017-02-23T04:35:17Z urn:sha1:1147abf53a53e2043d9cb518742e9eeb9309ca4f 2017-01-19T19:50:29Z Kurt Jaeger pi@FreeBSD.org 2017-01-19T19:50:29Z urn:sha1:783452a79cf6c3eed59c669b6db5f038f609c498 databases/sqlrelay: update 0.67.0 -> 1.0.0 Recommended reading: http://software.firstworks.com/2016/12/benchmarking-sql-relay-100.html http://software.firstworks.com/2016/12/rudiments-100-release-announcement.html http://software.firstworks.com/2016/12/rudiments-102-release-announcement.html http://software.firstworks.com/2016/12/sql-relay.html 2016-11-21T21:13:28Z Kurt Jaeger pi@FreeBSD.org 2016-11-21T21:13:28Z urn:sha1:5a8083d82d703eedc2edf1b99624a57a1766bd89 databases/sqlrelay: update 0.66.0 -> 0.67.0 http://software.firstworks.com/2016/11/rudiments-0570-release-announcement.html http://software.firstworks.com/2016/11/sql-relay-0670-release-announcement.html 2016-10-09T16:10:59Z Kurt Jaeger pi@FreeBSD.org 2016-10-09T16:10:59Z urn:sha1:ef2ff73de3cee8925c992618c279b6feb9730fe0 databases/sqlrelay: 0.65.0 -> 0.66.0 Changes: http://software.firstworks.com/2016/09/version-0.html http://software.firstworks.com/2016/09/sql-relay-0660-release-announcement.html 2016-04-03T10:17:44Z Kurt Jaeger pi@FreeBSD.org 2016-04-03T10:17:44Z urn:sha1:7962caf263dd651e3741207a8be360730cdbde80 databases/sqlrelay: 0.64 -> 0.65.0 rudiments: - file::open sets errno=ENOENT if the file or path wasn't found on Windows now - fixed a bug with filedescriptor::printf when printing to non-buffered files on Windows and Solaris 11 - fixed a bug that caused a crash in codetree if codeposition is NULL - added missing dll export clause to codetreegrammar class - added xmldomevents class - added namespace discrimination in codetree::write - fixed a codetree end-of-string-during-concatenation bug - fixed a codetree tree reset bug - fixed an xmlsax bug that caused text nodes with empty values to be inserted between tag nodes when there is no text between tags - added escapechar option to filedescriptor::read-until-terminator methods - added a generic securitycontext class and integrated it with filedescriptor - implemented GSS/SSPI and TLS/SSL children of securitycontext - removed old SSL integration with filedescriptor - updated inet/unixsocketclient to close() as the first step of connect() - updated charstring::to(Unsigned)Integer-with-endptr methods to have const char **endptr arguments - updated configure script to find erlang on openbsd 5.8 - buffers allocated by vasprintf are free()'ed now rather than deleted - fixed a commandline bug that could cause it to return the next parameter for getValue() of a parameter with no value - fixed connect()/useBlockingMode error masking bug - removed -revision during link and adopted Semantic Versioning 2.0 - added pthread_create/EAGAIN retry - added methods to configure and examine process::fork and thread::run retry behavior - thread methods test for invalid thread before operating on it now - charstring::split doesn't crash if list or listlength are null now - added debugprint header - removed problematic thread::cancel() method - added thread::runDetached() methods - removed useBlockingMode() call in stdio constructor as is caused problems with apps like Apache that actually need stdin/out/err to be in non-blocking mode sometimes sqlrelay: - removed erroneous SQLR_SQLExecute export in ODBC driver - fixed call type of internal ODBC driver functions and made them static - fixed --disable-API flags in configure.vbs - fixed bad user/password copy logic in ODBC SQLConnect function - added missing default implementation of sqlrservercursor::getColumnTypeName() - added parser debug option - normalize translation can convert foreign decimals now - updated missing-tnsnames.ora warning - updated sqlr-start and sqlr-scaler to run programs using fully qualified path names - fixed query timer in sqlrsh - add timer="query/command" parameter to slowqueries logger - added odbcversion parameter to ODBC connection - updated erlang api to use the C++ compiler to link (for netbsd 7.0) - added major-version check to node.js api for node 4.x+ - ODBC driver's SQLGetData can deal with NULL targetvalue now - fixed normalize || bug - fixed normalize bug that removed spaces around * for "all columns" improperly - removed freetds warning, modern sybase has different library file names - updates to support python3 - added several --disable options to the configure script for unix/linux - removed sqlr-fields/sqlr-query and updated sqlrsh to provide the same functionality - removed antiquated sqlrelay.dtd - moved default example directory to share/sqlrelay/examples - sqlrelay.conf example is installed under example directory now - Python DB -> Python DB-API in the docs - moved private members and support classes into C++ API's .cpp files - removed -revision during link and adopted Semantic Versioning 2.0 - added missing get*List methods to Java API - removed errant information_schema views from getTableList with mysql - refactored listenertimeout to use timed semaphore ops and only fall back to an alarm if the system doesn't support timed sem ops and the instance isn't configured to use threads - fixed inode-check in logger modules - works correctly with logrotate - change "an error occurred" to "server closed connection" to reduce false-positives from log analyzers - "real" errors will still be reported elsewhere - refactored the config file parser - added support for kerberos authentication and encryption - added krb_userlist auth module - renamed "authentication" to "auth" (for authentication/authorization, also matches module name prefix) in config file and docs - removed an errant flushWriteBuffer after client auth - moved debugprint stuff into rudiments - added support for tls authentication and encryption - added tls_userlist auth module - fixed long-standing copyrefs bug - when calling after-triggers, "success" flag is set correctly now - fixed bug where after-triggers could mask failed queries - added support for "before and after" triggers - moved call to set stdinput to use blocking mode from rudiments::stdiofiledescriptor to sqlrsh, as doing it in every case caused problems with apps like Apache, which need stdin/out/err to be in non-blocking mode sometimes (fixes bug where PHP's that used the SQL Relay API would cause apache workers to hang closing connections after a graceful restart) - made auth_database module always re-login - added auth_proxied module to support Oracle's (and potentially other databases') n-tier/proxied authentication - fixed a long-standing bug where passwords weren't checked when switching between oracle n-tier authenticated users 2015-10-17T13:07:40Z Kurt Jaeger pi@FreeBSD.org 2015-10-17T13:07:40Z urn:sha1:8fc64b581ef9953af78026e6d4bc4acf7fd60aa0 databases/sqlrelay: 0.63 -> 0.64 Changes rudiments: http://software.firstworks.com/2015/10/rudiments-054-release-announcement.html Changes sqlrelay: http://software.firstworks.com/2015/10/sql-relay-064-release-announcement.html 2015-09-02T20:35:02Z Kurt Jaeger pi@FreeBSD.org 2015-09-02T20:35:02Z urn:sha1:c1368f6f2af8b945867b09657a22e2a5a0a0a622 databases/sqlrelay: 0.62 -> 0.63 0.53 - exposed codetreegrammar class and updated codetree class so that successive parses/writes can use the same grammar without having to reload it added insert/appendXml(File) methods to xmldomnode to parse and insert/append xml strings or files to a node fixed FILE->fileno detection for solaris 11.2, which doesn't have it at all llabs() is detected and preferred to abs() added partial xml namespace support (namespaces for tags) added partial support for extended ascii character set to character class added setgroups() call before setuid() call to drop extraneous groups updated rudiments-config man page, slightly removed outdated and unused dtd class updated file::resolveSymbolicLink() to use directory::maxPathLength(filename) as a starting point updated directory::getCurrentDirectory() to use MAX_PATH as a starting point serialport/serialportprofile, modemserver/modemclient classes are disabled in the default build now updated intro docs 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 2015-08-08T12:11:27Z Kurt Jaeger pi@FreeBSD.org 2015-08-08T12:11:27Z urn:sha1:63fd3b0cedb51d331e24ff1b136ebdd0c2b53483 - 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 2015-06-21T11:52:03Z Kurt Jaeger pi@FreeBSD.org 2015-06-21T11:52:03Z urn:sha1:0577896d34a66a4d650005b7bff93d37549b15b5 databases/sqlrelay: 0.59 -> 0.60 - Both packages are updated together. - Lots of changes in devel/rudiments, see ChangeLog - Fixes in sqlrelay: o fixed true->false transposition in sqlrservercontroller::interceptQuery that could lead to a reLogIn loop o applied George Carrette's patch to fix PDO connectstring options o migrated directory/file paths info into sqlrpaths class o removed undocumented and not-so-relevent-these-days o MAX_CONNECTIONS/overridemaxconnections failsafe in sqlr-start o fixed java header detection for javac located in /usr/bin o updated java api to support non-null-tolerant implementations of environment::NewStringUTF() o the perl api builds correctly on OSR5 again o 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 o mono 2.8 or greater is required now o added a datedelimiters attribute to the instance tag in sqlrelay.conf to limit what date delimiters are used when translating dates o re-added mssqlserver detection, which had been accidentally removed o fixed statically-linked build o fixed mysql lob field bug that could cause a crash