ViciBox v.6.0 Bug Fixes - Updated 10/23/2015

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

ViciBox v.6.0 Bug Fixes - Updated 10/23/2015

Postby Kumba » Tue Jul 22, 2014 10:22 am

This thread will contain gotchas, patches, bugs, and other useful information related to ViciBox v.6.0 installs. The steps assume you are already logged in as the root user and sitting at a shell prompt.


ViciBox v.6.0.0 only fix for Apache access restrictions:
1) sed -i 's/Require all granted/Order allow,deny\n\tAllow from all/' /etc/apache2/conf.d/viciarchive.conf
2) sed -i 's/Require all granted/Order allow,deny\n\tAllow from all/' /etc/apache2/conf.d/vicirecord.conf
3) service apache2 restart


----------


ViciBox v.6.0.1 and under chan_ooh323 segfault fix, prevents asterisk from starting:
1) echo "noload => chan_ooh323.so" >> /etc/asterisk/modules.conf


----------


ViciBox v.6.0.1 and under has an issue with MySQL tmp directory being deleted during an automated filesystem pruning process. Fix is to specify the tmp directory. This should be done after hours as it causes an interruption in database availability:

1) sed -i 's/myisam_repair_threads=1/myisam_repair_threads=1\ntmpdir = \/tmp\//' /etc/my.cnf
2) service mysql restart


----------


For some reason the installation location of the Crypt::RC4 perl module results in issues for the list loader. A symlink seems to make it all work again. Here's the fix:

1) mkdir -p /usr/lib/perl5/site_perl/5.18.1/Crypt/
2) ln -s /usr/lib/perl5/vendor_perl/5.18.1/Crypt/RC4.pm /usr/lib/perl5/site_perl/5.18.1/Crypt/RC4.pm


----------


Missed the concurrent_insert directive in the my.cnf configuration file on ViciBox v.6.0.2 and under:

1) sed -i 's/table_cache=8192/table_cache=8192\nconcurrent_insert=2/' /etc/my.cnf
2) service mysql restart


----------


Default mysql configuration breaks replication if slave server rebooted due to memory tables not being persistent. Applies to ViciBox v.6.0.3 and under.

1) sed -i '/server-id/a slave-skip-errors=1032,1690' /etc/my.cnf
2) service mysql restart
Kumba
 
Posts: 721
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida

Re: ViciBox v.6.0 Bug Fixes

Postby covarrubiasgg » Tue Jul 22, 2014 4:54 pm

Kumba wrote:This thread will contain gotchas, patches, bugs, and other useful information related to ViciBox v.6.0 installs. The steps assume you are already logged in as the root user and sitting at a shell prompt.


ViciBox v.6.0.0 only fix for Apache access restrictions:
1) sed -i 's/Require all granted/Order allow deny\n\tAllow from all/' /etc/apache2/conf.d/viciarchive.conf
2) sed -i 's/Require all granted/Order allow deny\n\tAllow from all/' /etc/apache2/conf.d/vicirecord.conf
3) /etc/init.d/apache2 restart


There is a missing coma in allow,deny


Code: Select all
Jul 22 14:52:14 vicidial start_apache2[16116]: AH00526: Syntax error on line 6 of /etc/apache2/conf.d/viciarchive.conf:
Jul 22 14:52:14 vicidial start_apache2[16116]: order takes one argument, 'allow,deny', 'deny,allow', or 'mutual-failure'
Jul 22 14:52:14 vicidial systemd[1]: apache2.service: main process exited, code=exited, status=1/FAILURE
Jul 22 14:52:15 vicidial start_apache2[16133]: AH00526: Syntax error on line 6 of /etc/apache2/conf.d/viciarchive.conf:
Jul 22 14:52:15 vicidial start_apache2[16133]: order takes one argument, 'allow,deny', 'deny,allow', or 'mutual-failure'
Jul 22 14:52:15 vicidial systemd[1]: apache2.service: control process exited, code=exited status=1
Jul 22 14:52:15 vicidial systemd[1]: Failed to start The Apache Webserver.
Jul 22 14:52:15 vicidial systemd[1]: Unit apache2.service entered failed state.


also /etc/init.d/apache2 restart doesnt exists anymore in Vicibox 6.0 i had to

Code: Select all
service apache2 restart
covarrubiasgg
 
Posts: 356
Joined: Thu Jun 10, 2010 10:20 am
Location: Tijuana, Mexico

Re: ViciBox v.6.0 Bug Fixes

Postby Kumba » Tue Jul 22, 2014 8:46 pm

Everyone is a critic :)

Bugfix fixed.
Kumba
 
Posts: 721
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida

Re: ViciBox v.6.0 Bug Fixes

Postby covarrubiasgg » Tue Jul 22, 2014 9:00 pm

