<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CGGONZA%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]--><style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1120228400;
mso-list-type:hybrid;
mso-list-template-ids:-1766294150 -504586854 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:%1-;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]-->
<p class="MsoNormal">I have been trying for weeks to integrate Oensips and
A2Billing, but I just get more confused on how to do this. If I have Opensips
and A2Billing on separate computers:</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span style="">1-<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;"> </span></span><!--[endif]-->I
have to create a mysql view on the A2Billing server right?</p>
<p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span style="">2-<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;"> </span></span><!--[endif]-->I
have to point Opensips database to the A2Billing database right?</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style=""><span style="font-family: "Courier New";">modparam("auth_db|permissions|uri_db|usrloc","db_url","mysql://a2billinguser:a2billing@192.168.1.104/mya2billing")<o:p></o:p></span></p>
<p class="MsoNormal"><span style=""> </span>192.168.1.104 is the
A2Billing server.</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This is the error I receive</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Feb<span style=""> </span>9 12:19:47
sipproxy /usr/local/sbin/opensips[20140]: ERROR:db_mysql:db_mysql_submit_query:
driver error on query: Table 'mya2billing.location' doesn't exist<o:p></o:p></p>
<p class="MsoNormal">Feb<span style=""> </span>9 12:19:47
sipproxy /usr/local/sbin/opensips[20140]: ERROR:core:db_do_query: error while
submitting query<o:p></o:p></p>
<p class="MsoNormal">Feb<span style=""> </span>9 12:19:47
sipproxy /usr/local/sbin/opensips[20140]: ERROR:usrloc:testdb_udomain: failure
in db_query<o:p></o:p></p>
<p class="MsoNormal">Feb<span style=""> </span>9 12:19:47
sipproxy /usr/local/sbin/opensips[20140]: ERROR:usrloc:register_udomain:
testing domain 'location' failed<o:p></o:p></p>
<p class="MsoNormal">Feb<span style=""> </span>9 12:19:47
sipproxy /usr/local/sbin/opensips[20140]: ERROR:registrar:domain_fixup: failed
to register domain<o:p></o:p></p>
<p class="MsoNormal">Feb<span style=""> </span>9 12:19:47
sipproxy /usr/local/sbin/opensips[20140]: ERROR:core:fix_actions: fixing failed
(code=-1) at cfg line 158<o:p></o:p></p>
<p class="MsoNormal">Feb<span style=""> </span>9 12:19:47
sipproxy /usr/local/sbin/opensips[20140]: ERROR:core:main: failed to fix
configuration with err code -1<o:p></o:p></p>
<p class="MsoNormal">s</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I know this is for somebody experienced, but always have to
be an start point. Any hint will be appreciated.</p>
<p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal"><o:p>Thanks,</o:p></p><p class="MsoNormal"><br><o:p></o:p></p><p class="MsoNormal"><o:p>Gonzalo<br></o:p></p>
<p class="MsoNormal"><span style=""> </span></p>
</td></tr></table><br>