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=5cd8717…
Author: pd <peter.dunkley(a)crocodile-rcs.com>
Committer: pd <peter.dunkley(a)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=5cd…
_______________________________________________
sr-dev mailing list
sr-dev(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
--
Peter Dunkley
Technical Director
Crocodile RCS Ltd