Redmine completed 500 internal server error

Redmine

Forums » Help »

Hi, I already install redmine by this manual:
http://www.redmine.org/projects/redmine/wiki/install_Redmine_25x_on_Centos_65_complete

but when i go «http://myserverip» i get this error:

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.

Maybe anyone knows where the problem is?

THX a lot!


RE: Redmine 500 error

Added by Konstantin Okorochkov over 8 years ago

Connecting to database specified by database.yml
Creating scope :system. Overwriting existing method Enumeration.system.
Creating scope :sorted. Overwriting existing method Group.sorted.
Creating scope :sorted. Overwriting existing method User.sorted.
Started GET «/» for 192.168.0.4 at 2014-07-14 15:57:18 +0400
Processing by WelcomeController#index as HTML
Completed 500 Internal Server Error in 3.7ms

ActiveRecord::StatementInvalid (Mysql2::Error: Table ‘redmine_db.settings’ doesn’t exist: SHOW FULL FIELDS FROM `settings`):
app/models/setting.rb:226:in `check_cache’
app/controllers/application_controller.rb:97:in `user_setup’

Started GET «/» for 192.168.0.4 at 2014-07-14 15:57:41 +0400
Processing by WelcomeController#index as HTML
Completed 500 Internal Server Error in 1.5ms

ActiveRecord::StatementInvalid (Mysql2::Error: Table ‘redmine_db.settings’ doesn’t exist: SHOW FULL FIELDS FROM `settings`):
app/models/setting.rb:226:in `check_cache’
app/controllers/application_controller.rb:97:in `user_setup’

and so on, many times.


RE: Redmine 500 error

Added by Konstantin Okorochkov over 8 years ago

