![[BACK]](/icons/back.gif){kind=icon}
Up to [cvs.NetBSD.org] / pkgsrc / databases / sqlrelay
Request diff between arbitrary revisions
Default branch: MAIN
Current tag: pkgsrc-2013Q3
Revision 1.7 / (download) - annotate - [select for diffs], Wed Nov 2 13:59:29 2011 UTC (12 years, 5 months ago) by fhajny
Branch: MAIN
CVS Tags: pkgsrc-2014Q1-base,
pkgsrc-2014Q1,
pkgsrc-2013Q4-base,
pkgsrc-2013Q4,
pkgsrc-2013Q3-base,
pkgsrc-2013Q3,
pkgsrc-2013Q2-base,
pkgsrc-2013Q2,
pkgsrc-2013Q1-base,
pkgsrc-2013Q1,
pkgsrc-2012Q4-base,
pkgsrc-2012Q4,
pkgsrc-2012Q3-base,
pkgsrc-2012Q3,
pkgsrc-2012Q2-base,
pkgsrc-2012Q2,
pkgsrc-2012Q1-base,
pkgsrc-2012Q1,
pkgsrc-2011Q4-base,
pkgsrc-2011Q4
Changes since 1.6: +9 -6
lines
Diff to previous 1.6 (colored)
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