Kumba wrote:Everyone is a critic :)

Bugfix fixed.


:lol:

I am not criticizing, thats my 2 cents trying to help :mrgreen:
covarrubiasgg
 
Posts: 356
Joined: Thu Jun 10, 2010 10:20 am
Location: Tijuana, Mexico

Re: ViciBox v.6.0 Bug Fixes

Postby Kumba » Wed Jul 23, 2014 11:12 am

well the good news is that I had it correct in the conf files for 6.0.1 that I pushed out.
Kumba
 
Posts: 721
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida

Re: ViciBox v.6.0 Bug Fixes

Postby ciacho » Tue Jul 29, 2014 6:39 am

Hello Kumba,

There is one more error in listloader.
When I tried to load leads (csv, utf-8) into list via admin_listloader_fourth_gen.php
I've got this errors in /var/log/apache2/error_log:
Code: Select all
Attempt to reload Spreadsheet/XLSX.pm aborted.
Compilation failed in require at /srv/www/htdocs/vicidial/sheet2tab.pl line 43.
BEGIN failed--compilation aborted at /srv/www/htdocs/vicidial/sheet2tab.pl line 43.
[Tue Jul 29 13:26:11.464548 2014] [php5:error] [pid 7302] [client 192.168.99.106:64011] PHP Warning:  fopen(/tmp/db.txt): failed to open stream: No such file or directory in /srv/www/htdocs/vicidial/admin_listloader_fourth_gen.php on line 2195, referer: http://192.168.99.200/vicidial/admin_listloader_fourth_gen.php
[Tue Jul 29 13:26:11.464608 2014] [php5:error] [pid 7302] [client 192.168.99.106:64011] PHP Warning:  fgets() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/vicidial/admin_listloader_fourth_gen.php on line 2199, referer: http://192.168.99.200/vicidial/admin_listloader_fourth_gen.php
[Tue Jul 29 13:26:11.464679 2014] [php5:error] [pid 7302] [client 192.168.99.106:64011] PHP Warning:  fopen(/tmp/db.txt): failed to open stream: No such file or directory in /srv/www/htdocs/vicidial/admin_listloader_fourth_gen.php on line 2230, referer: http://192.168.99.200/vicidial/admin_listloader_fourth_gen.php
[Tue Jul 29 13:26:11.464700 2014] [php5:error] [pid 7302] [client 192.168.99.106:64011] PHP Warning:  fgets() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/vicidial/admin_listloader_fourth_gen.php on line 2245, referer: http://192.168.99.200/vicidial/admin_listloader_fourth_gen.php
VICIdial installations in POLAND
ciacho
 
Posts: 47
Joined: Tue Jul 08, 2008 1:46 am
Location: POLAND

Re: ViciBox v.6.0 Bug Fixes

Postby Kumba » Tue Jul 29, 2014 12:05 pm

Can you please start a new post with the new issues that you are having in ViciBox v.6.0? This will help other people who might be having a similar issue find it through resources like google. It also helps them find it quicker since one post is one issue and not one super long post with every issue known to exist.

I'll look into it.
Kumba
 
Posts: 721
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida

Re: ViciBox v.6.0 Bug Fixes

Postby mcargile » Tue Jul 29, 2014 1:04 pm

Please try running this on the command line and posting the results:

perl -I. -Ilib -e 'use Spreadsheet::XLSX';
Michael Cargile | Director of Consulting | ViciDialGroup | www.vicidial.com

The official source for VICIDIAL services and support. 1-888-894-VICI (8424)
mcargile
Site Admin
 
Posts: 551
Joined: Tue Jan 16, 2007 9:38 am

Re: ViciBox v.6.0 Bug Fixes

Postby nysander » Tue Jul 29, 2014 4:23 pm

I have also this error and this command returns nothing.

Code: Select all
vicidial2:/etc/asterisk # perl -I. -Ilib -e 'use Spreadsheet::XLSX';
vicidial2:/etc/asterisk #
now:
[vicidial]: ViciBox 6.0 Ast 1.8.29.0-vici | vd-2.10-448a-140706-0927 ------ SIP connected to GSM Gateway
[GSM Gateway]: Asterisk 1.8.29.0 | chan_dongle-1.1.r14 | 7x Huawei Dongles (E156G, E169, E1550 voice enabled)
nysander
 
Posts: 52
Joined: Wed Jul 23, 2014 5:06 am

Re: ViciBox v.6.0 Bug Fixes

Postby ciacho » Wed Jul 30, 2014 2:35 am

New topic of the problems associated with the list loader was created:
viewtopic.php?f=8&t=33282
VICIdial installations in POLAND
ciacho
 
Posts: 47
Joined: Tue Jul 08, 2008 1:46 am
Location: POLAND


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 9 guests