When trying to load data from database that is in AlwaysOn High Availability Group from Microsoft Excel the following error occurs:
Access to the remote server is denied because the current security context is not trusted Continue reading
May 22 2019
MSSQL Error – Access to the remote server is denied because the current security context is not trusted
May 22 2019
SQL Error – The database owner SID recorded in the master database differs from the database owner SID
When trying to execute Stored Procedures on a particular Database we got the following error:
The server principal “domain\user” is not able to access the database “dbXYZ” under the current security context.
The database owner SID recorded in the master database differs from the database owner SID recorded in database ‘dbXYZ’. You should correct this situation by resetting the owner of database ‘dbXYZ’ using the ALTER AUTHORIZATION statement. Continue reading
May 08 2019
odbc_log: Unable to retrieve database handle. CDR failed.
I correctly configured ODBC connection on Asterisk server to MSSQL database in Always On cluster.
The working configuration was as follows: Continue reading
Apr 30 2019
How to correctly stop/reboot Skype for Business server
Skype for Business like any other service needs periodic maintenance and that’s when you need to know how to gracefully stop Skype for Business service without losing a quorum.
Before stopping Skype for Business service make sure you will have more than 50% of front end servers running. Continue reading
Apr 24 2019
How to find all files containing specific text in Linux
Finding files containing text string in Linux is the easy task with the grep utility. grep also allows you to find files with specific text by searching directories recursively by defining -r key. Here are a few examples:
Apr 17 2019
Asterisk crashes on res_odbc.so load
While loading res_odbc.so Asterisk crashes with “invalid pointer” error like in the backtrace below:
Loading res_odbc.so. Continue reading
Apr 03 2019
How to reset MySQL/MariaDB root password
Start session ssh (using root if possible).
Edit my.cnf file using.
sudo vi /etc/my.cnf
Add line to [mysqld] block: Continue reading
Mar 30 2019
Parse JSON in Asterisk: how to install res_json
If you need to talk to external API and parse JSON in Asterisk dialplan you will need res_json installed. Unfortunately it’s not bundled in Asterisk installation yet but here is how you can install res_json in Asterisk: Continue reading
Mar 30 2019
Calculate Difference between two Time Values in Asterisk Dialplan
For calculating the difference between two times in Asterisk dialplan, the time values should be converted to an epoch value first. This can be done using the asterisk function STRFTIME. Use the below dialplan to convert current time to an epoch value
Set(time=${STRFTIME(${EPOCH},,%s)}) Continue reading
Mar 21 2019
New encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
During the step of database creation in Odoo database manager the following database creation error occurs:
New encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
