Can't install Endpoint Manager - error when processing Upgrade and Enable

Freepbx 13.0.192.19, PBX Firmware:10.13.66-21
OSS EPM was installed (as part of default install initially). Had been using that, but decided it was time to install commercial EPM.

Uninstalled OSS-EPM via Module Admin and got an error that it couldn’t run the uninstall scripts.
ran

[[email protected] ~]# fwconsole ma uninstall endpointman --force
The following error(s) occured:

  • Failed to run un-installation scripts

But Module Admin says OSS-EPM is uninstalled.

Purchased EPM and went to install it- need to update to the current version, but when I go through that process it craps out:


Here’s the contents of that tiny window:

Summary

INSERT INTO endpoint_timezones (id, location, htek, ciscoFxs, vtech, mbu, cortelco, mocet, and, panasonic, panasonic2, cisco, ciscoEnt, obihai, aastra, code, offset, snomv8, snom, grandstream, yealink, digium, dp715, incom, phoenix) VALUES (‘7’, ‘-06:00’, ‘14’, ‘-06 2 1’, ‘America/Chicago’, ‘6’, ‘9’, ‘12’, ‘America/Chicago’, ‘-360’, ‘-60003’, ‘-6’, ‘Central Standard/Daylight Time’, ‘(Central Time)’, ‘US-Central’, ‘CST’, ‘-21600’, ‘USA-6’, ‘310’, ‘CST6CDT’, ‘United States-Central Time’, ‘America/Chicago’, ‘TZE+6’, ‘44’, ‘Central Time (US & Canada)’), (‘1’, ‘-12:00’, ‘’, ‘’, ‘’, ‘0’, ‘0’, ‘0’, ‘Etc/GMT-12’, ‘-720’, ‘-’, ‘’, ‘Dateline Standard Time’, ‘(Int’l Dateline West)’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘TZA+12’, ‘’, ‘Dateline’), (‘2’, ‘-11:00’, ‘105’, ‘-11 1 0’, ‘Pacific/Pago_Pago’, ‘1’, ‘1’, ‘2’, ‘Etc/GMT-11’, ‘-660’, ‘-110001’, ‘-11’, ‘Samoa Standard Time’, ‘(Samoa)’, ‘AU-Perth’, ‘WST’, ‘-39600’, ‘’, ‘310’, ‘NZST-12NZDT-13,M10.1.0/02:00:00,M3.3.0/03:00:00’, ‘Samoa’, ‘Pacific/Midway’, ‘TZB+11’, ‘’, ‘Samoa’), (‘3’, ‘-10:00’, ‘1’, ‘-10 1 0’, ‘Pacific/Honolulu’, ‘2’, ‘2’, ‘4’, ‘Etc/GMT-10’, ‘-600’, ‘-100001’, ‘-10’, ‘Hawaiian Standard Time’, ‘(Hawaii)’, ‘US-Hawaii’, ‘HST’, ‘-36000’, ‘USA-10’, ‘310’, ‘HAW10’, ‘United States-Alaska-Aleutian’, ‘Pacific/Johnston’, ‘TZC+10’, ‘36’, ‘Hawaii’), (‘4’, ‘-09:00’, ‘3’, ‘-09 1 1’, ‘America/Anchorage’, ‘3’, ‘3’, ‘6’, ‘Etc/GMT-9’, ‘-540’, ‘-90002’, ‘-9’, ‘Alaskan Standard/Daylight Time’, ‘(Alaska)’, ‘US-Alaska’, ‘AKS’, ‘-32400’, ‘USA-9’, ‘299’, ‘AKST9AKDT’, ‘United States-Alaska’, ‘America/Anchorage’, ‘TZD+9’, ‘37’, ‘Alaska’), (‘5’, ‘-08:00’, ‘4’, ‘-08 1 1’, ‘America/Los_Angeles’, ‘4’, ‘4’, ‘8’, ‘America/Los_Angeles’, ‘-480’, ‘-80002’, ‘-8’, ‘Pacific Standard/Daylight Time’, ‘(Pacific Time)’, ‘US-Pacific’, ‘PST’, ‘-28800’, ‘USA-8’, ‘310’, ‘PST8PDT’, ‘United States-Pacific’, ‘America/Los_Angeles’, ‘TZE+8’, ‘39’, ‘Pacific Time (US & Canada)’), (‘6’, ‘-07:00’, ‘9’, ‘-07 2 1’, ‘America/Denver’, ‘5’, ‘5’, ‘10’, ‘America/Denver’, ‘-420’, ‘-70002’, ‘-7’, ‘Mountain Standard/Daylight Time’, ‘(Mountain Time)’, ‘US-Mountain’, ‘MST’, ‘-25200’, ‘USA-7’, ‘310’, ‘MST7MDT’, ‘United States-Mountain’, ‘America/Denver’, ‘TZE+7’, ‘41’, ‘Mountain Time (US & Canada)’), (‘8’, ‘-05:00’, ‘18’, ‘-05 2 1’, ‘America/New_York’, ‘7’, ‘12’, ‘14’, ‘America/New_York’, ‘-300’, ‘-50001’, ‘-5’, ‘Eastern Standard/Daylight Time’, ‘(Eastern Time)’, ‘US-Eastern’, ‘EST’, ‘-18000’, ‘USA-5’, ‘310’, ‘EST5EDT’, ‘United States-Eastern’, ‘America/New_York’, ‘TZE+5’, ‘47’, ‘Eastern Time (US & Canada)’), (‘9’, ‘-04:00’, ‘20’, ‘-04 2 1’, ‘America/Halifax’, ‘9’, ‘15’, ‘16’, ‘Etc/GMT-4’, ‘-240’, ‘-40003’, ‘-4’, ‘Atlantic Standard/Daylight Time’, ‘(Atlantic Time)’, ‘CA-Atlantic’, ‘AST’, ‘-14400’, ‘CAN-4’, ‘310’, ‘AST4ADT’, ‘Canada(Halifax,Saint John)’, ‘America/Argentina/San_Juan’, ‘TZE+4’, ‘50’, ‘Atlantic Time (Canada)’), (‘10’, ‘-03:30’, ‘26’, ‘-03.5 1 1’, ‘America/St_Johns’, ‘10’, ‘18’, ‘17’, ‘Etc/GMT-3’, ‘-210’, ‘’, ‘-3’, ‘Newfoundland Standard/Daylight Time’, ‘(Newfoundland)’, ‘’, ‘’, ‘-12600’, ‘CAN-3.5’, ‘’, ‘NST+3:30NDT+2:30,M4.1.0/00:01:00,M10.5.0/00:01:00’, ‘Canada-New Foundland(St.Johns)’, ‘America/St_Johns’, ‘TZE+3’, ‘51’, ‘Newfoundland’), (‘11’, ‘-03:00’, ‘28’, ‘-03 1 1’, ‘America/Argentina/Buenos_Aires’, ‘11’, ‘19’, ‘18’, ‘Etc/GMT-3’, ‘-180’, ‘-30002’, ‘-3’, ‘SA Eastern Standard Time’, ‘(Buenos Aires,Greenland)’, ‘AR-Buenos aires’, ‘ART’, ‘-10800’, ‘ARG-3’, ‘310’, ‘NST+3NDT+2,M4.1.0/00:01:00,M10.5.0/00:01:00’, ‘Argentina(Buenos Aires)’, ‘America/Argentina/Buenos_Aires’, ‘TZE+3’, ‘51’, ‘Buenos Aires’), (‘12’, ‘-02:00’, ‘31’, ‘-02 1 0’, ‘America/Sao_Paulo’, ‘13’, ‘22’, ‘20’, ‘Etc/GMT-2’, ‘-120’, ‘-20001’, ‘-2’, ‘Mid-Atlantic Standard/Daylight Time’, ‘(Mid-Atlantic)’, ‘’, ‘’, ‘-7200’, ‘BRA-2’, ‘’, ‘NST+2NDT+1,M4.1.0/00:01:00,M10.5.0/00:01:00’, ‘Brazil(no DST)’, ‘Atlantic/South_Georgia’, ‘TZE+2’, ‘52’, ‘Mid-Atlantic’), (‘13’, ‘-01:00’, ‘32’, ‘-01 1 2’, ‘Atlantic/Azores’, ‘14’, ‘23’, ‘22’, ‘Etc/GMT-1’, ‘-60’, ‘-10002’, ‘-1’, ‘Azores Standard/Daylight Time’, ‘’, ‘’, ‘’, ‘-3600’, ‘PRT-1’, ‘’, ‘’, ‘Portugal(Azores)’, ‘Atlantic/Azores’, ‘TZE+1’, ‘0’, ‘Azores’), (‘14’, ‘GMT’, ‘33’, ‘+00 2 2’, ‘’, ‘15’, ‘25’, ‘24’, ‘Etc/GMT’, ‘0’, ‘2’, ‘0’, ‘GMT Standard/Daylight Time’, ‘(London,Lisbon)’, ‘IE-Dublin’, ‘GMT’, ‘0’, ‘GBR-0’, ‘’, ‘GMT+0IST-1,M3.5.0/01:00:00,M10.5.0/02:00:00’, ‘GMT’, ‘Europe/Dublin’, ‘TZN+0’, ‘3’, ‘Dublin’), (‘15’, ‘+01:00’, ‘43’, ‘+01 2 2’, ‘Europe/Brussels’, ‘16’, ‘27’, ‘26’, ‘Etc/GMT+1’, ‘60’, ‘10003’, ‘+1’, ‘W. Europe Standard/Daylight Time’, ‘(Rome,Paris,Madrid)’, ‘IT-Rome’, ‘CET’, ‘3600’, ‘FRA+1’, ‘’, ‘CET-1CEST-2,M3.5.0/02:00:00,M10.5.0/03:00:00’, ‘Italy(Rome)’, ‘Europe/Paris’, ‘TZN+1’, ‘4’, ‘Paris’), (‘16’, ‘+02:00’, ‘61’, ‘+02 2 2’, ‘Europe/Paris’, ‘17’, ‘32’, ‘28’, ‘Etc/GMT+2’, ‘120’, ‘20002’, ‘+2’, ‘E. Europe Standard/Daylight Time’, ‘(Athens,Cairo)’, ‘GR-Athens’, ‘EET’, ‘7200’, ‘EGY+2’, ‘’, ‘EET-2EEST-3,M3.5.0/03:00:00,M10.5.0/04:00:00’, ‘Greece(Athens)’, ‘Europe/Athens’, ‘TZN+2’, ‘9’, ‘Athens’), (‘17’, ‘+03:00’, ‘73’, ‘+03 1 8’, ‘Europe/Moscow’, ‘18’, ‘38’, ‘30’, ‘Etc/GMT+3’, ‘180’, ‘30002’, ‘+3’, ‘Russian Standard/Daylight Time’, ‘(Moscow,Baghdad)’, ‘RU-Moscow’, ‘MSK’, ‘10800’, ‘RUS+3’, ‘’, ‘MSK-3MSD,M3.5.0/2,M10.5.0/3’, ‘Russia(Moscow)’, ‘Asia/Baghdad’, ‘TZN+3’, ‘13’, ‘Baghdad’), (‘18’, ‘+03:30’, ‘74’, ‘’, ‘Asia/Tehran’, ‘19’, ‘42’, ‘31’, ‘Etc/GMT+3’, ‘210’, ‘35001’, ‘+3’, ‘Iran Standard/Daylight Time’, ‘(Tehran)’, ‘’, ‘’, ‘12600’, ‘IRN+3.5’, ‘’, ‘’, ‘Iran(Teheran)’, ‘Asia/Tehran’, ‘TZN+3’, ‘16’, ‘Tehran’), (‘19’, ‘+04:00’, ‘77’, ‘+04 1 0’, ‘Asia/Tbilisi’, ‘20’, ‘43’, ‘32’, ‘Etc/GMT+4’, ‘240’, ‘40001’, ‘+4’, ‘Arabian Standard Time’, ‘(Abu Dhabi)’, ‘OM-Muscat’, ‘GST’, ‘14400’, ‘RUS+4’, ‘’, ‘CET-1CEST-2,M3.5.0/02:00:00,M10.5.0/03:00:00’, ‘Georgia(Tbilisi)’, ‘Asia/Dubai’, ‘TZN+4’, ‘17’, ‘Abu Dhabi’), (‘20’, ‘+04:30’, ‘77’, ‘’, ‘Asia/Tbilisi’, ‘21’, ‘45’, ‘33’, ‘Etc/GMT+4’, ‘270’, ‘45001’, ‘+4’, ‘Afghanistan Standard Time’, ‘(Kabul)’, ‘’, ‘’, ‘16200’, ‘’, ‘’, ‘’, ‘’, ‘Asia/Dubai’, ‘TZN+4’, ‘18’, ‘Afghanistan’), (‘21’, ‘+05:00’, ‘82’, ‘+05 1 7’, ‘Asia/Karachi’, ‘22’, ‘46’, ‘34’, ‘Etc/GMT+5’, ‘300’, ‘50001’, ‘+5’, ‘West Asia Standard Time’, ‘(Islamabad,Karachi)’, ‘’, ‘’, ‘18000’, ‘RUS+5’, ‘’, ‘’, ‘Pakistan(Islamabad)’, ‘Asia/Karachi’, ‘TZN+5’, ‘21’, ‘Islamabad’), (‘22’, ‘+05:30’, ‘84’, ‘+05.5 1 0’, ‘Asia/Karachi’, ‘23’, ‘48’, ‘35’, ‘Etc/GMT+5’, ‘330’, ‘55002’, ‘+5’, ‘India Standard Time’, ‘(New Delhi)’, ‘’, ‘GMT’, ‘19800’, ‘IND+5.5’, ‘’, ‘’, ‘India(Calcutta)’, ‘Asia/Karachi’, ‘TZN+5’, ‘19’, ‘Bombay’), (‘23’, ‘+05:45’, ‘84’, ‘’, ‘Asia/Karachi’, ‘24’, ‘49’, ‘35’, ‘Etc/GMT+5’, ‘345’, ‘57501’, ‘+5’, ‘Central Asia Standard Time’, ‘(Kathmandu)’, ‘’, ‘’, ‘20700’, ‘’, ‘’, ‘’, ‘’, ‘Asia/Karachi’, ‘TZN+5’, ‘21’, ‘’), (‘24’, ‘+06:00’, ‘86’, ‘+06 1 7’, ‘Asia/Novosibirsk’, ‘25’, ‘50’, ‘36’, ‘Etc/GMT+6’, ‘360’, ‘60001’, ‘+6’, ‘SE Asia Standard Time’, ‘’, ‘’, ‘’, ‘21600’, ‘RUS+6’, ‘’, ‘’, ‘Russia(Novosibirsk,Omsk)’, ‘Asia/Dhaka’, ‘TZN+6’, ‘22’, ‘Dhaka’), (‘25’, ‘+06:30’, ‘86’, ‘’, ‘Asia/Bangkok’, ‘26’, ‘53’, ‘37’, ‘Etc/GMT+6’, ‘390’, ‘65001’, ‘+6’, ‘SE Asia Standard Time’, ‘(Yangon)’, ‘’, ‘’, ‘23400’, ‘’, ‘’, ‘’, ‘’, ‘Asia/Bangkok’, ‘TZN+6’, ‘23’, ‘Bangkok’), (‘26’, ‘+07:00’, ‘88’, ‘+07 1 7’, ‘Asia/Bangkok’, ‘27’, ‘54’, ‘38’, ‘Etc/GMT+7’, ‘420’, ‘70001’, ‘+7’, ‘Taipei Standard Time’, ‘(Bangkok,Jakarta)’, ‘’, ‘’, ‘’, ‘RUS+7’, ‘’, ‘’, ‘Thailand(Bangkok)’, ‘Asia/Bangkok’, ‘TZN+7’, ‘23’, ‘’), (‘27’, ‘+08:00’, ‘90’, ‘+08 4 0’, ‘Asia/Singapore’, ‘28’, ‘56’, ‘40’, ‘Etc/GMT+8’, ‘480’, ‘80004’, ‘+8’, ‘China Standard/Daylight Time’, ‘(Beijing,HK,Singapore)’, ‘HK-Hong kong’, ‘HKS’, ‘28800’, ‘SGP+8’, ‘’, ‘SGT-8’, ‘Singapore(Singapore)’, ‘Asia/Singapore’, ‘TZN+8’, ‘28’, ‘Beijing’), (‘28’, ‘+09:00’, ‘93’, ‘+09 1 0’, ‘Asia/Tokyo’, ‘29’, ‘61’, ‘42’, ‘Etc/GMT+9’, ‘540’, ‘90001’, ‘+9’, ‘Tokyo Standard Time’, ‘(Tokyo,Seoul)’, ‘’, ‘’, ‘32400’, ‘JPN+9’, ‘’, ‘’, ‘Korea(Seoul)’, ‘Asia/Tokyo’, ‘TZN+9’, ‘32’, ‘Tokyo’), (‘29’, ‘+09:30’, ‘94’, ‘+09.5 1 10’, ‘Australia/Adelaide’, ‘30’, ‘64’, ‘43’, ‘Etc/GMT+9’, ‘570’, ‘95001’, ‘+9’, ‘AUS Central Standard Time’, ‘(Adelaide)’, ‘’, ‘’, ‘34200’, ‘AUS+9.5’, ‘’, ‘’, ‘Australia(Adelaide)’, ‘Australia/Adelaide’, ‘TZN+9’, ‘32’, ‘Adelaide’), (‘30’, ‘+10:00’, ‘96’, ‘+10 2 4’, ‘Australia/Sydney’, ‘31’, ‘66’, ‘44’, ‘Etc/GMT+10’, ‘600’, ‘100001’, ‘+10’, ‘E. Australia Standard Time’, ‘(Sydney,Guam)’, ‘’, ‘’, ‘36000’, ‘AUS+10’, ‘’, ‘’, ‘Australia(Sydney,Melbourne,Canberra)’, ‘Australia/Melbourne’, ‘TZN+10’, ‘34’, ‘Melbourne’), (‘31’, ‘+11:00’, ‘101’, ‘+11 1 0’, ‘Pacific/Noumea’, ‘32’, ‘71’, ‘46’, ‘Etc/GMT+11’, ‘660’, ‘110001’, ‘+11’, ‘Central Pacific Standard Time’, ‘(Solomon Is.)’, ‘’, ‘’, ‘39600’, ‘NCL+11’, ‘’, ‘’, ‘New Caledonia(Noumea)’, ‘Pacific/Noumea’, ‘TZN+11’, ‘’, ‘SolomanIs.’), (‘32’, ‘+12:00’, ‘102’, ‘+12 1 0’, ‘Pacific/Auckland’, ‘33’, ‘72’, ‘48’, ‘Etc/GMT+12’, ‘720’, ‘120002’, ‘+12’, ‘Fiji Standard Time’, ‘(Fiji,Auckland)’, ‘’, ‘’, ‘43200’, ‘RUS+12’, ‘’, ‘’, ‘New Zeland(Wellington,Auckland)’, ‘Pacific/Fiji’, ‘TZN+12’, ‘35’, ‘Fiji’), (‘33’, ‘+13:00’, ‘104’, ‘’, ‘Pacific/Tongatapu’, ‘34’, ‘’, ‘50’, ‘Etc/GMT+13’, ‘780’, ‘130001’, ‘+13’, ‘New Zealand Standard/Daylight Time’, ‘’, ‘’, ‘’, ‘46800’, ‘TON+13’, ‘’, ‘’, ‘Tonga(Nukualofa)’, ‘’, ‘TZN+13’, ‘’, ‘’), (‘34’, ‘-07:00 No DST’, ‘10’, ‘-07 1 0’, ‘America/Phoenix’, ‘5’, ‘5’, ‘10’, ‘America/Phoenix’, ‘-420’, ‘-70001’, ‘-7’, ‘US Mountain Standard Time’, ‘(Mountain Time)’, ‘US-Mountain’, ‘MST’, ‘-25200’, ‘USA2-7’, ‘2880’, ‘MST7’, ‘United States-MST no DST’, ‘US/Arizona’, ‘TZE+7’, ‘40’, ‘Mountain Time (US & Canada)’), (‘35’, ‘-03:00 Brasilia’, ‘29’, ‘-03 1 1’, ‘America/Argentina/Buenos_Aires’, ‘11’, ‘19’, ‘18’, ‘Etc/GMT-3’, ‘-180’, ‘-30002’, ‘-3’, ‘SA Eastern Standard Time’, ‘(Buenos Aires,Greenland)’, ‘AR-Buenos aires’, ‘ART’, ‘-10800’, ‘ARG-3’, ‘310’, ‘BRST+3BRDT+2,M10.3.0,M2.3.0’, ‘Brazil(DST)’, ‘America/Argentina/Buenos_Aires’, ‘TZE+3’, ‘51’, ‘Buenos Aires’) – SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘htek’ in ‘field list’::

