Question thread #58

[pauamma]

It's time for another question thread!

The rules:

- You may ask any dev-related question you have in a comment. (It doesn't even need to be about Dreamwidth, although if it involves a language/library/framework/database Dreamwidth doesn't use, you will probably get answers pointing that out and suggesting a better place to ask.)
- You may also answer any question, using the guidelines given in To Answer, Or Not To Answer and in this comment thread.

Comments

[octorok]

I'm learning quite a bit here, thank you for being patient with me. :) Here's the output:



edit: I FORGOT TO WHITE OUT MY PASSWORD IN THE LAST COMMENT!! Eek. Will change it later, lol.

[pauamma]

OK. It looks like there's something wrong with your install, I suspect with the Digest::MD5 perl module. To figure out whether I'm right and how to fix it, I need to check a few things about your installation. First, what Linux distribution (name and version) you're using. Second, the output of the command

perl -v

And third, the output of the command

perl -e 'use strict; use warnings; use Digest::MD5; print "$Digest::MD5::VERSION\n";'

[octorok]

I'm using Ubuntu 17.10 on Linode. Second, here's the output of perl -v:



The third step doesn't look like it did anything, sadly.

[pauamma]

Actually, the single line of output of the 3rd was just what I wanted to know, the version of the Digest::MD5 module you had installed. But I'm still not 100% sure whether there's something wrong with your install or what, so I have more troubleshooting code for you to run.

git checkout octorok-makesystem-changes
wget -O $LJHOME/bin/upgrading/make_system.pl https://gist.githubusercontent.com/pauamma/16977a9d0114d1a5e3a6f7417423f22a/raw/d88f27e2a1d8e9e7b69d4956e326784866244dc6/gistfile1.txt
git commit -a -m "More checking for error conditions"
$LJHOME/bin/upgrading/make_system.pl

And as usual, paste the output in a comment.

[octorok]

Okay cool! Here's the output after following your steps:

[pauamma]

OK, at this point, I'm pretty sure something changed between Ubuntu 16.4 (that the Dreamhack host runs) and 17.10 (that you run) that broke Dreamwidth. I suspect the something that changed is mysql-related. With that in mind, what is the output of

dpkg-query -l '*mysql*'

on your machine?

[octorok]

Interesting. Here's the output this time:

[pauamma]

OK. What's in /etc/mysql/mysql.conf.d/mysqld.cnf ? (Note: it may be several screenfulls long. I'm specifically interested in whether it contains a "sql_mode = ''" line as described in http://wiki.dreamwidth.net/wiki/index.php/Dreamwidth_Scratch_Installation#Configuring_MySQL.2FMariaDB .)

[octorok]

Here we go:

[pauamma]

Just to be clear: did you just add this or was it already there?

[octorok]

It was already there. I accidentally hit a key while searching for it is all. :)

[octorok]

Hey! I think you may have found the problem? I created a new disk and installed 16.04 on it and am able to login! So maybe that was the issue? Either way thank you so much for your help!

[pauamma]

Thanks for your patience while we worked our way through the problem!

ETA: filed bug https://github.com/dreamwidth/dw-free/issues/2248