vicidial server replication

Yes, we have dozens of clients using master -> slave database replication. It's great for a backup solution on 24/7 operating call centers, as well as warm spare and running reports.

http://www.vicidial.org/VICIDIALforum/viewtopic.php?f=4&t=37688

Custom Fields

Custom Fields

Post a reply

 

3 posts • Page 1 of 1

Custom Fields

by kennow » Tue Sep 12, 2017 2:36 pm

VERSION: 2.14-621a
BUILD: 170717-1444 
© 2017 ViciDial Group

Created two Custom Fields and in the summary of fields box one label is blue and one label is red. Is the red label color a sign of a problem?
Thanks
Kennow

kennow

 

Posts: 31

Joined: Fri Aug 11, 2017 9:57 am

Top

Re: Custom Fields

by mflorell » Tue Sep 12, 2017 2:41 pm

Red means you chose an existing vicidial_list field label. Blue means it's a new custom field.

mflorell

Site Admin

 

Posts: 16095

Joined: Wed Jun 07, 2006 2:45 pm

Location: Florida

Top

Re: Custom Fields

by williamconley » Sat Sep 16, 2017 2:02 am

kennow wrote:Is the red label color a sign of a problem?

It's a warning that this field will be *used* because it already exists. It will *not* be created. Not a bad thing, as long as you want to use an existing field. But if you wanted to create a new field named address2, you can't. Name it something else, such as addresstwo.

vicidial crontab entries

crontab -l 
### recording mixing/compressing/ftping scripts 
0,3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57 * * * * /usr/share/astguiclient/AST_CRON_audio_1_move_mix.pl 
#0,3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57 * * * * /usr/share/astguiclient/AST_CRON_audio_1_move_VDonly.pl 
1,4,7,10,13,16,19,22,25,28,31,34,37,40,43,46,49,52,55,58 * * * * /usr/share/astguiclient/AST_CRON_audio_2_compress.pl --MP3 
#2,5,8,11,14,17,20,23,26,29,32,35,38,41,44,47,50,53,56,59 * * * * /usr/share/astguiclient/AST_CRON_audio_3_ftp.pl --MP3 

### keepalive script for astguiclient processes 
* * * * * /usr/share/astguiclient/ADMIN_keepalive_ALL.pl 

### kill Hangup script for Asterisk updaters 
* * * * * /usr/share/astguiclient/AST_manager_kill_hung_congested.pl 

### updater for voicemail 
* * * * * /usr/share/astguiclient/AST_vm_update.pl 

### updater for conference validator 
* * * * * /usr/share/astguiclient/AST_conf_update.pl 

### flush queue DB table every hour for entries older than 1 hour 
11 * * * * /usr/share/astguiclient/AST_flush_DBqueue.pl -q 

### fix the vicidial_agent_log once every hour 
33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl 

### updater for VICIDIAL hopper 
* * * * * /usr/share/astguiclient/AST_VDhopper.pl -q 

### adjust the GMT offset for the leads in the vicidial_list table 
1 17,7 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug --postal-code-gmt 

### reset several temporary-info tables in the database 
2 17 * * * /usr/share/astguiclient/AST_reset_mysql_vars.pl 

### optimize the database tables within the asterisk database 
3 17 * * * /usr/share/astguiclient/AST_DB_optimize.pl 

### VICIDIAL agent time log weekly summary report generation 
2 0 * * 0 /usr/share/astguiclient/AST_agent_week.pl 

### remove old recordings more than 7 days old 
#24 0 * * * /usr/bin/find /var/spool/asterisk/monitorDONE -maxdepth 2 -type f -mtime +2 -print | xargs rm -f 

### remove old vicidial logs and asterisk logs more than 2 days old 
28 0 * * * /usr/bin/find /var/log/astguiclient -maxdepth 1 -type f -mtime +2 -print | xargs rm -f 
29 0 * * * /usr/bin/find /var/log/asterisk -maxdepth 3 -type f -mtime +2 -print | xargs rm -f 

### Reboot for good measure 
#45 6 * * * /sbin/reboot

3-Way Call Outbound CallerID

Outbound Transfer

by williamconley » Thu Sep 07, 2017 8:37 pm

rheymzkilove wrote:Thanks william, 3-Way Call Outbound CallerID : change from Campaign to CUSTOMER  all good

http://www.vicidial.org/VICIDIALforum/viewtopic.php?f=4&t=37615

Losing CID

Losing CID

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Post a reply

 

2 posts • Page 1 of 1

Losing CID

by tim33 » Sun Aug 27, 2017 10:02 pm

Web based GUI:
VERSION: 2.12-560a
BUILD: 160617-1427

Command line info:
ViciBox v.7.0.3-160505

In my campaign I have set Drop Action to CALLMENU. Dropped outbound calls that then go into a queue from the CALLMENU do not pass CID to the agent. Instead they pass something like Y8281228540000057045.

When customers call inbound and get the Callmenu the CID is passed to the agent.

The Callmenu settings for 1 are Route: Ingroup, Handle method: CID

tim33

 

Posts: 34

Joined: Thu Jul 07, 2016 1:15 am

Top

Re: Losing CID

by mflorell » Mon Aug 28, 2017 5:03 am

You need to set the handle method to CLOSER

Soundboard Delay After about an hour of use

Re: Soundboard Delay After about an hour of use

by mflorell » Mon Jan 23, 2017 6:18 pm

How many records are in the vicidial_manager table when you are having these issues? (select count(*) from vicidial_manager;)

Fix

The table is pruned every hour, but you can adjust a crontab entry to make it trim every 15 minutes if you like:

### flush queue DB table every hour for entries older than 1 hour (changed to 15 minutes)
11,26,41,56 * * * * /usr/share/astguiclient/AST_flush_DBqueue.pl --seconds=900 -q

mflorell

Site Admin

 

Posts: 16036

Joined: Wed Jun 07, 2006 2:45 pm

Location: Florida

vicidial DB structure

vicidial DB structure  http://viciwiki.com/index.php/Vicidial_Database_Structure