Error when trying to run the script on Redmine 2.2.3

[Eldadc]

(in /var/www/redmine)
rake aborted!
Don't know how to build task 'db:migrate_from_bugzilla'
/var/lib/gems/1.9.1/gems/rake-10.1.0/lib/rake/task_manager.rb:49:in []' /var/lib/gems/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:148:ininvoke_task'
/var/lib/gems/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:106:in block (2 levels) in top_level' /var/lib/gems/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:106:ineach'
/var/lib/gems/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:106:in block in top_level' /var/lib/gems/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:115:inrun_with_threads'
/var/lib/gems/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:100:in top_level' /var/lib/gems/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:78:inblock in run'
/var/lib/gems/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:165:in standard_exception_handling' /var/lib/gems/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:75:inrun'
/var/lib/gems/1.9.1/gems/rake-10.1.0/bin/rake:33:in <top (required)>' /usr/local/bin/rake:23:inload'
/usr/local/bin/rake:23:in `

'

[ralli]

The tasks name is redmine:migrate_from_bugzilla (not db:migrate_from_bugzilla)

I tested the migration. I had to change the task to make it work with ruby 1.9. Pushed a fix.

Can you please try if rake redmine:migrate_from_bugzilla works?
If you yield a similar result you can check if the task is properly installed by executing "rake -T | grep migrate"

HTH
Ralph

[Eldadc]

Please review my issue, I tried to install bugzilla-adapter but got an error:

gem install activerecord-bugzilla-adapter
ERROR: Could not find a valid gem 'activerecord-bugzilla-adapter' (>= 0) in any repository
ERROR: Possible alternatives: activerecord-nulldb-adapter, activerecord-mysql2-adapter, ac

---

rake aborted!
Please install the bugzilla adapter: gem install activerecord-bugzilla-adapter (cannot load such file -- active_record/conne
ction_adapters/bugzilla_adapter)
/var/lib/gems/1.9.1/gems/activesupport-3.2.12/lib/active_support/dependencies.rb:251:in require' /var/lib/gems/1.9.1/gems/activesupport-3.2.12/lib/active_support/dependencies.rb:251:inblock in require'
/var/lib/gems/1.9.1/gems/activesupport-3.2.12/lib/active_support/dependencies.rb:236:in load_dependency' /var/lib/gems/1.9.1/gems/activesupport-3.2.12/lib/active_support/dependencies.rb:251:inrequire'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_specification.rb:50:in
resolve_hash_connection' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_specification.rb:29:in spec'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_specification.rb:130:in
establish_connection' /var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:250:inblock in establish_connection'
/var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:247:in each' /var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:247:inestablish_connection'
/var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:515:in <module:BugzillaMigrate>' /var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:46:inblock (2 levels) in <top (required)>
'
Tasks: TOP => redmine:migrate_from_bugzilla
(See full trace by running task with --trace)
root@redmine lib/tasks# gem install activerecord-bugzilla-adapter
ERROR: Could not find a valid gem 'activerecord-bugzilla-adapter' (>= 0) in any repository
ERROR: Possible alternatives: activerecord-nulldb-adapter, activerecord-mysql2-adapter, ac

On Sunday, December 1, 2013 11:25 PM, Ralph Juhnke notifications@github.com wrote:

The tasks name is redmine:migrate_from_bugzilla (not db:migrate_from_bugzilla)
I tested the migration. I had to change the task to make it work with ruby 1.9. Pushed a fix.
Can you please try if rake redmine:migrate_from_bugzilla works?
If you yield a similar result you can check if the task is properly installed by executing "rake -T | grep migrate"
HTH
Ralph
—
Reply to this email directly or view it on GitHub.

[Eldadc]

Hi 

I managed to run it with mysql2 adapter , this is my error now:

Migrating profiles
rake aborted!
Can't connect to MySQL server on '192.168.18.137' (111)
/var/lib/gems/1.9.1/gems/mysql2-0.3.13/lib/mysql2/client.rb:58:in connect' /var/lib/gems/1.9.1/gems/mysql2-0.3.13/lib/mysql2/client.rb:58:ininitialize'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/mysql2_adapter.rb:16:in new' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/mysql2_adapter.rb:16:inmysql2_connection'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_pool.rb:315:in new_con nection' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_pool.rb:325:incheckou
t_new_connection'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_pool.rb:247:in block ( 2 levels) in checkout' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_pool.rb:242:inloop'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_pool.rb:242:in block i n checkout' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_pool.rb:239:incheckou
t'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_pool.rb:102:in block i n connection' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_pool.rb:101:inconnect
ion'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_pool.rb:410:in retriev e_connection' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_specification.rb:171:in retrieve_connection'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_specification.rb:145:in
connection' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/model_schema.rb:228:incolumns'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/model_schema.rb:237:in columns_hash' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/locking/optimistic.rb:129:inlocking_enabled?'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/relation.rb:170:in exec_queries' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/relation.rb:160:inblock in to_a'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/explain.rb:40:in logging_query_plan' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/relation.rb:159:into_a'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/relation/finder_methods.rb:159:in all' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/querying.rb:5:inall'
/var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:269:in migrate_users' /var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:517:inmodule:BugzillaMigrate'
/var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:46:in `block (2 levels) in <top (required)>
'
Tasks: TOP => redmine:migrate_from_bugzilla
(See full trace by running task with --trace) 

