You have to create yourself the odbc commands using func_odbc.conf file, like:<div><br></div><div>[GET_HUNTLIST_TYPE]</div><div>dsn=asterisk1,asterisk2</div><div>synopsis=Get the Hunt List type</div><div>readsql=SELECT hu_type,hu_ringtime from hu_huntlists where hu_id='${ARG1}'</div>
<div><br></div><div><br></div><div>then you cna use it in your dialplan (I use AEL):</div><div><br></div><div>Set(ARRAY(TYPE,DIALTIMEOUT)=${ODBC_GET_HUNTLIST_TYPE(${ID})});</div><div><br></div><div>Leandro <br><br><div class="gmail_quote">
2012/5/5 Jonas Kellens <span dir="ltr"><<a href="mailto:jonas.kellens@telenet.be" target="_blank">jonas.kellens@telenet.be</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div text="#000000" bgcolor="#ffffff">
<font face="Helvetica, Arial, sans-serif">Will ODBC become the
default then ?<br>
<br>
I see no ODBC-command to use in the dialplan.<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
Jonas.<br>
<br>
</font></span></font><div><div class="h5"><br>
On 05/05/2012 11:12 AM, Leandro Dardini wrote:
<blockquote type="cite">Use ODBC. Check the func_odbc.conf configuration file.
<div><br>
</div>
<div>Leandro<br>
<br>
<div class="gmail_quote">2012/5/5 Jonas Kellens <span dir="ltr"><<a href="mailto:jonas.kellens@telenet.be" target="_blank">jonas.kellens@telenet.be</a>></span><br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div text="#000000" bgcolor="#ffffff"> <font face="Helvetica, Arial, sans-serif">Hello,<br>
<br>
I notice when upgrading from 1.6.2 to 1.8 that in the
menuselect "app_mysql" is indicated as "deprecated".<br>
<br>
If one wants to use the MySQL-command in the dialplan,
how to do so if app_mysql is deprecated ??<br>
<br>
<br>
<br>
Kind regards,<br>
Jonas.<br>
</font> </div>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar
every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</blockquote>
</div>
<br>
</div>
<pre><fieldset></fieldset>
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --
New to Asterisk? Join us for a live introductory webinar every Thurs:
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a>
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a></pre>
</blockquote>
</div></div></div>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>