I have a drupal 6.13 site running. I would like to add mantis to the website. I have a private test site with drupal 6.13 and mantis 1.1.8. Everything seems to work normal. If a user registers in drupal, bugbits creates the mantis account. The only thing I cannot figure out is how to get existing drupal user accounts (created before mantis and bugbits where added) into mantis.

In the "Recent log entries" section I see this:
User TommyC doesn't exist in mantis, failed mantis_id check.
and:
Error user TommyC was not able to log into Mantis

Is there someone who can help out?

Comments

daften’s picture

daften commented
Assigned: Unassigned » daften

I'm working on that feature, it will be the option for the user to link his drupal account to his mantis account. Automatic sync is on the feature list in the long run, but that will be a while :)

TommyC’s picture

TommyC commented

Thanks for your time and especially the quick response.

Being able to link two existing accounts from the account page is indeed a nice feature but is not what I'm talking about.

The users I'm talking about currently only have drupal accounts, no mantis accounts. Since new drupal users are automatically added to mantis it would seem to me that it should also be possible and relatively easy to enable site admins to do the same thing for a large amount of existing drupal users.

daften’s picture

daften commented

That is something that is going to be done, in the long run, but we need to make sure that no problems arise from that.

maori’s picture

maori commented

heya is there any update on this

regards

daften’s picture

daften commented

No, At the moment there is no active development going on due to other priorities. I hope to get back to this, but I fear it might not be possible.

maori’s picture

maori commented

heya thanks for the info

for now i used a simple sql to import the users and so far it looks ok ie have been able to login via a few diffrent users id's and password's

tmckeown’s picture

tmckeown commented

Maori,

Would you be willing to share your db script you used and I can test it and hopefully rolled it into the next release.

Thanks,

Trevor

maori’s picture

maori commented

heya tmckeown

sure thing 

INSERT INTO mantis_user_table(id, username, realname, email, password, enabled, protected, access_level, login_count, lost_password_request_count, failed_login_count, cookie_string, last_visit, date_created)select uid,name,"",mail,pass,'1','0','10','0','0','0',rand(),'1','1' From users where uid != "1"

as i sayed it is a simple one as i'am not that good :( but this works all i did was copy over the drupal database users table to the mantis database one ran this sql and then deleted the copied table i left the original mantris admin in the table as i set it up initially whith same details as i made for my drupal but you could just clear the mantris table and copy all over by removing the where clause. but if you do that make sure you goto your admin account name in the table and set its access level to 90 which is the admin level for mantris

hope i didnt confuse you there just trying to get all info across

hope it helps
/Maori

editied forgot to add the rand() to the cookie string as without i had a problem loggin

daften’s picture

daften commented
Assigned: daften » Unassigned
Issue summary: View changes