Welcome to Geeklog, Anonymous Monday, November 25 2024 @ 03:22 am EST
Geeklog Forums
shared user tables
joe
Anonymous
I have 3 sites. Same server, same database, different domains. All working fine seperately. I tried sharing the 5 user* tables between them with no luck. Keep getting errors in sql to the access table.
I simply want the same userid and password to work on all three sites.
Has anyone done this? Can it be done by making certain tables shared? Which ones? Does this have to be done via a custom registration? Has anyone done that?
Thanks.
Joe
I simply want the same userid and password to work on all three sites.
Has anyone done this? Can it be done by making certain tables shared? Which ones? Does this have to be done via a custom registration? Has anyone done that?
Thanks.
Joe
12
9
Quote
joe
Anonymous
Seems to be working. Here's the shared tables:
access,
features,
groups,
group_assignments,
usercomment,
userinfo,
userindex,
userprefs,
users,
for forum settings:
forum_userprefs,
forum_banned_ip,(only have to ban once)
forum_userinfo
I've done about 30 minutes of test cases and it seems fine so far. I'll post if anything needs to be different.
access,
features,
groups,
group_assignments,
usercomment,
userinfo,
userindex,
userprefs,
users,
for forum settings:
forum_userprefs,
forum_banned_ip,(only have to ban once)
forum_userinfo
I've done about 30 minutes of test cases and it seems fine so far. I'll post if anything needs to be different.
12
10
Quote
Status: offline
sboss
Forum User
Newbie
Registered: 09/24/04
Posts: 2
I went into system/lib-databases.pbp and changed the tables to point to the "common" ones, but in the error.log I get that it can not read the sboss_gl_ versions (which is specific to my one website and not the commn ones). What other file(s) do I need to change?
Scott
Scott
13
15
Quote
All times are EST. The time is now 03:22 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content