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
C:\Users\ycsoftware\AppData\Roaming\MySQL\Workbench
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:

B4

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

$B4

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

B$4

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.

$B$4

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:
https://www.ablebits.com/office-addins-blog/2015/11/25/relative-absolute-reference-excel/


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

First

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

Second

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
https://andrewgdotcom.wordpress.com/2007/09/28/avahi-and-dot-local-addresses-on-ubuntu-gutsy/


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

itune_preferences

 

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

turnoff_synching

 


Delete all Emails in an Account from the Command Line Linux

Option 1

>/var/mail/root

Option 2

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

Install TomCat on Ubuntu

FIRST

Download Tomcat
https://tomcat.apache.org/download-70.cgi

SECOND

Extract it to folder on your Ubuntu server

THIRD

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: 

CATALINA_HOME=/YCSOFTWARE/servers/apache-tomcat-8.0.33
JRE_HOME=/usr/bin/java
JDK_HOME=/usr/lib/jvm/java-8-openjdk-amd64

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

YOU MUST HAVE JAVA INSTALLED.

FOURTH

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

FIFTH

start tomcat by running
./startup.sh
  or
$CATALINA_HOME/bin/startup.sh

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
WHERE NOT EXISTS (
	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
WHERE NOT EXISTS (
	SELECT * FROM wp_posts
	WHERE wp_postmeta.post_id = wp_posts.ID
);

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

console-kit-daemon

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
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

extension=json.so

then add your extension

extension=xyz.so

The order matters