Skip to main content

Hi, I followed this guide

https://www.centreon.com/seamless-collaboration-send-centreon-notifications-in-microsoft-teams-rooms/

and this topic

to solve the initial import password issue, now the users ans notification are imported with no issues but I have a webhook link that is really long (210 char), copied directly from the teams webhook, when importing thru CLAPI command I’m receiving this error:

Line 35 : SQLSTATET22001]: String data, right truncated: 1406 Data too long for column 'contact_pager' at row 1

 

My webhook format is like this:

https://mytenant.webhook.office.com/webhookb2/xxxxx-xxxxxxx-xxxx-xxxxxxxxxxxxxx@xxxxxxxxxxxxxxxxxxxx/IncomingWebhook/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxx

 

 

Hello @mx9421a2 

please see this post Seamless collaboration: Send Centreon notifications in Microsoft Teams rooms | Community

Warning!
Before loading the file, substitute these values with yours: 

  • <SET_CENTREON_URL>, the URL you use to access Centreon web UI.
  • <SET_TEAMSWEBHOOK_URL>, the Teams Webhook URL obtained previously. 

Sometimes, the Teams webhook URL can be longer than 200 characters. If this is your case, extend the size of the contact_pager row in the centreon configuration database. You can use this query: 

ALTER TABLE centreon.contact MODIFY contact_pager VARCHAR(255);

Reply