I encountered an error while reconnecting to navision SQl client after reinstalling the database. It usually comes with this error The extended stored procedure xp_ndo_enumuserids in the library file xp_ndo.dll, is not available on the xxx server. This has to do with xp_ndo.dll Extended Stored Procedure missing in the SQL Database.

Copy xp_ndo.dll (for 32bit OS) or xp_ndo_x64.dll (for 64bit OS) from Navision installation CD D:\DVD_BUILD32012\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database to SQL Binn folder C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn.

Install xp_ndo_enumusergroups and xp_ndo_enumuserids as NAV SQL extended stored procedures using SQL Management Studio Query Tab.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

USE master 
EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\xp_ndo_x64.dll' 
GO

GRANT EXECUTE 
ON [xp_ndo_enumusergroups] 
TO PUBLIC 
GO

USE master 
EXEC  sp_addextendedproc xp_ndo_enumusersids, 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\xp_ndo_x64.dll' 
GO

GRANT EXECUTE 
ON [xp_ndo_enumusersids] 
TO PUBLIC 
GO

Amazon just announced the expansion encryption ciphers to enable perfect forward secrecy.

To enable this feature, login to your AWS console and navigate to the Load Balancers section.

Select the loadbalancer and navigate to the Listerners section.

Click on Change under the Cipher Tab

Select ELBSecurityPolicy-2014-01 from the Predefined Security Policies and Save the changes.

You can test the new changes on Qualys SSL Tab to be sure perfect forward secrecy is enabled.

Create your Disqus account

To add disqus comments to your octopress blog site. Visit Disqus to signup.

Remember to Verify your email address afterwards.

Create and Configure Disqus site

Login to your disqus account.
Create a New Site for comments.
Once done, go to your Settings tab.

http://shortname.disqus.com/admin/settings/general/.

Add your octopress site to the Website URL.

Click on the advanced tab, and add your octopress domain to the Trusted Domains.

Save the changes.

Add the Disqus ID to Octopress config file

Open the octopress config file and add your username to it.

1
2
3
4
5

:~$ cd octopress
:~$ vi _config.yml

disqus_short_name: my_disqus_userid # replace it with the userid (not email address) you created in disqus
disqus_show_comment_count: true

Save the changes and run rake generate and rake deploy and there you go to start commenting.

Working with Namshi has opened my mind to a wide of tools for effectiveness. Like always a quote “Graph everything”. Initially, we were using icinga-web for graphing but seems like graphite introduces something missing and better than other tools.

We started using collectd for graphing system metrics to graphite. Its amazingly easy to setup and configure. You can find the salt state for collectd here. Collectd sends metrics to graphite straight of the box which is beauitful. Our systems has multiple cores and really not intuitive to have cores being analyzed separately, its good for individual core analysis but with hyperthreading. Then I got to know of aggregation plugin and Postcache chain which does exatly what I want.

Postcache chain sends the cpu metric to aggregate and truncates the rest.

1
2
3
4
5
6
7
8
9
10
11

<Chain "PostCache">
  <Rule> 
    <Match regex>
      Plugin "^cpu$"
    </Match>
    <Target write>
      Plugin "aggregate"
    </Target>
    Target stop
  </Rule>
</Chain>

Configure the aggregation plugin for cpu to merge all of them and only output average and sum of the metric.

1
2
3
4
5
6
7
8
9
10
11
12

<Plugin "aggregation">
  <Aggregation>
    Plugin "cpu"
    Type "cpu"

    GroupBy "Host"
    GroupBy "TypeInstance"

    CalculateSum true
    CalculateAverage true
  </Aggregation>
</Plugin>

This is much more better to analysis and do prefer it to others.