custom field_connect

[ruben23]

Version: 2.6b0.5
DB Schema Version: 1337
DB Schema Update Date: 2013-01-03 20:08:40
Auto User-add Value: 101
asterisk 1.4.21
Dahdi

Hi i added custom leads on a particular list ID and submitted but i get this error...Any Idea..?

[bbakirtas]

Did you change custom password ?

[ruben23]

yes it still the same

# Database connection information
VARDB_server => 172.16.0.32
VARDB_database => asterisk
VARDB_user => cron
VARDB_pass => 1234
VARDB_custom_user => custom
VARDB_custom_pass => custom1234
VARDB_port => 3306

[brett05]

first this is a quick demo from vicidial site : http://www.vicidial.org/vicidial_demo/a ... custom.htm

then you need to be sire that you have done this is your database asterisk :

MySQL tables:
####### FOR REFERENCE ONLY, DO NOT USE THESE!!!!!!!!!!!!! ########

GRANT ALTER,CREATE on asterisk.* TO custom@'%' IDENTIFIED BY 'custom1234';
GRANT ALTER,CREATE on asterisk.* TO custom@localhost IDENTIFIED BY 'custom1234';

ALTER TABLE system_settings ADD custom_fields_enabled ENUM('0','1') default '0';

ALTER TABLE vicidial_users ADD custom_fields_modify ENUM('0','1') default '0';

CREATE TABLE vicidial_lists_fields (
field_id INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
list_id BIGINT(14) UNSIGNED NOT NULL DEFAULT '0',
field_label VARCHAR(50),
field_name VARCHAR(1000),
field_description VARCHAR(100),
field_rank SMALLINT(5),
field_help VARCHAR(1000),
field_type ENUM('TEXT','AREA','SELECT','MULTI','RADIO','CHECKBOX','DATE','TIME') default 'TEXT',
field_options VARCHAR(5000),
field_size SMALLINT(5),
field_max SMALLINT(5),
field_default VARCHAR(255),
field_cost SMALLINT(5),
field_required ENUM('Y','N') default 'N',
name_position ENUM('LEFT','TOP') default 'LEFT',
multi_position ENUM('HORIZONTAL','VERTICAL') default 'HORIZONTAL',
field_order SMALLINT(5) default '1'
);

CREATE UNIQUE INDEX listfield on vicidial_lists_fields (list_id, field_label);







CREATE TABLE vicidial_lead_import_map (
map_id VARCHAR(50) PRIMARY KEY NOT NULL,
map_name VARCHAR(50) DEFAULT '',
map_notes VARCHAR(255) DEFAULT ''
);

CREATE TABLE vicidial_lead_import_map_fields (
map_id VARCHAR(50) NOT NULL,
file_field SMALLINT(5),
db_field VARCHAR(100),
field_functions VARCHAR(255) DEFAULT '',
field_notes VARCHAR(100) DEFAULT '',
index (map_id)
);

CREATE UNIQUE INDEX mapdbfield on vicidial_lead_import_map_fields (map_id, file_field, db_field);

[williamconley]

And please post your installer version (.iso name or a link to the installation instructions you used ...).

Consider building a Vicibox 4.0.3 system in a virtual machine for comparison if this was not the method you used to install (available at Vicibox.com, thanks to Kumba!)

[ruben23]

@ williamconley

Scratch install SVN trunk
Ubuntu Server 12.04 LTS
Asterisk 1.8
DAHDI current

i tried like 4 setup and still same issue after i add the custom field this is the output

----> Could not connect: 172.16.0.32|3306|asterisk|custom|custom1234

what could be the problem

@brett05

should i entry this all mysql insert,update and query..? Thanks

[ruben23]

Hi guys solved and work permission issue only with custom tables. Big Thanks brett05 »

[williamconley]

Good post back