Missing Windows Authentication Feature IIS and Windows 10

If you have windows 10 Home or SL version when might be you are unable to see Windows Authentication under IIS options when installing.

To enable “Windows Authentication” either you need to upgrade the OS to Pro version or you can run this command to enable it.

C:\WINDOWS\system32>dism /online /norestart /add-package:%SystemRoot%\servicing\Packages\Microsoft-Windows-IIS-WebServer-AddOn-2-Package~31bf3856ad364e35~amd64~~10.0.17134.1.mum

The file name will be different based on windows updates. So please update if requires.

How to Create Multiple SQL Server Instances on Same Server

When you install SQL Server, the installation creates an instance (DEFAULT OR SQLEXPRESS) of SQL Server. In my case I have created instanace named DEVSQL.

Some times we do need to create multiple instances based on requirements. To create more instances, start the setup again. The following screen appears when setup starts for the SQL Server 2012.

Click “New SQL Server stand-alone installation or add features to an existing installation”, the following screen appears:

Installation Start

As you can see DEVSQL instance already exists, it was created by the first installation, now select “New installation or add shared features”. Then click Next and accept the License Agreement.

Then select features you want to install for the new instance.

After that the installation offer you to specify the name of your new instance (MYTEST was chosen in this example):

Click Next to create the new instance and perform the remaining setup steps.

Now you are done!

 

How to install Koha – A Library Software on Ubuntu

Step 1:
Execute the script by giving the following command:

#!/bin/bash

#export HTTP_PROXY_HOST=10.3.100.207
#export HTTP_PROXY_PORT=8080

wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add –
echo deb http://debian.koha-community.org/koha stable main | sudo tee /etc/apt/sources.list.d/koha.list

sudo apt-get update
sudo apt-get install libgd-perl
sudo apt-get upgrade
sudo apt-get install koha-common

Koha installation gives error related with apache2-mpm-itk issue.
The initial configuration makes necessary enable / disable of the modules and does the initial configurations.

Step 2:
Execute the script by giving the following command:
############### Initial Configuration ####################

sudo a2dismod mpm_event
sudo a2enmod mpm_prefork
sudo service apache2 restart
sudo apt-get install -f

Step 3:
Koha Server configuration
In this step, we need to edit network information like domain name and port numbers.

sudo gedit /etc/koha/koha-sites.conf

Here we have to change port number of Koha staff client to 8080.
Find following line in the file and make changes.

INTRAPORT=”8080″

Step 4:
Adding ports

We have assigned 8080 port for Koha staff client and 80 for OPAC.
Open following file and add new port.

sudo gedit /etc/apache2/ports.conf

Copy paste following line below Listen 80

Listen 8080

Restart Apache,

sudo service apache2 restart

Step 5:
Apache module enable is done her executing the script

sudo a2enmod rewrite
sudo a2enmod cgi
sudo service apache2 restart

Step 6:
Install MySQL server and create the koha database. Here we have named the database as Koha2018.
Keep the default settings for MySQL server and when it asks for password give it as Koha2018. When the process asks to change the root password press ‘n’ then keep on pressing ‘enter’ for default values.

sudo apt-get install mysql-server
sudo koha-create –create-db Koha2018
sudo mysql_secure_installation

Step 7:
Most of the versions of Koha (3.x, 16.05 to 17.11) are not compatible with this default MYSQL configuration.
To bypasss the problem you can edit the configuration file (certainly /etc/mysql/my.cnf or /etc/mysql/mysql.conf.d/mysqld.cnf) and force the SQL modes Koha supports:

