Creating CDR branch

git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6295 a612230a-c5fa-0310-af8b-88eea846685b
Fixing up externals

git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6297 a612230a-c5fa-0310-af8b-88eea846685b
Initialized merge tracking via svnmerge with revisions 1-6294 from
https://scm.sipfoundry.org/rep/sipX/main


git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6299 a612230a-c5fa-0310-af8b-88eea846685b
Adding schema for call state event and observer databases

git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6308 a612230a-c5fa-0310-af8b-88eea846685b
Check in the schema for the SIPXCDR database


git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6309 a612230a-c5fa-0310-af8b-88eea846685b
Changes to the CSE postgres schema as suggested by Walter

git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6310 a612230a-c5fa-0310-af8b-88eea846685b
Removing pg schema - no sense in keeping two copies of this around

git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6311 a612230a-c5fa-0310-af8b-88eea846685b
First check in of CSE database design specification

git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6312 a612230a-c5fa-0310-af8b-88eea846685b
First check in of general framework to build with and link up to 
unixODBC. The actual ODBC wrapper interface (OdbcWrapper.(h|cpp))
is essentially empty and still needs to be implemented.


git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6313 a612230a-c5fa-0310-af8b-88eea846685b
Fix a few misleading comments and erroneous paths

git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6314 a612230a-c5fa-0310-af8b-88eea846685b
Add odbc include dir to sipxcommserverlib.spec.in

git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6315 a612230a-c5fa-0310-af8b-88eea846685b
Added infrastructure to only build databse unit tests when a
configure switch --enable-dbtests is specified. This will keep
database unit tests from being run during the automated builds
on build machines where we have no control over Postgres.

Also added a bit more functionality to the OdbcWrapper layer.


git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6317 a612230a-c5fa-0310-af8b-88eea846685b
Merging in from main up to rev 6317

[XPB-530] Workaround.
  Change the default for the address in the Record-Route header
  inserted by the authproxy to explicitly use the ip address and port.
  This is only a change of how the value is constructed, not an actual
  change in the value.  In earlier revisions, the config.defs variable
  AUTH_PROXY_SERVER_SIP_SRV_OR_HOSTPORT was used, but its value was
  set to ${MY_IP_ADDR}:${AUTH_PROXY_SERVER_SIP_PORT}.  With the HA
  changes, an actual SRV name is used in config.defs.  Due to XPB-530,
  the forking proxy does not correctly route messages that use an SRV
  name in the Route header, so this checkin changes the authproxy to
  always use what it did before.

XCF-941 Pick different setting names for line and phone dial plans.  THIS WILL remove all dial-plan line settings, but they didn't work right to begin with

Add sample SOAP script from Perl

XCF-903 conditionally display additional column ("Primary registrar") on a Registrations page
It is only usable if you have HA configured: it displays the name of the registrar that initially handled registration.


git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6318 a612230a-c5fa-0310-af8b-88eea846685b
Added requirements of unixODBC and unixODBC-devl >= 2.2 to sipXcommserverLib .spec file

git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6320 a612230a-c5fa-0310-af8b-88eea846685b
Possible fix for semget problem in RegistryDBTest. Contrary to
comments in the code the database was never closed when calling
removeDatabase(). 

Added an extra function SIPDBManager::closeDatabase. Added a boolean
parameter to RegistrationDB::releaseInstance to close database,
defaulting to false for backward compatibility.

Set that parameter to true in cleanup code of RegistryDBTest. The
database will now be closed after every test, hopefully elimination
the semget errors.


git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6330 a612230a-c5fa-0310-af8b-88eea846685b
Merged in from Sipfoundry/main up to rev 6330

git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6332 a612230a-c5fa-0310-af8b-88eea846685b
Make table names plural to follow ActiveRecord conventions.
Define the function contact_host to return the host part of a SIP contact URL.


git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6333 a612230a-c5fa-0310-af8b-88eea846685b
Finish up wrapping ODBC function calls in our own database
layer, implement DSN-less database connections rather than
DSN based connections, eliminating the need for a global
odbc.ini configuration file.

Unit testing for ODBC layer almost completed.

Add two new OsSysLog facilities, FAC_ODBC and FAC_CDR to
better separate log messages.



git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6335 a612230a-c5fa-0310-af8b-88eea846685b
Merged in from Sipfoundry/main up to rev. 6334

git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6336 a612230a-c5fa-0310-af8b-88eea846685b
Merge the aors and contacts tables into a single "parties" table.  Simpler and easier to understand, inspired by the XML schema in call_detail_record.xsd.
Add the view "view_cdrs" that allows the user to get all the relevant CDR data in a single "select *" without having to do any joins.


git-svn-id: http://scm.sipfoundry.org/rep/sipX/branches/cdr@6337 a612230a-c5fa-0310-af8b-88eea846685b