Skip to main content

Call Forwarding Alway Prompt

Posted by basisit on Thu, 03/12/2015

Good Morning,

we are trying to use the feature code *72 to activate call forwarding.

I have tried lot of time, but when I check the forwarding state with *96 it say no forwarding configured.

there are something to do?

the *72 is configured to call the script tl-callforward-prompt

exten => s,1,Answer
exten => s,n(start),Wait(1)
exten => s,n,Playback(tl/please-enter-your)
;exten => s,n,Playback(tl/extension)
exten => s,n,Playback(tl/then-press-pound)
exten => s,n,Read(source)
exten => s,n,Wait(1)
exten => s,n,Playback(tl/enter-target)
exten => s,n,Playback(tl/then-press-pound)
exten => s,n,Read(target)
exten => s,n,Wait(1)
exten => s,n(doit),Set(result=${TL_SET_FORWARDING(${tenant}${TL_DASH}${source},${ARG1},${target},1)})
exten => s,n,Playback(tl/call-fwd-${ARG1})
exten => s,n,Playback(tl/for)
exten => s,n,Playback(tl/extension)
exten => s,n,SayDigits(${source})
exten => s,n,Playback(tl/is-set-to)
exten => s,n,SayDigits(${target})
exten => s,n,Wait(1)
exten => s,n,Hangup

how it works?

for example how can I transfer call from extension 2001 to extension 2002?
we can transfer also to external number?

Thanks
Giuliano


Submitted by basisit on Thu, 03/12/2015 Permalink

I have check the some log

from the asterisk console i can see the following error:

[2015-03-12 12:07:39] WARNING[26613]: func_odbc.c:191 generic_execute: SQL Execute returned an error -1: HY000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Column 'user_id' cannot be null (74)
[2015-03-12 12:07:39] WARNING[26613]: func_odbc.c:199 generic_execute: SQL Exec Direct failed (-1)![call set_forwarding('001','', '', '1')]
[2015-03-12 12:07:39] WARNING[26613]: res_odbc.c:610 ast_odbc_direct_execute: SQL Execute error! Verifying connection to pbxconf [pbxconf]...
[2015-03-12 12:07:39] WARNING[26613]: func_odbc.c:191 generic_execute: SQL Execute returned an error -1: HY000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Column 'user_id' cannot be null (74)
[2015-03-12 12:07:39] WARNING[26613]: func_odbc.c:199 generic_execute: SQL Exec Direct failed (-1)![call set_forwarding('001','', '', '1')]
[2015-03-12 12:07:39] ERROR[26613]: func_odbc.c:542 acf_odbc_read: Unable to execute query [call set_forwarding('001','', '', '1')]
-- Executing [s@macro-tl-callforward-prompt:11] Set("SIP/Patton1-0000e77e", "result=") in new stack
-- Executing [s@macro-tl-callforward-prompt:12] Playback("SIP/Patton1-0000e77e", "tl/call-fwd-") in new stack
[2015-03-12 12:07:39] WARNING[26613]: file.c:666 ast_openstream_full: File tl/call-fwd- does not exist in any format
[2015-03-12 12:07:39] WARNING[26613]: file.c:957 ast_streamfile: Unable to open tl/call-fwd- (format 0x8 (alaw)): No such file or directory
[2015-03-12 12:07:39] WARNING[26613]: app_playback.c:479 playback_exec: ast_streamfile failed on SIP/Patton1-0000e77e for tl/call-fwd-

anybody encountered this error?

Regards
Giuliano

Submitted by basisit on Thu, 03/12/2015 Permalink

Other errors:

[2015-03-12 12:36:53] WARNING[30194]: file.c:666 ast_openstream_full: File tl/call-fwd- does not exist in any format
[2015-03-12 12:36:53] WARNING[30194]: file.c:957 ast_streamfile: Unable to open tl/call-fwd- (format 0x8 (alaw)): No such file or directory
[2015-03-12 12:36:53] WARNING[30194]: app_playback.c:479 playback_exec: ast_streamfile failed on SIP/Patton1-0000e8b6 for tl/call-fwd-

Regards
Giuliano

Submitted by thirdlane on Wed, 03/18/2015 Permalink

Hi Giuliano,

It appears that something may be seriously broken on your server. We do provide paid support