Vicidial mysql repair command / goautodial mysql repair command below are the possible issue faced while db/mysql corrupted 1. your session has been disabled 2. Autodial calls not landing to Agents. 3. realtime report not updating properly 4. agent error Run the below command as ssh shell ie: from putty mysqlcheck -u root -p –auto-repair ..
Category : Asterisk
install phpMyAdmin easily on Elastix if it isn’t installed: yum install -y phpmyadmin Then edit the file /etc/httpd/conf.d/phpMyAdmin.conf Add the line “Allow from all” to this entry so it ends up looking like this: Order Deny,Allow Deny from All Allow from 127.0.0.1 Allow from All Allow from ::1 Then type /etc/init.d/httpd restart Then you can ..
http://trixbox.org/forums/trixbox-forums/open-discussion/change-default-sql-password-freepbx-version-2-6 How to Change MySQL passwords: Follow each step in order ! Step 1) mysql -u root –p [ENTER] Step 2) Enter password: passw0rd [ENTER] Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3743 to server version: 5.0.22 Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to ..
Notes on FreePBX, IncrediblePBX, and the like. Installation Copy the ISO to the SDHC card Download IncrediblePBX for Pi. See http://nerdvittles.com/?p=3026 Unpack the tarball. Put the SDHC card in the card reader (assumes Linux). Run the make-sdhc script that came out of the tarball. Put the Pi on the network For security reasons, do not ..
Here’s the source for a php/agi file and dialplan sample I made, which can help you implement what you need : #extensions.conf exten => 12345,1,Goto(dtmf-recording,${EXTEN},1) [dtmf-recording] exten => _X.,1,Answer exten => _X.,2,Set(TIMEOUT(digits)=5) exten => _X.,3,Set(TIMEOUT(response)=10) exten => _X.,4,Set(TIMESTAMP=${STRFTIME(${EPOCH},,%Y%m%d-%H%M%S)}) exten => _X.,n,Read(DTMF|/var/lib/asterisk/agi-bin/sounds/whatever) exten => _X.,n,Hangup exten => h,1,Deadagi(agi-bin/report_dtmf.php|${TIMESTAMP}|${DTMF}) ————————————————— report_dtmf.php : <?php set_time_limit(30); require_once “phpagi.php”; declare(ticks ..
This campaign has zero leads in the dial hopper This campaign has 0 leads in the dial hopper ! This campaign has zero leads in the dial hopper No Leads in the Hopper to dial Follow the below step to get rid of the above error /problem ..
vicidial_log Field Name Description Location uniqueid unique id for record lead_id Lead Identifier /vicidial/admin_search_lead.php list_id List Name vicidial/admin.php?ADD=100 campaign_id Campaign Name vicidial/admin.php?ADD=10 call_date Call Date and Time /vicidial/user_stats.php?user= start_epoch Start of Call end_epoch End of Call length_in_sec Length of Call in seconds /vicidial/user_stats.php?user= status Dispositioned Status given at end of call Note this may no ..
recording_log Field Name Description Location recording_id Primary Key for this table channel asterisk channel when call was live vicidial/admin_modify_lead.php?lead_id=#### server_ip IP address of server user is connected to extension could be callerid of the client or extension call was ultimately sent to start_time start time of call start_epoch start time of call in unix epoch ..
vicidial_agent_log Field Name Description Location agent_log_id Primary Key for this table user User Name ID field vicidial/AST_agent_time_detail.php server_ip IP address of server user is connected to vicidial/AST_usergroup_login_report.php event_time Time logged for start of event or call lead_id link to vicidial_list.lead_id campaign_id Campaign user is logged into /vicidial/AST_agent_time_detail.php pause_epoch start of agent pause time pause_sec length ..
vicidial_closer_log Field Name Description Location closecallid closed call table Primary key lead_id ID of Lead vicidial/admin_modify_lead.php?lead_id= list_id ID of List vicidial/admin_modify_lead.php?lead_id= campaign_id Alpha Numeric Campaign ID from Vicidial Campaigns call_date Date and Time call was made start_epoch Start of Call Time end_epoch End of Call Time length_in_sec Total Length of call in seconds vicidial/AST_agent_performance_detail.php status ..
Recent Comments