November 21, 2024, 05:37:56 PM
Forum Rules: Read This Before Posting


Topic: Today's databese connection problems  (Read 14974 times)

0 Members and 2 Guests are viewing this topic.

Offline Mitch

  • General Chemist
  • Administrator
  • Sr. Member
  • *
  • Posts: 5298
  • Mole Snacks: +376/-3
  • Gender: Male
  • "I bring you peace." -Mr. Burns
    • Chemistry Blog
Today's databese connection problems
« on: January 25, 2010, 09:45:28 PM »
Earlier today chemicalforums was under an extensive spam attack that timed out the MySQL database. Specifically the attack sent emails to non-existant @chemicalforums.com accounts and spun the server crazy. The vulnerability has been closed.
Most Common Suggestions I Make on the Forums.
1. Start by writing a balanced chemical equation.
2. Don't confuse thermodynamic stability with chemical reactivity.
3. Forum Supports LaTex

Online Borek

  • Mr. pH
  • Administrator
  • Deity Member
  • *
  • Posts: 27853
  • Mole Snacks: +1813/-412
  • Gender: Male
  • I am known to be occasionally wrong.
    • Chembuddy
Re: Today's databese connection problems
« Reply #1 on: January 26, 2010, 02:32:30 AM »
Any chances that identical attaks were reason for earlier problems?
ChemBuddy chemical calculators - stoichiometry, pH, concentration, buffer preparation, titrations.info

Offline Mitch

  • General Chemist
  • Administrator
  • Sr. Member
  • *
  • Posts: 5298
  • Mole Snacks: +376/-3
  • Gender: Male
  • "I bring you peace." -Mr. Burns
    • Chemistry Blog
Re: Today's databese connection problems
« Reply #2 on: January 26, 2010, 02:12:53 PM »
I'm not sure, but I doubt they were related.
Most Common Suggestions I Make on the Forums.
1. Start by writing a balanced chemical equation.
2. Don't confuse thermodynamic stability with chemical reactivity.
3. Forum Supports LaTex

Offline Mitch

  • General Chemist
  • Administrator
  • Sr. Member
  • *
  • Posts: 5298
  • Mole Snacks: +376/-3
  • Gender: Male
  • "I bring you peace." -Mr. Burns
    • Chemistry Blog
Re: Today's databese connection problems
« Reply #3 on: January 28, 2010, 01:19:06 AM »
From the service provider

Quote
We have seen instances of SMF forums causing errors, timeouts, etc. on every known kind of hosting platform (shared, reseller, vps, dedicated servers, cloud, etc, etc). We attribute it to the backdoor that SMF has (part of it is "Stats collection") , and the mayhem this current "restructuring" that they are doing is causing...
Most Common Suggestions I Make on the Forums.
1. Start by writing a balanced chemical equation.
2. Don't confuse thermodynamic stability with chemical reactivity.
3. Forum Supports LaTex

Online Borek

  • Mr. pH
  • Administrator
  • Deity Member
  • *
  • Posts: 27853
  • Mole Snacks: +1813/-412
  • Gender: Male
  • I am known to be occasionally wrong.
    • Chembuddy
Re: Today's databese connection problems
« Reply #4 on: January 28, 2010, 10:50:04 AM »
I wonder. Have you changed anything since installing new version of SMF? After upgrade everything was initially OK. So, either something happened later, or it took some time for the problems to grow up to the point when they started to be hard to miss. Whenever I see slow responses I attribute them initially to the web having hiccup in general - it happens now and then, so could be I have missed early symptoms of CF/SMF having problems.

If that's SMF - perhaps switching to other forum software will help? I know - that means troubles and it can be simply impossible if conversion of the database is not supported, but perhaps it is worth trying?
ChemBuddy chemical calculators - stoichiometry, pH, concentration, buffer preparation, titrations.info

Offline Mitch

  • General Chemist
  • Administrator
  • Sr. Member
  • *
  • Posts: 5298
  • Mole Snacks: +376/-3
  • Gender: Male
  • "I bring you peace." -Mr. Burns
    • Chemistry Blog
