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 supp...@greenlightcrm.com _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users