DragonFly, mysql, ipv6, and defaults

I am posting this so it can help someone else, someday.

I have a DragonFly-5.4 system.  I installed mysql56-server, and started it up.  By default, it listens on “*”, which meant it listens on a local socket and IPv6 ::1 – not 127.0.0.1.

2019-06-04 13:35:03 15833 [Note] IPv6 is available.
2019-06-04 13:35:03 15833 [Warning] Failed to reset IPV6_V6ONLY flag (error: 45). The server will listen to IPv6 addresses only.

I put bind_address=127.0.0.1 into my.cnf to get IPv4 loopback to work.   Local socket connections still worked either way.  I’m not using IPv6 on this machine, so this solution works in this situation.  I’m not sure my mysql decides to go only IPv6 based on a strange flag, but mysql is reliably unreliable.

part-by-label: an additional benefit

Remember the commit that autocreates human-readable disk device names under /dev?  (Here’s a reminder.)  It’s now in 5.4 – technically, since 5.4.2.  Anyway, it will automatically identify the root USB disk when you boot from a USB .img file, so you no longer have to guess which /dev/daX file it was – usually da8 but sometimes you got a surprise instead.

Rehash reminder

If, like me, you’ve been running DragonFly for a long time, and you haven’t switched away from tcsh for your account or for root, you may not have ‘set autorehash’ in your .cshrc.  Newer installs have it.

Put that into .cshrc if you don’t have it, and it’ll save 15 seconds of the rest of your life not typing ‘rehash’… assuming you can overcome the muscle reflex.

More terminal fun

Remember my Wyse terminal experiment with a DragonFly VM?  I mentioned an odd output pause where the screen would stop updating until there was keyboard activity – or occasionally just die.  That was an artifact of Virtualbox; running this now in Qemu has no such problem.

I now have a very overcomplicated clock!  I’m running GRDC on this Wyse-185 connected as a vt100 to the virtual machine running DragonFly 5.4 in Qemu on my Windows 10 work laptop.  It’s at 9600 baud so I can see the numbers morph.  I find this aesthetically satisfying.