News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

SMF was unable to connect to the database

Started by bb99, December 26, 2017, 04:44:55 PM

Previous topic - Next topic

Aleksi "Lex" Kilpinen

Most probably it's not gone completely, but you might want to ask your host about that, and if they would be so kind as to make a dump of it for you to download.
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Just Another Member

Quote from: Aleksi "Lex" Kilpinen on December 27, 2017, 06:59:45 AM
SMF is basically first and foremost a database UI, and database operations are it's core...
No truer words were ever spoken! In fact that describes pretty much every modern CDS from WordPress and on.

When you think of it SMF (or WordPress) is just a state machine written in PHP that drops like a pinball through the database to land at the right content delivered. All the better than multiple balls can fall through the machine at the same time, up to the maximum threads the server CPU can handle (or time slices + threads).

To be honest I learned most of my corporate app job after I figured out SMF's architecture, studied the code and database until I could make mod packages that work. It's one thing to install SMF and have a forum, quite another to study that complex machine until you can modify it and add a new feature without breaking it. (I studied he mod packages the same way.) I took only one programming class in college (I majored in Lit and Psych) and all the rest was from looking over my brother's code and from a few mentors. (If you think about it, a major in Lit and Psyche is a pretty useless thing. Just what job does that qualify you for? None. Maybe marketing... that's still "none" for me.)

Since then I have written my own CDS where I heavily borrowed on the tricks I learned from figuring out how SMF works. Before then I was just writing static HTML/CSS pages. I can emulate static sites with my custom CDS, a handy tool when my customers want basically a static website. I just don't tell them their static website is really using the same code (even the same copy of the code, just only one copy of my CDS on my server) and all the customer has is a launch file to connect to their database. The rest gets handled by the common shared CDS code.

Just Another Member

Quote from: Pause on December 27, 2017, 06:58:32 AM
Quote from: Susan Addams on December 27, 2017, 06:51:25 AMI can't imagine any hosting provider having resource problems with just 4 forums unless their server is totally pooched.
Site5 is one of the many brands owned by EIG (Endurance International Group), so that should explain it.

I'd suggest it is probably best for OP to pick a new host, but to be careful not to go to another EIG brand (see https://researchasahobby.com/full-list-eig-hosting-companies-brands/).
I'll add to that, 1and1.com has some pretty good products although not the cheapest. I was with 1and1 for years before I got tired of their yearly price increases and found a dedicated server for only 30% more than their Unlimited package. And I have a true dedicated server, not a VPS. To be sure, a person who just wants a few forums is much better off with managed hosting than having the extra job of managing their own server.

I suggest that if the OP wants to change hosts, follow your advice along with googling something like "best shared hosting providers" and skip over the Google ads.

And for God's sake don't use GoDaddy.

Aleksi "Lex" Kilpinen

I have a VPS on Layershift, and while it costs me a pretty penny - I haven't had any big issues in years. Come to think of it, I think it's 10 years next week...
Oh, and internet reviews on shared hosts are not always a great idea - the web is filled with fake reviews, and paid charts sadly.
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Just Another Member

Well that's why I said to skip the paid advertising. But true you have to consider the source. I think if CNet or LifeHacker said something I'd believe them...

Probably personal reports here on the forum could be a very good source. Like my comment that I had reasonably good hosting at 1and1 for years. I'd still be there if I hadn't decided to move to a dedicated server. As I said, I'm paying only 30% more than my 1and1 Unlimited account, and I was surprised at how more quickly my sites now run. I hadn't realized how much a shared host slows you down.

Sir Osis of Liver

Quote from: Susan Addams on December 27, 2017, 07:59:28 AM
And for God's sake don't use GoDaddy.

Sounds like that would be a step up from current host.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Just Another Member

Quote from: Sir Osis of Liver on December 27, 2017, 11:28:51 AM
Quote from: Susan Addams on December 27, 2017, 07:59:28 AM
And for God's sake don't use GoDaddy.

Sounds like that would be a step up from current host.

LOLOL! I had to laugh at that one. Probably so! :)

bb99

Any webhosting that is good for SMF ? Someone who knows very well/good in SMF .

How come no one from here, open their web hosting business who are specialise in smf

Or anyone who can help me in moving it to another hosting and have the site running again ?


bb99

Quote from: Illori on December 28, 2017, 09:55:09 AM
try looking here https://www.simplemachines.org/community/index.php?board=155.0

Any one to recommend ? I need help in this to move host and get database not connect, server is busy please try again later. Into working mode.

Host that is good in smf forum problem and support which i need the most.

