Problem updating Redmine to use mysql

[robin.imrie Profile]

I installed the Redmine app with initially worked fine, however I needed to change the database to mysql, which I did by following the installation instructions on the Redmine website.

I proved that the redmine application then worked using webrick.

When I then restarted the Redmine app via ISS I got the following..


500
Error
Helicon Zoo module has caught up an error. Please see the details below.

Worker Status

The process was created

Windows error
The pipe has been ended. (ERROR CODE: 109)
Internal module error

message: Application backend read Error.
type: ZooException
file: App\Jobs\JobBase.cpp
line: 531
version: 3.1.98.535

STDERR

[tid-5294460] Could not find mysql2-0.3.16 in any of the sources (Bundler::GemNotFound)
C:/inetpub/wwwroot/redmine/redmine/GEM_HOME/gems/bundler-1.6.3/lib/bundler/spec_set.rb:92:in `block in materialize'
C:/inetpub/wwwroot/redmine/redmine/GEM_HOME/gems/bundler-1.6.3/lib/bundler/spec_set.rb:85:in `map!'
C:/inetpub/wwwroot/redmine/redmine/GEM_HOME/gems/bundler-1.6.3/lib/bundler/spec_set.rb:85:in `materialize'
C:/inetpub/wwwroot/redmine/redmine/GEM_HOME/gems/bundler-1.6.3/lib/bundler/definition.rb:133:in `specs'
C:/inetpub/wwwroot/redmine/redmine/GEM_HOME/gems/bundler-1.6.3/lib/bundler/definition.rb:178:in `specs_for'
C:/inetpub/wwwroot/redmine/redmine/GEM_HOME/gems/bundler-1.6.3/lib/bundler/definition.rb:167:in `requested_specs'
C:/inetpub/wwwroot/redmine/redmine/GEM_HOME/gems/bundler-1.6.3/lib/bundler/environment.rb:18:in `requested_specs'
C:/inetpub/wwwroot/redmine/redmine/GEM_HOME/gems/bundler-1.6.3/lib/bundler/runtime.rb:13:in `setup'
C:/inetpub/wwwroot/redmine/redmine/GEM_HOME/gems/bundler-1.6.3/lib/bundler.rb:120:in `setup'
C:/inetpub/wwwroot/redmine/redmine/GEM_HOME/gems/bundler-1.6.3/lib/bundler/setup.rb:17:in `<top (required)>'
C:/Ruby19/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:60:in `require'
C:/Ruby19/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:60:in `rescue in require'
C:/Ruby19/lib/ruby/site_ruby/1.9.1/rubygems/custom_require.rb:35:in `require'
C:/Zoo/Workers/ruby/lib/app.rb:97:in `bundle_setup'
C:/Zoo/Workers/ruby/lib/app.rb:14:in `initialize'
C:/Zoo/Workers/ruby/lib/worker.rb:4:in `new'
C:/Zoo/Workers/ruby/lib/worker.rb:4:in `initialize'
C:/Zoo/Workers/ruby/zoorack.rb:30:in `new'
C:/Zoo/Workers/ruby/zoorack.rb:30:in `<module:Zack>'
C:/Zoo/Workers/ruby/zoorack.rb:12:in `<main>'