rake aborted!
ActiveRecord::StatementInvalid: Mysql2::Error: Can’t create/write to file ‘/tmp/#sql_1de5_0.MYI’ (Errcode: 13): SHOW FULL FIELDS FROM `schema_migrations`
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `block in execute’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activesupport-3.2.17/lib/active_support/notifications/instrumenter.rb:20:in `instrument’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/mysql2_adapter.rb:213:in `execute’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:259:in `execute_and_free’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:426:in `columns’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/schema_cache.rb:16:in `yield’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/schema_cache.rb:16:in `default’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/schema_cache.rb:16:in `block in initialize’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/to_sql.rb:101:in `yield’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/to_sql.rb:101:in `default’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/to_sql.rb:101:in `column_for’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/to_sql.rb:430:in `visit_Arel_Attributes_Attribute’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/visitor.rb:19:in `visit’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/to_sql.rb:134:in `block in visit_Arel_Nodes_SelectCore’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/to_sql.rb:134:in `map’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/to_sql.rb:134:in `visit_Arel_Nodes_SelectCore’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/mysql.rb:41:in `visit_Arel_Nodes_SelectCore’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/to_sql.rb:121:in `block in visit_Arel_Nodes_SelectStatement’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/to_sql.rb:121:in `map’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/to_sql.rb:121:in `visit_Arel_Nodes_SelectStatement’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/mysql.rb:36:in `visit_Arel_Nodes_SelectStatement’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/visitor.rb:19:in `visit’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/visitor.rb:5:in `accept’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/to_sql.rb:19:in `accept’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/arel-3.0.3/lib/arel/visitors/bind_visitor.rb:11:in `accept’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `to_sql’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/database_statements.rb:38:in `select_values’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/migration.rb:587:in `get_all_versions’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/migration.rb:745:in `migrated’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/migration.rb:668:in `current_version’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/migration.rb:685:in `block in migrate’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/migration.rb:685:in `each’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/migration.rb:685:in `detect’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/migration.rb:685:in `migrate’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/migration.rb:570:in `up’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/migration.rb:551:in `migrate’
/usr/local/rvm/gems/ruby-1.9.3-p547/gems/activerecord-3.2.17/lib/active_record/railties/databases.rake:193:in `block (2 levels) in <top (required)>’
/usr/local/rvm/gems/ruby-1.9.3-p547/bin/ruby_executable_hooks:15:in `eval’
/usr/local/rvm/gems/ruby-1.9.3-p547/bin/ruby_executable_hooks:15:in `<main>’
Tasks: TOP => db:migrate
(See full trace by running task with —trace)


RE: Redmine 500 error

Added by Konstantin Okorochkov over 8 years ago

[root@crytek redmine]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_crytek-lv_root
50G 5.8G 41G 13% /
tmpfs 1.8G 228K 1.8G 1% /dev/shm
/dev/vda1 485M 67M 393M 15% /boot
/dev/mapper/vg_crytek-lv_home
46G 180M 43G 1% /home

[root@crytek redmine]# ll /tmp
total 60
drwxr-xr-x 2 root root 4096 Jul 14 14:48 keyring-cvXxgf
drwxr-xr-x 2 root root 4096 Jul 14 14:48 orbit-gdm
drwxr-xr-x 2 root root 4096 Jan 1 1970 orbit-root
drwxr-xr-x 2 root root 4096 Jul 15 10:13 orbit-root-2828a868
drwxr-xr-x 3 root root 4096 Jul 15 04:57 passenger.1.0.7710
drwxr-xr-x. 2 root root 4096 Jul 14 14:48 pulse-IeUtyxiMLV63
drwxr-xr-x. 2 root root 4096 Jul 14 14:48 pulse-InIUa7q55sdd
drwxr-xr-x 2 root root 4096 Jul 14 10:35 virtual-root.1Kd1wl
drwxr-xr-x. 2 root root 4096 Jul 11 16:15 virtual-root.3WiD2h
drwxr-xr-x. 2 root root 4096 Jul 11 17:03 virtual-root.BFcnAB
drwxr-xr-x 2 root root 4096 Jul 14 14:48 virtual-root.e6XU5F
drwxr-xr-x. 2 root root 4096 Jul 11 16:35 virtual-root.iytoJW
drwxr-xr-x 2 root root 4096 Jul 14 10:30 virtual-root.JniZAV
drwxr-xr-x 2 root root 4096 Jul 14 14:34 virtual-root.R0BlQU
drwxr-xr-x. 2 root root 4096 Jul 11 16:30 virtual-root.TqyNNH
-rwxr-xr-x. 1 root root 0 Jul 11 09:40 yum.log


RE: Redmine 500 error

Added by Konstantin Okorochkov over 8 years ago

cat /etc/my.cnf | grep tmpdir — nothing

[root@crytek redmine]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

  1. Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[root@crytek redmine]# cat /etc/my.cnf | grep user
user=mysql

[root@crytek redmine]# ps aux | grep mysql
root 7551 0.0 0.0 108204 1428 pts/0 S Jul14 0:00 /bin/sh /usr/bin/mysqld_safe —datadir=/var/lib/mysql —socket=/var/lib/mysql/mysql.sock —pid-file=/var/run/mysqld/mysqld.pid —basedir=/usr —user=mysql
mysql 7653 0.0 0.7 508812 27060 pts/0 Sl Jul14 0:24 /usr/libexec/mysqld —basedir=/usr —datadir=/var/lib/mysql —user=mysql —log-error=/var/log/mysqld.log —pid-file=/var/run/mysqld/mysqld.pid —socket=/var/lib/mysql/mysql.sock
root 15226 0.0 0.0 103256 816 pts/1 S+ 11:41 0:00 grep mysql

[root@crytek redmine]# ls -lah /tmp
total 84K
drwxrwxr-x. 20 root root 4.0K Jul 15 10:40 .
dr-xr-xr-x. 26 root root 4.0K Jul 14 17:16 ..
drwxr-xr-x. 2 root root 4.0K Jul 14 14:48 .esd-0
drwxr-xr-x 2 root root 4.0K Jul 14 14:48 .ICE-unix
drwxr-xr-x 2 root root 4.0K Jul 14 14:48 keyring-cvXxgf
drwxr-xr-x 2 root root 4.0K Jul 14 14:48 orbit-gdm
drwxr-xr-x 2 root root 4.0K Jan 1 1970 orbit-root
drwxr-xr-x 2 root root 4.0K Jul 15 10:13 orbit-root-2828a868
drwxr-xr-x 3 root root 4.0K Jul 15 10:40 passenger.1.0.13060
drwxr-xr-x. 2 root root 4.0K Jul 14 14:48 pulse-IeUtyxiMLV63
drwxr-xr-x. 2 root root 4.0K Jul 14 14:48 pulse-InIUa7q55sdd
drwxr-xr-x 2 root root 4.0K Jul 14 10:35 virtual-root.1Kd1wl
drwxr-xr-x. 2 root root 4.0K Jul 11 16:15 virtual-root.3WiD2h
drwxr-xr-x. 2 root root 4.0K Jul 11 17:03 virtual-root.BFcnAB
drwxr-xr-x 2 root root 4.0K Jul 14 14:48 virtual-root.e6XU5F
drwxr-xr-x. 2 root root 4.0K Jul 11 16:35 virtual-root.iytoJW
drwxr-xr-x 2 root root 4.0K Jul 14 10:30 virtual-root.JniZAV
drwxr-xr-x 2 root root 4.0K Jul 14 14:34 virtual-root.R0BlQU
drwxr-xr-x. 2 root root 4.0K Jul 11 16:30 virtual-root.TqyNNH
-rwxr-xr-x 1 root root 11 Jul 14 14:46 .X0-lock
drwxr-xr-x 2 root root 4.0K Jul 14 14:46 .X11-unix
-rwxr-xr-x. 1 root root 0 Jul 11 09:40 yum.log


RE: Redmine 500 error

Added by Konstantin Okorochkov over 8 years ago

YEEEEEEEEEEEEE, mr Martin Denizet, THX A LOT!!!!!
problem was: only root user and root group have access to change files in /tmp, i set this permission to all and now i have drwxrwxrwx. 20 root root that means everyone can do anything with /tmp, so i do that RAILS_ENV….. and restart apache, and my redmine is online now))
thx again)

Содержание

  1. Redmine 500 Внутренняя ошибка
  2. 1 ответ 1
  3. Redmine
  4. Задачи
  5. Сохранённые запросы
  6. Defect #30851
  7. Redmine 4.0.1 Internnal error 500 on accessing the settings page
  8. История
  9. #1 Обновлено net ops почти 4 года назад
  10. #2 Обновлено net ops почти 4 года назад
  11. #3 Обновлено Go MAEDA почти 4 года назад
  12. #4 Обновлено net ops почти 4 года назад
  13. #5 Обновлено net ops почти 4 года назад
  14. #6 Обновлено Holger Just почти 4 года назад
  15. #7 Обновлено net ops больше 3 лет назад
  16. = l(:label_settings) %>
  17. Redmine 500 Internal Error
  18. 1 Answer 1
  19. Redmine 500 error — create a New Issue #133
  20. Comments
  21. Redmine
  22. [Urgent Help!]Redmine 500 error(Mysql2::Error)

Redmine 500 Внутренняя ошибка

Внутренняя ошибка 500 выдается при попытке навигации через Redmine. Я погуглил ошибку и нашел некоторые подсказки, но никто не помог.

Я следовал этому руководству по установке Redmine. Вы можете найти это ЗДЕСЬ

Ошибка выглядит так:

Произошла ошибка на странице, к которой вы пытались получить доступ. Если проблемы не устранены, обратитесь за помощью к администратору Redmine.

Если вы являетесь администратором Redmine, проверьте файлы журналов для получения подробной информации об ошибке.

1 ответ 1

Шаг 8 — Разрешения файловой системы¶

NB. Пользователи Windows могут пропустить этот раздел.

Учетная запись пользователя, на котором запущено приложение, должна иметь разрешение на запись в следующих подкаталогах:

файлы (хранилище вложений) log (файл журнала приложения production.log) tmp и tmp/pdf (создавайте их, если они отсутствуют, используются для генерации PDF-документов, между прочим) public/plugin_assets (активы плагинов) Например, если вы запустите приложение с учетной записью пользователя Redmine:

mkdir -p tmp tmp/pdf public/plugin_assets sudo chown -R redmine: журнал redmine файлов tmp public/plugin_assets sudo chmod -R 755 файл журнала tmp public/plugin_assets Шаг 9 — Проверка установки Проверьте установку, запустив веб-сервер WEBrick:

с Redmine 1.4.x: скрипт ruby / сервера webrick -e производство с Redmine 2.x: скрипт ruby / сервера rails webrick -e production Как только WEBrick запустится, укажите в браузере http: //: 3000 /. Теперь вы должны увидеть страницу приветствия приложения.

Примечание: Webrick не подходит для производственного использования, используйте только webrick для проверки работоспособности установки до этого момента. Используйте одно из многих других руководств в этой вики, чтобы настроить redmine для использования Passenger (aka mod_rails), FCGI или Rack-сервера (Unicorn, Thin, Puma, hellip;) для обслуживания вашего redmine.

Источник

Redmine

Задачи

Сохранённые запросы

Defect #30851

Redmine 4.0.1 Internnal error 500 on accessing the settings page

Добавил(а) net ops почти 4 года назад. Обновлено больше 3 лет назад.

Статус: Reopened Начата:
Приоритет: Normal Дата выполнения:
Назначена: Готовность:
Категория: Administration
Версия:
Resolution: Invalid Affected version: 4.0.1

Описание

I’ve setup a brand new redmine 4.0.1 plateform and everything’s running fine but the «Settings» sub menu from «Administration» menu.
When I click on it, I’ve got an internal error (redmine error 500)

When I go back to my previous version redmine 3.4.5, I can access the Settings page, no problem.

Here is my configuration :

Centos 7 operating system
[redmine-4.0.1]# bundler -v
The dependency tzinfo-data (>= 0) will be unused by any of the platforms Bundler is installing for. Bundler is installing for ruby but the dependency is only for x86-mingw32, x64-mingw32, x86-mswin32. To add those platforms to the bundle, run `bundle lock —add-platform x86-mingw32 x64-mingw32 x86-mswin32`.
Bundler version 2.0.1

[redmine-4.0.1]# passenger -v
Phusion Passenger 6.0.1

[redmine-4.0.1]# ruby -v
ruby 2.6.1p33 (2019-01-30 revision 66950) [x86_64-linux]

[redmine-4.0.1]# rails -v
Rails 5.2.2

Here’s my database.yml

Using seperate mysql server for redmine database:

This is error on the browsers:

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.

This is the exact error each time I click on Administration, Settings page in the production.log

I have also started the webrick server:

When I click on Settings, I get this in the webrick server conosle:

Thank you so much for your time in advance..

redmine.jpg (53,03 КБ) net ops, 2019-06-25 23:52

История

#1 Обновлено net ops почти 4 года назад

In looking around google search to troubleshoot this issue:

1. I have added 777 permission to redmine folder on my Centos 7 server:

2. I even added this in my mysql server,

3. Also I deleted the following groups from the users table: GroupNonMember and GroupAnonymous

#2 Обновлено net ops почти 4 года назад

I have these 2 plugins installed but I even tried without installing the plugins from fresh install, still cannot access Settings page period. Get Internal Error message.

#3 Обновлено Go MAEDA почти 4 года назад

  • Параметр Статус изменился с New на Closed
  • Параметр Resolution изменился на Invalid

Could you try the following command?

Please use forums for questions. Reading How to request help may be helpful for you.

#4 Обновлено net ops почти 4 года назад

  • Параметр Статус изменился с Closed на Reopened

I did tried that command as well that did not help either, I forgot to list it.

Is this a defect or configuration or setup issue?

Thanks for your time.

#5 Обновлено net ops почти 4 года назад

Nevemind, I will post it in Forums.

#6 Обновлено Holger Just почти 4 года назад

  • Описание обновлено (diff)

#7 Обновлено net ops больше 3 лет назад

I still have same issue with internal server error 500 when accessing the settings

it has to do with these files under this path: /web/servers/redmine-4.0.4/app/views/settings/edit.html.erb

if I remove the two line, then I see blank Settings page with no Internal server error

see screen shot attached:

[root@redmine-04 settings]# more edit.html.erb_ORIG

>
[root@redmine-04 settings]# more edit.html.erb

= l(:label_settings) %>

[root@redmine-04 settings]# pwd
/web/servers/redmine-4.0.4/app/views/settings
[root@redmine-04 settings]#

This is production.log below:

Processing by SettingsController#index as HTML
Current user: aqureshi (id=79)
Rendering settings/edit.html.erb within layouts/admin
Rendered settings/_general.html.erb (37.6ms)
Rendered settings/_display.html.erb (42.0ms)
Rendered settings/_authentication.html.erb (68.7ms)
Rendered settings/_api.html.erb (7.4ms)
Rendered settings/_projects.html.erb (57.9ms)
Rendered settings/_users.html.erb (476.1ms)
Rendered settings/_issues.html.erb (98.7ms)
Rendered common/_tabs.html.erb (1139.6ms)
Rendered settings/edit.html.erb within layouts/admin (1144.2ms)
Completed 500 Internal Server Error in 1203ms (ActiveRecord: 83.8ms)

ActionView::Template::Error (undefined method `close_duplicate_issues’ for # ):
7:
8:

