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=5cd87175...
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=5cd8...
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev