Forum being shut down by Hosting Company Again!

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Pinkolyn
Registered User
Posts: 13
Joined: Mon Jan 13, 2020 8:36 pm

Forum being shut down by Hosting Company Again!

Post by Pinkolyn »

I've now been through 3 different hosting companies and after recently transferring my site and forum to a new hosting company, they just locked up my forum as did the others.

The reason they claim is some kind of SQL issues claiming I am not "managing" my forum correctly.

I had my forum online without problem or issue for 9 years. What I am hearing from them is that I need to convert my forum to some kind of Word Press extension.

I don't want to do this.

Apparently some kind of issue in the SQL is triggering an algorithm all the hosting sites use that causes automatic shut down of my site.

Anyone have a similar issue? Do I need to clean out some cache file in the forum phppb folders?

I have managed my site just using direct FTP uploads... not the newer cpanel or control panels the new hosting sites want me to be using.

They are basically saying they can't help me. I am with (hostgator) right now. Tech people have been friendly but not helpful.

Thanks

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69536
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Forum being shut down by Hosting Company Again!

Post by KevC »

That all sounds a bit vague. I'm not sure anyone can help without some specifics.

Your site is locked up how?
What SQL issues?
I don't see how converting a forum to wordpress 'works'. They're 2 different things.
What algorithm?
Shuts down the sites in what way?
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
david63
Registered User
Posts: 17041
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Forum being shut down by Hosting Company Again!

Post by david63 »

Pinkolyn wrote:
Mon Jan 13, 2020 8:50 pm
Apparently some kind of issue in the SQL is triggering an algorithm all the hosting sites use that causes automatic shut down of my site.
If that was true then this board would be full of similar posts.

Is this by any chance free hosting?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
obfuscated
Registered User
Posts: 34
Joined: Tue Dec 17, 2019 5:20 pm

Re: Forum being shut down by Hosting Company Again!

Post by obfuscated »

Maybe find a host that specifically provides support for phpbb?

Pinkolyn
Registered User
Posts: 13
Joined: Mon Jan 13, 2020 8:36 pm

Re: Forum being shut down by Hosting Company Again!

Post by Pinkolyn »

These are some excepts of what they sent me this morning about shutting down my site.
I know how to manage my phpbb site through the administrative log in.. but this stuff is way out of my expertise.

Hello,

Unfortunately, we have been forced to temporarily restrict access to MySQL for advanced on gator4113.hostgator.com.
You may try following the basic recommendations for optimizing your database.

a single hosting account may use no more than 25% of the entire server's resources. Accounts are typically not actively restricted until they exceed those resource limitations exceptionally. Unfortunately, in this instance, we were forced to place a temporary restriction on your user to prevent service issues with the server's over-all system performance.

CPU_TIME:265 table_rows_read:327646995 SELECTS:383 ROWS_UPDATED:122 ROWS_FETCHED:1779 BUSY_TIME:508 ONNECTED_TIME:508 BYTES_SENT:409600 BYTES_RECEIVED:89696 WAIT_TIME:243

Top table row reads:
DB_USER: advanced_app -- TOTAL_CONNECTIONS: 46 -- CONNECTED_TIME: 508 -- CPU_TIME: 265 -- TABLE_ROW_READS: 327646995 -- SELECT_COMMANDS: 383 -- UPDATE_COMMANDS: -- BUSY_TIME: 508 -- BYTES_SENT: 409600 -- BYTES_RECEIVED: 89696 -- WAIT_TIME (IO): 243

Top WAIT (IO) TIME:
DB_USER: advanced_app -- TOTAL_CONNECTIONS: 46 -- CONNECTED_TIME: 508 -- CPU_TIME: 265 -- TABLE_ROW_READS: 327646995 -- SELECT_COMMANDS: 383 -- UPDATE_COMMANDS: -- BUSY_TIME: 508 -- BYTES_SENT: 409600 -- BYTES_RECEIVED: 89696 -- WAIT_TIME (IO): 243

User avatar
JoshyPHP
Code Contributor
Posts: 1075
Joined: Mon Jul 11, 2011 12:28 am

Re: Forum being shut down by Hosting Company Again!

Post by JoshyPHP »

You need to ask them what queries specifically take too long, otherwise it's a wild-goose chase.

Also, you didn't post the thing so I'd bet there is some crucial information that you did not post. The numbers in the report you posted don't make sense for a normal installation, there is something particularly wrong with your forums and unless you provide absolutely all the details related to your installation, people could spend months throwing random guesses.
I wrote the thing that does BBCodes in 3.2.

User avatar
bubbathegimp
Registered User
Posts: 81
Joined: Tue Sep 25, 2018 8:02 pm
Location: Bronston
Name: Robert Anderson
Contact:

Re: Forum being shut down by Hosting Company Again!

Post by bubbathegimp »

Sooo....how many daily users do you have? sounds like they are complaining that you are using too many resources..
rogue app?
too many "guests" aka crawlers/bots abusing the board??

I'm on Hostgator,and rarely use their CPanel. do most of what I need to using CoreFTP...
Hostgator does support PhpBB, and supplies a quick install (but their version is Ancient)
Old enough to remember when Water was free, and you had to pay for Porn :o

