Page 1 of 1

MySQL connect ERROR: Custom Field List

PostPosted: Sat Jan 18, 2014 2:38 pm
by bluestream
When Creating a Custom Field for a list, get database error: MySQL connect ERROR:

I have also Tried this on the demo website as well and get the same error.

Steps:
Lists>List Custom Fields>(Find a List Click Modify Fields)

ADD A NEW CUSTOM FIELD FOR THIS LIST:
New Field Rank: 1 Field Order: 1
Field Label: ip_address
Field Name: IP Address
Field Description: IP Address
Field Type: TEXT
Field Size: 10
Field Max: 20
Field Default: NULL


Scratch Install Centos 5.9 | Vicidial 2.8-421a Build 140108-0752 | Asterisk 1.4.39.1-vici | VmWare ESXI 5.1.0 Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel Xeon X3440

Re: MySQL connect ERROR: Custom Field List

PostPosted: Sun Feb 02, 2014 9:13 pm
by williamconley
Since you get this error and no one else does, and you scratch installed instead of using a stock installer ... I'm going to venture a guess that this is related to your installer.

Why scratch install when you are installing on vSphere? You can install quite successfully with either Vicibox 5.0.3 or Goautodial (either iso will work quite nicely). If you must have CentOS 5.9 stock os for some other reason, you can use the yum installer for goautodial from their site which will perform the full install for you and should allow all functionality.

If you want to troubleshoot, on the other hand, you'll need to add "&DB=1" to your URL before you attempt to create the new custom field and see if you get any help from the debug data on the page.

PS: I have no idea what "the demo website" is.

PSS: Do NOT try to use a virtual server in production for more than a single agent. Have hardware standing by or be sure to NOT rely on it working under load. As a rule, one agent is viable, two is debatable and after that it will fall apart. I have heard claims otherwise, but I've not heard any from any "newbie" who actually "just made it work" ... and everyone who has said it has had a reason to make the claim that makes me believe they are not as forthcoming on the topic as they could be (ie: likely that at least one part of the server cluster is running on Hardware ... or some other non-standard setup). But to date I've not encountered anyone who has shown me a virtual vicidial standalone server actually supporting a dozen agents.