2 sites same database and user base.

Client Joined: Aug 14, 2005 Posts: 151

I was supplied a link from Raven for the steps to do this but I have a few things that I need to clarify first.

http://www.ravenphpscripts.com/nukemanual-more-than-one-php-nuke-sites.html

3.7.1.1 question - Had both config.php files opened and I copied the sql database info for the current main site into the config.php of the new subDomain RN install. I assume (based of the link above) that this is correct. The only edit I made to the sql info was adding the 1 and 2 for the first and second website.

Is this correct? I have not done anything to the existing nuke.sql yet because I want to know the exact process before I commit to possibly trashing my database Smile

Do I edit these config.php files THEN the nuke.sql THEN install the RavenNuke package for the second site? Its all on my FTP, I just need to go thru the install process BUT this is where I had questions. I shouldnt have to do the usual sql install stuff because I am using the existing database correct? The config.php should already have the needed info in it for the site to work?

Posted: Sat Apr 19, 2008 3:42 am

OK, just to clarify can you confirm exactly what you are doing?

1. Are you trying to install two sites in the same database, but with separate data?

2. Installing two sites with separate content, but sharing the users?

3. Installing two sites with the same data and users?

From your title it sounds like you want to do option 3, but 3.7.1.1 refers to option 1.

Posted: Sat Apr 19, 2008 7:59 am

2 sites, seperate content but sharing users.

awolgamers.com site1

aoc/awolgamers.com site2

For some reason I thought that you had to do both??

Posted: Sat Apr 19, 2008 5:01 pm

ok I am in the land of the unknown. I went into my assault_nuke database in phpMyAdmin and I have not a clue as to what I am looking at. I am directed to edit nuke.sql files so that my 2 sites will share users.

I am really lost. I have the config.php files ready I believe. That part seemed easy but I still have not uploaded them to the server. A point of serious confusion for me is the fact that it says that "the full name of the users table should thus be "nuke-common_users" in both nuke.sql files. Then proceed with the installation as described".

Now, it talks about setting up the user tables in both sites ... Only 1 site is installed. The new one just has the RavenNuke install files in its root folder. So I am of course getting really confused. Any of Ravens forum admins here willing to set this up for me? We would be willing to pay.

registered · Posted: Sat Apr 19, 2008 6:57 pm

You will need to run the install to set up two sets of tables (with different prefixes).

Then you will need to set the user_prefix values the same, to point to one of the users tables (either one will do).

Posted: Sat Apr 19, 2008 7:47 pm

but I am sharing the database and users. The second install has to have its own tables? argh. lol

so..

before I do ANYTHING I edit the config.php to share the database then I install the sub site. AFTER that I go about editing the sql stuff?

heh Raven is to busy to do this for a fee so I need to be pointed to someone that does this stuff for kaching!

. I am 100% still lost.. probably worse than 2 hours ago.

Posted: Sat Apr 19, 2008 10:36 pm

well I have an existing website already so I will not be installing 2 sets of tables. I am going to use that sites users for the new sub site for my main. So I dont see how you telling me to install 2 sets of tables makes this less confusing for me Smile

I would only need to install the NEW nuke site and its tables? The go back and edit them so that they use the same stuff? Or do I simply enter the info from the current website into the config.php for the NEW website then run the installer? Anyone?

Posted: Sun Apr 20, 2008 3:19 am

You need two sets of tables, otherwise both your sites will be serving up exactly the same content. Load the tables first before doing any changes to config.php

You can enter the same information from config.php, but the prefix value must be different.

Posted: Sun Apr 20, 2008 11:18 am

That makes sense now. Thanks for the clarification!

Posted: Wed Apr 23, 2008 9:00 am

Out of cursiosity - has anyone messed with replication in MySql that can speak intelligently on the subject? (Does MySql even provide the option for replication?)

Posted: Wed Apr 23, 2008 11:05 am

May want to try the mysql forum for that one to keep this one on topic? Smile

Posted: Wed Apr 23, 2008 8:39 pm

Mysql does provide replication, but I haven't tried it myself

Posted: Thu Apr 24, 2008 1:17 pm

Guardian2003 wrote:

May want to try the mysql forum for that one to keep this one on topic? Smile

Hey, it's close enough! Laughing

If MySql would do the replication, you could ~conceivably~ set up one databases' user table to replicate to the other. . . of course the timing of replication would be an issue, but it could work.

You would certainly answer the question "who's the biggest massochist" in the forums.

-sting

registered · Posted: Fri Apr 25, 2008 11:52 am

Not sure if you can do table-wise replication. It might be at a higher level than that. However, within the same database, one can certainly drop and recreate a new table based upon another one... Wink