Geek Answers Handbook

"An error occurred while trying to load the gem" mysql2 ". (Bundler :: GemRequireError): an error appears after installing redmine

I am transferring redmine from our local office server to the online server so that anyone dealing with error management does not need to have a VPN account to access redmine.

So, we decided to use Bluehost.com because we saw that their default version of Ruby is 1.9.3 (which works with redmine), while the other hosts we checked were at 1.8.7

Well, I finished creating the background, now to the main storyline:

I have been trying for several days to install redmine on the server without success. The error I get is this: Error message:

An error occurred while trying to load the gem 'mysql2'. (Bundler :: GemRequireError)

Exception Class: PhusionPassenger :: UnknownError

Here are a few details:

Ruby version 1.9.3 Redmine version 3.2.2 Rails Version 4.2.5.2 (installed as part of the redmine package) MySQL version 5.5.42

I used several manuals on the Internet on how to install redmine on a server. one of which was the director of Bluehost: https://my.bluehost.com/cgi/help/redmine

What I tried after a thorough search of StackOverflow:

  • I read that sometimes mysql2 stones have a problem and need to be reinstalled again after the package, so I did gem install mysql2
  • I also tried installing a specific version when someone here said that the mysql2 stone works with bluehost in version 0.3.16 or other similar versions. Does not work.
  • Ruby 2.3.1, , , , , .
  • (, WEBrick Thin), Bluehost , , . .

, , 4 , , . , Ruby on Rails ( Ruby), .

- , ? :

production.log:

Migrating to InsertAllowedStatusesForNewIssues (20150725112753)
Migrating to CreateImports (20150730122707)
Migrating to CreateImportItems (20150730122735)
Migrating to ChangeTimeEntriesCommentsLimitTo1024 (20150921204850)
Migrating to ChangeWikiContentsCommentsLimitTo1024 (20150921210243)
Migrating to ChangeAttachmentsFilesizeLimitTo8 (20151020182334)
Migrating to FixCommaInUserFormatSettingValue (20151020182731)
Migrating to ChangeIssueCategoriesNameLimitTo60 (20151021184614)
Migrating to ChangeAuthSourcesFilterToText (20151021185456)
Migrating to ChangeUserPreferencesHideMailDefaultToTrue (20151021190616)
Migrating to AddTokensUpdatedOn (20151024082034)
Migrating to CreateCustomFieldEnumerations (20151025072118)
Migrating to AddProjectsDefaultVersionId (20151031095005)

, development.log , , . cpanel :

'  ^[[1m^[[36m (0.2ms)^[[0m  ^[[1mSHOW CREATE TABLE `wikis`^[[0m
  ^[[1m^[[35m (0.3ms)^[[0m  SELECT fk.referenced_table_name as 'to_table'
      ,fk.referenced_column_name as 'primary_key'
      ,fk.column_name as 'column'
      ,fk.constraint_name as 'name'
FROM information_schema.key_column_usage fk
WHERE fk.referenced_column_name is not null
  AND fk.table_schema = 'skredmin_redmine2'
  AND fk.table_name = 'workflows'

!

+4
2

mysql2

redmine, , mysql . , , .

+6

mysql2 gem gemfile:

gem 'mysql2', '~> 0.3.18'

.

+2

More articles:


All Articles