Redmine

Smokie Smokerson wrote:

Is there any way i could save my Projects and Redmine data by any chance?

There is definitely a way to do this. Just follow the steps in the appropriate wiki article RedmineBackupRestore.

If Redmine doesn't come up, there is perhaps some information in the production log file. It's stored inside the Redmine installation in log/production.log.
Anyway I think it's good behave to backup your data before fiddling around.

Good luck!

Bernhard

Hello Bernhard,

Thanks for the reply.

I already have a back up of the database and files, the problem is when i try to restore it to a new Redmine installation i get an internal error.

Thats the issue im having and trouble im having with the restoration.

So any suggestions would be appreciated.

Ok great. So the first step is done already...

A bit more details to your problem could get very handy to find the right solution:

• What's the setup you are coming from? Redmine version, Ruby version, etc..
• What does the new setup look like?
• On which step you are struggling with the installation?
• Which steps have you accomplished so far?
• Can you provide us with the error message or your production.log file?

Hello,
I add my 2 cents:
Smokie Smokerson wrote:

I can still get the database through phpmyadmin but whenever i try to import it to a fresh install of Redmine it gives me an error..

I understand that you made a fresh new (3.4.x?) install, droped the new database and replaced it with your backup.
If it's the case, make sure you run migrations after restoring the backup:

RAILS_ENV=production bundle exec rake db:migrate

Also, to do a full backup of Redmine, you should also get the files in the files directory. File attachments are not included in DB backups.

Cheers!

Bernhard Rohloff wrote:

Ok great. So the first step is done already...

A bit more details to your problem could get very handy to find the right solution:

• What's the setup you are coming from? Redmine version, Ruby version, etc..
• What does the new setup look like?
• On which step you are struggling with the installation?
• Which steps have you accomplished so far?
• Can you provide us with the error message or your production.log file?

• What's the setup you are coming from? Redmine version, Ruby version, etc...
  

  Redmine: 3.1.0
  Ruby: ruby 2.1.9p490 (2016-03-30 revision 54437) [x86_64-linux-gnu]
  Passenger: Phusion Passenger 5.1.2
  passenger-status:
  Version : 5.3.1
  Date    : 2018-06-07 22:41:20 +0200
  Instance: jLoxI6w9 (Apache/2.4.18 (Ubuntu) SVN/1.9.3 Phusion_Passenger/5.1.2)
  
  ----------- General information -----------
  Max pool size : 6
  App groups    : 0
  Processes     : 0
  Requests in top-level queue : 0
  
  ----------- Application groups -----------
  
  cat passenger.conf
  ### Begin automatically installed Phusion Passenger config snippet ###
  <IfModule mod_passenger.c>
    PassengerRoot /usr/lib/ruby/vendor_ruby/phusion_passenger/locations.ini
    PassengerDefaultRuby /usr/bin/passenger_free_ruby
  </IfModule>
  ### End automatically installed Phusion Passenger config snippet ###
  
  PassengerUserSwitching on
  PassengerUser redmine
  PassengerGroup redmine
  
   cat passenger.load
  ### Begin automatically installed Phusion Passenger load snippet ###
  LoadModule passenger_module /usr/lib/apache2/modules/mod_passenger.so
  ### End automatically installed Phusion Passenger load snippet ###
  

• What does the new setup look like?
  

  Redmine 3.2.1.stable
  Ruby: ruby 2.3.1p112 (2016-04-26) [x86_64-linux-gnu]
  Passenger: Phusion Passenger 5.0.27
   passenger-status
  Version : 5.0.27
  Date    : 2018-06-07 22:51:10 +0200
  Instance: 0YVce7LX (Apache/2.4.18 (Ubuntu) Phusion_Passenger/5.0.27)
  
  ----------- General information -----------
  Max pool size : 6
  App groups    : 1
  Processes     : 1
  Requests in top-level queue : 0
  
  ----------- Application groups -----------
  /usr/share/redmine:
    App root: /usr/share/redmine
  
  cat passenger.load:
  LoadModule passenger_module /usr/lib/apache2/modules/mod_passenger.so
  
  cat passenger.conf
  <IfModule mod_passenger.c>
  PassengerDefaultUser www-data
    PassengerRoot /usr/lib/ruby/vendor_ruby/phusion_passenger/locations.ini
    PassengerDefaultRuby /usr/bin/ruby
  </IfModule>
  

• On which step you are struggling with the installation?
  Restoring the database, gives me an internal error

