<div dir="ltr">Hi Richard<div><br></div><div>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.</div><div><br></div><div>Pete</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 14 April 2016 at 13:51, Richard Robson <span dir="ltr"><<a href="mailto:rrobson@greenlightcrm.com" target="_blank">rrobson@greenlightcrm.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I'm trying to record ACCounting on a different database to the rest of<br>
opensips.<br>
<br>
Opensips is going to replace a gateway in asterisk which is currently<br>
recording CDRs to a MSSQL database. the Billing is generated from there.<br>
<br>
I'm happy that opensips uses MySQL locally, but would like the<br>
accounting to be recorded on the MSSSQL server remotely. Then the<br>
billing platform can consolidate the CDRs from the MSSQL database and<br>
bill our customers as on the current platform<br>
<br>
When I set ACC to use unixODBC i get an error as per below. It looks<br>
like it wants to find the Version table, but this is on the Mysql server<br>
and not the MSSQL server.<br>
<br>
Is what I'm trying to do possible or would I be better exporting billing<br>
information from the MySQL DB to MSSQL database outwith opensips?<br>
<br>
Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:<br>
ERROR:db_unixodbc:db_unixodbc_submit_query: rv=-1. Query= select<br>
table_version from version where table_name='acc'<br>
Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:<br>
ERROR:db_unixodbc:db_unixodbc_extract_error:<br>
unixodbc:SQLExecDirect=42S02:1:208:[FreeTDS][SQL Server]Invalid object<br>
name 'version'.<br>
Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:<br>
ERROR:core:db_do_query: error while submitting query - [select<br>
table_version from version where table_name='acc']<br>
Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:<br>
ERROR:core:db_table_version: error in db_query<br>
Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:<br>
ERROR:core:db_check_table_version: querying version for table acc<br>
Apr 14 12:44:51 gl-sip-01 /usr/sbin/opensips[26870]:<br>
ERROR:acc:acc_db_init: error during table version check<br>
<br>
Regards,<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Richard Robson<br>
Greenlight Support<br>
<a href="tel:01382%20843843" value="+441382843843">01382 843843</a><br>
<a href="mailto:support@greenlightcrm.com">support@greenlightcrm.com</a><br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</font></span></blockquote></div><br></div>