Thin redmine 서버가 정상동작하지 않을 때¶
Error의 원인¶
Redmine에 Google Calender Plug-In을 설치하다가 SSL Certification 문제로 Ruby의 bundle install에서 Error가 발생하였다.
다음과 같다.
C:\Bitnami\redmine-2.6.5-0\apps\redmine\htdocs>bundle install Fetching source index from https://rubygems.org/ Retrying source fetch due to error (2/3): Bundler::Fetcher::CertificateFailureEr ror Could not verify the SSL certificate for https://rubygems.org/. There is a chance you are experiencing a man-in-the-middle attack, but most like ly your system doesn't have the CA certificates needed for verification. For inf ormation about OpenSSL certificates, see bit.ly/ruby-ssl. To connect without usi ng SSL, edit your Gemfile sources and change 'https' to 'http'. Retrying source fetch due to error (3/3): Bundler::Fetcher::CertificateFailureEr ror Could not verify the SSL certificate for https://rubygems.org/. There is a chance you are experiencing a man-in-the-middle attack, but most like ly your system doesn't have the CA certificates needed for verification. For inf ormation about OpenSSL certificates, see bit.ly/ruby-ssl. To connect without usi ng SSL, edit your Gemfile sources and change 'https' to 'http'. Could not verify the SSL certificate for https://rubygems.org/. There is a chance you are experiencing a man-in-the-middle attack, but most likely your system doesn't have the CA certificates needed for verification. For information about OpenSSL certificates, see bit.ly/ruby-ssl. To connect without using SSL, edit your Gemfile sources and change 'https' to 'http'.
Redmine의 버전이 너무 오래되어 Ruby 관련 및 Git, SSL등이 업그레이드 되었는데 해당되는 SSL 정책들이 바뀌었음에도 이를 제대로 반영하지 못했기 때문이다.
해결방법은 올바른 pem 파일을 잘 등록 시켜주고 이것으로 SSL Certification이 이루어지도록 하면 된다.
이것이 성공적이었음¶
https://gist.github.com/fnichol/867550
에서 cacert.pem 파일을 받는다.
cacert.pem 파일은 SSL 관련 업데이트가 크게 이루어질 때 마다, 변화하기 때문에 가급적 최신 pem 파일을 받아야 한다.
다음과 같이 환경변수를 잡고
C:\Bitnami\redmine-2.6.5-0\apps\redmine\htdocs>SET SSL_CERT_FILE=c:\Users\root\c
acert.pem
테스트 해본다.
C:\Bitnami\redmine-2.6.5-0\apps\redmine\htdocs>gem sources *** CURRENT SOURCES *** https://rubygems.org/ C:\Bitnami\redmine-2.6.5-0\apps\redmine\htdocs>gem install bundler Fetching: bundler-1.16.2.gem (100%) Successfully installed bundler-1.16.2 Parsing documentation for bundler-1.16.2 Installing ri documentation for bundler-1.16.2 1 gem installed
이렇다고 해서 thin_redmine이 Stop 되는 것이 고쳐지는 것은 아니다. 단지 bundler가 Update된 것일 뿐이다.
실제로 bundle install을 수행하자.
다음과 같이 정상적으로 install 됨을 확인할 수 있다.
C:\Bitnami\redmine-2.6.5-0\apps\redmine\htdocs>bundle install The dependency activerecord-jdbc-adapter (~> 1.3.2) will be unused by any of the platforms Bundler is installing for. Bundler is installing for ruby, x86-mingw3 2 but the dependency is only for java. To add those platforms to the bundle, run `bundle lock --add-platform java`. The dependency activerecord-jdbcmysql-adapter (>= 0) will be unused by any of th e platforms Bundler is installing for. Bundler is installing for ruby, x86-mingw 32 but the dependency is only for java. To add those platforms to the bundle, ru n `bundle lock --add-platform java`. Fetching gem metadata from https://rubygems.org/.......... Fetching gem metadata from https://rubygems.org/. Resolving dependencies....... RubyGems 2.0.14 is not threadsafe, so your gems will be installed one at a time. Upgrade to RubyGems 2.1.0 or higher to enable parallel gem installation. Using rake 10.4.2 Fetching insensitive_hash 0.3.3 Installing insensitive_hash 0.3.3 Installing tzinfo 0.3.44 Fetching TimezoneParser 0.2.0 Installing TimezoneParser 0.2.0 Installing i18n 0.6.11 Installing multi_json 1.11.0 Installing activesupport 3.2.21 Installing builder 3.0.4 Installing activemodel 3.2.21 Installing erubis 2.7.0 Installing journey 1.0.4 Installing rack 1.4.5 Installing rack-cache 1.2 Installing rack-test 0.6.3 Installing hike 1.2.3 Installing tilt 1.4.1 Installing sprockets 2.2.3 Installing actionpack 3.2.21 Installing mime-types 1.25.1 Installing polyglot 0.3.5 Installing treetop 1.4.15 Installing mail 2.5.4 Installing actionmailer 3.2.21 Installing arel 3.0.3 Installing activerecord 3.2.21 Installing activeresource 3.2.21 Fetching public_suffix 2.0.5 Installing public_suffix 2.0.5 Fetching addressable 2.5.2 Installing addressable 2.5.2 Using bundler 1.16.2 Installing coderay 1.1.0 Installing daemons 1.1.9 Installing eventmachine 1.0.3 (x86-mingw32) Fetching multipart-post 2.0.0 Installing multipart-post 2.0.0 Fetching faraday 0.15.2 Installing faraday 0.15.2 Installing json 1.8.2 (x86-mingw32) Fetching jwt 1.5.6 Installing jwt 1.5.6 Fetching signet 0.8.1 Installing signet 0.8.1 Fetching google_calendar 0.5.2 Installing google_calendar 0.5.2 Installing rack-ssl 1.3.4 Installing rdoc 3.12.2 Installing thor 0.19.1 Installing railties 3.2.21 Installing jquery-rails 3.1.2 Installing mysql2 0.3.18 (x86-mingw32) Installing net-ldap 0.3.1 Installing ruby-openid 2.3.0 Installing rack-openid 1.4.2 Installing rails 3.2.21 Installing rbpdf 1.18.5 Installing redcarpet 2.3.0 (x86-mingw32) Installing request_store 1.0.5 Installing rmagick 2.13.4 (x86-mingw32) Installing thin 1.6.1 (x86-mingw32) Updating files in vendor/cache * insensitive_hash-0.3.3.gem * TimezoneParser-0.2.0.gem * public_suffix-2.0.5.gem * addressable-2.5.2.gem * multipart-post-2.0.0.gem * faraday-0.15.2.gem * jwt-1.5.6.gem * signet-0.8.1.gem * google_calendar-0.5.2.gem Bundle complete! 28 Gemfile dependencies, 53 gems now installed. Gems in the groups development, test and sqlite were not installed. Use `bundle info [gemname]` to see where a bundled gem is installed. Post-install message from rdoc: Depending on your version of ruby, you may need to install ruby rdoc/ri data: <= 1.8.6 : unsupported = 1.8.7 : gem install rdoc-data; rdoc-data --install = 1.9.1 : gem install rdoc-data; rdoc-data --install >= 1.9.2 : nothing to do! Yay! Post-install message from mysql2: ================================================================================ ====================== You've installed the binary version of mysql2. It was built using MySQL Connector/C version 6.1.5. It's recommended to use the exact same version to avoid potential issues. At the time of building this gem, the necessary DLL files were retrieved from: http://cdn.mysql.com/Downloads/Connector-C/mysql-connector-c-6.1.5-win32.zip This gem *includes* vendor/libmysql.dll with redistribution notice in vendor/R EADME. ================================================================================ ====================== Post-install message from rmagick: Please report any bugs. See https://github.com/gemhome/rmagick/compare/RMagick_2 -13-2...master and https://github.com/rmagick/rmagick/issues/18 C:\Bitnami\redmine-2.6.5-0\apps\redmine\htdocs>
그 다음, rake redmine:plugins:migrate RAILS_ENV=production 을 수행하여 plugin을 등록해 준다.
C:\Bitnami\redmine-2.6.5-0\apps\redmine\htdocs>rake redmine:plugins:migrate RAILS_ENV=production DL is deprecated, please use Fiddle rake aborted! Mysql2::Error: Can't connect to MySQL server on '127.0.0.1' (10061)
이렇게 모든 절차가 완료 되어야 Thin_Redmine서버가 정상적으로 동작하기 시작한다.
정상 동작까지는 약간의 시간이 걸린다 (약 2~3 분 정도 , PHP SQL에 해당 내용이 모두 반영되는데 시간이 걸리는 것으로 보인다.)
