zc0000

About offsetParent ....

2012-10-31T17:30:00Z

Assume we have a "div" in body: if the div 's position is absolute / relative / static , its offsetParent is body; if its position is fixed , then its offsetParent is null !

IIS fastCgi applications settings on monitorChangesTo , phprc

2012-09-16T14:25:00Z

PHPRC variable just denotes location of php.ini ; as in fastCgi/application section, you can't rely on PHPRC to be the default folder of all path settings ;

eg : if PHPRC = D:\phpCustom , then monitorChangesTo="php.ini" won't monitor "D:\phpCustom\php.ini" , actually just assigning "php.ini" is like assigning a relative path; in such case there is a conclusion:

If a relative file path is specified instead of an absolute path then FastCGI will assume that it is relative to the location of php-cgi.exe file.

So the best way is assigning absolute path as monitorChangesTo="D:\phpCustom\php.ini"

Important php.ini settings under IIS-fastCgi

2012-09-16T03:25:00Z

user_ini.filename = ".user.ini"
user_ini.cache_ttl = 1
extension_dir = "ext"
fastcgi.impersonate = 1
date.timezone = Asia/Shanghai
zend_extension = ext\php_xdebug-2.2.0-5.4-vc9-nts.dll

NOTE: Use 64bit editor ( Notepad2 x64 ) to change 64bit asp.net application's "applicationHost.config" !!

2012-09-15T18:13:00Z

1. If current windows OS is 64bit ( win7 x64 or windows server 2008 ) , then 32bit editors ( notepad++ , visual studio ) can't actually change C:\Windows\System32\inetsrv\Config\applicationHost.config ; changing this file is actually changing C:\Windows\SystemWOW64\inetsrv\Config\applicationHost.config, which is configured for 32bit asp.net applications on 64bit OS platform ! 2. So, to serve 64bit asp.net application we need access real "C:\Windows\System32\inetsrv\Config\applicationHost.config" , then we need a 64bit editor. "Notepad2 x64" is an ideal choice.

Again: how to configure XDebug

2012-06-03T06:00:00Z

1. download from xdebug.org ( use the 32bit ntf version , eg : php_xdebug-2.2.0-5.4-vc9-nts.dll ) 2. put dll in "ext" folder 3. add the extension config to php.ini : ;[zend_extension] zend_extension = ext\php_xdebug-2.2.0-5.4-vc9-nts.dll 4. NOTE: to enable site debuggable , should switch on the setting for target site ( could put in separate "user.ini" files ) xdebug.remote_enable = On

Configure Eclipse PDT / XDebug for PHP debugging

2012-04-08T08:33:00Z

Eclipse PDT settings

A suggestion: don't set "workspace" location the same as real project files reside. Seperate "Eclipse projects files" with actual source files.

Take PHP 5.4 custom installation as an example. The executable should be properly configured in Preference tab.

Then configure proper base site url, especially it is not "localhost". As in this sample the launched site is "http://phplab/".

Configure general debug settings ( assign XDebug as debugger ):

As per web app project, should set proper base url. If directly launching web app from "http://phplab/" , the base path should be set with "/".

Important XDebug settings under PHP engine

1. Download proper XDebug dll, set it as Zend extension in root php.ini:

zend_extension = ext\php_xdebug-2.2.0RC1-5.4-vc9-nts.dll

Note zend extension doesn't rely on "extension_dir" so here should explicitly assign the relative directory part "ext", otherwise PHP can't position the dll path.

2. Must set xdebug.remote_enable = On ( in root level or per site level ( user.ini ) ) ! Otherwise when starting "remote launch" ( this is essential for web server debugging ) , the PDT status always stays here and can't get further response:

Debugging needs switching to "Debug" perspective; otherwise stays in "PHP" perspective for maintaining project or handling sources.

About DNN ajax

2012-03-31T10:24:00Z

DNN uses iframe to mock ajax effect.

Eg: installation progress notification div.

<form name="TheForm" method="post" target="" action="http://localhost/DotNetNuke_Community/Install/InstallWizard.aspx?__U=1333186680507"><input type="hidden" name="ctx" value="2"><input type="hidden" name="__DNNCAPISCI" value="__Page"><input type="hidden" name="__DNNCAPISCP" value="06.00.01"></form>"

set fastCgi with appcmd

2012-03-29T03:40:00Z

The official FastCgi section says:

You can configure the <fastCgi> element at the server level in the ApplicationHost.config file or at the site level, at the application level, or at the directory level in a Web.config file.

