Converting Phpbb2 To Smf

[zhiping]

When I try to convert my phpbb2 forum to smf forum, it ask for the database path for the old (phpbb2) and the new, I think I gave the correct path

http://mydomain/oldforum_folder
http://mydomain/newforum_folder

and password for the new forum.

However, it comes back saying that the MySQL account for the new forum doesn't have access to the old forum. What should I do? I am the site admin, and should be able to grant everything.

Thank you very much.

[edmicman]

Originally posted by zhiping@May 10 2005, 08:12 PM
When I try to convert my phpbb2 forum to smf forum, it ask for the database path for the old (phpbb2) and the new, I think I gave the correct path

http://mydomain/oldforum_folder
http://mydomain/newforum_folder

and password for the new forum.

However, it comes back saying that the MySQL account for the new forum doesn't have access to the old forum. What should I do? I am the site admin, and should be able to grant everything.

Thank you very much.
Quoted post


I remember struggling with this, too. I think I ended up installing SMF in the same database as phpBB...I know, it was a kludge, but it was the only way I could get it to work.

The problem is, that the SMF install needs a db user that has access to both databases. But the way DA seems to work, and for the life of me I couldn't figure out a different way, is that each db has its admin user, and you can't grant priviledges to another db to that user. If you try to create a user with the same name as the phpBB user and give it access to the new SMF db, you get an error that the user already exists. I couldn't figure out how to add SMF db access to the phpBB db user, nor could I seem to find a way to create a new user that had access to both db's. It was hassle for sure. Good luck!

[eugene]

There are three solutions:
1. Add the new DB user to the old database.
2. Add a new user to both.
3. Use your DA login/pass combo as the DB combo. The DA login/passwd have access to all of your DBs.