[Solved] Save my Redmine setup

Added by Smokie Smokerson 5 months ago

Hello,

I had Redmine-3.1.0 installed in an Ubuntu VM for couple of years, for some reason I cannot access it anymore. Something messed up and i dont know exactly what it is. whenever i go to http://localip/redmine it shows the root folder with a list of files and folders instead of opening up Redmine.

i dont know anything about gem, Ruby, passenger etc...

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..

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

Thank you in advance.

Replies (7)

RE: Save my Redmine setup - Added by Bernhard Rohloff 5 months ago

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

RE: Save my Redmine setup - Added by Smokie Smokerson 5 months ago

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.

RE: Save my Redmine setup - Added by Bernhard Rohloff 5 months ago

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?

RE: Save my Redmine setup - Added by Martin Denizet (redmine.org team member) 5 months ago

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!

RE: Save my Redmine setup - Added by Smokie Smokerson 5 months ago

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.

RE: Save my Redmine setup - Added by Smokie Smokerson 5 months ago

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.

RE: Save my Redmine setup - Added by Smokie Smokerson 5 months ago

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.

(1-7/7)