Opsview - 6.8 UTF-8 constraints fix.

In version 6.8 there is an issue that could cause errors such as the following

[Opsview.Web.ControllerBase.REST] [Opsview::Web::ControllerBase::REST:end158] [INFO] REST response (ERROR=400): PUT /rest/config/host Data:{ detail => "DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Duplicate entry 'Solar' for key 'name' [for Statement \"INSERT INTO opsview.hosts ( alias, check_attempts, check_command, check_interval, check_period, enable_snmp, other_addresses, rancid_autoenable, rancid_connection_type, rancid_password, rancid_username, rancid_vendor, retry_check_interval, snmp_community, snmp_extended_throughput_data, snmpv3_authprotocol, snmpv3_privpassword, snmpv3_privprotocol, snmpv3_username, tidy_ifdescr_level, use_rancid) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )\" with ParamValues: 0='', 1='2', 2=15, 3=0, 4=1, 5='0', 6='', 7='0', 8='1', 9=106, 10='SYMBOL - Server', 11='', 12=1, 13='', 14='d,f,r,u', 15=1, 16='', 17='0', 18='ssh', 19='', 20='', 21=undef, 22=60, 23=''] at /opt/opsview/corelibs/lib/Opsview/ResultSet.pm line 424", message => "Error trying to synchronise object",}

This is caused when the opsview-web component checks database input using unicode compliant regular expressions. Sometimes it matches existing values in the database as invalid, which causes these errors.

To remedy this, you will need to to copy new constraints files to the orchestrator (files attached in constraints.tar.gz)

1. Extract constraints.json, constraints_unhashed.json and constraints_schema.json to /opt/opsview/corelibs/lib/
2. Make sure the file owner is root:opsview.
3. Restart the opsview-web component: /opt/opsview/watchdog/bin/opsview-monit restart opsview-web