• Can you provide us with the error message or your production.log file?
  

  prodcution.log:
  (called from block in included at /opt/redmine/redmine-3.1.0/plugins/redmine_gi                                                                                                             t_hosting/lib/redmine_git_hosting/patches/setting_patch.rb:14)
  Started GET "/redmine/login?back_url=http%3A%2F%2F192.168.1.202%2Fredmine%2Fissu                                                                                                             es%2F21" for 192.168.1.122 at 2016-08-12 00:10:11 +0200
  Processing by AccountController#login as HTML
    Parameters: {"back_url"=>"http://192.168.1.202/redmine/issues/21"}
    Current user: anonymous
    Rendered account/login.html.erb within layouts/base (92.3ms)
  Completed 200 OK in 501ms (Views: 391.1ms | ActiveRecord: 12.7ms)
  DEPRECATION WARNING: Currently, Active Record suppresses errors raised within `a                                                                                                             fter_rollback`/`after_commit` callbacks and only print them to the logs. In the                                                                                                              next version, these errors will no longer be suppressed. Instead, the errors wil                                                                                                             l propagate normally just like in other Active Record callbacks.
  
  You can opt into the new behavior and remove this warning by setting:
  
    config.active_record.raise_in_transactional_callbacks = true
  
   (called from block in included at /opt/redmine/redmine-3.1.0/plugins/redmine_gi                                                                                                             t_hosting/lib/redmine_git_hosting/patches/member_patch.rb:12)
  DEPRECATION WARNING: Currently, Active Record suppresses errors raised within `a                                                                                                             fter_rollback`/`after_commit` callbacks and only print them to the logs. In the                                                                                                              next version, these errors will no longer be suppressed. Instead, the errors wil                                                                                                             l propagate normally just like in other Active Record callbacks.
  
  You can opt into the new behavior and remove this warning by setting:
  
    config.active_record.raise_in_transactional_callbacks = true
  
   (called from block in included at /opt/redmine/redmine-3.1.0/plugins/redmine_gi                                                                                                             t_hosting/lib/redmine_git_hosting/patches/setting_patch.rb:14)
  Started GET "/redmine/projects/sidhe-boann/activity" for 192.168.1.106 at 2016-0                                                                                                             9-03 01:07:04 +0200
  Processing by ActivitiesController#index as HTML
    Parameters: {"id"=>"sidhe-boann"}
    Current user: anonymous
  Redirected to http://192.168.1.202/redmine/login?back_url=http%3A%2F%2F192.168.1                                                                                                             .202%2Fredmine%2Fprojects%2Fsidhe-boann%2Factivity
  Filter chain halted as :check_if_login_required rendered or redirected
  Completed 302 Found in 93ms (ActiveRecord: 7.8ms)
  Started GET "/redmine/login?back_url=http%3A%2F%2F192.168.1.202%2Fredmine%2Fproj                                                                                                             ects%2Fsidhe-boann%2Factivity" for 192.168.1.106 at 2016-09-03 01:07:04 +0200
  Processing by AccountController#login as HTML
    Parameters: {"back_url"=>"http://192.168.1.202/redmine/projects/sidhe-boann/ac                                                                                                             tivity"}
    Current user: anonymous
    Rendered account/login.html.erb within layouts/base (90.7ms)
  Completed 200 OK in 385ms (Views: 360.8ms | ActiveRecord: 8.2ms)
  

I am not sure if the issue is with Apache, Ruby or Passenger tbh.

Martin Denizet (redmine.org team member) wrote:

Hello,
I add my 2 cents:
Smokie Smokerson wrote:

I can still get the database through phpmyadmin but whenever i try to import it to a fresh install of Redmine it gives me an error..

I understand that you made a fresh new (3.4.x?) install, droped the new database and replaced it with your backup.
If it's the case, make sure you run migrations after restoring the backup:
[...]

Also, to do a full backup of Redmine, you should also get the files in the files directory. File attachments are not included in DB backups.

Cheers!

Thanks Martine.. I installed this new quick setup using ubuntu apet-get install redmine just to see if i can restore my database, it installed version 3.2.1.

I will try to run the migration command though like you suggested and see if that helps.

Martin Denizet (redmine.org team member) wrote:

Hello,
I add my 2 cents:
Smokie Smokerson wrote:

I can still get the database through phpmyadmin but whenever i try to import it to a fresh install of Redmine it gives me an error..

I understand that you made a fresh new (3.4.x?) install, droped the new database and replaced it with your backup.
If it's the case, make sure you run migrations after restoring the backup:
[...]

Also, to do a full backup of Redmine, you should also get the files in the files directory. File attachments are not included in DB backups.

Cheers!

The migration command made it work!

the command "RAILS_ENV=production bundle exec rake db:migrate" gave me an error but running this: ruby bin/rake db:migrate RAILS_ENV=production worked.