| Author |
 Topic Search  Topic Options
|
VTBO 
Newbie
Joined: 01 November 2008
Status: Offline
Points: 24
|
 Posted: 18 March 2009 at 10:03am |
Well it was set as a default application in the application pool. I added a new application pool and made sure it was set to 1 worker process. It didn't make a difference.
I restored the software back to the way it was prior to my modifications above.
I can log in, but when I go to login as admin it ignores the captcha info and tells me it was wrong. I see the same thing I am typing in the session table but for some reason it isn't making it through the compares. If I blow the normal user login and it puts up a captcha after 3 incorrect tries, I can no longer log in as the captcha compare does not work unless I add cstr and trim functions to the first term. This is really strange. I cannot log in to any of the web wiz forums here free or paid, something really changed, I still think it has to do with the updates but I don't know which, not sure I want to roll back and the web wiz stuff is the only stuff that has been effected.
Phil
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Posted: 18 March 2009 at 11:13am |
|
It still sounds to me like a session issue.
We have updated over 10 Win2k3 boxes here which all have the latest MS patches on and can see no issues with sessions. Although I do remember an issue with ASP Sessions that was coursed by SP1 or SP2 for Win2k3 but was later fixed, but this was going back a few years.
Also have you tried changing your forums in the includes/setup_options_inc.asp file to use the database to store session data in instead of the IIS worker process?
|
|
|
|
VTBO
Newbie
Joined: 01 November 2008
Status: Offline
Points: 24
|
Posted: 18 March 2009 at 12:45pm |
Well i tried rolling back the 3 software updates that were applied on the 11th and it was still bad so it wasn't them. I do remember installing that microsoft malicious software removal tool update, so maybe that got overzealous and took something out it wasn't supposed to. I just put the updates back in.
I am already using the database for the sessions, not using the application method, although it doesn't work either. This is about the strangest thing I have seen. Sorry to be such a pain.
Phil
|
|
VTBO
Newbie
Joined: 01 November 2008
Status: Offline
Points: 24
|
Posted: 18 March 2009 at 12:51pm |
|
I wonder if it could be some sort of permissions thing that changed. What are your applications pools running under. Are they as a network service, or IWAM or something else?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Posted: 18 March 2009 at 12:55pm |
|
If you are using the database for sessions then it should make no difference if sessions are working on the server or not.
Have a look in the database at the tblSessions table and see if the CAPTCHA code matches that in the session table in the database.
Also make sure that the collation for the database is not case sensitive.
|
|
|
|
VTBO
Newbie
Joined: 01 November 2008
Status: Offline
Points: 24
|
Posted: 18 March 2009 at 1:16pm |
Well, I see the captcha in the sessions table. See first postings. Problem is that it doesn't work unless I add that "trim" function to the first part of the compare as shown in the sql code posted.
WHen i am at the admin login screen once it compares and it sends me to the next page admin login then it craps out because the session table is now blank so it thinks i am a guest and tells me i have no permissions. better explanation in previous posts.
I have not changed anything in the database at all, but the 2 forums i have both stopped working at the same time, one is on a win2k machine the other is on a win2k3 machine. One is 9.55 the other is 9.53.
Really strange.
Phil
|
|
VTBO
Newbie
Joined: 01 November 2008
Status: Offline
Points: 24
|
Posted: 23 March 2009 at 12:13am |
After several hours of debuging, it has come down to the session info in the session table is clearing out. If I try to login 3 times as admin each time the captcha is not recognized after the 3rd login attempt, I am no longer loged in at all. Something is not working when using the session table to track user sessions instead of the application.
I switched the config file back to use application variables for both the forum config and the users and now everything seems to work ok. So apparently there is some sort of bug in using the sessions table. For now I will keep it using the applications, but I would rather use the sessions table if possible.
Phil
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Posted: 23 March 2009 at 9:24am |
|
Have not found an issue with this during testing when using the database to store sessions.
However, it is highly recommend not to use the database to store sessions unless you really have to, as using the database to store the session database is a BIG performance hit on the forum engine. It can more than double the amount of read and writes on the database for many popular pages.
|
|
|
|
Cannot login as Admin and CAPTCHA problems