BannedIP CallDescription: Reads the ClientIP and checks against the IgnoreIPs table. Not sure what this is used for..SQLCommand To Run:
- Select IgnoreIP from dbo.IgnoreIPs where IgnoreIP = @ClientIP
@ClientIP:
This IP is banned:
False
Successfully Checked Blocked IP
ParseURLDescription: Reads the URL and parses it into the different data elements.Full URL: 404;https://devsite.usf.edu:443/test-jessieg/ui-component-library/images/green-gradient.jpgProtocol: https://Domain: devsite.usf.edu CleanQueryStr: devsite.usf.eduCleanQueryStrVDFullTail: Actual URL Entered by User: https://devsite.usf.edu/test-jessieg/ui-component-library/images/green-gradient.jpg Not :80 (http) IIS 404 Error Path (:443): /test-jessieg/ui-component-library/images/green-gradient.jpgIIS 404 URL Start Position: 27 No QueryString Parameter FoundFind Campus from URLSQL Command To Run: SELECT TOP(1) Name FROM dbo.Campus WHERE @Path LIKE '%' + Path + '%' AND IsActive=1 ORDER BY DispOrder@Path: https://devsite.usf.edu/test-jessieg/ui-component-library/images/green-gradient.jpgCampus: Tampa Folder Count: 4First Folder: test-jessiegCleanQueryStr Value: https://devsite.usf.edu/test-jessieg/ui-component-library/images/green-gradient.jpgCleanQueryStrFullTail Value: /test-jessieg/ui-component-library/images/green-gradient.jpg
VariablesGenericURL: /system-error/error.aspxCampus: TampaProto: https://PassThru: False
CheckforBadSyntax CallDescription: Takes the QueryString and identifies if any of the blackList strings are found. If so, the user is auto-redirected to the Generic 404 Page.What is being checked:/test-jessieg/ui-component-library/images/green-gradient.jpg
QueryStrFix Scrub:No Bad Syntax Found
CheckIgnoreURL CallDescription: Checks the URL against the IgnoreURL table, if a match is found the user will be directed straight to the 404 Page Not Found page and the URL will not be logged in ErrorPageLog.SQLCommand To Run:
- SELECT IgnoreURL FROM dbo.IgnoreURLs WHERE Campus = @Campus and '/' + IgnoreURL = @URL
@Campus:
@URL:
- /test-jessieg/ui-component-library/images/green-gradient.jpg
URL is not ignored
RedirectGoLive Call -- File Level RedirectsDescription: Check the File Redirects table for a matching file; if one exists return the redirect URL.URL Full VD Tail: /test-jessieg/ui-component-library/images/green-gradient.jpgURL Full: https://devsite.usf.edu/test-jessieg/ui-component-library/images/green-gradient.jpgURL Full Minus Protocol: devsite.usf.edu/test-jessieg/ui-component-library/images/green-gradient.jpgSQLCommand To Run:
- SELECT FilePath,RedirectURL FROM dbo.FileRedirect WHERE Campus= @Campus and FilePath=@filepath and (ExpDate is null or ExpDate > CAST(FLOOR(CAST(GETDATE() as float)) as datetime))
@Campus:
@filepath:
- /test-jessieg/ui-component-library/images/green-gradient.jpg
No FilePath Match
No real URL in DB for FileRedirect.
DBSearchVD Call for TampaDescription: Takes the search string, compares it to the URLNinja DB and returns the RedirectURL field. Also takes into consideration if the Expiration Date has arrived.Checking Folder: 1 -- test-jessiegSQLCommand To Run:
- SELECT RedirectURL,PassThru,FolderPath FROM dbo.FolderRedirect WHERE FolderPath = @BadVDName and Campus=@Campus and (ExpDate is null or ExpDate > CAST(FLOOR(CAST(GETDATE() as float)) as datetime))
@Campus:
@BadVDName:
No Match
No real URL in DB.
DBReturnURLPath was empty... moving on!
Check for Multi Folder RedirectDescription: Check number of / in the URL, loop through each folder starting from last to check if the path exists.Full Path: test-jessieg/ui-component-library/images/green-gradient.jpgThe path contains 3 /s
File Found in FoldersSkip because it is a file (green-gradient.jpg)
DBSearchVD Call for TampaDescription: Takes the search string, compares it to the URLNinja DB and returns the RedirectURL field. Also takes into consideration if the Expiration Date has arrived.Checking Folder: 3 -- test-jessieg/ui-component-library/imagesSQLCommand To Run:
- SELECT RedirectURL,PassThru,FolderPath FROM dbo.FolderRedirect WHERE FolderPath = @BadVDName and Campus=@Campus and (ExpDate is null or ExpDate > CAST(FLOOR(CAST(GETDATE() as float)) as datetime))
@Campus:
@BadVDName:
- test-jessieg/ui-component-library/images
No Match
No real URL in DB.
DBSearchVD Call for TampaDescription: Takes the search string, compares it to the URLNinja DB and returns the RedirectURL field. Also takes into consideration if the Expiration Date has arrived.Checking Folder: 2 -- test-jessieg/ui-component-librarySQLCommand To Run:
- SELECT RedirectURL,PassThru,FolderPath FROM dbo.FolderRedirect WHERE FolderPath = @BadVDName and Campus=@Campus and (ExpDate is null or ExpDate > CAST(FLOOR(CAST(GETDATE() as float)) as datetime))
@Campus:
@BadVDName:
- test-jessieg/ui-component-library
No Match
No real URL in DB.
DBWriteBadURL Function CallDescription: Writes valid 404 Errors to the URLNinja DB.SQLCommand To Run:
- INSERT INTO dbo.ErrorPageLog (BadAddr, ClientIP, EntryDateTime, Campus) VALUES (@BadAddr, @ClientIP, GETDATE(), @Campus)
@BadAddr:
- https://devsite.usf.edu/test-jessieg/ui-component-library/images/green-gradient.jpg
@ClientIP:
@Campus:
Successfully Inserted URL into the ErrorPageLog DB
Status of 404 Write: Success
RedirectURLPath CallDescription: Determine if the Redirect URL is Null or has a real URLNull URL
GoURL CallDescription: Redirects the end user to the URL provided.Final redirect path: /system-error/error.aspxWould have done:
- Response.Status = 'File Not Found'
- Response.AddHeader('Location', /system-error/error.aspx)
- Response.Flush()
Function Returned - Real URL