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
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 -pCREATE 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
Conclusion:
Hope the article is helpful, for professional support reach me at skype:striker24x7
vicidial custom fields error UNSIGNED PRIMARY KEY NOT NULL