Connection Problems

[dopetek]

Connection Problems
Hi,

I am getting this error when loading my site.

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

Is this because I am currently using free hosting?

 

[Dead-i]

Hi dopetek,

You will need to alter your SMF forum's configuration so that the database details match the database you have created in your cPanel. You can do this by editing your Settings.php file.

Please see this wiki article for further information on setting up MySQL.

Thank you,

 

[dopetek]

Thanks for yet another reply. Please help me with this. I have no idea what I am doing.


I have downloaded settings.php from the root of the server.

 

[Dead-i]

Hi dopetek,

If you have already created your MySQL database, you will need to change the "$db_name", "$db_user" and "$db_passwd" lines in your Settings.php file accordingly.

Thank you,

 

[dopetek]

Thank you. Yes I had a database that was working. Is this MySQL® Databases the place I need to go on the cpanel?

 

[Dead-i]

Hi dopetek,

Yes. From there, you can see your database name and the username you will need to put in Settings.php.

Thank you,

 

[dopetek]

My settings.php now looks like this.
########## Database Info ##########
$db_type = 'mysql';
$db_server = 'localhost';
$db_name = 'fibx10m2_FIB';
$db_user = 'DTeK';
$db_passwd = 'mypassword here';
$ssi_db_user = '';
$ssi_db_passwd = '';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;


At the bottom of the cpanel MySQL Databases page it says Users then has this fibx10m2_FI. Half way down the page it has this
MySQL Users
Add New User Username: fibx10m2DTeK


Whick one do I put in settings.php?

 

[dopetek]

Can I send you the details in private please? Thank you so much for your help, I would be totally lost.

 

[Dead-i]

Hi dopetek,

In that case, you will need to use fibx10m2_FIB as your database username.

Thank you,

 

[dopetek]

I uploaded this but it still does not load

########## Database Info ##########
$db_type = 'mysql';
$db_server = 'localhost';
$db_name = 'fibx10m2_FIB';
$db_user = 'fibx10m2_FIB';
$db_passwd = 'my password';
$ssi_db_user = '';
$ssi_db_passwd = '';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;

 

[Dead-i]

Hi dopetek,

The current value of $db_passwd in Settings.php is incorrect. Please could you try resetting the password for the database user "fibx10m2_FIB" and try again?

Thank you,

 

[dopetek]

If I click rename from the bottom of the page it confirms the current database user name is fibx10m2_FIB


Changing password now.

 

[dopetek]

Password changed and I have access to my portal page. The images from the database are no longer there though and I can't load the login page or any of my forum pages.

 

[dopetek]

My portal page says there are items in the database. is it ok for me to keep posting new posts or do I need to edit my previous posts to add information. I don't want to anger anyone

 

[Dead-i]

Hi dopetek,

It looks like the board URL specified in Settings.php was also incorrect. Sorry I didn't pick up on that earlier. I've changed it for you; please could you try again?

Thank you,

 

[dopetek]

Ahhhh well I just uploaded the settings.php I backed up last night. It had a whole chunk of extra information. I think that somehow my settings.php from the root was deleted or reset over night. It worked fine when I went to bed. I changed only the password on the backed up settings.php and it works fine.

Actually it was working fine an hour ago when I looked at it on my phone.


Thank you so very much for all your help. If there is anything I can do for you please let me know. Are you staff here?

 

[Dead-i]

Great to hear everything's back up and running!

Are you staff here?

Yes, I'm part of the free hosting support staff.

Thank you,

 

[dopetek]

Well you're wonderful and I hope you get paid for this either in money or gratitude.