Author: Jan Janak 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=a33b9a87f67d035c727520bd8cf8eac3937cc5a9 Author: Jan Janak 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=7d14b0374cd9b84b4114bbb4f75ea0ca85801587 Author: Jan Janak 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=cb5aaf833539c231625e0d5474182a32b3ba3335 Author: Jan Janak 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=70fc66d9705f09e52f68af094f0807c85799c15f Author: Jan Janak 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=20606ac1e48c6913718f15fed0f632fabceb3657 Author: Jan Janak 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=13f9c1e6fe82c579c57ebb6f5afe67dd1730e872 Author: Jan Janak 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=3561d314a524eee363847ebb61e11bb1f9d63f4b Author: Jan Janak 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=a5071c502ceb51e09a6ca7805396d3f0cd6b026e Author: Jan Janak 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=18580856594ed04229fb0650f7ec505a24320ffa Author: Jan Janak 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=5aad47222996f9006fb15018e61227c350385097 Author: Jan Janak 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=35ba402ab2814581a020e8a22bf55cc1098280f0 Author: Jan Janak 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=f3bcff01b2cb289d191cbdaf89029f5e608971ce Merge: 569bf0016d12bfa3da853e256d6b24e4ab730fa0 86a18a6d68639db7982aeb436d05a9e6903bcaca Author: Jan Janak 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=569bf0016d12bfa3da853e256d6b24e4ab730fa0 Author: Jan Janak 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=86a18a6d68639db7982aeb436d05a9e6903bcaca Author: Henning Westerholt 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=ba9b7dbe78876bc1de3a227168f9a7b14a627edf Author: Juha Heinanen 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=1b4f5086fff82d2d35686dd6f35f2c6f5871186d Author: Daniel-Constantin Mierla 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=5d4d8292e6d29382c20efa0b538238976415679b Author: Juha Heinanen 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=8fb93e2af5dc7770789637b0f69c1a7c489ecb8f Author: Henning Westerholt 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=005029d515598612246f3aea913c13487831511c Author: Henning Westerholt 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=fec76e8d5878227d2148a90511f9d750aff69f7e Author: Henning Westerholt 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=ccac2322f748b180a12f9190a57c2cd4c97d1a6f Author: Henning Westerholt 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=6f82012273435180d8a71cd2c4bdbae0a217a1a4 Author: Henning Westerholt 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=744bed4ad3c6749abb7dd43f6be226fd5552db73 Author: Henning Westerholt 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=c0a18f4fd10a7b74914d3b89bea77b77545220a5 Author: Henning Westerholt 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=88dc2f06c991087719c5ef349a00e27fe6ceb7fb Author: Henning Westerholt 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=cc68e8f0dc2e976e399318a0c860fce2306e160b Author: Henning Westerholt 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=e5721bcf2ff1a7a436371cd04c09b59bfd504002 Author: Henning Westerholt 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=3d7f4c1e965216614392c5152072f3a7edd483d5 Author: Henning Westerholt 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=f9200735c6cabb41adc731008825e685ddae2889 Author: Henning Westerholt 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=1d7bba54261d633f498f5ab1a54ee461a69467bc Author: Henning Westerholt 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=c843980a3ba1656daa711d5184d28988ab36f237 Author: Henning Westerholt 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=18557a9f3069be8e5f71c0707cdacd5fc6bab4ad Author: Henning Westerholt 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=2d0ae74699f66fb40c5a9beb96ac91da4eb103b2 Author: Henning Westerholt 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=1b53cbd5908de117a2033267930ae211b6bd532e Author: Henning Westerholt 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=f6b18a6f21570d411bd16931fb49b1c3772a9697 Author: Juha Heinanen 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=a465a4ab11da4852416e25c7e9a24421fde616c7 Author: Henning Westerholt 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=8ecee0c1c41ddd8197644864539cd81ade08eec8 Author: Juha Heinanen 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=1212f98457f00864da4aae092090879ec8745721 Author: Henning Westerholt 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=0ba2767853abb5bd106fecee446e0c317e97af48 Author: Elena-Ramona Modroiu 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=cc6c7a5f32f05b1b33e4300d4101708c6063bbac Author: Henning Westerholt 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=13c66bf68beb365f25ce2c5551ff29f301b60365 Author: Henning Westerholt 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=7746b450f7a0c9b8e246288ba9b516328fa8fca3 Author: Henning Westerholt 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=04c0fcf4d5971c54a1f5547c881c18c750bf6379 Author: Henning Westerholt 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=6f0c1672883e0c673a8b5946dab2eaff9d3800b9 Author: Henning Westerholt 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=537075c8219166f03aaf588df5639bf7a50dfcc0 Author: Henning Westerholt 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=f2b44d13dc34bf306d47ecd7c35c46f1d24f825b Author: Henning Westerholt 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=a0e004911eeda4eef029c724ef4777a5c9d65a52 Author: Henning Westerholt 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=c71af70a4cf61db02c1b1ac1aa925f27c4c544a1 Author: Henning Westerholt 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=8d8f16856530891f0806c39f0fe627e1e43f58fa Author: Henning Westerholt 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=468c304299f14e5c703ce35c033c4ceeb325bdbd Author: Henning Westerholt 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=53b1496ec6a26d70212667f1ac4847e679bbea84 Author: Henning Westerholt 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=6081a4833941d09f3e123615e2f2b71d4885d017 Author: Henning Westerholt 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=a3ccd3d6f4ba5f13893831950ae6b2a4da3f1395 Author: Henning Westerholt 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=a7fc7c605ff8c483755ef6c88f0f9353b9b265e6 Author: Henning Westerholt 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=cf4700bc89bd8c6d32744faa7db1fe735da0fe75 Author: Klaus Darilion 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=14248f85d7cc95e3ae134056b7c4576ba143687f Author: Dan Pascu 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=d520eaf5e702e948f689fe25d7cb029e0ecb0ced Author: Henning Westerholt 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=e4998f77b16ba9db20583eeb306e6fb8a4d7db7d Author: Henning Westerholt 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=5b5a6333d93c517215e1fa8963649811a5f00587 Author: Henning Westerholt 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=4251c5433f714627fe43ea23004f773dc93c95bd Author: Henning Westerholt 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=c750c35a4dcb2d8f18538f4d35fee20decb1ea10 Author: Henning Westerholt 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=875f5c9444319ab55c9047196e5a227fc48e62ec Author: Henning Westerholt 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=78611c936736ec81212b61f5bce7b25cfe3ca23d Author: Bogdan-Andrei Iancu 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=b664eadfabc0b6d6dc4b0eb6dcd305a087c734ea Author: Anca Vamanu 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=b332f22ddd606c79d44ddca3dc616502fdb82eed Author: Henning Westerholt 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=d162a81c328f8de385fe01cd97562ceae8b92858 Author: Henning Westerholt 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=8384f5a76d9f84355ada74f704a76eee87410c52 Author: Henning Westerholt 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=65d4ee8d6cd9dc7dcf09f3adb89ebc455a5b9fe9 Author: Henning Westerholt 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=6c8c88ee1c7a7a5e977d3b46b249e1dec130a865 Author: Anca Vamanu 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=507a587fa9bef6eba0eeabaa40fad6a57f2b615a Author: Henning Westerholt 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=6c4ccfa9419ed0bbac6f4e0dc694aab8395bd378 Author: Henning Westerholt 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=494f3bbcc9db6c62a5f758cf84fe36b396319cbe Author: Henning Westerholt 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=c5e925db34a2ba51ffae1718306304036cf8465d Author: Henning Westerholt 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=e2a96019f84093235055079f095c6950f5ee29af Author: Henning Westerholt 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=dd7348a108d586257c00bb263c8fe9a0ce3a99d1 Author: Henning Westerholt 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=0f5ce5c0e58051895d8362a989022f4f6ce0aba9 Author: Bogdan-Andrei Iancu 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=a8250d07a5d1172dabd6e43b1af00d2bb86864fb Author: Daniel-Constantin Mierla 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=d5b80544f26e5ee556d61e53113deeac5c51f73e Author: Henning Westerholt 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=d6789309b611abf0e2b7b9fa247eed40e58ca1bc Author: Daniel-Constantin Mierla 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=1799926107f5354b1b7b6e1a5c0b4db3f27282b4 Author: Henning Westerholt 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=9a8126dc03c98d292ade2547c6fcda75792f036b Author: Henning Westerholt 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=04e87c51fb08caa4a82f88dd594b03e70eb25488 Author: Henning Westerholt 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=b20e950073d5edef4701ab84aa9f718754013a50 Author: Henning Westerholt 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=b22602f51ca2e3e243b4de354e733caa2658520a Author: Bogdan-Andrei Iancu 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=cb87dcad1f27a77bd8bb3bfc27c29d18bc345fc8 Author: Henning Westerholt 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=dda0818f9735f574d9b65f43d515dbf32458b158 Author: Henning Westerholt 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=705bb727f1189246ceb8c6cab2e228490c8d80aa Author: Daniel-Constantin Mierla 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=72b0651d358d30840e849a063d2052d6ffeac439 Author: Henning Westerholt 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=47c619ff6709b0fc222021f5a32068160c0d6d3e Author: Henning Westerholt 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=0ad41bb7a8750effa92139f190f4f5db5c1139a2 Author: Henning Westerholt 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=c65db6bbb8253ec3110e2a8d25015d00300c3a73 Author: Henning Westerholt 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=88a6937ec62cbda2a2eeee7db6a296527c28524e Author: Henning Westerholt 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=dac7077b686393bcaddb75008a681e55b426d154 Author: Henning Westerholt 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=30bde5b0fdb42b2cc33f4bea4c7d39e158a5fe84 Author: Henning Westerholt 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=c9485c3cd48fad587b1eaeda7c3500430052bcb4 Author: Henning Westerholt 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=7a85c8e01b50329f2561ef5ece1f5f9d0483a706 Author: Henning Westerholt 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=25f17988b007b3dca7f3d2e70826b6b6b6d09df5 Author: Henning Westerholt 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=bc4bf2658a7ace6140da1568833a4cbab2ff0178 Author: Henning Westerholt 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=1655fbd867a23e8dfb99506a760e2f4f3cb1d75e Author: Juha Heinanen 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=2b32ef255b1b8b07fe92ae5e15c2d26d314b61bf Author: Henning Westerholt 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=309b1f1db6e155df30e9db643739aa4c04d5b921 Author: Henning Westerholt 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=518ed3c1e65ddcb2cd09e69951aed76e69409268 Author: Henning Westerholt 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=71eafcc959ed78bc95941fd3e5cec5a07409366f Author: Juha Heinanen 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=3d27bead7e35f4ec3324055fb785710995f7c69c Author: Juha Heinanen 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=27aa4ad6d926578573bea98d268c071fe241f710 Author: Jesus Rodrigues 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=79c9b78cf07cff2ddbbc0a903e58133e64fd172b Author: Henning Westerholt 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=34523d7ffabfca3cab4de0f52cd7f25d094feda3 Author: Henning Westerholt 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=d3b8213e96cb69e7164ad455ae412968a3533a08 Author: Bogdan-Andrei Iancu 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=2f60e0c96fda47e9fc1c961cb471e89d73beb33a Author: Anca Vamanu 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=710bdc2c6fcfd69cf26b0c4e135adf7dbccec379 Author: Dan Pascu 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=97841ad1e31ef24b2d8d0382b301c263b119da0d Author: Henning Westerholt 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=09d410b4c2f98cfd9d98a5c1e544e20dabaa2aff Author: Henning Westerholt 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=5ac299ca0c059b7763a6cd21136ff7168936e1e8 Author: Henning Westerholt 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=6f95efa8bf370da0ae838bf57983747e3ca533ea Author: Henning Westerholt 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=42d74a5e119ce8de789af68654bcef5d8b08e432 Author: Henning Westerholt 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=04e7ba696d94c8f80ad2a0ab36082fe1c4509dba Author: Henning Westerholt 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=1cd0d621e312cd6956446028392ff28704eb5789 Author: Henning Westerholt 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 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=11ea23e939c71b2b24da44db4710632b83da4037 Author: Henning Westerholt 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=0cdfaf602b3050872b6c7297d3d7422f4d6e3bce Author: Bogdan-Andrei Iancu 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=612a6f423b83519bacc634e2bea234b358d482be Author: Henning Westerholt 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=2899ef3ba635ef59de71af64aa8a42e3dadc16b5 Author: Dan Pascu 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=3c532005ba1003e2cd12810e1f21d10f86bcc57a Author: Anca Vamanu 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=d033a26467f697ee89bb7920ed59722c8bd07458 Author: Dan Pascu 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=a8e6dd48aab44e27e63eba58c7955e4ffbc1d8f7 Author: Dan Pascu 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=890abb575d6393b3594eb06394ec7242289a2637 Author: Dan Pascu 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=5f711f82b3c8f9903f4ad2a69fa723c8f1c23d96 Author: Dan Pascu 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=ab9efd1d74b77a32190a62d2ceee84d8d9f18158 Author: Dan Pascu 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=6b259a8498c662fd8a4e4978079b699063ccf4e6 Author: Dan Pascu 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=1b58c59155f6bd3da579fb18d0693f73d2591470 Author: Dan Pascu 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=307860b26ba6b2c948b99817b019e2ba97f1cef9 Author: Dan Pascu 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=8d435c09c4ae19f3edb1f0a5791322831526be61 Author: Henning Westerholt 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=a4869c6052b5bd0efa7fcfd1926746027c387556 Author: Anca Vamanu 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=2aea67f2cd155ea042ed89e162e26d9ff1d0bd00 Author: Dan Pascu 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=100d17b007fd7e34bec6ab12b3c2544c35970128 Author: Henning Westerholt 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=676afffc5b8cda394508f4bf99b04269a31c18d5 Author: Henning Westerholt 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=f812683052f99ee5b979cb3864704e3585f459e6 Author: Henning Westerholt 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=3cb35b743c77881ed8a9fe07c0c0abb5157e6783 Author: Henning Westerholt 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=6b9d93590b02d6ad269502ab945b38531fcc0551 Author: Henning Westerholt 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=54ef43efc160c448d38eeea577d9676b292e1d9d Author: Henning Westerholt 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=422aa3aafa5def5663700c7b9900771d3fbe15aa Author: Henning Westerholt 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=07dc819dc313bbdb5d6fcf1a7b848033f132d9d4 Author: Anca Vamanu 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=2b1249dc768c8f3c2c30bc981ed454ffd972cb1a Author: Henning Westerholt 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=962bcbcdc8efb065c812fba031685a3490c5d812 Author: Anca Vamanu 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=53d94439d3ade53b1ebfdab155697be74ab6ee5d Author: Henning Westerholt 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=a441792da7899f817a2792ee6dd81922c879fc57 Author: Anca Vamanu 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=71110cef651f321de5b9377ffc3e1549717f463a Author: Henning Westerholt 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=edfe696d905642a89bbaf52c20828698663cb700 Author: Anca Vamanu 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=196e36483cc97131a4cd81dd66826ce8320530ce Author: Henning Westerholt 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=5886d29b001bba472508364d71dbbeb8e69a466b Author: Henning Westerholt 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=f001ee7dbd09114ab2672b36f6966a7b74f467ce Author: Henning Westerholt 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=1157360469b4b637893d6b3ddfa652d82db559c7 Author: Anca Vamanu 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=02967b89f171bef9bd9989113a3a1b288329ff8a Author: Anca Vamanu 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=8a9134eeadbcc0803ed00e194540af1c516ab83f Author: Juha Heinanen 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=da396e9e018c5bf5f28fe4f81f32e45de8ea90d6 Author: Anca Vamanu 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=2d6c48e56c6b26f758d36f2b88bb85dd05d1ddf5 Author: Anca Vamanu 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=6b28dfe99496ca1204dfbe4b158c265cca83a40e Author: Anca Vamanu 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=11856bebfb90c19d2ee00e231a0efc7e5eefcdec Author: Daniel-Constantin Mierla 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=5ffed9404cd1ef1c59623777653ca88b203e5302 Author: Anca Vamanu 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=a7e6beb0c66c7c3507f5e07a9ca1dc4e87ef4966 Author: Anca Vamanu 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=2ea504ccee26a7d81ecb8f4eebd96e4ea1f2744c Author: Henning Westerholt 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=10cbbdd99ff5bbdb5d6c549cc9ac2e1dc751caf6 Author: Henning Westerholt Date: Wed Aug 1 18:18:08 2007 +0000 - add carrierroute module - Credits go to Jonas Appel, - 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=0a1b84d75935848271ecd59f1ab92e46f85fd294 Author: Anca Vamanu 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=f947675ab8203315d89e3e527cd6b23707f54326 Author: Anca Vamanu Date: Mon Jul 30 10:06:19 2007 +0000 - removed unecessary ude_presentity index (reported by Juha Heinanen) 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=ab7b2ae039539845b2416eacaabb572e3089f051 Author: Daniel-Constantin Mierla 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=089fe36f04ce53ab9706f31085cbf5feedc8fe66 Author: Henning Westerholt 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=8211f0e615e120f37b800eb6150071a94b034a54 Author: Henning Westerholt 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=ef4fb71d52ab8215ead2d01078d56a6d8775c046 Author: Henning Westerholt 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=7340e62e4cb5d13ec33dedfc8db9b9ddc4d84502 Author: Henning Westerholt 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=b62aa67b74683a324569d1873449fd53abf597b5 Author: Anca Vamanu 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=cc07a52b8276909866d76f4dc884c93e3615ef9e Author: Anca Vamanu 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=004accc57d78efa1e523774ee2666a3c4c48866f Author: Henning Westerholt 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=9db225d9644c222798cd8f823199086c984d9f43 Author: Henning Westerholt 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=65571b65053a26d5e1d03dc05f0c2aa4a479777b Author: Henning Westerholt 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=e2f3c93885e4771351068c508603bfa633d43895 Author: Henning Westerholt 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=48cb6cce1a9600764e2cc1caef837eb877cbc933 Author: Henning Westerholt 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=86041318fbc57080e2dbda0c2c6187d881db1b6d Author: Bogdan-Andrei Iancu 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=0929d7f7bacebfbdbcb3aaa9a418ed09976ddf67 Author: Henning Westerholt 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=68d40bcfb23c9b5cbbaaae1060393899010ac5fa Author: Henning Westerholt 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=81e739a3b09e51ff9c8010b358f08cdc5b4bcc26 Author: Henning Westerholt 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=298a808072ac40a3bbce1d1d609025a782703258 Author: Henning Westerholt 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=3f4fa3a22c7a5ac8a2672f44bd955444cf437e8f Author: Bogdan-Andrei Iancu 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=54d490530c158a47e34dbf7b9ca48c4b23c1b230 Author: Bogdan-Andrei Iancu 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=6947d0594374a1f96d2d58d978623aca05c51c6e Author: Henning Westerholt 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=ede27bf959ce8f72d70005964ec17f34c35a2a83 Author: Henning Westerholt 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=1657ebd90b65d3459abc704924b803edde056589 Author: Henning Westerholt 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=14b1237ca11be7cf9d8d5bb29cbcae55c28edd20 Author: Henning Westerholt 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=7d695200d52ac7d27c0102dd65be3575d2265e81 Author: Henning Westerholt 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=14541dcfd4d18260b002d15af866769ea28a4127 Author: Henning Westerholt 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=29ec81482f9108e262a12c631675adf807564ffc Author: Henning Westerholt 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=c250b82234e5a124baf86b702b9352e002666fbd Author: Henning Westerholt 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=0438d14fbd82d7c617ed601563569ad536b5f80b Author: Henning Westerholt 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=e47829f3696ae1241342b685ba056166f7b0f899 Author: Henning Westerholt 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=78ac3c31b643e8b3f81708e1ab4bb6616bf00447 Author: Henning Westerholt 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=9397efc457e46933a44abf32fc2d9f6c7f507ee9 Author: Henning Westerholt 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=d0c43d2dda2c1a4f913ba4e1f60332f142e31cc4 Author: Henning Westerholt 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=665516ae4a6026ce8b89b7b29da27521210cbc3c Author: Henning Westerholt 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=f956d5cc2b05659bfb11caa59b62444008a29048 Author: Henning Westerholt 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=8961f724c4b2985ac7adbc827d48189e8107316c Author: Henning Westerholt 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=8ef74cb12467d2d57d26bdb26efa3a9e2304f3fc Author: Henning Westerholt 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=67686f35d8e2f9d5df7009edb1bfcf0e63ae402e Author: Henning Westerholt 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=e3d1c460e540343d753acc67012ca6943912cd70 Author: Henning Westerholt 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=d1fab40345dd60fb4dbb9c8cdb37e07789142189 Author: Henning Westerholt 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=1d62f7691ddf141d7d05d110a25bd1942215983f Author: Henning Westerholt 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=2aa8865791c2c337d0bb7e85842b3ba8b9ac37a5 Author: Henning Westerholt 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=dfed16e7a51420fafb370f14a51d4131ceea8128 Author: Henning Westerholt 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=1768a799a46194459c9be854697a57d7c8d388df Author: Henning Westerholt 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=56590fa21494b0e7736dd4ab9fd5832fb20b685e Author: Henning Westerholt 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=c48e0425a1574813638f389a84dfc72c9f5b9106 Author: Henning Westerholt 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=975b070c0411d3d77ac115cf3597d834404193c0 Author: Henning Westerholt 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=54f96fdd43398998669e23617153aadf968f1c6f Author: Henning Westerholt 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=71498e232d28d769ced323889947fcb2f9a4184d Author: Henning Westerholt 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=0200e6d42cbb19adb2e1283757fec646296c90a1 Author: Henning Westerholt 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=c52783fd1618969da33371024fd626f6f2833d93 Author: Henning Westerholt 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=0eece1d29618c2806576f12e7c48057020a7f20a Author: Henning Westerholt 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=94b24ee285b5eb63a30c2a3ee602baa973ca6502 Author: Henning Westerholt 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=cda1e991b2b355ff7ed35e060a34e0c821c9e59b Author: Henning Westerholt 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=516b44cc957487241bb679ac2ea6cfdf7f591799 Author: Henning Westerholt 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=4e8a664563f4ffefa880f91774fff3baedcfe844 Author: Bogdan-Andrei Iancu 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=130215ba4d627f7379463933aa24f94e781fb6ef Author: Bogdan-Andrei Iancu 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 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=bf01159fa70f937d36b4cbe0cb86b720c5720fa8 Author: Bogdan-Andrei Iancu 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 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=d957e6c6667cc2362be3ee9f679b51060bea3a47 Author: Daniel-Constantin Mierla 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=e180d9c35ebf45f4af62ac80a6bbc9202551fa6c Author: Bastian Friedrich 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=501d9d5de605d8f925067344be074c90d97bde7e Author: Bogdan-Andrei Iancu 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=f3076ee8ef101633eabae6e02366f8df862254ff Author: Daniel-Constantin Mierla 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=83510117450f0cb7e31aeaa92f6c5d75e8e1b8b9 Author: Daniel-Constantin Mierla 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=f0a8baec2395898da549f2c2400e95822e05c6c1 Author: Bogdan-Andrei Iancu 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=b5887fbfda33d7e4c85f00942f68cc6fdd3d2066 Author: Daniel-Constantin Mierla Date: Sun Jul 2 18:01:08 2006 +0000 - check the type of table_version result (reported by Ryan (Matty )) - 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=850c6f956ee53b84083351969b1534dce7232110 Author: Daniel-Constantin Mierla 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=dfcf771f1edc4a47f3f260af482b4d668cc7c05f Author: Bogdan-Andrei Iancu 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=61739866a3a1f635889e4209a62d494d715a1b31 Author: Daniel-Constantin Mierla 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=857b95ea5367d1982859cc68250735d61d56e857 Author: Daniel-Constantin Mierla 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=9405692ac3ec512bc2d9d83cde9b997002719bc2 Author: Bogdan-Andrei Iancu 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