https://onnocenter.or.id/wiki/index.php?action=history&feed=atom&title=OpenBTS%3A_Set_SQLite_Subscriber_setup_manual
OpenBTS: Set SQLite Subscriber setup manual - Revision history
2026-04-25T18:18:52Z
Revision history for this page on the wiki
MediaWiki 1.35.4
https://onnocenter.or.id/wiki/index.php?title=OpenBTS:_Set_SQLite_Subscriber_setup_manual&diff=47863&oldid=prev
Onnowpurbo at 03:20, 11 May 2017
2017-05-11T03:20:59Z
<p></p>
<table class="diff diff-contentalign-left diff-editfont-monospace" 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'>−</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"> </td></tr>
<tr><td class='diff-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"> </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;"></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;"></td></tr>
</table>
Onnowpurbo
https://onnocenter.or.id/wiki/index.php?title=OpenBTS:_Set_SQLite_Subscriber_setup_manual&diff=47862&oldid=prev
Onnowpurbo: Created page with "==Test Data== Cek IMSI dari TMSIS OpenBTS> tmsis IMSI TMSI IMEI AUTH CREATED ACCESSED TMSI_ASSIGNED 901550000000149 - 353907055098370 2 53s..."
2017-05-11T03:18:07Z
<p>Created page with "==Test Data== Cek IMSI dari TMSIS OpenBTS> tmsis IMSI TMSI IMEI AUTH CREATED ACCESSED TMSI_ASSIGNED 901550000000149 - 353907055098370 2 53s..."</p>
<p><b>New page</b></p><div>==Test Data==<br />
<br />
Cek IMSI dari TMSIS<br />
<br />
OpenBTS> 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><br />
<br />
Ketik<br />
<br />
INSERT INTO dialdata_table (exten, dial) VALUES ('2001', 'IMSI001010000000001');<br />
insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI001010000000001','IMSI001010000000001','2001','127.0.0.1','friend','phones','dynamic');<br />
<br />
INSERT INTO dialdata_table (exten, dial) VALUES ('2002', 'IMSI510105852803044');<br />
insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510105852803044','IMSI510105852803044','2002','127.0.0.1','friend','phones','dynamic');<br />
<br />
INSERT INTO dialdata_table (exten, dial) VALUES ('2012', 'IMSI901550000000148');<br />
insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI901550000000148','IMSI901550000000148','2012','127.0.0.1','friend','phones','dynamic');<br />
<br />
INSERT INTO dialdata_table (exten, dial) VALUES ('2032', 'IMSI510107013804199');<br />
insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510107013804199','IMSI510107013804199','2032','127.0.0.1','friend','phones','dynamic');<br />
<br />
INSERT INTO dialdata_table (exten, dial) VALUES ('2003', 'IMSI510103013910888');<br />
insert into sip_buddies (name,username,callerid,ipaddr,type,context,host) values ('IMSI510103013910888','IMSI510103013910888','2003','127.0.0.1','friend','phones','dynamic');</div>
Onnowpurbo