sr-dev February 2009

sr-dev@lists.kamailio.org

13 participants
478 discussions

git:janakj/ldap: - domain_attrs table mapping added
by Jan Janak 12 Feb '09

12 Feb '09

Module: sip-router Branch: janakj/ldap Commit: 06ebc89d3302a11654e42fa75bccf9404e1d3188 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=06ebc89… Author: Jan Janak <jan(a)iptel.org> Committer: Jan Janak <jan(a)iptel.org> Date: Tue May 13 09:11:45 2008 +0000 - domain_attrs table mapping added --- modules/db_ldap/ldap.cfg | 37 +++++++++++++++++++++++++++++++++++++ 1 files changed, 37 insertions(+), 0 deletions(-) diff --git a/modules/db_ldap/ldap.cfg b/modules/db_ldap/ldap.cfg index 6e69119..f8ef551 100644 --- a/modules/db_ldap/ldap.cfg +++ b/modules/db_ldap/ldap.cfg @@ -6,7 +6,9 @@ # LDAP attribute names and vice versa. # +# # Table credentials contains SIP digest authentication credentials. +# [credentials] # In our LDAP directory we store SIP digest credentials under @@ -29,3 +31,38 @@ field_map = realm : digestRealm field_map = auth_username : digestUsername field_map = uid : serUID field_map = flags : serFlags + +# +# Domain table stores information about virtual domains +# +[domain] + +# Objects mapping domain IDs to domain names and vice versa are stored +# in the subtree with the following root: +base = "ou=Domains,dc=iptel,dc=org" + +scope = children + +# We are only interested in serDomain objects when looking up information +# about virtual domains. +filter = "(objectClass=serDomain)" + +field_map = did : serDID +field_map = domain : serDomain +field_map = flags : serFlags + +# +# Table domain_attrs contains domain attributes, domain attributes store +# extra information about virtual domains. +# +[domain_attrs] +base = "ou=Domains, dc=iptel,dc=org" +scope = children + +filter = "(objectClass=serDomainAttr)" + +field_map = did : serDID +field_map = name : serAttrName +field_map = type : serAttrType +field_map = value : serAttrValue +field_map = flags : serFlags

1 0

git:janakj/ldap: - parse and check the result message
by Jan Janak 12 Feb '09

12 Feb '09

Module: sip-router Branch: janakj/ldap Commit: 09e32928839c2be69caa0ad96a25b725b268482f URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=09e3292… Author: Jan Janak <jan(a)iptel.org> Committer: Jan Janak <jan(a)iptel.org> Date: Mon May 12 15:01:17 2008 +0000 - parse and check the result message - support for binary values - better support for integers - support for bitmap fields --- modules/db_ldap/ld_cmd.c | 99 ++++++++++++++++++++++++++------------------- modules/db_ldap/ld_fld.c | 77 +++++++++++++++++++++++++++-------- modules/db_ldap/ld_fld.h | 2 +- modules/db_ldap/todo.txt | 2 - 4 files changed, 117 insertions(+), 63 deletions(-) diff --git a/modules/db_ldap/ld_cmd.c b/modules/db_ldap/ld_cmd.c index 8444bed..209db1e 100644 --- a/modules/db_ldap/ld_cmd.c +++ b/modules/db_ldap/ld_cmd.c @@ -251,27 +251,18 @@ int ld_cmd(db_cmd_t* cmd) switch(cmd->type) { case DB_PUT: - ERR("ldap: DB_PUT not supported\n"); - goto error; - break; - case DB_DEL: - ERR("ldap: DB_DEL not supported\n"); + case DB_UPD: + ERR("ldap: The driver does not support directory modifications yet.\n"); goto error; break; - + case DB_GET: break; - case DB_UPD: - ERR("ldap: DB_UPD not supported\n"); - goto error; - break; - case DB_SQL: - ERR("ldap: DB_SQL not supported\n"); + ERR("ldap: The driver does not support raw queries yet.\n"); goto error; - break; } cfg = ld_find_config(&cmd->table); @@ -293,7 +284,6 @@ int ld_cmd(db_cmd_t* cmd) if (ld_resolve_fld(cmd->result, cfg) < 0) goto error; if (build_result_array(&lcmd->result, cmd) < 0) goto error; - DB_SET_PAYLOAD(cmd, lcmd); return 0; @@ -314,10 +304,14 @@ int ld_cmd_exec(db_res_t* res, db_cmd_t* cmd) struct ld_res* lres; struct ld_cmd* lcmd; struct ld_con* lcon; - char* filter; - int ret; + char* filter, *err_desc; + int ret, err; LDAPMessage* msg; + filter = NULL; + err_desc = NULL; + msg = NULL; + /* First things first: retrieve connection info from the currently active * connection and also mysql payload from the database command */ @@ -327,57 +321,72 @@ int ld_cmd_exec(db_res_t* res, db_cmd_t* cmd) if (build_search_filter(&filter, cmd->match, &lcmd->filter) < 0) { ERR("ldap: Error while building LDAP search filter\n"); - return -1; + goto error; } ret = ldap_search_ext_s(lcon->con, lcmd->base, lcmd->scope, filter, lcmd->result, 0, NULL, NULL, NULL, 0, &msg); - if (filter) pkg_free(filter); if (ret != LDAP_SUCCESS) { ERR("ldap: Error in ldap_search: %s\n", ldap_err2string(ret)); - return -1; + goto error; + } + + ret = ldap_parse_result(lcon->con, msg, &err, NULL, &err_desc, NULL, NULL, 0); + if (ret != LDAP_SUCCESS) { + ERR("ldap: Error while reading result status: %s\n", + ldap_err2string(ret)); + goto error; } + if (err != LDAP_SUCCESS) { + ERR("ldap: LDAP server reports error: %s\n", ldap_err2string(err)); + goto error; + } + if (res) { lres = DB_GET_PAYLOAD(res); - if (lres->msg) ldap_msgfree(lres->msg); lres->msg = msg; } else { ldap_msgfree(msg); } + if (filter) pkg_free(filter); + if (err_desc) ldap_memfree(err_desc); return 0; + + error: + if (filter) pkg_free(filter); + if (msg) ldap_msgfree(msg); + if (err_desc) ldap_memfree(err_desc); + return -1; } -int ld_cmd_first(db_res_t* res) +/* Iterate to the next search result in the linked list + * of messages returned by the LDAP server and convert + * the field values. + */ +static int next_search_entry(db_res_t* res, LDAP* con) { - db_con_t* con; struct ld_res* lres; - struct ld_con* lcon; lres = DB_GET_PAYLOAD(res); - /* FIXME */ - con = res->cmd->ctx->con[db_payload_idx]; - lcon = DB_GET_PAYLOAD(con); - - lres->current = ldap_first_message(lcon->con, lres->msg); while(lres->current) { if (ldap_msgtype(lres->current) == LDAP_RES_SEARCH_ENTRY) { break; } - lres->current = ldap_next_message(lcon->con, lres->msg); + lres->current = ldap_next_message(con, lres->current); } if (lres->current == NULL) return 1; - if (ld_ldap2fld(res->cmd->result, lcon->con, lres->current) < 0) return -1; + if (ld_ldap2fld(res->cmd->result, con, lres->current) < 0) return -1; res->cur_rec->fld = res->cmd->result; return 0; } -int ld_cmd_next(db_res_t* res) +int ld_cmd_first(db_res_t* res) { db_con_t* con; struct ld_res* lres; @@ -388,19 +397,25 @@ int ld_cmd_next(db_res_t* res) con = res->cmd->ctx->con[db_payload_idx]; lcon = DB_GET_PAYLOAD(con); - if (lres->current == NULL) return 1; + lres->current = ldap_first_message(lcon->con, lres->msg); + return next_search_entry(res, lcon->con); +} + + +int ld_cmd_next(db_res_t* res) +{ + db_con_t* con; + struct ld_res* lres; + struct ld_con* lcon; + + lres = DB_GET_PAYLOAD(res); + /* FIXME */ + con = res->cmd->ctx->con[db_payload_idx]; + lcon = DB_GET_PAYLOAD(con); lres->current = ldap_next_message(lcon->con, lres->current); - while(lres->current) { - if (ldap_msgtype(lres->current) == LDAP_RES_SEARCH_ENTRY) { - break; - } - lres->current = ldap_next_message(lcon->con, lres->current); - } - if (lres->current == NULL) return 1; - if (ld_ldap2fld(res->cmd->result, lcon->con, lres->current) < 0) return -1; - res->cur_rec->fld = res->cmd->result; - return 0; + return next_search_entry(res, lcon->con); } + /** @} */ diff --git a/modules/db_ldap/ld_fld.c b/modules/db_ldap/ld_fld.c index 2c06727..b886d85 100644 --- a/modules/db_ldap/ld_fld.c +++ b/modules/db_ldap/ld_fld.c @@ -41,6 +41,7 @@ #include "../../db/db_drv.h" #include "../../mem/mem.h" #include "../../dprint.h" +#include "../../ut.h" #include <stdint.h> #include <string.h> @@ -53,7 +54,7 @@ static void ld_fld_free(db_fld_t* fld, struct ld_fld* payload) { db_drv_free(&payload->gen); - if (payload->values) ldap_value_free(payload->values); + if (payload->values) ldap_value_free_len(payload->values); payload->values = NULL; pkg_free(payload); } @@ -97,48 +98,88 @@ int ld_resolve_fld(db_fld_t* fld, struct ld_config* cfg) } +static inline int ldap_int2db_int(int* dst, str* src) +{ + if (str2sint(src, dst) != 0) { + ERR("ldap: Error while converting value '%.*s' to integer\n", + src->len, ZSW(src->s)); + return -1; + } + return 0; +} + + +static inline int ldap_bit2db_int(int* dst, str* src) +{ + int i, v; + + if (src->len > 32) { + WARN("ldap: bitString '%.*s'B is longer than 32 bits, truncating\n", + src->len, ZSW(src->s)); + } + v = 0; + for(i = 0; i < src->len; i++) { + v <<= 1; + v += src->s[i] - '0'; + } + *dst = v; + return 0; +} + + int ld_ldap2fld(db_fld_t* fld, LDAP* ldap, LDAPMessage* msg) { int i; struct ld_fld* lfld; + str tmp; if (fld == NULL || msg == NULL) return 0; for(i = 0; !DB_FLD_EMPTY(fld) && !DB_FLD_LAST(fld[i]); i++) { lfld = DB_GET_PAYLOAD(fld + i); - if (lfld->values) ldap_value_free(lfld->values); - lfld->values = ldap_get_values(ldap, msg, lfld->attr.s); + if (lfld->values) ldap_value_free_len(lfld->values); + lfld->values = ldap_get_values_len(ldap, msg, lfld->attr.s); - if (lfld->values == NULL) { - /* FIXME: Test for errno value here */ - ERR("ldap: Error in ldap_get_values\n"); - return -1; - } - - if (lfld->values[0] == NULL) { + if (lfld->values == NULL || lfld->values[0] == NULL) { fld[i].flags |= DB_NULL; continue; } if (lfld->values[1] != NULL) { - ERR("ldap: Multivalue attributes not yet supported\n"); + ERR("ldap: Multivalue attributes not yet supported: %.*s\n", + lfld->attr.len, lfld->attr.s); return -1; } switch(fld[i].type) { - case DB_STR: - fld[i].v.cstr = lfld->values[0]; + case DB_CSTR: + fld[i].v.cstr = lfld->values[0]->bv_val; break; - case DB_CSTR: - fld[i].v.lstr.s = lfld->values[0]; - fld[i].v.lstr.len = strlen(lfld->values[0]); + case DB_STR: + case DB_BLOB: + fld[i].v.lstr.s = lfld->values[0]->bv_val; + fld[i].v.lstr.len = lfld->values[0]->bv_len; break; case DB_INT: - fld[i].v.int4 = 33; - break; + case DB_BITMAP: + tmp.s = lfld->values[0]->bv_val; + tmp.len = lfld->values[0]->bv_len; + + if (tmp.s[0] == '\'' && + tmp.s[tmp.len - 1] == 'B' && + tmp.s[tmp.len - 2] == '\'') { + + tmp.s++; + tmp.len -= 3; + return ldap_bit2db_int(&fld[i].v.int4, &tmp); + } else { + return ldap_int2db_int(&fld[i].v.int4, &tmp); + } + break; + default: ERR("ldap: Unsupported field type: %d\n", fld[i].type); return -1; diff --git a/modules/db_ldap/ld_fld.h b/modules/db_ldap/ld_fld.h index 404f501..6994ace 100644 --- a/modules/db_ldap/ld_fld.h +++ b/modules/db_ldap/ld_fld.h @@ -48,7 +48,7 @@ struct ld_fld { db_drv_t gen; str attr; /**< Name of corresponding LDAP attribute */ - char** values; /**< Values retrieved from the LDAP result */ + struct berval** values; /**< Values retrieved from the LDAP result */ }; diff --git a/modules/db_ldap/todo.txt b/modules/db_ldap/todo.txt index 6c75a58..7e9c544 100644 --- a/modules/db_ldap/todo.txt +++ b/modules/db_ldap/todo.txt @@ -8,6 +8,4 @@ * Proper handling of NULL values * use the asynchronous functions of the api instead of synchronous * Support for multi-value attributes (they should be broken up into rows) -* Handle the value in LDAP_RES_SEARCH_RESULT somehow intelligently (it - may indicate a failure)

