Joe,

after a long pause I tried to upgrade my pgsql site from revision 3399 to 4864. Some notes and questions.

1. mojoportal-complete-vs2005.sln did not compile as \mojoPortal.Features.UI\Services\Metaweblog\Services\MojoDataService.cs uses constructions not supported by old .Net runtime. For now just commented out sorting of blog categories.

2. Setup page has thrown the following exception.

Running script mojoportal-core - 2.2.4.9 - 00:00:01.0469152
Npgsql.NpgsqlException: constraint "mp_bannedipaddresses_pkey" of relation "mp_bannedipaddresses" does not exist Severity: ERROR Code: 42704

Changing "mp_bannedipaddresses_pkey" to "pk_bannedipaddresses" in the script solved the problem, after that all the upgrade scripts passed.

3. Skins that I used disappeared from svn, so I needed to edit the database to set the skin and access admin menu.

4. As far as I can see in web.config, the solution is now targeted to .Net 3.5. What should I change to still target .Net 2.0 (for a while, before upgrade of my projects)?

Joe, nice to hear you too!

1. While adjusting my skins, found out the following. I have one main site and 2 folder-based ones. If I have my custom skin for site 3 only in /Data/Sites/3/skins, it does not work, I needed also to copy it to /Data/Sites/1/skins to make it work. Is that a bug or feature?

2. I shall also move the project to 3.5, I suppose. Thanks for your help!

In the source it calls to csshandler.ashx in site 3 only.

Having the fact that it does not work without the skin in site 1, I used SysInternals Process Monitor when loading a page from site 3 after iisreset. Here is what I got:

219676 18:13:51,1977226 w3wp.exe 5900 QueryOpen F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles\sitesettingscachedependecy.config SUCCESS CreationTime: 12.03.2009 15:03:58, LastAccessTime: 12.03.2009 15:03:58, LastWriteTime: 12.03.2009 15:03:58, ChangeTime: 12.03.2009 15:03:58, AllocationSize: 0, EndOfFile: 0, FileAttributes: A
219677 18:13:51,1982575 w3wp.exe 5900 QueryOpen F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles\sitesettingscachedependecy.config SUCCESS CreationTime: 12.03.2009 15:03:58, LastAccessTime: 12.03.2009 15:03:58, LastWriteTime: 12.03.2009 15:03:58, ChangeTime: 12.03.2009 15:03:58, AllocationSize: 0, EndOfFile: 0, FileAttributes: A
219678 18:13:51,1985657 w3wp.exe 5900 QueryOpen F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles SUCCESS CreationTime: 12.03.2009 14:58:32, LastAccessTime: 12.03.2009 18:13:48, LastWriteTime: 12.03.2009 15:14:15, ChangeTime: 12.03.2009 15:14:15, AllocationSize: 0, EndOfFile: 0, FileAttributes: D
219679 18:13:51,1988889 w3wp.exe 5900 CreateFile F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles SUCCESS Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Synchronous IO Non-Alert, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, OpenResult: Opened
219680 18:13:51,1989251 w3wp.exe 5900 QueryDirectory F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles\sitesettingscachedependecy.config SUCCESS Filter: sitesettingscachedependecy.config, 1: sitesettingscachedependecy.config
219681 18:13:51,1989688 w3wp.exe 5900 CloseFile F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles SUCCESS
219683 18:13:51,1992920 w3wp.exe 5900 CreateFile F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles\sitesettingscachedependecy.config SUCCESS Desired Access: Read Control, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, OpenResult: Opened
219684 18:13:51,1993280 w3wp.exe 5900 QuerySecurityFile F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles\sitesettingscachedependecy.config BUFFER OVERFLOW Information: Owner, Group, DACL
219685 18:13:51,1993442 w3wp.exe 5900 CloseFile F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles\sitesettingscachedependecy.config SUCCESS
219687 18:13:51,1996637 w3wp.exe 5900 CreateFile F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles\sitesettingscachedependecy.config SUCCESS Desired Access: Read Control, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, OpenResult: Opened
219688 18:13:51,1996926 w3wp.exe 5900 QuerySecurityFile F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles\sitesettingscachedependecy.config SUCCESS Information: Owner, Group, DACL
219689 18:13:51,1997077 w3wp.exe 5900 CloseFile F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles\sitesettingscachedependecy.config SUCCESS
219691 18:13:51,2000960 w3wp.exe 5900 CreateFile F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles SUCCESS Desired Access: Read Data/List Directory, Read Attributes, Synchronize, Disposition: Open, Options: , Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, OpenResult: Opened
219692 18:13:51,2003839 w3wp.exe 5900 CreateFile F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles IS DIRECTORY Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Synchronous IO Non-Alert, Non-Directory File, Complete If Oplocked, Attributes: n/a, ShareMode: Read, AllocationSize: n/a
219693 18:13:51,2004368 w3wp.exe 5900 NotifyChangeDirectory F:\Billing\mojoPortal SVN\Web\Data\Sites\1\systemfiles Filter: FILE_NOTIFY_CHANGE_FILE_NAME, FILE_NOTIFY_CHANGE_DIR_NAME, FILE_NOTIFY_CHANGE_SIZE, FILE_NOTIFY_CHANGE_LAST_WRITE, FILE_NOTIFY_CHANGE_CREATION, FILE_NOTIFY_CHANGE_SECURITY
219700 18:13:51,4523798 w3wp.exe 5900 QueryOpen F:\Billing\mojoPortal SVN\Web\Data\Sites\1\skins\starlink-manager-jsavard-subblue\style.config PATH NOT FOUND
 

So it calls to 2 files in site 1, including one from the skin!

Joe,

I nearly found out what is going on. When requesting /csshandler.ashx, at first CacheHelper.GetSiteSettingsFromContext() is called by UrlRewriter, and only then by CSSHandler, so CSSHandler just uses (already invalid!) SiteSettings object from HttpContext.

As far as I understood, csshandler.ashx is caled from ~/Data folder, so in case of folder-based sites it is considered to be called for the root site.

Any ideas how to solve this?

Joe,

this will not help.

Even if UrlRewriter will do nothing, CSSHandler will request CacheHelper.GetCurrentSiteSettings() which will do the same thing: call CacheHelper.GetSiteSettingsFromContext() which will call CacheHelper.GetSiteSettingsFromCache() which will not recognize folder-based site as the request is made to ~/Data/.

Joe,

no, this problem is under IIS.

May be, I was too short in the problem description, let me describe it in a more detailed way.

Actually, there are 2 independent problems.

1. The first one is with UrlRewriter. Actually it must not do anything for requests into /Data folder, but it does. The solution you suggest is for this problem, but I suggest to replace the criteria with || (app.Request.Path.StartsWith("/Data/", StringComparison.InvariantCultureIgnoreCase)).

2. The second one is with CSSHandler, but actually with CacheHelper.GetSiteSettingsFromCache(). When request is to the /Data/ subfolder, it does not recognize folder-based subsites, thinking it's always the root site.

This problem actually does not depend on the first one: now SiteSettings are requested from CacheHelper.GetSiteSettingsFromCache() and stored in HttpContext by UrlRewriter, but if it doesn't CSSHandler will do absolutely the same.

As far as I can see, there are 2 possible solutions for the second problem: either correct CacheHelper.GetSiteSettingsFromCache() so that it can recognize the site in this case as well or modify CSSHandler so that it does not use SiteSettings. I suggest the last variant - SiteSetting are really not required there, path to the skin can be got from the request path.