How to reset recording counter

[rdipen]

Good day everyone,

We are using:
ViciBox V.10.0.0 210901
VICIDial version: 2.14b0.5
Asterisk #: 13.38.2
SVN: 3693
On physical computer Dell precision T1650 Intel i5, 16G RAM, 2 TB HDD

Problem:
I am trying to record a greetings for a campaign by dialing 8168 > password> pressing 1 to save that greeting > at the last it gives me a number that starts with 170200XXX I was hoping if there is a way to reset counter for those recordings to 85100xxxx... Now I have tried using " mysql -u cron -p1234 asterisk -e "update system_settings set rec_prompt_count='85100xxx" suggested by someone in one of the eflo forum and when I check that on VICI ADMIN> Sytem setting it does say 85100xxx but for some reason I might have changed wrong counter as that didn't work with the problem that I have.

[carpenox]

Check this out in detail view of campaign, it's how you set the recorded file name

[rdipen]

Thank you for reverting back but it says " This feature on works if I allow campaign Recording Policy needs to be "ON DEMAND" or "ALLCALLS".. We have it set to use NEVER also even if we make it ALLCALLS wouldn't I have to change Campaign Recording format every time I create new campaign?
Please forgive me for stupid question

[rdipen]

This isn't about campaign call recording, it's about inserting a recording into the audio store. It should by default be recording as 851XXXXXXXX, but it is not -- where can I correct this on a server level? Any idea @carpenox

[mflorell]

The system_settings.rec_prompt_count should control that. You can edit it manually with the MySQL CLI client.

[rdipen]

We have tried that before and no luck even after editing with MYSQL CLI client..

[mflorell]

When you use the feature, what does the Asterisk CLI output look like(set the Server's AGI Output to BOTH first)?

[rdipen]

Umm I am not really sure on how to adjust Server's AGI Output to BOTH?

[RBecker]

Umm I am not really sure on how to adjust Server's AGI Output to BOTH?

Admin -> Servers -> Click on the server you are dialing into -> find the AGI Output option and set it to BOTH. See https://i.imgur.com/QH9xCP1.png

[rdipen]

Thank you @RBecker
]Is this something you're looking for @mflorell ?

-----------------------------------------------------------------------------

[May 19 08:05:02] WARNING[2360][C-00006fe0]: chan_sip.c:34208 process_crypto: Ignoring crypto attribute in SDP because RTP transport is insecure

