<div dir="ltr"><div>Hi all,</div><div><br></div><div>I am having trouble converting hints entered in a static extensions.conf file into database entries. The
web results I found were either not answered or indicated it was simply
impossible to store hints in the realtime dialplan database. Has anyone been able to successfully put hints into a realtime database?</div><div><br></div><div>If so, the correct values for each column when trying to add a hint to the realtime extensions/dialplan database?</div><div><br></div><div>I have tried multiple different approaches but nothing is recognised by Asterisk. My table structure is below:</div><div><table class="gmail-m_-359591420107481230gmail-m_-2147268930961519878gmail-nowrap" cellspacing="0"><thead><tr><th>Column</th><td>Type</td><td>Comment</td></tr></thead>
<tbody><tr><th>id</th><td><span title="">int(11)</span> <i>Auto Increment</i></td><td>
<br></td></tr><tr class="gmail-m_-359591420107481230gmail-m_-2147268930961519878gmail-odd"><th>context</th><td><span title="latin1_swedish_ci">varchar(20)</span></td><td>
<br></td></tr><tr><th>exten</th><td><span title="latin1_swedish_ci">varchar(20)</span></td><td>
<br></td></tr><tr class="gmail-m_-359591420107481230gmail-m_-2147268930961519878gmail-odd"><th>priority</th><td><span title="">tinyint(4)</span></td><td>
<br></td></tr><tr><th>app</th><td><span title="latin1_swedish_ci">varchar(20)</span></td><td>
<br></td></tr><tr class="gmail-m_-359591420107481230gmail-m_-2147268930961519878gmail-odd"><th>appdata</th><td><span title="latin1_swedish_ci">varchar(128)</span> <i>NULL</i></td><td><br></td></tr></tbody></table></div><div><br></div><div>To
test that my configuration for connecting to the database is correct I
can populate the database with standard actions (answer, musiconhold,
voicemailmain etc) and those commands work properly.</div><div><br></div><div>In case it is relevant I am still using chan_sip for this project.<br></div><div><br></div><div>Kind regards</div><div>Stuart<br></div></div>