Archive for » September 3rd, 2009«

Coming soon….

I’ll post here soon…. :)
Thanks,
Arun

Category: Art, Indian Cuisines, Photography, Sports, Tamil Kavidhaigal  Comments off
Change terminal service/RDP port

To change Terminal Service/RDP port please follow these steps-

*****You are about to make changes in server’s registry so any incorrect changes will result in severe problem*****

1. Open registry editor by running this command in run – regedit
2. Locate for HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp
3. Locate the ‘PortNumber’ subkey and find the value of d3d (in hexadecimal), change the ‘Base’ radio button to ‘Decimal’ and modify the port no. from 3389 to new one.

Note: If your server is behind hardware/software firewall please make sure to add this port in allow list so that you can establish connection from outside.

Category: Windows 2003  Tags:  Leave a Comment
Remote IIS Management in Windows Server 2008

Remote IIS Management feature is available in DNP. Not many control panels have implemented this. Even it’s possible in IIS 6. Here’s the steps for IIS 7-

Note: Resellers should enable this feature in their client hosting plans.

1. Login to DNP,  click web > websites

2. Click your website you wish to enable for IIS Remote management tool.

3. Click the last tab “Management”

4. Create a Username and password, and then click ‘Enable’.

Note: when the page reloads, make sure it now shows that ‘Management’ is now enabled.

5. Using Windows Vista or Windows 7 or Windows 2008, Open IIS 7 by going to-

Control Panel > Administrative Tools > Internet Information Services

Note: You can install IIS if not installed from add/remove windows features from program & features.

6. Once IIS is loaded click ‘Connect to a site’ under IIS > Start Page > ‘Connection tasks’ section.

7. Specify the server name, for site name, enter your full domain name without www > Next > specify user name and password.

8. Here it will ask you to enter a friendly name, this is the name of the website on your local IIS machine > Click Finish.

Display detailed errors in IIS 7 – Windows 2008

In Windows server 2008, displaying detailed error is disabled by default. To enable this please follow this steps-

1. Open web.config file located under domain root (possibly under wwwroot if helm/DNP, httpdocs if plesk).
2. Look for the lines (esp at last)-
</handlers>
</system.webServer>
</configuration>

after  </handlers>  press enter and add the following line

<httpErrors errorMode=”Detailed”/>

After adding should look like-

</handlers>
<httpErrors errorMode=”Detailed”/>
</system.webServer>
</configuration>
Save the file and now you will be able to see the detailed error.

Install Ioncube loaders for php windows

To install Ioncube loaders for php windows please follow these steps-

# Download Ioncube loaders available at

http://downloads2.ioncube.com/loader_downloads/ioncube_loaders_win_x86.zip

http://downloads2.ioncube.com/loader_downloads/ioncube_loaders_win_x86_ipf.zip

# Place the dll files in C:\PHP5\Ioncube or C:\PHP\Ioncube (for php4) or to any location where php is installed
# Open php.ini under C:\PHP5 or C:\PHP and add the following entry after ‘;Windows Extensions’ section-

zend_extension_ts =”C:\PHP5\ioncube\ioncube_loader_win_5.x.dll” for php5
zend_extension_ts =”C:\PHP5\ioncube\ioncube_loader_win_4.x.dll” for php4

Prevent synattack in Windows server 2003

To prevent synattack in Windows server 2003 please follow this-

Save the following in synattackprotect.reg and double click it to merge-

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters]
“EnableTCPChimney”=dword:00000000
“SynAttackProtect”=dword:00000002
“TcpMaxHalfOpen”=dword:00000064
“TcpMaxHalfOpenRetried”=dword:00000050
“TcpMaxPortsExhausted”=dword:00000005
“TcpMaxConnectResponseRetransmissions”=dword:00000003

Php application popup in the server

To fix the application popup-

Warning : Unknown(): Unable to load dynamic library ‘C:\Program Files\SWsoft\Plesk\Additional\Php\extensions\php_curl.dll’ – The specified module could not be found

Make sure libeay32.dll and ssleay32.dll exist in the Windows system32 folder. These 2 files can be found in a folder called dll in the PHP folder.

Enable IIS HTTP conditional GET and HTTP compression

To enable HTTP compression and Conditional GET please follow these steps-

