SQL Woes

For the most part, managing my web server is pretty straightforward, especially because I don’t really get a ton of traffic. Its mostly just keeping things up to date through standard channels.

Occasionally I have a bit of a brain fart moment. I recently was doing regular Linux updates on the server. I noticed a message I had seen before about some packages being held back. Occasionally I will go through and update these, because I am not real sure why they are being held back, but don’t really see any reason they should be.

Then MySQL broke.

So I went digging in some logs and searching for solutions, and decided I needed to roll back the version. Following a guide I found, I discovered… I had done this before, which I now vaguely remebered. Because the old .deb file was still there from last time I broke it.

Anyway, this didn’t fix it, MySQL still was not launching.

I decided that maybe it was time to just switch to MariaDB, which I believe is the spiritual successor to MySQL. And the process was simple enough, I would not even need to dump my Databases. So I uninstalled MySQL, installed MariaDB and… It worked!

Then it stopped working.

I restarted the SQL service and it worked!

Then it…. Stopped working… Again…

So I checked logs again and corrected some issues there and again it worked, then a half hour or so later it stopped working.

One thing I had come across in troubleshooting the original MySQL issue was that there was a command, mysql_upgrade that needed to be run to change how some tables are configured. I couldn’t do that before because I couldn’t even get MySQL to run. But I could get MariaDB to run at least for a bit, and had successfully gotten this upgrade command to run.

So I decided to, once again, try MySQL again, so I uninstalled MariaDB, and purged everything out, rebooting a few times to be sure. And MySQL would not even install anymore, so more purging, this time, including the Databases.

One thing I was glad I had decided to do, “Just in Case” when MariaDB was “working” was dump the databases out with backups. I was glad I did at this point. So with absolutely everything purged, MySQL installed and was working.

I set about recreating the databases from the dumps, and while I was at it updated all the passwords, since I had to recreate the user accounts used by WordPress anyway.

And now everything is working smoothly again.

A couple of links that were actually helpful in solving my problem.

https://stackoverflow.com/questions/67564215/problems-installing-mysql-on-ubuntu-20-04

https://learnubuntu.com/install-mysql/

Code Project: Automated List From Reddit Comments

Python Logo

This is one of those quick and kind of dirty projects I’ve been meaning to do for a while. Basically, I wanted a script that would scrape all of the top level comments from a Reddit post and push them out to a list. Most commonly, to use on /r/AskReddit style threads like, well, for this example, “What is a song from the 90s that young people should listen to.”

Basically, threads that ask for useful opinions on list. Sometimes it’s lists of websites or something. Often it’s music. The script here is made for music but could be adjusted for any thread. Here is the script, I’ll touch on it a bit in more detail after.

## Create an APP for Secrets here:
## https://www.reddit.com/prefs/apps

import praw

## Thread to scrape goes here, replace the one below
url = "https://www.reddit.com/r/Music/comments/10c4ki0/name_one_90s_song_kids_born_after_2000_should_add/"

## Fill in API Information here
reddit = praw.Reddit(
    client_id="",
    client_secret= "",
    user_agent= "script by u/", # Your Username, not really required though
    redirect_uri= "http://localhost:8080",
)


submission = reddit.submission(url=url)
submission.comments.replace_more(limit=0)
submission.comment_limit = 1

for x in submission.comments:
    with open("output.txt", mode="a", encoding="UTF-8") as file:
        if "-" in x.body:
            file.write(str(x.body)+"\n")
            # print(x.body)

The script uses praw, Python Reddit API Wrapper. A Library made for use in Python and the Reddit API. It requires free keys which can be gotten here: https://www.reddit.com/prefs/apps. Just create an app, the Client ID is a jumble of letters under the name, the secret is labeled. User Agent can be whatever really, but it’s meant to be informative.

The thread URL also needs filled in.

The script then pulls the thread data and pulls the top level comments.

I’m interested in text file lists mostly, though for the sake of music based lists, if I used Spotify, I might combine it with the Spotify Playlist maker from my 100 Days of Python course. Like I said before though, this script is made for pulling music suggestions, with this but of code:

        if "-" in x.body:
            file.write(str(x.body)+"\n")
            # print(x.body)

