aboutsummaryrefslogtreecommitdiffstats
path: root/sql
AgeCommit message (Collapse)AuthorFilesLines
2017-06-03hlr_data.sql: Insert ki and opc instead of op to example dataDaniel Willmann1-2/+2
It depends on the cards whether you have op or opc, but the most cards in use for 3G are using the opc. Change the example to reflect that. Change-Id: I8f6051ea9b285ff6261bfe346cfc29d1167921f5
2017-05-22install hlr.sql in prefix/doc/osmo-hlr/Neels Hofmeyr1-0/+3
In particular I need this to start a fresh osmo-hlr instance on the osmo-gsm-tester. Might also come in handy during packaging? Change-Id: I08e48375814ab93691892299d34909c6d0bf12a2
2017-03-16UMTS AKA: implement SQN increment according to SEQ and INDNeels Hofmeyr1-1/+2
Add ind_bitlen column to auc_3g to record each USIM's IND size according to 3GPP TS 33.102 -- default is 5 bits, as suggested by the spec. Introduce auc_3g_ind to each connecting GSUP client to use as IND index for generating auth tuples sent to this client. With osmo_gsup_server_add_conn(), implement a scheme where clients receive fixed auc_3g_ind indexes based on the order in which they connect; each new connection takes the lowest unused auc_3g_ind, so in case one of the clients restarts, it will most likely receive the same auc_3g_ind, and if one client disconnects, no other clients' auc_3g_ind are affected. Add gsup_server_test.c to test the auc_3g_ind index distribution scheme. Depends: libosmocore I4eac5be0c0b2cede04464c4c3a0873102d952453 for llist_first Related: OS#1969 Change-Id: If4501ed4ff8e923fa6fe8b80c44c5ad647a8ed60
2017-02-01sql: add unique constraints to IMSI and MSISDNNeels Hofmeyr1-2/+2
Todo for later: table subscriber_multi_msisdn possibly allows duplicating the MSISDN, so we should drop this table or have all MSISDNs in one table separate from 'subscriber'. Change-Id: I5737106a232e416d67a10634e6270a7a89cf1b05
2017-02-01comment: sql: describe auc_2g and auc_3g columnsNeels Hofmeyr1-7/+7
Change-Id: Ie4edc69ff11a83a4c0f79097f43a2cb206dfe405
2017-02-01sql: auc_3g: set sqn NOT NULL DEFAULT 0Neels Hofmeyr1-1/+1
Change-Id: Ibb765f30295b441e563bb0e06ed39987f79a60d6
2017-02-01cosmetic: sql: indicate VARCHAR size of key columns as 32Neels Hofmeyr1-3/+3
Notably this has no functional effect (according to https://sqlite.org/faq.html#q9 ), but it can't hurt to indicate intent. Change-Id: I2b0f9369318085c1482c6d2d8db56699466bfbf3
2017-02-01sql: fix 3g_auc's column K data typeNeels Hofmeyr1-1/+1
K is the SIM card's 128bit secret key, so the type should be VARCHAR like the other key columns. The db code already reads the column as text and parses as hex, so a VARCHAR column matches that. Change-Id: Iaa8d33e303760bd15dcb7dc8bb8b9b24bf6c8f14
2017-01-19hlr.sql: typo in commentNeels Hofmeyr1-1/+1
Change-Id: I8f16944f966bd40540d5b5396873b873685c18e9
2016-12-11build with autoconf/automake, add jenkins.sh scriptNeels Hofmeyr1-0/+4
Add configure.ac and Makefile.ams to build with autoreconf && ./configure && make like most other Osmocom projects. Add jenkins.sh for a gerrit build job to verify patches. Change-Id: I6b4419dd519f3d0a75235d0c22bf899f075347a3
2016-05-05implement PURGE-MS from VLR/SGSN to HLRHarald Welte1-0/+2
Using this procedure, the VLR/SGSN can set the cs/ps purged flag for the subscriber. We might not even need to store this persistent in the database according to spec, but let's do it anyway, at least until it turns out to be a performance issue.
2016-05-03hlr.sql: Don't use TRUE/FALSE as DEFAULT, they will be strings :(Harald Welte1-4/+5
SQLite has this crappy type system where you can put a string into a boolean or integer column, which of course will break once you try to read it as bool.. Also, add an index by IMSI to the SUBSCRIBER table.
2016-04-28initial import of osmo-gsup-hlr code so farHarald Welte2-0/+80