Phones not ringing for incoming calls

reikidude89 · September 1, 2015, 2:43pm

HI

I’ve strange problem with freepbx,last week i realized that when i’ve an incoming call, no exstensions ring, 'ive tried to upgrade modules admin and restart but problem persist.

My scenario consist on a firewall connected directly to the switch where freepbx is attached.
PBX have always worked fine but this problem maby is caused by my last upgrade of modules.

this is the cli when i’ve the incoming call.

>     2015-09-01 16:34:24] ERROR[16340][C-0000000a]: cdr_odbc.c:148 odbc_log: Unable to retrieve database handle.  CDR failed.
> [2015-09-01 16:34:25] NOTICE[2228]: chan_iax2.c:11192 socket_process_helper: Peer '207' is now REACHABLE! Time: 989
> [2015-09-01 16:34:35] WARNING[16376][C-0000000b]: Ext. 03519966339:2 @ from-trunk: Friendly Scanner from 83.211.227.21
> [2015-09-01 16:34:35] WARNING[16376][C-0000000b]: func_channel.c:538 func_channel_read: Unknown or unavailable item requested: 'reversecharge'
> [2015-09-01 16:34:54] WARNING[2237][C-0000000b]: chan_sip.c:23127 handle_response_invite: Received response: "Forbidden" from '<sip:[email protected]>;tag=as6da8eb23'
> [2015-09-01 16:35:14] ERROR[16384][C-0000000b]: cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (1045) Access denied for user 'freepbx'@'localhost' (using password: YES)
> [2015-09-01 16:35:14] ERROR[16384][C-0000000b]: cdr_odbc.c:148 odbc_log: Unable to retrieve database handle.  CDR failed.
> [2015-09-01 16:35:14] WARNING[2237][C-0000000b]: chan_sip.c:23127 handle_response_invite: Received response: "Forbidden" from '<sip:[email protected]>;tag=as0def6d10'
> [2015-09-01 16:35:21] WARNING[2237][C-0000000b]: chan_sip.c:23127 handle_response_invite: Received response: "Forbidden" from '<sip:[email protected]>;tag=as2e27e2b8'
> [2015-09-01 16:35:31] ERROR[16566][C-0000000b]: cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (1045) Access denied for user 'freepbx'@'localhost' (using password: YES)
> [2015-09-01 16:35:31] ERROR[16566][C-0000000b]: cdr_odbc.c:148 odbc_log: Unable to retrieve database handle.  CDR failed.
> [2015-09-01 16:35:31] ERROR[16573][C-0000000b]: cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (1045) Access denied for user 'freepbx'@'localhost' (using password: YES)
> [2015-09-01 16:35:31] ERROR[16573][C-0000000b]: cdr_odbc.c:148 odbc_log: Unable to retrieve database handle.  CDR failed.
> [2015-09-01 16:35:41] ERROR[16376][C-0000000b]: cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (1045) Access denied for user 'freepbx'@'localhost' (using password: YES)
> [2015-09-01 16:35:41] ERROR[16376][C-0000000b]: cdr_odbc.c:148 odbc_log: Unable to retrieve database handle.  CDR failed.

Thanks for the help

Marbled · September 1, 2015, 5:28pm

Hi!

It looks like you somehow lost access to your database…

Maybe you could try the same thing that person did: Freepbxuser unable to connect to asteriskcdrdb ?

Please do a copy of those files before playing with them though and let us know how it turns out…

Have a nice day!

Nick

reikidude89 · September 2, 2015, 12:32pm

Hi

Thank you for the answer!!

Unfortunately it didn’t work.

i’ve tried to put the psw on cdr_mysql.conf and restart amportal and the system.
For testing today i’ve spin off the pbx and setup directly the trunk on my Yealink phone and it worked fine, but if it is connected on my pbx it still not ring.

any ideas?

( Sorry for my english, i’m learning )

reikidude89 · September 3, 2015, 8:19am

Hi!

i am not be able to call internal phones…

today i’ve just get a log verbose on schell with command: “rasterisk -vvvvvr” and i’ve tried to call an internal 102.
For some reason PBX lets a call to phones setted on the follow-me settings, strange because now the follow-me setting isn’t selected.

Can anyone help me?? i Hope that can i slove the problem without reinstall all PBX.

