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
3 comments
Read more

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
3 comments
Read more

Test Pollen

-
1 comment
Read more

Javascript for creating timeline

-
Image
#1 TimelineJS - http://timeline3.knightlab.com/ #2 InfostoryJS - https://github.com/athletics/infostory
Post a Comment
Read more

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.
Post a Comment
Read more

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!
Post a Comment
Read more

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.co
17 comments
Read more