For the benefit of anyone who may run into this in the future. I resolved the issue by providing each sip_profile it's own database schema. This does not seem like the best solution but it works.<div><br></div><div>Thanks for the feedback!</div>
<div><br></div><div>Ryan</div><div><br></div><div><div><br><div class="gmail_quote">On Wed, Oct 5, 2011 at 11:54 AM, R H <span dir="ltr"><<a href="mailto:buscom123%2Bfs@gmail.com">buscom123+fs@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">
<p>Hey Anthony, I appreciate your help on this. Your response was not clear enough for me to understand how to accomplish what you are describing. Let's assume I only have 2 profiles (Internal/External). Both profiles default to the public context.</p>
<p>Now if I were to create two domains in the directory and name them "<a href="http://internal.mydomain.com/" target="_blank"><span>internal.mydomain.com</span></a>" and "<a href="http://external.mydomain.com/" target="_blank"><span>external.mydomain.com</span></a>" and force everyone who registers to the internal profile to use the internal domain and everyone on the external profile to use the external domain I would still get the same problem. </p>
<p>If I have two clients register on the external profile using the external domain and they call each other, with ODBC disabled everything works fine, but with ODBC enabled I get two invites to the destination client.</p>
<p>The fact that I get different behavior with odbc enabled / disabled seems to indicate a bug more than it indicates a mis-configuration. </p>
<p>Perhaps I am missing something? I don't quite understand the section in the example xml that refers to domains. Is there something I need to do there? The wiki does not mention it at all and the comments in the xml are not very clear either:</p>
<p><span style="font-family:arial, sans-serif;font-size:13px;background-color:rgb(255, 255, 255)"><domains><br> <!-- indicator to parse the directory for domains with parse="true" to get gateways--><br>
<!--<domain name="$${domain}" parse="true"/>--><br> <!-- indicator to parse the directory for domains with parse="true" to get gateways and alias every domain to this profile --><br>
<!--<domain name="all" alias="true" parse="true"/>--><br> <domain name="all" alias="false" parse="true"/><br> </domains></span></p>
<p>Thanks for your help,</p>
<p>Ryan</p><br></div><div><div></div><div class="h5"><div class="gmail_quote">On Tue, Oct 4, 2011 at 10:27 AM, Anthony Minessale <span dir="ltr"><<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">ok but the db is shared so if they are all using <a href="http://mydomain.com" target="_blank">mydomain.com</a> it will<br>
cross over so you should use distinct fake domains at least between<br>
your profiles.<br>
<div><div></div><div><br>
<br>
On Tue, Oct 4, 2011 at 11:24 AM, R H <<a href="mailto:buscom123%2Bfs@gmail.com" target="_blank">buscom123+fs@gmail.com</a>> wrote:<br>
> In Response to Brian West, below are my sip registrations. These may have<br>
> slightly different values from the logs I sent yesterday simply because I<br>
> shut down last night and re-registered this morning. Same softphones, same<br>
> extensions, just new registrations:<br>
> -----------------------------------------------------------------------------<br>
> select * from sip_registrations;<br>
> MTAwYWEwYzhlNzc2MDAxYTUzNDhlY2EwZmEyZDFlZDE.,4001,<a href="http://mydomain.com" target="_blank">mydomain.com</a>,<a href="http://mydomain.com" target="_blank">mydomain.com</a>,"""user""<br>
> <sip:4001@192.168.99.164:61238;rinstance=e2d50bbe31452d30>",Registered(UDP),unknown,1317746818,X-Lite<br>
> 4 release 4.1 stamp<br>
> 63215,4001,192.168.122.236,internal,psiFreeswitch,192.168.99.164,61238,4001,<a href="http://mydomain.com" target="_blank">mydomain.com</a>,4001,<a href="http://mydomain.com" target="_blank">mydomain.com</a>,192.168.122.236,psiFreeswitch<br>
> dQJifXuoqNBUlWCuZ8rCI6cu.Nn5F81W,4002,<a href="http://mydomain.com" target="_blank">mydomain.com</a>,<a href="http://mydomain.com" target="_blank">mydomain.com</a>,"""Test<br>
> User123""<br>
> <<a href="http://sip:cqgulpey@192.168.99.164:57003" target="_blank">sip:cqgulpey@192.168.99.164:57003</a>>",Registered(UDP),unknown,1317743825,Blink<br>
> Lite 1.2.0<br>
> (MacOSX),4002,192.168.122.236,internal,psiFreeswitch,192.168.99.164,57003,4002,<a href="http://mydomain.com" target="_blank">mydomain.com</a>,4002,<a href="http://mydomain.com" target="_blank">mydomain.com</a>,192.168.122.236,psiFreeswitch<br>
> -----------------------------------------------------------------------------<br>
> In Response to Anthony Minessale,<br>
> "Mydomain.com" is simply for testing and will not be our go-live domain. The<br>
> particular switch I am testing on is located in a closed internal network<br>
> designed specifically for testing systems like this and nothing more. It is<br>
> set up using the instructions on the FreeSwitch wiki for Multi-Tenant<br>
> installations because we have the potential to go multi-tenant in the future<br>
> and we want to make sure multi-tenant setups work for the system we are<br>
> building.<br>
> As far as my profiles in development i have the following setup:<br>
> 1) Internal - To emulate production this is limited use, no real phones will<br>
> ever connect from the local LAN in production. We have been testing<br>
> registrations on this profile anyway but not there is no plan to have phones<br>
> register here in production:<br>
> <domain name="all" alias="false" parse="false"/><br>
><br>
><br>
> 2) External - Most phones will register here, possibly to multiple domains<br>
> (tenants). These devices will be on other networks with possible natting<br>
> issues. This profile requires authentication to make calls.<br>
> 3) External_Debug - When clients complain of connectivity issues we will be<br>
> asking them to move to this profile so that we can more easily monitor their<br>
> sip traffic and debug their issues. This profile will also require<br>
> authentication and allow registration to the many domains.<br>
> 4) Unnamed Future External Profile - We will also most likely have another<br>
> profile for our upstream providers once we are ready to turn them on.<br>
><br>
><br>
><br>
><br>
><br>
> On Mon, Oct 3, 2011 at 5:59 PM, Anthony Minessale<br>
> <<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>> wrote:<br>
>><br>
>> are you really using "<a href="http://mydomain.com" target="_blank">mydomain.com</a>" on all the profiles at the same time?<br>
>><br>
>> On Mon, Oct 3, 2011 at 5:29 PM, R H <<a href="mailto:buscom123%2Bfs@gmail.com" target="_blank">buscom123+fs@gmail.com</a>> wrote:<br>
>> > Sure,<br>
>> > I have two soft phones registering as extensions 4001 and 4002 to the<br>
>> > same<br>
>> > profile. When 4002 dials 4001 the softphone that is registered as 4001<br>
>> > received two calls simultaneously. This only happens when I enable odbc<br>
>> > on<br>
>> > two profiles. If I disable odbc or only enable it for one profile<br>
>> > everything<br>
>> > works fine. If I enable ODBC for 3 profiles I would get three invites to<br>
>> > 4001, etc...<br>
>> > Attached is some logging output. Notice the parts highlighted in red.<br>
>> > Thank you for your help.<br>
>> > Ryan<br>
>> ><br>
>> ><br>
>> ><br>
>> > On Mon, Oct 3, 2011 at 1:23 PM, Anthony Minessale<br>
>> > <<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>> wrote:<br>
>> >><br>
>> >> could you elaborate more on what the B-legs are?<br>
>> >> Are you doing bridges to an outbound entity, if so how?<br>
>> >><br>
>> >> do you have any traces doing:<br>
>> >><br>
>> >> sofia global siptrace on<br>
>> >> and<br>
>> >> console loglevel debug<br>
>> >><br>
>> >><br>
>> >><br>
>> >><br>
>> >><br>
>> >> On Mon, Oct 3, 2011 at 2:14 PM, R H <<a href="mailto:buscom123%2Bfs@gmail.com" target="_blank">buscom123+fs@gmail.com</a>> wrote:<br>
>> >> > Hey Everyone,<br>
>> >> > I am preparing to set up HA Failover to my production freeswitch<br>
>> >> > environment. In preparation for this I have been doing some testing<br>
>> >> > in a<br>
>> >> > development environment and I encountered the following problem:<br>
>> >> > I currently have two sip-profiles set up that I am using full time,<br>
>> >> > when<br>
>> >> > I<br>
>> >> > enable odbc in the switch.conf.xml everything works correctly. When I<br>
>> >> > enable<br>
>> >> > odbc in ONE of the sip-profiles everything works correctly. But when<br>
>> >> > I<br>
>> >> > enable odbc in the second profile I begin to see two b-legs for ever<br>
>> >> > call<br>
>> >> > that I initiate. Both b-legs are directed at the same client.<br>
>> >> > Does anyone have any idea why enabling odbc on two sofia profiles<br>
>> >> > would<br>
>> >> > cause every inbound call to generate two outbound calls? I also<br>
>> >> > decided<br>
>> >> > to<br>
>> >> > test this problem by adding two more profiles for a total of 4. With<br>
>> >> > 4<br>
>> >> > profiles I get 4 b-legs. What am I doing wrong?<br>
>> >> > Ryan<br>
>> >> ><br>
>> >> > FreeSWITCH-users mailing list<br>
>> >> > <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> >> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> >> ><br>
>> >> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> >> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> >> ><br>
>> >> ><br>
>> >><br>
>> >><br>
>> >><br>
>> >> --<br>
>> >> Anthony Minessale II<br>
>> >><br>
>> >> FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
>> >> ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
>> >> Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
>> >><br>
>> >> AIM: anthm<br>
>> >> <a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>
>> >> GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">PAYPAL:anthony.minessale@gmail.com</a><br>
>> >> IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
>> >><br>
>> >> FreeSWITCH Developer Conference<br>
>> >> <a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">sip:888@conference.freeswitch.org</a><br>
>> >> <a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>
>> >> pstn:<a href="tel:%2B19193869900" value="+19193869900" target="_blank">+19193869900</a><br>
>> >><br>
>> >><br>
>> >> FreeSWITCH-users mailing list<br>
>> >> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> >> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> >><br>
>> >> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> >> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> ><br>
>> ><br>
>> ><br>
>> > FreeSWITCH-users mailing list<br>
>> > <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> ><br>
>> ><br>
>><br>
>><br>
>><br>
>> --<br>
>> Anthony Minessale II<br>
>><br>
>> FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
>> ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
>> Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
>><br>
>> AIM: anthm<br>
>> <a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>
>> GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">PAYPAL:anthony.minessale@gmail.com</a><br>
>> IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
>><br>
>> FreeSWITCH Developer Conference<br>
>> <a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">sip:888@conference.freeswitch.org</a><br>
>> <a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>
>> pstn:<a href="tel:%2B19193869900" value="+19193869900" target="_blank">+19193869900</a><br>
>><br>
>><br>
>> FreeSWITCH-users mailing list<br>
>> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
><br>
> FreeSWITCH-users mailing list<br>
> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
<br>
<br>
<br>
--<br>
Anthony Minessale II<br>
<br>
FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
<br>
AIM: anthm<br>
<a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
<br>
FreeSWITCH Developer Conference<br>
<a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">sip:888@conference.freeswitch.org</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:<a href="tel:%2B19193869900" value="+19193869900" target="_blank">+19193869900</a><br>
<br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br></div></div>