1 0

git:janakj/ldap: - latest version of the configuration file for ldap module
by Jan Janak 12 Feb '09

12 Feb '09

Module: sip-router Branch: janakj/ldap Commit: 22de964d0177a19af48cdf53b2813cde0c8e1e09 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=22de964… Author: Jan Janak <jan(a)iptel.org> Committer: Jan Janak <jan(a)iptel.org> Date: Mon May 12 12:21:03 2008 +0000 - latest version of the configuration file for ldap module --- modules/db_ldap/ldap.cfg | 38 ++++++++++++++++++++++++++++++-------- 1 files changed, 30 insertions(+), 8 deletions(-) diff --git a/modules/db_ldap/ldap.cfg b/modules/db_ldap/ldap.cfg index 596d37f..6e69119 100644 --- a/modules/db_ldap/ldap.cfg +++ b/modules/db_ldap/ldap.cfg @@ -1,9 +1,31 @@ +# +# This is a configuration file for the LDAP module in SER. The configuration +# file maps database table names used in SER to LDAP directory sub-trees to +# be searched. In addition to that the configuration file also allows to +# configure the LDAP search filter and maps database field names to +# LDAP attribute names and vice versa. +# + +# Table credentials contains SIP digest authentication credentials. [credentials] -base="ou=Digest Credentials,dc=iptel,dc=org" -scope=sub -filter="(objectClass=digestAuthCredentials)" -field=password:digestPassword -field=realm:digestRealm -field=auth_username:digestUsername -field=uid:serUID -field=flags:serFlags + +# In our LDAP directory we store SIP digest credentials under +# "Digest Credentials" organization unit so this is where searches for digest +# credentials should start. +base = "ou=Digest Credentials,dc=iptel,dc=org" + +# We search all the children but not the ou object itself. +scope = children + +# For digest credentials we are only interested in objects with objectClass +# 'digestAuthCredentials', objects of all other types are ignored. +filter = "(objectClass=digestAuthCredentials)" + +# Mapping of field names to LDAP attribute names and vice versa. Names are +# delimited using ':', the first name is database field name as used in SER +# modules, the second name (after :) is corresponding LDAP attribute name. +field_map = password : digestPassword +field_map = realm : digestRealm +field_map = auth_username : digestUsername +field_map = uid : serUID +field_map = flags : serFlags

1 0

git:janakj/ldap: - initial version of generic LDAP driver ( not yet ready to be used)
by Jan Janak 12 Feb '09

12 Feb '09

Module: sip-router Branch: janakj/ldap Commit: d05c54a899ba1e13e994c106d40c0688d7c31a0a URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d05c54a… Author: Jan Janak <jan(a)iptel.org> Committer: Jan Janak <jan(a)iptel.org> Date: Mon May 12 12:14:38 2008 +0000 - initial version of generic LDAP driver (not yet ready to be used) ---

1 0

git:janakj/db DELETED: SER 2.0 and Kamailio mysql driver intergrated.
by Jan Janak 12 Feb '09

12 Feb '09

Module: sip-router Branch: janakj/db DELETED Commit: 25700524f8270115f2ffa647b5868d30f768535a URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2570052… Author: Jan Janak <jan(a)iptel.org> Committer: Jan Janak <jan(a)iptel.org> Date: Fri Nov 21 04:09:48 2008 +0100 SER 2.0 and Kamailio mysql driver intergrated. This is the integrated version of the mysql db driver from SER 2.0 and Kamailio. The module supports both API versions and links with both database libraries. Currently only compiles, untested. --- modules/db_mysql/Makefile | 25 + modules/db_mysql/dbase.c | 535 +++++++++++++ modules/db_mysql/dbase.h | 128 ++++ modules/db_mysql/doc/mysql_parser.dia | Bin 0 -> 2461 bytes modules/db_mysql/my_cmd.c | 1341 +++++++++++++++++++++++++++++++++ modules/db_mysql/my_cmd.h | 73 ++ modules/db_mysql/my_con.c | 195 +++++ modules/db_mysql/my_con.h | 69 ++ modules/db_mysql/my_con1.c | 131 ++++ modules/db_mysql/my_con1.h | 75 ++ modules/db_mysql/my_fld.c | 65 ++ modules/db_mysql/my_fld.h | 54 ++ modules/db_mysql/my_res.c | 80 ++ modules/db_mysql/my_res.h | 41 + modules/db_mysql/my_uri.c | 282 +++++++ modules/db_mysql/my_uri.h | 51 ++ modules/db_mysql/mysql_mod.c | 187 +++++ modules/db_mysql/mysql_mod.h | 54 ++ modules/db_mysql/res.c | 215 ++++++ modules/db_mysql/res.h | 48 ++ modules/db_mysql/row.c | 79 ++ modules/db_mysql/row.h | 48 ++ modules/db_mysql/val.c | 265 +++++++ modules/db_mysql/val.h | 51 ++ 24 files changed, 4092 insertions(+), 0 deletions(-) Diff: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=257…

1 0

text/plain; charset=UTF-8
by New＠sip-router.org 12 Feb '09

