rake db:migrate_plugins fails

bitnami redmine 0.8.0 on ubuntu 8.10

I’m trying to install plugins (in linux user mode) and get the following failure message.

acmeuser@acme-lnx01:~/redmine-0.8.0-0/apps/redmine$ rake db:migrate_plugins
(in /home/acmeuser/redmine-0.8.0-0/apps/redmine)
Migrating engines…
rake aborted!
Access denied for user ‘bitnami’@’localhost’ to database ‘redmine_development’

(See full trace by running task with—trace)

I figure am not sending the right authentication info to MySQL. Section 8 of README.txt mentions two different user accounts (root and non-root) for MySQL. What am I doing wrong and how may I fix it.

Thanks.

Hi,

Check that the mysql database is running:

./ctlscript.sh status

And try to run the command into the redmine stack console:

$ cd redmine-0.8.0-0
$ ./use_redmine
$ cd apps/redmine
$ rake db:migrate_plugins

Cheers.

Followed verbatim and this is what I get.

~/redmine-0.8.0-0$ ./ctlscript.sh status
subversion already running
apache already running
redmine already running
mysql already running
~/redmine-0.8.0-0$ ./use_redmine 
bash-3.2$ 
bash-3.2$ cd apps/redmine/
bash-3.2$ ls
app   config  doc    files  lib  public    script   test  vendor
conf  db      extra  lang   log  Rakefile  scripts  tmp
bash-3.2$ 
bash-3.2$ rake db:migrate_plugins
(in /home/user/redmine-0.8.0-0/apps/redmine)
Migrating engines...
rake aborted!
Access denied for user 'bitnami'@'localhost' to database 'redmine_development'

(See full trace by running task with --trace)

bash-3.2$ rake --trace db:migrate_plugins
(in /home/user/redmine-0.8.0-0/apps/redmine)
** Invoke db:migrate_plugins (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate_plugins
Migrating engines...
rake aborted!
Access denied for user 'bitnami'@'localhost' to database 'redmine_development'
/home/user/redmine-0.8.0-0/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:527:in `real_connect'
/home/user/redmine-0.8.0-0/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:527:in `connect'
/home/user/redmine-0.8.0-0/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:186:in `initialize'
/home/user/redmine-0.8.0-0/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:85:in `new'
/home/user/redmine-0.8.0-0/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:85:in `mysql_connection'
/home/user/redmine-0.8.0-0/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:292:in `send'
/home/user/redmine-0.8.0-0/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:292:in `connection='
/home/user/redmine-0.8.0-0/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:260:in `retrieve_connection'
/home/user/redmine-0.8.0-0/apps/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection'
/home/user/redmine-0.8.0-0/apps/redmine/vendor/plugins/engines/lib/engines/plugin/migrator.rb:36:in `current_version'
/home/user/redmine-0.8.0-0/apps/redmine/vendor/plugins/engines/lib/engines/plugin/migrator.rb:22:in `migrate_plugin'
/home/user/redmine-0.8.0-0/apps/redmine/config/../vendor/plugins/engines/lib/engines/plugin.rb:122:in `migrate'
/home/user/redmine-0.8.0-0/apps/redmine/lib/tasks/migrate_plugins.rake:8
/home/user/redmine-0.8.0-0/apps/redmine/lib/tasks/migrate_plugins.rake:5:in `each'
/home/user/redmine-0.8.0-0/apps/redmine/lib/tasks/migrate_plugins.rake:5
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `execute'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `execute'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in `invoke_with_call_chain'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in `synchronize'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in `invoke_with_call_chain'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in `invoke_task'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `each'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in `top_level'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in `run'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in `run'
/home/user/redmine-0.8.0-0/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31
/home/user/redmine-0.8.0-0/ruby/bin/rake:19:in `load'
/home/user/redmine-0.8.0-0/ruby/bin/rake:19
bash-3.2$ 

Hi chakraps,

Could you try to run it in production mode ?

$ rake db:migrate_plugins RAILS_ENV=production

Hit a roadblock before I could try this one. I’ve opened a separate thread for that. will get back to this later.

Running it in production mode fixed it. The plugins are now accessible from inside Redmine. Thanks for the quick response and resolution.

Great to hear that it works now :)

Hi,

i get the same error. I’m using redmine 0.8.4-1 on windows xp.
I have just tried to run it in production mode.

Could you post the error that you are getting? Cheers.

Thanks a lot Carlos and to the rest of you. Changing the environment to ‘Production’ solved the issue. I really appreciate the way you guys help us newbies.
(Signed up just to say that)

Nice! Thanks for that kind words.

Hi,

Using the 1.2.0 version I’m also having issues with rake commands, even running them in production environment.
I have to precise that MySQL is running.

$ rake db:migrate

rake aborted!
Access denied for user ’bitnami’@’localhost’ to database ‘redmine_development’
___________________________________________________________________

$ rake db:migrate RAILS_ENV=production

rake aborted!
Mysql::Error: Commands out of sync; you can’t run this command now: SET NAMES ‘utf8’

Do you have any clues ?

Thank you very much,
thibault

finally found it!
If you’re running the stack under Windows (XP), you need to run the rake commands in the “Use bitnami redmine” utility. I was running it in an (Aptana Studio 3) terminal.

Hope this will help anybody experiencing similar issues.

Nice, thanks for sharing your solution.