Unable to see data from old Redmine on new server Ubuntu 10.04
Added by allen yeh over 14 years ago
We have an old CentOS box running Redmine and yesterday i setup a Ubuntu 10.04 server and used these instructions:
http://www.redmine.org/wiki/redmine/HowTo_Install_Redmine_in_Ubuntu#Ubuntu-104-using-Passenger
It loaded up a new instance of redmine with no problems. I went with apache2 and passenger, very simple.
Today I have been trying to get the data from our old instance onto the new instance and this part is frustrating me.
On the old server I did a mysqldump and zipped up all the files in the files directory and copied those onto the new server.
On the new server I did:
- mysql -u root –p
Enter password: DDDDDDD
mysql> drop database redmine;
mysql> create database redmine;
mysql> exit
#mysql --database = redmine -u root -p < dump.sql
Enter password: ***exit- rake db:migrate RAILS_ENV="production"
- rake db:migrate:upgrade_plugin_migrations RAILS_ENV="production"
- rake db:migrate_plugins RAILS_ENV="production"
- sudo service apache2 restart
Now it still loads up a blank redmine instance. What am I missing here?
Previously as a test we had done similiar steps but imported it onto a Windows box w/bitnami and that came out alright but we ran into problems trying to upgrade redmine and decided to stick with Linux and a non-bitnami installation.
Replies (4)
RE: Unable to see data from old Redmine on new server Ubuntu 10.04 - Added by allen yeh over 14 years ago
Figured it out:
In the instructions the database.yml was located in /etc/redmine but the ruby file doesn't look for it there it looks for the database.yml in /etc/redmine/default/
Also the email.yml belongs in there as well not in /usr/share/redmine/config as it used to.
currently having problems with the email.yml though.
RE: Unable to see data from old Redmine on new server Ubuntu 10.04 - Added by Felix Schäfer over 14 years ago
That looks right, any errors in the logs, or just nothing in redmine? Make sure you export the right DB and import it in the right one (not sure where the debian package assumes the default redmine database is, you might want to check that).
RE: Unable to see data from old Redmine on new server Ubuntu 10.04 - Added by Felix Schäfer over 14 years ago
The debian package changes stuff to comply to LSB, i.e. puts config files in /etc/redmine and stuff like that.
RE: Unable to see data from old Redmine on new server Ubuntu 10.04 - Added by allen yeh over 14 years ago
Felix,
It was because the database.yml that I modified was not in the correct place, in Ubuntu 10.04 if you install with the package it looks for database.yml in /etc/redmine/default/
I didn't realize installing it from the package would put things in different places than on my older instance of Redmine where everything pretty much resided in /opt/redmine/
Thanks for the reply.