Help! I've broken my dreamhack!

[purplecat]

For a while my dreamhack has been throwing odd errors - e.g.,

file error - tropo-red.tt: not found at /dreamhack/home/8362-purplecat/dw/cgi-bin/DW/Template.pm line 365.\n, referer: http://user3.purplecat.hack.dreamwidth.net/

Today it was behaving very badly, with apache refusing to start and stop correctly, git throwing wierd errors when I tried to update develop and so on. I eventually realised I'd run out of space - deleted my back-up save of my old mercurial repositories and managed to get apache and git behaving again.

However, somewhere along the way I seem to have fubarred the database:


dh-purplecat@newhack:~/dw/bin/upgrading$ ./update-db.pl -r -p --innodb
Updating cluster: 0
Use of uninitialized value in concatenation (.) or string at /dreamhack/home/8362-purplecat/dw/cgi-bin/DBI/Role.pm line 245.
Use of uninitialized value in concatenation (.) or string at /dreamhack/home/8362-purplecat/dw/cgi-bin/DBI/Role.pm line 245.

cluster: status
0: ERROR: Can't connect to the database (clust#0), so I can't update it. (Access denied for user 'dh-purplecat'@'localhost' (using password: NO))

Use of uninitialized value in concatenation (.) or string at /dreamhack/home/8362-purplecat/dw/cgi-bin/DBI/Role.pm line 245.
Use of uninitialized value in concatenation (.) or string at /dreamhack/home/8362-purplecat/dw/cgi-bin/DBI/Role.pm line 245.
Couldn't get master handle for population. at ./update-db.pl line 212.


Any idea what I've done, or how I can fix it?

Or even why I ran out of space - that worries me a bit too.

Comments

[momijizukamori]

I cannot help with the errors, but the space issue is probably the apache logs - it turned out at one point mine had gotten to like 300mb because they weren't being rotated/deleted/etc.

[purplecat]

That could easily be the explanation - I don't think I've ever deleted those logs.

Doesn't explain what I've done to the database though :(

[ninetydegrees]

Also, I had the same problem once and Sophie explained to me that the logs get bigger faster if you always leave your hack running (I do because I regularly need it for support and style things). I don't know if that's you case but I figured it couldn't hurt to mention it.

[purplecat]

That may be it as well, I often forget to stop-apache when I log off.

[alierak]

If you've run out of space during an update, it's possible that some files are missing or truncated. I guess the database issue sounds like a problem with ext/local/etc/config-private.pl (where the password is supposed to be kept). Yours seems to be missing.

[purplecat]

That figures. I had to do a git reset --hard at one point and it will have cleared out my config files!!

[mark]

Hmm, I would expect configuration files to be stored in a directory that wouldn't be touched by a git reset. Possibly I'm wrong, though?

If you don't have any patches on the hack right now, then you might just want to reset it. I don't know what the procedure is for that, but IIRC it's pretty easy. I'll see if I can poke someone on IRC to come give better information!

[purplecat]

They're in .gitignore, but I have a feeling one of the things I attempted over-rode .gitignore.

I don't think I do have any patches on the hack now (or at least none which don't have current commits also on github so, presumably, could be recovered). However it seems reasonable to at least attempt restoring config-private.pl before trying anything else.

I'll also drop by irc... errr... sometime when I have more than a few minutes spare (hopefully tomorrow evening)

[sophie]

Following on from what mark said, reinstalling your Dreamhack would probably be the best idea. Unfortunately, that's broken right now so I can't do that, so instead I'll take a look at your 'hack soon and email you about what I find and how to fix it. :D

(And I'll also get reinstallation working at some point soon!)

[purplecat]

I'll see if I can recover my config-private.pl and if that fixes things, if not then reinstalling may well be a solution.

[sophie]

Whoops, I just realised I never followed up on this. Do you still need help? If so I'll do it this time :)

[purplecat]

*g* No I'm fine. I ventured into IRC and you helped me there!

[sophie]

Oh! Right. Sorry, I apparently forgot. :D