Ξ welcome to cryptostorm's member forums ~ you don't have to be a cryptostorm member to post here Ξ
∞ take a peek at our legendary cryptostorm_is twitter feed if you're into that kind of thing ∞
Ξ we're rolling out voodoo network security across cryptostorm - big things happening, indeed! Ξ
Ξ any OpenVPN configs found on the forum are likely outdated. For the latest, visit GitHub Ξ

Forum instability of late

Looking for a bit more than customer support, and want to learn more about what cryptostorm is , what we've been announcing lately, and how the cryptostorm network makes the magic? This is a great place to start, so make yourself at home!
User avatar

Topic Author
df
Site Admin
Posts: 266
Joined: Thu Jan 01, 1970 5:00 am

Forum instability of late

Postby df » Sun Aug 02, 2015 9:10 pm

Just wanted to reassure everyone that the recent SQL errors some people have noticed on the forum is NOT an attack against the website.

The error:
Table ‘phpbb_sessions’ is marked as crashed and should be repaired

Is caused by a change cPanel made to the MySQL database structure when we moved everything from the old Datacell server to this new Leaseweb.de one. On the old server we forced cPanel not to update because it was doing too many things we didn't like, and we are planning to get rid of cPanel anyways. So on the new server the structure on most databases got pretty screwed up. I've tried to manually fix most of it, but there's still some residual problems.

Eventually we'll move off of this Leaseweb server to somewhere else (without cPanel), which isn't as easy as it sounds. cPanel likes to put a strangle hold on almost every service, making moves to a non-cPanel server a little harder. The final setup after the next move will probably involve VMs (KVM), having things like the websites and the email servers separated for security, also because it will make it easier to do live migrations of a single service (like email) to another network.

Also, I added a script to cronjob (runs every minute) that will notify us when another one of these forum errors pops up, so we don't have to wait for someone to tell us the forum is down. For the curious, the script is:

Code: Select all

#!/bin/bash
if wget -SO- cryptostorm.org 2>&1|grep "General Error"; then
 if wget -SO- cryptostorm.org 2>&1|grep "marked as crashed and should be repaired"; then
  mysql csorg_phpbb -e'REPAIR TABLE phpbb_sessions'
 else
  echo "Forum is spitting out SQL errors, and it's not the phpbb_sessions thing" | mail -s "Forum is screwed up" df@cryptostorm.is
 fi
fi

EDIT: Added more code to the above script to make it check for the mysql.sock error that was on the forum earlier today, but that error causes the website to respond with "HTTP/1.1 503 Service Unavailable" instead of the normal "HTTP/1.1 200 OK". Problem is that the autofixing script uses wget, and wget stops trying to read the webpage if it gets anything but "HTTP/1.1 200 OK". So gotta modify the above a bit...

Oh and as for the mysql.sock error earlier this morning, PJ did that, so feel free blame him :-P

User avatar

parityboy
Site Admin
Posts: 1013
Joined: Wed Feb 05, 2014 3:47 am

Re: Forum instability of late

Postby parityboy » Sun Aug 02, 2015 9:37 pm

@df

Thanks for the update. Question: how is cPanel related to phpBB? Since you have root access to the server, could you not simply place phpBB in a jail along with its attendant web server (nginx?) and DB and administer it separately?

Oh, and PJ: you are hereby ordered to self-flagellate as an atonement for your naked transgression(s). :P

User avatar

Topic Author
df
Site Admin
Posts: 266
Joined: Thu Jan 01, 1970 5:00 am

Re: Forum instability of late

Postby df » Sun Aug 02, 2015 10:34 pm

We could put it in a jail/chroot, but the cPanel problems will continue.
Better to just move it off onto a proper VM.

User avatar

rwilcher
Posts: 32
Joined: Sun Apr 26, 2015 7:46 pm
Contact:

Re: Forum instability of late

Postby rwilcher » Tue Aug 04, 2015 4:18 pm

Anyone experiencing logins problems into cstorm? Was fine
yesterday but hangs at logging into darknet. Retries after
60 secs.

User avatar

rwilcher
Posts: 32
Joined: Sun Apr 26, 2015 7:46 pm
Contact:

Re: Forum instability of late update.

Postby rwilcher » Tue Aug 04, 2015 7:21 pm

Got things to work by changing to us - west endpoint in the widget.
Dont really know why the one I have been using won't authenticate any more.


Return to “cryptostorm in-depth: announcements, how it works, what it is”

Who is online

Users browsing this forum: Google [Bot] and 5 guests

Login