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 <[email protected]> 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 > [email protected] > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
