Disabling ~/.mysql_history logging

Posted on Thu 13 August 2015 in Linux • Tagged with linux, mysqlLeave a comment

If you haven't heard, there was a nasty Firefox vulnerability discovered last week. The "tldr" is, malicious ads were able to read the contents of local files on your computer. According to Mozilla, there exploit leaves no traces behind so you can't really know if you were a victim. The jury is still out on whether or not ad-blocker software would have saved you either.

This situation has made me reevaluate some of the bad computing habits that I've formed over the years. This post is about disabling the mysql client's logging to ~/.mysql_history. It's easy enough to empty the contents of ~/.mysql_history after adding a user or some such "sensitive" query... but that's also easy to forget. It's easier/safer for me to just disable the client logging entirely. There are two ways to accomplish this. The first (and probably easiest):

ln -sf /dev/null ~/.mysql_history

The other way is by setting the MYSQL_HISTFILE environment variable to /dev/null:

export MYSQL_HISTFILE=/dev/null

I prefer the symlink approach since it didn't require me to update any of my dot files etc...


Mystery load on my Arch Linux laptop

Posted on Sun 02 August 2015 in Linux • Tagged with arch, linuxLeave a comment

This weekend PyOhio was taking place at the Ohio State University Union building. While sitting in one of the presentations yesterday, I noticed that my battery was a bit lower than I expected. This also lead to me noticing that my load average was hovering between 1 and 1.5 despite having very little running on my computer. I started investigating. I stopped a lot of services & applications, rebooted, booted into rescue.target (systemd's "single user-ish" mode), etc... No matter what, the load was consistently above 1 no matter what.

After poking around for a while, I tried unloading the virtualbox kernel modules - vboxdrv, vboxnetflt, and vboxnetadp). My load started dropping like a bag of hammers. It looks like the problem driver is specifically vboxdrv:

[root@earth ~]# modprobe vboxdrv
[root@earth ~]# uptime
 13:34:34 up 22:17,  1 user,  load average: 0.06, 0.17, 0.14
[root@earth ~]# uptime
 13:34:45 up 22:17,  1 user,  load average: 0.20, 0.20, 0.14
[root@earth ~]# uptime
 13:35:46 up 22:19,  1 user,  load average: 1.00, 0.42, 0.22

As you can see, load just immediately starts climbing. Let's unload it!

[root@earth ~]# rmmod vboxdrv
[root@earth ~]# uptime
 13:59:57 up 22:43,  1 user,  load average: 0.99, 1.07, 0.92
[root@earth ~]# uptime
 14:00:17 up 22:43,  1 user,  load average: 0.71, 1.00, 0.91
[root@earth ~]# uptime
 14:02:42 up 22:45,  1 user,  load average: 0.08, 0.63, 0.78
[root@earth ~]# uptime
 14:02:58 up 22:46,  1 user,  load average: 0.06, 0.60, 0.77

And just like that, load returns to normal. I guess now's a good time to switch to libvirt!


Planck 40% Ortholinear Keyboard Review

Posted on Thu 30 April 2015 in Mechanical Keyboards • Tagged with keyboards, diyLeave a comment

I have been a mechanical keyboard enthusiast for several years now. I frequently lurke at r/mechanicalkeyboards and GeekHack. At work I use a Cooler Master Quickfire Rapid with Cherry MX Blue switches and at home I use a Unicomp Customizer 104 with buckling spring switches. A little over a month ago I stumbled upon a DIY 40% ortholinear keyboard called the Planck. It was created by Jack Humbert who sells the parts at ortholinearkeyboards.com. Building my own keyboard (and having full control over the firmware) sounded like a great experiment and I've never used an ortholinear (grid keys) keyboard, so I decided to go for it.

Continue reading

Dance Dance Revolution Arcade Unlock Codes

Posted on Wed 22 April 2015 in Dance Dance Revolution • Tagged with dance dance revolution, video gamesLeave a comment

