<div dir="ltr">It did automatically create all tables :)</div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Oct 16, 2015 at 9:10 AM, Michael Nielsen <span dir="ltr"><<a href="mailto:mic.niel84@gmail.com" target="_blank">mic.niel84@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 dir="ltr">Hi Sergey,<div><br></div><div>Will FS automatically create tables etc in the postgresql or is there a script for this?</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Oct 15, 2015 at 7:58 PM, Sergey Safarov <span dir="ltr"><<a href="mailto:s.safarov@gmail.com" target="_blank">s.safarov@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 dir="ltr">Try store registration data in postgresql database shared between two or more FS servers.<div><a href="https://freeswitch.org/confluence/display/FREESWITCH/PostgreSQL+in+the+core" target="_blank">https://freeswitch.org/confluence/display/FREESWITCH/PostgreSQL+in+the+core</a><br></div><div><br></div><div>In my production environment is used Kazoo solution. This solution is designed for load balancing.<br></div><div><br></div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Oct 15, 2015 at 8:27 PM, Tanguy <span dir="ltr"><<a href="mailto:phenix@vfemail.net" target="_blank">phenix@vfemail.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hello Michael<br>
<br>
I'm still a freeswitch newbie but i have to deal with a similar
issue ( not yet implemented ) I believe that the proper solution
is using a sip proxy like opensips but it seems difficult to
implement.<br>
<br>
My idea is to detect if a particular extension is registered
locally and try to transmit the call to the second server if the
extensions is not registered<br>
<br>
I added something like this in the beginning of my domain dialplan
on freeswitch1<br>
<br>
<tt><extension name="user_registered" continue="true"></tt><tt><br>
</tt><tt> <condition ></tt><tt><br>
</tt><tt> <action application="set"
data="user_registered=${sofia_contact
${destination_number}@${domain_name}}" inline="true"/></tt><tt><br>
</tt><tt> <action application="set"
data="user_exists=${user_exists id ${destination_number}
${domain_name}}" inline="true"/></tt><tt><br>
</tt><tt><br>
</tt><tt> </condition></tt><tt><br>
</tt><tt> <condition field="${user_exists}"
expression="^true$" /></tt><tt><br>
</tt><tt> <condition field="${user_registered}"
expression="^error/user_not_registered$" ></tt><tt><br>
</tt><tt> <action application="bridge"
data="{sip_invite_to_uri=<sip:${destination_number}@${domain_name}>}sofia/internal/${<a href="mailto:destination_number%7D@freeswitch2.company.com" target="_blank">destination_number}@freeswitch2.company.com</a>"
/></tt><tt><br>
</tt><tt><br>
</tt><tt> </tt><tt><br>
</tt><tt> </condition></tt><tt><br>
</tt><tt></extension></tt><br>
<br>
<br>
I added this the public dialplan on freeswitch2<br>
<br>
<include><br>
<extension name="ha_transfert" continue="false"><br>
<condition field="${sip_h_X-CallType}"
expression="^ha_transfert$" ><br>
<action application="set"
data="call_direction=inbound"/><br>
<br>
<action application="set"
data="domain_name=${sip_to_host}"/><br>
<action application="set"
data="domain=${sip_to_host}"/><br>
<br>
<action application="transfer"
data="${sip_to_user} XML ${sip_to_host}" /><br>
<br>
</condition><br>
<br>
</extension><br>
</include><br>
<br>
<br>
Please note that my sample dialplan on freeswitch2 is not secure (
hopefully not yet in production and a restrictive firewall ), you
may interested by a topic between me and a freeswitch power user (
not like me :-) )<br>
<br>
<a href="http://lists.freeswitch.org/pipermail/freeswitch-users/2015-September/115900.html" target="_blank">http://lists.freeswitch.org/pipermail/freeswitch-users/2015-September/115900.html</a><br>
<br>
Please look the Sergey advice about dialplan security, i hope i
will have the time to implement theses advises in a near future.<br>
<a href="http://lists.freeswitch.org/pipermail/freeswitch-users/2015-September/115978.html" target="_blank">http://lists.freeswitch.org/pipermail/freeswitch-users/2015-September/115978.html</a><br>
<br>
<br>
<br>
~ <br><div><div>
<br>
<br>
<br>
<br>
<br>
On 15/10/2015 08:56, Michael Nielsen wrote:<br>
</div></div></div>
<blockquote type="cite"><div><div>
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>Hello everyone,<br>
<br>
</div>
I've got a FreeSWITCH installation and made my directory
dynamically generated via LUA from a PostgreSQL
database.<br>
</div>
<div>CDR's are also saved to a PostgreSQL.<br>
</div>
<div><br>
</div>
This makes my FreeSWITCH installation somewhat stateless I
guess?<br>
<br>
</div>
I would like to setup another FreeSWITCH and then having my
domain "load-balance" via DNS between those two.<br>
<br>
</div>
The DNS part I do know how to do.<br>
<br>
</div>
Should I do more to my FreeSWITCH's for this to work? Or is this
enough for everything, and can would they know if one subscriber
is connected to one FS and another to the other FS etc.?<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a>
Official FreeSWITCH Sites
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a></pre>
</blockquote>
<br>
</div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" rel="noreferrer" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" rel="noreferrer" target="_blank">http://www.cluecon.com</a><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" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br></blockquote></div><br></div>
</div></div><br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" rel="noreferrer" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" rel="noreferrer" target="_blank">http://www.cluecon.com</a><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" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>