Источник

Redmine 500 Internal Error

Internal error 500 thrown when I try to navigate through Redmine. I have googled error and found some clues but none helped.

I was following this set up guide to install redmine. You can find it HERE

Error looks like this:

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.

1 Answer 1

Solved by doing this :

Step 8 — File system permissions¶

NB: Windows users can skip this section.

The user account running the application must have write permission on the following subdirectories:

files (storage of attachments) log (application log file production.log) tmp and tmp/pdf (create these ones if not present, used to generate PDF documents among other things) public/plugin_assets (assets of plugins) E.g., assuming you run the application with a redmine user account:

mkdir -p tmp tmp/pdf public/plugin_assets sudo chown -R redmine:redmine files log tmp public/plugin_assets sudo chmod -R 755 files log tmp public/plugin_assets Step 9 — Test the installation Test the installation by running WEBrick web server:

with Redmine 1.4.x: ruby script/server webrick -e production with Redmine 2.x: ruby script/rails server webrick -e production Once WEBrick has started, point your browser to http://:3000/. You should now see the application welcome page.

Note: Webrick is not suitable for production use, please only use webrick for testing that the installation up to this point is functional. Use one of the many other guides in this wiki to setup redmine to use either Passenger (aka mod_rails), FCGI or a Rack server (Unicorn, Thin, Puma, hellip;) to serve up your redmine.