12 Feb '09

Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 20:28:11 2009 +0100 Header file conditional macros renamed (DB_ -> DB1). All macros protecting header files against multiple inclusions have been renamed to make sure that there are no conflicts with header fields from srdb2 library. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a33b9a8… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 20:23:56 2009 +0100 Doxygen group renamed from db to db1. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=7d14b03… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 20:23:12 2009 +0100 Updated the value of \file doxygen tags. Since we moved files in lib/srdb1 from another directory we also needed to update the doxygen \file tags. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=cb5aaf8… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 20:22:10 2009 +0100 Renamed type names (DB_ -> DB1_) in comments and documentation. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=70fc66d… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 20:21:15 2009 +0100 Database type enum values (such as DB_INT) renamed to DB1_*. Both database libraries define the same database value type names. We need to rename them in one of the libraries so that both libraries can be used at the same time. Here we chose to rename the enum values in libsrdb1 to DB1_*. The same change needs to be done in SER modules using this version of the database library. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=20606ac… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 20:18:57 2009 +0100 Renamed db_res_t to db1_res_t in doxygen documentation. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=13f9c1e… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 20:16:40 2009 +0100 Renamed db_res_t to db1_res_t to avoid conflicts with libsrdb2. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=3561d31… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 20:15:29 2009 +0100 Rename db_con_t to db1_con_t in doxygen documentation. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a5071c5… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 20:14:43 2009 +0100 Rename db_con_t to db1_con_t to avoid conflicts with libsrdb2. Both libraries libsrdb1 and libsrdb2 contain the data structure db_con_t and in one if them the data structure needs to be renamed so that both libraries can be used from one SER module at the same time. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1858085… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 16:34:16 2009 +0100 Added *~ to the list of files ignored by git. Files with *~ suffix are created by emacs to hold a backup copy of the file being edited. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5aad472… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 16:33:31 2009 +0100 Fixing relative paths to SER headers. After moving the database library from SER 2.0 into lib/srdb2 it was necessary to update all the relative paths to SER header fiels. Also adding a new Makefile suitable for building the library. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=35ba402… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 16:26:34 2009 +0100 Changed the path to ser include files. After moving the database library into lib/srdb1 subdirectory it is necessary to update the relative paths to ser header files. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f3bcff0… Merge: 569bf0016d12bfa3da853e256d6b24e4ab730fa0 86a18a6d68639db7982aeb436d05a9e6903bcaca Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 14:13:51 2009 +0100 Merge commit 'kam/trunk' * commit 'kam/trunk': (219 commits) - add one debug probe for SQL NULL values, like for the other datatypes * Hostname of gateway should default to NULL. - new column to dispatcher table to hold priority * Introduced optional aliveness checking of gateways. Contributed by - partial revert of commit rev5359 for db_mysql module - remove obselete DB example directory, the Makefile don't work and the source - prevent problems when a DB modules (like db_postgres) first calls - small indention fix - revert commit rev5415 - move one DBG probe to the beginning of the free, to catch later problems - add group functionality to read content from specified sections - port from opensips, commit 4977, 4988, credits to Dan Pascu - port from opensips, commit 4889 - port from opensips, commit 4990, credits to Dan Pascu - unify common rows and row allocation functionality in the DB API core - change behaviour of db_str2val, this now copy strings - avoid potential read overflow on non NULL terminated string - move db_mysql and db_unixodbc str2val implementation to the DB core, - fix a bunch of doxygen errors (mostly in modules, some in the core) - finish refactoring of carrierroute module ... URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=569bf00… Author: Jan Janak <jan(a)iptel.org> Date: Thu Feb 12 14:11:53 2009 +0100 SER 2.0 database api moved to lib/srdb2. URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=86a18a6… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jan 26 18:07:14 2009 +0000 - add one debug probe for SQL NULL values, like for the other datatypes git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5518 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=ba9b7db… Author: Juha Heinanen <jh(a)tutpro.com> Date: Sat Jan 17 03:26:18 2009 +0000 * Hostname of gateway should default to NULL. * Improved descriptions. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5478 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1b4f508… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Wed Jan 14 11:54:41 2009 +0000 - new column to dispatcher table to hold priority - regenerated scripts to create the table git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5457 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5d4d829… Author: Juha Heinanen <jh(a)tutpro.com> Date: Tue Jan 6 10:32:43 2009 +0000 * Introduced optional aliveness checking of gateways. Contributed by Alexandr S. Dubovikov. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5424 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8fb93e2… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jan 5 18:29:35 2009 +0000 - partial revert of commit rev5359 for db_mysql module - generalize db_str2val function in the DB API core, the string copying behaviour can now configured (its done for db_postgres, db_unixodbc, not done for db_mysql like in the 1.3, 1.4 branches) - still TODO: fix NULL case in db_unixodbc, try to fix double copying git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5423 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=005029d… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jan 5 15:48:23 2009 +0000 - remove obselete DB example directory, the Makefile don't work and the source won't compile anymore since release 1.2.0 or so git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5419 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=fec76e8… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jan 5 15:42:12 2009 +0000 - prevent problems when a DB modules (like db_postgres) first calls db_free_row (because of some problems in the data processing), and then later db_free_result - this could cause a double free, and also a crash because of null pointer - reported from Bayan Towfiq, bayan at flowroute dot com - fix also a similar problem in the db_free_columns function git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5418 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=ccac232… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jan 5 15:27:12 2009 +0000 - small indention fix git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5417 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6f82012… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jan 5 15:22:18 2009 +0000 - revert commit rev5415 - contains one unrelated change git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5416 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=744bed4… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jan 5 15:19:36 2009 +0000 - move one DBG probe to the beginning of the free, to catch later problems - extend one DBG probe to also log the number of rows, small indention fix git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5415 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c0a18f4… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jan 5 12:27:49 2009 +0000 - add group functionality to read content from specified sections of the mysql config to the db_mysql module, db_url examples: * mysql://user:pass@[group]host:port/db or * mysql://user:pass@[group]/db or * mysql://[group]/db - existing functionality is not changed, this is backward compatible - check usernames for NULL before comparing in DB API, otherwise it would segfault when only a group name is specified - patch from Andreas Granig, agranig at sipwise dot com, closes #1815631 git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5413 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=88dc2f0… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Dec 15 17:12:34 2008 +0000 - port from opensips, commit 4977, 4988, credits to Dan Pascu - move variable declaration, remove unneeded variable 'prefix' - test for failure in memory allocation git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5365 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=cc68e8f… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Dec 15 16:56:10 2008 +0000 - port from opensips, commit 4889 - remove (small) memory leak in DB module bind git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5364 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=e5721bc… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Dec 15 16:41:36 2008 +0000 - port from opensips, commit 4990, credits to Dan Pascu - remove unnecessary check during mem free in API bind git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5363 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=3d7f4c1… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Dec 15 16:33:22 2008 +0000 - unify common rows and row allocation functionality in the DB API core git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5362 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f920073… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Dec 15 15:07:12 2008 +0000 - change behaviour of db_str2val, this now copy strings - this change was necessary because in some circumstances the memory that is returned from the database driver is used by some other means too fast, causes crashed or wrong results later on, this bug is timing related - this means for mysql and unixodbc that the performance will be decreased a bit, postgres already copied the string, so here nothing change - add a new function to DB core API, db_val2str that, usable to convert numerical values to a string, and common things like NULL values conversion, parameter checks - convert mysql, postgres and unixodbc module to use this new function - convert postgres function to use the core db_str2val function, the copying is now done at a different place, cleanup the code somewhat - remove unnecessary assignment if a NULL value is encountered in postgres - TODO: fix NULL handling and double copying that is done now for unixodbc git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5359 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1d7bba5… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Dec 15 10:30:13 2008 +0000 - avoid potential read overflow on non NULL terminated string port from opensips (#4980), credits to Dan Pascu git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5355 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c843980… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Dec 10 18:41:09 2008 +0000 - move db_mysql and db_unixodbc str2val implementation to the DB core, remove the duplicated implementation in the modules (preparation for query copy problem) - introduced a small regression for the unixodbc in the NULL value handling that needs to be fixed git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5322 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=18557a9… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Dec 4 18:12:33 2008 +0000 - fix a bunch of doxygen errors (mostly in modules, some in the core) - credits belongs to Frederick Bullik, frederick dot bullik at 1und1 dot de git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5299 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2d0ae74… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Nov 12 15:53:01 2008 +0000 - finish refactoring of carrierroute module - replace O(n) matching logic for carrier and domain names with a efficient binary search implementation - use qsort and bsearch of glibc in most of the cases, where its possible (basically all carrier/domain searches are O(log n) now, only when dynamic strings for are used in the cfg, it needs to search the whole list) - change carrier and domain names from string to integer, to allow the lookup - instead of storing the carrier/domain name string in the memory structure, a pointer to the name is used to save space - get rid of this internal ID vs. external ID stuff, we use now only one - rename the route_tree table to carrier_name - add a new table domain_name, to hold the domain names (like route_tree tbl) - adapt tests for the new or changed functionality - extend documentation with a paragraph about the used matching logic - Credits for this work belongs to Hardy Kahl, hardy dot kahl at 1und1 dot de - fix a few errors in the postgres cr test, fix a few doxygen statements - move some parts of log messages to DBG log level - update documentation and database schemes git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5189 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1b53cbd… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Nov 3 17:22:27 2008 +0000 - fix conflicting swap definition during solaris compilation - the _XOPEN_SOURCE causes a definition of swap in unistd.h and stdlib.h - based on opensips change r4622 from Bogdan - thanks to Muhammad Akl for access to a debugging machine git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5159 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f6b18a6… Author: Juha Heinanen <jh(a)tutpro.com> Date: Sun Oct 19 09:07:52 2008 +0000 * Added 'hostname' column to 'gw' table. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5096 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a465a4a… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Oct 17 08:01:23 2008 +0000 - docs extension: explain fetch_result functionality better to prevent errors because of wrong usage, found from Juha Heinanen git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5088 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8ecee0c… Author: Juha Heinanen <jh(a)tutpro.com> Date: Thu Oct 16 16:58:34 2008 +0000 * New implementation of lcr part of lcr module. * Entries of lcr table are now stored in in-memory cache for high performance (see README for execution times of lcr related functions). * Gateways can now be assigned a weight within their groups. * Support for prefix_mode=1 has been dropped. * lcr_dump MI function has been split into lcr_gw_dump and lcr_lcr_dump functions. * lcr_reload function is now executed under a lock. * Testing is welcomed. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5084 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1212f98… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Oct 10 13:21:23 2008 +0000 - check in db_do_close/ mysql_close also for an invalid tail pointer - normally this should be fine, but as the database is eventual closed in some abnormal situations, its better to be really sure - change in trunk: all databases that uses the core infrastructure, change in 1.3 branch: mysql git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5061 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=0ba2767… Author: Elena-Ramona Modroiu <ramona(a)rosdev.ro> Date: Tue Oct 7 20:14:32 2008 +0000 - table definition for htable module git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@5039 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=cc6c7a5… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Sep 17 14:46:05 2008 +0000 - don't check for LLONG_MAX, LLONG_MIN, as some gcc don't provide this, checking for ERANGE is enough, reported from Klaus git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4941 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=13c66bf… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Sep 17 12:49:27 2008 +0000 - partial port from opensips, r4736, credits to Anca (without kamctlrc change) - changed length for rlsubs_did filed in rls_presentity table (512 to 255) - fixes also key length issues with MySQL 1.4.22 git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4939 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=7746b45… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Sep 16 16:44:10 2008 +0000 - initial support for BIGINT database in DB core and SQL based database modules, closes patch #2101659 - some tests for mysql were done, but more testing, especially for the postgres and unixodbc would be appreciated - Todo: fix other DB modules, at the moment some warnings are printed during compilation because of the unhandled BIGINT state git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4928 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=04c0fcf… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Sep 10 17:00:49 2008 +0000 - add small doxygen comment about the usage of fetch_result with db_query git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4878 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6f0c167… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Sep 9 15:39:38 2008 +0000 - carrierroute use autogenerated DB infrastructure - adapt configuration, move some descriptions to DB scheme git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4872 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=537075c… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Sep 1 09:46:38 2008 +0000 - fixed freeing NULL pointers - in case of error, db_free_columns() may be internally called by other functions or directly by db_free_result(), resulting in double free. Reported by Richard Revels, credits to Bogdan git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4783 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f2b44d1… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Aug 26 16:29:28 2008 +0000 - store generated DB interface sources and documentation in module dir - fix cleanup target for generated sources and documentation - deactivate module and dbdoc generation and cleanup for now on plain "make", to avoid eventual problems in the modules dirs at the moment git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4745 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a0e0049… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Aug 26 15:46:01 2008 +0000 - split xsl in two files, after discussion on list, to generate a seperate header and implementation file - adapt both xsl to create header and implementation source code git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4744 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c71af70… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Aug 25 14:05:13 2008 +0000 - add XSL for generating module table documentation from available XML - add new db/schema Makefile target, "dbdoc" git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4735 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8d8f168… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Aug 13 07:24:06 2008 +0000 - also remove module directory, will be created on 'make dbschema' git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4691 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=468c304… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Aug 12 22:51:33 2008 +0000 - fix error in previous commit, i accidently added the wrong file git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4688 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=53b1496… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Aug 12 22:44:49 2008 +0000 - initial version of infrastructure for autogenerating DB functions and definitions - use 'make dbschema' to generate - will be refined in the next weeks - change only auth_db module to use this functions for now - add autogenerated header to repository - add new directory to doxygen, fix some small bug in schema makefile git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4687 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6081a48… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Aug 7 08:47:44 2008 +0000 - port from opensips r4528, credits goes to Anca - updated version count for tables presentity and pua (the code already uses the "new" version number) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4628 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a3ccd3d… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Aug 7 08:37:04 2008 +0000 - port from opensips r4523, credits goes to Anca - fixed some more bugs in BLA - problem at openser restart - phone refresh issue - added one more column in table presentity - added one more column in table pua git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4625 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a7fc7c6… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Aug 7 08:33:42 2008 +0000 - fix 'make dbschema', rename files git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4624 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=cf4700b… Author: Klaus Darilion <klaus.darilion(a)pernau.at> Date: Tue Aug 5 14:58:52 2008 +0000 - renaming: openser -> kamailio git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4565 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=14248f8… Author: Dan Pascu <dan(a)ag-projects.com> Date: Thu Jul 31 15:12:38 2008 +0000 Automatically determine table names git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4525 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d520eaf… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jul 28 15:39:28 2008 +0000 - change name in copyright headers git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4518 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=e4998f7… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Jul 25 15:21:56 2008 +0000 - some small doxygen error fixes git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4517 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5b5a633… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Jul 24 15:20:11 2008 +0000 - small doxygen updates (group, syntax), small docs update - patch provided from Olle E. Johansson, closes #2025079 git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4505 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=4251c54… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Jul 10 15:40:14 2008 +0000 - small extension to the location table docs git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4474 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c750c35… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Jul 3 15:56:43 2008 +0000 - fix make dbschema-docbook-html generation, closes #2009831 - remove old entities from template git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4447 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=875f5c9… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Jun 17 13:06:28 2008 +0000 - fix database related doxygen errors git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4398 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=78611c9… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Fri Jun 6 19:01:37 2008 +0000 -fixed swapped values git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4344 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b664ead… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Fri Jun 6 14:36:01 2008 +0000 - uploaded new modules that implements generic string translations based on matching and replacement rules. It can be used to manipulate R-URI or a PV and to translated to a new format/value. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4331 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b332f22… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed May 21 14:05:14 2008 +0000 - add 'description_len' to entitity.xml - sync description length and type of globalblacklist table to carrierroute - remove description column of userblacklist table, this is not really needed - carrierroute and carrierfailureroute table use the entity, no visible change git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4234 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d162a81… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed May 21 07:50:05 2008 +0000 - add db_check_table_version funtion to db API - this function includes error logging and also a error message on version mismatch, its require now a exact match of the version numbers - convert most of the modules to use this function, instead of implementing their own error handling again - new modules should use this function - increase trusted table version define for permissions module, it should be the same as the DB version entry - TODO: convert uri_db, domain, domainpolicy and dispatch too git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4232 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8384f5a… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed May 14 15:51:09 2008 +0000 - fix error in userblacklist DB scheme definition, the whitelist colum type should be of TINYINT (or equivalent) size - no DB version update necessary, as the module in question is not released yet git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4184 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=65d4ee8… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Apr 23 11:58:05 2008 +0000 - use a random name for the temporary file, this is safer git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4073 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6c8c88e… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Fri Apr 18 10:26:29 2008 +0000 - removed wrong unique index git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4045 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=507a587… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Apr 16 13:37:47 2008 +0000 - enable oracle SQL generation with XML scheme - add oracle specific DATE default values - improve oracle XSL script, many thanks to Iouri for testing git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4017 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6c4ccfa… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Apr 10 16:00:46 2008 +0000 - fix index name for globalblacklist table git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4004 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=494f3bb… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Apr 10 09:11:26 2008 +0000 - improve 'autoincrement' type for postgres, now its not necessary anymore to specify this workaround in the scheme sources git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4000 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c5e925d… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Apr 3 16:37:35 2008 +0000 - preparations for db_oracle driver merging - rename column names that uses reserved words from oracle - update siptrace code and carrierroute documentation - siptrace table version increased, but this is not checked in code anyway - carrierroute code changed as comment is displayed from setup tools - the other modules don't use the colum in question, its only a comment so no version update is necessary - SQL scheme files and documentation also updated - Patch provided from Iouri Kharon, yjh at styx dot cabel dot net git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3972 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=e2a9601… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Apr 1 15:46:49 2008 +0000 - fix double null termination of query string - Patch provided from Iouri Kharon, yjh at styx dot cabel dot net git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3970 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=dd7348a… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Mar 21 21:18:16 2008 +0000 - add message flag support for more flexibility in routing - increase table version, as two new colums are introduced - internal refactoring, change routing rule structure - add documentation about this functionality - update database tables after schema extension - credits goes to Hardy Kahl, hardy dot kahl at 1und1 dot de git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3946 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=0f5ce5c… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Thu Mar 13 10:14:54 2008 +0000 - fixed 64bits compiling: sizeof() returns long type! git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3932 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a8250d0… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Thu Mar 6 13:05:01 2008 +0000 - don't free dbtext values in core DB api, the module will free along with the internal structure (related to #1891453 reported by Ovidiu Sas) - formatted some logs to fit 80char line git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3868 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d5b8054… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Mar 6 09:30:33 2008 +0000 - add missing check for errors during val2str - closes #1908392, Patch provided from Iouri Kharon git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3863 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d678930… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Thu Feb 28 20:52:03 2008 +0000 - db_text module exports DB API via bind function - DB core tries to find first the bind function, if not found, old way to link the DB API is used git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3796 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1799926… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Feb 28 16:20:02 2008 +0000 - sync carrierroute and carrierfailureroute table (swap scan_prefix and domain column) - as carrierroute is only usable for SQL based tables because of the raw query dependency, we don't need to increment the version number git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3791 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=9a8126d… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Feb 28 15:47:04 2008 +0000 - add new database table for carrierroute git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3790 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=04e87c5… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Feb 28 15:45:33 2008 +0000 - major reworking of carrierroute module - make exported, user visible interface much more flexible - add a new table 'carrierfailureroute' for database supported failure routing - credits for this work goes to Hardy Kahl, hardy dot kahl at 1und1 dot de git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3789 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b20e950… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Feb 28 13:45:26 2008 +0000 - remove SERWEB stuff from database scheme and tables git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3787 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b22602f… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Thu Feb 28 09:54:16 2008 +0000 - removed from the subscriber table the following fields: - first_name - last_name - email_address - datetime_created - timezone as these fields are not used by openser itself (but rather by whatever provisioning tools) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3782 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=cb87dca… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Feb 26 13:51:26 2008 +0000 - add a new module, called 'userblacklist' for handling user and global blacklists - credits for this module goes to Hardy Kahl, hardy dot kahl at 1und1 dot de - add documentation, database scheme and test for this module git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3760 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=dda0818… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Feb 11 12:14:21 2008 +0000 - fix wrong type in re_grep group_id column - reported from Giovanni Coriasco, closes #1891097 git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3677 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=705bb72… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Thu Feb 7 13:02:09 2008 +0000 - added flags column to dispatcher table - dispatcher table version increased git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3660 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=72b0651… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Feb 6 15:46:09 2008 +0000 further changes after the db name change - update INSTALL file - fix Makefile skip modules variable - fix module Makefile, lib name - change db_bind_mod to add the db prefix in the function - change db url defines in db_berkeley and db_text - change database modules names in module struct - fix debian packaging - fix tests git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3642 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=47c619f… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Feb 6 12:59:01 2008 +0000 further improvements of the database API: - unify postgres, unixodbc and mysql code, error and debug messages - move the column allocating logic into the DB core API - change the all three modules to use this function - change postgres module to use the memory memory management methods of the core - add a flag to the db_val_t type that indicates if the (string) memory must be freed - don't try to free the static NULL values in db_free_row - change core row freeing method to evaluate the memory status flag - change the postgres module to set this flag - add some memsets to the mysql and unixodbc module for more safety and also ensure the correct working of the free flag - fix database TYPE flags in mysql module, they will be removed for 5.2 and are also obselete since 3.X times - change column names allocation logic in postgres to match the unixodbc and mysql behaviour, don't copy the names - some smaller documentation improvements and cleanups - tested only with testsuite so far works that still needs to be done: - modify the db_berkeley, dbtext and flatstore module to use the core API - modify the postgres, db_berkeley driver that they don't copy the values returned from the driver git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3637 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=0ad41bb… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Feb 6 12:52:59 2008 +0000 - revert commit in rev 3603, this don't work because xsltproc ouput an exit status != 0 even for warnings.. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3636 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c65db6b… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Feb 1 16:17:44 2008 +0000 - remove old api-txt, this was some weeks ago converted to doxygen git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3608 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=88a6937… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Feb 1 10:06:32 2008 +0000 - db schema generation should fail early on parser errors git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3603 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=dac7077… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jan 30 13:18:49 2008 +0000 - this belongs to the previous commit.. ;-) - move db_free_result function from DB drivers to core DB API git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3597 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=30bde5b… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Jan 25 10:30:58 2008 +0000 - fix (small) potential buffer overflow conditions in query preperation - this could happen if the size of the query string offset is equal to the SQL_BUF_LEN define length git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3583 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c9485c3… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Jan 24 13:31:18 2008 +0000 - fix doxygen file header git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3568 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=7a85c8e… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Jan 24 13:00:49 2008 +0000 - autoincrement route_tree id columns, remove default of '0' git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3566 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=25f1798… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Jan 22 13:55:43 2008 +0000 - port database interface (almost) complete from 'const char*' to 'str' for more safety (e.g. not null terminated strings) and performance (save strlen calls in core and library code) - adapt existing modules to use the new interface - change bind_dbmod and use_table function to the naming scheme of the other functions of the API - port existing module to use 'str' values for database related parameters - if modules uses already 'str' functions internally, remove the unnecessary temporary variables - make functions and parameter that needs only locally be used static - introduce new column variables needed for the keys for modules that don't have them already, this could be used to make them configurable later on - add 'const' to more db related functions - fix postgres driver, async queries must be finished, otherwise the next one will not complete - smaller whitespace and formatting changes and cleanups all over the place - reviewed and tested with testcases, but probably not error free because of the change size - basic DB operations should work, but no extensive load testing has yet be done, as some work still remains: - remove dead code and superflous comments in postgres driver - clean up memory management, at the moment there exists two flavors: don't copy that much (mysql, unixodbc), don't trust the driver, copy everything (postgres, db_berkeley) - after this is unified, then only one implementation for the memory management of the db API could be used for all modules - Foundations of this change have been created from Frederick Bullik, Frederick.Bullik at 1und1 dot de - Please review and test. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3563 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=bc4bf26… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jan 7 14:26:27 2008 +0000 further cleanups in core database API - move use_table and close function for SQL DBs to core - move query, raw_query, insert, update, delete functions for SQL DBs to core - all this functions were almost identical implemented in the three DB, this functions uses now a function pointer based interface to do the work - the use_table functions from dbtext and db_berkeley uses also now the core API - move result management function from db_col to db_res to the other result management functions, they are not useful alone - change postgres module to match more the structure of mysql and unixodbc, remove the 'PARANOID' #define, the other modules don't have this and prefix all functions with db_postgres, make this more consistent to mysql module - prefix all functions in unixodbc module with db_unixodbc, make this consistent to the other modules, cleanup the namespace - prefix val2str function in mysql with db_mysql too - move the SQL_BUF_LENGTH to core API, all modules need this - remove the static SQL char buffer from postgres and unixodbc, uses the one provided from the core API - move documentation from db/doc to API files in doxygen format - improve and extend documentation for the whole API - make database API const correct, to guard against implementation errors and allow better compiler optimizations - change interface free_connection function in SQL DBs to connection structure to allow the usage of core API do_close - fix indention for postgres driver and make logging messages consistent - remove now unneeded system header includes for SQL DBs - remove transaction related code from postgres driver, this is not used at all and according to Klaus also brings no performance benefit if used. - probably some other smaller cleanups Tested with the testcases, so basic functionality should work.. Please test! :-) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3506 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1655fbd… Author: Juha Heinanen <jh(a)tutpro.com> Date: Fri Dec 28 10:55:21 2007 +0000 * Updated schema and scripts due to gw table change. * Improved descriptions. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3494 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2b32ef2… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Dec 21 15:55:54 2007 +0000 - cleanup in database API - introduce a helper method for db_init, that does the actual work - database modules needs now only a small wrapper function - functionality checked for mysql and postgres with the available tests git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3481 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=309b1f1… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Dec 19 11:56:11 2007 +0000 - move db_func_t to the correct place again, fix compile error git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3440 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=518ed3c… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Dec 19 11:49:43 2007 +0000 - move documentation from txt file to db.h file in doxygen format - extend documentation - add a simple start page for the doxygen docs, this needs to be extended.. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3439 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=71eafcc… Author: Juha Heinanen <jh(a)tutpro.com> Date: Sat Dec 15 11:04:24 2007 +0000 * Schema changes due to gw/dm to gw/flags change. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3402 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=3d27bea… Author: Juha Heinanen <jh(a)tutpro.com> Date: Fri Dec 14 16:21:04 2007 +0000 * Removed lcr/gw_grp table because it is not used by OpenSER. If someone needs it, it can be added as an extension. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3395 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=27aa4ad… Author: Jesus Rodrigues <jesusr(a)voztele.com> Date: Fri Dec 14 12:10:47 2007 +0000 - Fix typos git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3384 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=79c9b78… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Nov 26 19:03:03 2007 +0000 - increase dialog db version - closes #1838888 git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3212 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=34523d7… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Nov 15 14:09:15 2007 +0000 - add support for default values to db_berkeley database source git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3142 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d3b8213… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Wed Nov 14 10:09:17 2007 +0000 - fixed DB schema: 1) domain column may be NULL in location and aliases tables (if use_domain=0) 2) prefix column may be NULL in lcr table Closes bug report: 1829179 git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3132 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2f60e0c… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Fri Nov 9 10:53:32 2007 +0000 - extended xcap table key to include 'doc_uri' as there can be more documents of the same type (suggested by Adrian Georgescu) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3075 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=710bdc2… Author: Dan Pascu <dan(a)ag-projects.com> Date: Wed Nov 7 15:39:13 2007 +0000 Use consistent indentation in xml files git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3044 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=97841ad… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Nov 7 15:23:23 2007 +0000 - some doxygen documentation for db_ut.h git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3042 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=09d410b… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Nov 7 15:03:56 2007 +0000 - revert commit in revision 3022 - this commit misses a variable assignment that causes an error - even if this is fixed, then mysql don't like unquoted time values on insertion - prober quoting of the time should be done in val2str, but this requires probably a interface change in time2str - for this changes we're to late in the release process, error should be changed in the db_berkeley module git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3041 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5ac299c… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Nov 6 08:31:58 2007 +0000 - use 'natural' instead of naturalkey, the primary and unique indexes keywords are 'primary' and 'unique' too git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3025 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6f95efa… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Nov 5 15:19:35 2007 +0000 - The function db_time2str() should not include the single-quotes. - Fixes a core dump for db_berkeley module, noticed by Will Quan git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3022 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=42d74a5… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Nov 5 12:11:48 2007 +0000 - add 'naturalkey' to template file git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3014 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=04e7ba6… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Nov 5 12:01:15 2007 +0000 - increase openser DTD version after 'naturalkey' addition git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3013 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1cd0d62… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Nov 5 11:36:18 2007 +0000 - add 'naturalkey' column to OpenSER tables to fix the db_berkeley index problem Patch provided by Will Quan <wiquan(a)employees.org> git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3011 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=11ea23e… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Nov 2 09:39:42 2007 +0000 - don't iterate during version table generation over the version table.. - head with negative index is not available on *BSD, use positive instead git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3009 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=0cdfaf6… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Tue Oct 30 15:21:37 2007 +0000 - moved variable declaration at the beginning of the function - replaced the c++ like comments with standard C one git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@3004 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=612a6f4… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Oct 29 13:09:41 2007 +0000 - extend documentation a little bit, this table vs. dbaliases git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2995 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2899ef3… Author: Dan Pascu <dan(a)ag-projects.com> Date: Fri Oct 26 09:38:57 2007 +0000 Fixed leftover name inconsistencies after the renaming of the xcap_xml table to xcap git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2990 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=3c53200… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Thu Oct 25 08:45:08 2007 +0000 - applied changes suggested by Adrian Georgescu to maintain consistency with presence database table definition git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2985 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d033a26… Author: Dan Pascu <dan(a)ag-projects.com> Date: Sun Oct 21 04:34:21 2007 +0000 Reverted column id name as it gives an error of being redefined git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2964 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a8e6dd4… Author: Dan Pascu <dan(a)ag-projects.com> Date: Sun Oct 21 03:59:23 2007 +0000 Call the db_berkeley_clean rule as well from the generic clean rule of db/schema git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2962 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=890abb5… Author: Dan Pascu <dan(a)ag-projects.com> Date: Sun Oct 21 03:57:33 2007 +0000 ... and another typo in the path of the db_berkeley clean rule git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2961 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5f711f8… Author: Dan Pascu <dan(a)ag-projects.com> Date: Sun Oct 21 03:54:32 2007 +0000 Fixed path in db schema clean rules git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2960 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=ab9efd1… Author: Dan Pascu <dan(a)ag-projects.com> Date: Sat Oct 20 04:48:18 2007 +0000 Replaced a hardcoded value with a constant from entities git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2949 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6b259a8… Author: Dan Pascu <dan(a)ag-projects.com> Date: Sat Oct 20 04:44:55 2007 +0000 Use more consistent names for database indexes git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2948 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1b58c59… Author: Dan Pascu <dan(a)ag-projects.com> Date: Sat Oct 20 04:17:56 2007 +0000 Some spell checking and repharasing for clarity in column descriptions git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2947 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=307860b… Author: Dan Pascu <dan(a)ag-projects.com> Date: Sat Oct 20 03:49:07 2007 +0000 Fixed inconsistent use of mixed tabs and spaces for indenting db schema files git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2946 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8d435c0… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Oct 18 08:45:18 2007 +0000 - remove bogus comment end from xml spec git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2936 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a4869c6… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Tue Oct 16 11:38:54 2007 +0000 - followed the suggestions of Adrian Georgescu to use the same names in equivalent columns from watchers and active_watchers database tables git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2923 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2aea67f… Author: Dan Pascu <dan(a)ag-projects.com> Date: Sun Oct 14 21:49:06 2007 +0000 Remove autogenerated db schema files to make sure the source tree is in the same state as the original after a make proper git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2916 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=100d17b… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Oct 10 09:13:38 2007 +0000 - fix IDs of the tables git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2893 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=676afff… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Oct 5 14:32:16 2007 +0000 - move new_result and free_columns function to db directory - remove the implementation of this functions in all database modules - still missing - postgresql and db_berkeley implement different, more thouroughly free methods for colums and such - review if we can use the common functions like the other three modules git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2871 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f812683… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Oct 5 10:53:20 2007 +0000 - first version of (almost) working xsl script for db_berkeley module the index creation don't work for some tables yet git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2863 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=3cb35b7… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Oct 5 10:47:36 2007 +0000 - small formatting changes git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2860 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6b9d935… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Sep 27 15:53:04 2007 +0000 - fix strip column datatype - fix cr_tree_rewrite function, use the specfified tree instead of the defaul closes Bug #1803444 - add a comment about the difference between internal and external IDs git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2830 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=54ef43e… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Sep 27 11:07:10 2007 +0000 - fix the confusing mismatch between config and db mode in carrierroute now both modes only use 'domain' in documentation and source - adjust database scripts too git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2827 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=422aa3a… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Sep 20 09:16:59 2007 +0000 - fix wrong name in database documentation git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2796 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=07dc819… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Wed Sep 12 15:39:44 2007 +0000 - increased table version for presence active_watchers table git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2749 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2b1249d… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Sep 12 08:59:40 2007 +0000 - extends one comments in sr_module.c - unify db-api documentation - fix one error message in db_ut.c git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2741 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=962bcbc… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Wed Sep 12 08:44:45 2007 +0000 - new module: Resource List Server (implements the specifications in RFC 4662 and RFC 4826) - requires 2 new databse tables - rls_presentity and rls_watchers - works independent from presence server - testing required git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2739 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=53d9443… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Sep 10 15:25:12 2007 +0000 - port mysql driver and db API to new logging system git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2733 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a441792… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Fri Sep 7 16:23:17 2007 +0000 - improved xcap_client module: - added conditional queries - possibility to configure a periodical query update method (works with any xcap server) - modified xcap table , added new columns and changed default name (version increased) - improved presence_xml - xcap_client interface - updated documentation git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2723 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=71110ce… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Sep 4 14:40:17 2007 +0000 - improve diplayed doc name of uri-db - spelling fix in auth* modules git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2711 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=edfe696… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Tue Sep 4 08:30:20 2007 +0000 - added a new column in presence xcap_table - etag, needed by an integrated xcap server (version increased) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2709 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=196e364… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri Aug 31 13:16:26 2007 +0000 - unifiy URLs in database docs, use an entity to make this configurable git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2688 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5886d29… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Aug 30 13:17:44 2007 +0000 - documentation fixes correct name of dispatcher module index links are now properly followed, instead of the output the link name git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2683 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f001ee7… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Aug 29 16:01:01 2007 +0000 - add error handling for strptime and strftime in str2time and time2str - return an error if the time conversation fails - port to new logging system git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2671 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1157360… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Tue Aug 28 16:28:35 2007 +0000 - updated presence watchers table sql definition git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2659 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=02967b8… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Mon Aug 27 14:44:23 2007 +0000 - fixed some bugs in presence modules (reported by Juha Heinanen) - added a new column to active_watchers database table (version increased ) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2643 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8a9134e… Author: Juha Heinanen <jh(a)tutpro.com> Date: Mon Aug 27 11:26:50 2007 +0000 * Added a gateway attribute that can be used to indicate if a gateway supports directed media (RFC 4145). git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2638 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=da396e9… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Wed Aug 22 13:32:55 2007 +0000 - modified presence and presence_xml to allow using external XCAP servers with the possibility to configure the mode of operation through presence_xml module parameter 'integrated_xcap_server' git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2628 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2d6c48e… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Mon Aug 20 09:15:30 2007 +0000 - fixed a bug in index definition git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2620 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6b28dfe… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Mon Aug 20 08:47:47 2007 +0000 - made changes in watchers table ( version increased ) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2619 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=11856be… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Fri Aug 17 11:28:20 2007 +0000 - add space in front of "order by" (reported by Ben Smithurst and Anca Vamanu) - dev version increased git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2614 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5ffed94… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Thu Aug 16 07:35:58 2007 +0000 - included memory caching storage with the possibility to configure a fallback to database mode git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2604 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=a7e6beb… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Mon Aug 13 17:07:01 2007 +0000 - added 2 more columns to pua_table (increased table version) - enabled refresh possiblity after server restart - included event type in record identification git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2597 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2ea504c… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Aug 1 18:19:59 2007 +0000 - add carrierroute tables to Makefile in db/schema - add actual SQL code for this tables - update SQL with the last changes in schema files git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2563 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=10cbbdd… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Aug 1 18:18:08 2007 +0000 - add carrierroute module - Credits go to Jonas Appel, <jonas dot appel at schlund dot de> - add module to exclude_modules var in Makefile - add database schemas for two necessary tables - add database tables to extra tables definition in openserdbctl git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2562 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=0a1b84d… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Mon Jul 30 12:14:55 2007 +0000 - added a new column to pua table - contact (increased version) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2547 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f947675… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Mon Jul 30 10:06:19 2007 +0000 - removed unecessary ude_presentity index (reported by Juha Heinanen<jh(a)tutpro.com>) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2543 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=ab7b2ae… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Fri Jul 27 11:41:08 2007 +0000 - table definition for dispatcher module - credits to Ancuta Onofrei for DB support in dispatcher git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2533 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=089fe36… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu Jul 26 15:14:43 2007 +0000 - fix small error in template.xml git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2527 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8211f0e… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jul 25 11:52:20 2007 +0000 - add '-f' to rm, to prevent errors if the file does not exist git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2518 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=ef4fb71… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jul 25 08:57:44 2007 +0000 - add index names to serweb server monitoring and domainpolicy table git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2516 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=7340e62… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jul 25 08:48:02 2007 +0000 - add index names to two serweb tables git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2515 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b62aa67… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Fri Jul 20 10:45:46 2007 +0000 - corrected syntax errors when adding new index git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2490 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=cc07a52… Author: Anca Vamanu <anca(a)voice-system.ro> Date: Thu Jul 19 14:34:45 2007 +0000 - added some KEYs to presence tables to improve db query performance (table version increased) - did some cleanup (corrected some log messages, a bit of restructuring ) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2485 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=004accc… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jul 18 16:28:47 2007 +0000 - implement 'insert on duplicate key update' SQL directive in database API and mysql driver - this is similar to the replace SQL command, but the old row in case of an update is not deleted - closes #1665077 git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2477 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=9db225d… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jul 18 16:03:34 2007 +0000 - adapt mysql fetch_result function to the postgresql behavior, only fetches a partial result set, if the number of wanted rows is zero return nothing - this matches more closely the user expectations of the db api - add a comment to the api documentation about this behavior git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2476 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=65571b6… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jul 18 10:37:27 2007 +0000 - add template sgml file for database documentation - change Makefile to use this template, add entities link git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2471 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=e2f3c93… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Jul 17 11:18:09 2007 +0000 - more meaningful table ('database') names for doc generation git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2466 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=48cb6cc… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Jul 17 11:16:31 2007 +0000 - dbschema doc generation create now only one document for all tables - change stylesheets to a little bit newer docbook version git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2465 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8604131… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Wed Jul 11 09:43:51 2007 +0000 - updated the dialog table format (according to the extention of the dialog structure). git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2438 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=0929d7f… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jul 4 14:04:45 2007 +0000 - fix dbtext stylesheet to generate version data for tables - add small hack to db/schema Makefile to copy the version number to the version file - remove version number insertion from openserdbctl.dbtext - there is now all table version data present in this table, even if some tables are not used git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2405 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=68d40bc… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jul 4 12:55:15 2007 +0000 - change dbschema-docbook-clean, use a own target, this is much more efficient - suppress the output of the 'rm' in root and db/schema Makefile git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2402 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=81e739a… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jul 4 11:33:34 2007 +0000 - add dbschema-docbook target and subtargets for txt, html and pdf documentation generation from the xml db schema - add cleanup for this files to docbook-clean target - activate docbook generation in db/schema Makefile - at the moment for each group of tables "eg. presence" a own document will be created, this is needs to changed, and is on my TODO list.. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2399 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=298a808… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jul 4 11:23:06 2007 +0000 - make chars in db schema documentation compatible with docbook - add some documentation git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2397 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=3f4fa3a… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Wed Jul 4 09:05:30 2007 +0000 - updated the DOCTYPE url to a working location. DTD file now present at http://openser.org/pub/openser/dbschema/dtd/1.0/dbschema.dtd git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2395 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=54d4905… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Wed Jul 4 08:19:01 2007 +0000 - dialog table added to the openser schema git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2394 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6947d05… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jun 18 10:41:24 2007 +0000 - fix wrong column names in presentity and active_watchers table - reported from Dave Waiting git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2366 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=ede27bf… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jun 13 13:15:37 2007 +0000 - change dir for dbtext to 'openser', more consistent with other DBs - integrate textdb.sh into the common infrastructure, use the generated tables - the version data is missing, this needs an update for the dbtext XSL scripts - add serweb table creation, admin data generation is missing - add reinit support for dbtext - backup, restore and copy not implemented and blocked for dbtext - you can specify now a optional dbname for operations, needed for dbtext - fix db SQL installation, install as non-executable in Makefile - change Makefile to install openserdbctl.dbtext - fix INSTALL_TOUCH in Makefile for postgresql and mysql git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2361 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1657ebd… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed Jun 13 10:48:35 2007 +0000 - fix wrong pua column name, s/pres_user/pres_uri git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2360 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=14b1237… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Jun 12 13:33:11 2007 +0000 fix error in usrloc and registrar table, s/useragent/user_agent git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2359 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=7d69520… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue Jun 12 08:06:18 2007 +0000 - address table belongs to the permissions module, not to lrc - Reported from Juha Heinanen git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2355 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=14541dc… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jun 11 14:08:06 2007 +0000 -unify logging messages in db/db_ut.h, use 'db_' prefix in all cases git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2354 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=29ec814… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jun 11 13:57:32 2007 +0000 - move customized print_* functions from db-modules to db core - use a function pointer for the customized val2str function from the modules that gets used in the common function in db core - Thanks to Victor Gamov for the patch git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2353 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c250b82… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Jun 11 13:50:08 2007 +0000 - move extension point to openser-extensions.xml file - add this file to Makefile - remove extra.xml include from openser-standard.xml git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2352 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=0438d14… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed May 30 12:14:08 2007 +0000 - update xml database table sources - use SERIAL PRIMARY KEY for postgresql unique ids - use binary for xcap_xml and presentity body column - move primary key definition for mysql to column definition - update template - add some missing index names, fix misspellings and double names for indexes git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2318 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=e47829f… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue May 29 15:41:48 2007 +0000 - add missing pdt table to schema definitions git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2312 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=78ac3c3… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue May 29 09:02:31 2007 +0000 use bytea instead of text for postgres xcap_xml table, bug 1684821 git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2310 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=9397efc… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri May 25 15:00:34 2007 +0000 unify all database id field to unsigned int git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2298 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d0c43d2… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri May 25 12:08:24 2007 +0000 update build system: - do not stops with a error anymore if some files are present in the modules dir - move textdb.sh installation to install-bin to prevent inclusion of dbtext stuff into every debian package - add define for '/usr/share/openser' for architecure independent data files data-prefix, data-dir - add make dbschema, make dbschema-clean for dbschema generation and cleaning - add mkdir target for data-dir - install mysql and postgres sql code with mysqldb.sh and postgresdb.sh, so that this get included into the right debian packages - fix wrong ROOT variable in make clean task in db/schema Makefile git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2291 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=665516a… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue May 22 08:38:48 2007 +0000 fix documentation and mask type size in address table git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2257 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f956d5c… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon May 21 13:37:14 2007 +0000 - small docu update - change uri size in pua tables git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2253 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8961f72… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon May 21 12:19:18 2007 +0000 - fix variable type in phonebook table - fix variable name in subscriber table git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2252 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8ef74cb… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon May 21 12:01:50 2007 +0000 - add missing path size to usrloc table - fix usage of 'NULL' default values - update example file git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2251 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=67686f3… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon May 21 11:31:55 2007 +0000 add missing path size to registrar table git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2250 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=e3d1c46… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon May 21 10:44:16 2007 +0000 add the last tables, finish serweb git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2249 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d1fab40… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri May 18 13:55:45 2007 +0000 - add usr_preferences, subscriber, xcap_xml, watchers, pua, pending, presentity, active_sessions and active_watchers tables - some cleanups in xml files git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2248 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1d62f76… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri May 18 09:51:34 2007 +0000 - add silo, speed_dial, re_grp and dbaliases table definitions - some cleanups in other xml files git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2245 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2aa8865… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed May 16 16:14:25 2007 +0000 - add template.xml file as example for a xml database specification - add usrloc definition - fix wrong xpointer call in openser-standard file git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2237 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=dfed16e… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed May 16 15:35:26 2007 +0000 - add DATETIME default entity to entity.xml - add group, permissions, registrar and domainpolicy definitions git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2236 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1768a79… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed May 16 13:37:12 2007 +0000 - add siptrace and cpl module xml file - add address and missed_calls xml definition - update lcr and acc include files - some docu fixes git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2234 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=56590fa… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Wed May 16 12:57:31 2007 +0000 - finish lrc module related tables - fix DTD definition - remove core and extra xml files - rework and cleanup Makefile git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2232 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c48e042… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue May 15 16:18:29 2007 +0000 - cleanup of xml references - add definition for acc module git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2227 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=975b070… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue May 15 13:56:30 2007 +0000 - complete 'extra' tables - add verbose case to makefile - add two more entities git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2225 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=54f96fd… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Tue May 15 10:48:05 2007 +0000 - add entities from database setup script - add xml files for core, presence, serweb and extra tables - update xml after extensions in xsl scripts - update Makefile git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2223 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=71498e2… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon May 14 15:51:41 2007 +0000 - change dtd reference to local fs, update gw definition - add definitions for pdt, cpl and uri tables git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2218 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=0200e6d… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon May 14 14:21:32 2007 +0000 - add a directory for xml definition for database schemas - add Makefile and first xml definition for gw table - xsl schemas needed for this and other stuff still missing, not ready yet git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2217 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=c52783f… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Fri May 11 08:01:24 2007 +0000 add 'db_' prefix to fetch_rows and fetch_row function to prevent name clash with mysql library function git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2196 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=0eece1d… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu May 10 12:37:19 2007 +0000 - more database interface cleanup - move the free_rows function to db/db_res.c - move the free_row function to db/db_row.c - change mysql and unixodbc to use this implementation - the postgresql uses a different implementation, this still needs some investigation - move common used print_columns function to db_ut.c - change the mysql, postgresql and unixodbc modules to use this implementation - use the right mysql and postgresql escape function for BLOBs instead of the deprecated function which could produce errors in certain corner cases - extends comments in db dir and database modules git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2185 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=94b24ee… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon May 7 12:01:18 2007 +0000 - move most of the time and date handling functions for databases to db_ut.h - delete the implementations in unixodbc, mysql and partly in postgresql - fix header includes for these modules - postgresql saves the time and date with the timezone attached, so this module can not use the common db_time2str - change the _XOPEN_SOURCE define to 600 use the SuSv3 definition for strptime, the old define conflicts with some string handling functions - delete the unneded time related defines in postgresql module - add undefs after the defines to avoid changes for subsequent includes git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2157 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=cda1e99… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Thu May 3 12:03:14 2007 +0000 * move commonly used char* converter function for DBs into db dir * remove these functions from unixodbc, postgresql and mysql * change these modules to use the implementation from db_ut.c * fix wrong indention in ut.h git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2126 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=516b44c… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Date: Mon Apr 23 12:44:16 2007 +0000 Add documentation for fetch_result function to db api docs, extends comments for this function. git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2049 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=4e8a664… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Wed Apr 4 15:53:50 2007 +0000 - added extension for OpenSER-Database-API and the mySQL-Module for "last_inserted_id" method. This method returns the last inserted ID of an INSERT-statement, in case the table has an auto-increment field. Contributed by Carsten Bock, BASIS AudioNet GmbH The first module to use this functionality will be the usrloc module for update and delete operations (used the record ID instead of costly AOR and contact maching) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@1970 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=130215b… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Fri Mar 9 13:04:51 2007 +0000 - fixed several warnings regarding signed/unsigned ops, incomplet initializers for static data. Based on a patch send by Eliot Gable <egable(a)broadvox.net> for increasing the level of warning messages git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@1782 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=bf01159… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Thu Feb 22 15:16:38 2007 +0000 More cleanup applied : Delete the crc32file function from crc.c. This is a test function, that is not exported and thus not used anywhere. It also deletes the main function there that is commented out. Remove the "/bin/sh" shebang in the sourced scripts in the ./scripts directory. These files are not meant for direct execution and are installed in /usr/lib/ anyway. This fix comes from the debian package dir (see next patch). Remove the now unnecessary patch in the debian packaging directories. Adds some documentation for the replace callback in the api.txt documentation in the db dir. It also extends the comment for this function in db.h. Credits go to Henning Westerholt <henning.westerholt(a)1und1.de> git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@1687 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d957e6c… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Thu Feb 15 10:10:34 2007 +0000 - free alocated memory when binding DB. Not a really a leak now since it is done only at startup, but better free than unused and avoid future turning in leak (reported by Henning Westerholt) - closes 1660410 git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@1645 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=e180d9c… Author: Bastian Friedrich <bastian.friedrich(a)collax.com> Date: Mon Feb 12 16:24:59 2007 +0000 Fixing minor typo ("quries" -> "queries") during an error logging git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@1616 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=501d9d5… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Mon Jan 15 11:06:45 2007 +0000 - removed obsolete files related to old FIFO impl git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@1510 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f3076ee… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Fri Aug 4 08:23:25 2006 +0000 - db_res_t* variables initialized to NULL (patch by Norman Brandinger) git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@1063 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8351011… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Fri Jul 14 14:13:00 2006 +0000 - added support for fetch_result() in DB API - drivers supporting fetch_result() will advertise DB_CAP_FETCH as capability - added support for fetch_result() in mysql module - usrloc modules uses fetch_result() if available when loads location records - this removes the issue with loading huge numbers of location records which required increase of PGK memory size and recompilation of OpenSER - from the tests, with 1MB memory (default) the out of memory occured approximately around row 4300 - usrloc has a new parameter 'fetch_rows' for tunning the number of the rows to be fetched at once, default is 2000 git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@1012 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f0a8bae… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Wed Jul 5 08:52:15 2006 +0000 - more validity checks for table_version() - check if returned field has INT type and if it's not null git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@966 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b5887fb… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Sun Jul 2 18:01:08 2006 +0000 - check the type of table_version result (reported by Ryan (Matty <matty91(a)gmail.com>)) - free mysql connection from pool only when found git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@950 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=850c6f9… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Tue Jun 6 18:29:36 2006 +0000 - check for null passwords (on some OS strcmp crashes) - reported by Edgar Barbosa - tbd: the other attributes in db url has to be investigated if they are optional or not git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@902 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=dfcf771… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Mon Jun 5 15:07:10 2006 +0000 - code formating beautification git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@898 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6173986… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Mon Jan 30 12:03:11 2006 +0000 - added reminder features (patch subbmited by Andrea Giordana) - added OP_NEQ (!=) to database operators - doc updated - dev version increased - mysql script updated git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@573 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=857b95e… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Thu Jun 16 12:07:08 2005 +0000 - mergin with ser cvs head git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@29 689a6050-402a-0410-94f2-e92a70836424 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=9405692… Author: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Date: Mon Jun 13 16:47:24 2005 +0000 Initial revision git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@2 689a6050-402a-0410-94f2-e92a70836424

