[dev.icinga.com #7540] Unable to use diactritics in user attributes

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/7540

Created by skocdopolet on 2014-10-31 20:16:55 +00:00

Assignee: (none)
Status: New
Target Version: Backlog
Last Update: 2015-05-18 12:18:10 +00:00 (in Redmine)

Icinga Version: 2.1.1
Icinga Web Version: 1.11.2
IDO Version: 1.11.7
OS Version: FreeBSD 10.0-RELEASE-p10
DB Type: MySQL
DB Version: 5.5.40
Browser Version: IE 10

---

When are you try to modify user details for example surname field and use diactricitics character in value, you got this error into apache error log.

PHP Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\\xC4\\x8Ddopo...' for column 'session_data' at row 1' in /usr/local/share/icinga-web/lib/doctrine/lib/Doctrine/Connection.php:1090\nStack trace:\n#0 /usr/local/share/icinga-web/lib/doctrine/lib/Doctrine/Connection/Statement.php(274): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Statement))\n#1 /usr/local/share/icinga-web/lib/doctrine/lib/Doctrine/Connection.php(1050): Doctrine_Connection_Statement->execute(Array)\n#2 /usr/local/share/icinga-web/lib/doctrine/lib/Doctrine/Connection.php(661): Doctrine_Connection->exec('UPDATE nsm_sess...', Array)\n#3 /usr/local/share/icinga-web/lib/doctrine/lib/Doctrine/Connection/UnitOfWork.php(534): Doctrine_Connection->update(Object(Doctrine_Table), Array, Array)\n#4 /usr/local/share/icinga-web/lib/doctrine/lib/Doctrine/Connection/UnitOfWork.php(89): Doctrine_Connection_UnitOfWork->update(Object(NsmSession))\n# in /usr/local/share/icinga-web/lib/doctrine/lib/Doctrine/Connection.php on line 1090, referer: https://192.168.221.202/icinga-web/modules/appkit/admin/users

[icinga-migration]

Updated by mfrosch on 2014-11-18 15:16:42 +00:00

• Status changed from New to Feedback

I can not reproduce that problem on Debian wheezy with MySQL 5.5.40

Could that be a problem with your PHP or MySQL installation?

I changed my Name to "róòt" and it works. Also no problems with re-login.

[icinga-migration]

Updated by skocdopolet on 2014-11-18 19:43:02 +00:00

Hello,

thank you for reply. The characters "óò", which you tried are without any problems. Similary with this characters "šžýáíó" - without problem.

But if you try for example characters č ř ě ů, then you get this error.

Regards
Tomáš Skočdopole

[icinga-migration]

Updated by mfrosch on 2015-03-12 10:56:04 +00:00

• Target Version set to Backlog

I don't get an error when I add such characters to the name, but they appear as '?' in the database.

mysql-server                                 5.5.41-0+wheezy1
php5                                         5.4.36-0+deb7u3 

If someone wants to sponsor a patch I will be happy to apply it.

[icinga-migration]

Updated by mfriedrich on 2015-03-12 19:43:44 +00:00

• Status changed from Feedback to New