[OpenSIPS-Users] Different Database for accounting

Richard Robson rrobson at greenlightcrm.com
Thu Apr 14 13:51:23 CEST 2016


I'm trying to record ACCounting on a different database to the rest of
opensips.

Opensips is going to replace a gateway in asterisk which is currently
recording CDRs to a MSSQL database. the Billing is generated from there.

I'm happy that opensips uses MySQL locally, but would like the
accounting to be recorded on the MSSSQL server remotely.  Then the
billing platform can consolidate the CDRs from the MSSQL database and
bill our customers as on the current platform

When I set ACC to use unixODBC i get an error as per below. It looks
like it wants to find the Version table, but this is on the Mysql server
and not the MSSQL server.

Is what I'm trying to do possible or would I be better exporting billing
information from the MySQL DB to MSSQL database outwith opensips?

Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:
ERROR:db_unixodbc:db_unixodbc_submit_query: rv=-1. Query= select
table_version from version where table_name='acc'
Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:
ERROR:db_unixodbc:db_unixodbc_extract_error:
unixodbc:SQLExecDirect=42S02:1:208:[FreeTDS][SQL Server]Invalid object
name 'version'.
Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:
ERROR:core:db_do_query: error while submitting query - [select
table_version from version where table_name='acc']
Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:
ERROR:core:db_table_version: error in db_query
Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:
ERROR:core:db_check_table_version: querying version for table acc
Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:
ERROR:acc:acc_db_init: error during table version check

Regards,

-- 
Richard Robson
Greenlight Support
01382 843843
support at greenlightcrm.com




More information about the Users mailing list