Project

General

Profile

Redmine access issue

Added by César Olivieri almost 9 years ago

Hello
I installed the version 2.5.1-2 of bitnami redmine on a virtual machine. During the installation on Windows XP I haven't any problem, but when I when want to log in, I had a problem. This is the message:

Internal error

An error occurred on the page you were trying to access.
If you continue to experience problems please contact your Redmine administrator for assistance.

If you are the Redmine administrator, check your log files for details about the error.

And here you are the logs:

Production.log:

Connecting to database specified by database.yml
Migrating to Setup (1)
Connecting to database specified by database.yml
Connecting to database specified by database.yml
Connecting to database specified by database.yml
Creating scope :system. Overwriting existing method Enumeration.system.
Creating scope :system. Overwriting existing method Enumeration.system.
Creating scope :sorted. Overwriting existing method Group.sorted.
Creating scope :sorted. Overwriting existing method Group.sorted.
Creating scope :sorted. Overwriting existing method User.sorted.
Creating scope :sorted. Overwriting existing method User.sorted.
Started GET "/redmine/" for 127.0.0.1 at 2015-04-28 17:17:52 -0300
Processing by WelcomeController#index as HTML
Completed 500 Internal Server Error in 109.4ms

ActiveRecord::StatementInvalid (Mysql2::Error: Table 'bitnami_redmine.settings' doesn't exist: SHOW FULL FIELDS FROM settings):
app/models/setting.rb:226:in check_cache'
app/controllers/application_controller.rb:97:inuser_setup'

Started GET "/redmine/" for 127.0.0.1 at 2015-04-28 17:23:52 -0300
Processing by WelcomeController#index as HTML
Completed 500 Internal Server Error in 843.8ms

ActiveRecord::StatementInvalid (Mysql2::Error: Table 'bitnami_redmine.settings' doesn't exist: SHOW FULL FIELDS FROM settings):
app/models/setting.rb:226:in check_cache'
app/controllers/application_controller.rb:97:inuser_setup'

Started GET "/redmine/" for 127.0.0.1 at 2015-04-28 17:37:28 -0300
Processing by WelcomeController#index as HTML
Completed 500 Internal Server Error in 78.1ms

ActiveRecord::StatementInvalid (Mysql2::Error: Table 'bitnami_redmine.settings' doesn't exist: SHOW FULL FIELDS FROM settings):
app/models/setting.rb:226:in check_cache'
app/controllers/application_controller.rb:97:inuser_setup'

Access.log:
127.0.0.1 - - [28/Apr/2015:17:17:34 -0300] "GET / HTTP/1.1" 200 1090
127.0.0.1 - - [28/Apr/2015:17:17:36 -0300] "GET /bitnamistack.css HTTP/1.1" 200 698
127.0.0.1 - - [28/Apr/2015:17:17:36 -0300] "GET /img/bitnami.png HTTP/1.1" 200 3738
127.0.0.1 - - [28/Apr/2015:17:17:36 -0300] "GET /img/redmine.png HTTP/1.1" 200 3649
127.0.0.1 - - [28/Apr/2015:17:17:36 -0300] "GET /img/header_bg.png HTTP/1.1" 200 147
127.0.0.1 - - [28/Apr/2015:17:17:36 -0300] "GET /img/sub_header_bg.png HTTP/1.1" 200 146
127.0.0.1 - - [28/Apr/2015:17:17:51 -0300] "GET /redmine/ HTTP/1.1" 500 646
127.0.0.1 - - [28/Apr/2015:17:20:16 -0300] "GET /phpmyadmin HTTP/1.1" 301 236
127.0.0.1 - - [28/Apr/2015:17:20:16 -0300] "GET /phpmyadmin/ HTTP/1.1" 200 2805
127.0.0.1 - - [28/Apr/2015:17:20:18 -0300] "GET /phpmyadmin/themes/pmahomme/jquery/jquery-ui-1.9.2.custom.css HTTP/1.1" 200 6177
127.0.0.1 - - [28/Apr/2015:17:20:18 -0300] "GET /phpmyadmin/phpmyadmin.css.php?server=1&lang=es&collation_connection=utf8_general_ci&token=b3fa744d942462c0366f8b4f743925eb&nocache=4231430853ltr HTTP/1.1" 200 19256
127.0.0.1 - - [28/Apr/2015:17:20:18 -0300] "GET /phpmyadmin/js/get_scripts.js.php?lang=es&collation_connection=utf8_general_ci&token=b3fa744d942462c0366f8b4f743925eb&scripts[]=jquery/jquery-1.8.3.min.js&scripts[]=ajax.js&scripts[]=keyhandler.js&scripts[]=jquery/jquery-ui-1.9.2.custom.min.js&scripts[]=jquery/jquery.sprintf.js&scripts[]=jquery/jquery.cookie.js&scripts[]=jquery/jquery.mousewheel.js&scripts[]=jquery/jquery.event.drag-2.2.js&scripts[]=jquery/jquery-ui-timepicker-addon.js&scripts[]=jquery/jquery.ba-hashchange-1.3.js&scripts[]=jquery/jquery.debounce-1.0.5.js&scripts[]=jquery/jquery.menuResizer-1.0.js&scripts[]=cross_framing_protection.js&scripts[]=rte.js&scripts[]=tracekit/tracekit.js&scripts[]=error_report.js&scripts[]=doclinks.js&scripts[]=functions.js&scripts[]=navigation.js&scripts[]=indexes.js&scripts[]=common.js&scripts[]=codemirror/lib/codemirror.js&scripts[]=codemirror/mode/sql/sql.js&scripts[]=codemirror/addon/runmode/runmode.js HTTP/1.1" 200 1046250
127.0.0.1 - - [28/Apr/2015:17:20:20 -0300] "GET /phpmyadmin/js/messages.php?lang=es&db=&collation_connection=utf8_general_ci&token=b3fa744d942462c0366f8b4f743925eb HTTP/1.1" 200 19535
127.0.0.1 - - [28/Apr/2015:17:20:20 -0300] "GET /phpmyadmin/js/get_image.js.php?theme=pmahomme HTTP/1.1" 200 6388
127.0.0.1 - - [28/Apr/2015:17:20:21 -0300] "GET /phpmyadmin/themes/dot.gif HTTP/1.1" 200 43
127.0.0.1 - - [28/Apr/2015:17:20:21 -0300] "GET /phpmyadmin/themes/pmahomme/img/logo_right.png HTTP/1.1" 200 4548
127.0.0.1 - - [28/Apr/2015:17:20:22 -0300] "GET /phpmyadmin/themes/pmahomme/img/sprites.png HTTP/1.1" 200 41626
127.0.0.1 - - [28/Apr/2015:17:20:54 -0300] "GET /phpmyadmin HTTP/1.1" 301 236
127.0.0.1 - - [28/Apr/2015:17:20:54 -0300] "GET /phpmyadmin/ HTTP/1.1" 200 2809
127.0.0.1 - - [28/Apr/2015:17:20:56 -0300] "GET /phpmyadmin/ HTTP/1.1" 200 2810
127.0.0.1 - - [28/Apr/2015:17:20:56 -0300] "GET /phpmyadmin/themes/pmahomme/img/logo_right.png HTTP/1.1" 200 4548
127.0.0.1 - - [28/Apr/2015:17:20:56 -0300] "GET /phpmyadmin/themes/pmahomme/jquery/jquery-ui-1.9.2.custom.css HTTP/1.1" 200 6177
127.0.0.1 - - [28/Apr/2015:17:20:56 -0300] "GET /phpmyadmin/phpmyadmin.css.php?server=1&lang=es&collation_connection=utf8_general_ci&token=ffac98adfaa14910c4fc26703a771796&nocache=4231430853ltr HTTP/1.1" 200 19022
127.0.0.1 - - [28/Apr/2015:17:20:56 -0300] "GET /phpmyadmin/phpmyadmin.css.php?server=1&lang=es&collation_connection=utf8_general_ci&token=fddae3cdc65c7f1664ff2f070c6fcf4a&nocache=4231430853ltr HTTP/1.1" 200 19022
127.0.0.1 - - [28/Apr/2015:17:20:57 -0300] "GET /phpmyadmin/themes/dot.gif HTTP/1.1" 200 43
127.0.0.1 - - [28/Apr/2015:17:20:57 -0300] "GET /phpmyadmin/js/messages.php?lang=es&db=&collation_connection=utf8_general_ci&token=ffac98adfaa14910c4fc26703a771796 HTTP/1.1" 200 19535
127.0.0.1 - - [28/Apr/2015:17:20:57 -0300] "GET /phpmyadmin/js/messages.php?lang=es&db=&collation_connection=utf8_general_ci&token=fddae3cdc65c7f1664ff2f070c6fcf4a HTTP/1.1" 200 19535
127.0.0.1 - - [28/Apr/2015:17:20:57 -0300] "GET /phpmyadmin/js/get_image.js.php?theme=pmahomme HTTP/1.1" 200 6388
127.0.0.1 - - [28/Apr/2015:17:20:57 -0300] "GET /phpmyadmin/js/get_scripts.js.php?lang=es&collation_connection=utf8_general_ci&token=fddae3cdc65c7f1664ff2f070c6fcf4a&scripts[]=jquery/jquery-1.8.3.min.js&scripts[]=ajax.js&scripts[]=keyhandler.js&scripts[]=jquery/jquery-ui-1.9.2.custom.min.js&scripts[]=jquery/jquery.sprintf.js&scripts[]=jquery/jquery.cookie.js&scripts[]=jquery/jquery.mousewheel.js&scripts[]=jquery/jquery.event.drag-2.2.js&scripts[]=jquery/jquery-ui-timepicker-addon.js&scripts[]=jquery/jquery.ba-hashchange-1.3.js&scripts[]=jquery/jquery.debounce-1.0.5.js&scripts[]=jquery/jquery.menuResizer-1.0.js&scripts[]=cross_framing_protection.js&scripts[]=rte.js&scripts[]=tracekit/tracekit.js&scripts[]=error_report.js&scripts[]=doclinks.js&scripts[]=functions.js&scripts[]=navigation.js&scripts[]=indexes.js&scripts[]=common.js&scripts[]=codemirror/lib/codemirror.js&scripts[]=codemirror/mode/sql/sql.js&scripts[]=codemirror/addon/runmode/runmode.js HTTP/1.1" 200 1044306
127.0.0.1 - - [28/Apr/2015:17:20:56 -0300] "GET /phpmyadmin/js/get_scripts.js.php?lang=es&collation_connection=utf8_general_ci&token=ffac98adfaa14910c4fc26703a771796&scripts[]=jquery/jquery-1.8.3.min.js&scripts[]=ajax.js&scripts[]=keyhandler.js&scripts[]=jquery/jquery-ui-1.9.2.custom.min.js&scripts[]=jquery/jquery.sprintf.js&scripts[]=jquery/jquery.cookie.js&scripts[]=jquery/jquery.mousewheel.js&scripts[]=jquery/jquery.event.drag-2.2.js&scripts[]=jquery/jquery-ui-timepicker-addon.js&scripts[]=jquery/jquery.ba-hashchange-1.3.js&scripts[]=jquery/jquery.debounce-1.0.5.js&scripts[]=jquery/jquery.menuResizer-1.0.js&scripts[]=cross_framing_protection.js&scripts[]=rte.js&scripts[]=tracekit/tracekit.js&scripts[]=error_report.js&scripts[]=doclinks.js&scripts[]=functions.js&scripts[]=navigation.js&scripts[]=indexes.js&scripts[]=common.js&scripts[]=codemirror/lib/codemirror.js&scripts[]=codemirror/mode/sql/sql.js&scripts[]=codemirror/addon/runmode/runmode.js HTTP/1.1" 200 1046250
127.0.0.1 - - [28/Apr/2015:17:20:59 -0300] "GET /phpmyadmin/themes/pmahomme/img/sprites.png HTTP/1.1" 200 41626
127.0.0.1 - - [28/Apr/2015:17:20:59 -0300] "GET /phpmyadmin/favicon.ico HTTP/1.1" 200 18902
127.0.0.1 - - [28/Apr/2015:17:21:22 -0300] "GET / HTTP/1.1" 200 1090
127.0.0.1 - - [28/Apr/2015:17:21:22 -0300] "GET /bitnamistack.css HTTP/1.1" 200 698
127.0.0.1 - - [28/Apr/2015:17:21:22 -0300] "GET /img/bitnami.png HTTP/1.1" 200 3738
127.0.0.1 - - [28/Apr/2015:17:21:23 -0300] "GET /img/redmine.png HTTP/1.1" 200 3649
127.0.0.1 - - [28/Apr/2015:17:21:23 -0300] "GET /img/sub_header_bg.png HTTP/1.1" 200 146
127.0.0.1 - - [28/Apr/2015:17:21:23 -0300] "GET /img/header_bg.png HTTP/1.1" 200 147
127.0.0.1 - - [28/Apr/2015:17:21:23 -0300] "GET /favicon.ico HTTP/1.1" 200 1150
127.0.0.1 - - [28/Apr/2015:17:23:46 -0300] "GET /redmine/ HTTP/1.1" 500 646
127.0.0.1 - - [28/Apr/2015:17:37:28 -0300] "GET /redmine/ HTTP/1.1" 500 646
What is happening?

Regards


Replies (5)

RE: Redmine access issue - Added by Leonel Iturralde almost 9 years ago

Hi,
its seems to be a problem with your database. Check that all tables were created.

ActiveRecord::StatementInvalid (Mysql2::Error: Table 'bitnami_redmine.settings' doesn't exist: SHOW FULL FIELDS FROM settings):

RE: Redmine access issue - Added by Martin Denizet (redmine.org team member) almost 9 years ago

Hello,

You can try to cd to the Redmine directory and run:
Linux:

RAILS_ENV=production bundle exec rake db:migrate

Windows:
set RAILS_ENV=production
bundle exec rake db:migrate

Cheers,

RE: Redmine access issue - Added by César Olivieri almost 9 years ago

Hi!,

I tried to executed the command "bundle exec rake db:migrate" but I got this message: "Could not locate Gemfile". Of course I'm stayed in the directory c:\Bitnami\redmine-2.5.1-2

Regards!

RE: Redmine access issue - Added by Leonel Iturralde almost 9 years ago

Hi,
I installed bitnami redmine 3.0.0 for windows and
Bitnami Redmine generally installs redmine in c:\bitnami\redmine-x.x.x\apps\redmine\htdocs
So, try running

cd c:\Bitnami\redmine-2.5.1-2\apps\redmine\htdocs
set RAILS_ENV=production
bundle exec rake db:migrate

RE: Redmine access issue - Added by César Olivieri almost 9 years ago

Hi,
I executed the command bundle exec rake db:migrate
And got this:

C:\Bitnami\redmine-2.5.1-2\apps\redmine\htdocs>bundle exec rake db:migrate
rake aborted!
C:/Bitnami/redmine-2.5.1-2/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rak
e-10.1.1/lib/rake/trace_output.rb:16:in `block in trace_on': invalid byte sequen
ce in US-ASCII (ArgumentError)
from C:/Bitnami/redmine-2.5.1-2/apps/redmine/htdocs/vendor/bundle/ruby/1
.9.1/gems/rake-10.1.1/lib/rake/trace_output.rb:14:in `map'
from C:/Bitnami/redmine-2.5.1-2/apps/redmine/htdocs/vendor/bundle/ruby/1
.9.1/gems/rake-10.1.1/lib/rake/trace_output.rb:14:in `trace_on'
from C:/Bitnami/redmine-2.5.1-2/apps/redmine/htdocs/vendor/bundle/ruby/1
.9.1/gems/rake-10.1.1/lib/rake/application.rb:340:in `trace'
from C:/Bitnami/redmine-2.5.1-2/apps/redmine/htdocs/vendor/bundle/ruby/1
.9.1/gems/rake-10.1.1/lib/rake/application.rb:187:in `display_error_message'
from C:/Bitnami/redmine-2.5.1-2/apps/redmine/htdocs/vendor/bundle/ruby/1
.9.1/gems/rake-10.1.1/lib/rake/application.rb:174:in `rescue in standard_excepti
on_handling'
from C:/Bitnami/redmine-2.5.1-2/apps/redmine/htdocs/vendor/bundle/ruby/1
.9.1/gems/rake-10.1.1/lib/rake/application.rb:165:in `standard_exception_handlin
g'
from C:/Bitnami/redmine-2.5.1-2/apps/redmine/htdocs/vendor/bundle/ruby/1
.9.1/gems/rake-10.1.1/lib/rake/application.rb:75:in `run'
from C:/Bitnami/redmine-2.5.1-2/apps/redmine/htdocs/vendor/bundle/ruby/1
.9.1/gems/rake-10.1.1/bin/rake:33:in `<top (required)>'
from C:/Bitnami/redmine-2.5.1-2/ruby/bin/rake:23:in `load'
from C:/Bitnami/redmine-2.5.1-2/ruby/bin/rake:23:in `<main>'

What will that command do?

Regards

    (1-5/5)