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

1 files changed, 26 insertions, 12 deletions

diff --git a/databases/sqlrelay/PLIST b/databases/sqlrelay/PLIST
index 4514edf09a2..b84c9fa3f90 100644
--- a/databases/sqlrelay/PLIST
+++ b/databases/sqlrelay/PLIST
@@ -1,24 +1,20 @@
-@comment $NetBSD: PLIST,v 1.7 2009/06/14 17:43:26 joerg Exp $
+@comment $NetBSD: PLIST,v 1.8 2011/11/02 13:59:29 fhajny Exp $
 bin/backupschema
 bin/fields
 bin/query
 bin/sqlr-cachemanager
 ${PLIST.freetds}bin/sqlr-connection-freetds
-${PLIST.freetds}bin/sqlr-connection-freetds-debug
 ${PLIST.mysql}bin/sqlr-connection-mysql
-${PLIST.mysql}bin/sqlr-connection-mysql-debug
 ${PLIST.odbc}bin/sqlr-connection-odbc
-${PLIST.odbc}bin/sqlr-connection-odbc-debug
 ${PLIST.pgsql}bin/sqlr-connection-postgresql
-${PLIST.pgsql}bin/sqlr-connection-postgresql-debug
+bin/sqlr-connection-router
 ${PLIST.sqlite}bin/sqlr-connection-sqlite
-${PLIST.sqlite}bin/sqlr-connection-sqlite-debug
 bin/sqlr-export
 bin/sqlr-import
 bin/sqlr-listener
-bin/sqlr-listener-debug
 bin/sqlr-scaler
 bin/sqlr-start
+bin/sqlr-status
 bin/sqlr-stop
 bin/sqlrclient-config
 bin/sqlrclientwrapper-config
@@ -36,18 +32,18 @@ lib/libmysql3sqlrelay.la
 lib/libmysql40sqlrelay.la
 lib/libmysql41sqlrelay.la
 lib/libmysql50sqlrelay.la
+lib/libmysql51sqlrelay.la
 lib/libpqsqlrelay.la
 lib/libsqlrclient.la
 lib/libsqlrclientwrapper.la
 lib/libsqlrconnection.la
-lib/libsqlrconnection_debug.la
+${PLIST.odbc}lib/libsqlrodbc.la
 lib/libsqlrutil.la
 lib/pkgconfig/sqlrelay-c++.pc
 lib/pkgconfig/sqlrelay-c.pc
 man/man1/fields.1
 man/man1/query.1
 man/man1/query.py.1
-man/man1/sqlr-config-gtk.1
 man/man1/sqlrsh.1
 man/man8/sqlr-cachemanager.8
 man/man8/sqlr-connection.8
@@ -94,23 +90,38 @@ share/doc/sqlrelay/css/styles.css
 share/doc/sqlrelay/dropin/mysql.html
 share/doc/sqlrelay/dropin/postgresql.html
 share/doc/sqlrelay/faq.html
+share/doc/sqlrelay/gettingstarted/blackray.html
 share/doc/sqlrelay/gettingstarted/db2.html
-share/doc/sqlrelay/gettingstarted/interbase.html
-share/doc/sqlrelay/gettingstarted/msql.html
+share/doc/sqlrelay/gettingstarted/db2/72.html
+share/doc/sqlrelay/gettingstarted/db2/81.html
+share/doc/sqlrelay/gettingstarted/db2/82.html
+share/doc/sqlrelay/gettingstarted/db2/824.html
+share/doc/sqlrelay/gettingstarted/db2/91.html
+share/doc/sqlrelay/gettingstarted/firebird.html
 share/doc/sqlrelay/gettingstarted/mssqlserver.html
 share/doc/sqlrelay/gettingstarted/mysql.html
 share/doc/sqlrelay/gettingstarted/oracle.html
+share/doc/sqlrelay/gettingstarted/oracle/linux/fedoracore/1/10g.html
+share/doc/sqlrelay/gettingstarted/oracle/linux/fedoracore/1/9iR2.html
+share/doc/sqlrelay/gettingstarted/oracle/linux/fedoracore/2/10g.html
+share/doc/sqlrelay/gettingstarted/oracle/linux/fedoracore/3/10g.html
+share/doc/sqlrelay/gettingstarted/oracle/linux/fedoracore/5/10g.html
 share/doc/sqlrelay/gettingstarted/oracle/linux/redhat/5/805.html
 share/doc/sqlrelay/gettingstarted/oracle/linux/redhat/6/8i.html
 share/doc/sqlrelay/gettingstarted/oracle/linux/redhat/7/8i.html
-share/doc/sqlrelay/gettingstarted/oracle/linux/slackware/7/8i.html
+share/doc/sqlrelay/gettingstarted/oracle/linux/redhat/8/9iR2.html
+share/doc/sqlrelay/gettingstarted/oracle/linux/redhat/9/9iR2.html
 share/doc/sqlrelay/gettingstarted/oracle/linux/slackware/8/8i.html
 share/doc/sqlrelay/gettingstarted/oracle/linux/slackware/8/9i.html
+share/doc/sqlrelay/gettingstarted/oracle/linux/suse/9.0/9iR2.html
 share/doc/sqlrelay/gettingstarted/postgresql.html
 share/doc/sqlrelay/gettingstarted/sqlite.html
 share/doc/sqlrelay/gettingstarted/sybase.html
 share/doc/sqlrelay/gettingstarted/sybase/11.0.3.3.html
 share/doc/sqlrelay/gettingstarted/sybase/11.9.2.html
+share/doc/sqlrelay/gettingstarted/sybase/12.5.1.html
+share/doc/sqlrelay/gettingstarted/sybase/12.5.2.html
+share/doc/sqlrelay/gettingstarted/sybase/15.0.2.html
 share/doc/sqlrelay/index.html
 share/doc/sqlrelay/installing.html
 share/doc/sqlrelay/introduction.html
@@ -121,6 +132,8 @@ share/doc/sqlrelay/programming/binds.html
 share/doc/sqlrelay/programming/c++.html
 share/doc/sqlrelay/programming/c.html
 share/doc/sqlrelay/programming/java.html
+share/doc/sqlrelay/programming/jdbc.html
+share/doc/sqlrelay/programming/odbc.html
 share/doc/sqlrelay/programming/perl.html
 share/doc/sqlrelay/programming/perldbi.html
 share/doc/sqlrelay/programming/php.html
@@ -142,5 +155,6 @@ share/doc/sqlrelay/running.html
 share/doc/sqlrelay/tuning.html
 share/doc/sqlrelay/windows.html
 share/examples/rc.d/sqlrelay
+share/examples/sqlrelay/sqlrelay
 share/examples/sqlrelay/sqlrelay.conf.example
 share/examples/sqlrelay/sqlrelay.dtd