FreePBX | Register | Issues | Wiki | Portal | Support

SQL logic error or missing database


#1

i found a old post Corrupted ASTDB - how to rebuild?
but this I think is for a older version (correct me if I am wrong I like to know as much as I can)

the version of freepbx is 14 is most recent updated few days ago
asterisk I tried v15.7.1 and now on v13 asterisk what ever is most recent LTS

I had only astdb.sqlite3. so i backed up and removed it.
my 2 test connections do not ring but work fine out. similar to whats mentioned in post above

here is the error when I apply any changes like hitting sumit to a ext (as per post mentioned above)

WARNING db.c ast_db_deltree: Couldn’t execute stmt: SQL logic error or missing database

[2019-01-12 18:21:07] NOTICE[26056]: iax2/provision.c:562 iax_provision_reload: No IAX provisioning configuration found, IAX provisioning disabled.
[2019-01-12 18:21:07] WARNING[26056]: db.c:483 ast_db_deltree: Couldn't execute stmt: SQL logic error or missing database
    -- Reloading module 'chan_dahdi.so' (DAHDI Telephony)
    -- Reloading module 'chan_sip.so' (Session Initiation Protocol (SIP))
 Reloading SIP
  == Using SIP TOS bits 96
  == Using SIP CoS mark 4
    -- Reloading module 'res_adsi.so' (ADSI Resource)
    -- Reloading module 'app_confbridge.so' (Conference Bridge Application)
[2019-01-12 18:21:07] NOTICE[26056]: confbridge/conf_config_parser.c:2089 verify_default_profiles: Adding default_menu menu to app_confbridge
    -- Reloading module 'cel_manager.so' (Asterisk Manager Interface CEL Backend)
    -- Reloading module 'cel_odbc.so' (ODBC CEL backend)
    -- Found CEL table cel@asteriskcdrdb.
    -- Reloading module 'res_http_post.so' (HTTP POST support)
    -- Reloading module 'codec_speex.so' (Speex Coder/Decoder)
    -- Reloading module 'app_voicemail.so' (Comedian Mail (Voicemail System))
[2019-01-12 18:21:07] WARNING[26056]: app_voicemail.c:13870 actual_load_config: maxsilence should be less than minsecs or you may get empty messages
    -- Reloading module 'codec_dahdi.so' (Generic DAHDI Transcoder Codec Translator)
    -- Reloading module 'app_playback.so' (Sound File Playback Application)
    -- Reloading module 'app_queue.so' (True Call Queueing)
[2019-01-12 18:21:07] NOTICE[26056]: app_queue.c:8729 reload_queue_rules: No queuerules.conf file found, queues will not follow penalty rules
    -- Remote UNIX connection disconnected
[2019-01-12 18:22:50] WARNING[25563]: chan_sip.c:4128 retrans_pkt: Timeout on 723603460-1449424062-1889182466 on non-critical invite transaction.
[2019-01-12 18:23:06] WARNING[25563]: db.c:350 ast_db_put: Couldn't execute statment: SQL logic error or missing database
    -- Registered SIP '21' at 192.168.1.239:5060
       > Saved useragent "Linksys/SPA2100" for peer 21
[2019-01-12 18:23:06] NOTICE[25563]: chan_sip.c:24640 handle_response_peerpoke: Peer '21' is now Reachable. (10ms / 2000ms)

Here is a call coming in the cli
DID fake 5195551234
from CID fake 5195550005