Источник

Redmine 500 error — create a New Issue #133

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.

Tested versions: 3.0.4, 3.1.0 and 2.6.5 (Same error)
Logs: Don´t show nothing.

The text was updated successfully, but these errors were encountered:

This container is running on

CentOS Linux release 7.1.1503 (Core)
3.10.0-229.7.2.el7.x86_64

@darioajr please make sure that you have loaded the default configuration from the administration page.

Yes, I loaded the default configurations In English and In Portuguese (New container), but the error persists.

@darioajr ok.. at this point I would suggest turning off selinux and retrying.

SELINUX of host machine was disabled.

@darioajr ok.. can you share you docker run or docker-compose.yml file so that I can try to reproduce this issue.

redmine:
image: sameersbn/redmine:3.1.0
environment:
— TZ=America/Sao_Paulo
— REDMINE_PORT=10083
— SMTP_ENABLED=true
— SMTP_DOMAIN=mailserv.xxxxxxxx.com.br
— SMTP_HOST=mailserv.xxxxxxxx.com.br
— SMTP_PORT=25
— DB_TYPE=mysql
— DB_HOST=bnsvher348
— DB_NAME=redmine
— DB_USER=redmine
— DB_PASS=Redmine@2015.
— NGINX_MAX_UPLOAD_SIZE=999m
ports:
— «10083:80»
volumes:
— /srv/docker/redmine/:/home/redmine/data

