Connection problems

[FLORAMARILLA]

Hi,

I am writing to ask you for help, because since yestarday I have not been able to enter my forum.
It says:

Connection Problems

Sorry, SMF was unable to connect the database. This may be caused by the server being busy. Please try again later.

[Suki]

Welcome to SMF

It may help if you provide some more info about your issue, perhaps your forum url and host you're using.

[FLORAMARILLA]

The URL is http://www.federicoamador.com.ar/foro/ [nofollow] and I use Fanfusion.

[Suki]

Well, you're using a free hosting, chances are that your server has some issues and that's why SMF cannot connect properly.

Ask your hosting about this.

[FLORAMARILLA]

Fanfusion said they didn't host this.

I haven't been able to enter for 2 day, I'm getting the same message, please tell me what to do, because I want my forum back!!!!!!

[Suki]

So, your own host says that they aren't hosting your site?


There is not much you can do except changing your host, free hosting often comes with limitations.

[FLORAMARILLA]

Yes, they host my website, I think they meant that they didn't host the forum. Please give me a useful answer, you have to know what to do in such cases.

[Illori]

if your host will not give you, your files and database there is nothing we can do to help you.

and this issue is an issue with the server so there is nothing we can do to help you further.

[Suki]

The error isn't SMF related, that is, the problem is not SMF, is your host who has issues and SMF cannot connect with your database.

That is why I told you there is nothing you can do but to change hosting.

Feel free to ask in your Native language support board: Español (Spanish)

[FLORAMARILLA]

Well, in Cpanel I added a new user to my forum database and in the file repair_settings.php I added the new data. The problem is that only the index page appears,if I click on something, for example "register" it says that the page could not be found. Why?

[Suki]

Use the repair_settings file to change your urls, your main url is domain/forum/  but all of your urls are domain/

[FLORAMARILLA]

It's okay now,but now I can't enter the forum with my old username.

[Suki]

If you used a brand new database, then you must log in with the account that you created when installed SMF, the old account isn't available anymore.

[FLORAMARILLA]

I forgot the password of the database I created while installing SMF. How can I get it?

[Suki]

Take a look at your Settings.php file, that file contains your database info.

[FLORAMARILLA]

It contains the dates of the new database and I need the password of the old one. It said "root"

[Suki]

Then check in your host panel.  on your host panel you should be able to change the password of the old database with a new one.

[FLORAMARILLA]

in Cpanel you mean?

I tried it,but I need the old password to create a new one...

[Suki]

You can create a new user with a new password and then add this new user to the old password with all privileges.

[FLORAMARILLA]

In repair_settings.php I set the new mysql username and password, but I can't enter the forum with them. I need to find a solution,because I'm the administrator. Which username shall I use to enter??

When I installed SMF I registered with another name and made myself administrator. Then I deleted the profile of the user I set in SMF installation. As I saw,the other users can enter,so I don't understand why I cannot enter.

[Suki]

your username in the forum is not the same  as the mysql user

go to your cpanel

create a new myslq user and password

save that user and password

select the newly created user  and add it to your old database with all privileges

enter repair_settings and in the mysql user enter the newly created user

do the same for password.


now you can enter your forum with the old forum username

I strongly suggest you to post in the Spanish boards.

[emmanova]

Ok Im glad I found this so I dont have to open a new thread. A bit if story first.

I am a Reseller Hosting (meaning I got a shared server that I can resell spaces to host other people websites.) My previous hosting provider was Resellers Panel, website was running great there but I started to get hacked not only to my site but to a lot of sites I am hosting with them. Hacked in a way that they were getting into the root of each account. After a few weeks fighting with Reseller Panel and them telling me was my problem I decided to move my forum to Host Gator (well I was forced to, cause Reseller Panel suspended the domain and they didnt want to release it. So I created a full cPanel backup and HostGator restored it into their server. Nothing changed, exactly the same way it was at Reseller Panel it is now at Host Gator (no new addons)

Well site was working fine when out of nowhere I am getting the same connection problem. I though was something messed up on my settings maybe a hacker changed something, but by refreshing the site it went away so I let that pass. Days pass and site is working fine then out of nowhere again same connection error, sometimes refreshing works sometimes it doesnt. So is a random thing. Searching online for solutions, I went inside the SQL and deleted all the backup_"addons", inside SMF I ran database optimization, checked folder permissions, etc. The other thing I found is that when my forum goes down my main site doesnt, meaning I have a homepage with Wordpress installed at http://xecofl.com but the forum is installed at http://xecofl.com/forum so when the forum gives me the cannot connect to database is not the the whole site goes down cause I can access the home page.

Let me tell you about forum. Is an Automotive Event Forum for Florida, I barely have visitors because the members come check the events and leave, so normally I have between 2 to 4 members online per day. Only after we do an event is when I have maybe 7 to 10 members.

At this point I chat with Host Gator and you will never guess what they think is wrong. Ah never mind Im sure you guess it. Yes they say the problem is with my site and not the server. So here is there excuses so far:


Host Gator   -  My Answers
1. You may have permission problems - Already Checked and Im not
2. You are getting a lot of traffic - No I don't I created an htaccess that blocks every IP except United States so I can keep hackers away. Maximum users are 10, regular users are 2 to 5. Also I checked the bandwidth of the server and is around 4% to 7%
3. You may be using too much CPU - No, I checked the Status of the Server and eveything is Status OK, when the site is completly down.
4. Maybe an Addon is causing the problem - I dont think so because I had the same addons from the other hosting provider and never got this problem
5. You may want to enale caching - Why? I dont have that much traffic?

So after all this BS. I demand for them to tell me what the server is reporting when this goes down, since when the site goes down, I check the server and ecerything is Status OK. So I asked them to check the Server Log which I cannot see and tell me what is triggering the problem. Their answer is "there is no error in the Apache Log"

So my problem: Host Gator says I have to enable caching and that the problem is my site. These are my addons btw

1.   Google Member Map    2.0.10     [ Uninstall ] [ List Files ] [ Delete ]
2.   Admin Notepad    2.0.1     [ Uninstall ] [ List Files ] [ Delete ]
3.   SMF 2.0.2 Update    1.0     [ Uninstall ] [ List Files ] [ Delete ]
4.   Member Color Link    3.1     [ List Files ] [ Delete ]
5.   Aeva Media    1.4c     [ Uninstall ] [ List Files ] [ Delete ]
6.   Tapatalk SMF 2.0 RC4/RC5/Final Plugin    3.0.0     [ Uninstall ] [ List Files ] [ Delete ]
7.   Treasury    2.10     [ Uninstall ] [ List Files ] [ Delete ]
8.   FB & Twitter Sharer Mod 2.0    2.0     [ List Files ] [ Delete ]
9.   SimplePortal    2.3.4     [ Uninstall ] [ List Files ] [ Delete ]
10.   SMF Garage    2.2     [ Uninstall ] [ List Files ] [ Delete ]
11.   Gamer IDs    1.4     [ Uninstall ] [ List Files ] [ Delete ]


Thanks in advance guys!

[Illori]

please open a separate thread for your issue, this thread belongs to someone else.

[emmanova]

please open a separate thread for your issue, this thread belongs to someone else.

Ok i don't get it. If i open a new thread with the same message and same problem I will get bombarded by "search the forum before create a new thread" now I get told create a new thread cause this one belong to someone else?

I'm getting the exact same error message SMS cannot access the database because the server is busy.

[Illori]

the way the support team works is 1 thread per person per topic, we dont want people to combine their issues into one topic or we cant make sure the issue is resolved and we cant easily track who we are helping so please open a separate topic.