<div dir="ltr">It's been years since I have used real time but can it be because of the GoSub?<div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Oct 16, 2017 at 12:39 PM, John Kiniston <span dir="ltr"><<a href="mailto:johnkiniston@gmail.com" target="_blank">johnkiniston@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"><div>I'm toying with the idea of replacing a statically generated file I include in my extensions.conf with a realtime lookup against my database.<br><br>I've got it working but something seems off in my logs, It looks like I'm getting two lookups for every priority?<br><br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_odbc.c: Reusing ODBC handle 0x7f8da8002938 from class 'odbc_kiniston-test'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Skip: 0; SQL: SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND context = ?<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 1 ('exten') = '<a href="tel:(520)%20670-0792" value="+15206700792" target="_blank">5206700792</a>'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 2 ('priority') = '5'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 3 ('context') = 'sip-in'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_odbc.c: Releasing ODBC handle 0x7f8da8002938 into pool<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_odbc.c: Reusing ODBC handle 0x7f8da8002938 from class 'odbc_kiniston-test'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Skip: 0; SQL: SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND context = ?<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 1 ('exten') = '<a href="tel:(520)%20670-0792" value="+15206700792" target="_blank">5206700792</a>'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 2 ('priority') = '5'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 3 ('context') = 'sip-in'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_odbc.c: Releasing ODBC handle 0x7f8da8002938 into pool<br>[Oct 12 16:45:24] VERBOSE[26541][C-0000000e] pbx_realtime.c: Executing <a href="tel:(520)%20670-0792" value="+15206700792" target="_blank">[5206700792</a>@sip-in:5] Gosub("PJSIP/trunks1-0000000e"<wbr>, "sub-setupinboundcall,s,1(<wbr>kiniston,Pop_Country_<wbr>Crossover,300,VOIP)")<br><br>---SNIP---<br><br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_odbc.c: Reusing ODBC handle 0x7f8da8002938 from class 'odbc_kiniston-test'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Skip: 0; SQL: SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND context = ?<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 1 ('exten') = '<a href="tel:(520)%20670-0792" value="+15206700792" target="_blank">5206700792</a>'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 2 ('priority') = '6'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 3 ('context') = 'sip-in'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_odbc.c: Releasing ODBC handle 0x7f8da8002938 into pool<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_odbc.c: Reusing ODBC handle 0x7f8da8002938 from class 'odbc_kiniston-test'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Skip: 0; SQL: SELECT * FROM extensions-test WHERE exten = ? AND priority = ? AND context = ?<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 1 ('exten') = '<a href="tel:(520)%20670-0792" value="+15206700792" target="_blank">5206700792</a>'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 2 ('priority') = '6'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_config_odbc.c: Parameter 3 ('context') = 'sip-in'<br>[Oct 12 16:45:24] DEBUG[26541][C-0000000e] res_odbc.c: Releasing ODBC handle 0x7f8da8002938 into pool<br>[Oct 12 16:45:24] VERBOSE[26541][C-0000000e] pbx_realtime.c: Executing <a href="tel:(520)%20670-0792" value="+15206700792" target="_blank">[5206700792</a>@sip-in:6] Goto("PJSIP/trunk1-0000000e", "kiniston-ivr,s,1")<br>[Oct 12 16:45:24] VERBOSE[26541][C-0000000e] pbx_builtins.c: Goto (kiniston-ivr,s,1)<br><br><br><br>The contents of my table are just<br>id context exten priority app appdata<br>7301702413361087843 sip-in <a href="tel:(520)%20670-0792" value="+15206700792" target="_blank">5206700792</a> 5 Gosub sub-setupinboundcall,s,1(<wbr>kiniston,Pop_Country_<wbr>Crossover,300,VOIP)<br>7301702413361087848 sip-in <a href="tel:(520)%20670-0792" value="+15206700792" target="_blank">5206700792</a> 6 Goto kiniston-ivr,s,1<br><br>My extensions.conf<br>[sip-in]<br>exten => _X.,1,Log(NOTICE,Incoming ${CHANNEL:0:3} call DID: ${EXTEN} from CallerID: ${CALLERID(num)} ${CALLERID(name)}, ANI:${CALLERID(ani)} ANI2:${CALLINGANI2})<br>exten => _X.,2,Set(ARRAY(CDR(firstext),<wbr>CDR(firstcontext))=${EXTEN},${<wbr>CONTEXT})<br>exten => _X.,3,Set(ARRAY(__FirstEXT,__<wbr>FirstContext)=${EXTEN},${<wbr>CONTEXT})<br>exten => _X.,4,Set(CHANNEL(hangup_<wbr>handler_push)=cdr-fixup,s,1)<br>exten => _X.,7,Hangup()<br>switch => Realtime/sip-in@extensions/p<br clear="all"><br><br></div>Has anyone else noticed this behavior? Is it expected? I dont' see any mentions of it in any the docs. <br><span class="HOEnZb"><font color="#888888"><br><div>-- <br><div class="m_-50898154401884019gmail_signature">A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialization is for insects.<br>---Heinlein</div>
</div></font></span></div>
<br>--<br>
______________________________<wbr>______________________________<wbr>_________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.<wbr>org/</a><br>
<br>
New to Asterisk? Start here:<br>
<a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</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" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br></blockquote></div><br></div>