- Code: Select all
**First Lets update OpenSuse to make sure we can get what we need to start. (Reboot Required)
zypper refresh
zypper update
**Wanna see what packages are being installed? "zypper list-updates --all"
zypper install epel-release
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
***Add Swap File
mkdir -p /var/lib/swap
dd if=/dev/zero of=/var/lib/swap/swapfile bs=1M count=128
mkswap /var/lib/swap/swapfile
swapon /var/lib/swap/swapfile
cat /proc/swaps (to check its loaded)
***Add Swap into startup
vim /etc/fstab
Type "i"
COPY "/var/lib/swap/swapfile swap swap defaults 0 0"
CNTL+C
Type ":wq"
Press Enter
*Install Dependencies for Apache, MariaDB, PHP and Perl
zypper install kernel*
zypper install make patch gcc gcc-c++ subversion php php-devel php-gd gd-devel php-mbstring php-mcrypt php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc curl curl-devel perl-libwww-perl ImageMagick libxml2 libxml2-devel httpd libpcap libpcap-devel libnet ncurses ncurses-devel screen mysql-devel ntp mutt glibc.i686 wget nano unzip sipsak sox –y
zypper install sqlite-devel –y
zypper install mariadb-server mariadb-devel mariadb -y
***Install and Run Apache & MariaDB Servers
zypper install httpd php-common php-pdo mod_ssl perl-DBI perl-DBD-MySQL perl-Digest-HMAC perl-YAML perl-ExtUtils-ParseXS perl-NetAddr-IP perl-Crypt-SSLeay perl-Curses perl-DBD-Pg perl-Module-ScanDeps perl-Text-CSV perl-HTML-Template perl-IO-Compress perl-Text-Glob perl-Jcode perl-Test-Script perl-Archive-Tar perl-Test-Base perl-OLE-Storage_Lite perl-Archive-Zip perl-Net-Server perl-Convert-ASN1 perl perl-Compress-Raw-Zlib perl-Digest-SHA1 perl-Data-Dumper perl-Error perl-ExtUtils-CBuilder perl-Test-Tester perl-Parse-RecDescent perl-Spiffy perl-IO-Zlib perl-Module-Build perl-HTML-Parser perl-Net-SSLeay perl-Proc-ProcessTable perl-TermReadKey perl-Term-ReadLine-Gnu perl-Digest-SHA perl-Tk perl-Net-SNMP perl-Test-NoWarnings perl-XML-Writer perl-Proc-PID-File perl-Compress-Raw-Bzip2 perl-libwww-perl perl-XML-Parser perl-File-Remove perl-Parse-CPAN-Meta perl-Set-Scalar perl-Probe-Perl perl-File-Which perl-Package-Constants perl-Module-Install perl-File-HomeDir perl-Spreadsheet-ParseExcel perl-Mail-Sendmail perl-Spreadsheet-XLSX asterisk-perl perl-version perl-Crypt-DES perl-URI perl-Net-Daemon perl-IO-stringy perl-YAML-Tiny perl-HTML-Tagset perl-Socket6 perl-BSD-Resource perl-PlRPC perl-IPC-Run3 perl-Text-CSV_XS perl-Unicode-Map perl-Module-CoreList perl-Net-Telnet perl-PAR-Dist perl-Date-Manip perl-JSON perl-Proc-Daemon perl-Spreadsheet-WriteExcel perl-rrdtool install lame screen sox iftop subversion dahdi-linux-devel php-xcache
zypper install make patch gcc gcc-c++
zypper install ncurses-devel
zypper install libxml2-devel
zypper install sqlite-devel
systemctl start httpd.service; systemctl start mariadb.service;systemctl enable httpd.service; systemctl enable mariadb.service
***Install Cpan
cpan -i String::CRC Tk::TableMatrix Net::Address::IP::Local Term::ReadLine::Gnu Spreadsheet::Read Net::Address::IPv4::Local RPM::Specfile Spreadsheet::XLSX Spreadsheet::ReadSXC
zypper install perl-CPAN
zypper install perl-YAML
zypper install perl-libwww-perl
zypper install perl-DBI
zypper install perl-DBD-MySQL
zypper install perl-GD
cpan -i Net::Telnet
***perl -MCPAN -e 'my $c = "CPAN::HandleConfig"; $c->load(doit => 1, autoconfig => 1); $c->edit(prerequisites_policy => "follow"); $c->edit(build_requires_install_policy => "yes"); $c->commit'
***cpan MD5 Digest::MD5 Digest::SHA1 readline Bundle::CPAN Pod::Usage Getopt::Long DBI DBD::mysql Net::Telnet Time::HiRes Net::Server Mail::Sendmail Unicode::Map Jcode Spreadsheet::WriteExcel OLE::Storage_Lite Proc::ProcessTable IO::Scalar Scalar::Util Spreadsheet::ParseExcel Archive::Zip Compress::Raw::Zlib Spreadsheet::XLSX Test::Tester Spreadsheet::ReadSXC Text::CSV Test::NoWarnings Text::CSV_PP File::Temp Text::CSV_XS Spreadsheet::Read LWP::UserAgent HTML::Entities HTML::Strip HTML::FormatText HTML::TreeBuilder Switch Time::Local MIME::POP3Client Mail::IMAPClient Mail::Message IO::Socket::SSL
cd /usr/bin/
curl -LOk http://xrl.us/cpanm
chmod +x cpanm
zypper install make
cpanm -f File::Which
cpanm -f File::HomeDir
cpanm CPAN::Meta::Requirements
cpanm -f CPAN
cpanm YAML
cpanm MD5
cpanm Digest::MD5
cpanm Digest::SHA1
cpanm readline
cpanm Bundle::CPAN
cpanm DBI
cpanm -f DBD::mysql
cpanm Net::Telnet
cpanm Time::HiRes
cpanm Net::Server
cpanm Switch
cpanm Mail::Sendmail
cpanm Unicode::Map
cpanm Jcode
cpanm Spreadsheet::WriteExcel
cpanm OLE::Storage_Lite
cpanm Proc::ProcessTable
cpanm IO::Scalar
cpanm Spreadsheet::ParseExcel
cpanm Curses
cpanm Getopt::Long
cpanm Net::Domain
cpanm Term::ReadKey
cpanm Term::ANSIColor
cpanm Spreadsheet::XLSX
cpanm Spreadsheet::Read
cpanm LWP::UserAgent
cpanm HTML::Entities
cpanm HTML::Strip
cpanm HTML::FormatText
cpanm HTML::TreeBuilder
cpanm Time::Local
cpanm MIME::Decoder
cpanm Mail::POP3Client
cpanm Mail::IMAPClient
cpanm User::Identity --force
cpanm Mail::Message
cpanm IO::Socket::SSL
cpanm MIME::Base64
cpanm MIME::QuotedPrint
cpanm Crypt::Eksblowfish::Bcrypt
cpanm Crypt::RC4
cpanm Text::CSV
cpanm Text::CSV_XS
***Asterisk PERL Module 0.8 Installation
cd /usr/src/
wget http://download.vicidial.com/required-apps/asterisk-perl-0.08.tar.gz
tar -zxf asterisk-perl-0.08.tar.gz
cd asterisk-perl-0.08
perl Makefile.PL && make all && make install
***Install Lame
cd /usr/src
tar -xf lame-398-2.tar.gz
cd lame-398-2/
./configure && make && make install
***Install Jasson
cd /usr/src/
wget http://www.digip.org/jansson/releases/jansson-2.5.tar.gz
tar -zvxf jansson-2.5.tar.gz
cd jasson-2.5
./configure && make clean && make && make install
ldconfig
***Install Asterisk - Dadhi and libpri
mkdir /usr/src/asterisk
cd /usr/src/asterisk
wget http://downloads.asterisk.org/pub/telephony/libpri/libpri-current.tar.gz
wget http://downloads.asterisk.org/pub/telephony/dahdi-linux-complete/dahdi-linux-complete-2.10.2+2.10.2.tar.gz
wget http://download.vicidial.com/beta-apps/asterisk-13.21.0-vici.tar.gz
tar xzf asterisk-*
tar xzf dahdi-linux-complete-*
tar xzf libpri-*
cd /usr/src/asterisk/dahdi-linux-complete-*
zypper addrepo --check --refresh --name 'openSUSE-Leap-15.0-Update' http://download.opensuse.org/update/leap/15.0/oss/ repo-update
zypper refresh
zypper install kernel-devel
make
make install
make config
cd tools
make clean
make
make install
make config
cd /usr/src/asterisk/libpri-1.6.0
make clean
make
make install
cd /usr/src/asterisk/asterisk-13.21.0-vici/
zypper install libuuid-devel
./configure --libdir=/usr/lib64
make clean
make menuselect*
!!!*MAKE SURE TO CHECK Applications > App.MeetME [*] and press x to save and exit
make
make install
make samples
make config
chkconfig asterisk on
cp /usr/src/asterisk/asterisk-13.21.0-vici/contrib/init.d/rc.opensuse.asterisk /etc/init.d/asterisk
***DB Creation
mysql -p
CREATE DATABASE `asterisk` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES on asterisk.* TO cron@'%' IDENTIFIED BY '1234';
GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES on asterisk.* TO cron@localhost IDENTIFIED BY '1234';
GRANT RELOAD ON *.* TO cron@'%';
GRANT RELOAD ON *.* TO cron@localhost;
flush privileges;
quit
***Install ViciDial
mkdir /usr/src/astguiclient
cd /usr/src/astguiclient
svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk
cd trunk
perl install.pl
***Import MySQL Settings
mysql -u root -p
SET GLOBAL connect_timeout=60;
use asterisk;
\. /usr/src/astguiclient/trunk/extras/MySQL_AST_CREATE_tables.sql
\. /usr/src/astguiclient/trunk/extras/first_server_install.sql
ALTER TABLE phones ALTER template_id SET DEFAULT '';
\. /usr/src/astguiclient/trunk/extras/sip-iax_phones.sql
quit
***Update Area Codes
/usr/share/astguiclient/ADMIN_area_code_populate.pl
cp /usr/src/astguiclient/trunk/extras/performance_test_leads.txt /usr/share/astguiclient/LEADS_IN/
/usr/src/astguiclient/trunk/bin/VICIDIAL_IN_new_leads_file.pl --forcelistid=107 --forcephonecode=1
***Edit /etc/rc.local to contain the following code (enter vi /etc/rc.local/ to edit with vi, nano /etc/rc.local to edit with nano, ed /etc/rc.local to edit with ed... choose an editor to your liking):
#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.
touch /var/lock/subsys/local
# OPTIONAL enable ip_relay(for same-machine trunking and blind monitoring)
/usr/share/astguiclient/ip_relay/relay_control start 2>/dev/null 1>&2
# Disable console blanking and powersaving
/usr/bin/setterm -blank
/usr/bin/setterm -powersave off
/usr/bin/setterm -powerdown
### start up the MySQL server
systemctl start mariadb.service
systemctl enable mariadb.service
### start up the apache web server
systemctl start apache2
systemctl enable apache2
### roll the Asterisk logs upon reboot
/usr/share/astguiclient/ADMIN_restart_roll_logs.pl
### clear the server-related records from the database
/usr/share/astguiclient/AST_reset_mysql_vars.pl
### load dahdi drivers
modprobe dahde
/usr/sbin/dahdi_cfg -vvvvvvvvvvvvv
#modprobe zaptel
#modprobe wct1xxp
#/sbin/ztccfg -vvvvvvvvvvvv
### sleep for 20 seconds before launching Asterisk
sleep 20
### start up asterisk
/usr/share/astguiclient/start_asterisk_boot.pl
***Adding to Crontab
crontab -e
**Once it opens, Press "i" and then paste the following into crontab:
### 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_mix.pl --MIX
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 --GSM
#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 --GSM
### keepalive script for astguiclient processes
* * * * * /usr/share/astguiclient/ADMIN_keepalive_ALL.pl --cu3way
### 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 and the full day run at night
33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl
50 0 * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl --last-24hours
## uncomment below if using QueueMetrics
#*/5 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl --only-qm-live-call-check
## uncomment below if using Vtiger
#1 1 * * * /usr/share/astguiclient/Vtiger_optimize_all_tables.pl --quiet
### updater for VICIDIAL hopper
* * * * * /usr/share/astguiclient/AST_VDhopper.pl -q
### adjust the GMT offset for the leads in the vicidial_list table
1 1,7 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug
### reset several temporary-info tables in the database
2 1 * * * /usr/share/astguiclient/AST_reset_mysql_vars.pl
### optimize the database tables within the asterisk database
3 1 * * * /usr/share/astguiclient/AST_DB_optimize.pl
## adjust time on the server with ntp
30 * * * * /usr/sbin/ntpdate -u pool.ntp.org 2>/dev/null 1>&2
### VICIDIAL agent time log weekly and daily summary report generation
2 0 * * 0 /usr/share/astguiclient/AST_agent_week.pl
22 0 * * * /usr/share/astguiclient/AST_agent_day.pl
### VICIDIAL campaign export scripts (OPTIONAL)
#32 0 * * * /usr/share/astguiclient/AST_VDsales_export.pl
#42 0 * * * /usr/share/astguiclient/AST_sourceID_summary_export.pl
### remove old recordings more than 7 days old
#24 0 * * * /usr/bin/find /var/spool/asterisk/monitorDONE -maxdepth 2 -type f -mtime +7 -print | xargs rm -f
### roll logs monthly on high-volume dialing systems
#30 1 1 * * /usr/share/astguiclient/ADMIN_archive_log_tables.pl
### 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
30 0 * * * /usr/bin/find / -maxdepth 1 -name "screenlog.0*" -mtime +4 -print | xargs rm -f
### cleanup of the scheduled callback records
25 0 * * * /usr/share/astguiclient/AST_DB_dead_cb_purge.pl --purge-non-cb -q
### GMT adjust script - uncomment to enable
#45 0 * * * /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --list-settings
### Dialer Inventory Report
1 7 * * * /usr/share/astguiclient/AST_dialer_inventory_snapshot.pl -q --override-24hours
### inbound email parser
* * * * * /usr/share/astguiclient/AST_inbound_email_parser.pl
!!!!END CRONTAB HERE
***Update Server IP
**/usr/share/astguiclient/ADMIN_update_server_ip.pl --old-server_ip=10.10.10.15
reboot
I can not load any leads into any lists. My Server shows as red instead of green if that gives any hints...
Below is my debug output:
- Code: Select all
----- DEBUG -----
----- SUPER DEBUG -----
TIME DEBUG: -5.00|-4|1| GMT: 03:27
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2020-04-14") ) );Inactive Lists: 2
Inactive and Expired List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998') ;|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2020-04-14 23:27:29' and status='ACTIVE' ;|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Trim Hopper Enabled For Dream---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 20
CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0
Starting hopper run for Dream campaign- GMT: 12pm-5pm HOPPER: 20 ORDER: RANDOM|Y|LEAD_ASCEND
|GMT-DAY-HOUR| |13.00-3-1627||12.75-3-1612||12.50-3-1557||12.25-3-1542||12.00-3-1527||11.75-3-1512||11.50-3-1457||11.25-3-1442||11.00-3-1427||10.75-3-1412||10.50-3-1357||10.25-3-1342||10.00-3-1327||9.75-3-1312||9.50-3-1257||9.25-3-1242||9.00-3-1227||8.75-3-1212||8.50-3-1157||8.25-3-1142||8.00-3-1127||7.75-3-1112||7.50-3-1057||7.25-3-1042||7.00-3-1027||6.75-3-1012||6.50-3-957||6.25-3-942||6.00-3-927||5.75-3-912||5.50-3-857||5.25-3-842||5.00-3-827||4.75-3-812||4.50-3-757||4.25-3-742||4.00-3-727||3.75-3-712||3.50-3-657||3.25-3-642||3.00-3-627||2.75-3-612||2.50-3-557||2.25-3-542||2.00-3-527||1.75-3-512||1.50-3-457||1.25-3-442||1.00-3-427||0.75-3-412||0.50-3-357||0.25-3-342||0.00-3-327||-0.25-3-312||-0.50-3-257||-0.75-3-242||-1.00-3-227||-1.25-3-212||-1.50-3-157||-1.75-3-142||-2.00-3-127||-2.25-3-112||-2.50-3-57||-2.75-3-42||-3.00-3-27||-3.25-3-12||-3.50-2-2357||-3.75-2-2342||-4.00-2-2327||-4.25-2-2312||-4.50-2-2257||-4.75-2-2242||-5.00-2-2227||-5.25-2-2212||-5.50-2-2157||-5.75-2-2142||-6.00-2-2127||-6.25-2-2112||-6.50-2-2057||-6.75-2-2042||-7.00-2-2027||-7.25-2-2012||-7.50-2-1957||-7.75-2-1942||-8.00-2-1927||-8.25-2-1912||-8.50-2-1857||-8.75-2-1842||-9.00-2-1827||-9.25-2-1812||-9.50-2-1757||-9.75-2-1742||-10.00-2-1727||-10.25-2-1712||-10.50-2-1657||-10.75-2-1642||-11.00-2-1627||-11.25-2-1612||-11.50-2-1557||-11.75-2-1542||-12.00-2-1527||-12.25-2-1512||-12.50-2-1457||-12.75-2-1442|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id='12pm-5pm';|
LocalCallTime No-Call Gap: |68400|1700(17 00)|1200(12 00)|2|1|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='Dream' and status='READY';|
Processing GMT for list 998
Processing GMT for list 1000
campaign lists count ACTIVE:1 | TOTAL:2
LIST ID SQL (list_id IN('1000')) |SELECT count(*) from vicidial_hopper where campaign_id='Dream' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='Dream' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='Dream' and ((gmt_offset_now NOT IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ));|
no lead filter defined for campaign: Dream
|NONE|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('SALE','NP','NI','N','DEC','DC','B','A','NEW') and ((list_id IN('1000'))) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('SALE','NP','NI','N','DEC','DC','B','A','NEW') and ((list_id IN('1000'))) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
NO DIALABLE LEADS FOR THIS CAMPAIGN
hopper too low (0|20) starting hopper dump
ERROR CANNOT ADD ANY LEADS TO HOPPER
SUMMARY: 1 campaigns
Dream 0 20 0
DONE. Script execution time in seconds: 0
Im going from this:
There are screens on:
14067.ASTVDremote (Detached)
14064.ASTVDauto (Detached)
14061.ASTlisten (Detached)
14058.ASTsend (Detached)
14055.ASTupdate (Detached)
11897.asterisk (Detached)
11890.astshell20200414193204 (Detached)
1604.ASTconf3way (Detached)
1596.ASTVDadFILL (Detached)
1593.ASTfastlog (Detached)
1590.ASTVDadapt (Detached)
11 Sockets in /run/screens/S-root.
To this:
There are screens on:
11897.asterisk (Detached)
11890.astshell20200414193204 (Detached)
1604.ASTconf3way (Detached)
1596.ASTVDadFILL (Detached)
1593.ASTfastlog (Detached)
1590.ASTVDadapt (Detached)
6 Sockets in /run/screens/S-root.
All the needed asterisks socks are there at first, then within a matter of a couple minutes it goes from 11 down to 6... ANy idea why? I am going to guess this has something to do with why I cant load any neads. When I load leads, it shows them loading but then the list still has zero leads.