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

[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

[covarrubiasgg]

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

[Kumba]

Everyone is a critic

Bugfix fixed.

[covarrubiasgg]

Everyone is a critic

Bugfix fixed.

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

[Kumba]

well the good news is that I had it correct in the conf files for 6.0.1 that I pushed out.

[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


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

[mcargile]

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

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

[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 #

[ciacho]

New topic of the problems associated with the list loader was created:
viewtopic.php?f=8&t=33282