head 1.5; access; symbols pkgsrc-2022Q3:1.4.0.50 pkgsrc-2022Q3-base:1.4 pkgsrc-2022Q2:1.4.0.48 pkgsrc-2022Q2-base:1.4 pkgsrc-2022Q1:1.4.0.46 pkgsrc-2022Q1-base:1.4 pkgsrc-2021Q4:1.4.0.44 pkgsrc-2021Q4-base:1.4 pkgsrc-2021Q3:1.4.0.42 pkgsrc-2021Q3-base:1.4 pkgsrc-2021Q2:1.4.0.40 pkgsrc-2021Q2-base:1.4 pkgsrc-2021Q1:1.4.0.38 pkgsrc-2021Q1-base:1.4 pkgsrc-2020Q4:1.4.0.36 pkgsrc-2020Q4-base:1.4 pkgsrc-2020Q3:1.4.0.34 pkgsrc-2020Q3-base:1.4 pkgsrc-2020Q2:1.4.0.30 pkgsrc-2020Q2-base:1.4 pkgsrc-2020Q1:1.4.0.10 pkgsrc-2020Q1-base:1.4 pkgsrc-2019Q4:1.4.0.32 pkgsrc-2019Q4-base:1.4 pkgsrc-2019Q3:1.4.0.28 pkgsrc-2019Q3-base:1.4 pkgsrc-2019Q2:1.4.0.26 pkgsrc-2019Q2-base:1.4 pkgsrc-2019Q1:1.4.0.24 pkgsrc-2019Q1-base:1.4 pkgsrc-2018Q4:1.4.0.22 pkgsrc-2018Q4-base:1.4 pkgsrc-2018Q3:1.4.0.20 pkgsrc-2018Q3-base:1.4 pkgsrc-2018Q2:1.4.0.18 pkgsrc-2018Q2-base:1.4 pkgsrc-2018Q1:1.4.0.16 pkgsrc-2018Q1-base:1.4 pkgsrc-2017Q4:1.4.0.14 pkgsrc-2017Q4-base:1.4 pkgsrc-2017Q3:1.4.0.12 pkgsrc-2017Q3-base:1.4 pkgsrc-2017Q2:1.4.0.8 pkgsrc-2017Q2-base:1.4 pkgsrc-2017Q1:1.4.0.6 pkgsrc-2017Q1-base:1.4 pkgsrc-2016Q4:1.4.0.4 pkgsrc-2016Q4-base:1.4 pkgsrc-2016Q3:1.4.0.2 pkgsrc-2016Q3-base:1.4 pkgsrc-2016Q2:1.3.0.8 pkgsrc-2016Q2-base:1.3 pkgsrc-2016Q1:1.3.0.6 pkgsrc-2016Q1-base:1.3 pkgsrc-2015Q4:1.3.0.4 pkgsrc-2015Q4-base:1.3 pkgsrc-2015Q3:1.3.0.2 pkgsrc-2015Q3-base:1.3 pkgsrc-2015Q1:1.1.0.4 pkgsrc-2015Q1-base:1.1 pkgsrc-2014Q4:1.1.0.2 pkgsrc-2014Q4-base:1.1; locks; strict; comment @// @; 1.5 date 2022.12.03.15.53.40; author adam; state dead; branches; next 1.4; commitid cgKl8mED8BOfY74E; 1.4 date 2016.07.01.17.02.39; author fhajny; state Exp; branches; next 1.3; commitid rNWqTGm4CjPQKDcz; 1.3 date 2015.07.05.12.52.39; author joerg; state Exp; branches; next 1.2; commitid P4J6cInwDQuZ06sy; 1.2 date 2015.05.20.13.26.45; author ryoon; state dead; branches; next 1.1; commitid cV2P7XSYwbNkGbmy; 1.1 date 2014.11.17.19.00.39; author joerg; state Exp; branches; next ; commitid dzveM0GYueDDrzYx; desc @@ 1.5 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: patch-src_api_php_sql__relay.cpp,v 1.4 2016/07/01 17:02:39 fhajny Exp $ --- src/api/php/sql_relay.cpp.orig 2016-03-13 19:20:25.000000000 +0000 +++ src/api/php/sql_relay.cpp @@@@ -24,39 +24,15 @@@@ #define ZTS 1 #endif -extern "C" { - #ifndef WIN32 - - // On some platforms (solaris), stdio.h must be included prior - // to including math.h or FILE will get redefined. - #include - - // php.h ultimately includes math.h and on some platforms, - // __cplusplus to be defined when including it. Manually - // including it prior to including php.h solves this problem. - #include - - #ifdef __cplusplus - #undef __cplusplus - #define cpluspluswasdefined - #endif - #ifndef HAVE_SOCKLEN_T - #define HAVE_SOCKLEN_T - #endif - #ifndef _WCHAR_T_DECLARED - #define _WCHAR_T_DECLARED - #endif - #ifndef _WCHAR_T_DEFINED_ - #define _WCHAR_T_DEFINED_ - #endif - #endif - #include - #ifndef WIN32 - #ifdef cpluspluswasdefined - #define __cplusplus - #endif - #endif -} +// On some platforms (solaris), stdio.h must be included prior +// to including math.h or FILE will get redefined. +#include + +// php.h ultimately includes math.h and on some platforms, +// __cplusplus to be defined when including it. Manually +// including it prior to including php.h solves this problem. +#include +#include #include @ 1.4 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: patch-src_api_php_sql__relay.cpp,v 1.3 2015/07/05 12:52:39 joerg Exp $ @ 1.3 log @Restore patch for src/api/php/sql_relay.cpp: Do not pretend that C++ is C. @ text @d1 1 a1 1 $NetBSD$ d3 1 a3 1 --- src/api/php/sql_relay.cpp.orig 2015-07-05 10:40:12.000000000 +0000 d5 1 a5 1 @@@@ -16,29 +16,7 @@@@ d11 10 d42 8 @ 1.2 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: patch-src_api_php_sql__relay.cpp,v 1.1 2014/11/17 19:00:39 joerg Exp $ d3 1 a3 4 Don't mess with system headers by pretending to be C or removing defines. Just expect php.h to work. --- src/api/php/sql_relay.cpp.orig 2014-09-02 01:51:20.000000000 +0000 d5 3 a7 3 @@@@ -3,39 +3,7 @@@@ #include a8 13 -#ifdef WIN32 - #undef uid_t - #undef gid_t - #undef ssize_t - #undef socklen_t - #undef pid_t - #undef mode_t - #define PHP_WIN32 - #define ZEND_WIN32 - #define ZEND_DEBUG 0 - #define ZTS 1 -#endif - d18 3 @ 1.1 log @Don't pretend that C++ is C. @ text @d1 1 a1 1 $NetBSD$ @