Page 1 of 1

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

PostPosted: Tue Jul 22, 2014 10:22 am
by Kumba
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

Re: ViciBox v.6.0 Bug Fixes

PostPosted: Tue Jul 22, 2014 4:54 pm
by covarrubiasgg
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

Re: ViciBox v.6.0 Bug Fixes

PostPosted: Tue Jul 22, 2014 8:46 pm
by Kumba
Everyone is a critic :)

Bugfix fixed.

Re: ViciBox v.6.0 Bug Fixes

PostPosted: Tue Jul 22, 2014 9:00 pm
by covarrubiasgg
Kumba wrote:Everyone is a critic :)

Bugfix fixed.


:lol:

I am not criticizing, thats my 2 cents trying to help :mrgreen:

Re: ViciBox v.6.0 Bug Fixes

PostPosted: Wed Jul 23, 2014 11:12 am
by Kumba
well the good news is that I had it correct in the conf files for 6.0.1 that I pushed out.

Re: ViciBox v.6.0 Bug Fixes

PostPosted: Tue Jul 29, 2014 6:39 am
by ciacho
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

Re: ViciBox v.6.0 Bug Fixes

PostPosted: Tue Jul 29, 2014 12:05 pm
by Kumba
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.

Re: ViciBox v.6.0 Bug Fixes

PostPosted: Tue Jul 29, 2014 1:04 pm
by mcargile
Please try running this on the command line and posting the results:

perl -I. -Ilib -e 'use Spreadsheet::XLSX';

Re: ViciBox v.6.0 Bug Fixes

PostPosted: Tue Jul 29, 2014 4:23 pm
by nysander
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 #

Re: ViciBox v.6.0 Bug Fixes

PostPosted: Wed Jul 30, 2014 2:35 am
by ciacho
New topic of the problems associated with the list loader was created:
viewtopic.php?f=8&t=33282