User avatar
obfuscated
Registered User
Posts: 34
Joined: Tue Dec 17, 2019 5:20 pm

Re: Forum being shut down by Hosting Company Again!

Post by obfuscated »

Pinkolyn wrote:
Mon Jan 13, 2020 10:32 pm
You may try following the basic recommendations for optimizing your database.
How large is your database? Does it have any copied tables? Years worth of logs? No longer needed migration tables?

User avatar
obfuscated
Registered User
Posts: 34
Joined: Tue Dec 17, 2019 5:20 pm

Re: Forum being shut down by Hosting Company Again!

Post by obfuscated »

Pinkolyn wrote:
Mon Jan 13, 2020 8:50 pm
I have managed my site just using direct FTP uploads... not the newer cpanel or control panels the new hosting sites want me to be using.

They are basically saying they can't help me. I am with (hostgator) right now. Tech people have been friendly but not helpful.

You need to login and use phpMyAdmin or whatever they have and look at your database. You probably have some junk accumulated for running it for 9 years that needs to be cleaned.

I ran into a similar thing with a mediawiki database and for what it's worth the support at dreamhost lifted a finger to take a look at it and help fix it up. I'm running a number of forums on the same account and have not had any issues.

KYPREO
Registered User
Posts: 223
Joined: Fri Feb 02, 2018 9:56 am
Contact:

Re: Forum being shut down by Hosting Company Again!

Post by KYPREO »

bubbathegimp wrote:
Tue Jan 14, 2020 12:54 am
too many "guests" aka crawlers/bots abusing the board??
This is where I would start looking.
phpBB user since 2002
www.AusRotary.com

User avatar
obfuscated
Registered User
Posts: 34
Joined: Tue Dec 17, 2019 5:20 pm

Re: Forum being shut down by Hosting Company Again!

Post by obfuscated »

KYPREO wrote:
Tue Jan 14, 2020 2:04 am
bubbathegimp wrote:
Tue Jan 14, 2020 12:54 am
too many "guests" aka crawlers/bots abusing the board??
This is where I would start looking.
Login via SSH and run a command like

cat yourlogs.txt | grep -oE "\b([0-9]{1,3}\.){3}[0-9]{1,3}\b" | sort | uniq -c | sort

This should print a sorted list of how many times each ip addressed your site.. should reveal pretty quickly if there specific ip's that are crawling your site and then check to see if they are users or known crawlers and then use your .htaccess file to block them.

Pinkolyn
Registered User
Posts: 13
Joined: Mon Jan 13, 2020 8:36 pm

Re: Forum being shut down by Hosting Company Again!

Post by Pinkolyn »

The site itself is large with content... jpg's, pdf files, a few videos files.. but not a lot of users online. Usually between 10 and 40 at any given time.
It's not crazy overloaded.

Hostgator seems to think the problem is a mySQL database management issue.
I have never ever managed anything in there. I only have managed the backside of my forum going through the Admin login.
I don't know much about PHP other than that is the software that needs to be installed on these hosting servers to read or run phpbb language?

Is there a cache file that can be emptied or should be from time to time?
They said something about optimizing the databases. I have no idea what that is or how to do it.

I am only reaching out here because I don't know the answers, they (hostgator) can't seem to fix it.. and my forum since 2009 has been phpbb based
on PHP.

thanks

User avatar
bubbathegimp
Registered User
Posts: 81
Joined: Tue Sep 25, 2018 8:02 pm
Location: Bronston
Name: Robert Anderson
Contact:

Re: Forum being shut down by Hosting Company Again!

Post by bubbathegimp »

In the Hostgator Cpanel scroll down to Databases, look for MySql Databases and click on it..
scroll down to modify databases
click on the box that says repair database..
only takes a few seconds.
back on the main menu, scroll down to software, click on optimize website.
check compress all content.....
Old enough to remember when Water was free, and you had to pay for Porn :o

Pinkolyn
Registered User
Posts: 13
Joined: Mon Jan 13, 2020 8:36 pm

Re: Forum being shut down by Hosting Company Again!

Post by Pinkolyn »

Thanks,

That was easy enough to follow.
I was able to compress the content.

I hope I can get them to turn the site back on to see if this works.

They gave me a 45 day guarantee on the site. Today is day 43 so I might have to ask for a refund if they can't get the site back online again

User avatar
bubbathegimp
Registered User
Posts: 81
Joined: Tue Sep 25, 2018 8:02 pm
Location: Bronston
Name: Robert Anderson
Contact:

Re: Forum being shut down by Hosting Company Again!

Post by bubbathegimp »

you might want to go onto the online chat, and remind them of that....
I have been a bit disappointed with Hostgator.

I ran OWasp zed attack proxy against my site, and it came up with a few things i was unable to resolve... Unable to set security features recommended by the scan such as suppressing server software version info that can be used to help attack my site.
backup file disclosure (I cant even find them in file manager to delete them)
unable to set content security policy header
unable to turn on web browser xss protection
Feature policy headers (Load balancing)...
etc etc...
Old enough to remember when Water was free, and you had to pay for Porn :o

Post Reply

Return to “[3.2.x] Support Forum”