Hallo,
when setting up a 3G network with the nano3G the default filename of the HLR according to osmo-hlr is hlr.db (source code: hlr.c), but the run.sh script, which is included in https://osmocom.org/attachments/download/2636/3G-config-example-v5.tar tries to access hlr.sqlite3 (7th line: sqlite3 hlr.sqlite3 "delete from sms"). So, when starting an error message occures: "Error: no such table: sms".
greetings,
Andreas
Hello,
sorry - I saw, that sms table is in sms.db, so the line in run.sh to clean the table should maybe be sqlite3 sms.db "delete from sms"
greetings,
Andreas
On Sat, May 13, 2017 at 03:47:23PM +0200, Andreas Mueller wrote:
Hallo,when setting up a 3G network with the nano3G the default filename of the HLR according to osmo-hlr is hlr.db (source code: hlr.c), but the run.sh script, which is included in https://osmocom.org/attachments/download/2636/3G-config-example-v5.tar tries to access hlr.sqlite3 (7th line: sqlite3 hlr.sqlite3 "delete from sms"). So, when starting an error message occures: "Error: no such table: sms".
greetings, Andreas
On Sat, May 13, 2017 at 08:48:10PM +0200, Andreas Mueller wrote:
Hello,sorry - I saw, that sms table is in sms.db, so the line in run.sh to clean the table should maybe be sqlite3 sms.db "delete from sms"
Ah, thanks for reporting this.
The hlr.sqlite3 is the legacy database from OsmoNITB. In OsmoMSC, this db no longer holds subscriber data, but until we fix the implementation, SMS are still stored in it. Thus it was renamed to sms.db.
That said, the run script comes from my personal test setup, where I don't want SMS from a previous test run to re-appear in the next one. So I deleted all SMS from the (then) hlr.sqlite3. That would need to happen in sms.db now, but in that run.sh we shouldn't actually remove SMS, who knows what important messages might be in there :)
I commented out the SMS deletion, fixed the db filename and uploaded to redmine.
Thanks!
~N
-
Andreas Mueller -
Neels Hofmeyr