[Help] Multiple Forums with Single User DB

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts

[Help] Multiple Forums with Single User DB

Postby Zason » Fri Jan 29, 2010 9:33 pm

I hope this is the place to ask this since it is neither a mod or mod request.

I poised this question in a thread however it was not directly related to the OP. viewtopic.php?f=72&t=1935435

I have separate phpbb3 DBs and I want to link them together with a single user DB. How can I do this?

"Z"
Looking for help with: Linking separate PHPBB3 forum DB with a single User BD

phpBB Primetime - Not your daddy's portal.
User avatar
Zason
Registered User
 
Posts: 48
Joined: Mon Feb 17, 2003 8:40 pm
Location: Austin TX

Re: [Help] Multiple Forums with Single User DB

Postby HGN » Fri Jan 29, 2010 10:01 pm

You may have a look in the topic Help with forums sharing same database.. It gives directions on how to share a user database over several forums.
User avatar
HGN
Former Team Member
 
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred

Re: [Help] Multiple Forums with Single User DB

Postby Zason » Tue Feb 02, 2010 3:49 am

I must confess, I tried reading and following the above linked thread and what I gather is that the multiple forums are on the same database.

I have separate databases, same server, I would ideally like to dictate having some sites share tables so information is cross posted, however that is a bit away.

Currently I need to share users and any other tables required for users. Not permissions or groups as they are going to be site specific.
Looking for help with: Linking separate PHPBB3 forum DB with a single User BD

phpBB Primetime - Not your daddy's portal.
User avatar
Zason
Registered User
 
Posts: 48
Joined: Mon Feb 17, 2003 8:40 pm
Location: Austin TX

Re: [Help] Multiple Forums with Single User DB

Postby Zason » Sun Feb 14, 2010 11:46 pm

Still looking for help. Currently all of the sites run fine on separate databases.

Also looking for a way to change where PHPBB3 looks for certain folders/files. For an example, if I could have it look for styles in root/sites/DOMAIN.com/styles/ rather than the default. (Note: DOMAIN.com is not static since different sites folders have different names.)
Looking for help with: Linking separate PHPBB3 forum DB with a single User BD

phpBB Primetime - Not your daddy's portal.
User avatar
Zason
Registered User
 
Posts: 48
Joined: Mon Feb 17, 2003 8:40 pm
Location: Austin TX

Re: [Help] Multiple Forums with Single User DB

Postby Seibertron » Wed Feb 17, 2010 3:50 am

HGN wrote:You may have a look in the topic Help with forums sharing same database.. It gives directions on how to share a user database over several forums.


I'm basically looking for this modification as well. I read through all 6 pages at viewtopic.php?p=3087439#p3087439, and while I think they're on the right track ... it looks like a MOD in progress without a set of clear and concise instructions on how to properly address sharing users amongst the different forum installations and sharing avatars and image files users upload.

Very interested in a comprehensive mod that provides a proper solution for having a network of websites.
Seibertron.com
http://www.seibertron.com
The Ultimate Transformers Fansite
User avatar
Seibertron
Registered User
 
Posts: 54
Joined: Tue Oct 01, 2002 7:54 pm
Location: Chicago, IL

Re: [Help] Multiple Forums with Single User DB

Postby Zason » Wed Feb 17, 2010 2:55 pm

Right, me too. >:+)

If there was a way to add a code in the config to pull users from a different database, that would be perfect since I have a config for each site/forum.

I remember there was a forum that allowed this, but it was a long time ago. phpBB2? PHPnuke? Dragonfly? I forget.

"Z"
Looking for help with: Linking separate PHPBB3 forum DB with a single User BD

phpBB Primetime - Not your daddy's portal.
User avatar
Zason
Registered User
 
Posts: 48
Joined: Mon Feb 17, 2003 8:40 pm
Location: Austin TX

Re: [Help] Multiple Forums with Single User DB

Postby Zason » Thu Apr 22, 2010 11:56 pm

