OpenBTS: Set SQLite Subscriber Registry secara manual: Difference between revisions
From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs) No edit summary |
Onnowpurbo (talk | contribs) No edit summary |
||
| Line 2: | Line 2: | ||
sqlite3 /var/lib/asterisk/sqlite3dir/sqlite3.db | sqlite3 /var/lib/asterisk/sqlite3dir/sqlite3.db | ||
akan keluar | |||
sqlite> | |||
Cek database | |||
.databases | |||
seq name file | |||
--- --------------- ---------------------------------------------------------- | |||
0 main /var/lib/asterisk/sqlite3dir/sqlite3.db | |||
1 temp | |||
Cek table | |||
.tables | |||
DIALDATA_TABLE RRLP SIP_BUDDIES rates | |||
Cek isi table DIALDATA_TABLE | |||
select * from DIALDATA_TABLE; | |||
1|2100|IMSI001010000000000 | |||
2|2001|IMSI001010000000001 | |||
3|2002|IMSI001010000000002 | |||
Revision as of 13:46, 7 December 2013
Masuk ke Database SubscriberRegistry
sqlite3 /var/lib/asterisk/sqlite3dir/sqlite3.db
akan keluar
sqlite>
Cek database
.databases
seq name file --- --------------- ---------------------------------------------------------- 0 main /var/lib/asterisk/sqlite3dir/sqlite3.db 1 temp
Cek table
.tables
DIALDATA_TABLE RRLP SIP_BUDDIES rates
Cek isi table DIALDATA_TABLE
select * from DIALDATA_TABLE;
1|2100|IMSI001010000000000 2|2001|IMSI001010000000001 3|2002|IMSI001010000000002