Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does VICIDIAL work with BRIstufft Asterisk installations?

April 26, 2017Asterisk installations vicidial

0

Posted

Does VICIDIAL work with BRIstufft Asterisk installations?

1 Answer

0

Posted

Yes, but because of the way that the BRIstufft changes the formatting of the Asterisk uniqueid for calls you have to execute the following MySQL statements to alter the database to allow the longer uniqueids: ALTER TABLE live_inbound MODIFY uniqueid VARCHAR(40) NOT NULL; ALTER TABLE live_inbound_log MODIFY uniqueid VARCHAR(40) NOT NULL; ALTER TABLE live_inbound_log MODIFY uniqueid VARCHAR(40) NOT NULL; ALTER TABLE vicidial_manager MODIFY uniqueid VARCHAR(40) NOT NULL; ALTER TABLE vicidial_live_agents MODIFY uniqueid VARCHAR(40) NOT NULL; ALTER TABLE vicidial_auto_calls MODIFY uniqueid VARCHAR(40) NOT NULL; ALTER TABLE call_log DROP PRIMARY KEY; ALTER TABLE call_log DROP INDEX uniqueid; ALTER TABLE call_log MODIFY uniqueid VARCHAR(40) PRIMARY KEY UNIQUE NOT NULL; ALTER TABLE park_log DROP PRIMARY KEY; ALTER TABLE park_log DROP INDEX uniqueid; ALTER TABLE park_log MODIFY uniqueid VARCHAR(40) PRIMARY KEY UNIQUE NOT NULL; ALTER TABLE vicidial_log DROP PRIMARY KEY; ALTER TABLE vicidial_log