Patient Bump.
Looking for help with: Linking separate PHPBB3 forum DB with a single User BD

phpBB Primetime - Not your daddy's portal.
User avatar
Zason
Registered User
 
Posts: 48
Joined: Mon Feb 17, 2003 8:40 pm
Location: Austin TX

Re: [Help] Multiple Forums with Single User DB

Postby Seibertron » Fri Apr 23, 2010 1:17 am

Yeah, i'm still waiting for this as well. Hoping that a proper mod can come out for this rather than me trying to hack together a bunch of sites.
Seibertron.com
http://www.seibertron.com
The Ultimate Transformers Fansite
User avatar
Seibertron
Registered User
 
Posts: 54
Joined: Tue Oct 01, 2002 7:54 pm
Location: Chicago, IL

Re: [Help] Multiple Forums with Single User DB

Postby Arthran » Fri May 14, 2010 10:43 pm

I have just successfully created 2 forums in a single database sharing users without any permissions problems.

Im going to do a writeup on it in the next few days and publish it here, whilst it wont allow you to use multiple databases, it may give you the information you need to go that extra step.
Arthran
Registered User
 
Posts: 4
Joined: Wed Dec 05, 2007 9:01 pm

Re: [Help] Multiple Forums with Single User DB

Postby Seibertron » Fri May 14, 2010 11:08 pm

Arthran wrote:I have just successfully created 2 forums in a single database sharing users without any permissions problems.

Im going to do a writeup on it in the next few days and publish it here, whilst it wont allow you to use multiple databases, it may give you the information you need to go that extra step.


Sounds great. Looking forward to it.
Seibertron.com
http://www.seibertron.com
The Ultimate Transformers Fansite
User avatar
Seibertron
Registered User
 
Posts: 54
Joined: Tue Oct 01, 2002 7:54 pm
Location: Chicago, IL

Re: [Help] Multiple Forums with Single User DB

Postby Edgen22 » Sun Jun 06, 2010 5:17 pm

Arthran wrote:I have just successfully created 2 forums in a single database sharing users without any permissions problems.

Im going to do a writeup on it in the next few days and publish it here, whilst it wont allow you to use multiple databases, it may give you the information you need to go that extra step.


I was looking forward to it too but it doesn't look like he has logged on again since his original post. I would email him but I don't have permission to do that yet (less than 5 posts on my account).

Anyone else want to fill in for him?
Edgen22
Registered User
 
Posts: 2
Joined: Fri Mar 10, 2006 3:20 am

Re: [Help] Multiple Forums with Single User DB

Postby stevemaury » Sun Jun 06, 2010 8:14 pm

This works fine if you just share the users, banlist, sessions and sessions_keys tables:

http://www.phpbb.com/kb/article/share-m ... bb-boards/
For REALLY good and VERY inexpensive hosting CLICK HERE

http://www.stevesstocks.com

All unsolicited PMs will be ignored.
User avatar
stevemaury
Support Team Member
Support Team Member
 
Posts: 44096
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve

Re: [Help] Multiple Forums with Single User DB

Postby Edgen22 » Sun Jun 06, 2010 8:46 pm

stevemaury wrote:This works fine if you just share the users, banlist, sessions and sessions_keys tables:

http://www.phpbb.com/kb/article/share-m ... bb-boards/


"The article specified doesn't exist."

I tried googling it in case you made a typo but had no luck... :(
Edgen22
Registered User
 
Posts: 2
Joined: Fri Mar 10, 2006 3:20 am

Re: [Help] Multiple Forums with Single User DB

Postby stevemaury » Sun Jun 06, 2010 9:21 pm

For REALLY good and VERY inexpensive hosting CLICK HERE

http://www.stevesstocks.com

All unsolicited PMs will be ignored.
User avatar
stevemaury
Support Team Member
Support Team Member
 
Posts: 44096
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve


Return to 3.0.x Support Forum

Who is online

Users browsing this forum: ezhrs, MSNbot Media, Oyabun1 and 73 guests