Posted by TommyC on September 9, 2009 at 1:14pm
Jump to:
| Project: | Bugbits |
| Version: | 6.x-1.x-dev |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | daften |
| Status: | active |
Issue Summary
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
#1
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 :)
#2
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.
#3
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.
#4
heya is there any update on this
regards
#5
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.
#6
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
#7
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
#8
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