13 May
2017
13 May
'17
3:47 p.m.
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
13 May
13 May
8:48 p.m.
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
11:28 p.m.
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
2563
days inactive
2563
days old
2 comments
2 participants
participants (2)
-
Andreas Mueller -
Neels Hofmeyr