4 sip peers [Monitored: 4 online, 0 offline Unmonitored: 0 online, 0 offline]
  == Using SIP RTP TOS bits 184
  == Using SIP RTP CoS mark 5
       > 0x7fc104008df0 -- Strict RTP learning after remote address set to: 55.55.55.555:12864
    -- Executing [5195551234@from-trunk:1] Set("SIP/voiceprovider1_out-00000001", "__DIRECTION=INBOUND") in new stack
    -- Executing [5195551234@from-trunk:2] Gosub("SIP/voiceprovider1_out-00000001", "sub-record-check,s,1(in,5195551234,dontcare)") in new stack
    -- Executing [s@sub-record-check:1] GotoIf("SIP/voiceprovider1_out-00000001", "0?initialized") in new stack
    -- Executing [s@sub-record-check:2] Set("SIP/voiceprovider1_out-00000001", "__REC_STATUS=INITIALIZED") in new stack
    -- Executing [s@sub-record-check:3] Set("SIP/voiceprovider1_out-00000001", "NOW=1547339084") in new stack
    -- Executing [s@sub-record-check:4] Set("SIP/voiceprovider1_out-00000001", "__DAY=12") in new stack
    -- Executing [s@sub-record-check:5] Set("SIP/voiceprovider1_out-00000001", "__MONTH=01") in new stack
    -- Executing [s@sub-record-check:6] Set("SIP/voiceprovider1_out-00000001", "__YEAR=2019") in new stack
    -- Executing [s@sub-record-check:7] Set("SIP/voiceprovider1_out-00000001", "__TIMESTR=20190112-192444") in new stack
    -- Executing [s@sub-record-check:8] Set("SIP/voiceprovider1_out-00000001", "__FROMEXTEN=unknown") in new stack
    -- Executing [s@sub-record-check:9] Set("SIP/voiceprovider1_out-00000001", "__MON_FMT=wav") in new stack
    -- Executing [s@sub-record-check:10] NoOp("SIP/voiceprovider1_out-00000001", "Recordings initialized") in new stack
    -- Executing [s@sub-record-check:11] ExecIf("SIP/voiceprovider1_out-00000001", "0?Set(ARG3=dontcare)") in new stack
    -- Executing [s@sub-record-check:12] Set("SIP/voiceprovider1_out-00000001", "REC_POLICY_MODE_SAVE=") in new stack
    -- Executing [s@sub-record-check:13] ExecIf("SIP/voiceprovider1_out-00000001", "0?Set(REC_STATUS=NO)") in new stack
    -- Executing [s@sub-record-check:14] GotoIf("SIP/voiceprovider1_out-00000001", "2?checkaction") in new stack
    -- Goto (sub-record-check,s,17)
    -- Executing [s@sub-record-check:17] GotoIf("SIP/voiceprovider1_out-00000001", "1?sub-record-check,in,1") in new stack
    -- Goto (sub-record-check,in,1)
    -- Executing [in@sub-record-check:1] NoOp("SIP/voiceprovider1_out-00000001", "Inbound Recording Check to 5195551234") in new stack
    -- Executing [in@sub-record-check:2] Set("SIP/voiceprovider1_out-00000001", "FROMEXTEN=unknown") in new stack
    -- Executing [in@sub-record-check:3] ExecIf("SIP/voiceprovider1_out-00000001", "10?Set(FROMEXTEN=5195550005)") in new stack
    -- Executing [in@sub-record-check:4] Gosub("SIP/voiceprovider1_out-00000001", "recordcheck,1(dontcare,in,5195551234)") in new stack
    -- Executing [recordcheck@sub-record-check:1] NoOp("SIP/voiceprovider1_out-00000001", "Starting recording check against dontcare") in new stack
    -- Executing [recordcheck@sub-record-check:2] Goto("SIP/voiceprovider1_out-00000001", "dontcare") in new stack
    -- Goto (sub-record-check,recordcheck,3)
    -- Executing [recordcheck@sub-record-check:3] Return("SIP/voiceprovider1_out-00000001", "") in new stack
    -- Executing [in@sub-record-check:5] Return("SIP/voiceprovider1_out-00000001", "") in new stack
    -- Executing [5195551234@from-trunk:3] Set("SIP/voiceprovider1_out-00000001", "CHANNEL(tonezone)=us") in new stack
    -- Executing [5195551234@from-trunk:4] Set("SIP/voiceprovider1_out-00000001", "__FROM_DID=5195551234") in new stack
    -- Executing [5195551234@from-trunk:5] Set("SIP/voiceprovider1_out-00000001", "returnhere=1") in new stack
    -- Executing [5195551234@from-trunk:6] Gosub("SIP/voiceprovider1_out-00000001", "app-blacklist-check,s,1()") in new stack
    -- Executing [s@app-blacklist-check:1] GotoIf("SIP/voiceprovider1_out-00000001", "0?blacklisted") in new stack
    -- Executing [s@app-blacklist-check:2] Set("SIP/voiceprovider1_out-00000001", "CALLED_BLACKLIST=1") in new stack
    -- Executing [s@app-blacklist-check:3] Return("SIP/voiceprovider1_out-00000001", "") in new stack
    -- Executing [5195551234@from-trunk:7] Set("SIP/voiceprovider1_out-00000001", "CDR(did)=5195551234") in new stack
    -- Executing [5195551234@from-trunk:8] GotoIf("SIP/voiceprovider1_out-00000001", "0?") in new stack
    -- Executing [5195551234@from-trunk:9] ExecIf("SIP/voiceprovider1_out-00000001", "0 ?Set(CALLERID(name)=5195550005)") in new stack
    -- Executing [5195551234@from-trunk:10] Set("SIP/voiceprovider1_out-00000001", "__MOHCLASS=") in new stack
    -- Executing [5195551234@from-trunk:11] Ringing("SIP/voiceprovider1_out-00000001", "") in new stack
    -- Executing [5195551234@from-trunk:12] Set("SIP/voiceprovider1_out-00000001", "__RINGINGSENT=TRUE") in new stack
    -- Executing [5195551234@from-trunk:13] Set("SIP/voiceprovider1_out-00000001", "__REVERSAL_REJECT=FALSE") in new stack
    -- Executing [5195551234@from-trunk:14] GotoIf("SIP/voiceprovider1_out-00000001", "1?post-reverse-charge") in new stack
    -- Goto (from-trunk,5195551234,16)
    -- Executing [5195551234@from-trunk:16] NoOp("SIP/voiceprovider1_out-00000001", "") in new stack
    -- Executing [5195551234@from-trunk:17] Set("SIP/voiceprovider1_out-00000001", "__CALLINGNAMEPRES_SV=allowed_not_screened") in new stack
    -- Executing [5195551234@from-trunk:18] Set("SIP/voiceprovider1_out-00000001", "__CALLINGNUMPRES_SV=allowed_not_screened") in new stack
    -- Executing [5195551234@from-trunk:19] Set("SIP/voiceprovider1_out-00000001", "CALLERID(name-pres)=allowed_not_screened") in new stack
    -- Executing [5195551234@from-trunk:20] Set("SIP/voiceprovider1_out-00000001", "CALLERID(num-pres)=allowed_not_screened") in new stack
    -- Executing [5195551234@from-trunk:21] NoOp("SIP/voiceprovider1_out-00000001", "CallerID Entry Point") in new stack
    -- Executing [5195551234@from-trunk:22] Goto("SIP/voiceprovider1_out-00000001", "from-did-direct,20,1") in new stack
    -- Goto (from-did-direct,20,1)
    -- Executing [20@from-did-direct:1] GotoIf("SIP/voiceprovider1_out-00000001", "1?ext-local,20,1:followme-check,20,1") in new stack
    -- Goto (ext-local,20,1)
    -- Executing [20@ext-local:1] Set("SIP/voiceprovider1_out-00000001", "__RINGTIMER=15") in new stack
    -- Executing [20@ext-local:2] Macro("SIP/voiceprovider1_out-00000001", "exten-vm,novm,20,0,0,0") in new stack
    -- Executing [s@macro-exten-vm:1] Macro("SIP/voiceprovider1_out-00000001", "user-callerid,") in new stack
    -- Executing [s@macro-user-callerid:1] Set("SIP/voiceprovider1_out-00000001", "TOUCH_MONITOR=1547339084.1") in new stack
    -- Executing [s@macro-user-callerid:2] Set("SIP/voiceprovider1_out-00000001", "AMPUSER=5195550005") in new stack
    -- Executing [s@macro-user-callerid:3] GotoIf("SIP/voiceprovider1_out-00000001", "0?report") in new stack
    -- Executing [s@macro-user-callerid:4] ExecIf("SIP/voiceprovider1_out-00000001", "1?Set(REALCALLERIDNUM=5195550005)") in new stack
    -- Executing [s@macro-user-callerid:5] Set("SIP/voiceprovider1_out-00000001", "AMPUSER=") in new stack
    -- Executing [s@macro-user-callerid:6] GotoIf("SIP/voiceprovider1_out-00000001", "0?limit") in new stack
    -- Executing [s@macro-user-callerid:7] Set("SIP/voiceprovider1_out-00000001", "AMPUSERCIDNAME=") in new stack
    -- Executing [s@macro-user-callerid:8] ExecIf("SIP/voiceprovider1_out-00000001", "0?Set(__CIDMASQUERADING=TRUE)") in new stack
    -- Executing [s@macro-user-callerid:9] GotoIf("SIP/voiceprovider1_out-00000001", "1?report") in new stack
    -- Goto (macro-user-callerid,s,15)
    -- Executing [s@macro-user-callerid:15] NoOp("SIP/voiceprovider1_out-00000001", "Macro Depth is 2") in new stack
    -- Executing [s@macro-user-callerid:16] GotoIf("SIP/voiceprovider1_out-00000001", "1?report2:macroerror") in new stack
    -- Goto (macro-user-callerid,s,17)
    -- Executing [s@macro-user-callerid:17] GotoIf("SIP/voiceprovider1_out-00000001", "0?continue") in new stack
    -- Executing [s@macro-user-callerid:18] Set("SIP/voiceprovider1_out-00000001", "__TTL=64") in new stack
    -- Executing [s@macro-user-callerid:19] GotoIf("SIP/voiceprovider1_out-00000001", "1?continue") in new stack
    -- Goto (macro-user-callerid,s,35)
    -- Executing [s@macro-user-callerid:35] Set("SIP/voiceprovider1_out-00000001", "CALLERID(number)=5195550005") in new stack
    -- Executing [s@macro-user-callerid:36] Set("SIP/voiceprovider1_out-00000001", "CALLERID(name)=J: COMPUTER") in new stack
    -- Executing [s@macro-user-callerid:37] GotoIf("SIP/voiceprovider1_out-00000001", "0?cnum") in new stack
    -- Executing [s@macro-user-callerid:38] Set("SIP/voiceprovider1_out-00000001", "CDR(cnam)=J: COMPUTER") in new stack
    -- Executing [s@macro-user-callerid:39] Set("SIP/voiceprovider1_out-00000001", "CDR(cnum)=5195550005") in new stack
    -- Executing [s@macro-user-callerid:40] Set("SIP/voiceprovider1_out-00000001", "CHANNEL(language)=en") in new stack
    -- Executing [s@macro-exten-vm:2] Set("SIP/voiceprovider1_out-00000001", "RingGroupMethod=none") in new stack
    -- Executing [s@macro-exten-vm:3] Set("SIP/voiceprovider1_out-00000001", "__EXTTOCALL=20") in new stack
    -- Executing [s@macro-exten-vm:4] Set("SIP/voiceprovider1_out-00000001", "__PICKUPMARK=20") in new stack
    -- Executing [s@macro-exten-vm:5] Set("SIP/voiceprovider1_out-00000001", "RT=") in new stack
    -- Executing [s@macro-exten-vm:6] Gosub("SIP/voiceprovider1_out-00000001", "sub-record-check,s,1(exten,20,dontcare)") in new stack
    -- Executing [s@sub-record-check:1] GotoIf("SIP/voiceprovider1_out-00000001", "10?initialized") in new stack
    -- Goto (sub-record-check,s,10)
    -- Executing [s@sub-record-check:10] NoOp("SIP/voiceprovider1_out-00000001", "Recordings initialized") in new stack
    -- Executing [s@sub-record-check:11] ExecIf("SIP/voiceprovider1_out-00000001", "0?Set(ARG3=dontcare)") in new stack
    -- Executing [s@sub-record-check:12] Set("SIP/voiceprovider1_out-00000001", "REC_POLICY_MODE_SAVE=") in new stack
    -- Executing [s@sub-record-check:13] ExecIf("SIP/voiceprovider1_out-00000001", "0?Set(REC_STATUS=NO)") in new stack
    -- Executing [s@sub-record-check:14] GotoIf("SIP/voiceprovider1_out-00000001", "5?checkaction") in new stack
    -- Goto (sub-record-check,s,17)
    -- Executing [s@sub-record-check:17] GotoIf("SIP/voiceprovider1_out-00000001", "1?sub-record-check,exten,1") in new stack
    -- Goto (sub-record-check,exten,1)
    -- Executing [exten@sub-record-check:1] NoOp("SIP/voiceprovider1_out-00000001", "Exten Recording Check between 5195550005 and 20") in new stack
    -- Executing [exten@sub-record-check:2] Set("SIP/voiceprovider1_out-00000001", "CALLTYPE=external") in new stack
    -- Executing [exten@sub-record-check:3] ExecIf("SIP/voiceprovider1_out-00000001", "0?Set(CALLTYPE=)") in new stack
    -- Executing [exten@sub-record-check:4] Set("SIP/voiceprovider1_out-00000001", "CALLEE=") in new stack
    -- Executing [exten@sub-record-check:5] ExecIf("SIP/voiceprovider1_out-00000001", "1?Set(CALLEE=dontcare)") in new stack
    -- Executing [exten@sub-record-check:6] GotoIf("SIP/voiceprovider1_out-00000001", "1?callee") in new stack
    -- Goto (sub-record-check,exten,11)
    -- Executing [exten@sub-record-check:11] Gosub("SIP/voiceprovider1_out-00000001", "recordcheck,1(dontcare,external,20)") in new stack
    -- Executing [recordcheck@sub-record-check:1] NoOp("SIP/voiceprovider1_out-00000001", "Starting recording check against dontcare") in new stack
    -- Executing [recordcheck@sub-record-check:2] Goto("SIP/voiceprovider1_out-00000001", "dontcare") in new stack
    -- Goto (sub-record-check,recordcheck,3)
    -- Executing [recordcheck@sub-record-check:3] Return("SIP/voiceprovider1_out-00000001", "") in new stack
    -- Executing [exten@sub-record-check:12] Return("SIP/voiceprovider1_out-00000001", "") in new stack
    -- Executing [s@macro-exten-vm:7] GotoIf("SIP/voiceprovider1_out-00000001", "1?macrodial") in new stack
    -- Goto (macro-exten-vm,s,13)
    -- Executing [s@macro-exten-vm:13] GosubIf("SIP/voiceprovider1_out-00000001", "0?clrheader,1()") in new stack
    -- Executing [s@macro-exten-vm:14] Macro("SIP/voiceprovider1_out-00000001", "dial-one,,HhTtr,20") in new stack
    -- Executing [s@macro-dial-one:1] Set("SIP/voiceprovider1_out-00000001", "DEXTEN=20") in new stack
    -- Executing [s@macro-dial-one:2] ExecIf("SIP/voiceprovider1_out-00000001", "0?Set(__EXTTOCALL=20)") in new stack
    -- Executing [s@macro-dial-one:3] Set("SIP/voiceprovider1_out-00000001", "DIALSTATUS_CW=") in new stack
    -- Executing [s@macro-dial-one:4] GosubIf("SIP/voiceprovider1_out-00000001", "0?screen,1()") in new stack
    -- Executing [s@macro-dial-one:5] GosubIf("SIP/voiceprovider1_out-00000001", "0?cf,1()") in new stack
    -- Executing [s@macro-dial-one:6] GotoIf("SIP/voiceprovider1_out-00000001", "1?skip1") in new stack
    -- Goto (macro-dial-one,s,9)
    -- Executing [s@macro-dial-one:9] GotoIf("SIP/voiceprovider1_out-00000001", "0?nodial") in new stack
    -- Executing [s@macro-dial-one:10] GotoIf("SIP/voiceprovider1_out-00000001", "0?continue") in new stack
    -- Executing [s@macro-dial-one:11] Set("SIP/voiceprovider1_out-00000001", "EXTHASCW=") in new stack
    -- Executing [s@macro-dial-one:12] GotoIf("SIP/voiceprovider1_out-00000001", "1?next1:cwinusebusy") in new stack
    -- Goto (macro-dial-one,s,13)
    -- Executing [s@macro-dial-one:13] GotoIf("SIP/voiceprovider1_out-00000001", "0?docfu:skip3") in new stack
    -- Goto (macro-dial-one,s,17)
    -- Executing [s@macro-dial-one:17] GotoIf("SIP/voiceprovider1_out-00000001", "1?next2:continue") in new stack
    -- Goto (macro-dial-one,s,18)
    -- Executing [s@macro-dial-one:18] GotoIf("SIP/voiceprovider1_out-00000001", "1?continue") in new stack
    -- Goto (macro-dial-one,s,26)
    -- Executing [s@macro-dial-one:26] GotoIf("SIP/voiceprovider1_out-00000001", "0?nodial") in new stack
    -- Executing [s@macro-dial-one:27] GosubIf("SIP/voiceprovider1_out-00000001", "1?dstring,1():dlocal,1()") in new stack
    -- Executing [dstring@macro-dial-one:1] Set("SIP/voiceprovider1_out-00000001", "DSTRING=") in new stack
    -- Executing [dstring@macro-dial-one:2] Set("SIP/voiceprovider1_out-00000001", "DEVICES=") in new stack
    -- Executing [dstring@macro-dial-one:3] ExecIf("SIP/voiceprovider1_out-00000001", "1?Return()") in new stack
    -- Executing [s@macro-dial-one:28] GotoIf("SIP/voiceprovider1_out-00000001", "1?nodial") in new stack
    -- Goto (macro-dial-one,s,59)
    -- Executing [s@macro-dial-one:59] NoOp("SIP/voiceprovider1_out-00000001", "") in new stack
    -- Executing [s@macro-dial-one:60] ExecIf("SIP/voiceprovider1_out-00000001", "1?Set(DIALSTATUS=NOANSWER)") in new stack
    -- Executing [s@macro-dial-one:61] NoOp("SIP/voiceprovider1_out-00000001", "Returned from dial-one with nothing to call and DIALSTATUS: NOANSWER") in new stack
    -- Executing [s@macro-dial-one:62] MacroExit("SIP/voiceprovider1_out-00000001", "") in new stack
    -- Executing [s@macro-exten-vm:15] Set("SIP/voiceprovider1_out-00000001", "SV_DIALSTATUS=NOANSWER") in new stack
    -- Executing [s@macro-exten-vm:16] GosubIf("SIP/voiceprovider1_out-00000001", "0?docfu,1()") in new stack
    -- Executing [s@macro-exten-vm:17] GosubIf("SIP/voiceprovider1_out-00000001", "0?docfb,1()") in new stack
    -- Executing [s@macro-exten-vm:18] Set("SIP/voiceprovider1_out-00000001", "DIALSTATUS=NOANSWER") in new stack
    -- Executing [s@macro-exten-vm:19] ExecIf("SIP/voiceprovider1_out-00000001", "0?MacroExit()") in new stack
    -- Executing [s@macro-exten-vm:20] GotoIf("SIP/voiceprovider1_out-00000001", "1?s-NOANSWER,1") in new stack
    -- Goto (macro-exten-vm,s-NOANSWER,1)
    -- Executing [s-NOANSWER@macro-exten-vm:1] GotoIf("SIP/voiceprovider1_out-00000001", "0?exit,1") in new stack
    -- Executing [s-NOANSWER@macro-exten-vm:2] PlayTones("SIP/voiceprovider1_out-00000001", "congestion") in new stack
    -- Executing [s-NOANSWER@macro-exten-vm:3] Congestion("SIP/voiceprovider1_out-00000001", "10") in new stack
  == Spawn extension (macro-exten-vm, s-NOANSWER, 3) exited non-zero on 'SIP/voiceprovider1_out-00000001' in macro 'exten-vm'
  == Spawn extension (ext-local, 20, 2) exited non-zero on 'SIP/voiceprovider1_out-00000001'
    -- Executing [h@ext-local:1] Macro("SIP/voiceprovider1_out-00000001", "hangupcall,") in new stack
    -- Executing [s@macro-hangupcall:1] GotoIf("SIP/voiceprovider1_out-00000001", "1?theend") in new stack
    -- Goto (macro-hangupcall,s,3)
    -- Executing [s@macro-hangupcall:3] ExecIf("SIP/voiceprovider1_out-00000001", "0?Set(CDR(recordingfile)=)") in new stack
    -- Executing [s@macro-hangupcall:4] NoOp("SIP/voiceprovider1_out-00000001", " monior file= ") in new stack
    -- Executing [s@macro-hangupcall:5] AGI("SIP/voiceprovider1_out-00000001", "attendedtransfer-rec-restart.php,,") in new stack
    -- Launched AGI Script /var/lib/asterisk/agi-bin/attendedtransfer-rec-restart.php
    -- <SIP/voiceprovider1_out-00000001>AGI Script attendedtransfer-rec-restart.php completed, returning 0
    -- Executing [s@macro-hangupcall:6] Hangup("SIP/voiceprovider1_out-00000001", "") in new stack
  == Spawn extension (macro-hangupcall, s, 6) exited non-zero on 'SIP/voiceprovider1_out-00000001' in macro 'hangupcall'
  == Spawn extension (ext-local, h, 1) exited non-zero on 'SIP/voiceprovider1_out-00000001'
pbx*CLI> 

Let me know if you need me to show more information.

After I removed the /var/lib/asterisk/astdb.sqlite3 i no longer see the error but am unable to get phones to ring.


(Tom Ray) #2

You need to restore a backup. Without the AstDB nothing is going to work


#3

If you start asterisk when there is no astdb.sqlite3 then it will create an empty one for you. You will need to go to each extension in turn and hit the submit button to repopulate the AMPUSER family , hit the apply changes button when you are all done. Freepbx will get other necessary ‘families’ rebuilt , dnd and cf and other transient ‘values’ will need to be redone.


(system) closed #4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.