Vicibox 6.0 Listloader not working

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

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

Vicibox 6.0 Listloader not working

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

Hello,

Kumba: could You please merge threads:
viewtopic.php?f=8&t=33251#p113026

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


Command (via post from mcargile):
Code: Select all
# perl -I. -Ilib -e 'use Spreadsheet::XLSX';
#

returns nothing.
VICIdial installations in POLAND
ciacho
 
Posts: 48
Joined: Tue Jul 08, 2008 1:46 am
Location: POLAND

Re: Vicibox 6.0 Listloader not working

Postby mcargile » Wed Jul 30, 2014 9:59 am

Could you please send the lead file you are loading to support@vicidial.com?
Michael Cargile | Director of Engineering | ViciDialGroup | http://www.vicidial.com

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

Re: Vicibox 6.0 Listloader not working

Postby ciacho » Wed Jul 30, 2014 10:21 am

According to Your request - there is a sample file:
http://we.tl/9iEZwGa5Cf
VICIdial installations in POLAND
ciacho
 
Posts: 48
Joined: Tue Jul 08, 2008 1:46 am
Location: POLAND

Re: Vicibox 6.0 Listloader not working

Postby ciacho » Mon Aug 04, 2014 5:01 am

Hello,

Is there any progress with this problem?
VICIdial installations in POLAND
ciacho
 
Posts: 48
Joined: Tue Jul 08, 2008 1:46 am
Location: POLAND

Re: Vicibox 6.0 Listloader not working

Postby blackbird2306 » Mon Aug 04, 2014 9:02 am

Hi there,
I have the same problem with loading leads. It doesn't matter if it's xls or csv format.
My 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.



It's a fresh installation from Vicibox with all new updates.
Vicibox_v.6.0.x86_64-6.0.1.preload.iso
VERSION: 2.10-448a
BUILD: 140706-0927
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: Vicibox 6.0 Listloader not working

Postby Kumba » Thu Aug 07, 2014 5:48 pm

We are working on the issue. Unfortunately that's all I have at this moment. Something has gone horribly wrong somewhere in PERL.
Kumba
 
Posts: 939
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida

Re: Vicibox 6.0 Listloader not working

Postby williamconley » Thu Aug 07, 2014 7:13 pm

Please try Tab Delimited. And report back.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicibox 6.0 Listloader not working

Postby mcargile » Tue Aug 12, 2014 9:36 am

Think we found the issue. It looks like Spreadsheet::Read is now explicitly loading Spreadsheet::XLSX. As such loading Spreadsheet::XLSX is causing it to fail. So on Vicibox 6 commenting out:
Code: Select all
use Spreadsheet::XLSX;

should fix this. The only problem is that on older versions this will not work. I am currently looking for a way to tell if XLSX is loaded and if not then load it.
Michael Cargile | Director of Engineering | ViciDialGroup | http://www.vicidial.com

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

Re: Vicibox 6.0 Listloader not working

Postby geoff3dmg » Tue Aug 12, 2014 10:21 am

The problem is 'use' loads modules at compile time, not at run time. The classic way to fix this in perl is to use 'require' which is a run time check:

http://perldoc.perl.org/perlfaq8.html#What%27s-the-difference-between-require-and-use?

Code: Select all
if  (eval {require Spreadsheet::XLSX;1;}) {
#module loaded
Spreadsheet::XLSX->import();
}


However the Module::Load::Conditional module is a much better way of handling this situation.
Vicibox 5.03 from .iso | VERSION: 2.10-451a BUILD: 140902-0816 | Asterisk 1.8.28.2-vici | Multi-Server | Amfeltec H/W Timing Cards | No Extra Software After Installation | Dell PowerEdge 1850 | Pentium 4 'Prescott' Xenon Quad @ 3.40GHz
geoff3dmg
 
Posts: 403
Joined: Tue Jan 29, 2013 4:35 am
Location: Lancashire, UK

Re: Vicibox 6.0 Listloader not working

Postby mcargile » Tue Aug 12, 2014 11:08 am

Tried that. The issue is that it does not work across all versions of perl. On systems installed with Vicibox version 3 (which we have hundreds of clients still using) doing that fails. I also tried commenting out Spreadsheet::Read and only loading the XLSX module. I get this:

Code: Select all
Can't locate Crypt/RC4.pm:   Permission denied at /usr/lib/perl5/vendor_perl/5.18.1/Spreadsheet/ParseExcel.pm line 26.


I have checked and Crypt/RC4.pm is installed properly and has correct file permissions. Something is just weird with this module.
Michael Cargile | Director of Engineering | ViciDialGroup | http://www.vicidial.com

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

Re: Vicibox 6.0 Listloader not working

Postby mcargile » Tue Aug 12, 2014 1:15 pm

I replaced sheet2tab.pl with a perl script that just has:

Code: Select all
use Spreadsheet::XLSX


and thats it. When PHP goes to execute this it is returning this:

Code: Select all
Can't locate Crypt/RC4.pm:   Permission denied at /usr/lib/perl5/vendor_perl/5.18.1/Spreadsheet/ParseExcel.pm line 26.


I can run it as root just fine. I think disabling XLSX support for now is the best solution.
Michael Cargile | Director of Engineering | ViciDialGroup | http://www.vicidial.com

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

Re: Vicibox 6.0 Listloader not working

Postby mcargile » Tue Aug 12, 2014 1:22 pm

A temporary solution to this issue is to just disable XLSX support. To do so run:

Code: Select all
sed -i 's/use Spreadsheet::XLSX/#use Spreadsheet::XLSX/' /srv/www/htdocs/vicidial/sheet2tab.pl
Michael Cargile | Director of Engineering | ViciDialGroup | http://www.vicidial.com

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

Re: Vicibox 6.0 Listloader not working

Postby mcargile » Wed Aug 13, 2014 8:56 am

Looks like the issue is a file permission issue with the Crypt::RC4 perl module. Running the following in CPAN will fix it:

Code: Select all
force install Crypt::RC4
Michael Cargile | Director of Engineering | ViciDialGroup | http://www.vicidial.com

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

Re: Vicibox 6.0 Listloader not working

Postby blackbird2306 » Wed Aug 20, 2014 9:36 am

Many thanks for your key. Is this a temporary solution or the real reason behind the problem? What are your experiences after that. Does everything work as it should?

mcargile wrote:Looks like the issue is a file permission issue with the Crypt::RC4 perl module. Running the following in CPAN will fix it:

Code: Select all
force install Crypt::RC4
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: Vicibox 6.0 Listloader not working

Postby Kumba » Tue Aug 26, 2014 1:08 am

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
Kumba
 
Posts: 939
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 82 guests