However this is not by default, since applicationHost.config has pre-defined:

        <sectionGroup name="system.webServer">
           ...
            <section name="fastCgi" allowDefinition="AppHostOnly" overrideModeDefault="Deny" />
		   ...
		</sectionGroup>

Thereby if type this command:

appcmd set config mainsite /section:fastCgi /+"[fullPath='d:\php\php-cgi.exe',arguments='-d open_basedir="d:\mainsite"']"

It just throw such error:

ERROR ( message:New application object missing required attributes. This configuration section cannot be used at this path. This happens when the section is locked at a parent level. Locking is either by default (overrideModeDefault="Deny"), or set explicitly by a location tag with overrideMode="Deny" or the legacy allowOverride="false".. )

NOTE: the parameter should be quoted if contains any space!! That means , you can't even type as :

C:\Windows\System32\inetsrv>appcmd set config mainsite /section:fastCgi /+[fullPath='d:\php\php-cgi.exe', activityTimeout='500']

beause a space is padded in between "..-cgi.exe'," and "activityTimeout". Typing as this causes such error:

Failed to process input: The parameter 'activityTimeout='500']' must begin with a / or - (HRESULT=80070057).

Nonsense.

Active Directory Configuration Issues ...

2011-05-09T06:50:00Z

1. Configure a "Active Directory Domain Controller" on server A

2. Set Server B's domain to the domain configured in server A , say, "sample.com"

In step 2 we may get some exceptions as :

The following error occurred when DNS was queried for the service location (SRV) resource record used to locate an Active Directory Domain Controller (AD DC) for domain "xxx.com":

The error was: "DNS name does not exist."

(error code 0x0000232B RCODE_NAME_ERROR)

The query was for the SRV record for _ldap._tcp.dc._msdcs.xxxx.com

Common causes of this error include the following:

- The DNS SRV records required to locate a AD DC for the domain are not registered in DNS. These records are registered with a DNS server automatically when a AD DC is added to a domain. They are updated by the AD DC at set intervals. This computer is configured to use DNS servers with the following IP addresses:

xx.xx.xx.xx

- One or more of the following zones do not include delegation to its child zone:

xxx.com

com

. (the root zone)
The following error occurred attempting to join the domain "bamv2":

An attempt to resolve the DNS name of a domain controller in the domain being joined has failed. Please verify this client is configured to reach a DNS server that can resolve DNS names in the target domain. For information about network troubleshooting, see Windows Help.

This is possibly caused by wrongly setting the DNS server IP on the client which is intented to join the target domain.

Open Network and Sharing Center -> Local Area Connection Properties Dialogbox -> IPV4 Properties dialog -> Use the folowing DNS IP Address -> Set "Preferred DNS Server" to the target AD server ip address

A client problem, not server's : A network-related or instance-specific error occurred while establishing a connection to SQL Server...

2011-04-30T17:59:00Z

I don't know, when and why, I cannot connect remote SQL server from my win7 & winserver2008 (64bit) machines. When trying to connect a server by typing IP ( xx.xx.xx.xx ) in the server name in "Management studio->Connect Server" dialog box, I always get:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

or ( If typing "xx.xx.xx.xx,yyyy" - assigning port )

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - TCP Provider: ) (Microsoft SQL Server, Error: -1)

Well , after cautious checking I am sure it is not caused by wrong server configuration, since I even tested onnection from another XP3 32bit computer and it's OK, implying problem lies in my win7 client.

It's really very,very weird ------ no detailed information for the error even seeking event viewer. Eventually & luckily I approach to get around it : just connect local server by type IP format server name: "127.0.0.1" ------ it is like some internal mechanism that "IP" server is triggered ; once IP is triggered locally, it could be applied on remote connection. After connecting "127.0.0.1" I could get my remote server connected.

Does anyone know why thing goes as this ?

How to circumvent "Cannot obtain value of local or argument as it is not available at this instruction pointer, possibly because it has been optimized away

2011-02-26T09:28:00Z

Sometimes when debugging code we can't "watch" variable's value and only get this alerting message:

Cannot obtain value of local or argument as it is not available at this instruction pointer, possibly because it has been optimized away

As this has been discussed in How to disable optimizations when debugging Reference Source. According to his second suggesion, I just leave a checkbox blank:

Then rebuild the project. Then in your main project which references the "originally optimized" project , you could see the variables are accessible now.

Base class' constructor takes effect even not explicitly called.

2010-04-07T06:28:00Z

I almost have no impression at all on a heavily important c# grammar issue......

