MySQL/MariaDB woes

Recently had some issues with a fresh MariaDB install. After installation I was unable to create a new user. After testing a few things I realized I also had issues changing the root password.

I eventually was hit with the error message:

ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number

After numerous searches the most common answer lead me to try the following:

 SET old_passwords = 0;

After that failed I eventually gave up with MariaDB, uninstalled and tried to install MySQL. That also didn’t go as smoothly as I had hoped. First there were old files left behind. After a few more searches I ended up running a few commands to completely uninstall MariaDB.

Now with the fresh install of MySQL I go ahead and try to create a new user, to then be faced with this new error:

ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded.

This was easy enough to fix. After logging into mysql via terminal. I ran the following commands:

use mysql;
update user set plugin="mysql_native_password";
flush privileges;

Sadly this ended up taking a couple days to fully resolve. Luckily it was on a development machine, but still work is work.


Open source journalism

We recently started a discussion on stream on what open source journalism might look like for as us developers. We also discussed some implications and use cases for both readers and journalists. Here’s a quick breakdown of our initial chat on 2/6/2020.

I plan on editing this post as we continue to grow this idea as a community. If you have any feedback or would like to follow along join the stream Tuesdays and Thursdays 10am-4pm.

Initial punch list (Last edited 2/6/2020)

☐ Source an origin
    Content from same location or time stamps
☐ Allowing people to submit sources, articles already posted online
    ☐ Archiving original posts + revisions
☐ Determine mood and sentiment from comments
☐ Source similar or related information  
☐ Read more on what problems journalist currently face
☐ Tech stack
    ☐ for data submission and processing
    ☐  website itself will be pre-generated and stored on:
        ☐ distributed servers
            ☐ block chain
        ☐ object store like s3 or Linode
        ☐ tor
☐ Goals/Priorities 
    ☐ 1. Develop trust
    ☐ Verification
        ☐ Make sure a human is actually posting the external content
    ☐ Distinction between verified and unverified authors
        ☐ Look for patterns
            Photos/video posted
            Other content posted by this author on other platforms, if any

Sorry for the poor formatting. This theme needs some serious attention, just hasn’t been a priority. Will begin fixing in the coming weeks.

Playing Quake 3 on OS-X

I was surprised to see how easy it was to get Quake 3 up and running under OS-X 10.10.5. With these simple steps you’ll be up and running in no time. I think I see a dedicated server in my near future.

  1. Download a pre compiled (Windows, Linux, Solaris also available)
  2. Mount ioquake3.dmg
  3. Move ioquake3 folder to your  /Applications folder
  4. Copy pak0.pk3 from your baseq3 folder on your Quake III: Arena CD or Steam installation to your /Applications/ioquake3/baseq3 folder
    • Mods are also installed into /Applications/ioquake3/baseq3
  5. Start it up and enjoy!
    • Enter your CD key (optional)

If you don’t have a Quake III: Arena CD you can easily find one on eBay, I picked my copy up for $8.



Two weeks of HHVM

Running for about two weeks now, I must say HHVM is very snappy. It can be rough around the edges while setting up depending on your system, but thats to be expected.  I tried several installation methods, ultimately a manual build under Ubuntu 12.04 worked best. However I’m experiencing some issues with WordPress permalinks. Direct requests work as expected, but snappier.

I must say I’m most impressed by the performance increase via command line. We use several PHP based command line tools at DealerX. These tools comb millions of vehicles a week, cleaning and sanitizing and matching data for search and other end user displays. I think she’s a keeper.

Some Hello Doge, in C?

Like some young men, my father was a big influencer on my career path. I started with web design, but quickly realized without logic my projects would essentially be useless. A few months later I was writing basic PHP and cutting up WordPress themes on a regular basis.

Today, 6 years later,  quite comfortable with PHP but feel like as though it’s getting a bum deal being a dynamic language an all. With projects like HHVM chugging away, I’m looking for other ways to bridge the gap between PHP and C.

