Previously I wrote about configuring a Microtik for RDP. Well, that router died, so I’d to do it all over again. (Here are the Terminal commands, except I’ve changed my public IP address to x.x.x.x.):-

/ip firewall nat>> add chain=dstnat action=dst-nat to-addresses=192.168.1.243 to-ports=3389 protocol=tcp dst-address=x.x.x.x dst-port=3389 log=no log-prefix=""
/ip firewall nat>> add chain=srcnat action=src-nat to-addresses=192.168.1.254 to-ports=3389 protocol=tcp dst-address=192.168.1.243 dst-port=3389 log=no log-prefix=""

Microtik port forwarding

Spent too much time configuring port forwarding (RDP) on my (Microtik) RouterBoard 751G-2HnD. The solution, as usual, was buried in a May 2014 forum post. There needs to be TWO (2) NAT rules enabled; i.e. to forward traffic to/fro the router/server.

In this case, 192.0.78.13 and 10.0.0.254 refers to the router’s WAN and LAN IPs respectively, and 10.0.0.243 is the intended recipient of my RDP traffic.

[admin@751g2hnd] > /ip firewall nat print
1 chain=dstnat action=dst-nat to-addresses=10.0.0.243 to-ports=3389 protocol=tcp dst-address=192.0.78.13 dst-port=3389 log=no log-prefix=””

2 chain=srcnat action=src-nat to-addresses=10.0.0.254 to-ports=3389 protocol=tcp dst-address=10.0.0.243 dst-port=3389 log=no log-prefix=””

Many thanks to The Digital Doctor (http://forums.ncix.com/forums/topic.php?id=2662521)!!

InnoDB transactions

Yesterday I updated the date column of an entire table meant for its subset only. The solution to this mistake was to recover from daily mysqldump, and filling in the gaps that were, thankfully, able to be filled in.

Writing in 2010, the author of the answer said:-

When something goes wrong, the only restoration option available is to reconstruct the data from a backup (providing one exists).

Here are two answers that I found useful; i.e., Stack Overflow, the gift(s) that keeps on giving:

http://stackoverflow.com/questions/2950676/difference-between-set-autocommit-1-and-start-transaction-in-mysql-have-i-misse
http://stackoverflow.com/questions/5727827/update-one-mysql-table-with-values-from-another

Windows 10 and Google Drive

So I was asking my colleague to switch from Dropbox to Google Drive, mainly because is the company is subscribed to Google Apps for Work. But the pushback was that (Windows 10) search didn’t return hits as expected, and search is all-important.

I asked (the search engine) Google for help, and buried in a 2015 forum post is the solution for Windows 10, today. I’m not even sure why it’s been months and not resolved by the principals, but anyways:-

Right click ‘Google Drive’ > Security tab > Advanced > Click your username > Check the ‘Enable inheritance’ box > Click OK.

 

https://productforums.google.com/forum/#!topic/drive/5EPuLuwmLGI

Hyper-V: Slow Guest Network Performance

A couple weeks ago, I discovered that guest network performance was abysmally slow, copy-pasting files from host to guest (RDP) felt like it took days instead of the (expected) minutes! This delayed the commissioning of a new application, and it bugged me for a bit. Later on, a different guest exhibited the same issue; i.e., I could actually see the images it sent over being (very slowly) downloaded in the browser…

After a bit of Google-ing and experimentation, it appears to be related to a NIC issue (our HP server uses Broadcom) and this Virtual Machine Queues (VMQ) option in Windows Server 2012 R2. It’s weird that it hasn’t already been resolved by Broadcom/Microsoft, but here’s the full Reddit link if you need more details.

Do note however that I tried out the Registry update (BelowTenGigVmqEnabled=1), but it didn’t work in my case. I’m just going to quote from the the Redditor in closing:-

My world is beautiful.

https://www.reddit.com/r/sysadmin/comments/2k7jn5/after_2_years_i_have_finally_solved_my_slow/

Mac: Deleting pages in Preview.app

Today I received a PDF document, but there were two pages I’d to delete. Clicking the page and then hitting Delete didn’t work, so I did a Google search:

I figured it out! In case this is useful to anyone else: I just needed to go to the Edit menu and choose “Thumbnail.” Once the list of pages is turned into Thumbnails, you can delete them.

https://discussions.apple.com/thread/5893303

Magento: Admin URI 404

Today I was informed that navigating to a (previously working) Magento installations’ admin page was no longer working. Obviously, paid orders cannot be processed. So it’s pretty serious, to say the least.

Stack Overflow gave me the solution, but it’s buried pretty deep down, so I’m copy-pasting for posterity, from http://stackoverflow.com/questions/18724995/magento-404-on-admin-page.

One common cause for this behavior is an invalid value (or no value at all) being set for a custom admin path. Since you can’t access the admin, try running the following SQL query. If you see results similar to the above, or admin/url/custom_path is blank/not-present but admin/url/use_custom_path is still 1 — then that’s your problem.

Hope this helps someone else out there in some small way.