Project

General

Profile

Bug #1943

The Dashboard has encountered an exception!

Added by skynerv over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Dashboard UI
Target version:
Start date:
02/13/2016
Due date:
% Done:

0%


Description

New installation (2nd reinstall):

http://paste.fedoraproject.org/322339/55399761

Started POST "/user_sessions/initialize_system" for 10.20.30.108 at 2016-02-14 00:00:46 +0300
Processing by UserSessionsController#initialize_system as HTML
  Parameters: {"utf8"=>"?", "authenticity_token"=>"/vq+aVw6DIp2UXmfF0Eg/+wL81QPEn0/LMKb1FYDsk2XDnqzV8wM23                RNOFMHya8Y0bM1gXf9xX4wP9E0lXTUWA==", "username"=>"bingo", "password"=>"[FILTERED]", "password_confirmatio                n"=>"[FILTERED]", "commit"=>"???????"}
Mysql2::Error: Incorrect string value: '\xD0\xA1\xD0\xB5\xD1\x80...' for column 'comment' at row 1: INSER                T INTO `servers` (`name`, `pidfile`, `comment`, `created_at`, `updated_at`) VALUES ('mariadb', 'mariadb/m                ariadb.pid', '?????? MariaDB', '2016-02-13 21:00:46', '2016-02-13 21:00:46')
Completed 500 Internal Server Error in 30ms (ActiveRecord: 7.2ms)

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-02-13 21:00:46', '2016-02-13 21:00:4                6')):
  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'

Started GET "/tab/debug" for 10.20.30.108 at 2016-02-14 00:00:50 +0300

dump.sql View (16.4 KB) skynerv, 02/15/2016 08:08 AM

History

#1 Updated by bigfoot65 over 4 years ago

  • Status changed from New to Assigned
  • Assignee set to skynerv
  • Priority changed from Urgent to Normal

Which install guidance did you follow? What language, English or is this a different one?

Did you check that the Fedora 21 image was not corrupt?

Did you install anything manually after the Amahi 8 install?

Is this a real machine or a VM? Does it meet minimum system requirements required for Amahi?

#2 Updated by skynerv over 4 years ago

  • Status changed from Assigned to New
  • Assignee deleted (skynerv)
  • Priority changed from Normal to Urgent

bigfoot65 wrote:

Which install guidance did you follow? What language, English or is this a different one?

Did you check that the Fedora 21 image was not corrupt?

Did you install anything manually after the Amahi 8 install?

Is this a real machine or a VM? Does it meet minimum system requirements required for Amahi?

https://wiki.amahi.org/index.php/Amahi_8_Install - i followed this guide. Didn't know that install guide has other languages - i used English to install. Fedora was not corrupt. I followed the install guide strictly, so did not install anything else. This is a VirtualBox VM - i tried with both Guest tools installed and not. It does meet the minimum requrements.
All those questions are needless, if you direct your attention to that piece of log wich i posted -

Parameters: {"utf8"=>"?", "authenticity_token"=>"/vq+aVw6DIp2UXmfF0Eg/+wL81QPEn0/LMKb1FYDsk2XDnqzV8wM23 RNOFMHya8Y0bM1gXf9xX4wP9E0lXTUWA==", "username"=>"bingo", "password"=>"[FILTERED]", "password_confirmatio n"=>"[FILTERED]", "commit"=>"???????"}

COMMIT here is Create, but in russian for some reason (i have russian locale on the system)

Mysql2::Error: Incorrect string value: '\xD0\xA1\xD0\xB5\xD1\x80...' for column 'comment' at row 1: INSER T INTO `servers` (`name`, `pidfile`, `comment`, `created_at`, `updated_at`) VALUES ('mariadb', 'mariadb/m ariadb.pid', '?????? MariaDB', '2016-02-13 21:00:46', '2016-02-13 21:00:46')

Here, after 'mariadb/m ariadb.pid', follows Server MariaDB, also in russian.

So i assume the table in DB refuses to accept strings with russian encoding.

#3 Updated by woolear over 4 years ago

  • Status changed from New to Assigned
  • Assignee set to skynerv

totally the same behavior

#4 Updated by bigfoot65 over 4 years ago

  • Category changed from Dashboard UI to hda-install
  • Priority changed from Urgent to Normal