Environment variables
ALLUSERSPROFILE C:\ProgramData
APPDATA C:\Windows\system32\config\systemprofile\AppData\Roaming
APPL_ID redmine
APPL_PHYSICAL_PATH C:\inetpub\wwwroot\redmine\redmine
APPL_PHYSICAL_SHORT_PATH C:\inetpub\wwwroot\redmine\redmine
APPL_VIRTUAL_PATH /redmine
APP_POOL_CONFIG C:\inetpub\temp\apppools\redmine1\redmine1.config
APP_POOL_ID redmine1
COMMONPROGRAMFILES C:\Program Files\Common Files
COMMONPROGRAMFILES(X86) C:\Program Files (x86)\Common Files
COMMONPROGRAMW6432 C:\Program Files\Common Files
COMPUTERNAME SERVER
COMSPEC C:\Windows\system32\cmd.exe
CURRENT_DIRECTORY C:\inetpub\wwwroot\redmine\redmine
DEPLOY_FILE deploy.rb
ERROR_LOG_DIR log
FP_NO_HOST_CHECK NO
GEM_HOME C:\inetpub\wwwroot\redmine\redmine\GEM_HOME
GEM_PATH C:\inetpub\wwwroot\redmine\redmine\GEM_HOME
HOME C:\inetpub\wwwroot\redmine\redmine
HOST 127.0.0.1
IIS_BINDNGS http=*:8088:
INSTANCE_ID 2
LOCALAPPDATA C:\Windows\system32\config\systemprofile\AppData\Local
NUMBER_OF_PROCESSORS 4
OS Windows_NT
PATH C:\inetpub\wwwroot\redmine\redmine\GEM_HOME\bin;C:\Ruby19\bin;C:\Ruby19\devkit\bin;C:\Ruby19\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Perforce;C:\Program Files\Microsoft\Web Platform InstallerPATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE AMD64
PROCESSOR_IDENTIFIER Intel64 Family 6 Model 62 Stepping 4, GenuineIntel
PROCESSOR_LEVEL 6
PROCESSOR_REVISION 3e04
PROGRAMDATA C:\ProgramData
PROGRAMFILES C:\Program Files
PROGRAMFILES(X86) C:\Program Files (x86)
PROGRAMW6432 C:\Program Files
PSMODULEPATH C:\Windows\system32\WindowsPowerShell\v1.0\ModulesPUBLIC C:\Users\Public
RACK_ENV development
RAILS_ENV development
RAILS_RELATIVE_URL_ROOT /redmine
REDMINE_LANG en
SITE_NAME REDMINE
SITE_PHYSICAL_PATH C:\inetpub\wwwroot\redmine
SYSTEMDRIVE C:
SYSTEMROOT C:\Windows
TEMP C:\Windows\TEMP
TMP C:\Windows\TEMP
USERDOMAIN HAINUK
USERNAME SERVER$
USERPROFILE C:\Windows\system32\config\systemprofile
WINDIR C:\Windows
WORKER_REQUEST_TIMEOUT 1000
Helicon Zoo engine settings
appName rails.project
appFullPath C:\Ruby19\bin\ruby.exe
appDirectory C:\inetpub\wwwroot\redmine\redmine
appArguments C:\Zoo\Workers\ruby\zoorack.rb
deployArguments
transportName NamedPipe
protocol fastcgi
scriptProcessor ruby.1.9.rack
errorLogDir C:\inetpub\wwwroot\redmine\redmine\log
postBufferDir
watchFileChangesMask
host 127.0.0.1
port %PORT%
proxyPass
minInstances 1
maxInstances 4
minRequestsPerWorker 3
maxRequestsPerWorker 15
portLower 49152
portUpper 65535
workerRequestTimeout 1000
timeLimit 0
postBuffer 1024
memoryLimit 0
gracefulShutdownTimeout 30
Web.config variables
APPL_ID redmine
APPL_PHYSICAL_PATH C:\inetpub\wwwroot\redmine\redmine
APPL_PHYSICAL_SHORT_PATH C:\inetpub\wwwroot\redmine\redmine
APPL_VIRTUAL_PATH /redmine
CURRENT_DIRECTORY C:\inetpub\wwwroot\redmine\redmine
DEPLOY_FILE deploy.rb
ERROR_LOG_DIR log
GEM_HOME C:\inetpub\wwwroot\redmine\redmine\GEM_HOME
GEM_PATH C:\inetpub\wwwroot\redmine\redmine\GEM_HOME
HOME C:\inetpub\wwwroot\redmine\redmine
HOST 127.0.0.1
IIS_BINDNGS http=*:8088:
INSTANCE_ID 2
PATH C:\inetpub\wwwroot\redmine\redmine\GEM_HOME\bin;C:\Ruby19\bin;C:\Ruby19\devkit\bin;C:\Ruby19\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Perforce;C:\Program Files\Microsoft\Web Platform InstallerRACK_ENV development
RAILS_ENV development
RAILS_RELATIVE_URL_ROOT /redmine
REDMINE_LANG en
SITE_NAME REDMINE
SITE_PHYSICAL_PATH C:\inetpub\wwwroot\redmine
WORKER_REQUEST_TIMEOUT 1000

[RiskReward Profile]

Hi,

I've had exactly the same problem. I managed to get it running, and made the following rough notes which might point you in the right direction. I don't have any real expertise, so hopefully someone can review these and tell us a much simpler way to make it work:

1. Use MySQL Workbench to create redmine user, and three redmine schemas: redmine, redmine_development and test
2. Give the redmine user full access to those three schemas
3. edit the database.yml file in the redmine directory to set up the details to connect to the database
4. edit the helicon deploy file in the redmine23 root directory, by changing these lines to match this:
system_or_die('gem install bundler')
system_or_die('bundle install --without development test')
system_or_die('rake --trace generate_secret_token')
system_or_die('set RAILS_ENV=production')
system_or_die('rake --trace db:migrate')
system_or_die('set RAILS_ENV=production')
system_or_die('set REDMINE_LANG=en')
system_or_die("rake --trace redmine:load_default_data")
5. edit the gemfile in the root directory so that it uses an old version of the mysql connector

Change this line:
gem "mysql2", "~> 0.3.11", :platforms => [:mri, :mingw]

to look like this:

gem "mysql2", "= 0.3.11", :platforms => [:mri, :mingw]

5. point your web browser to localhost/redmine23 to kick off the Helicon installer.
6. To get email working change the file /config/configuration.yml to:
# default configuration options for all environments
default:
# Outgoing emails configuration (see examples above)
email_delivery:
delivery_method: :smtp
smtp_settings:
address: your.machines.address
port: 25
domain: your.domain
authentication: :login
user_name: "uname"
password: "pword"
you then need to restart the webserver using iis7, and in Redmine's admin/settings page change the "emission email address to "[email protected]"

Hopefully it should work! Obviously you need to replace my generic references like your.machines.address to your machine's actual address etc.

For some reason the install populates the redmine_development schema in the database, instead of the redmine schema. It must be something to do with the way I wrote "system_or_die('set RAILS_ENV=production')" (i.e. this is not really setting the production environment, so it's defaulting to the development environment.

Anyway, some better insight would be greatly appreciated!

[robin.imrie Profile]

Hi,

Thanks for your input. I did manage to resolve the problem. I discovered that there was a Zoo console (Via Helicon Manager), which I used with the Redmine installation instructions to install Redmine. Once I have done this and changed my Rails environment (RAILS_ENV) to production (as you did, except I did it via the Helicon Manager application) it started to work.

Regards

Robin