|
From: Phil K. <phi...@ru...> - 2016-01-04 10:49:32
|
Dear list, I wish you all a happy new year. My last mail to the list came around during holiday time and was probably missed by some of you. Let me quickly rephrase my problem and concentrate on the encryption problem first. I tried setting up encryption in OpenBTS by using a self-burned SIM card with known k_i and by enabling *GSM.Cipher.Encrypt* on the openBTS command line. When I connect the SIM card I am receiving error messages in my log that indicate a problem with an SQL query (see log output at the end of the message). The same lines are repeated over and over again and no connection can be established. The most relevant part seems to be 'sqlite3_prepare_v2 failed code=1 for "update mem_sip_buddies set dirty = "1", rand = "",sres = "" where username = "IMSI262071234567891"": no such column: dirty'. Why is there no dirty column and how could I fix this? Thank you for your help, -Phil FULL LOG OUTPUT: Dec 22 15:37:43 phl-openBTSBox openbts: INFO 1535:1857 2015-12-22T15:37:43.7 L3TranEntry.cpp:869:ttAdd: new transaction TranEntry( tid=116 GSMState=null chan=(C0T0 SDCCH/4-0 state=Established) Subscriber=( Imsi="" Tmsi=(no tmsi) Imei="") L3TI=16 Service=LUR stateAge=(0 sec)) Dec 22 15:37:44 phl-openBTSBox sipauthserve: NOTICE 1522:1522 2015-12-22T15:37:44.6 sipauthserve.cpp:234:processBuffer: imsi 262071234567891 known, 1st register Dec 22 15:37:44 phl-openBTSBox sipauthserve: ERR 1522:1522 2015-12-22T15:37:44.6 sqlite3util.cpp:62:sqlite3_prepare_statement: sqlite3_prepare_v2 failed code=1 for "update mem_sip_buddies set dirty = "1", rand = "",sres = "" where username = "IMSI262071234567891"": no such column: dirty Dec 22 15:37:44 phl-openBTSBox openbts: INFO 1535:1834 2015-12-22T15:37:44.7 SIPTransaction.cpp:550:TUWriteHighSideV: SIP Register received:SipMessage( code=401 reason=Unauthorized CSeq=210970 REGISTER callid=574aa22458a58954 To=<sip:IMSI262071234567891@127.0.0.1:5064> From=<sip:IMSI262071234567891@127.0.0.1:5064>;tag=OBTSpabeszyzgarsgtzd Vias=SIP/2.0/UDP localhost:5064;branch=1;rec...@fo...,SIP/2.0/UDP 127.0.0.1:5062;branch=z9hG4bKOBTSmeoavcficgcvwzlf Contact=<sip:IMSI262071234567891@127.0.0.1:5062>;expires=5400 header WWW-Authenticate=Digest nonce=a2e9cc3c9b9e76aed67df448c6336370 header P-preferred-identity=<sip:IMSI262071234567891@127.0.0.1> header P-phy-info=OpenBTS; IMSI=no-MMUser TA=0 TE=0.083008 UpRSSI=-40.000000 TxPwr=39 DnRSSIdBm=-70 time=1450795064.390 header P-access-network-info=3GPP-GERAN; cgi-3gpp=26207011d1a0a header User-agent=OpenBTS 5.0-master Build Date 2015-12-21T11:59:48 header Content-Length=0 firstLine=) Dec 22 15:37:45 phl-openBTSBox sipauthserve: ERR 1522:1522 2015-12-22T15:37:45.7 ../SubscriberRegistry.cpp:481:sqlLocal: Subscriber registry returned a NULL column. Dec 22 15:37:45 phl-openBTSBox sipauthserve: ERR 1522:1522 2015-12-22T15:37:45.7 sqlite3util.cpp:62:sqlite3_prepare_statement: sqlite3_prepare_v2 failed code=1 for "update mem_sip_buddies set dirty = "1", ipaddr = "127.0.0.1",port = "5062" where username = "IMSI262071234567891"": no such column: dirty Dec 22 15:37:49 phl-openBTSBox openbts: INFO 1535:1857 2015-12-22T15:37:49.0 L3TranEntry.cpp:1571:teRemove: SIP term info dialogCancel called in teRemove cancel cause: l3cause=785=0x311(MM_Success) SipCode=0() Dec 22 15:37:49 phl-openBTSBox openbts: ERR 1535:1857 2015-12-22T15:37:49.1 GSMLogicalChannel.cpp:124:flushL3In: channel closure caused message to be discarded:L3Frame( Primitive=L3_DATA Sapi=SAPI0 PD=Mobility Management MTI=0x2(Location Updating Accept) TI=0 raw=(050262f270011da1)) C0T0 SDCCH/4-0 Dec 22 15:37:49 phl-openBTSBox openbts: ERR 1535:1857 2015-12-22T15:37:49.1 GSMLogicalChannel.cpp:124:flushL3In: channel closure caused message to be discarded:L3Frame( Primitive=L3_DATA Sapi=SAPI0 PD=Radio Resource MTI=0xd(Channel Release) TI=0 raw=(060d00)) C0T0 SDCCH/4-0 |