1 0

git:daniel/pv: - sync transformations add/lookup with kamailio
by Daniel-Constantin Mierla 12 Feb '09

12 Feb '09

Module: sip-router Branch: daniel/pv Commit: 46ab082aab5971e8511460df0107709bd6aedb0d URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=46ab082… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Fri Feb 13 00:21:44 2009 +0200 - sync transformations add/lookup with kamailio --- pvapi.c | 11 ----------- 1 files changed, 0 insertions(+), 11 deletions(-) diff --git a/pvapi.c b/pvapi.c index 2e34412..fa304a5 100644 --- a/pvapi.c +++ b/pvapi.c @@ -1362,15 +1362,9 @@ int tr_table_add(tr_export_t *e) tri = _tr_table[trid%TR_TABLE_SIZE]; while(tri) { - if(tri->trid > trid) - break; - if(tri->tre.tclass.len > e->tclass.len) - break; if(tri->tre.tclass.len==e->tclass.len) { found = strncmp(tri->tre.tclass.s, e->tclass.s, e->tclass.len); - if(found>0) - break; if(found==0) { LM_ERR("TR class [%.*s] already exists\n", e->tclass.len, @@ -1470,11 +1464,6 @@ tr_export_t* tr_lookup_class(str *tclass) tri = _tr_table[trid%TR_TABLE_SIZE]; while(tri) { - if(tri->trid > trid) - break; - if(tri->tre.tclass.len > tclass->len) - break; - if(tri->trid==trid && tri->tre.tclass.len==tclass->len && memcmp(tri->tre.tclass.s, tclass->s, tclass->len)==0) return &(tri->tre);

1 0

git:daniel/pv: init_mi_core() exported via mi.h
by Daniel-Constantin Mierla 12 Feb '09

12 Feb '09

Module: sip-router Branch: daniel/pv Commit: 4e6f8d23f4afbf76a69196e4789be85742e8a56e URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=4e6f8d2… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Fri Feb 13 00:16:27 2009 +0200 init_mi_core() exported via mi.h - mi_core.h no longer needed, probably mi_core.c should get into a module --- lib/kmi/mi.h | 2 ++ lib/kmi/mi_core.h | 2 +- 2 files changed, 3 insertions(+), 1 deletions(-) diff --git a/lib/kmi/mi.h b/lib/kmi/mi.h index 0a14452..5c0ac19 100644 --- a/lib/kmi/mi.h +++ b/lib/kmi/mi.h @@ -91,5 +91,7 @@ static inline struct mi_root* run_mi_cmd(struct mi_cmd *cmd, struct mi_root *t) void get_mi_cmds( struct mi_cmd** cmds, int *size); +int init_mi_core(void); + #endif diff --git a/lib/kmi/mi_core.h b/lib/kmi/mi_core.h index bc58392..481aeed 100644 --- a/lib/kmi/mi_core.h +++ b/lib/kmi/mi_core.h @@ -36,6 +36,6 @@ #ifndef _MI_MI_CORE_H_ #define _MI_MI_CORE_H_ -int init_mi_core(void); +// int init_mi_core(void); #endif

1 0

git:daniel/pv: mi include file
by Daniel-Constantin Mierla 10 Feb '09

10 Feb '09

Module: sip-router Branch: daniel/pv Commit: 7f8bc741b9ee35df5c77ed199299a62ce1444dca URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=7f8bc74… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Tue Feb 10 23:54:09 2009 +0200 mi include file - just include the lib/kmi/mi.h --- mi/mi.h | 66 +-------------------------------------------------------------- 1 files changed, 1 insertions(+), 65 deletions(-) diff --git a/mi/mi.h b/mi/mi.h index d01d94b..b3c106f 100644 --- a/mi/mi.h +++ b/mi/mi.h @@ -28,71 +28,7 @@ #ifndef _mi_h_ #define _mi_h_ -#include "../str.h" - -#define MI_DUP_NAME (1<<0) -#define MI_DUP_VALUE (1<<1) - -#define MI_OK_S "OK" -#define MI_OK_LEN (sizeof(MI_OK_S)-1) -#define MI_INTERNAL_ERR_S "Server Internal Error" -#define MI_INTERNAL_ERR_LEN (sizeof(MI_INTERNAL_ERR_S)-1) -#define MI_MISSING_PARM_S "Too few or too many arguments" -#define MI_MISSING_PARM_LEN (sizeof(MI_MISSING_PARM_S)-1) -#define MI_BAD_PARM_S "Bad parameter" -#define MI_BAD_PARM_LEN (sizeof(MI_BAD_PARM_S)-1) - -#define MI_SSTR(_s) _s,(sizeof(_s)-1) -#define MI_OK MI_OK_S -#define MI_INTERNAL_ERR MI_INTERNAL_ERR_S -#define MI_MISSING_PARM MI_MISSING_PARM_S -#define MI_BAD_PARM MI_BAD_PARM_S - - - -struct mi_attr{ - str name; - str value; - struct mi_attr *next; -}; - - -struct mi_node { - str value; - str name; - struct mi_node *kids; - struct mi_node *next; - struct mi_node *last; - struct mi_attr *attributes; -}; - - -struct mi_root { - unsigned int code; - str reason; - struct mi_handler *async_hdl; - struct mi_node node; -}; - -typedef struct mi_root* (mi_cmd_f)(struct mi_root*, void *param); -typedef int (mi_child_init_f)(void); - - -typedef struct mi_export_ { - char *name; - mi_cmd_f *cmd; - unsigned int flags; - void *param; - mi_child_init_f *init_f; -}mi_export_t; - - -#define init_mi_tree(code, reason, reason_len) 0 -#define free_mi_tree(parent) -#define add_mi_node_sibling(node, flags, name, name_len, val, val_len) 0 -#define add_mi_node_child(node, flags, name, name_len, val, val_len) 0 -#define addf_mi_node_child(node, flags, name, name_len, fmt, ...) 0 - +#include "../lib/kmi/mi.h" #endif /* _mi_h_ */

1 0

git:daniel/pv: MI: core part
by Daniel-Constantin Mierla 10 Feb '09

10 Feb '09

Module: sip-router Branch: daniel/pv Commit: 697e05f3421efa7e614783e8497a743d792fa9cc URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=697e05f… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Tue Feb 10 23:52:07 2009 +0200 MI: core part - code from kamailio MI --- lib/kmi/Makefile | 9 ++ lib/kmi/attr.c | 176 +++++++++++++++++++++++++ lib/kmi/attr.h | 61 +++++++++ lib/kmi/fmt.c | 54 ++++++++ lib/kmi/fmt.h | 71 ++++++++++ lib/kmi/mi.c | 180 +++++++++++++++++++++++++ lib/kmi/mi.h | 95 +++++++++++++ lib/kmi/mi_core.c | 378 +++++++++++++++++++++++++++++++++++++++++++++++++++++ lib/kmi/mi_core.h | 41 ++++++ lib/kmi/tree.c | 286 ++++++++++++++++++++++++++++++++++++++++ lib/kmi/tree.h | 103 +++++++++++++++ 11 files changed, 1454 insertions(+), 0 deletions(-) Diff: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=697…

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

sr-dev February 2009