first of all: Since I have various problems with my installation of vicidial I decided to make one long post out of them, because it's not really necessary to make 4 up to 90% identical posts.
So this is the setup:
We startet out with a test installation of vicidial 2.0.3, asterisk 1.2.18 with digium te405p, and mysql 5.0 on an ubuntu 7.04 server edition.
On this machine, everything seemed to work really good. But it took a rather long time for the predictive dialler to put calls to the agents. Unfortunately, at this point it wasn't a testing environment any more, so wasn't able to install a second system from scratch but had to replace certain elements part by part.
ok here are some configuration details of this test installation:
mysql:
- Code: Select all
mysql> SHOW VARIABLES;
+---------------------------------+-----------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 5 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| expire_logs_days | 10 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | YES |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | YES |
| have_dynamic_loading | YES |
| have_example_engine | NO |
| have_federated_engine | YES |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_merge_engine | YES |
| have_ndbcluster | DISABLED |
| have_openssl | DISABLED |
| have_ssl | DISABLED |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| hostname | obelisk |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_rollback_on_timeout | OFF |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| large_page_size | 0 |
| large_pages | OFF |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_error | |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 104857600 |
| max_connect_errors | 10 |
| max_connections | 100 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| myisam_stats_method | nulls_unequal |
| ndb_autoincrement_prefetch_sz | 32 |
| ndb_force_send | ON |
| ndb_use_exact_count | ON |
| ndb_use_transactions | ON |
| ndb_cache_check_time | 0 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 1024 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /var/run/mysqld/mysqld.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 16777216 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| secure_file_priv | |
| server_id | 1 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_compressed_protocol | OFF |
| slave_load_tmpdir | /tmp/ |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| slow_launch_time | 2 |
| socket | /var/run/mysqld/mysqld.sock |
| sort_buffer_size | 2097144 |
| sql_big_selects | ON |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | SAST |
| table_cache | 64 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 8 |
| thread_stack | 131072 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | /tmp |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.38-Ubuntu_0ubuntu1-log |
| version_comment | Ubuntu 7.04 distribution |
| version_compile_machine | i486 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+-----------------------------+
228 rows in set (0.01 sec)
asterisk extensions.conf (I will omit the other .conf files for now, since i'm pretty shure they are ok anyway):
- Code: Select all
root@obelisk:/var/spool# cat /etc/asterisk/extensions.conf
[general]
static=yes
writeprotect=no
autofallthrough=yes
clearglobalvers=yes
priorityjumping=no
[globals]
CONSOLE=Console/dsp
TRUNK1=Zap/g0
TRUNK2=Zap/g1
TRUNK3=Zap/g2
TRUNK4=Zap/g3
[default]
exten => h,1,DeadAGI(agi://127.0.0.1:4577/call_log)
exten => h,2,DeadAGI(agi://127.0.0.1:4577/VD_hangup--HVcauses--PRI-----NODEBUG-----${HANGUPCAUSE}-----${DIALSTATUS}-----${DIALEDTIME}-----${ANSWEREDTIME}))
exten => 8600,1,Meetme(8600)
exten => 8601,1,Meetme(8601)
exten => 102,1,Playback(transfer,skip)
exten => 102,n,Dial(sip/test,20,tor)
exten => 102,n,Hangup()
exten => 300,1,Playback(transfer,skip)
exten => 300,n,Dial(sip/testagent,20,tor)
exten => 300,n,Hangup()
exten => 2001,1,Playback(transfer,skip)
exten => 2001,n,Dial(sip/firefly001,20,tor)
exten => 2001,n,Hangup()
exten => 2002,1,Playback(transfer,skip)
exten => 2002,n,Dial(sip/firefly002,20,tor)
exten => 2002,n,Hangup()
exten => 2003,1,Playback(transfer,skip)
exten => 2003,n,Dial(sip/firefly003,20,tor)
exten => 2003,n,Hangup()
exten => 2004,1,Playback(transfer,skip)
exten => 2004,n,Dial(sip/firefly004,20,tor)
exten => 2004,n,Hangup()
exten => 2005,1,Playback(transfer,skip)
exten => 2005,n,Dial(sip/firefly005,20,tor)
exten => 2005,n,Hangup()
exten => 2006,1,Playback(transfer,skip)
exten => 2006,n,Dial(sip/firefly006,20,tor)
exten => 2006,n,Hangup()
exten => 2007,1,Playback(transfer,skip)
exten => 2007,n,Dial(sip/firefly007,20,tor)
exten => 2007,n,Hangup()
exten => 2008,1,Playback(transfer,skip)
exten => 2008,n,Dial(sip/firefly008,20,tor)
exten => 2008,n,Hangup()
exten => 2009,1,Playback(transfer,skip)
exten => 2009,n,Dial(sip/firefly009,20,tor)
exten => 2009,n,Hangup()
exten => 2010,1,Playback(transfer,skip)
exten => 2010,n,Dial(sip/firefly010,20,tor)
exten => 2010,n,Hangup()
exten => 2011,1,Playback(transfer,skip)
exten => 2011,n,Dial(sip/firefly011,20,tor)
exten => 2011,n,Hangup()
exten => 2012,1,Playback(transfer,skip)
exten => 2012,n,Dial(sip/firefly012,20,tor)
exten => 2012,n,Hangup()
exten => 2013,1,Playback(transfer,skip)
exten => 2013,n,Dial(sip/firefly013,20,tor)
exten => 2013,n,Hangup()
exten => 2014,1,Playback(transfer,skip)
exten => 2014,n,Dial(sip/firefly014,20,tor)
exten => 2014,n,Hangup()
exten => 2015,1,Playback(transfer,skip)
exten => 2015,n,Dial(sip/firefly015,20,tor)
exten => 2015,n,Hangup()
exten => 2016,1,Playback(transfer,skip)
exten => 2016,n,Dial(sip/firefly016,20,tor)
exten => 2016,n,Hangup()
exten => 2017,1,Playback(transfer,skip)
exten => 2017,n,Dial(sip/firefly017,20,tor)
exten => 2017,n,Hangup()
;;;;;;;;;;;;;
exten => 2201,1,Playback(transfer,skip)
exten => 2201,n,Dial(sip/agent001,20,tor)
exten => 2201,n,Hangup()
exten => 2202,1,Playback(transfer,skip)
exten => 2202,n,Dial(sip/agent002,20,tor)
exten => 2202,n,Hangup()
exten => 2203,1,Playback(transfer,skip)
exten => 2203,n,Dial(sip/agent003,20,tor)
exten => 2203,n,Hangup()
exten => 2204,1,Playback(transfer,skip)
exten => 2204,n,Dial(sip/agent004,20,tor)
exten => 2204,n,Hangup()
exten => 2205,1,Playback(transfer,skip)
exten => 2205,n,Dial(sip/agent005,20,tor)
exten => 2205,n,Hangup()
exten => 2206,1,Playback(transfer,skip)
exten => 2206,n,Dial(sip/agent006,20,tor)
exten => 2206,n,Hangup()
exten => 2207,1,Playback(transfer,skip)
exten => 2207,n,Dial(sip/agent007,20,tor)
exten => 2207,n,Hangup()
exten => 2208,1,Playback(transfer,skip)
exten => 2208,n,Dial(sip/agent008,20,tor)
exten => 2208,n,Hangup()
exten => 2209,1,Playback(transfer,skip)
exten => 2209,n,Dial(sip/agent009,20,tor)
exten => 2209,n,Hangup()
exten => 2210,1,Playback(transfer,skip)
exten => 2210,n,Dial(sip/agent010,20,tor)
exten => 2210,n,Hangup()
;;;;;;;;;;;;;
exten => _949NXXXXX.,1,AGI(agi://127.0.0.1:4577/call_log)
exten => _949NXXXXX.,n,Noop(Attempting call to ${EXTEN} as 00${EXTEN:1})
exten => _949NXXXXX.,n,DIAL(${TRUNK1}/00${EXTEN:1},35,tTo)
exten => _949NXXXXX.,n,Hangup()
exten => _0049NXXXXX.,1,AGI(agi://127.0.0.1:4577/call_log)
exten => _0049NXXXXX.,n,Noop(Attempting call to ${EXTEN})
exten => _0049NXXXXX.,n,DIAL(${TRUNK1}/${EXTEN},35,tTo)
exten => _0049NXXXXX.,n,Hangup()
exten => _10049NXXXXX.,1,AGI(agi://127.0.0.1:4577/call_log)
exten => _10049NXXXXX.,n,Noop(Attempting call to ${EXTEN}:1)
exten => _10049NXXXXX.,n,DIAL(${TRUNK1}/${EXTEN:1},35,tTo)
exten => _10049NXXXXX.,n,Hangup()
exten => _20049NXXXXX.,1,AGI(agi://127.0.0.1:4577/call_log)
exten => _20049NXXXXX.,n,Noop(Attempting call to ${EXTEN};1)
exten => _20049NXXXXX.,n,DIAL(${TRUNK2}/${EXTEN:1},35,tTo)
exten => _20049NXXXXX.,n,Hangup()
exten => _30049NXXXXX.,1,AGI(agi://127.0.0.1:4577/call_log)
exten => _30049NXXXXX.,n,Noop(Attempting call to ${EXTEN};1)
exten => _30049NXXXXX.,n,DIAL(${TRUNK3}/${EXTEN:1},35,tTo)
exten => _30049NXXXXX.,n,Hangup()
exten => _40049NXXXXX.,1,AGI(agi://127.0.0.1:4577/call_log)
exten => _40049NXXXXX.,n,Noop(Attempting call to ${EXTEN}:1)
exten => _40049NXXXXX.,n,DIAL(${TRUNK4}/${EXTEN}:1,35,tTo)
exten => _40049NXXXXX.,n,Hangup()
exten => _90009.,1,Answer()
exten => _90009.,2,AGI(agi-VDADcloser.agi,${EXTEN}-----START)
exten => _90009.,3,Hangup()
;######------ START extensions.conf additions for direct zapbarges ------######
; ZapBarge direct channel extensions
exten => 8612001,1,ZapBarge(1)
exten => 8612002,1,ZapBarge(2)
exten => 8612003,1,ZapBarge(3)
exten => 8612004,1,ZapBarge(4)
exten => 8612005,1,ZapBarge(5)
exten => 8612006,1,ZapBarge(6)
exten => 8612007,1,ZapBarge(7)
exten => 8612008,1,ZapBarge(8)
exten => 8612009,1,ZapBarge(9)
exten => 8612010,1,ZapBarge(10)
exten => 8612011,1,ZapBarge(11)
exten => 8612012,1,ZapBarge(12)
exten => 8612013,1,ZapBarge(13)
exten => 8612014,1,ZapBarge(14)
exten => 8612015,1,ZapBarge(15)
exten => 8612016,1,ZapBarge(16)
exten => 8612017,1,ZapBarge(17)
exten => 8612018,1,ZapBarge(18)
exten => 8612019,1,ZapBarge(19)
exten => 8612020,1,ZapBarge(20)
exten => 8612021,1,ZapBarge(21)
exten => 8612022,1,ZapBarge(22)
exten => 8612023,1,ZapBarge(23)
exten => 8612024,1,ZapBarge(24)
;######------ END extensions.conf additions for direct zapbarges ------######
;######------ START extensions.conf changes for VD conf ------######
exten => _X48600XXX,1,MeetMeAdmin(${EXTEN:2},T,${EXTEN:0:1})
exten => _X48600XXX,2,Hangup
exten => _X38600XXX,1,MeetMeAdmin(${EXTEN:2},t,${EXTEN:0:1})
exten => _X38600XXX,2,Hangup
; SLD: Mute and unmute the conference
exten => _118600XXX,1,MeetMeAdmin(${EXTEN:2},M,${EXTEN:0:1})
exten => _118600XXX,2,Hangup
exten => _128600XXX,1,MeetMeAdmin(${EXTEN:2},m,${EXTEN:0:1})
exten => _128600XXX,2,Hangup
exten => 8300,1,Hangup
exten => _8600[012]XX,1,Meetme,${EXTEN}
; quiet entry and leaving conferences for VICIDIAL
exten => _78600XXX,1,Meetme,${EXTEN:1}|q
; quiet monitor extensions for meetme rooms (for room managers)
exten => _68600XXX,1,Meetme,${EXTEN:1}|mq
;######------ END extensions.conf changes for VD conf ------######
; this is used for recording conference calls, the client app sends the filename
; value as a callerID recordings go to /var/spool/asterisk/monitor (WAV)
exten => 8309,1,Answer
exten => 8309,2,Monitor(wav,${CALLERIDNAME})
exten => 8309,3,Wait,3600
exten => 8309,4,Hangup
; this is used for recording conference calls, the client app sends the filename
; value as a callerID recordings go to /var/spool/asterisk/monitor (GSM)
exten => 8310,1,Answer
exten => 8310,2,Monitor(gsm,${CALLERIDNAME})
exten => 8310,3,Wait,3600
exten => 8310,4,Hangup
;#### VDAD STANDARD TRANSFER ENTRIES ####
; VICIDIAL_auto_dialer transfer script for no-agent campaigns:
exten => 8364,1,Playback(sip-silence)
exten => 8364,2,AGI(agi://127.0.0.1:4577/call_log)
exten => 8364,3,AGI(agi-VDADtransferBROADCAST.agi,${EXTEN})
exten => 8364,4,AGI(agi-VDADtransferBROADCAST.agi,${EXTEN})
exten => 8364,5,Hangup
; VICIDIAL_auto_dialer transfer script:
exten => 8365,1,AGI(agi://127.0.0.1:4577/call_log)
exten => 8365,2,AGI(agi-VDADtransfer.agi,${EXTEN})
exten => 8365,3,AGI(agi-VDADtransfer.agi,${EXTEN})
exten => 8365,4,AGI(agi-VDADtransfer.agi,${EXTEN})
exten => 8365,5,Hangup
; VICIDIAL_auto_dialer transfer script SURVEY at beginning:
exten => 8366,1,AGI(agi://127.0.0.1:4577/call_log)
exten => 8366,2,AGI(agi-VDADtransferSURVEY.agi,${EXTEN})
exten => 8366,3,AGI(agi-VDADtransferSURVEY.agi,${EXTEN})
exten => 8366,4,AGI(agi-VDADtransferSURVEY.agi,${EXTEN})
exten => 8366,5,Hangup
; VICIDIAL_auto_dialer transfer script Load Balance Overflow:
exten => 8367,1,AGI(agi://127.0.0.1:4577/call_log)
exten => 8367,2,AGI(agi-VDAD_LO_transfer.agi,${EXTEN})
exten => 8367,3,AGI(agi-VDAD_LO_transfer.agi,${EXTEN})
exten => 8367,4,AGI(agi-VDAD_LO_transfer.agi,${EXTEN})
exten => 8367,5,Hangup
; VICIDIAL_auto_dialer transfer script Load Balanced:
exten => 8368,1,AGI(agi://127.0.0.1:4577/call_log)
exten => 8368,2,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8368,3,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8368,4,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8368,5,Hangup
; VICIDIAL_auto_dialer transfer script AMD with Load Balanced:
exten => 8369,1,AGI(agi://127.0.0.1:4577/call_log)
exten => 8369,2,AMD(3500|1500|300|5000|120|50|5|256)
exten => 8369,3,AGI(VD_amd.agi,${EXTEN})
exten => 8369,4,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8369,5,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8369,6,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8369,7,Hangup
; VICIDIAL auto-dial reminder script
exten => 8372,1,AGI(agi://127.0.0.1:4577/call_log)
exten => 8372,2,AGI(agi-VDADautoREMINDER.agi,${EXTEN})
exten => 8372,3,AGI(agi-VDADautoREMINDER.agi,${EXTEN})
exten => 8372,4,AGI(agi-VDADautoREMINDER.agi,${EXTEN})
exten => 8372,5,Hangup
;#### VDAD SIP UNREGISTERED TRANSFER ENTRIES ####
;#### Use these entries IN PLACE OF the entries above if you are using SIP trunks
;#### and are not registering your provider in sip.conf
; SLD: We are not using a SIP trunk, so these are commented out
;**; VICIDIAL_auto_dialer transfer script:
;**exten => 8365,1,Playback(sip-silence)
;**exten => 8365,2,AGI(agi://127.0.0.1:4577/call_log)
;**exten => 8365,3,AGI(agi-VDADtransfer.agi,${EXTEN})
;**exten => 8365,4,AGI(agi-VDADtransfer.agi,${EXTEN})
;**exten => 8365,5,Hangup
;**
;**; VICIDIAL_auto_dialer transfer script SURVEY at beginning:
;**exten => 8366,1,Playback(sip-silence)
;**exten => 8366,2,AGI(agi://127.0.0.1:4577/call_log)
;**exten => 8366,3,AGI(agi-VDADtransferSURVEY.agi,${EXTEN})
;**exten => 8366,4,AGI(agi-VDADtransferSURVEY.agi,${EXTEN})
;**exten => 8366,5,Hangup
;**
;**; VICIDIAL_auto_dialer transfer script Load Balance Overflow:
;**exten => 8367,1,Playback(sip-silence)
;**exten => 8367,2,AGI(agi://127.0.0.1:4577/call_log)
;**exten => 8367,3,AGI(agi-VDAD_LO_transfer.agi,${EXTEN})
;**exten => 8367,4,AGI(agi-VDAD_LO_transfer.agi,${EXTEN})
;**exten => 8367,5,Hangup
;**
;**; VICIDIAL_auto_dialer transfer script Load Balanced:
;**exten => 8368,1,Playback(sip-silence)
;**exten => 8368,2,AGI(agi://127.0.0.1:4577/call_log)
;**exten => 8368,3,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
;**exten => 8368,4,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
;**exten => 8368,5,Hangup
;**
;**; VICIDIAL_auto_dialer transfer script AMD with Load Balanced:
;**exten => 8369,1,Playback(sip-silence)
;**exten => 8369,2,AGI(agi://127.0.0.1:4577/call_log)
;**exten => 8369,3,AMD(3500|1500|300|5000|120|50|5|256)
;**exten => 8369,4,AGI(VD_amd.agi,${EXTEN})
;**exten => 8369,5,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
;**exten => 8369,6,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
;**exten => 8369,7,Hangup
;**
;**; VICIDIAL auto-dial reminder script
;**exten => 8372,1,Playback(sip-silence)
;**exten => 8372,2,AGI(agi://127.0.0.1:4577/call_log)
;**exten => 8372,3,AGI(agi-VDADautoREMINDER.agi,${EXTEN})
;**exten => 8372,4,AGI(agi-VDADautoREMINDER.agi,${EXTEN})
;**exten => 8372,5,Hangup
[from-sip]
include => default
;long distance to germany test
exten => _90049NXXXXX.,1,Dial(${TRUNK1}/${EXTEN:1},30,tTo)
exten => _90049NXXXXX.,2,Hangup()
exten => 500,1,Answer()
exten => 500,2,Wait(2)
exten => 500,3,Playback(hello-world)
exten => 500,4,Hangup()
everything really simple and working.
Now I installed a dedicated mysql database server on centos 5.0. dumped the database from the small server and imported it into the new one, and adjusted the astguiclient.conf. The VARIABLES were pretty much the same at that point, but from that day on the database did not act like the other one before.
We're experiencing 3 problems since the switch:
1. agent time sheet shows incorrect times (example):
- Code: Select all
VICIDIAL: Agent Time Sheet 2007-07-04 17:44:59
Time range: 2007-07-03 00:00:00 to 2007-07-03 23:59:59
---------- AGENT TIME SHEET: tobiasb - Tobias Blankenberg -------------
TOTAL CALLS TAKEN: 168
TALK TIME: 11:23:24 AVERAGE: 4:04
PAUSE TIME: 0:24:36 AVERAGE: 0:09
WAIT TIME: 1:10:48 AVERAGE: 0:25
WRAPUP TIME: 1:28:12 AVERAGE: 0:32
----------------------------------------------------------------
TOTAL ACTIVE AGENT TIME: 14:27:00
FIRST LOGIN: 2007-07-03 10:57:29
LAST LOG ACTIVITY: 2007-07-03 19:57:52
-----------------------------------------
TOTAL LOGGED-IN TIME: 9:00:36
amazing productivity eh?
btw this is taken from an agent who already has a month of experience with vicidial, and i can garantuee that he does log off correctly. It's not the agents fault.
2. adapt-* did not work at all [SOLVED].
turned out to be faulty hardware clock on the database server. doing ntp lookup every 2 minutes for now, so the delay does not sum up to more than 0.3 seconds.
3. special characters are displayed incorrectly. [kind-of-solved]
Looks like that issue is not really related to the database change, but i thought it was. caused me a lot of headache in the past few weeks.
Be sure to save your CSV files for the lead loader in Latin1 not UTF8... and don't waste your time by trying to convert the DB charset manually to utf like I did, i guess vicidial is designed to work on latin1.
to have the database in UTF8 and utf8_unicode_ci would be nice though. Could save lots of people lots of trouble...
I'll split this post up here, it's getting a little long...