Migration Mantis Redmine

Command :

c:\”program files\bitnami redemine stack\ruby\rake” redmine:migrate_from_mantis RAILS_ENV=”production”

result :

Migrating usersrake aborted!
Acces denied for user ‘root’@localhost’ <using no password:>

??????

Hi groswill,

I try to execute the script and I can see the Mantis options:

Please enter settings for your Mantis database
adapter [mysql]:
host [localhost]:
database [bugtracker]:
username [root]:
password []:
encoding [UTF-8]:

Have you configured the mantis database correctly?

Maybe this script needs to be executed by the MySQL root user. Have you tried to change the database user and password to the root MySQL user in redmine/config/database.yml?

How can i change the database user and password to the root MySQL user in redmine/config/database.yml?

You can edit this file with a notepad for example:

production:
adapter: mysql
database: redmine_production
host: localhost
username: root
password: root_password

Mantis
database : bugtracker
username : root
password :

redmine “production” in redmine/config/database.yml
username : bitnami
password : bitnami

Command :

adapter [mysql]:
host [localhost]:
database [bugtracker]:
username [root]:
password []:
encoding [UTF-8]:

Acces denied for user ‘root’@’localhost’

??

Is MySQL Mantis running? BitNami Redmine has a database and Mantis should be another database. What are the ports? Maybe you can specify the port to the MySQL Mantis database in the host name:

host [localhost]: localhost:port

in C:\Program Files\BitNami Redmine Stack\mysql\data

redmine database = redmine_production
mantis database = bugtracker

Mantis is installed in other server so i copy and paste the Mantis database in the same directory (C:\Program Files\BitNami Redmine Stack\mysql\data).

How can I verify that MYSQL Mantis is running ?

I think that you shouldn’t to copy the database. The migrate_from_mantis script runs with another database. Have you tried to set the parameters of the Mantis database?

If you have copied the database, the script is trying to access to the redmine MySQL database. Try to insert your MySQL redmine root password which you inserted during the Bitnami Redmine installation.

redmine root password inserted during the Bitnami

username : admin
password : csismglmgl

adapter [mysql]:
host [localhost]:
database [bugtracker]:
username [root]: admin
password []: csismglmgl
encoding [UTF-8]:

Acces denied ….....

Other solution :

The mantis database is on the IP 10.201.0.50
The redmine database in on localhot

How can I writ the command ??

adapter [mysql]:
host [localhost]: 10.201.0.50
database [bugtracker]:
username [root]:
password []:
encoding [UTF-8]:

username [root]: admin
password []: csismglmgl

This is the username of the Redmine application. You should insert root/csismglmgl.

How can I writ the command ??

Yes, this is the approach. This script should import all Mantis data from the remote MySQL to the Redmine MySQL server.

scenario 1 [localhost]

adapter [mysql]:
host [localhost]:
database [bugtracker]:
username [root]: root
password []: csismglmgl
encoding [UTF-8]:

Acces denied ……..

scenario 2 (network)

Config Mantis database :

$g_hostname            = 'localhost';   
$g_db_username        = 'root';      
$g_db_password        = '';          
$g_database_name= 'bugtracker';

adapter [mysql]:
host [localhost]: 10.201.0.50
database [bugtracker]:
username [root]:
password []:
encoding [UTF-8]:

Can’t connect to MYSQL server on 10.201.0.50

It seems that the Mantis database runs in a private network. Are you in the same network that the Mantis MySQL database? Is this database running on the 3306 port?

Computer 10.201.0.111 In workgroup
C:\Program Files\BitNami Redmine Stack\mysql\data
Redmine DataBase : redmine_production

Computer 10.201.50 In workgroup
C:\Program Files\EasyPHP1-8\mysql
Mantis database : bugtracker

Command

adapter [mysql]:
host [localhost]:10.201.0.50: 3306
database [bugtracker]:
username [root]: root
password []:
encoding [UTF-8]:

Can’t connect to MYSQL server on 10.201.0.50

Sorry,

I don’t know what is happening. Are you sure that the mantis MySQL is running? Maybe you can find more help in the redmine forums.