https://lms.onnocenter.or.id/wiki/index.php?action=history&feed=atom&title=OpenBTS%3A_Set_SQLite_Subscriber_setup_manual 2026-04-20T08:42:18Z Revision history for this page on the wiki MediaWiki 1.45.1 https://lms.onnocenter.or.id/wiki/index.php?title=OpenBTS:_Set_SQLite_Subscriber_setup_manual&diff=47863&oldid=prev 2017-05-11T03:20:59Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 03:20, 11 May 2017</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">==Test Data==</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Cek IMSI dari TMSIS</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Cek IMSI dari TMSIS</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> </table>

Onnowpurbo https://lms.onnocenter.or.id/wiki/index.php?title=OpenBTS:_Set_SQLite_Subscriber_setup_manual&diff=47862&oldid=prev 2017-05-11T03:18:07Z

<p>Created page with &quot;==Test Data== Cek IMSI dari TMSIS OpenBTS&gt; tmsis IMSI TMSI IMEI AUTH CREATED ACCESSED TMSI_ASSIGNED 901550000000149 - 353907055098370 2 53s...&quot;</p> <p><b>New page</b></p><div>==Test Data==<br /> <br /> Cek IMSI dari TMSIS<br /> <br /> OpenBTS&gt; tmsis<br /> IMSI TMSI IMEI AUTH CREATED ACCESSED TMSI_ASSIGNED <br /> 901550000000149 - 353907055098370 2 53s 53s 0 <br /> <br /> Lakukan<br /> <br /> sudo su<br /> sqlite3 /var/lib/asterisk/sqlite3dir/sqlite3.db<br /> <br /> Pada prompt<br /> <br /> sqlite&gt;<br /> <br /> Ketik<br /> <br /> INSERT INTO dialdata_table (exten, dial) VALUES (&#039;2001&#039;, &#039;IMSI001010000000001&#039;);<br /> insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values (&#039;IMSI001010000000001&#039;,&#039;IMSI001010000000001&#039;,&#039;2001&#039;,&#039;127.0.0.1&#039;,&#039;friend&#039;,&#039;phones&#039;,&#039;dynamic&#039;);<br /> <br /> INSERT INTO dialdata_table (exten, dial) VALUES (&#039;2002&#039;, &#039;IMSI510105852803044&#039;);<br /> insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values (&#039;IMSI510105852803044&#039;,&#039;IMSI510105852803044&#039;,&#039;2002&#039;,&#039;127.0.0.1&#039;,&#039;friend&#039;,&#039;phones&#039;,&#039;dynamic&#039;);<br /> <br /> INSERT INTO dialdata_table (exten, dial) VALUES (&#039;2012&#039;, &#039;IMSI901550000000148&#039;);<br /> insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values (&#039;IMSI901550000000148&#039;,&#039;IMSI901550000000148&#039;,&#039;2012&#039;,&#039;127.0.0.1&#039;,&#039;friend&#039;,&#039;phones&#039;,&#039;dynamic&#039;);<br /> <br /> INSERT INTO dialdata_table (exten, dial) VALUES (&#039;2032&#039;, &#039;IMSI510107013804199&#039;);<br /> insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values (&#039;IMSI510107013804199&#039;,&#039;IMSI510107013804199&#039;,&#039;2032&#039;,&#039;127.0.0.1&#039;,&#039;friend&#039;,&#039;phones&#039;,&#039;dynamic&#039;);<br /> <br /> INSERT INTO dialdata_table (exten, dial) VALUES (&#039;2003&#039;, &#039;IMSI510103013910888&#039;);<br /> insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values (&#039;IMSI510103013910888&#039;,&#039;IMSI510103013910888&#039;,&#039;2003&#039;,&#039;127.0.0.1&#039;,&#039;friend&#039;,&#039;phones&#039;,&#039;dynamic&#039;);</div>

Onnowpurbo