porting users from my DB to jforum DB

[Migrated From Jforum.net]

jforum_users is exactly as phpbb_users. A just copy'n paste from one to another should work.

Passwords in both jforum and phpbb are stored in MD5 hashes. For further reading please see http://www.jforum.net/confluence/display/migration/phpbb

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

hello;
i want to port my current users from my table (that holds username, clear text password, and user role) to jforum tables so that the existing users i have will be able to log in to jforum.
what steps should i take? i looked at the jforum_users table and lost it. there are stuff such as hashed password that idont know how to deal with (amongst other fields in the table).
help would be appreciated.
thanks.
[originally posted on jforum.net by gkatz]

[Migrated From Jforum.net]

by the way ; i read https://coderanch.com/t/574740 this + the links there but it did not help my case.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

thanks;
but in order to port my users to jforum users what steps should i take.
should i put username and password in the jforum_users table and taht it? or are there other tables i should look at?

i just want my current users to be able to log in to the forum using their old username and password.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Sorry, I don't know why I thought you were using phpbb ..

Well, you should at least fill username and password using a MD5 hash. If possible, fill the email as well. I guess it will work for you.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

hi;
i managed to port my users inserting to jforum name,md5 password, and email.
now those users can login but cant see forum that were created. i guess its because they are not associated with a group? is this correct?
what table should i insert more data (all those users are for the general group) in oorder for the users to be able to actually see and use the forums?
thanks
[originally posted on jforum.net by gkatz]

[Migrated From Jforum.net]

Associate all users to the "General" group ( see jforum_users ). You can do that in the admin too, but it will be very hard to manage one by one.. The best will be to add the association via database console.

Don't forget to set groups' permissions ( Admin Panel -> Groups -> Permissions ), rememberint that, for the first time, you should click "Update" to store the rights in the db.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

hi;
i added an entry to jforum_users
and another entry to jforum_user_groups (with the userid from the first insert and gorup id for 'general').

that seems to do the trick.
is there anything else (like another insert to another table) i should do?
[originally posted on jforum.net by gkatz]

[Migrated From Jforum.net]

No, these steps do the trick. Now, you just need to edit the users / groups you want to have more ( or less ) privileges, like admins and moderators. But this can be done in the admin panel without problem.

Rafael
[originally posted on jforum.net by Rafael Steil]