VICIBox3.1.9 Cluster Install Problems - Leads Loading

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

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

VICIBox3.1.9 Cluster Install Problems - Leads Loading

Postby avinash_shah » Thu Apr 14, 2011 5:10 pm

Hi,

Cluster info :

DB Server
HP Proliant DL180 G6 Dual XEON quad core 16 GB 1 TB
Kernel : 2.6.34.7-0.7-default
Installed Using : vicibox3.1.9 64 Bit ISO
Install Reference : VICIBox Cluster and Walkthrough Guide

Above server is dedicated database only

Web/Telephony server
HP Proliant DL180 G6 Dual XEON quad core 16 GB 1TB
Dual Digium TE420P (total of 8 spans)
Kernel : 2.6.34.7-0.7-default
Installed Using : VICIbox 3.1.9 64 bit ISO
Install Reference : VICIBox Cluster and Walkthrough Guide
Asterisk version : 1.4.39.1-vici
Vicidial Version : 2.4-299
Vicidial Build : 110214-0001

Above server is only Web/Telephony server in the set-up. No additional software's installed on both servers except ISO install

The set-up is being used for INBOUND calls handling. everything is working fine except when i try to load leads in a list that has custom fields defined i am faced with problem. After selecting the file to upload and selecting custom layout when submit is pressed the next screen doesnt show any fields mapping just Two buttons "Ok to process" and "start over". The problem persists in 3rdGen and Old leads loader. I have tried CSV, Tab Delimited, extension as TXT but no success.

However if I create a list without any custom fields and try leads loading everything works perfectly fine.

Two error messages in apache error logs are included below for your kind reference

Code: Select all
Fri Apr 15 02:44:43 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_num_fields() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/vicidial/admin_listloader_third_gen.php on line 1399, referer: http://xx.xx.xx.xx/vicidial/admin_listloader_third_gen.php
[Fri Apr 15 02:45:31 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_num_fields() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/vicidial/new_listloader_superL.php on line 1904, referer: http://xx.xx.xx.xx/vicidial/new_listloader_superL.php
[Fri Apr 15 02:56:08 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_num_fields() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/vicidial/admin_listloader_third_gen.php on line 1399, referer: http://xx.xx.xx.xx/vicidial/admin_listloader_third_gen.php
[Fri Apr 15 02:56:21 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_num_fields() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/vicidial/new_listloader_superL.php on line 1904, referer: http://xx.xx.xx.xx/vicidial/new_listloader_superL.php
[Fri Apr 15 02:58:17 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_num_fields() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/vicidial/admin_listloader_third_gen.php on line 1399, referer: http://xx.xx.xx.xx/vicidial/admin_listloader_third_gen.php
[Fri Apr 15 03:29:30 2011] [error] [client xx.xx.xx.xx] PHP Warning:  mysql_num_fields() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/vicidial/admin_listloader_third_gen.php on line 1399, referer: http://xx.xx.xx.xx/vicidial/admin_listloader_third_gen.php


I hate to disclose but this is a production cluster :( :( :D
avinash_shah
 
Posts: 9
Joined: Mon Oct 04, 2010 2:13 pm
Location: IN

Postby williamconley » Thu Apr 14, 2011 7:35 pm

i'm not sure i have a solution for you ... but some ideas

1) try using the command line lead loader instead of the php web page

2) try a different file with a single lead on a freshly created custom list with a single custom (text) field

3) upgrade to latest (you may already be, i didn't check yours against latest version, just thinking aloud)

4) consider moving the problem to a VMWare server (install the same version and copy your db into it for "play time", missing the "other" servers won't have much effect on the lead loader functions for playing around)
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby avinash_shah » Thu May 12, 2011 4:09 pm

Matt !!!

I am waiting for your inputs. Hope you get some free time from your schedule to look over here :)

@william: i tried loading using CLI and that works fine. The problem is in php something to do with mysql_num_fields() function expecting parameter to be resource and Boolean being passed to it
avinash_shah
 
Posts: 9
Joined: Mon Oct 04, 2010 2:13 pm
Location: IN

Postby williamconley » Thu May 12, 2011 9:48 pm

i gave 4 suggestions already 8)

i note an answer to the first one, which is useful information.

the fourth one was more of an exercise you could try.

but # 2 and # 3 have not been addressed as yet.
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 92 guests