[root@PBX ~]# rasterisk -vvvvvr
Asterisk 11.10.2, Copyright (C) 1999 - 2013 Digium, Inc. and others.
Created by Mark Spencer <[email protected]>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for detail                                                                                                 s.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
=========================================================================
Connected to Asterisk 11.10.2 currently running on PBX (pid = 1756)
    -- Accepting AUTHENTICATED call from 192.168.201.51:
    --        > requested format = gsm,
    --        > requested prefs = (),
    --        > actual format = gsm,
    --        > host prefs = (ulaw|alaw|gsm|g729),
    --        > priority = mine
    -- Executing [102@from-internal:1] GotoIf("IAX2/209-14124", "0?ext-local,102,1") in new stack
    -- Executing [102@from-internal:2] Macro("IAX2/209-14124", "user-callerid,") in new stack
    -- Executing [s@macro-user-callerid:1] Set("IAX2/209-14124", "TOUCH_MONITOR=1441266799.59") in new stack
    -- Executing [s@macro-user-callerid:2] Set("IAX2/209-14124", "AMPUSER=209") in new stack
    -- Executing [s@macro-user-callerid:3] GotoIf("IAX2/209-14124", "0?report") in new stack
    -- Executing [s@macro-user-callerid:4] ExecIf("IAX2/209-14124", "0?Set(REALCALLERIDNUM=209)") in new stack
    -- Executing [s@macro-user-callerid:5] Set("IAX2/209-14124", "AMPUSER=209") in new stack
    -- Executing [s@macro-user-callerid:6] GotoIf("IAX2/209-14124", "0?limit") in new stack
    -- Executing [s@macro-user-callerid:7] Set("IAX2/209-14124", "AMPUSERCIDNAME=209 Cel Giovanni") in new stack
    -- Executing [s@macro-user-callerid:8] GotoIf("IAX2/209-14124", "0?report") in new stack
    -- Executing [s@macro-user-callerid:9] Set("IAX2/209-14124", "AMPUSERCID=209") in new stack
    -- Executing [s@macro-user-callerid:10] Set("IAX2/209-14124", "__DIAL_OPTIONS=tr") in new stack
    -- Executing [s@macro-user-callerid:11] Set("IAX2/209-14124", "CALLERID(all)="209 Cel Giovanni" <209>") in new stack
    -- Executing [s@macro-user-callerid:12] GotoIf("IAX2/209-14124", "0?limit") in new stack
    -- Executing [s@macro-user-callerid:13] ExecIf("IAX2/209-14124", "0?Set(GROUP(concurrency_limit)=209)") in new stack
    -- Executing [s@macro-user-callerid:14] GosubIf("IAX2/209-14124", "7?sub-ccss,s,1(from-internal,102)") in new stack
    -- Executing [s@sub-ccss:1] ExecIf("IAX2/209-14124", "0?Return()") in new stack
    -- Executing [s@sub-ccss:2] Set("IAX2/209-14124", "CCSS_SETUP=TRUE") in new stack
    -- Executing [s@sub-ccss:3] GosubIf("IAX2/209-14124", "0?monitor_config,1(from-internal,102):monitor_default,1(from-internal,102)") in new stack
    -- Executing [monitor_default@sub-ccss:1] GotoIf("IAX2/209-14124", "1?is_exten") in new stack
    -- Goto (sub-ccss,monitor_default,4)
    -- Executing [monitor_default@sub-ccss:4] Set("IAX2/209-14124", "CALLCOMPLETION(cc_monitor_policy)=generic") in new stack
    -- Executing [monitor_default@sub-ccss:5] Set("IAX2/209-14124", "CALLCOMPLETION(cc_max_monitors)=5") in new stack
    -- Executing [monitor_default@sub-ccss:6] Return("IAX2/209-14124", "TRUE") in new stack
    -- Executing [s@sub-ccss:4] GosubIf("IAX2/209-14124", "7?agent_config,1():agent_default,1()") in new stack
    -- Executing [agent_config@sub-ccss:1] Set("IAX2/209-14124", "CALLCOMPLETION(cc_agent_policy)=generic") in new stack
    -- Executing [agent_config@sub-ccss:2] Set("IAX2/209-14124", "CALLCOMPLETION(cc_offer_timer)=30") in new stack
    -- Executing [agent_config@sub-ccss:3] Set("IAX2/209-14124", "CALLCOMPLETION(ccbs_available_timer)=") in new stack
    -- Executing [agent_config@sub-ccss:4] Set("IAX2/209-14124", "CALLCOMPLETION(ccnr_available_timer)=") in new stack
    -- Executing [agent_config@sub-ccss:5] Set("IAX2/209-14124", "CALLCOMPLETION(cc_callback_macro)=ccss-default") in new stack
