vicidial.org

Posted: **Wed Jul 04, 2007 12:14 pm**

Hi there,

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...

Posted: **Wed Jul 04, 2007 12:15 pm**

Now that the main DB Server was in place it was time to replace asterisk on the small machine with some more performant hardware. So I installed Asterisk 1.4.5 on Debian 4.0 64bit with a te410p card (and a b410p which is yet to be configured). The better CPU and 4GB of RAM really make a huge difference!
But then again. something does not work any more: Voice Recordings.
Well, technichally they do work, but they get saved under the wrong filename. In the vicidial admin interface i set AGENT_CAMPAIGN_FULLDATE with ALLFORCE and recording exten 8310.
same as the old box where that worked. Now i get names like:

Code: Select all: 1183471145-Local-78600068@default-a2a9,1-in.gsm audio-in-580.gsm audio-out-580.gsm

in moitor/ORIG
and the same in DONE, but most of the files stay in ORIG?

maybe part of the problem is that i save the recordings to a nfs-share on the DB server? (which for some strange reason doesn't work most of the time as well and the files get saved locally in the folder that is actually supposed to be the mount point for the nfs, okay I think I need to clarify myself:)

/mnt/voicerec/ on DATABASE SERVER (10.20.30.2) is in exports.
/mnt/voicerec/ on ASTERISK SERVER (10.20.30.1) is mounted as 10.20.30.2:/mnt/voicerec /mnt/voicerec nfs rw,...
on the asterisk box. That seems to work for some time, but the next day it's not mounted any more and the files get saved under /mnt/voicerec/ locally. well, weird. so, the call recording names are a big problem for us, since we need them desperatly. Here is my extensions.conf and extensions-vicidial.conf from the new server:

Code: Select all: asterisk01:/etc/asterisk# cat extensions.conf [general] static=yes writeprotect=no autofallthrough=yes clearglobalvers=yes priorityjumping=no [globals] CONSOLE=Console/dsp TRUNK1=Zap/r0 TRUNK2=Zap/r1 TRUNK3=Zap/r2 TRUNK4=Zap/r3 [default] include => vicidial #include extensions-vicidial.conf #include extensions-agent.conf #include extensions-oldexten.conf asterisk01:/etc/asterisk#

Code: Select all: asterisk01:/etc/asterisk# cat extensions-vicidial.conf [vicidial] include => agent 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 => _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 => _XXXX0049NXXXXXX.,1,AGI(agi://127.0.0.1:4577/call_log) exten => _XXXX0049NXXXXXX.,n,Noop(Attempting call to ${EXTEN}) exten => _XXXX0049NXXXXXX.,n,DIAL(${TRUNK${EXTEN:0:1}}/${EXTEN:4},35,tTo) exten => _XXXX0049NXXXXXX.,n,DIAL(${TRUNK${EXTEN:1:1}}/${EXTEN:4},35,tTo) exten => _XXXX0049NXXXXXX.,n,DIAL(${TRUNK${EXTEN:2:1}}/${EXTEN:4},35,tTo) exten => _XXXX0049NXXXXXX.,n,DIAL(${TRUNK${EXTEN:3:1}}/${EXTEN:4},35,tTo) exten => _XXXX0049NXXXXXX.,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 asterisk01:/etc/asterisk#

ok, now there is only one more thing: the basic lead loader.
what exacly causes it to classify a lead as “bad”? And I recently loaded a list of 10000 leads, bll tells me that all 10000 are “good” and when i look at the list either with vicidial or phpmyadmin, there are only 9960 entries. So the rest of them are lost.

At this point i have to thank you for your patience to read through all of this. maybe someone already had similar issues and can give some tips. I'll be happy to provide you with additional information tomorrow.

regards,
tobiasm

Posted: **Wed Jul 04, 2007 7:15 pm**

are you sure the time is sync on those 2 servers?

Posted: **Thu Jul 05, 2007 4:54 am**

yes i'm sure. time on all servers is in sync

btw. it's 3 servers now. the apache still runs on the initial vicidial server.
That's how it should be.

Posted: **Thu Jul 05, 2007 11:02 am**

For the lead loading, do you have duplication check enabled?

Are any of the phone numbers less than 6 characters in length?

In the SVN codebase there have been several changes made to lead loading which may help you figure out what is being kicked out, if you want to upgrade to the development code.

Posted: **Fri Jul 06, 2007 9:14 am**

matt,

afaik i read in a post from you that you want to get the next release ready in August? If that's the case i'd rather wait for it, unless you tell me it's really safe to upgrade to svn, and if you can tell me what database changes you introduced.

thanks,
tobiasm

Posted: **Fri Jul 06, 2007 9:24 am**

are your database server and dialer on the same timezone in the Operating System?

Are they both ntp time-synced to the same source?

As for non-latin, there is a config option in admin.php -> Admin -> system settings you may want to set to "1"

1. the time on every server is set to SAST

2. they all sync to our router/firewall

3. the non-latin is already set to "1"

Posted: **Wed Jul 11, 2007 5:36 am**

I changed some of the default variables:

Code: Select all: # Settings for FastAGI logging server VARfastagi_log_min_servers => 3 VARfastagi_log_max_servers => 32 VARfastagi_log_min_spare_servers => 2 VARfastagi_log_max_spare_servers => 8 VARfastagi_log_max_requests => 1000 VARfastagi_log_checkfordead => 30 VARfastagi_log_checkforwait => 60

still no change with the wrong filenames...

tobias

vicidial.org

record names, agent stats, filter & others

record names, agent stats, filter & others