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

[Daniel-Constantin Mierla]

Hi Peter,

thanks for these enhancements, just one note.

The file doc/cfg_list/docbook/cfg_core.xml is auto-generated from the 
cfg reload framework structures, should not be updated manually. Also, 
in this case, the new parameter sql_buffer_size is not in such 
structure. To document it, you have to update the Core Cookbook wiki 
page for devel version:

http://sip-router.org/wiki/cookbooks/core-cookbook/devel

Cheers,
Daniel



On 7/27/11 1:11 PM, 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

-- 
Daniel-Constantin Mierla -- http://www.asipto.com
Kamailio Advanced Training, Oct 10-13, Berlin: http://asipto.com/u/kat
http://linkedin.com/in/miconda -- http://twitter.com/miconda