On Monday, December 2, 2013 9:58 AM, Eldad Cohen cohen_eldad@yahoo.com wrote:

Please review my issue, I tried to install bugzilla-adapter but got an error:

gem install activerecord-bugzilla-adapter
ERROR: Could not find a valid gem 'activerecord-bugzilla-adapter' (>= 0) in any repository
ERROR: Possible alternatives: activerecord-nulldb-adapter, activerecord-mysql2-adapter, ac

---

rake aborted!
Please install the bugzilla adapter: gem install activerecord-bugzilla-adapter (cannot load such file -- active_record/conne
ction_adapters/bugzilla_adapter)
/var/lib/gems/1.9.1/gems/activesupport-3.2.12/lib/active_support/dependencies.rb:251:in require' /var/lib/gems/1.9.1/gems/activesupport-3.2.12/lib/active_support/dependencies.rb:251:inblock in require'
/var/lib/gems/1.9.1/gems/activesupport-3.2.12/lib/active_support/dependencies.rb:236:in load_dependency' /var/lib/gems/1.9.1/gems/activesupport-3.2.12/lib/active_support/dependencies.rb:251:inrequire'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_specification.rb:50:in
resolve_hash_connection' /var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_specification.rb:29:in spec'
/var/lib/gems/1.9.1/gems/activerecord-3.2.12/lib/active_record/connection_adapters/abstract/connection_specification.rb:130:in
establish_connection' /var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:250:inblock in establish_connection'
/var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:247:in each' /var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:247:inestablish_connection'
/var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:515:in <module:BugzillaMigrate>' /var/www/redmine/lib/tasks/migrate_from_bugzilla-master/migrate_from_bugzilla.rake:46:inblock (2 levels) in <top (required)>
'
Tasks: TOP => redmine:migrate_from_bugzilla
(See full trace by running task with --trace)
root@redmine lib/tasks# gem install activerecord-bugzilla-adapter
ERROR: Could not find a valid gem 'activerecord-bugzilla-adapter' (>= 0) in any repository
ERROR: Possible alternatives: activerecord-nulldb-adapter, activerecord-mysql2-adapter, ac

On Sunday, December 1, 2013 11:25 PM, Ralph Juhnke notifications@github.com wrote:

The tasks name is redmine:migrate_from_bugzilla (not db:migrate_from_bugzilla)
I tested the migration. I had to change the task to make it work with ruby 1.9. Pushed a fix.
Can you please try if rake redmine:migrate_from_bugzilla works?
If you yield a similar result you can check if the task is properly installed by executing "rake -T | grep migrate"
HTH
Ralph
—
Reply to this email directly or view it on GitHub.

[ralli]

Have you been trying to connect to the mysql server from your machine via commandline?

The stack trace states the script cannot get a TCP/IP connection to the mysql service on host 192.168.18.137.

[Eldadc]

Hi,

Yes it is probably connection issue.
Can you tell please which user should grant permission to the db , the bugzilla user or redmine ?

Thanks

Sent from Yahoo Mail for iPhone

[ralli]

The connection in your stacktrace is against the bugzilla database.

The user connecting to the bugzilla database will need read permissions.

The user connecting to the redmine database will need write permissions. it will not create any new tables, so DDL-Statements will not be neccessary.