Question thread #61

[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

[pauamma]

OK, I think I'm beginning to have an idea what happened. To confirm my suspicion, I need you to check which tables exist in the dw_schwartz database. But first, what is in the @THESCHWARTZ_DBS array in $LJHOME/ext/local/etc/config-private.pl ? (Be sure to sanitize it by redacting the actual password.)

[octorok]

Here ya go:

@THESCHWARTZ_DBS = (
{
dsn => 'dbi:mysql:dw_schwartz;host=localhost', # CHANGETHIS if on Dreamhack to dreamhack_username instead of dw_schwartz
user => 'dw', # CHANGETHIS if on Dreamhack to dh_username
pass => 'password', # CHANGETHIS
},
);

[pauamma]

OK. I need you to list the tables in the dw_schwartz database. Something like:

mysql --user=dw --password=youractualpasswordgoesthere
show databases;
use dw_schwartz;
show tables;
exit

[octorok]

Okay. Here's what I got (a whole lot of nothing it looks like!):

[pauamma]

Yeah, that confirms my suspicion. More after I file the appropriate bug.

[pauamma]

OK, you were probably bitten by https://github.com/dreamwidth/dw-free/issues/2318. I'm afraid the notifications you never received are well and truly lost. There still is a solution for you that will let you use notifications in the future, and that is to point @THESCHWARTZ_DBS to where the tables actually live. Specifically:

1- Open ext/local/etc/config-private.pl (not etc/config-private.pl) with your favorite editor
2- In %DBINFO, note what user and pass are set to
3- In @THESCHWARTZ_DBS, make sure that user and pass match those in %DBINFO
4- Still in @THESCHWARTZ_DBS, change 'dw_schwartz' in dsn to 'dw'
5- Still in @THESCHWARTZ_DBS, add the following line before the closing }:

prefix => 'sch_',

6- Check @THESCHWARTZ_DBS: it should now look something like:

    @THESCHWARTZ_DBS = (
            {
                dsn => 'dbi:mysql:dw;host=localhost',
                user => 'yourusernamegoeshere',
                pass => 'yourpasswordgoeshere',
                prefix => 'sch_'
            },
        );

(perhaps with different indentation)
7- Save your changes
8- Test as much of the features that rely on TheSchwartz that you can and care for (for a should-be-complete list, see TheSchwartz workers in http://wiki.dreamwidth.net/wiki/index.php/Workers#List_of_workers )

[octorok]

That did the trick! :) Comment notifications seem to be working now. I'll do more testing on the other features to make sure everything's working and if I have any problems I'll be sure to bring them here. You guys are great! Thanks for the help.

[pauamma]

And adding this for completeness because I forgot it in my list above, but you appear to have done it anyway (or maybe it wasn't needed):
7.5- restart Apache and workers