All those questions are needless, if you direct your attention to that piece of log wich i posted

I disagree as we need to know how you installed and the process that led to this error. Reading the log file does not always provide the context needed to assist.

I did not mean install guide in a different language. I mean what is the one you are choosing during install.

There could be an issue with the Russian encoding and will require more research.

Your patience is appreciated.

#5 Updated by skynerv over 4 years ago

  • Category changed from hda-install to Dashboard UI
  • Status changed from Assigned to New
  • Priority changed from Normal to Urgent

bigfoot65 wrote:

Your patience is appreciated.

Thank you.
During the install of Fedora i chose English locale. The system wich i use fore initial configuration is Russian.

#6 Updated by bigfoot65 over 4 years ago

  • Category changed from Dashboard UI to hda-install
  • Priority changed from Urgent to Normal

Why choose English locale for Fedora if your system is set to Russian locale? This is likely the issue. The Fedora install should match your system locale.

Also please do not change the status, category, and priority as this is set by us (developers), not the user.

#7 Updated by bigfoot65 over 4 years ago

  • Status changed from New to Assigned

#8 Updated by skynerv over 4 years ago

  • Category changed from hda-install to Dashboard UI
  • Status changed from Assigned to New
  • Priority changed from Normal to Urgent

Why choose English locale for Fedora if your system is set to Russian locale? This is likely the issue.

If this is the issue, than it is the most strange server software behavour i've ever seen.
I install linux OS with English locale, because in my native language (Russian) any console output is not readible and hardly understandable. All server OS are always installed in english.

And i didn't change statuses - they change if you answer message through the quote button.

#9 Updated by bigfoot65 over 4 years ago

  • Category changed from Dashboard UI to hda-install
  • Status changed from New to Assigned
  • Priority changed from Urgent to Normal

I have never heard that all OS are installed in English.

I am unsure what the issue could be that caused this failure. I will yield to our head developer to take a look at this issue.

#10 Updated by bigfoot65 over 4 years ago

  • Assignee changed from skynerv to cpg

#11 Updated by cpg over 4 years ago

  • Description updated (diff)

We thought we had solved this issue with #878 a while back.

However, this started to emerge as an issue some time ago where some of the mysql/mariadb database tables have still with the old default latin encoding and not utf8. We plan to make utf8 the new default.

Doing the conversion for an existing system is not trivial. If you want to try it, you can do it with the following guidance.

You can help us solve this issue by shading your database like this:

mysqldump -uroot -phda --add-drop-database  hda_production > dump.sql

and share dump.sql by reopening this bug and assigning it to me.

#12 Updated by woolear over 4 years ago

cpg wrote:

We thought we had solved this issue with #878 a while back.

However, this started to emerge as an issue some time ago where some of the mysql/mariadb database tables have still with the old default latin encoding and not utf8. We plan to make utf8 the new default.

Doing the conversion for an existing system is not trivial. If you want to try it, you can do it with the following guidance.

You can help us solve this issue by shading your database like this:

[...]

and share dump.sql by reopening this bug and assigning it to me.

Thanks, this solved my problem.

#13 Updated by cpg over 4 years ago

  • Status changed from Assigned to Closed

@woolear, can you be more specific, describing as exactly as possible what you did?

thanks for the feedback!

#14 Updated by woolear over 4 years ago

cpg wrote:

@woolear, can you be more specific, describing as exactly as possible what you did?

thanks for the feedback!

Yes, i can: I've converted my db from latin1 to utf8 trough dump>edit encoding and collation> attach dump back to db

#15 Updated by skynerv over 4 years ago

  • File dump.sql View added
  • Category changed from hda-install to Dashboard UI
  • Status changed from Closed to Assigned
  • Priority changed from Normal to Urgent

Hey, i made a dump for you.

#16 Updated by cpg over 4 years ago

looks like individual tables are

... ENGINE=InnoDB DEFAULT CHARSET=latin1;

maybe change that and do like @woolear did (from the guidance) and that should work.

you can grep -i latin dump.sql to find out where the instances of latin are.

#17 Updated by cpg over 4 years ago

  • Status changed from Assigned to Closed
  • Priority changed from Urgent to Normal

We will attempt to fix it in amahi 9.

Also available in: Atom