Failed to update notification pager to new MS Teams URL

Icinga 2
1

Now that MS is updating their webhook URLs I was trying to update our users pager info to the updated URL, but got this error:

Storing icinga_user[operations] failed: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'pager' at row 1, query was: UPDATE icinga_user SET pager....

As I understand the URL string is too long? How should I do then?

Environment:
Icinga 2.12.1
Director 1.11.1
PHP 8.1.2-1ubuntu2.18

2

you can use custom vars in user objects too.

  • create a new datafield msteams_url
  • add it to a user template
  • use user.vars.msteams_url instead of user.pager
1 Like
3

OK great. I’ll try that road. :slight_smile:

4

Worked like a charm. Added a custom var on the user and used $user.vars.msteamurl$ in the notificationscript.
Thanks!

2 Likes