1. You need to open Metabase.xml from the location – C:\Windows\System32\inetsrv

******Please take much care in handling this since you are doing this in Metabase file. Any incorrect actions can lead to severe problems. Do it at your own risk******

**Before doing this please make sure your IIS Metabase is directly editable without stopping IIS. If this option is not enabled you can enable it in IIS > properties of server name > under ‘Internet Information Services’ tab > check ‘Enable Direct Metabase Edit’ check box > hit Ok. Otherwise you will have to stop IIS then open Metabase.xml to proceed further. Either things will work according to your convenience**

And look for the following parameters-

<IIsCompressionScheme Location =”/LM/W3SVC/Filters/Compression/deflate”
HcCompressionDll=”%windir%\system32\inetsrv\gzip.dll”
HcCreateFlags=”0″
HcDoDynamicCompression=”TRUE”
HcDoOnDemandCompression=”TRUE”
HcDoStaticCompression=”FALSE”
HcDynamicCompressionLevel=”0″
HcFileExtensions=”htm
html
txt”
HcOnDemandCompLevel=”10″
HcPriority=”1″
HcScriptFileExtensions=”asp
dll
exe”
>
</IIsCompressionScheme>
<IIsCompressionScheme Location =”/LM/W3SVC/Filters/Compression/gzip”
HcCompressionDll=”%windir%\system32\inetsrv\gzip.dll”
HcCreateFlags=”1″
HcDoDynamicCompression=”TRUE”
HcDoOnDemandCompression=”TRUE”
HcDoStaticCompression=”TRUE”
HcDynamicCompressionLevel=”0″
HcFileExtensions=”htm
html
txt”
HcOnDemandCompLevel=”10″
HcPriority=”1″
HcScriptFileExtensions=”asp
dll
exe”
>
</IIsCompressionScheme>
<IIsCompressionSchemes Location =”/LM/W3SVC/Filters/Compression/Parameters”
HcCacheControlHeader=”max-age=86400″
HcCompressionBufferSize=”8192″
HcCompressionDirectory=”%windir%\IIS Temporary Compressed Files”
HcDoDiskSpaceLimiting=”FALSE”
HcDoDynamicCompression=”FALSE”
HcDoOnDemandCompression=”TRUE”
HcDoStaticCompression=”FALSE”
HcExpiresHeader=”Wed, 01 Jan 1997 12:00:00 GMT”
HcFilesDeletedPerDiskFree=”256″
HcIoBufferSize=”8192″
HcMaxDiskSpaceUsage=”100000000″
HcMaxQueueLength=”1000″
HcMinFileSizeForComp=”1″
HcNoCompressionForHttp10=”TRUE”
HcNoCompressionForProxies=”TRUE”
HcNoCompressionForRange=”FALSE”
HcSendCacheHeaders=”FALSE”
>
</IIsCompressionSchemes>

Change the above to the following-

<IIsCompressionScheme Location =”/LM/W3SVC/Filters/Compression/deflate”
HcCompressionDll=”%windir%\system32\inetsrv\gzip.dll”
HcCreateFlags=”0″
HcDoDynamicCompression=”TRUE”
HcDoOnDemandCompression=”TRUE”
HcDoStaticCompression=”TRUE”
HcDynamicCompressionLevel=”10″
HcFileExtensions=”htm
xml
css
rdf
js
html
txt”
HcOnDemandCompLevel=”10″
HcPriority=”1″
HcScriptFileExtensions=”asp
php
cgi
dll
aspx
asmx
exe”
>
</IIsCompressionScheme>
<IIsCompressionScheme Location =”/LM/W3SVC/Filters/Compression/gzip”
HcCompressionDll=”%windir%\system32\inetsrv\gzip.dll”
HcCreateFlags=”1″
HcDoDynamicCompression=”TRUE”
HcDoOnDemandCompression=”TRUE”
HcDoStaticCompression=”TRUE”
HcDynamicCompressionLevel=”10″
HcFileExtensions=”htm
html
xml
css
rdf
js
txt”
HcOnDemandCompLevel=”10″
HcPriority=”1″
HcScriptFileExtensions=”asp
php
cgi
aspx
asmx
dll
exe”
>
</IIsCompressionScheme>
<IIsCompressionSchemes Location =”/LM/W3SVC/Filters/Compression/Parameters”
HcCacheControlHeader=”max-age=86400″
HcCompressionBufferSize=”8192″
HcCompressionDirectory=”%windir%\IIS Temporary Compressed Files”
HcDoDiskSpaceLimiting=”TRUE”
HcDoDynamicCompression=”FALSE”
HcDoOnDemandCompression=”TRUE”
HcDoStaticCompression=”FALSE”
HcExpiresHeader=”Wed, 01 Jan 1997 12:00:00 GMT”
HcFilesDeletedPerDiskFree=”256″
HcIoBufferSize=”8192″
HcMaxDiskSpaceUsage=”100000000″
HcMaxQueueLength=”1000″
HcMinFileSizeForComp=”1″
HcNoCompressionForHttp10=”FALSE”
HcNoCompressionForProxies=”FALSE”
HcNoCompressionForRange=”FALSE”
HcSendCacheHeaders=”FALSE”
>
</IIsCompressionSchemes>