[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

After save the changes and restart mysql.

Step 8:
Finally enable the koha site by executing the script
sudo a2dissite 000-default
sudo a2enmod deflate
sudo a2ensite Koha2018
sudo service apache2 restart

Step 9:
KOHA Web Installation URL – Open the Koha staff using the link:
http://localhost:8080
This will show the login user name and the pass word

For credentials execute the script:

echo “Admin user name : koha_osslm”;
sudo xmlstarlet sel -t -v ‘yazgfs/config/pass’ /etc/koha/sites/Koha2018/koha-conf.xml
echo ” “;

Enjoy:
Browse to http://localhost:8080 – for admin login
Browse to http://localhost:80 – for OPAC login

SQL Server 2016 Always Encrypted Timeout at IIS

Always Encrypted is a feature designed by the Microsoft in SQL Server 2016 to protect sensitive data, such as credit card numbers or national identification numbers (SSN). It allows clients to encrypt sensitive data inside client applications.

When you work with Always Encrypted in development environment, it will be works fine because it requires certificate keys, which will be already installed on Dev machine. But when you moved to production environment it will not work. The Certificate needs to install on that server to run the web application. Without it encryption will not work. You will get database timed out error or encryption error while run the application.

For example:
Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

To resolve this error, you need to install the certificate on the server for specific user. After that you have to defined, selected user in application pool advanced properties. Which user you need to enabled the “Load user profile” property too under “Process Model”.

iis-load-user-profile

JSON date to Date object – javascript

While working with web services or API with json return, we will get date values in different format, we can’t use this as is where required.

To convert to date object we need to extract integer value and then pass to Date object, below example shows how to get valid date object.

[javascript]
var json = “/Date(-1827639000000)/”
var mytime = new Date(parseInt(json.replace(“/Date(“, “”).replace(“)/”,””), 10));
alert(mytime);
alert(mytime.toUTCString());

[/javascript]

Debugging VS2013/VS2015 Websites Using 64-bit IIS Express

If you are working on ASP.NET MVC web sites in Visual Studio 2013 (VS2013) or 2015 (VS2015), and want to debug 64bit application, you need to do following changes in Visual Studio.

f you don?t do this, you will likely get a message similar to:

?Could not load file or assembly or one of its dependencies. An attempt was made to load a program with an incorrect format.?

For Visual Studio 2013 and Visual Studio 2015:

Tools
  -> Options
   -> Projects and Solutions
    -> Web Projects
     -> Check "Use the 64 bit version of IIS Express for web sites and projects"`

How to enable HTTP Compression of Static and Dynamic Contents IIS

Enabling compression of static and dynamic contents of your website will be more help to load your website faster on browsers.

To enabling both you must have to install “Dynamic Compression” and “Static Compression” on the server features and roles.

Open server manager
Roles > Web Server (IIS)
Role Services (scroll down) > Add Role Services
Add desired role (Web Server > Performance > Dynamic Content Compression & Static Content Compression)
Next, Install, Wait for couple of seconds?Done!

To Enable it:
Open your web.config and add the following configuration in webServer tag.

<system.webServer>
<urlCompression doStaticCompression="true" doDynamicCompression="true" dynamicCompressionBeforeCache="true"/>
<httpCompression noCompressionForHttp10="false" noCompressionForProxies="false" dynamicCompressionDisableCpuUsage="93" dynamicCompressionEnableCpuUsage="93" staticCompressionDisableCpuUsage="99" staticCompressionEnableCpuUsage="99">
<scheme name="gzip" dll="%Windir%\System32\Inetsrv\gzip.dll" staticCompressionLevel="9" dynamicCompressionLevel="4" doDynamicCompression="true" doStaticCompression="true"/>
</httpCompression>
</system.webServer>

 

Only Office – Multifunctional service for business with low cost

Only Office is a great tool which can use by any small scale organization for Project management, online editors, documents management, emails and few more things. Like all the features are available in other products too like Google, Microsoft Office Online, Microsoft SharePoint. All these products stores data to their own cloud servers, they are some expensive for the start-ups or small companies, also their model based on subscription. We need to pay them monthly or yearly subscription.

Only office also host on their cloud machines but we can setup this on our machines too. ?A subscription model of this application also cost effective. Any small scale company can afford it. If they want to setup their own machine then it can also be possible.

If we have a small team and would like to share docs between them without worrying about versions, sharing permissions, we can do it easily with this tool. It also support web editors where anyone can open and edit documents without installing the required software?s on local machines. This will help to reduce resources as well.

Only office also easily integrated with existing applications using iframe without worrying and wasting lot of time. It has application programming interface (API) too, so programmers can easily integrate it. Programmers can easily create real time users, upload files, sharing permission to the file without going to portal.

Only office installation is also easy, it provides single click installation for beginners, setup will take case all the things, we need to provide public IP and credentials to start that.

Only office comes with two applications, first Community Server and second one is document server. Community server will take care of all the things like project management, users, sharing, emails, authentication and authorizations. Document server serve the documents online with the support of Iframe.

If anyone wants to use the application for editors only then he can setup document server ONLY. Both application needs to install on separate machines. They are internally responsible for data transfer.

See more about only office please click here?

IIS7/8 URL Rewrite ? rewriting non-www to www

In order to Redirect non-www to www on your website, manually edit the web.config file of site and add the following rewrite rule:

<rewrite>
<rules>
<rule name="Redirect example.com to www" patternSyntax="ECMAScript" stopProcessing="true">
<match url=".*" />
<conditions>
<add input="{HTTP_HOST}" pattern="^example.com$" />
</conditions>
<action type="Redirect" url="http://www.example.com/{R:0}" />
</rule>
</rules>
</rewrite>

Deploy ASP.NET MVC Site on IIS6 – Windows Server 2003

I built a new ASP.NET MVC 4 (.NET 4) web application, but client wanted it to be hosted on their older Windows Server 2003 running IIS 6. While hosting I got 403 error because IIS6 comes with .Net framework 2.0.

I have figured out what we need to do inorder to host the mvc site on IIS6. We do need all the appropriate MVC assemblies in the application bin folder, otherwise we will have to install mvc on server. But the server must have .net Framework 4.0.

Steps :

1. Install the .NET 4 Framework.

2. Make sure ASP.NET v4.0.30319 is ?Allowed? under Web Service Extensions in IIS ? it is ?Prohibited? by default.

3. IIS Website Configuration: Right click on your new website and select ?Properties?:

a. Under the ?Home Directory? tab, make sure that ?Execute permissions? is set to ?Scripts only? .
b. Under the ?ASP.NET? tab, make sure that the ASP.NET version is set to ?4.0.30319?.
c. Click on the ?Configuration? button in the ?Home Directory? tab and make sure that all the Application extensions are mapped to .NET 4 versions of the dlls.
d. Add a ?Wildcard application mapping? ? click on ?Insert? and enter ?C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll? as the ?Executable?. Leave ?Verify that file exists? unchecked.