Tunnel Connection Error with Mysql Workbench (Host key does not match)

The issue seems to be related to SSH caching or missing algorithm on the system

In my case, here is how i solved it:

Rename the mysql workbench roaming folder
Reinstall workbench

Launch workbench

Move the content of your renamed folder into the new folder. Yes you can overwrite the new content.

ssh_exchange_identification: read: Connection reset by peer

ssh_exchange_identification: read: Connection reset by peer

I kept getting this error when i tried scp from a remote server to a local server.

Solution in my case

The remove server had the ALL: ALL in the hosts.deny file.
change it to  ALL : youclientIP to fix this.

Pulse Secure Setup Wizard ended prematurely

If Juniper pulse secure will not install on your computer in my case windows 10, chances are you are running into a driver issue.
Here is how to solve it:

First Step

Open CMD as an administrator and run the following:

pnputil -e > pnplist.txt
this command enumerates the driver packages that are currently in the driver store

Second Step

then open the txt file and locate anything that says Juniter in the “Publisher name” and run the following command:

pnputil -d "Publisher name" 

in my case

pnputil -d oem8.inf

Third Step

Reinstall Juniper pulse secure

About pnputil

Flexview: Could not read ini file: consumer.ini

You are getting this error most likely because there is something wrong in your INI file.

Open consumer.ini and you have a password for example, that has alphanumeric characters make sure that you surround it with double quotes.

As a matter of fact do this for everything that has a alphanumeric characters.

Display MySQL Configuration File

Sometimes you open up my.cnf and it is all empty and you are wondering about the remaining config options.

mysqld --verbose --help

Dollar Sign In Excel Cell’s name

The Dollar ($) in Excel formula indicates absolute reference. What does that mean?

It means that the value that immediately succeeds the dollar sign will not change.

In Excel a single cell can be used in 4 different ways:

Let’s take cell B4 as an example:

you can have:


No $ sign this one is relative. It will change if a column/formula that references this column is copied to a different cell.


If a cell references this column, the "B" will never change bit the "4" will change. Only the "B" is Frozen


If a cell references this column, The "B" will change but the 4 is frozen. So if you use this in a formula, the 4 is absolute.


If a cell references this column, it will NOT change if that cell is copied to a different cell. The whole cell is frozen.

Useful Links:

VMWARE : Could not open the client device. Check that the device exists…

check that the device exists

If you get this error “VMWARE : Could not open the client device. Check that the device exists and that it is not being used by another program” while trying to connect vsphere client to a CD-ROM try the following:

Run vsphere client as an administrator. Right click on the VSphere client icon and select "Run as Administrator"

That did it for me on Windows 10, hopefully this post will help someone out there.

Using Git on Windows


Download git for Windows here : https://git-for-windows.github.io/


Change your "Start in" folder accordingly
set up git for windows

Third (optional)

Do this step only if you want to change default home that git for windows pulls from your system.

Add a windows environment for HOME and point it to the location of your new home folder.

Problem resolving .local domains from Linux

If you are having the following issue :

ping IP -> Success
ping NETBIOS -> Success
nslookup xyz.local -> Success
ping xyz.local  -> FAILURE

The solution is to edit /etc/nsswitch.conf and remove the text “[NOTFOUND=return]”

More on that here:
Avahi and dot-local addresses on Ubuntu

What is the location of Microsoft Windows’ Logon Scripts

Startup folder for a user is :

C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup

Startup folder for every user

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup

Stop mysqld_safe Safely

After running “mysqld_safe –skip-grant-tables”  you may notice that the process is still running.
Instead of killing the process by running: kill -9 process ID
you can safely kill mysqld_safe by running the following command:

mysqladmin shutdown

Prevent iTunes from Launching When i Plug my iPhone

If you are annoyed by the fact that iTunes keeps starts everytime you plug in your iPhone then you are not alone.

Just turn that option off:

  1. Go to preferences



     2. Check OFF  “Prevent iPods, iPhones and iPads from synching…”



Delete all Emails in an Account from the Command Line Linux

Option 1


Option 2

cat /dev/null > /var/mail/root

Install TomCat on Ubuntu


Download Tomcat


Extract it to folder on your Ubuntu server


Set Up your environment variables (important)
open /etc/environment
copy and paste the following: (Make sure you use the proper paths for your system)
for example, in my system it looks like this: 


"source /etc/environment" 
to make the system recognize the newly added paths



change the permissions of the ".sh" inside the  apache-tomcat-8.0.33/bin directory
chmod +x *.sh


start tomcat by running

Nodejs from Node.js v0.12.7 To Version 4.0

Why the discrepancy in the version numbers?

Once upon a time there was just node.js then some people were unhappy with the speed of releases of node.js so they created io.js.

A few months later io.js converges back with Node.js 0.12.x into a unified Node.js 4.0.

Hence version Node.js 4.0 is born.

4.0 is the new 1.0
4.0 is the new 1.0 – https://medium.com/node-js-javascript/4-0-is-the-new-1-0-386597a3436d

Delete WordPress posts from the database

First run some selects statement before you start deleting

SELECT * FROM wp_posts where post_status like '%XXXXXXXX%'
SELECT * FROM wp_postmeta
	SELECT * FROM wp_posts
	WHERE wp_postmeta.post_id = wp_posts.ID

Run the actual delete (Always do a backup first)

delete * from wp_posts post_status like '%XXXXXXXX%'

-- Delete orphan records from the wp_postmeta table
delete * FROM wp_postmeta
	SELECT * FROM wp_posts
	WHERE wp_postmeta.post_id = wp_posts.ID

Turn off console-kit-daemon Centos / Ubuntu / RedHat


cd /usr/share/dbus-1/system-services/
mv org.freedesktop.ConsoleKit.service  org.freedesktop.ConsoleKit.service.old

make[1]: *** [wav2swf] Error 1 while installing swtools

Run make clean
apt-get install bison
apt-get install flex
make install

Install zlib ubuntu

app-get install zlib1g-dev

undefined symbol: php_json_decode_ex in Unknown on line 0 – Solr.so in Ubuntu

Make you sure that this line comes before your newly added extension in php.ini


then add your extension


The order matters