Having never written any C before, I quickly realized it was quite needy. I decided to try out BinaryPHP, it quickly converts your PHP into source and compiles an executable for you.

For those who are curious, you can grab all sources from github.


This is something I’ve been having some difficulties with the past few months. I tend to program in cycles, I have some very productive times, followed by a null in development and overall creativity. In the past I relied heavily on yoga to help reduce the impact these lulls had on my overall person. More recently mountain biking had taken that role, however my season ended shortly with a broken wrist after I took a spill into some rocks.

With that lull right around the corner, and my wrist still not 100%, I was hoping to take a new approach to my lack of output. I’m wrapping up, ending or getting involved in new projects. In other words, I’m taking some of this time where “I should be productive” and applying that energy to simpler tasks, saying good bye to old projects, and hello to new ones. Its less about being extremely productive, but more about addressing some minor issues on my to do.

Somethings on my lull list:

So here it goes – in a bit of a lull at the moment. I’m in the midst of addressing 2 of those items. Heres to a slightly different approach.


Edit 1:

It’s common to see some motivational crap on hacker news, with that being said I came across this gem earlier this morning.

Life is a game. This is your strategy guide



I was initially drawn in by attractive pixel art, but needless to say I think OP forgot to write the strategy part. “Cute post man.”


Edit 2:

Here’s a more useful article. Linux monitoring, thanks hacker news.


Edit 3:

Screen Shot 2014-02-05 at 4.01.56 PM

I managed to wipe my apache config on my development server while performing a few mundane updates. That seems to be another item complete.

Carmelo Santana

Independent Consultant

  • Male
  • 35 years old
  • Hudson Valley, New York

Mood: Mindful 🌠

View my:

On a path of spiritual healing 🌒 and deep learning 🤖
GamesPath of Exile, Rise of Kingdoms 🌽, Satisfactory, Nu****, Elder Scrolls Online = 💩
  • Work:
  • Easy Listening: Wang Xu-Dong, o k h o, Saito, Canti, Feign, Brothel, Trashlord, foxwedding, Harukasuka, SLIGHT, Kamandi, Baths, Bonobo, Bloc Party, Coconut Records, Yeah Yeah Yeahs, Phoenix, M83, The Drums, Deerhunter, Toro Y Moi, Passion Pit, Bombay Bicycle Club, Neon Indian
  • Weekends: Drake, Cardi B, Doja Cat, Childish Gambino, Danny Brown, Earl Sweatshirt, A$AP Rocky, B.I.G, D.I.T.C, Wu-Tang, Fugees, Necro, Ariana Grande, Megan Thee Stallion
  • Metal of sorts: Berried Alive, Angel Vivaldi, Deftones, The Tony Danza Tapdance Extravaganza, Liferuiner, Emmure, Misery Signals, Chelsea Grin, For The Fallen Dreams, Erra, Northlane, Dream On Dreamer, Molotov Solution, Vanna, Rings of Saturn
MoviesDie Hard 3, The Birdcage, Birdman, The Godfather, Goodfellas, A Bronx Tale, Scarface, Working Girl, Burn After Reading, Dope, Arrival, Outbreak, Get Out, Pretty Woman
  • Stranger Things, Glow, The End of The F**cking World, Narcos, Orange Is the New Black, Ozark, Unbreakable Kimmy Schmidt, High Maintenance, Insecure, Veep, Vice, Westworld
  • Oldies: Boardwalk Empire, Rome, Silicone Valley (first few seasons), The Sopranos, House of Cards (rip)
BooksAngels & Demons, Hua Hu Ching: The Unknown Teachings of Lao Tzu, When Will Jesus Bring The Pork Chops?, Yak Butter Blues, ACT on Life not on Anger
HeroesMy mother and Edward Snowden
Here forSharing code and experiences
HometownNewburgh, NY
EthnicityPuerto Rican
Zodiac♒ Aquarius
EducationMostly self taught, always experimenting and learning.
OccupationSelf employed