Project

General

Profile

Bug #2183

Dashboard exception with cyrillic names for servers

Added by Anonymous almost 3 years ago. Updated almost 2 years ago.

Status:
Feedback
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
11/15/2016
Due date:
% Done:

0%


Description

Immediately after install I faced with exception in dashboard. Here is the production.log file. As you can see, there is cyrillic words 'Сервер MariaDB'. I think, it is not ut8 encoding database. But I installed completely english version of system. What is wrong?
Processing by UserSessionsController#initialize_system as HTML
Parameters: {"utf8"=>"✓", "authenticity_token"=>"sxj4yrM1ILOdXpOIVJNk76LpVXzj2tu5qBh/C6RKrQJfmsaFTQGqFczE7m+CehIatXBwxCFpeQS2YiFKyLEVDQ==", "username"=>"yaroslav", "password"=>"[FILTERED]", "password_confirmation"=>"[FILTERED]", "commit"=>"Создать"}
Mysql2::Error: Incorrect string value: '\xD0\xA1\xD0\xB5\xD1\x80...' for column 'comment' at row 1: INSERT INTO `servers` (`name`, `pidfile`, `comment`, `created_at`, `updated_at`) VALUES ('mariadb', 'mariadb/mariadb.pid', 'Сервер MariaDB', '2016-11-15 15:13:32', '2016-11-15 15:13:32')
Completed 500 Internal Server Error in 129ms (ActiveRecord: 48.1ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xD0\xA1\xD0\xB5\xD1\x80...' for column 'comment' at row 1: INSERT INTO `servers` (`name`, `pidfile`, `comment`, `created_at`, `updated_at`) VALUES ('mariadb', 'mariadb/mariadb.pid', 'Сервер MariaDB', '2016-11-15 15:13:32', '2016-11-15 15:13:32')):
app/models/server.rb:37:in `create_default_servers'
app/controllers/user_sessions_controller.rb:119:in `initialize_default_settings'
app/controllers/user_sessions_controller.rb:103:in `initialize_system'

History

#1 Updated by cpg almost 3 years ago

  • Subject changed from Dashboard exception to Dashboard exception with cyrillic names for servers
  • Status changed from New to Feedback
  • Assignee set to Anonymous

correct that mariadb cannot handle the character set, apparently, but we can tell you that there has got to be a reason that it did that. we have hundreds of installs each week, virtually all of them in english and this does not happen.

however, what i am thinking is that your web server may be advertising a cyrillic based locale, which caused the first login to adapt to that locale (see the "commit"=>"Создать" part). that may have caused all the ruby/rails back-end to take the locale, and trickle into the server name.

can you try the first login again in english in your browser (ir you do not know how, you can add "?locale=en" to the url).

after first login happens (assuming it has not recorded it already), then switch to your locale of choice.

#2 Updated by cpg almost 2 years ago

user kdamyanov also experienced this issue in #2292

Also available in: Atom