February 2019 – 无限可能

XOX 之精打细算

网上拉杂大充值比直接与XOX交易还要便宜。只是拉杂大充值可以获得延长活跃期。每充值马币1元就获延长一天。如果充值50元就有50天存活期。因为马币25元可以延长365天，所以50天存活期等值马币3.42元。任何加值马币50元没有便宜过这个价值的就不划算。

如这个，加值30元只需28.50，换言之加值50元需要47.50，只省了2.50，没有达到3.42元，所以不值得。

如果是买入通话时间，计算如下。通过XOX买的话每333分钟得付马币30元。

以上面这开价，每300分钟要马币18，或每333分钟马币19.98。相对于XOX的便宜了整10元2分。

不仅如此，如果买入500分钟马币26.88的话，换算333分钟只要马币17.90，足足便宜了12.10。

如果买的是流量，XOX 10GB卖马币50大元。

这里7GB只需马币20元，相等于10GB马币28.57元，相对于XOX便宜了21.43元。

由于很少用到短信，这里就不赘述了。结论是，

纯粹加值的话，直接与XOX交易

买通话时间及流量的话，网上买

1882 home restaurant

早上跑步后决定换个地方早餐。

选了这家庭式面店。

麻辣板面，里头没有四川的花椒。

够辣，而且好吃。

沙爹专卖店

这间沙爹电非常出名。位置就在捷运站旁。捷运未建成生意都已经如日中天，建成后更是红红火火。

上下2层都有人客

内里景观

后面还有座椅

人流多了，顺便做起周边生意。

修改Google cloud文件权限

处理谷歌云上的文件会碰到伺服器不让修改文件的问题。要解决这问题有几个步骤要做。

第一是从谷歌云平台(google cloud platform)里找要修改文件的电脑。在哪里由SSH进入谷歌云电脑。

打入以下指令检查原文件权限。

stat -c “%a %n” /文件路径

下一行指令会显示原文件权限。接着就键入以下以修改文件权限。

sudo chmod 777 /文件路径

777是文件所有权限都放行。电脑接下来没显示任何回应。可以再键入
stat -c “%a %n” /文件路径来重查文件权限。没意外的话文件权限已经修改。下一步重启Apache服务器。如果是bitnami配套的话，指令如下。

sudo /opt/bitnami/ctlscript.sh restart apache

这时候重写服务文件已经无障碍。

Hosting WordPress on google cloud

There are few steps involved in the hosting of wordpress on google cloud.

Create an instance with WordPress installed
Point domain to google cloud server
Upload files to google cloud
Upload and replace existing MySql file in phpMyAdmin

1.Create an instance with WordPress installed

This is relatively straight forward. First create an account with google cloud. Once completed, there are 2 ways to create the server, or so call instance. We can create an empty instance and install WordPress later. However, the much simpler way would be to create an instance with WordPress installed. To do this, inside google cloud, click the hamburger icon, look for deployment manager. From there look for WordPress installation. There are few WordPress version to choose from. The decision would be on the price and the associate installation packages.

Once decided the installation package, we need to specify the CPU, memory, disk size, network etc. The whole installation would take about few minutes to complete.

At the end of the installation, there would be information about the instance, e.g., ip address, username, password etc.

2. Point domain to google cloud server

There are two ways to do this. For the first method, it involves two servers, namely google and domain name provider server. First go to the google console, inside API and services, look for google cloud DNS API and enable it. Then return to the console, under network services/cloud DNS, start to create zone. Fill in A record and CNAME once the zone created.

The subsequent steps would be done on the domain name provider server.
Copy the name servers provided in google DNS zone and fill inside domain name provider server.

For the second method, nothing needed to be done on the google console and no need to enable google cloud DNS API. The domain name could be propagated to google cloud server from domain name provider directly. For this method, use default name server provided by the domain name provider, then start to add record in DNS management page.

3. Upload files to google cloud

To upload the file we need a ftp client. Here we use Fileziella. As there is no username and password provided to connect to google cloud server, we have to create one using PuTTY Key Generator.

Inside Putty Key Generator, click Generate. Copy the public key and save the private key. Inside Google cloud platform, find the project/instance, metadata/SSH keys. Click edit and paste the public key into the box provided and save.

Open Fileziella and fill in 1, 2, 3. Fill the server IP address in 1. For 2, this is key comment from PuTTY Key Generator. For 3, browse and load the saved private key. Click connect and start to upload files.

4. Upload and replace existing MySql file in phpMyAdmin

As it is difficult to create a new database with database name, username, password, it is better to import own database content to the existing database via phpMyadmin. However there is a catch here. The server phpMyAdmin won’t allow direct remote connection. phpMyAdmin must be opened from the local host, i.e., 127.0.0.1.

To do this, we need to create a SSH tunnel between remote computer and the server. Here we use PuTTY .

Fill in the server IP in 1.
Browse and load private key generated from PuTTY Key Generator in 2.
Enter 8888 for source port and localhost:80 for destination. If http is redirected to https, use 443 for destination port.
Enter key comment from PuTTY Key Generator in Auto-login username.
Go back to session and click open. This will create a secure tunnel between source 8888 and destination 80 ports.
Open a browser, enter http://127.0.0.1:8888/phpmyadmin
In the phpMyAdmin interface, use root for username and password from google instance[ Admin password (Temporary)] for password.
Inside phpMyAdmin, look for the database. For bitnami installation, the database name looks like “bitnami_wordpress”
Select bitnami_wordpress, drop existing data and import own data to this database.
Under database prefix_options, change the site url and home as needed.
Last, search for wp-config.php inside the server. Change the database table prefix as necessary.

By now the website should be live.

安装谷歌商店

荣耀V9（本地叫荣耀8 pro）虽然没问题，但是老婆的电话电池开始不给力，时不时提早收工，也是时候换个电话了。

可这荣耀V9重置后就失去谷歌商店了。几个星期前为了修理也重置，费了好大功夫也把商店安上了。可这次花了好长一段时间，上网找了好些资料。本来以为荣耀去掉了谷歌框架服务或阻止安装谷歌相关服务，冤枉花了6小时。答案其实很简单，荣耀其实一早运行了谷歌框架服务，而且是最新版的。框架服务及谷歌商店如果不是最新的是没办法安装的。既然谷歌框架服务已经运行了，只要下载安装最新的谷歌商店安装就行了。

谷歌安装器建议的各类apk。