Once the changes are done please save the metabase file.

2. Now goto command prompt and to the following location and type-

C:\Inetpub\AdminScripts>
adsutil set w3svc/filters/compression/parameters/HcDoSta
ticCompression false
HcDoStaticCompression : (BOOLEAN) False

C:\Inetpub\AdminScripts>adsutil set w3svc/filters/compression/parameters/HcDoDyn
amicCompression false
HcDoDynamicCompression : (BOOLEAN) False

C:\Inetpub\AdminScripts>adsutil set w3svc/1234/root/DoStaticCompression true
DoStaticCompression : (BOOLEAN) True

C:\Inetpub\AdminScripts>adsutil set w3svc/1234/root/DoDynamicCompression true
DoDynamicCompression : (BOOLEAN) True

Note: The value ’1234′ is website’s identifier. You can note this in IIS Manager > locate the website > note the identifier or you can find it in site’s logfile folder name for ex- w3svc1234

3. Finally restart IIS.

Coldfusion error: Hebrew characters failed to display properly – UTF8

Problem description-

Setup MySQL database and CF DSN but the Hebrew characters fail to display properly – UTF8.

Temporary work around-

Recreate the DSN and set the driver type from MySQL 3 to MySQL 4/5
Note: This solves only for characters already stored in the DB – if I update the text using coldfusion – then ? Marks appear instead

Permanent solution-

Please include this code in your script-

<cfscript>
setEncoding(“URL”, “UTF-8″);
setEncoding(“Form”, “UTF-8″);
</cfscript>

At the top of form loading script.

In CFAdmin, under the connection string field specify these piece of entry-

useUnicode=true&characterEncoding=UTF-8

Coldfusion – Can’t connect to Access db

Problem description-

When creating Datasource with MS Access or MS Access Unicode driver seleceted produces this error even though there is valid Access database file-

Connection verification failed for data source: DSN name
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.

Solution-

Chose “other” as the driver type and entered the following:

JDBC URL:
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=[Full path to your database file];DriverID22;

Driver Class:
sun.jdbc.odbc.JdbcOdbcDriver

Drive Name:
MS Access via JDBC

Diagnosing Windows server 2003 performance problems

Microsoft has released the Windows Server 2003 ‘Server Performance Advisor’ tool designed to help troubleshoot Windows 2003 performance problems. Neither Windows XP nor Windows 2000 platforms support this tool. The tool is available here: http://www.microsoft.com/downloads/details.aspx?familyid=61a41d78-e4aa-47b9-901b-cf85da075a73&displaylang=en

Once downloaded please run the msi file and follow the instructions and these steps-

1. Click Next to go to the “Welcome to the Server Performance Advisor Setup Wizard” introduction screen.
2. Click “I accept” on the license page, then click Next.
3. Accept the default installation location and select whether the tool will be used by just the person installing the tool or by all administrators, as the figure shows. Click Next.
4. The wizard prompts you for a location for the temporary storage of performance log files. Accept the default C:\perflogs\data location and click Next.
5. The wizard prompts you for a reports folder location. Again, accept the default location (C:\perfLogs) and click Next. Click Next to begin the installation. When the installation is finished, click Finish.
7. You’ll now have a new Start menu item, Server Performance Advisor, which you can use to start the advisor process.