Posts

[Bitnami] mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Got into this error while trying to run "mysql_upgrade" command

bitnami@server:~$ mysql_upgrade --force -uroot -p
Enter password:
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
Solution:

Just do a symbolic link for the mysql.sock file.

bitnami@server:~$ ln -s /opt/bitnami/mysql/tmp/mysql.sock /tmp/mysql.sock
Wahlah! Problem solved!

bitnami@vulcan-clients:/tmp$ mysql_upgrade --force -uroot -p
Enter password:
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid…

Visual Composer (version 4.4.1) fixes for Wordpress 4.7

Updated to Wordpress 4.7.2 recently and existing theme with old Visual Composer was broken.

Searched and tracked the error, and found the following scripts that solves the issues.

1. /wp-content/plugins/js_composer_theme/assets/js/backend/composer-view.js:99


2. /wp-content/plugins/js_composer_theme/assets/js/backend/composer-teaser.js:350

Test Pollen

Javascript for creating timeline

Image

Google does crawl and parse iFrame content

Image
I noticed that the number of 404s in my webmaster account starts to increase. I get "weird" links that I don't think should appear on my page, e.g. this:


A quick check shows that Google crawler picked up the URL from one of the Guardian iFrame:


I wonder whether any link juice is passed on to the URL, since its indexed by Google.

How to enable Facebook Comment reply function on Facebook Profile

Image
This is a guide on how to enable Facebook comment reply on your Facebook profile.

Summary of steps:
1. Open Chrome
2. Enable emulate geolocation coordinate.
3. Set geolocation to New Zealand ("-41.211111", and "174.781111").
4. Open touch.facebook.com
5. Select "Check in"
6. Open facebook.com
7. Comment reply should appear now!

Generate GoDaddy SSL Certificate (.crt) for Azure Websites (.pfx)

Image
Step 1: Getting GoDaddy SSL cert.
Let's say you have a domain name of my_domain.com. You'll first need to generate the the .csr file for GoDaddy with the following command:

openssl req -new -newkey rsa:2048 -nodes -keyout my_domain.com.key -out my_domain.com.csr


This gives you 2 files:
my_domain.com.key - This is the private key
my_domain.com.csr - This is the Certificate Signing Request


Copy the content of my_domain.com.csr file to the SSL signing authority (GoDaddy).



Once approved, GoDaddy give you back a .zip file with the following 2 files:

18f1c77f369c0b59.crt - This is your cert
gd_bundle-g2-g1.crt - This is the GoDaddy Certificate Chain


Step 2: Convert a CERT/PEM certificate to a PFX certificate
openssl pkcs12 -export -out my_domain.com.pfx -inkey my_domain.com.key -in 18f1c77f369c0b59.crt


Step 3: Certificate to Upload to Azure.


Step 4: Assign SSL Bindings.




Step 5: Done!


References:

http://azure.microsoft.com/en-us/documentation/articles/web-sites-configure-ssl-certificate…