Asterisk Phone Inventory / Useragent List

Asterisk PBXI need to find out whether all Cisco phones in organization use the latest firmware. As SPA series phones show firmware version in “Useragent” string it would be great to display all useragents in Asterisk. In order to get this string from all Asterisk peers we need to go through each peer and display the property we are interested in. Here is the useragents.sh Bash script: Continue reading

How to Install and Configure GitLab on CentOS 7

gitlabGitlab is an open source, powerful, robust, scalable, secure, as well as efficient software development and collaboration platform for all stages of the DevOps lifecycle.

It allows you to plan your development process; code, and verify; package software, and release it with an in-built continuous delivery feature; automate configurations management, and monitor software performance.
It has features such as an issue tracker, moving of issues between projects, time tracking, very powerful branching tools, file locking, merge requests, custom notifications, project roadmaps, burndown charts for project and group milestones, and so much more.

Gitlab is one of the best alternatives to Github, that is now owned by Microsoft, for hosting your open source projects.
Here is what you need to do in order to install Gitlab on CentOS: Continue reading

ASP.NET Error Validation of viewstate MAC failed

Validation-of-viewstate-MAC-failedIn some environments the following error may occur for ASP.NET:
Validation of viewstate MAC failed.
If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm.
AutoGenerate cannot be used in a cluster.

There are a few reasons of this error and you can solve it by adding MachineKey to the Web.config file of your application. To do this follow the steps: Continue reading

Windows Task Scheduler Fails With Error Code 2147943785

In Windows Task Scheduler in tasks’ history you can see that it fails with error code 2147943785. This error code indicates permission issue with the account under which the task is run.

Check that the user that is running the scheduled task has Log On As Batch Job assignment. Open Start Menu > Administrative Tools > Local Security Policy > Local Policies > User Rights Assignment > Log On As Batch Job as seen below:

2147943785-Task-Scheduler-Permissions-Log-On-as-batch-job

SfB Server 2015: Event 57005 Could not find stored procedure ‘XdsQueryCriticalDocumentSignatures’

skype-for-businessAfter applying cumulative update on Skype for Business I noticed the following errors in Event Log:Event-ID-57005-Could-not-find-stored-procedure-XdsQueryCriticalDocumentSignatures
Log Name: Lync Server
Source: LS User Store Sync Agent
Date: 04/23/2018 11:33:23
Event ID: 57005
Task Category: (1061)
Level: Error
Keywords: Classic
User: N/A
Computer: sfbfe01.contoso.com
Description:
Error encountered pushing data to RtcXds Blob Store Continue reading

Set owner failed for Database ‘rtcxds’

skype-for-businessInstallation of Skype for Business database update failed with error “Set owner failed for Database ‘rtcxds’.”

Command used to update Skype for Business database:

The update script needs SQL user “sa” to be on place so make sure it was not renamed or deleted. In my case it was renamed so I renamed it back to “sa” and update script succeded.

How To Create SSL Certificate for Apache on CentOS 7

Apache HTTP ServerAn SSL certificate is an electronic ‘document’ that is used to bind together a public security key and a website’s identity information (such as name, location, etc.) by means of a digital signature. The ‘document’ is issued by a certificate provider such as GlobalSign, Verisign, GoDaddy, Comodo, Thawte, and others.

In this article I will show how to generate self-signed certificate for Apache on CentOS. Please note that self-signed certificate does encrypt communication between your server and any clients. However, because it is not signed by any of the trusted certificate authorities included with web browsers, it’s not trusted by browsers by default and can’t be used to verify the identity of your server.

Continue reading

Redirect HTTP to HTTPS in Apache

Apache HTTP ServerLet’s say you want all traffic to your website use secured connection. You can redirect HTTP to HTTPS in Apache like following:

Using virtual hosts and Redirect directive

When using SSL, you will frequently have at least two virtual hosts: one on port 80 to serve ordinary requests, and one on port 443 to serve SSL. If you wish to redirect users from the non-secure site to the SSL site, you can use an ordinary Redirect directive inside the non-secure VirtualHost: Continue reading

SQL SSRS change certificate binding error

SSL-binding-already-exists
While deploying SQL Reporting Services I got the following error:
Create certificate binding.
We were unable to create the certificate binding.

Continue reading

A2billing Install Guide

a2billing-call-flow-inbounda2billing-callflow-outboundThis guide will show you how to install A2Billing v2.2 on CentOS v7. It is assumed that you already have Asterisk and/or Freepbx installed (if not – install it first using this guide). It is also assumed that you have compiled Asterisk Realtime driver module (res_config_mysql) by selecting it in Asterisk Menuselect before compiling Asterisk. Continue reading

Load more