Howto capture the log to this error??

@darioajr oh.. sorry I did not find the time to look into this. give me a couple if minutes to check.

@darioajr I checked it and found no issues. can you try the following docker-compose file to check if you see the issue

here is th output of docker-compose up http://pastebin.com/77a8fJyj

Remember to load the default configuration first before creating a project. Let me know.

As far as I can tell there is nothing wrong with the image.

Ok , the error occurs when I add the following settings

  • SMTP_ENABLED=true
  • SMTP_DOMAIN=mailserv.xxxxxxxx.com.br
  • SMTP_HOST=mailserv.xxxxxxxx.com.br
  • SMTP_PORT=25

When I do an email to send test works, but let configured to send email when you create a task the error occurs.

My E-mail server is Exchange 2010, I´m using relay option in the host machine (server) , this configuration don’t need user and password and Allows send email with any «From» name .

Resolution:
Change SMTP parameters:
— SMTP_ENABLED=true
— SMTP_DOMAIN=mydomain
— SMTP_HOST=mailserv.mywebserver.com.br
— SMTP_PORT=25
— SMTP_STARTTLS=false
— SMTP_OPENSSL_VERIFY_MODE=none
— SMTP_TLS=false

@darioajr its weird that incorrect incorrect SMTP settings causes issues while accessing the «New Issue» page. Glad that you got it resolved.

Hi all,
I exactly had the same issue. The funny thing was that after disabling emails all outgoing emails in the admin section, the 500 error was gone. Then I activated emailing again. But now I was able to create new issues (even with enable email settings).
Weired thing.. And after a restart (of the container) the problem once again appeared.

hi,i got this error too,and here is production.log

•554 DT:SPM 发送的邮件内容包含了未被许可的信息,或被系统识别为垃圾邮件。请检查是否有用户发送病毒或者垃圾邮件;(The email contains information that has not been licensed, or is identified as spam by the system. Please check if there is a user to send a virus or spam)

if i set SMTP_METHOD:async_smtp , error is gone,but i can’t receive email.

Источник

Redmine

[Urgent Help!]Redmine 500 error(Mysql2::Error)

[Env.]Redmine 2.3.2 on windows
[Background]From yesterday, I found when click to «Repository» in redmine, speed is very slow, so I try to boot mongrel, I installed mongrel gem, and run «ruby script/rails server -e production», there is such message.

=> Booting Mongrel
=> Rails 3.2.13 application starting in production on http://0.0.0.0:3000
=> Call with -d to detach
=> Ctrl-C to shutdown server