Thank you

Sir Osis of Liver

If you can pm access to your host account (url/username/password) I'll have a look. 
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

bb99

Quote from: Sir Osis of Liver on December 28, 2017, 03:20:10 PM
If you can pm access to your host account (url/username/password) I'll have a look.

PM sent. Thank you

Aleksi "Lex" Kilpinen

Did you ask your host if they could make the database dump for you?

There isn't much you can do yourself to the actual problem on shared hosting such you are using really.
As a temporary measure you could try to put your forum in to maintenance mode before trying to backup the database, but really it shouldn't have any impact to to your access from the hosting control panel.

A reminder about admin / ftp passwords etc.
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

bb99

Die lol. Their backup is corrupted and fail. They not able to restore the database before 25 dec for me.

Now is I have to find new hosting and rebuild my website again :(

I have the database 1 year ago. But funny thing is I not able to upload it into their server from cpanel.

I don't understand why also

Aleksi "Lex" Kilpinen

Well that sucks... :( Seems like your host royally screwed you over.
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

bb99

#35
Quote from: Aleksi "Lex" Kilpinen on December 29, 2017, 06:36:02 AM
Well that sucks... :( Seems like your host royally screwed you over.

Stay away from site5 , anyhow said my site too busy so not able to connect to database. Database is corrupted how to connect .

Even now I want to upgrade to their so call VPS, also no use. Database suddenly got problem after their server down. Backup also got problem. What can I do ? Nothing I can do. I have backup, but I am not able to upload from cpanel backup and restore.

bb99

#36
Even they restore from 2 Dec 2017 database also fail. If the database is faulty how come my site is running till 25 Dec 2017.

There is some problem with their side which I don't understand.

I try upload 1 year ago backup database cannot upload at all from cpanel backup download database also fail.

Who even encounter this before with your hosting ?

I go to myphpadmin , I cannot open any file at all.

4 smf forum with site5, each with it's own cpanel. Only 1 got problem which is 2.0.15 with ssl another 3 2.0.13 no ssl no problem running after 25 Dec server down. I didn't edit or do anything at all for December 2017.

I believe is their server problem.

Please avoid making sequential posts in short periods of time.  Use the modify button to add content instead in such circumstances.  I've merged some of your posts together to tidy up this topic - Iris.

Just Another Member

I swear I posted command line examples of how to access your database via SSH without involving your forum. Let me know if you have SSH access, and also if you know if they are running their server back end on the same shared machine or a different machine. You can usually tell because your MySQL parameters will be localhost if front end and back end are on the same machine. If so then you can backup and restore databases via command line commands. That would bypass any SMF issues completely.

I am sure you realize the folly of going from a crappy shared hosting account to a crappy VPS ac******. If you decide to move I suggest 1and1.com which is sort of expensive but at least they know what they're doing. I'm sure they backup their SQL sservers since I've never lost a database in many years with them. My only reason for leaving was because their unlimited account is unlimited only until you reach 50,000 files and they will never tell you that up front. I realized that for only 33% more I could have a dedicated server and I mean a real dedicated server not a VPS. For my curiosity sake would you post a link to your provider's site? I'd like to compare rates just for my curiosity. But please, have the sense to not expand operations with a provider that is plainly a loser.

Let me know if you think the SSH command line backup would help you and I'll post the command line examples that should extract your database from the MySQL server with no SMF required.

If I were you I'd be making plans on how to migrate to a different host. Oh also, if you post the link please tell me what plan you are on.

Illori

Quote from: Susan Addams on December 29, 2017, 10:15:48 AM
If you decide to move I suggest 1and1.com which is sort of expensive but at least they know what they're doing.

1 and 1 is an over sold host, i would never recommend anyone move to an overhold host. also i would not suggest anyone to use ssh, as most shared hosts dont allow ssh access.

Just Another Member

Quote from: Illori on December 29, 2017, 10:25:01 AM
1 and 1 is an over sold host, i would never recommend anyone move to an overhold host. also i would not suggest anyone to use ssh, as most shared hosts dont allow ssh access.
They worked fine for me until my Unlimited account smacked up against a 50,000 file limit that was hard coded. I was also annoyed that they always raise their prices on a continuing basis. My new dedicated server guaranteed  my rate would never change as long as I had the account.

And not use SSH, surely you jest. SSH and WinSCP (file transfer over SSH) are my two most important tools!

I've found SSH to be a very handy tool. I can't imagine why you would recommend not using one of your tools, especially when it's the right tool for the job. Care to explain?

Advertisement: