Forum

ASSIST, AMERICA'S ARMY COMMUNITY - RELIVE THE GLORY DAYS OF AMERICA'S ARMY 2.5

Author Topic: Connection Problems Sorry, SMF was unable to connect to the database.  (Read 4968 times)

0 Members and 1 Guest are viewing this topic.

Offline 82nd_DXO_COL=Shad

Connection Problems Sorry, SMF was unable to connect to the database.
« on: Monday, March 16, 2015, 21:19:52 PM »
aao25.com/vortex servers went down at 2100 EST as well as auth
« Last Edit: Tuesday, March 17, 2015, 00:07:03 AM by Nick »

Offline Spanky

  • <?php echo $opinion .' is better.'; ?>
  • Administrator
  • Posts like a Spanky!
  • *
  • Posts: 10,893
    • View Profile
    • NatesComp.com
  • AA: tigobitties
Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #1 on: Monday, March 16, 2015, 21:22:16 PM »
The SMF error is due to Assist going down and causing a timeout on the PHP scripts for this site. It's the stats code that refreshes every 5 minutes when the next page is requested (by any user). Problem was, PHP's get_headers waits for a response or times out after the default 30 or 60 seconds. Once that happens, the SMF database connection gets refused and throws an error.

I've re-worked the function (again, thought I fixed it before) and it looks like it's working despite Assist being down.
It's like shaving your pubes to make your junk look bigger.
Might look bigger, but it aint.....

Offline 82nd_DXO_COL=Shad

Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #2 on: Monday, March 16, 2015, 21:37:39 PM »
Always thought this was VBulletin.  fsocketopen routine with a $timeout might fail more gracefully

Offline Spanky

  • <?php echo $opinion .' is better.'; ?>
  • Administrator
  • Posts like a Spanky!
  • *
  • Posts: 10,893
    • View Profile
    • NatesComp.com
  • AA: tigobitties
Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #3 on: Monday, March 16, 2015, 21:48:48 PM »
Nope, highly customized SMF :) We're too cheap to pay for VBulletin.

I've had a hard time in the past getting connections to fail gracefully. I think I have used fsocketopen but the stat code currently on this site was rewritten by Jared and despite it having a fail check, it wasn't graceful. There's still a delay here, I've got the timeout set at 2 seconds. Might change it to 1 but it seems to be working fine.
It's like shaving your pubes to make your junk look bigger.
Might look bigger, but it aint.....

Offline Nick

  • Administrator
  • Loyal Member
  • *
  • Posts: 555
    • View Profile
Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #4 on: Tuesday, March 17, 2015, 00:06:34 AM »
aao25.com/vortex servers went down at 2100 EST as well as auth

I can confirm that there was not maintenance or downtime on Vortex Servers end.

Offline Spanky

  • <?php echo $opinion .' is better.'; ?>
  • Administrator
  • Posts like a Spanky!
  • *
  • Posts: 10,893
    • View Profile
    • NatesComp.com
  • AA: tigobitties
Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #5 on: Tuesday, March 17, 2015, 00:43:42 AM »
Well the CURL code was bogus, switched over to a fsocketopen and looks like everything works... properly. Thanks for reminding me of that function Shad.
It's like shaving your pubes to make your junk look bigger.
Might look bigger, but it aint.....

Offline Petrol

Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #6 on: Tuesday, March 17, 2015, 02:25:35 AM »
60$ is bit to much for what you need to keep this game alive.

Offline teddy_grizzly_bear

  • Used to be known as nobody
  • Administrator
  • Epic Poster
  • *
  • Posts: 5,699
  • what are you looking at?
    • View Profile
  • AA: teddy_grizzIy_bear
Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #7 on: Tuesday, March 17, 2015, 02:36:19 AM »
And you know this because?

It's not a number just thought out of thin air.
Our month server costs end up being around $60.00 USD a month. Anything you donate will go straight to server cost and will help keep Assist moving forward.
<image removed due to imgur stuff - probably for the best>

"Mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true." Bertrand Russell

Offline Possessed

  • bWpnRecoil == False;
  • Administrator
  • Epic Poster
  • *
  • Posts: 3,620
  • You suffer, but why?!
    • View Profile
  • AA: Possessed
Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #8 on: Tuesday, March 17, 2015, 03:20:43 AM »
And its mostly for the auth hosting, the costs would be higher if we didnt had a partner :D
Not much time ago, Sergio paid all costs by him self.
These things I have spoken unto you, that in me ye might have peace. In the world ye shall have tribulation: but be of good cheer; I have overcome the world.
John 16:33


Offline Spanky

  • <?php echo $opinion .' is better.'; ?>
  • Administrator
  • Posts like a Spanky!
  • *
  • Posts: 10,893
    • View Profile
    • NatesComp.com
  • AA: tigobitties
Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #9 on: Tuesday, March 17, 2015, 13:29:24 PM »
It's ONLY for the auth hosting. This website & the official game servers are sponsored by Vortex Servers. The work is volunteered.

I'm not sure what your point is, especially posting in this thread.
It's like shaving your pubes to make your junk look bigger.
Might look bigger, but it aint.....

Offline Petrol

Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #10 on: Tuesday, March 17, 2015, 15:08:19 PM »
60$ for auth is definitly to much.

Offline Spanky

  • <?php echo $opinion .' is better.'; ?>
  • Administrator
  • Posts like a Spanky!
  • *
  • Posts: 10,893
    • View Profile
    • NatesComp.com
  • AA: tigobitties
Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #11 on: Tuesday, March 17, 2015, 15:28:28 PM »
Instead of saying that, you could pretend to be helpful and ask how much bandwidth and disk space it uses, what kind of setup it is and recommend other hosts that might save us costs.
It's like shaving your pubes to make your junk look bigger.
Might look bigger, but it aint.....

Offline Nick

  • Administrator
  • Loyal Member
  • *
  • Posts: 555
    • View Profile
Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #12 on: Tuesday, March 17, 2015, 15:46:56 PM »
Instead of saying that, you could pretend to be helpful and ask how much bandwidth and disk space it uses, what kind of setup it is and recommend other hosts that might save us costs.

My offer still stands whenever we are ready to move the auth :)

Offline Petrol

Re: Connection Problems Sorry, SMF was unable to connect to the database.
« Reply #13 on: Wednesday, March 18, 2015, 08:44:41 AM »
Nope...

 

Download Assist

×

Download Game Client

Important: Battletracker no longer exists. However, old Battletracker accounts may still work. You can create a new 25Assist account here

Download Server Manager