Re: Today's databese connection problems
« Reply #5 on: January 28, 2010, 02:09:51 PM »
That was the same advice the hosting service gave. I would like to wait one more week before deciding to switch us all over to something new.
Most Common Suggestions I Make on the Forums.
1. Start by writing a balanced chemical equation.
2. Don't confuse thermodynamic stability with chemical reactivity.
3. Forum Supports LaTex

Online Borek

  • Mr. pH
  • Administrator
  • Deity Member
  • *
  • Posts: 27853
  • Mole Snacks: +1813/-412
  • Gender: Male
  • I am known to be occasionally wrong.
    • Chembuddy
Re: Today's databese connection problems
« Reply #6 on: January 28, 2010, 04:29:29 PM »
I am not trying to give an advice - call it "thinking aloud" ;)
ChemBuddy chemical calculators - stoichiometry, pH, concentration, buffer preparation, titrations.info

Offline Mitch

  • General Chemist
  • Administrator
  • Sr. Member
  • *
  • Posts: 5298
  • Mole Snacks: +376/-3
  • Gender: Male
  • "I bring you peace." -Mr. Burns
    • Chemistry Blog
Re: Today's databese connection problems
« Reply #7 on: January 28, 2010, 05:23:31 PM »
The only newish thing is the "Good Chemistry Books" ads. I'll turn them off and see if that helps.
Most Common Suggestions I Make on the Forums.
1. Start by writing a balanced chemical equation.
2. Don't confuse thermodynamic stability with chemical reactivity.
3. Forum Supports LaTex

Offline Mitch

  • General Chemist
  • Administrator
  • Sr. Member
  • *
  • Posts: 5298
  • Mole Snacks: +376/-3
  • Gender: Male
  • "I bring you peace." -Mr. Burns
    • Chemistry Blog
Re: Today's databese connection problems
« Reply #8 on: January 29, 2010, 06:26:16 PM »
All amazon ad components that call for any data offsite have been turned off. Let me know if you seen an improvement or what not.
« Last Edit: January 30, 2010, 03:50:10 PM by Mitch »
Most Common Suggestions I Make on the Forums.
1. Start by writing a balanced chemical equation.
2. Don't confuse thermodynamic stability with chemical reactivity.
3. Forum Supports LaTex

Online Borek

  • Mr. pH
  • Administrator
  • Deity Member
  • *
  • Posts: 27853
  • Mole Snacks: +1813/-412
  • Gender: Male
  • I am known to be occasionally wrong.
    • Chembuddy
Re: Today's databese connection problems
« Reply #9 on: January 30, 2010, 03:13:56 PM »
At first it seemed like things were much better, but this have happened few minutes ago:

Quote
Page created in 183.237 seconds with 7 queries.

Doesn't necesarilly mean things are not better.

I am off for a week, will be back probably next Sunday.
ChemBuddy chemical calculators - stoichiometry, pH, concentration, buffer preparation, titrations.info

Online Borek

  • Mr. pH
  • Administrator
  • Deity Member
  • *
  • Posts: 27853
  • Mole Snacks: +1813/-412
  • Gender: Male
  • I am known to be occasionally wrong.
    • Chembuddy
Re: Today's databese connection problems
« Reply #10 on: February 23, 2010, 05:02:46 AM »
For the record: I don't remember seeing lags since I am back, that means over two weeks now.
ChemBuddy chemical calculators - stoichiometry, pH, concentration, buffer preparation, titrations.info

Offline Mitch

  • General Chemist
  • Administrator
  • Sr. Member
  • *
  • Posts: 5298
  • Mole Snacks: +376/-3
  • Gender: Male
  • "I bring you peace." -Mr. Burns
    • Chemistry Blog
Re: Today's databese connection problems
« Reply #11 on: February 23, 2010, 05:17:50 AM »
Same here, the server was down for a couple hours Feb. 17th, but after a reboot it was fine.
Most Common Suggestions I Make on the Forums.
1. Start by writing a balanced chemical equation.
2. Don't confuse thermodynamic stability with chemical reactivity.
3. Forum Supports LaTex

Sponsored Links