Originally I thought base class' constructor doesn't participate in any of derived class' constructional logic unless explicitly called for serving , just like :

 
public Manager(int initialdata) : base()
{
    //Add further instructions here. 
}

In this manner the default constructor is to be called undoubtedly. However in my bad conception I think code like this:

 
public Manager(int initialdata)
{
    //Add further instructions here. 
}

doesn't call the base class' default constructor because there is no explicit code ":base()" coming after main class name "Manager" so the base default constructor has no impact here.

However I am wrong. The two pieces above are semantically identical. Official tutorial tells me:

In a derived class, if a base-class constructor is not called explicitly using the base keyword, then the default constructor, if there is one, is called implicitly.

Here is official link stating this case:

Using Constructors (C# Programming Guide)

asp.net Auto-generated SQLEXPRESS database: Failed to generate a user instance of SQL Server ( troubleshooting 1 )

2010-04-04T20:03:00Z

If you adopt .net Login controls to handle user authentication tasks and simply rely on default connection settings which generates SQLEXPRESS-based database in APP_Data folder , especially under the windows 7 or windows server 2008 system, you are likely to suffer several exceptions caused by similar reasons. One is like:

Server Error in '/SamplesApp' Application.

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

To thoroughly I log some repro steps.

I create a new application pool "SamplesAppPool" to host "SamplesApp".

The "SamplesAppPool" 's identity is assigned using the win7/winserver 2008 r2-recommended feature: "ApplicationPoolIdentity" , leaving "Load User Profile" as false currenctly.

Such setting is meant to create a special account with the same name as target pool to run W3WP.exe. For better security issue we no longer resort to Network Service. This is an improved model induced into new generation of windows OS.

However if we use default asp.net connection string settings to initialize a build-in asp.net security database ( assuming SQLEXPRESS instance installed ) , which means the conn string is like :

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

'"User Instance=true" means that SQLEXPRESS service needs a User Profile envrionment to perform some initialization works. Since the aspnet worker process is run in "SamplesAppPool" account, there should be a special user profile folder caring this account. However , since we previously set "Not load user profile", system doesn't at all create such a profile , thus no corresponding user profile folder created:

From Control Panel\System and Security\System\Advanced system settings panel we can get user profiles information

As you can see , the required "SamplesAppPool" profile is not maintained here.

Accordingly , "SamplesAppPool" profile folder does not exist in Users folder:

To get around the exception , "Load User Profile" needs setting as "true"

Once above settings changed , such profile is created in system immediately:

So far , the SQLEXPRESS-related information has not been established in the profile folder yet. We need trigger something to make account-specified sqlexpress folder constructed automatically. That is : do what I mentioned at the top. If you simply click "create user" button in a CreateUserWizard control without any custom connection settings in web.config , you may find App_Data/aspnetdb.mdf is successfully created. In addition , exploring "SamplesAppPool" profile folder will supply such a view:

To change application pool identity to build-in account such as "Network Service" without taking care of "Local User Profile"settings can solve the issue as well , because these build-in account auto-position to current logon user profile folder as is ensured by default and erect SQLExpress folder ( eg. if I logon as "zc0000" the folder is located at : C:\Users\zc0000\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS ). Nevertheless, this is no longer suggestive in new generation of windows OS ( window 7 , windows server 2008 r2 or latter ) . I think since Network Service has undertaken more and more tasks in the whole system, Microsoft designs such a new mechanism to help the powerful giant out of heavy load thus to have asp.net applications be more concentrative and secure.

Official knowledge base link concerning this issue:

Problems with SQL Server Express user instancing and ASP.net Web Application Projects

SQL SERVER 2008 Database Diagram: "Saving changes is not permitted"

2010-04-04T18:59:00Z

When making some datatable changes in db diagram environment, a popup window might show up with this message:

Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created./p>

meanwhile saving progress stops.

It is because that SSMS by default prevents some operations that requires target tables to be recreated. To go over this block, the highlighted item in Options window needs unchecking.

For more details refer the official knowledge base link:

Error message when you try to save a table in SQL Server 2008: "Saving changes is not permitted"

Database operations through SQL: Database Restore ...

2010-03-29T13:50:00Z

If using sql to perform a database restoring , care the sql-codes very well. Any trivial mistake may prevent a successful execution. Cases are listed here based on simple experiments.

with operation: MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name'

If logical file name not correctly set , following error is obtained:

Logical file 'FILE_NAME' is not part of database 'DATABASE_NAME'. Use RESTORE FILELISTONLY to list the logical file names.

RESTORE DATABASE is terminating abnormally.

To be continue...