Bug #2183
Dashboard exception with cyrillic names for servers
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 5 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 4 years ago
user kdamyanov also experienced this issue in #2292
Also available in: Atom