Here I am again...

[whobutdrew]

So I got past the patching problem I had earlier this week, thanks to you guys. I ran through the rest of the steps in the wiki, and reached the end! So I fire up a browser, punch in my address, and get...

This. The "Oops! Something's broked" error. I combed through the comments, and the poster there was running dw-free and dw-nonfree code, and eventually rolled back to just dw-free. From there, it looked as if he ran into similar problems than I did, and (presumably) went on his merry way once getting those worked out.

So here are the results of a `tail /var/log/apache2/error.log`, after restarting my Apache services and attempting to hit my site again.


[Sat Sep 05 14:13:06 2009] [notice] caught SIGTERM, shutting down
[Sat Sep 05 14:13:11 2009] [notice] Apache/2.2.11 (Ubuntu) mod_apreq2-20051231/2.6.0 mod_perl/2.0.4 Perl/v5.10.0 configured -- resuming normal operations
[Sat Sep 05 14:13:50 2009] [error] [client 192.168.2.102] Can't call method "selectrow_array" on an undefined value at /home/dw/cgi-bin/ljlib.pl line 1948.\n
[Sat Sep 05 14:13:50 2009] [error] [client 192.168.2.102] File does not exist: /home/dw/htdocs/favicon.ico
Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665. @ ubuntu
Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665. @ ubuntu
[Sat Sep 05 14:13:50 2009] [error] [client 192.168.2.102] Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665.\n
[Sat Sep 05 14:21:15 2009] [error] [client ########] Can't call method "selectrow_array" on an undefined value at /home/dw/cgi-bin/ljlib.pl line 1948.\n
[Sat Sep 05 14:21:15 2009] [error] [client ########] File does not exist: /home/dw/htdocs/favicon.ico
Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665. @ ubuntu
Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665. @ ubuntu
[Sat Sep 05 14:21:15 2009] [error] [client ########] Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665.\n



On the bright side, this is farther I've ever gotten on LJ code! Thanks to my manual configurations... I mean butchery... I could get a site internally viewable, but not externally. Now, though, the whole dang interwebs can see my error. So my excitement remains unfettered, as progress is progress.

Thanks again for everyone's help before, and in advance for the assistance now! I'll try my best not to spam the comm, I promise. :)

Comments

[mark]

It sounds like your database isn't properly configured. Did you/have you successfully run bin/upgrading/update-db.pl? And that works?

[whobutdrew]

I ran:

$LJHOME/bin/upgrading/update-db.pl -r --innodb
$LJHOME/bin/upgrading/update-db.pl -r --cluster=all --innodb
$LJHOME/bin/upgrading/update-db.pl -p
$LJHOME/bin/upgrading/make_system.pl

And didn't remark upon any problems. Shall I delete/recreate/repopulate the databases to make sure?

[afuna]

The error about the language code is probably a symptom not a cause (it means that it wasn't able to load the site strings from the database). I'm trying to match up the line you gave me with my version of the code, but line 1948 in ljlib.pl is just a closing brace. Could you update to the latest code, reconfigure (if necessary, but it shouldn't be), and try again?

[whobutdrew]

I ran

cd $LJHOME/cvs/dw-free
hg update -C tip

And got no files changed. Is there another command I should be running instead?

[afuna]

Hm, do bin/cvsreport.pl -s -c, too. Did that move over anything?

[whobutdrew]

It pulled down cgi-bin/ljlib-local.pl.

I did an /etc/init.d/apache2 restart and got a failure. I repatched from here: http://bugs.dwscoalition.org/attachment.cgi?id=2279

And I got the same problem again. I have since rerun cvsreport.pl. The error.log file gave me:

Can't locate DW/Hooks.pm in @INC (@INC contains: /home/dw/cgi-bin /home/dw/src/s2 CODE(0x7ff713c44040) /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /home/dw/cgi-bin/ljlib-local.pl line 6.\nBEGIN failed--compilation aborted at /home/dw/cgi-bin/ljlib-local.pl line 6.\nCompilation failed in require at /home/dw/cgi-bin/ljlib.pl line 114.\nCompilation failed in require at /home/dw/cgi-bin/Apache/LiveJournal.pm line 43.\nBEGIN failed--compilation aborted at /home/dw/cgi-bin/Apache/LiveJournal.pm line 45.\nCompilation failed in require at /home/dw/cgi-bin/modperl_subs.pl line 15.\nBEGIN failed--compilation aborted at /home/dw/cgi-bin/modperl_subs.pl line 15.\nCompilation failed in require at /home/dw/cgi-bin/modperl.pl line 45.\nCompilation failed in require at (eval 2) line 1.\n
[Sat Sep 05 20:01:03 2009] [error] Can't load Perl file: /home/dw/cgi-bin/modperl.pl for server ubuntu.localdomain:0, exiting...


Which looks mysteriously like the problem that the patch was meant to fix! Not sure what the next step is...

[exor674]

You'll need to reapply the patch heh.

Also -- your error looks like you missed running

$LJHOME/bin/upgrading/texttool.pl load

(note, it might be texttool, it might have dashes -- I'm trying to recall off the top of my head which is kinda fail right now)

[whobutdrew]

OK, so I reran cvsreport.pl, repatched, and then ran texttool.pl, which didn't look like it did much, but did it anyway.

Then I restarted Apache. This succeeded where it failed before.

I try to hit my site, I get the same "Oops!" error.

My error log says:

[Sat Sep 05 21:49:34 2009] [error] [client 71.80.150.32] Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665.\n
[Sat Sep 05 21:52:55 2009] [notice] caught SIGTERM, shutting down
[Sat Sep 05 21:52:59 2009] [notice] Apache/2.2.11 (Ubuntu) mod_apreq2-20051231/2.6.0 mod_perl/2.0.4 Perl/v5.10.0 configured -- resuming normal operations
Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665. @ ubuntu
Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665. @ ubuntu
[Sat Sep 05 21:53:12 2009] [error] [client 71.80.150.32] Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665.\n
[Sat Sep 05 21:53:12 2009] [error] [client 71.80.150.32] File does not exist: /home/dw/htdocs/favicon.ico
Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665. @ ubuntu
Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665. @ ubuntu
[Sat Sep 05 21:53:12 2009] [error] [client 71.80.150.32] Unable to load language code: en_DW at /home/dw/cgi-bin/ljlang.pl line 665.\n

I then reran all of the database populating commands that the wiki has:

$LJHOME/bin/upgrading/update-db.pl -r --innodb
$LJHOME/bin/upgrading/update-db.pl -r --cluster=all --innodb
$LJHOME/bin/upgrading/update-db.pl -p
$LJHOME/bin/upgrading/make_system.pl
$LJHOME/bin/upgrading/texttool.pl load
$LJHOME/bin/upgrading/copy-emailpass-out-of-user

(NOTE - none of these were as sudo, but none gave any errors that I could discern)

I still get:

Oops!

If you've gotten this error, it means that something is currently (and, with luck, temporarily) broken. Please wait five minutes and try again.

[pauamma]

$LJHOME/bin/upgrading/update-db.pl -p

I think you need to use the -r option there too. Try:

$LJHOME/bin/upgrading/update-db.pl -r -p

Also, can you post the content of bin/upgrading/text.dat (and text-local.dat, if also using dw-nonfree), and the settings for @LJ::LANGS and $LJ::DEFAULT_LANG (if present) in $LJHOME/etc/config*.pl? That may help troubleshoot the "Unable to load language code: en_DW" error message.

[whobutdrew]

Running update-db -r -p alone didn't fix it. So, in their entirety in case anything else jumps out at you:

bin/upgrading/text.dat

etc/config.pl
etc/config-local.pl
etc/config-private.pl

[pauamma]

OK. Relevant line from text.dat is

lang:1:en:English

If you don't have a text-local.dat (and you likely don't), that means that your installation only knows about en, but you try to make it use en_DW in one of the config files.

Trying to see those files gives me 500 pages, but at a guess, one of them (I can't remember which one offhand) has either @LJ::LANGS set to qw(en_DW en) or $LJ::DEFAULT_LANG set to "en_DW" (which could happen if you leave it unset, since the default value is $LJ::LANGS[0]. If that's the problem, just remove en_DW from @LJ::LANGS and remove any setting for $LJ::DEFAULT_LANG. That should fix it.

(Note: those may be present as @LANGS and $DEFAULT_LANG in the files)

If that still doesn't work, comment with the contents of the config files. (Suitably sanitized - we don't need to know the password for your MySQL database, or any other sensitive information)

[whobutdrew]

I have found

@LANGS = qw( en_DW );

in config.pl. If I understand you correctly, I should remove the "_DW" part to have it be just 'en?' Or remove that line completely?

[pauamma]

Change it to read

@LANGS = qw( en );

then restart your Apache and you should be fine. (You may need to rerun texttool too, just in case.)

[whobutdrew]

And I'm live!!

Thank you SO much. To the tinkering! (Mwhahahahah)

[afuna]

Hmm, okay we should probably fix that in the default config file, shouldn't we? And only have en_DW in config-local.pl?

[pauamma]

Hmm, in which order are files loaded? Having qw( en ) in config.pl and qw( en en_DW ) in config-local.pl only works if config.pl is loaded first, but IIRC it relies on variables set in config-local.pl for some of the variables it sets, so that wouldn't work. Alternate solution would be to remove it entirely from config.pl and have something in (IIRC) cgi-bin/ljdefaults.pl along the lines of @LANGS = qw( en ) unless @LANGS;