[sr-dev] git:pd/crocodile: core, srdb1, modules/db_*, modules_k/db_*: Added support for configuring SQL buffer size and mediumblob/ mediumtext in MySQL

Peter Dunkley peter.dunkley at crocodile-rcs.com
Wed Jul 27 13:26:26 CEST 2011


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 at crocodile-rcs.com>
> Committer: pd <peter.dunkley at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev


-- 
Peter Dunkley
Technical Director
Crocodile RCS Ltd
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20110727/95ba1764/attachment.htm>


More information about the sr-dev mailing list