It’s simple, but if the comment contains a dash, as in “Taylor Swift – Shake it Off” or “ACDC – Back in Black”, it writes it to the file. Otherwise it discards it. There is a chance it means discarding some submissions, but this isn’t precision work so I’m OK with that to filter out the chaff. If I were looking for URLs or something, I might look for “http” in the comment. I could also eliminate the “if” statement and just have it write all the comments to a file.

My Music Listening Habits for 2022

It’s that time again, when I ramble on about what I’ve been listening to this year.  I don’t use Spotify so I don’t have a “cool kids” wrap up to share.  Instead you get this!  A blog post!  And some little 5×5 charts made from my Last.fm.  I kind of prefer starting on Artists over Albums, so without further ado, the top 25 for 2022.  Which unsurprisingly, is relatively similar to my previous years.

In a surprise to literally no one, including myself, my top 3 are pretty much the same as they have been for a while.  Aurora, CHVRCHES, and Sigrid.  Actually, I am a little surprised Sigrid is so high, I didn’t listen tot he new album a ton, or much Sigrid that I remember actually.  Aurora and CHVRCHES, not so much, I listen to both a lot.  Heck, I saw Aurora live this year.

Beyond that is a bit of new-ish stuff.  I’m still been digging on Radiohead’s Kid A Mnesia re-release, and I picked up a copy of OK Computer to add to that mix.  The Weeknd’s Dawn FM has become a pretty regular listen as well.  It’s an album I didn’t expect to enjoy as much as I do.   Orla Gartland and Dodie slot in at numbers 6 and 7.  I almost went to see Dodie (and Orla) earlier this year but my wife had a Doctor’s thing come up and COVID was starting to ramp up again, so I opted to skip it.

Next on the list is Magdalena Bay, a newcomer to the list which a lot of the folks at the CHVRCHES discord recommended.  Another with this honor is Wolf Alice down in the number 17 slot.  I actually kind of prefer Wolf Alice to Mag Bay, but I picked up their album later, so they got less time to be listened to. Wolf Alice is a bit more, guitars and rock, while Mag Bay is more synth and electronic.  Also in this list of “Recommended by CHV People,” is Purity Ring at number 20.

Quite a few regulars on the list for a bit, though I want to comment on how much Raffaella has manages to stay in these lists.  I’m sure I mentioned it before, several times, but I had never hear of her back in 2019 before going to see Sigrid, and I’ve been listening to her music still, years later.  She hasn’t even really put out a lot of new stuff either, a couple of singles and a small sized EP.

I think Berlinist is new to the top 25, but this is entirely from listening to the Gris Video Game soundtrack.  It’s a good ‘relaxing music” album.  

There are a few missing that I’m actually surprised are missing.  Well, one anyway, which is Enya.  Not a new artist by any means, but I ended up with her entire discography, minus one, I think, at an estate sale, and I listened to quite a few of her albums recently.  It feels like it should have been enough to put her up there on the list.  It’s also really interesting because, Enya definitely reminds me of the same sort of, exotic, vocalizing, sort of style of Aurora.

Anyway, next up is the albums list, but a lot will have been covered by the Artists wrap up so I’ll just stick to anything interesting.

And it’s more or less an expansion of the Artists lists.  Most interesting, though not surprising is that every album from Aurora and CHVRCHES appears in this list.

I also noticed I forgot to mention the Cranberries.  Like Enya, I picked up a few Cranberries albums and I’ve been enjoying them.  It’s also funny because, Enya “feels” like an “Earlier Aurora” in a lot of ways, and The Cranberries, “feels” like an “Earlier CHVRCHES” in a lot of ways.  I could actually expand on this a bit with Sigrid too, because Alanis Morissette, “feels” like an “Earlier Sigrid.”

I guess my point is, the more things change,t he more they stay the same, and my overall musical tastes is about the same as it always has been, it’s just added the latest version of the same shtick.