Then from today, there is interl 500 error, when developers doing «update» issue, I checked the log, there are 2 mysql erros shown below,I guess there maybe 2 reasons.

I remove mongrel info. from gemfile.lock and gemfile, run bundle install again, then restart redmine service, for I am not sure if 500 error is booting mongrel leads, so I did like that.

  • accessing «repository» and fetching changesets speed is too slow influences normal redmine usage

I am not sure if the 2 are the right reasons, so hope to get some guide and solution to this issue.

By the way, , our redmine is bitnami redmine, it has apache integrated, mongrel booting is unnecessary or not?

Hope to get help.

Started GET «/redmine/» for xxx at 2015-04-28 09:55:59 +0800
Processing by WelcomeController#index as HTML
Completed 500 Internal Server Error in 0ms

ActiveRecord::StatementInvalid (Mysql2::Error: Query execution was interrupted: SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = ‘session_lifetime’ LIMIT 1):
app/models/setting.rb:171:in `find_or_default’
app/models/setting.rb:108:in `[]’
app/models/setting.rb:141:in `session_lifetime?’
app/controllers/application_controller.rb:64:in `session_expired?’
app/controllers/application_controller.rb:53:in `session_expiration’

Started GET «/redmine/issues/7101» for xxx at 2015-04-28 09:56:01 +0800
Processing by IssuesController#show as HTML
Parameters: <«id»=>«7101»>
Completed 500 Internal Server Error in 1045ms

Источник

Some users are getting 500 errors when logging in and when trying to browse certain pages or when the server’s been idle for a while or visiting my controller page.

The production logs where 500 error occurred are the followings:

Completed 500 Internal Server Error in 1ms (ActiveRecord: 0.3ms)

ActiveRecord::StatementInvalid (Mysql2::Error: MySQL server has gone away: SELECT 
MAX(`settings`.`updated_on`) FROM `settings`):
  app/models/setting.rb:231:in `check_cache'
  app/controllers/application_controller.rb:90:in `user_setup'

Started GET "/" for 127.0.0.1 at 2019-12-29 08:52:50 +0000
Processing by MyController#page as HTML
Completed 500 Internal Server Error in 1ms (ActiveRecord: 0.2ms)

ActiveRecord::StatementInvalid (Mysql2::Error: MySQL server has gone away: SELECT MAX(`settings`.`updated_on`) FROM `settings`):
  app/models/setting.rb:231:in `check_cache'
  app/controllers/application_controller.rb:90:in `user_setup'

Started GET "/" for 127.0.0.1 at 2019-12-29 08:52:56 +0000

Mysql2::Error (Can't connect to MySQL server on 'rds-prod-db-xxxxx.c3uzu7me4rud.us-east-1.rds.amazonaws.com' (111)):

Completed 500 Internal Server Error in 134ms (ActiveRecord: 69.2ms)

Second Error:

ActiveRecord::StatementInvalid (Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: UPDATE `issues` SET `issues`.`done_ratio` = 90, `issues`.`updated_on` = '2020-01-20 08:22:21', `issues`.`lock_version` = 49 WHERE `issues`.`id` = 328453 AND `issues`.`lock_version` = 48):
  app/models/issue.rb:210:in `create_or_update'
  app/models/issue.rb:1716:in `recalculate_attributes_for'
  app/models/issue.rb:1666:in `update_parent_attributes'
  app/models/issue.rb:210:in `create_or_update'
  app/controllers/issues_controller.rb:558:in `block in save_issue_with_child_records'
  app/controllers/issues_controller.rb:546:in `save_issue_with_child_records'
  app/controllers/issues_controller.rb:168:in `update'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'

Third Error:

Completed 500 Internal Server Error in 1ms (ActiveRecord: 0.2ms)

