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.