Tuesday 7 October 2014

Removing Dynamic Members from queue (Asterisk)

Log in to asterisk CLI

asterisk -r

Use the following command to show the members in the queue.

queue show <queue name>

To remove a member listed in that queue

queue remove member <member name> from <queue name>

Hitting 'tab' after 'queue remove member' will list the members that are available.

Tuesday 30 September 2014

Shellshock Fix (RHEL 5 or CentOS 5)


Shellshock / Bashdoor is a group of security bugs which made the Unix Bash shell vulnerable to exploits. Servers running web services, ftp, etc which use bash to execute certain commands allowed attackers to execute arbitrary commands and may as a result allow them to gain unauthorized access.


Before you fix the vulnerability, you need to know whether the bug affects your version of bash.

CVE-2014-6271

This vulnerability can tested using the following command.
 
env x='() { :;}; echo vulnerable' bash -c "echo this is a test"
 
 
If your system is affected , the word "vulnerable" will be displayed as the part of the output.
 
 

CVE-2014-7169

This can be tested using the following command

cd /tmp; env X='() { (a)=>\' bash -c "echo date"; cat echo

If the above command outputs the current date, you will be vulnerable. If it shows the word "date", then you are fine.

 You can also test it with the following command.

env -i X=' () { }; echo hello' bash -c 'date'

If the commands gives an output "hello" you are vulnerable.



CVE-2014-7187

Test the vulnerability with the following command.

(for x in {1..200} ; do echo "for x$x in ; do :"; done; for x in {1..200} ; do echo done ; done) | bash || echo "CVE-2014-7187 vulnerable, word_lineno"

 If "CVE-2014-7187 vulnerable, word_lineno" comes as a part of  the output, then you are vulnerable.


CVE-2014-7186

Use the following command to test for the vulnerablity.

 bash -c 'true <<EOF <<EOF <<EOF <<EOF <<EOF <<EOF <<EOF <<EOF <<EOF <<EOF <<EOF <<EOF <<EOF <<EOF' || echo "CVE-2014-7186 vulnerable, redir_stack"

If you see " CVE-2014-7186 vulnerable, redir_stack" as a part of the output, then your system is vulnerable.


Fix


The only fix to the issue is to update your bash.

The current version can be known by using the command

bash --version


If you have CentOS-base.repo enabled, then, to update bash use the following command.

yum update bash





 
  

 



Saturday 30 August 2014

"The User Profile Service failed the logon” error message - Windows 7



1. Go to regedit


2. In Registry Editor,find and then click the registry sub key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList


3. Locate the folder that begins with S-1-5 (SID key) followed by a long number.


4. Click each S-1-5 folder, locate the ProfileImagePath entry in the details pane, and then double-click to make sure that this is the user account profile that has the error.


5. If there are two folders starting with S-1-5 followed by some long numbers and one of them ended with .bak, you have to rename the .bak folder. To do this, follow these steps:


   a.Right-click the folder without .bak, and then click Rename. Type .ba, and then press ENTER.


   b. Right-click the folder that is named .bak, and then click Rename. Remove .bak at the end of the folder name, and then press ENTER.



  c. Right-click the folder that is named .ba, and then click Rename. Change the .ba to .bak at the end of the folder name, and then press ENTER.



6. Double-click the folder without .bak in the details pane, double-click RefCount, type 0, and then click OK.


7. Click the folder without .bak, in the details pane, double-click State, type 0, and then click OK.


8. Close Registry Editor.


9. Restart the computer.


10. Log on again with your account.

/usr/bin/ld: cannot find -lmysqlclient - Compiling from source

While compiling an application from source, the following error was encountered.

/usr/bin/ld: cannot find -lc
Process exited with status 1.

The problem was that the MySQL client library files didn't have soft links created for 'libmysqlclient' to the /usr/lib directory

The default installation created 'libmysqlclient.so.16'.

So inorder for the compilation to work, a soft link for this was created using

ln -s /usr/lib/libmysqlclient.so.16 /usr/lib/libmysqlclient.so

Dialing extension on a remote Asterisk Server through IAX trunk

Open the config extensions_additional.conf

Go to the context of the concerned IVR.

add the Line

exten => _<Dial Pattern>,1,dial(iax2/<Trunk Name>/${EXTEN})

eg: exten => _5xxx,1,dial(iax2/OFFICE3/${EXTEN})
When this is done, a pattern with 5 followed by 3 digits ,ie, an extension will be forwarded to the remote asterisk server using IAX2 trunk

So that an extension of an elastix server can be dialled from a remote server.

Once the file is edited

Reload asterisk.


Wednesday 26 February 2014

Creating a new MySQL ODBC DSN and importing it in Microsoft Excel

1. Download the MySQL ODBC Connector Driver and Install it. 
 http://dev.mysql.com/downloads/connector/odbc
2. Go to Control Panel > Administrative Tools > Data Sources (ODBC)
3. Select User DSN. Click Add
4. Select the MySQL ODBC Driver. Click Finish
5. In the 'MySQL Connector/ODBC Data Source Configuration' dialog box, enter the following details.
•   Data Source Name
•   Description
•   TCP/IP Server
•   Port (Default 3306)
•   User 
•   Password
•   Database
6. Click Test. If connection is OK, "Connection Successful" Dialog Box Appears. Click OK

This creates a User MySQL ODBC DSN. 

Now we have to configure it in Microsoft Excel.

1. Open Microsoft Excel.
2. click Data Tab.
3. Click Connections
4. In the Workbook Connections Wizard, Click Add
5. Click 'Browse For More'.
6. In the dialog box, Click New Sources.
7. In the 'Data Connection Wizard',  Select ODBC DSN and Click Next
8. Select the DSN Created Earlier.
9. Click Next and then Finish.
10. Now in the 'Data' Tab of Excel,  Click Existing Connection.
11. Open the Database that we added.
12. In the import Wizard, Click OK.

The data from the DB will be imported in the Excel Sheet.

VM Not starting - "VM is in Use error" - VMWare



Not able to launch the VMware session after a PC crash.

The following error message was being displayed, “  Taking ownership of this virtual machine failed. The virtual machine is in use by an application on your host computer."


Solution:

Close the VMware Player. Open up the Explorer . Go to the location of the VMDK in your explorer. 
Delete all the*.LCK files. You might also need to delete directories that works as Locks (ends in LCK)



Now start the Virtual Machine.

Outlook Hyperlink problem - "This operation has been cancelled due to restrictions"

While opening a hyperlink present in an email in OUTLOOK, We might face the following error 

"This operation has been cancelled due to restrictions. Please contact your system administrator."
This happens because MS - OUTLOOK needs IE to be the default application to open the Hyperlinks.
The following can be done to solve this issue.

EDIT Registry
1. Start, click Run, type Regedit in the Open box, and then click OK.2. Browse to HKEY_CURRENT_USER\Software\Classes\.html3. Right click the value for the .html key and select Modify…4. Change the value from “ChromeHTML” to “htmlfile” (or from FireFoxHTML to htmlfile)5. Repeat for .htm, shtml, .xht, .xhtml, .xhtm keys6. Repeat these steps for htm and .shtml keys if they exist. You may also want to check the xhtml and xhtm keys. 



Reset Web Settings
1. Close Outlook2. Open Internet Explorer.3. On the Tools menu, click Internet Options.4. Click the Advanced tab, and then click the Reset button.5. On the Programs tab, under Internet programs, click Set Programs, then “Set your Default Programs”, select your OUTLOOK program and click “Set this program as Default”. Repeat for Internet Explorer.6. Click OK and close the dialogs.