Cannot load Counter Name data because an invalid index ” was read from the registry

Cannot load Counter Name data because an invalid index ” was read from the registry

When we are trying to read system performance counters, some time we will get this type of error on machines.

“Cannot load Counter Name data because an invalid index ” was read from the registry”

To fix the issue:

Click the START button
Type CMD
Right click CMD PROMPT and select “Run As Administrator”
Type LODCTR /r
Wait a few seconds, you will get “Error: Unable to rebuild performance counter setting from system backup store, error code is 2”

Now again Type LODCTR /r

This time it will run successfully with the message “Info: Successfully rebuilt performance counter setting from system backup store”

Close he CMD.
















Search in MSSQL tables

Sometime we need to reverse engineering in the database tables to find a specific values, we can find the column name easily but in large database, to search a specific key value is too hard. From below query we can easily search value in all tables, it will list column with table in the result.

DECLARE @SearchStr nvarchar(100) = 'test'
DECLARE @Results TABLE (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET  @TableName = ''
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

WHILE @TableName IS NOT NULL

BEGIN
    SET @ColumnName = ''
    SET @TableName = 
    (
        SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
        FROM     INFORMATION_SCHEMA.TABLES
        WHERE         TABLE_TYPE = 'BASE TABLE'
            AND    QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
            AND    OBJECTPROPERTY(
                    OBJECT_ID(
                        QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)
                         ), 'IsMSShipped'
                           ) = 0
    )

    WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)

    BEGIN
        SET @ColumnName =
        (
            SELECT MIN(QUOTENAME(COLUMN_NAME))
            FROM     INFORMATION_SCHEMA.COLUMNS
            WHERE         TABLE_SCHEMA    = PARSENAME(@TableName, 2)
                AND    TABLE_NAME    = PARSENAME(@TableName, 1)
                AND    DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar', 'int', 'decimal', 'numeric')
                AND    QUOTENAME(COLUMN_NAME) > @ColumnName
        )

        IF @ColumnName IS NOT NULL

        BEGIN
            INSERT INTO @Results
            EXEC
            (
                'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630) 
                FROM ' + @TableName + ' (NOLOCK) ' +
                ' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
            )
        END
    END    
END

SELECT distinct ColumnName, ColumnValue FROM @Results order by ColumnValue

Android Gmail App not find email addresses / contacts that emailed before?

Sometimes after installing the application on mobile devices,  due to permission popup and without reading the message users generally select Allow / deny.  This will cause that we are not able to select the email / or contacts while sending the email from the email app.  To resolve check the following things:

Went to Android Settings, Apps, Gmail. In the App Permissions section, Contacts disabled. Enabled it, closed everything.

And after  opened gmail, it was giving me suggestions of emails as I was typing.

 

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

Get last and current quarter in javascript

function getQuarter(id) {
var d = new Date();
var quarter = Math.floor((d.getMonth() / 3));

switch (id) {
case "Current":
var firstDate = new Date(d.getFullYear(), quarter * 3, 1);
var endDate = new Date(firstDate.getFullYear(), firstDate.getMonth() + 3, 0);
break;
case "Previous":
var firstDate = new Date(d.getFullYear(), quarter * 3 - 3, 1);
var endDate = new Date(firstDate.getFullYear(), firstDate.getMonth() + 3, 0);
break;
}
}

 

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]

How to fix the outlook issue when its prompting the password again and again

We are using Microsoft Outlook on our desktops or laptops to view emails offline. Some times on start the outlook it prompt us to provide valid password. After providing valid password it prompt again. This will be some irritating.

To fix this type of issue we do have 2 ways:

  • Remove the saved credentials of outlook from windows credentials manager, using these steps:
    • Click Start, click Control Panel, and then click Credential Manager.
    • Note If View by is set to Category, click User Accounts first, and then click Credential Manager.
    • Locate the set of credentials that has Outlook in the name.
    • Click the name to expand the set of credentials, and then click Remove from Vault.
    • Repeat step 3 for any additional sets of credentials that have the word Outlook in the name.
  • In outlook, go to ?Email Accounts -> More Settings? ?> ?Outgoing Server? ?> Check First checkbox and first radio button.

Only Office Error: Server connection lost. The document cannot be edited right now

After hosting of Only Office some time users can get the error “Server connection lost. The document cannot be edited right now“.? To resolve this error we can remove 2 values from the web.config key of the Document Server setup.

By default values:
<add key=”editor.settings.coauthoring.url” value=”/coauthoring” />
<add key=”editor.settings.spellchecker.url” value=”/spellchecker” />

Remove values like that:
<add key=”editor.settings.coauthoring.url” value=”” />
<add key=”editor.settings.spellchecker.url” value=”” />

and reset the IIS.

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>