Hello,

I would like to request that you consider this change for inclusion in the master branch of Kamailio.  I have committed it to a branch as it is a substantial change and wanted others to consider it before trying to put it into the master branch.

This change has been tested with MySQL and PostgreSQL but it does impact the other database modules too.

This change is required because we need to be able to store and retrieve XML documents that exceed 64k in size.  It is a pre-requisite for the next two commits on my branch (6033da2e644ccdca7fa57bee03f82cb03c36e45e and 8623eeb1c2762d299cd88e0b7bc8d8fdb8fa2a72).

Thanks,

Peter

On Wed, 2011-07-27 at 13:11 +0200, Peter Dunkley wrote: 
Module: sip-router
Branch: pd/crocodile
Commit: 5cd87175faa97161023c37e2cc0f0c064e08d571
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5cd87175faa97161023c37e2cc0f0c064e08d571

Author: pd <peter.dunkley@crocodile-rcs.com>
Committer: pd <peter.dunkley@crocodile-rcs.com>
Date:   Wed Jul 27 11:50:20 2011 +0100

core, srdb1, modules/db_*, modules_k/db_*: Added support for configuring SQL buffer size and mediumblob/mediumtext in MySQL

- Currently the SQL buffer size is hard-coded to 64k.  This isn't
  enough in some cases.  For example, it is easily possible for
  resource lists (which can be Network Address Books) to be larger
  than 64k.
- The default buffer size is still 64k, but this can be overriden
  with the new "sql_buffer_size" configuration option.
- Support added for mediumblob/mediumtext in MySQL as the blob/text
  types that are currently supported are limited to 64k.
- Feature added by Andrew Miller at Crocodile RCS

---

 cfg.lex                                        |    2 +
 cfg.y                                          |    3 +
 doc/cfg_list/docbook/cfg_core.xml              |   12 +++
 doc/stylesheets/dbschema_k/xsl/db_berkeley.xsl |    4 +-
 doc/stylesheets/dbschema_k/xsl/db_sqlite.xsl   |    6 +-
 doc/stylesheets/dbschema_k/xsl/dbtext.xsl      |    4 +-
 doc/stylesheets/dbschema_k/xsl/mysql.xsl       |   12 +++
 doc/stylesheets/dbschema_k/xsl/oracle.xsl      |    6 +-
 doc/stylesheets/dbschema_k/xsl/postgres.xsl    |    6 +-
 globals.h                                      |    1 +
 lib/srdb1/db_query.c                           |  102 ++++++++++++++----------
 lib/srdb1/db_query.h                           |    9 ++
 lib/srdb1/db_ut.h                              |    5 -
 main.c                                         |    2 +
 modules/db_berkeley/km_db_berkeley.c           |    3 +-
 modules/db_mysql/km_db_mysql.c                 |    2 +-
 modules/db_mysql/km_dbase.c                    |   42 ++++++++---
 modules/db_postgres/km_db_postgres.c           |    3 +-
 modules_k/db_oracle/db_oracle.c                |    3 +-
 modules_k/db_sqlite/db_sqlite.c                |    2 +-
 modules_k/db_unixodbc/db_unixodbc.c            |   25 ++++--
 21 files changed, 175 insertions(+), 79 deletions(-)

Diff:   http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=5cd87175faa97161023c37e2cc0f0c064e08d571

_______________________________________________
sr-dev mailing list
sr-dev@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev


-- 
Peter Dunkley
Technical Director
Crocodile RCS Ltd