ActiveRecord::StatementInvalid (Mysql2::Error: MySQL server has gone away: UPDATE `tokens` SET `tokens`.`updated_on` = '2020-02-02 09:07:22' WHERE `tokens`.`user_id` = 289 AND `tokens`.`value` = 'a30e44e2ac37c8ba31eb383a409509c0d5fbb8be' AND `tokens`.`action` = 'session' AND (created_on > '2020-02-01 09:07:22') AND (updated_on > '2020-02-01 09:07:22')):
  app/models/user.rb:445:in `verify_session_token'
  app/controllers/application_controller.rb:77:in `session_expired?'
  app/controllers/application_controller.rb:67:in `session_expiration'

Started GET "/" for 127.0.0.1 at 2020-02-02 09:07:25 +0000

I saw an earlier in redmine forums topic having almost the same problem but have not found the solution yet.
Information:
Environment:

  Redmine version                3.4.4.stable
  Ruby version                   2.2.2-p95 (2015-04-13) [x86_64-linux]
  Rails version                  4.2.8
  Environment                    production
  Database adapter               Mysql2
SCM:
  Subversion                     1.7.14
  Git                            1.8.3.1
  Filesystem                     
Redmine plugins:
  redmine_query_share            2.1.0
  redmine_agile                  1.4.5
  sidebar_hide                   0.0.7

Ruby Server: Puma
Puma_worker_killer config:

PumaWorkerKiller.config do |config|
    config.ram           = 4096 # mb
    config.frequency     = 60   # seconds
    config.percent_usage = 0.90
    config.rolling_restart_frequency = 10 * 3600 # 12 hours in seconds, or 12.hours if using Rails
    config.reaper_status_logs = true # setting this to false will not log lines like:
    # PumaWorkerKiller: Consuming 54.34765625 mb with master and 2 workers.

    config.pre_term = -> (worker) { puts "Worker #{worker.inspect} being killed" 
  Thread: 4-16
  }
  end

I am very new to ruby on rails and redmine. Any help would be appreciated.
Thanks.

Internal error 500 thrown when I try to navigate through Redmine. I have googled error and found some clues but none helped.

I was following this set up guide to install redmine. You can find it HERE

Error looks like this:

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.

Back

niton's user avatar

niton

1,78614 silver badges21 bronze badges

asked Mar 21, 2014 at 0:15

Maciej Cygan's user avatar

Solved by doing this :

Step 8 — File system permissions¶

NB: Windows users can skip this section.

The user account running the application must have write permission on
the following subdirectories:

files (storage of attachments) log (application log file
production.log) tmp and tmp/pdf (create these ones if not present,
used to generate PDF documents among other things)
public/plugin_assets (assets of plugins) E.g., assuming you run the
application with a redmine user account:

mkdir -p tmp tmp/pdf public/plugin_assets sudo chown -R
redmine:redmine files log tmp public/plugin_assets sudo chmod -R 755
files log tmp public/plugin_assets Step 9 — Test the installation Test
the installation by running WEBrick web server:

with Redmine 1.4.x: ruby script/server webrick -e production with
Redmine 2.x: ruby script/rails server webrick -e production Once
WEBrick has started, point your browser to http://:3000/. You
should now see the application welcome page.

Note: Webrick is not suitable for production use, please only use
webrick for testing that the installation up to this point is
functional. Use one of the many other guides in this wiki to setup
redmine to use either Passenger (aka mod_rails), FCGI or a Rack server
(Unicorn, Thin, Puma, hellip;) to serve up your redmine.

answered Mar 21, 2014 at 0:28

Maciej Cygan's user avatar

I am trying to migrate an oldish installation:

Environment:
  Redmine version                          2.2.3.stable
  Ruby version                             1.9.3 (x86_64-linux)
  Rails version                            3.2.12
  Environment                              production
  Database adapter                         Mysql2
Redmine plugins:
  no plugin installed

to a new machine:

Environment:
  Redmine version                2.6.1.stable
  Ruby version                   1.9.3-p194 (2012-04-20) [x86_64-linux]
  Rails version                  3.2.21
  Environment                    production
  Database adapter               Mysql2
SCM:
  Subversion                     1.6.17
  Mercurial                      2.2.2
  Bazaar                         2.6.0
  Git                            1.7.10.4
  Filesystem                     
Redmine plugins:
  redmine_dmsf                   1.4.9 stable

I did a simple backup on old server:

root@redmine www/redmine# /usr/bin/mysqldump -u root -p"...redmine" redmine_production | gzip > redmine_`date +%y_%m_%d`.gz
root@redmine www/redmine# tar cjf files.tar.bz2 files

and tried to restore it in the new (working, but empty) machine:

root@redmine ~# cd /var/www/redmine/
root@redmine www/redmine# scp mcon@syno0:files.tar.bz2 .
files.tar.bz2                                         100% 4229     4.1KB/s   00:00
root@redmine www/redmine# scp mcon@syno0:redmine_15_02_12.gz .
redmine_15_02_12.gz                                   100%   11KB  11.2KB/s   00:00

*** here Redmine server is STILL working ***

root@redmine www/redmine# service apache2 stop
[ ok ] Stopping web server: apache2 ... waiting .
root@redmine www/redmine# tar xjf files.tar.bz2
root@redmine www/redmine# zcat redmine_15_02_12.gz | mysql --user=root --password=...redmine     redmine_production
root@redmine www/redmine# rake db:migrate
==  Setup: migrating ==========================================================
-- create_table("attachments", {:force=>true})
   -> 0.0082s
-- create_table("auth_sources", {:force=>true})
   -> 0.0043s
-- create_table("custom_fields", {:force=>true})
   -> 0.0041s
-- create_table("custom_fields_projects", {:id=>false, :force=>true})
   -> 0.0043s
-- create_table("custom_fields_trackers", {:id=>false, :force=>true})
   -> 0.0037s
-- create_table("custom_values", {:force=>true})
   -> 0.0049s
-- create_table("documents", {:force=>true})
   -> 0.0041s
-- add_index("documents", ["project_id"], {:name=>"documents_project_id"})
   -> 0.0127s
-- create_table("enumerations", {:force=>true})
   -> 0.0052s
-- create_table("issue_categories", {:force=>true})
   -> 0.0036s
-- add_index("issue_categories", ["project_id"], {:name=>"issue_categories_project_id"})
   -> 0.0158s
-- create_table("issue_histories", {:force=>true})
   -> 0.0191s
-- add_index("issue_histories", ["issue_id"], {:name=>"issue_histories_issue_id"})
   -> 0.0143s
-- create_table("issue_statuses", {:force=>true})
   -> 0.0046s
-- create_table("issues", {:force=>true})
   -> 0.0045s
-- add_index("issues", ["project_id"], {:name=>"issues_project_id"})
   -> 0.0149s
-- create_table("members", {:force=>true})
   -> 0.0062s
-- create_table("news", {:force=>true})
   -> 0.0052s
-- add_index("news", ["project_id"], {:name=>"news_project_id"})
   -> 0.0139s
-- create_table("permissions", {:force=>true})
   -> 0.0044s
-- create_table("permissions_roles", {:id=>false, :force=>true})
   -> 0.0059s
-- add_index("permissions_roles", ["role_id"], {:name=>"permissions_roles_role_id"})
   -> 0.0168s
-- create_table("projects", {:force=>true})
   -> 0.0582s
-- create_table("roles", {:force=>true})
   -> 0.0045s
-- create_table("tokens", {:force=>true})
   -> 0.0044s
-- create_table("trackers", {:force=>true})
   -> 0.0037s
-- create_table("users", {:force=>true})
   -> 0.0048s
-- create_table("versions", {:force=>true})
   -> 0.0112s
-- add_index("versions", ["project_id"], {:name=>"versions_project_id"})
   -> 0.0428s
-- create_table("workflows", {:force=>true})
   -> 0.0059s
==  Setup: migrated (0.4712s) =================================================

**** MANY LINES, APPARENTLY WITHOUT ERROR ****

==  ChangeChangesetsCommentsLimit: migrating ==================================
-- change_column(:changesets, :comments, :text, {:limit=>16777216})
   -> 0.0081s
==  ChangeChangesetsCommentsLimit: migrated (0.0085s) =========================

==  AddPasswordChangedAtToUser: migrating =====================================
-- add_column(:users, :passwd_changed_on, :datetime)
   -> 0.0104s
==  AddPasswordChangedAtToUser: migrated (0.0108s) ============================

==  InsertBuiltinGroups: migrating ============================================
==  InsertBuiltinGroups: migrated (0.1441s) ===================================

root@redmine www/redmine# service apache2 start
[ ok ] Starting web server: apache2.
root@redmine www/redmine#

After this Redmine is no longer working.
Attempts to connect results in:

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.

Back

And I get the following log:

...
Connecting to database specified by database.yml
Creating scope :system. Overwriting existing method Enumeration.system.
Creating scope :sorted. Overwriting existing method User.sorted.
Creating scope :sorted. Overwriting existing method Group.sorted.
Started GET "/" for 192.168.7.114 at 2015-02-12 14:41:57 +0000
Processing by WelcomeController#index as HTML
  Current user: admin (id=1)
Completed 500 Internal Server Error in 75.0ms

NoMethodError (undefined method `passwd_changed_on' for #<User:0x00000006696f80>):
  app/controllers/application_controller.rb:150:in `force_logout_if_password_changed'

What am I doing wrong?

Понравилась статья? Поделить с друзьями:
  • Redmi note 9 pro частота обновления экрана как изменить
  • Redmi note 7 the system has been destroyed как исправить
  • Redmi fastboot как исправить
  • Redmi airdots рассинхронизация как исправить
  • Redmi 7a мало памяти как исправить