That's how it's done, people! FYI, Anthony added this today in these two commits:<br><a href="http://fisheye.freeswitch.org/changelog/freeswitch.git/?cs=081e261">http://fisheye.freeswitch.org/changelog/freeswitch.git/?cs=081e261</a><br>
<a href="http://fisheye.freeswitch.org/changelog/freeswitch.git/?cs=bce107b">http://fisheye.freeswitch.org/changelog/freeswitch.git/?cs=bce107b</a><br><br>You can also see the flow of the conversation between the person submitting the patch and the devs who had suggestions/information to make the process go more smoothly:<br>
<br><a href="http://jira.freeswitch.org/browse/FS-4883">http://jira.freeswitch.org/browse/FS-4883</a><br><br>*THAT* is why we need Jira for bugs/features/patches and not merely the mailing list.<br><br>Kudos to all who got this feature added!<br>
-MC<br><br><div class="gmail_quote">On Thu, Nov 29, 2012 at 1:28 AM, Antonio <span dir="ltr"><<a href="mailto:asilva@wirelessmundi.com" target="_blank">asilva@wirelessmundi.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div bgcolor="#ffffff">
Hi,<br>
<br>
Last night came up with this patch:<br>
<br>
<a href="http://jira.freeswitch.org/browse/FS-4883" target="_blank">http://jira.freeswitch.org/browse/FS-4883</a><br>
<br>
Is working in my fs, this way i can use REGEXP in my lua scripts :)<div><div class="h5"><br>
<br>
<br>
<br>
<br>
On Thu, 2012-11-29 at 01:19 -0500, S. Scott wrote: <br>
<blockquote type="CITE">
That's EXACTLY what I'm hunting for! My freeswitch build doesn't have a pcre.so anywhere on the disk. The .../freeswitch/libs/pcre/ exists with many files but no .so. <br>
<br>
<br>
What does one need to do to get the sqlite3 and the pcre.so rolled (from the git ingredients)? make() and stuff not my strong suit.<br>
<br>
Thanks,<br>
—————<br>
iThing: Big thumbs & little keys. Please excuse typo, spelling and grammar errors • Last night I played a blank CD at full blast. The Mime next door went nuts.<br>
<br>
<br>
<br>
On 2012-11-28, at 23:53, Antonio <<a href="mailto:asilva@wirelessmundi.com" target="_blank">asilva@wirelessmundi.com</a>> wrote:<br>
<br>
<br>
<br>
<blockquote type="CITE">
Hi,<br>
<br>
Coudn't we load just an external extension to sqlite?<br>
<br>
for example, to have regular expression support you could load an external library like "<tt>sqlite3-pcre</tt>" (available for unbuntu), you can load from the console interface or directly in sql.<br>
<br>
console:<br>
sqlite> .load '/usr/lib/sqlite3/pcre.so<br>
<br>
sql in console:<br>
sqlite> select load_extension(''/usr/lib/sqlite3/pcre.so'); <br>
<br>
<br>
In fs is not possible, when i try to do it from my lua script i have the following error:<br>
<br>
2012-11-28 17:21:34.196304 [ERR] switch_core_sqldb.c:572 NATIVE SQL ERR [no such function: load_extension]<br>
select load_extension('/usr/lib/sqlite3/pcre.so');<br>
<br>
<br>
Since you have already a switch type of db ( core, odbc or pgsql) could be nice when using core, be able to use a few more functions available in sqlite?<br>
<br>
<br>
Thanks,<br>
António<br>
<br>
<br>
<br>
<br>
<br>
<br>
On Fri, 2012-11-02 at 18:03 -0500, Ken Rice wrote:<br>
<blockquote type="CITE">
No and this wont happen anytime soon... The SQL interfaces for FreeSwitch are kept generic as we support more then just sqlite from common code and if we did it for sqlite we would have to make sure its implemented equally well for postgresql and mysql and mssql and any other database someone might want to use via ODBC<br>
<br>
K<br>
<br>
<br>
On 11/2/12 3:34 PM, "Scott" <<a href="http://8f27e956@gmail.com" target="_blank">8f27e956@gmail.com</a>> wrote:<br>
<br>
<blockquote>
"LIKE" notwithstanding, sqlite3 does not have a built-in true regex function; it does allow for a a c-language hook to one. Given fs extensive use of the regex engine and of sqlite3, we're wondering if the hook is already written and rolled. If so, can the rest of us hook it to our sqlite3 uses (e.g. from dial plan lua sqlite3).<br>
<br>
With thanks,<br>
<br>
<br>
<hr size="3">
<br>
<br>
<br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="http://consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="http://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>
</blockquote>
<br>
-- <br>
Ken<br>
<u><font color="#0000ff"><a href="http://www.FreeSWITCH.org" target="_blank">http://www.FreeSWITCH.org</a></font></u><br>
<u><font color="#0000ff"><a href="http://www.ClueCon.com" target="_blank">http://www.ClueCon.com</a></font></u><br>
<u><font color="#0000ff"><a href="http://www.OSTAG.org" target="_blank">http://www.OSTAG.org</a></font></u><br>
<a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch
<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>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a>
Official FreeSWITCH Sites
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.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>
<table cellpadding="0" cellspacing="0" width="100%">
<tbody><tr>
<td>
<pre>--
Un cordial saludo / Best regards,
_________________________
António Silva
E-mail:<a href="mailto:asilva@wirelessmundi.com" target="_blank">asilva@wirelessmundi.com</a>
</pre>
</td>
</tr>
</tbody></table>
_________________________________________________________________________<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" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" 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" 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>
</blockquote>
<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>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a>
Official FreeSWITCH Sites
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.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>
<table cellpadding="0" cellspacing="0" width="100%">
<tbody><tr>
<td>
<pre>--
Un cordial saludo / Best regards,
_________________________
António Silva
E-mail:<a href="mailto:asilva@wirelessmundi.com" target="_blank">asilva@wirelessmundi.com</a>
</pre>
</td>
</tr>
</tbody></table>
</div></div></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">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></blockquote></div><br><br clear="all"><br>-- <br>Michael S Collins<br>Twitter: @mercutioviz<br><a href="http://www.FreeSWITCH.org" target="_blank">http://www.FreeSWITCH.org</a><br><a href="http://www.ClueCon.com" target="_blank">http://www.ClueCon.com</a><br>
<a href="http://www.OSTAG.org" target="_blank">http://www.OSTAG.org</a><br><br><br>