[2015-09-03 09:53:19] WARNING[16369][C-0000000f]: ccss.c:1000 ast_set_cc_callback_macro: Usage of cc_callback_macro is deprecated.  Please use cc_callback_sub instead.
    -- Executing [agent_config@sub-ccss:6] ExecIf("IAX2/209-14124", "1?Set(CALLCOMPLETION(cc_recall_timer)=)") in new stack
    -- Executing [agent_config@sub-ccss:7] ExecIf("IAX2/209-14124", "1?Set(CALLCOMPLETION(cc_max_agents)=)") in new stack
    -- Executing [agent_config@sub-ccss:8] ExecIf("IAX2/209-14124", "0?Set(CALLCOMPLETION(cc_agent_dialstring)=Local/209_102@from-ccss-)") in new stack
    -- Executing [agent_config@sub-ccss:9] Set("IAX2/209-14124", "CALLCOMPLETION(cc_callback_macro)=ccss-default") in new stack
[2015-09-03 09:53:19] WARNING[16369][C-0000000f]: ccss.c:1000 ast_set_cc_callback_macro: Usage of cc_callback_macro is deprecated.  Please use cc_callback_sub instead.
    -- Executing [agent_config@sub-ccss:10] Return("IAX2/209-14124", "") in new stack
    -- Executing [s@sub-ccss:5] Set("IAX2/209-14124", "DB(AMPUSER/209/ccss/last_number)=102") in new stack
    -- Executing [s@sub-ccss:6] Return("IAX2/209-14124", "") in new stack
    -- Executing [s@macro-user-callerid:15] ExecIf("IAX2/209-14124", "0?Set(CHANNEL(language)=)") in new stack
    -- Executing [s@macro-user-callerid:16] GotoIf("IAX2/209-14124", "0?continue") in new stack
    -- Executing [s@macro-user-callerid:17] ExecIf("IAX2/209-14124", "1?Set(__CALLEE_ACCOUNCODE=)") in new stack
    -- Executing [s@macro-user-callerid:18] Set("IAX2/209-14124", "__TTL=64") in new stack
    -- Executing [s@macro-user-callerid:19] GotoIf("IAX2/209-14124", "1?continue") in new stack
    -- Goto (macro-user-callerid,s,30)
    -- Executing [s@macro-user-callerid:30] Set("IAX2/209-14124", "CALLERID(number)=209") in new stack
    -- Executing [s@macro-user-callerid:31] Set("IAX2/209-14124", "CALLERID(name)=209 Cel Giovanni") in new stack
    -- Executing [s@macro-user-callerid:32] Set("IAX2/209-14124", "CDR(cnum)=209") in new stack
    -- Executing [s@macro-user-callerid:33] Set("IAX2/209-14124", "CDR(cnam)=209 Cel Giovanni") in new stack
    -- Executing [s@macro-user-callerid:34] Set("IAX2/209-14124", "CHANNEL(language)=en") in new stack
    -- Executing [102@from-internal:3] Set("IAX2/209-14124", "DIAL_OPTIONS=trI") in new stack
    -- Executing [102@from-internal:4] Set("IAX2/209-14124", "CONNECTEDLINE(num,i)=102") in new stack
    -- Executing [102@from-internal:5] Gosub("IAX2/209-14124", "sub-presencestate-display,s,1(102)") in new stack
    -- Executing [s@sub-presencestate-display:1] Goto("IAX2/209-14124", "state-available,1") in new stack
    -- Goto (sub-presencestate-display,state-available,1)
    -- Executing [state-available@sub-presencestate-display:1] Set("IAX2/209-14124", "PRESENCESTATE_DISPLAY=(Available)") in new stack
    -- Executing [state-available@sub-presencestate-display:2] Return("IAX2/209-14124", "") in new stack
    -- Executing [102@from-internal:6] Set("IAX2/209-14124", "CONNECTEDLINE(name)=102 Giovanni(Available)") in new stack
    -- Executing [102@from-internal:7] Set("IAX2/209-14124", "FM_DIALSTATUS=NOT_INUSE") in new stack
    -- Executing [102@from-internal:8] Set("IAX2/209-14124", "__EXTTOCALL=102") in new stack
    -- Executing [102@from-internal:9] Set("IAX2/209-14124", "__PICKUPMARK=102") in new stack
    -- Executing [102@from-internal:10] Macro("IAX2/209-14124", "blkvm-setifempty,") in new stack
    -- Executing [s@macro-blkvm-setifempty:1] GotoIf("IAX2/209-14124", "1?init") in new stack
    -- Goto (macro-blkvm-setifempty,s,4)
    -- Executing [s@macro-blkvm-setifempty:4] Set("IAX2/209-14124", "__BLKVM_CHANNEL=IAX2/209-14124") in new stack
    -- Executing [s@macro-blkvm-setifempty:5] Set("IAX2/209-14124", "SHARED(BLKVM,IAX2/209-14124)=TRUE") in new stack
    -- Executing [s@macro-blkvm-setifempty:6] Set("IAX2/209-14124", "GOSUB_RETVAL=TRUE") in new stack
    -- Executing [s@macro-blkvm-setifempty:7] MacroExit("IAX2/209-14124", "") in new stack
    -- Executing [102@from-internal:11] GotoIf("IAX2/209-14124", "1?skipov") in new stack
    -- Goto (from-internal,102,14)
    -- Executing [102@from-internal:14] Set("IAX2/209-14124", "RRNODEST=") in new stack
    -- Executing [102@from-internal:15] Set("IAX2/209-14124", "__NODEST=102") in new stack
    -- Executing [102@from-internal:16] GosubIf("IAX2/209-14124", "0?sub-fmsetcid,s,1()") in new stack
    -- Executing [102@from-internal:17] Set("IAX2/209-14124", "RecordMethod=Group") in new stack
    -- Executing [102@from-internal:18] Gosub("IAX2/209-14124", "sub-record-check,s,1(exten,102,)") in new stack
    -- Executing [s@sub-record-check:1] GotoIf("IAX2/209-14124", "0?initialized") in new stack
    -- Executing [s@sub-record-check:2] Set("IAX2/209-14124", "__REC_STATUS=INITIALIZED") in new stack
    -- Executing [s@sub-record-check:3] Set("IAX2/209-14124", "NOW=1441266800") in new stack
    -- Executing [s@sub-record-check:4] Set("IAX2/209-14124", "__DAY=03") in new stack
    -- Executing [s@sub-record-check:5] Set("IAX2/209-14124", "__MONTH=09") in new stack
    -- Executing [s@sub-record-check:6] Set("IAX2/209-14124", "__YEAR=2015") in new stack
    -- Executing [s@sub-record-check:7] Set("IAX2/209-14124", "__TIMESTR=20150903-095320") in new stack
    -- Executing [s@sub-record-check:8] Set("IAX2/209-14124", "__FROMEXTEN=209") in new stack
    -- Executing [s@sub-record-check:9] Set("IAX2/209-14124", "__MON_FMT=wav") in new stack
    -- Executing [s@sub-record-check:10] NoOp("IAX2/209-14124", "Recordings initialized") in new stack
    -- Executing [s@sub-record-check:11] ExecIf("IAX2/209-14124", "1?Set(ARG3=dontcare)") in new stack
    -- Executing [s@sub-record-check:12] Set("IAX2/209-14124", "REC_POLICY_MODE_SAVE=") in new stack
    -- Executing [s@sub-record-check:13] ExecIf("IAX2/209-14124", "0?Set(REC_STATUS=NO)") in new stack
    -- Executing [s@sub-record-check:14] GotoIf("IAX2/209-14124", "5?checkaction") in new stack
    -- Goto (sub-record-check,s,17)
    -- Executing [s@sub-record-check:17] GotoIf("IAX2/209-14124", "1?sub-record-check,exten,1") in new stack
    -- Goto (sub-record-check,exten,1)
    -- Executing [exten@sub-record-check:1] NoOp("IAX2/209-14124", "Exten Recording Check between 209 and 102") in new stack
    -- Executing [exten@sub-record-check:2] Set("IAX2/209-14124", "CALLTYPE=internal") in new stack
    -- Executing [exten@sub-record-check:3] ExecIf("IAX2/209-14124", "0?Set(CALLTYPE=)") in new stack
    -- Executing [exten@sub-record-check:4] Set("IAX2/209-14124", "CALLEE=dontcare") in new stack
    -- Executing [exten@sub-record-check:5] ExecIf("IAX2/209-14124", "0?Set(CALLEE=dontcare)") in new stack
    -- Executing [exten@sub-record-check:6] GotoIf("IAX2/209-14124", "0?callee") in new stack
    -- Executing [exten@sub-record-check:7] GotoIf("IAX2/209-14124", "1?caller") in new stack
    -- Goto (sub-record-check,exten,13)
    -- Executing [exten@sub-record-check:13] Set("IAX2/209-14124", "RECMODE=dontcare") in new stack
    -- Executing [exten@sub-record-check:14] ExecIf("IAX2/209-14124", "0?Set(RECMODE=dontcare)") in new stack
    -- Executing [exten@sub-record-check:15] ExecIf("IAX2/209-14124", "1?Set(RECMODE=dontcare)") in new stack
    -- Executing [exten@sub-record-check:16] Gosub("IAX2/209-14124", "recordcheck,1(dontcare,internal,102)") in new stack
    -- Executing [recordcheck@sub-record-check:1] NoOp("IAX2/209-14124", "Starting recording check against dontcare") in new stack
    -- Executing [recordcheck@sub-record-check:2] Goto("IAX2/209-14124", "dontcare") in new stack
    -- Goto (sub-record-check,recordcheck,3)
    -- Executing [recordcheck@sub-record-check:3] Return("IAX2/209-14124", "") in new stack
    -- Executing [exten@sub-record-check:17] Return("IAX2/209-14124", "") in new stack
    -- Executing [102@from-internal:19] Set("IAX2/209-14124", "RingGroupMethod=ringallv2") in new stack
    -- Executing [102@from-internal:20] Set("IAX2/209-14124", "_FMGRP=102") in new stack
    -- Executing [102@from-internal:21] GotoIf("IAX2/209-14124", "0?doconfirm") in new stack
    -- Executing [102@from-internal:22] Macro("IAX2/209-14124", "dial,17,trI,102-*NUM_MOBILE_CEL1*#") in new stack
    -- Executing [s@macro-dial:1] GotoIf("IAX2/209-14124", "1?dial") in new stack
    -- Goto (macro-dial,s,3)
    -- Executing [s@macro-dial:3] AGI("IAX2/209-14124", "dialparties.agi") in new stack
    -- Launched AGI Script /var/lib/asterisk/agi-bin/dialparties.agi
 dialparties.agi: Starting New Dialparties.agi
 dialparties.agi: Caller ID name is '209 Cel Giovanni' number is '209'
       > dialparties.agi: USE_CONFIRMATION:  'FALSE'
       > dialparties.agi: RINGGROUP_INDEX:   ''
 dialparties.agi: Methodology of ring is  'ringallv2'
    -- dialparties.agi: Added extension 102 to extension map
    -- dialparties.agi: Added extension *NUM_MOBILE_CEL1*# to extension map
       > dialparties.agi: got fmgrp_prering: 7, fmgrp_grptime: 10
       > dialparties.agi: fmgrp_totalprering: 17
       > dialparties.agi: found extension in pre-ring and array
       > dialparties.agi: ringallv2 ring times: REALPRERING: 17, PRERING: 7
 dialparties.agi: Extension 102 has call forward set to *NUM_MOBILE_CEL2*
       > dialparties.agi: Primary ext is CF so disabling mastermode if it was set
    -- dialparties.agi: Extension *NUM_MOBILE_CEL1*# cf is disabled
       > dialparties.agi: extnum *NUM_MOBILE_CEL2*# has:  cw: 0; hascfb: 0 [] hascfu: 0 []
       > dialparties.agi: Built External dialstring component for *NUM_MOBILE_CEL2*: Local/*NUM_MOBILE_CEL2*@from-internal/n
       > dialparties.agi: extnum *NUM_MOBILE_CEL1*# has:  cw: 0; hascfb: 0 [] hascfu: 0 []
       > dialparties.agi: Built External dialstring component for *NUM_MOBILE_CEL1*: Local/*NUM_MOBILE_CEL1*@from-internal/n
    -- dialparties.agi: Filtered ARG3: *NUM_MOBILE_CEL2*-*NUM_MOBILE_CEL1*
       > dialparties.agi: NODEST: 102 adding M(auto-blkvm) to dialopts: trIM(auto-blkvm)
       > dialparties.agi: NODEST: 102 blkvm enabled macro already in dialopts: trIM(auto-blkvm)
    -- <IAX2/209-14124>AGI Script dialparties.agi completed, returning 0
    -- Executing [s@macro-dial:7] Dial("IAX2/209-14124", "Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal&Local/FMGL-*NUM_MOBILE_CEL1*#@from-internal,17,trIM(auto-blkvm)") in new stack
    -- Called Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal
    -- Called Local/FMGL-*NUM_MOBILE_CEL1*#@from-internal
    -- Executing [FMGL-*NUM_MOBILE_CEL1*#@from-internal:1] NoCDR("Local/FMGL-*NUM_MOBILE_CEL1*#@from-internal-00000009;2", "") in new stack
    -- Executing [FMGL-*NUM_MOBILE_CEL1*#@from-internal:2] Set("Local/FMGL-*NUM_MOBILE_CEL1*#@from-internal-00000009;2", "ENDLOOP=1441266807") in new stack
    -- Executing [FMPR-*NUM_MOBILE_CEL2*#@from-internal:1] NoCDR("Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal-00000008;2", "") in new stack
    -- Executing [FMPR-*NUM_MOBILE_CEL2*#@from-internal:2] Set("Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal-00000008;2", "RingGroupMethod=") in new stack
    -- Executing [FMPR-*NUM_MOBILE_CEL2*#@from-internal:3] Set("Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal-00000008;2", "USE_CONFIRMATION=") in new stack
    -- Executing [FMGL-*NUM_MOBILE_CEL1*#@from-internal:3] GotoIf("Local/FMGL-*NUM_MOBILE_CEL1*#@from-internal-00000009;2", "0?dodnd") in new stack
    -- Executing [FMGL-*NUM_MOBILE_CEL1*#@from-internal:4] Wait("Local/FMGL-*NUM_MOBILE_CEL1*#@from-internal-00000009;2", "1") in new stack
    -- Executing [FMPR-*NUM_MOBILE_CEL2*#@from-internal:4] Set("Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal-00000008;2", "RINGGROUP_INDEX=") in new stack
    -- Executing [FMPR-*NUM_MOBILE_CEL2*#@from-internal:5] Macro("Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal-00000008;2", "simple-dial,*NUM_MOBILE_CEL2*#,17") in new stack
    -- Executing [s@macro-simple-dial:1] Set("Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal-00000008;2", "__EXTTOCALL=*NUM_MOBILE_CEL2*#") in new stack
    -- Executing [s@macro-simple-dial:2] Set("Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal-00000008;2", "RT=17") in new stack
    -- Executing [s@macro-simple-dial:3] Set("Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal-00000008;2", "CFUEXT=") in new stack
    -- Executing [s@macro-simple-dial:4] Set("Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal-00000008;2", "CFBEXT=") in new stack
    -- Executing [s@macro-simple-dial:5] Set("Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal-00000008;2", "CWI_TMP=") in new stack
    -- Executing [s@macro-simple-dial:6] Macro("Local/FMPR-*NUM_MOBILE_CEL2*#@from-internal-00000008;2", "dial-one,17,tr,*NUM_MOBILE_CEL2*#") in new stack

Thank you very much.

Marbled · September 4, 2015, 1:42pm

Hi!

Don’t worry about your English, it’s perfectly fine…

(Please take this with a grain of salt though, it’s not my mother tongue either… )

As far as I know what FreePBX does is keep its configuration in a database (MySQL or maybe MariaDB) and when you apply your settings it regenerate the configuration files read by Asterisk.

For some reason it looks like your database password was changed (Did you by any chance restore from another server or something like that? I had a similar problem when I did…).

One of those password is also present in the database itself, maybe that one is wrong too…

Please take a look at this post: Unable to apply config after restore from backup - #5 by stiadmin

Replace the update in that post with this one:

update freepbx_settings SET value = ‘MY_DATABASE_PASSWORD’ WHERE keyword = ‘CDRDBPASS’;

MY_DATABASE_PASSWORD is the password you got from freepbx.conf and when you connect to your datatabase using the command described in the post I referred you to if it asks for a password provide the one from freepbx.conf…

I hope you have backups though…

Have a nice day!

Nick

reikidude89 · September 4, 2015, 3:13pm

IT WORKED !!!
INCREDIBLEEEEEEEEE THANK YOUUUUU

After that, the error about cdr access disappeared

The “problem” is that the exstensions not work but if i delete and re-create again any exstension all will work fine …

Thank you Nick

Marbled · September 4, 2015, 5:11pm

You are welcome…

You might want to investigate why your password was changed though but if it happens again you know what to do now…

(In my case it was a restore to a PC I had reinstalled from scratch…)

There was probably a way to have it regenerate the configuration files correctly without needing to recreate the extensions but I am glad it worked out Ok for you…

Have a nice day!

Nick