A couple of weeks ago I noticed that ddrfreak.com's site is either broken or a lot of content has been removed. I had installed DDRMAX2 on one of my arcade DDR PCBs and went to ddrfreak in search of unlock codes. To my surprise, they were nowhere to be found. A quick search on the Way Back Machine gave me what I needed. I decided it would probably be a good idea to make a blog post containing these unlock codes to further preserve them.

Secret Menu

Accessing the secret menu requires access to the operator menu. Once you are in the operator menu, move your selection to "GAME OPTIONS" but do not press start. Hold the 1P down arrow and the Service button and press 1P start. This should put you in the "SECRET" menu.

DDRMAX 6th Mix

Unlocks 1-3 (All): PGEKMMN-INGLOMI

That should unlock MAX 300, true... ~trance sunrise mix~, and CANDY?

DDRMAX2 7th Mix

Unlocks 1-5:        DGMBJCU - YCDPMAS
Unlocks 1-10:       MCQEMRG - KHVOBWG
Unlocks 1-15:       BARTYY_ - PDSHTBH (the seventh character is a space)
Unlocks 1-20:       USGCFHJ - JLBBYXK
Unlocks 1-25:       IJURVIT - WXFCOJW
Unlocks 1-31 (All): JCYWEKJ - DZJNBGF

Those unlocks correspond to:

 1. ONI COURSE - TEMPO CHANGER
 2. "La Senorita" - CAPTAIN. T
 3. ONI COURSE - NAOKI feat. PAULA TERRY
 4. ".59" - dj TAKA
    "DXY!" - TaQ
 5. "Abyss" - dj TAKA
    "ECSTASY" - d-complex
 6. ONI COURSE - SOUL 6
 7. "Sana Molette Ne Ente" - Togo Project feat. Sana
 8. ONI COURSE - COOL 7
 9. ONI COURSE - Be For U
10. "SEXY PLANET" - Crystal Aliens
11. "WILD RUSH" - FACTOR-X
12. ONI COURSE - POP 8
13. "Holic" - TaQ
14. "TRIP MACHINE CLIMAX" - DE-SIRE
15. "SUPER STAR" - DJ.Rich feat. Tail Bros.
16. ONI COURSE - Fine Choice
17. ONI COURSE - HAPPY HARDCORE
18. "MY SUMMER LOVE" - MITSU-O! with GEILA
19. "LUV TO ME (AMD MIX)" - DJ KAZU feat. Tiger YAMATO
20. "Silent Hill" - THOMAS HOWARD
    "HIGHER" - NM feat. SUNNY
21. ONI COURSE - LOVE RevenG
22. ONI COURSE - From SOLO
23. ONI COURSE - MIDNIGHT BLUE
24. "Spin the Disc" - good-cool
25. "Burning Heat! (3 Option Mix)" - Mr. T. feat. Motoaki F.
26. ONI COURSE - From IIDX
27. "i feel..." - AKIRA YAMAOKA
28. ONI COURSE - NAOKI PLATINUM
29. ONI COURSE - Demon Road
30. "MAXX UNLIMITED" - Z
    "Kakumei" - dj TAKA with NAOKI
31. ONI COURSE - Demon Road 2

DDR EXTREME

Unlocks 1-6:        JLEDKZT - KOZGDJJ
Unlocks 1-9:        UBNRXAO - UJGPQQI
Unlocks 1-15:       PVAGUPM - UALPOEZ
Unlocks 1-18:       RVNYIXO - YKAWEM_ (the last character is a space)
Unlocks 1-24:       SQFRXYY - JSBERAH
Unlocks 1-27:       JHEDXF_ - ALZSMSH (the seventh character is a space)
Unlocks 1-30 (All): BWUVHBK - KVXFXYA

I'm not sure what these unlocks correspond to. Eventually I'll document that as well.


Changes incoming!

Posted on Wed 15 April 2015 in General • Tagged with python, djangoLeave a comment

I'm moving some stuff around and I've been working on my blog software. Hopefully some good stuff will be coming this week!