<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/4.0.1">
</HEAD>
<BODY>
Hello,<BR>
<BR>
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.<BR>
<BR>
This change has been tested with MySQL and PostgreSQL but it does impact the other database modules too.<BR>
<BR>
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).<BR>
<BR>
Thanks,<BR>
<BR>
Peter<BR>
<BR>
On Wed, 2011-07-27 at 13:11 +0200, Peter Dunkley wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
Module: sip-router
Branch: pd/crocodile
Commit: 5cd87175faa97161023c37e2cc0f0c064e08d571
URL: <A HREF="http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5cd87175faa97161023c37e2cc0f0c064e08d571">http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5cd87175faa97161023c37e2cc0f0c064e08d571</A>
Author: pd <<A HREF="mailto:peter.dunkley@crocodile-rcs.com">peter.dunkley@crocodile-rcs.com</A>>
Committer: pd <<A HREF="mailto:peter.dunkley@crocodile-rcs.com">peter.dunkley@crocodile-rcs.com</A>>
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: <A HREF="http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=5cd87175faa97161023c37e2cc0f0c064e08d571">http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=5cd87175faa97161023c37e2cc0f0c064e08d571</A>
_______________________________________________
sr-dev mailing list
<A HREF="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</A>
<A HREF="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</A>
</PRE>
</BLOCKQUOTE>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<PRE>
--
Peter Dunkley
Technical Director
Crocodile RCS Ltd
</PRE>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>