This week's book giveaway is in the Reactive Progamming forum.
We're giving away four copies of Reactive Streams in Java: Concurrency with RxJava, Reactor, and Akka Streams and have Adam Davis on-line!
See this thread for details.
Win a copy of Reactive Streams in Java: Concurrency with RxJava, Reactor, and Akka Streams this week in the Reactive Progamming forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

porting users from my DB to jforum DB

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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]
 
Barry's not gonna like this. Barry's not gonna like this one bit. What is Barry's deal with tiny ads?
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!