[OpenSIPS-Users] Different Database for accounting

[Pete Kelly]

Hi Richard

I think you will also need to create the version table on the MSSQL server.
It will probably only need 1 row for 'acc' with the correct version entered.

Pete

On 14 April 2016 at 13:51, Richard Robson <rrobson at greenlightcrm.com> wrote:

> 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
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160420/4e682c75/attachment.htm>