Ronson Chan - Ronson's Blog (Page 2)

Drop Databse <Database Name>; mariaDB

Was trying to remove seafile from a server and drop the databases in mariaDB. Unfortunately, all the documentation says the syntax is: DROP DATABASE DATABASE_NAME; This doesn't work. You need a '`' around the database name to work. DROP DATABASE `DATABASE_NAME`;

zjstar

Zjstar ZJ3T Shuttlecock - Speed 77

Basic Info: * Official Info: Zjstar [http://www.zjstar.cn/product-149.html] * Available for Sale from various retailers on TaoBao [www.taobao.com] * Purchased from JJ Sports in Markham [http://www.jjsports.ca/co] for $21 * Goose Feather * Price: ~58 RMB or $10 CAD from Taobao + Shipping * All shuttles were purchased

Wenjie

Wenjie No. 105 Shuttlecock - Speed 77

Basic Info: * Official Info: Anhui Wenjie Sporting Goods Co., Ltd [http://www.wenjiesport.com/products1.asp?id=136] * Available for Sale from various retailers on TaoBao [www.taobao.com]: Purchased one tube from 钻级卖家 [https://item.taobao.com/item.htm?id=23648324207&_u=22qd5q8s3a2d] * Duck Feather * Price: ~58 RMB

lucksix

Lucksix Gold (金诺) Shuttlecock - Speed 76

Basic Info: * Official Info: Anhui Hengda Sports Goods Co., Ltd [http://www.ah-hengda.com/En/Product_list.asp?classid=4&id=203] * Available for Sale from various retailers on TaoBao [www.taobao.com]: Purchased one tube from 皇冠卖家 [https://world.taobao.com/item/521822237047.htm?fromSite=main&_u=

Hero Shuttlecock

Hero No. 9 Shuttlecock - Speed 77

Basic Info: * Official Info: HERO Shuttles International Company Inc. [http://www.heroshuttles.com/] * Available for Sale from: * Le Coin Badminton, QC,Canada [https://lecoinbadminton.com/hero-no-9] * Directly from the manufacturer (via contact form on website) * Tube says Goose Feather but emails with the company tell me they're duck

lucksix

Lucksix Blue (蓝诺) Shuttlecock - Speed 77

Basic Info: * Official Info: Anhui Hengda Sports Goods Co., Ltd [http://www.ah-hengda.com/En/Product_list.asp?classid=4&id=200] * Available for Sale from: * Le Coin Badminton, QC,Canada [https://lecoinbadminton.com/volants-lucksix] * Various Retailers on TaoBao [www.taobao.com]: Purchased one tube from 华人体育运动商城 [https://world.

Excel

Excel - Document not saved.

Occasionally, you'll be working on an Excel document and when you try to save it, it says "Document not saved." [1] To get around this problem quickly, you can 1. Select all your worksheets (Click the first sheet + SHIFT + Click the last sheet) 2. Right click

Installing munin-node for Windows

Useful Links * Official Documentation: http://munin-monitoring.org/wiki/HowToMonitorWindows * Actual useful documentation [http://d.hatena.ne.jp/mazda77/20120831/1347067257&prev=search] * Official Download Link [https://github.com/munin-monitoring/munin-node-win32] Instructions 1. Download and install munin-node-win32 from github a. You may want to choose a fork [https://github.com/

FreedomPop Global SIM - Free Data

Summary Get a cheap ~$15 SIM card that gives you free 500MB/month forever that you can use around the world! Details Recently took a cruise in Scandinavia and roaming on a Canadian Carrier's plan [https://www.roammobility.com/compare] didn't seem like a good deal.

Excel

Filter out an Item from a Pivot Table using VBA with an OLAP Data Source

The following VBA code does not work as expected: PivotField.HiddenItemsList Property (Excel) [https://msdn.microsoft.com/en-us/library/office/ff195478.aspx] Sub UseHiddenItemsList() ActiveSheet.PivotTables(1).PivotFields(1).HiddenItemsList = _ Array("[Product].[All Products].[Food]", _ "[Product].[All Products].[Drink]") End Sub To properly use this you

nginx

TTRSS Migration to New Server

1. Prepare the old Server 2. Stop the update service e.g. service ttrss stop 3. Export the DB, assuming you're using Postgresql: sudo -u postgres pg_dump ttrss > dbdump 4. Prepare new server[1] a. Install PHP: apt-get install php5 php5-fpm php5-curl php5-pgsql php5-gd php5-mcrypt php5-cli

xiaomi

Xiaomi Yi Action Camera - Lens Focus Fix

1. Original instructions here: http://fpvlab.com/forums/showthread.php?40059-Fixing-Xiaomi-Yi-Out-of-Focus-Problem&p=785731#post785731 [http://fpvlab.com/forums/showthread.php?40059-Fixing-Xiaomi-Yi-Out-of-Focus-Problem&p=785731#post785731] 2. Instead of only using a knife to remove the hot glue, I highly recommend using Rubbing Alcohol (Isopropyl Alcohol) http://lifehacker.com/5676237/

Debian

Seafile Pro 5.0.3 + Debian Jessie Clean Install

Running the Seafile install script will pretty much wipe your server. If you have anything useful on it, back it up somewhere else! Before you run the script, change the hostname to whatever you plan to use first. https://wiki.debian.org/HowTo/ChangeHostname 1. As per http://manual.seafile.

nginx

Pydio 6 Enterprise + Nginx + letsencrypt

1. Install nginx mainline a. http://nginx.org/en/linux_packages.html 2. Sign up for Pydio 6 Enterprise: https://pydio.com/en/get-pydio 3. Add Pydio 6 enterprise repositories: https://pydio.com/en/node/1045 4. Install one more item (or 2 if using sqlite) apt-get install php5-ioncube-loader apt-get

Guacamole

Upgrading Guacamole 0.9.4 to 0.9.7

This guide was translated and summarized (stolen) from:Ubuntu 14.04.x LTS - Guacamole HTML5 Remotedesktop Gateway installieren mit Apache Reverse Proxy [http://znil.net/index.php?title=Ubuntu_14.04.x_LTS_-_Guacamole_HTML5_Remotedesktop_Gateway_installieren_mit_Apache_Reverse_Proxy#Upgrade_von_0.9.6_auf_

American Express

$200 Travel Credit + FHR Benefits

Two great benefits of Amex Platinum is their annual $200 travel credit and access to FHR. How We Made Use of Both Over the Long Weekend We were looking for a hotel in Montreal, and not knowing it was Osheaga [http://http://www.osheaga.com/], hotels were expensive. We decided

Building a Golf Swing with Monte Schienblum

Starting Point Holding the Golf Club Setup and Posture How to Set Up Your Swing Keeping your Hands Infront of You Part 1/2 Shoulder and Golf Plane What your Shoulder Turn Should Feel Like Too Much Shoulder Turn More Info: http://www.golfwrx.com/89009/what-is-a-full-turn/ More on Shoulder

Concierge Battle - Amex Platinum vs. MasterCard World

Request: Find modes of transportation from Hilton Marina Ft. Lauderdale to Sawgrass Mills Mall#### Amex Platinum number called: 1-800-263-1616 MasterCard World Concierge number called: 1-888-531-4227 Amex Platinum Conceirge The first person I talked to (male) was not helpful at all. I made my request and he told me that the

Track your Miles and Points with AwardWallet

Review: http://travelcodex.com/2014/01/using-awardwallet-track-miles-points/ AwardWallet: https://awardwallet.com/ Use my link to register if you'd like: http://AwardWallet.com/?refCode=fpybtkfjot More Info: AwardWallet keeps track of your reward programs such as your frequent flyer miles, hotel and credit card points. Currently we are tracking

Get 1,000 free Hilton Honor points for Changing your Password

http://loyaltylobby.com/2015/03/13/update-hilton-hhonors-dropping-pins-1000-points-for-updating-password-march-12-24-2015-new-dates/ Today, to ensure maximum security, Hilton announced that the login process for all Hilton HHonors members is being updated. PIN numbers will no longer be accepted and members will have until March 25, 2015, to create a new password or update their existing

Credit Score

Get your Credit Score for free until March 31, 2015

http://canadiankilometers.boardingarea.com/2015/02/23/free-credit-score-canada-process/ Quote: Home Depot/Equifax Free Credit Score Canada Last year, Home Depot Canada suffered a data breach of their credit card information. As a result, they are offering customers access to their credit score as well as free credit monitoring with Equifax.

American Express

American Express Offers

Full disclosure: If you sign up using the link provided, I will get a $150 referral bonus in points Summary: 1. Sign up for Amex Gold to get $250 to spend on travel (Spend $500 on it within 3 months) 2. Refer yourself to Amex Platinum to get $600 in

nginx

Setting up wallabag + MySQL + nginx

Open source Pocket replacement https://www.wallabag.org/ 1. Follow most of the instructions here: Install Wallabag on Ubuntu 12.04 LTS VPS [https://www.rosehosting.com/blog/install-wallabag-on-ubuntu-12-04-lts-vps/] a. MySQL apt-get install mysql-server mysql-client b. nginx mainline [http://nginx.org/en/linux_packages.html]: grab the key, modify /etc/

nginx

Setting up Guacamole 0.9.4 on Debian Wheezy

Needed a way to access Remote Desktop and other remote servers from behind a firewall. Windows RD Gateway doesn't work behind a nginx server (or I wasn't able to figure it out), so needed an alternative. Found Guacamole! [http://guac-dev.org/] 1. Install Debian Wheezy 2.

nginx

Setting up morss (Full Text RSS Expander) on Debian Wheezy

1. Install Debian Wheezy 2. Install git apt-get install git 3. Install dependencies Python: apt-get install python-pip python-dev build-essential libxml2-dev libxslt-dev python-dev 4. Install the morss requirements: pip install -r requirements.txt Or install the Python packages individually: a. lxml [http://lxml.de/installation.html#installation]: pip install lxml b.