Then to see if this was specific to this install I did the same on a second personal system, and I got the same results (so its not just this one box, its something about the process).
So not sure what to do next.

cd /var/www/html/admin/modules/
rm -rf endpoint
fwconsole ma uninstall restart
mysqlcheck --repair --all-databases
fwconsole ma downloadinstall endpoint
fwconsole r

The first time I rant that on one machine it still downloaded the v12 EPM, but then I went back in, removed it via Module Admin, then reran those commands again and it downloaded the v13.0.110 module, and then that worked.

Hello demani,

I had the same problem under FreePBX 14 with Asterisk 14 and End Point Manager 14.0.2.8.
While trying installing the module via fwconsole I got this error:

[Exception]
INSERT INTO endpoint_global (key, values) VALUES (‘legacyXML’, ‘Y’) – SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘legacyXML’ for key ‘key’::

For now I solved the problem as follows:

  1. connect asterisk db via commandline: # mysql asterisk
  2. SELECT * FROM endpoint_global
  3. | key | values |
    | legacyXML | Y |
    1 row in set (0.00 sec)
    This was the only entry in that table.
  4. So I delete this entry with “DELETE FROM endpoint_global;”
  5. After that I did “fwconsole ma downloadinstall endpoint”
  6. After a while the End Point Manager was installed successfully.
    Downloading module 'endpoint’
    Processing endpoint
    Verifying local module download…Verified
    Extracting…Done
    Download completed in 5 seconds
    Checking database tables…Done
    Migrating tables as required…Done
    Checking Settings and Defaults…Done
    Generating Configs…Done
    Downloading Firmware…Done (Background)
    Generating CSS…Done
    Module endpoint successfully installed
    Updating Hooks…Done

Enjoy

RudiS