[May 19 08:05:02] -- Executing [8186@defaultlog:1] AGI("SIP/298-000088f3", "agi-NVA_recording.agi,BOTH------Y---Y---Y") in new stack
[May 19 08:05:02] -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-NVA_recording.agi
[May 19 08:05:02] -- AGI Script Executing Application: (Monitor) Options: (wav,/var/spool/asterisk/monitor/MIX/20230519080502_298_8186)
[May 19 08:05:02] -- <SIP/298-000088f3>AGI Script agi-NVA_recording.agi completed, returning 0
[May 19 08:05:02] -- Executing [8186@defaultlog:2] Goto("SIP/298-000088f3", "default,8186,1") in new stack
[May 19 08:05:02] -- Goto (default,8186,1)
[May 19 08:05:02] -- Channel 'SIP/298-000088f3' sent to invalid extension: context,exten,priority=default,8186,1
[May 19 08:05:02] -- Executing [i@default:1] Playback("SIP/298-000088f3", "invalid") in new stack
[May 19 08:05:06] WARNING[15566][C-00006fe0]: func_hangupcause.c:140 hangupcause_read: Unable to find information for channel
[May 19 08:05:06] -- Executing [h@default:1] AGI("SIP/298-000088f3", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0--------------------)") in new stack
[May 19 08:05:06] -- <SIP/298-000088f3>AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... ----------) completed, returning 0
[May 19 08:05:09] == Using SIP RTP CoS mark 5
[May 19 08:05:09] WARNING[2360][C-00006fe1]: chan_sip.c:34208 process_crypto: Ignoring crypto attribute in SDP because RTP transport is insecure
[May 19 08:05:10] -- Executing [8168@defaultlog:1] AGI("SIP/298-000088f4", "agi-NVA_recording.agi,BOTH------Y---Y---Y") in new stack
[May 19 08:05:10] -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-NVA_recording.agi
[May 19 08:05:10] -- AGI Script Executing Application: (Monitor) Options: (wav,/var/spool/asterisk/monitor/MIX/20230519080510_298_8168)
[May 19 08:05:10] -- <SIP/298-000088f4>AGI Script agi-NVA_recording.agi completed, returning 0
[May 19 08:05:10] -- Executing [8168@defaultlog:2] Goto("SIP/298-000088f4", "default,8168,1") in new stack
[May 19 08:05:10] -- Goto (default,8168,1)
[May 19 08:05:10] -- Executing [8168@default:1] Answer("SIP/298-000088f4", "") in new stack
[May 19 08:05:10] > 0x7f0a5808a840 -- Strict RTP switching to RTP target address 192.168.2.221:59404 as source
[May 19 08:05:10] -- Executing [8168@default:2] AGI("SIP/298-000088f4", "agi-record_prompts.agi,gsm-----720000") in new stack
[May 19 08:05:10] -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-record_prompts.agi
[May 19 08:05:10] -- <SIP/298-000088f4> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[May 19 08:05:10] -- <SIP/298-000088f4> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[May 19 08:05:10] -- <SIP/298-000088f4> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[May 19 08:05:10] -- <SIP/298-000088f4> Playing 'ld_welcome_pin_number.gsm' (escape_digits=123456789) (sample_offset 0) (language 'en')
[May 19 08:05:14] DTMF[15579][C-00006fe1]: channel.c:4247 __ast_read: DTMF begin '4' received on SIP/298-000088f4
[May 19 08:05:14] DTMF[15579][C-00006fe1]: channel.c:4251 __ast_read: DTMF begin ignored '4' on SIP/298-000088f4
[May 19 08:05:14] DTMF[15579][C-00006fe1]: channel.c:4133 __ast_read: DTMF end '4' received on SIP/298-000088f4, duration 140 ms
[May 19 08:05:14] DTMF[15579][C-00006fe1]: channel.c:4222 __ast_read: DTMF end passthrough '4' on SIP/298-000088f4
[May 19 08:05:14] DTMF[15579][C-00006fe1]: channel.c:4247 __ast_read: DTMF begin '3' received on SIP/298-000088f4
[May 19 08:05:14] DTMF[15579][C-00006fe1]: channel.c:4251 __ast_read: DTMF begin ignored '3' on SIP/298-000088f4
[May 19 08:05:15] > 0x7f0a5808a840 -- Strict RTP learning complete - Locking on source address 192.168.2.221:59404
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4133 __ast_read: DTMF end '3' received on SIP/298-000088f4, duration 160 ms
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4222 __ast_read: DTMF end passthrough '3' on SIP/298-000088f4
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4247 __ast_read: DTMF begin '2' received on SIP/298-000088f4
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4251 __ast_read: DTMF begin ignored '2' on SIP/298-000088f4
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4133 __ast_read: DTMF end '2' received on SIP/298-000088f4, duration 120 ms
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4222 __ast_read: DTMF end passthrough '2' on SIP/298-000088f4
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4247 __ast_read: DTMF begin '1' received on SIP/298-000088f4
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4251 __ast_read: DTMF begin ignored '1' on SIP/298-000088f4
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4133 __ast_read: DTMF end '1' received on SIP/298-000088f4, duration 140 ms
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4222 __ast_read: DTMF end passthrough '1' on SIP/298-000088f4
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4247 __ast_read: DTMF begin '#' received on SIP/298-000088f4
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4251 __ast_read: DTMF begin ignored '#' on SIP/298-000088f4
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4133 __ast_read: DTMF end '#' received on SIP/298-000088f4, duration 180 ms
[May 19 08:05:15] DTMF[15579][C-00006fe1]: channel.c:4222 __ast_read: DTMF end passthrough '#' on SIP/298-000088f4
[May 19 08:05:15] -- <SIP/298-000088f4> Playing 'beep.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[May 19 08:05:16] -- <SIP/298-000088f4> Playing 'vm-rec-generic.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[May 19 08:05:16] WARNING[15223][C-00006fd3]: func_hangupcause.c:140 hangupcause_read: Unable to find information for channel
[May 19 08:05:20] -- <SIP/298-000088f4> Playing 'beep.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[May 19 08:05:23] DTMF[15579][C-00006fe1]: channel.c:4247 __ast_read: DTMF begin '#' received on SIP/298-000088f4
[May 19 08:05:23] DTMF[15579][C-00006fe1]: channel.c:4258 __ast_read: DTMF begin passthrough '#' on SIP/298-000088f4
[May 19 08:05:23] DTMF[15579][C-00006fe1]: channel.c:4133 __ast_read: DTMF end '#' received on SIP/298-000088f4, duration 180 ms
[May 19 08:05:23] DTMF[15579][C-00006fe1]: channel.c:4184 __ast_read: DTMF end accepted with begin '#' on SIP/298-000088f4
[May 19 08:05:23] DTMF[15579][C-00006fe1]: channel.c:4222 __ast_read: DTMF end passthrough '#' on SIP/298-000088f4
[May 19 08:05:23] -- <SIP/298-000088f4> Playing 'beep.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[May 19 08:05:23] -- <SIP/298-000088f4> Playing 'vm-review.gsm' (escape_digits=123456789) (sample_offset 0) (language 'en')
[May 19 08:05:26] DTMF[15579][C-00006fe1]: channel.c:4247 __ast_read: DTMF begin '1' received on SIP/298-000088f4
[May 19 08:05:26] DTMF[15579][C-00006fe1]: channel.c:4251 __ast_read: DTMF begin ignored '1' on SIP/298-000088f4
[May 19 08:05:26] DTMF[15579][C-00006fe1]: channel.c:4133 __ast_read: DTMF end '1' received on SIP/298-000088f4, duration 140 ms
[May 19 08:05:26] DTMF[15579][C-00006fe1]: channel.c:4222 __ast_read: DTMF end passthrough '1' on SIP/298-000088f4
[May 19 08:05:26] -- <SIP/298-000088f4> Playing 'auth-thankyou.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[May 19 08:05:27] -- <SIP/298-000088f4> Playing 'digits/1.gsm' (language 'en')
[May 19 08:05:28] -- <SIP/298-000088f4> Playing 'digits/7.gsm' (language 'en')
[May 19 08:05:29] -- <SIP/298-000088f4> Playing 'digits/0.gsm' (language 'en')
[May 19 08:05:30] -- <SIP/298-000088f4> Playing 'digits/2.gsm' (language 'en')
[May 19 08:05:30] -- <SIP/298-000088f4> Playing 'digits/0.gsm' (language 'en')
[May 19 08:05:31] -- <SIP/298-000088f4>AGI Script agi-record_prompts.agi completed, returning 4
[May 19 08:05:31] == Spawn extension (default, 8168, 2) exited non-zero on 'SIP/298-000088f4'
[May 19 08:05:31] WARNING[15579][C-00006fe1]: func_hangupcause.c:140 hangupcause_read: Unable to find information for channel
[May 19 08:05:31] -- Executing [h@default:1] AGI("SIP/298-000088f4", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0--------------------)") in new stack
[May 19 08:05:31] -- <SIP/298-000088f4>AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... ----------) completed, returning 0

----------------------------------------------------------------------

[rdipen]

When you use the feature, what does the Asterisk CLI output look like(set the Server's AGI Output to BOTH first)?

I still couldn't figure out have you got a chance to look at the logs that I sent?

[Update] When I manually update the rec_prompt_count value in the system_settings table through a SQL query, it is just temporarily reflecting the new value. However, once I record a message, VICIDIAL recalculates the prompt count and updates it accordingly, overriding the value that I set manually.

[mflorell]

The AGI output is still not included in the output you shared, and I did test this on two separate systems and could not replicate the issue.