vicidial custom fields error Unsigned Primary Key Not Null

Vicidial Error Unsigned Primary Key Not Null

Topic: vicidial custom fields error Unsigned Primary Key Not Null

  Overview:

    Vicidial is the most popular Open-Source Contact Center Solution in the world, that incorporates a predictive dialer to enable the blended handling of inbound / outbound calls alongside inbound emails and customer website chat.

  Issue : UNSIGNED PRIMARY KEY NOT NULL

While creating custom fields in vicidial you might get the below error.

Could not execute: |CREATE TABLE custom_ (lead_id INT(9) UNSIGNED PRIMARY KEY NOT NULL, name VARCHAR(5) );|

  Root Cause:

    In vicidial to create the Custom List Fields ,you  need the below mysql user credentials created and updated in astguiclient.conf file.

user:custom 
password:custom1234         

    These mysql user should be enabled with necessary permissions.

  Workaround:

    1. Create the mysql user "custom" with password "custom1234" in mysql cli copy paste the below commands

mysql -p

CREATE USER 'custom'@'localhost' IDENTIFIED BY 'custom1234';

    2. update the user custom with necessary permission, copy paste the below mysql command 

GRANT SELECT,INSERT,UPDATE,DELETE,LOCK,ALTER,CREATE TABLES on asterisk.* TO custom@'%' IDENTIFIED BY 'custom1234';

GRANT SELECT,INSERT,UPDATE,DELETE,LOCK,ALTER,CREATE TABLES on asterisk.* TO custom@localhost IDENTIFIED BY 'custom1234';

GRANT RELOAD ON *.* TO custom@'%';

GRANT RELOAD ON *.* TO custom@localhost;

flush privileges;    

    3. Make sure the user custom and password is updated in astguiclient.conf

vi /etc/astguiclient.conf
VARDB_custom_user => custom
VARDB_custom_pass => custom1234

Now add the custom fields

  Conclusion:

    Hope the article is helpful, for professional support reach me at skype:striker24x7