Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - MSSQL v7.97 New Install -- Admin Button problems
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MSSQL v7.97 New Install -- Admin Button problems
 Post Reply Post Reply Page  <123>
Author
  Topic Search Topic Search  Topic Options Topic Options
Webmaster MJF View Drop Down
Newbie
Newbie


Joined: 14 February 2006
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Webmaster MJF Quote  Post ReplyReply Direct Link To This Post Posted: 20 February 2006 at 8:53pm
This is truely not the topic. I am logged in as the forum administrator and have all the rights needed for the rest of the forum. But still I can't get into the admin section. No login required as I am already logged in..
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 21 February 2006 at 11:55am
In version 7.97 for extra protection against the latest hacking wave the login system for the admin section is completely different to the main forum.

The admin section now requires the admin to re-login to the admin section, which now uses a more secure ASP session variable to keep the admin logged in throughout the admin section.

If for some reason your browser or server is dropping the ASP session you will get issues logging into the admin section.

Please see my other posts in this Topic for suggestions if you are having issues logging into the admin section.

If the servers app pool is continually recycling like your host have said then it sounds like there is an issue with the server and it sounds like the server either has a bug that needs addressing, or the app pools have been setup incorrectly.

Until this issue is resolved with your host server you will not be able to use software, such as web wiz forums that requires ASP sessions and application level variables.

If the app pool is continually recycling then things like Active Users, Performance enhancements, logging into the admin area, uploading files and images, and lots of other features will not work or fail to work correctly.


Edited by -boRg- - 21 February 2006 at 12:11pm
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jpwalters View Drop Down
Newbie
Newbie
Avatar

Joined: 05 February 2006
Location: United States
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jpwalters Quote  Post ReplyReply Direct Link To This Post Posted: 23 February 2006 at 6:54pm
Hi Borg,
 
1.   There is a hardware firewall, however, the ip addresses we are testing from, are allowed open access (all ports).
 
2.  No script blocking. 
   
3.  The only software programs running other than iis and sql would be veritas netbackup and mcaffee virusscan.
 
Would it be possible to download v7.96 and to try that?
 
Thanks,
Jason Walters
 
 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 24 February 2006 at 9:02am
McAffee often courses issues, try disabling it see if it clears up the issue.

Have you tested to see if your site can hold the ASP session?

One way to do this is to run Firefox and have a look at the stored cookie for your site, if the ASP session ID keeps changing it means that your site has issues holding the ASP session.

Also check that the application pool on the server is not set to be using a web garden and is not continually recycling.

You can check that the app pool is not continually recycling by looking in the Windows Task Manager for the Image Name w3wp.exe, if the process ID for these keeps changing then the app pool is recycling, which could mean either an app pool setup problem or a bigger issue on the server.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jpwalters View Drop Down
Newbie
Newbie
Avatar

Joined: 05 February 2006
Location: United States
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jpwalters Quote  Post ReplyReply Direct Link To This Post Posted: 24 February 2006 at 3:06pm
Originally posted by -boRg- -boRg- wrote:

McAffee often courses issues, try disabling it see if it clears up the issue.

Have you tested to see if your site can hold the ASP session?

One way to do this is to run Firefox and have a look at the stored cookie for your site, if the ASP session ID keeps changing it means that your site has issues holding the ASP session.

Also check that the application pool on the server is not set to be using a web garden and is not continually recycling.

You can check that the app pool is not continually recycling by looking in the Windows Task Manager for the Image Name w3wp.exe, if the process ID for these keeps changing then the app pool is recycling, which could mean either an app pool setup problem or a bigger issue on the server.
 
 
Thanks for the info...
 
1.  I added PID to the View in Task Manager and monitored the w3pwp.exe's.  I watched them for about 30 minutes.  The did not change at all.  Though the Mem Usage and CPU usage for those processes varied.
 
2.  Regarding the forum.  I did seem to get a little further this time, which is a good thing, but I still ultimately end up at the same place.  As you suggested I looked at the cookies from within FireFox, and here the ASP Session ID has not changed.
 
Cookie: ASPSESSIONIDSCCCDCDT
Content: PDNBEOIDKOIKALCNACFPAPKK
Went to Web Wiz Forums License Agreement
Cookie Session ID the same...
Came to Forum Administration Menu
Cookie Session ID the same...
Created a forum...
Cookie Session ID the same..
Changed Password
Cookie Session ID the same..
Clicked on Membership Admin from the Admin Menu
Cookie Session ID the same..
Then....I received the famous message
"Sorry, only members with sufficient permission can access this page."
Checked Cookie one last time and it was still:
 
Cookie: ASPSESSIONIDSCCCDCDT
Content: PDNBEOIDKOIKALCNACFPAPKK

So apparently, the session ID is not changing yet there is some other issue.
 
Thanks,
Jason

 
 
 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 24 February 2006 at 4:28pm
The only thing I can think then is a corrupted file of some kind.

Try reuploading all the original files again making sure they are all from the same version.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Webmaster MJF View Drop Down
Newbie
Newbie


Joined: 14 February 2006
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Webmaster MJF Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2006 at 8:01pm
I think I fount it!
The variable "strLoggedInUserCode" is not defined in the file admin/common.asp. When I defined it as the UID session it worked great!
Back to Top
oldgym View Drop Down
Groupie
Groupie


Joined: 19 February 2006
Status: Offline
Points: 43 		Post Options Post Options   Thanks (0) Thanks(0)   Quote oldgym Quote  Post ReplyReply Direct Link To This Post Posted: 04 March 2006 at 5:21am
Originally posted by Webmaster MJF Webmaster MJF wrote:

I think I fount it!
The variable "strLoggedInUserCode" is not defined in the file admin/common.asp. When I defined it as the UID session it worked great!
 
Webmaster MJF! what have you changed in the code to fix it??? i found the code but am not sure how to manipulate it.
 

'Read in users ID number from the cookie
strLoggedInUserCode = Trim(Mid(Session("UID"), 1, 44))

'If a cookie exsists on the users system then read in there username from the database
If strLoggedInUserCode <> "" Then
 
 'Make the usercode SQL safe
 strLoggedInUserCode = formatSQLInput(strLoggedInUserCode)
 
 'Initalise the strSQL variable with an SQL statement to query the database
 strSQL = "SELECT " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Username, " & strDbTable & "Author.Group_ID "
 strSQL = strSQL & "FROM " & strDbTable & "Author "
 strSQL = strSQL & "WHERE User_code = '" & strLoggedInUserCode & "';"
  
 
Anyone wanna help me out???
Back to Top
 Post Reply Post Reply Page  <123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.