[axxs-sysadmin] mysql problems with climateimc.org

[Dave Fregon]

On Sun, 2006-07-16 at 23:28 -0400, Jim Nelson wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> The chrooted environment we have does not have mysql included, and we are having
> database problems.  The plesk panel does not have any way of doing database
> maintenance, either.

There's phpmysqladmin in there, under databases, if you choose the
database, there's an icon up near the top of the page next to add a
database user that pops it up.

Also in Plesk admin, you can manage your shell (you have permissions to
change from chroot already, it's set on it for security while your not
working/needing a full shell), just click on 'setup' and choose your
shell, I have already set it for bash just then, so you should be able
to go in and repair the db now.

If in future you are after a quicker possible response, email
axxs-sysadmin at lists.indymedia.org as well, as there are quite a number
of sysadmins for the box, a few in Indymedia as well, that can help.

Of course, always cc us for extra protection! or just to say hi :)

take care, and good luck with the repair ..

Dave

> 
> We are getting the following error when we try to post comments:
> 
> user error: Can't open file: 'watchdog.MYD'. (errno: 145)
> query: INSERT INTO watchdog (uid, type, message, severity, link, location,
> hostname, timestamp) VALUES (4, 'content', 'Comment: duplicate <em>Test</em>.',
> 1, '', '/?q=comment/reply/1', '24.125.75.112', 1153111107) in
> /home/httpd/vhosts/climateimc.org/httpdocs/includes/database.mysql.inc on line 66.
> 
> I don't have any way of looking into the database right now.
> 
> Jim Nelson
> Climate IMC
> - --
> GPG key available
> gpg --keyserver pgp.mit.edu --recv-keys 06B386612
> 
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.4 (GNU/Linux)
> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
> 
> iD4DBQFEuwPvXxNjpms4ZhIRAokCAJY+9t5No5kzvG/JWL9e/27dViRaAJ41ob9v
> 5KbwnDIg9j6ahKq/X223Ow==
> =muEe
> -----END PGP SIGNATURE-----