| Author |
 Topic Search  Topic Options
|
GhOs+ 
Groupie
Joined: 02 January 2005
Location: United States
Status: Offline
Points: 115
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Integrate w/ other user database app/tables
Posted: 03 April 2012 at 8:27pm |
I am very much interested in integrating the forum database with another user database I have. Actually, I'm only using ONE database, but different sets of tables for two different apps, specifically the forum app, and a customer/userlevel app. I would very much like to keep the integrity of both sets of data intact, so when there is a major WebWiz upgrade, the forum tables can easily be upgraded without much concern of breaking anything on the other end. I realize this is quite a feat, and would like to get input/advice regarding this endeavor. Especially from someone who has already done this. The goal is to have one login for the forum, as well as other aspects of the site (as per user permissions defined in the other tables). What unique identifier in the "AUTHOR" table was used, Author_ID? What method(s) did you use to transfer the username/email/password to the other tables so the logins always remain the same for both applications? Many thanks, GhOs+
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(1)
Quote Reply
Posted: 03 April 2012 at 9:14pm |
For integration with an existing database you should look at the pages below:-
|
|
|
|
GhOs+
Groupie
Joined: 02 January 2005
Location: United States
Status: Offline
Points: 115
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 April 2012 at 2:50am |
|
|
|
GhOs+
Groupie
Joined: 02 January 2005
Location: United States
Status: Offline
Points: 115
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 February 2013 at 9:18pm |
I know it's been a while since i looked at implementing this. It looks rather simple, but I just can't get it to work. I'm obviously missing something and am hoping someone can help - functions_member_API.asp: Const blnMemberAPI = True Created the following sessions: Session("USER") Session("PASSWORD") Session("EMAIL") I confirmed the Session("USER") value does not exist as a username in the forum tables. It should automatically create a username with this value when navigating to a forum page, correct? Nothing happens - the forum page remains as usual and I do not get "logged in"
|
|
GhOs+
Groupie
Joined: 02 January 2005
Location: United States
Status: Offline
Points: 115
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 February 2013 at 9:50pm |
|
Just in case it's needed, I assigned the directory of the membership system I'm using to the same application pool as the forum, and restarted IIS. I also called up the Session.SessionID and noticed that it increments by one when I move from the membership page to a forum page. Could this be related to my problem somehow?
|
|
IanSmithISA
Groupie
Joined: 21 October 2010
Location: Worcester
Status: Offline
Points: 127
|
Post Options
Thanks(1)
Quote Reply
Posted: 04 February 2013 at 6:29am |
Good morning,
I am not at all sure that I am right about this but....
Many pages don't need you to be logged in to view them, so maybe setting these Session variables won't force a login.
So maybe you need to call the login_user.asp page to get a login performed using these Session variables and then to go where you want to, you can set the request parameter "returnURL" with the page's URL. There is a bit processing of this on line 182
I am not at all sure that I know what I am talking about though.
Bye
Ian |
|
Why does anyone need more than an 80x25 character only VDU?
|
|
GhOs+
Groupie
Joined: 02 January 2005
Location: United States
Status: Offline
Points: 115
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 February 2013 at 6:36am |
|
Thanks for your reply. Not working, though. By using response.write, I verified that the Session("USER") is populated in the page before I go to the forum, and I tried doing a response.write of Session("USER") in a forum page, but it nothing shows up! Apparently the forum isn't picking up any of the session variables...
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 February 2013 at 8:36am |
For ASP sessions to work in Classic ASP they require that you use both a single application pool and for security reasons the same website.
ASP sessions also rely on a session cookie to run, so if you change domain, even if it is the same website but using a sub domain, a new ASP session would be created and you would loose your old session variables.
For session variables to work you need to:-
1. Use a single domain (eg. www.example.com and www.example.com/forum) 2. Use a single application pool for the website
|
|
|
|
