Connection Problems

Status
Not open for further replies.

dopetek

Member
Messages
53
Reaction score
1
Points
8
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

x10Hosting Support Ninja
Community Support
Messages
6,084
Reaction score
368
Points
83
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

Member
Messages
53
Reaction score
1
Points
8
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

x10Hosting Support Ninja
Community Support
Messages
6,084
Reaction score
368
Points
83
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

Member
Messages
53
Reaction score
1
Points
8
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

x10Hosting Support Ninja
Community Support
Messages
6,084
Reaction score
368
Points
83
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

Member
Messages
53
Reaction score
1
Points
8
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

Member
Messages
53
Reaction score
1
Points
8
Can I send you the details in private please? Thank you so much for your help, I would be totally lost.
 

Dead-i

x10Hosting Support Ninja
Community Support
Messages
6,084
Reaction score
368
Points
83
Hi dopetek,

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

Thank you,
 

dopetek

Member
Messages
53
Reaction score
1
Points
8
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

x10Hosting Support Ninja
Community Support
Messages
6,084
Reaction score
368
Points
83
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

Member
Messages
53
Reaction score
1
Points
8
If I click rename from the bottom of the page it confirms the current database user name is fibx10m2_FIB


Changing password now.
 

dopetek

Member
Messages
53
Reaction score
1
Points
8
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

Member
Messages
53
Reaction score
1
Points
8
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 :D
 

Dead-i

x10Hosting Support Ninja
Community Support
Messages
6,084
Reaction score
368
Points
83
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

Member
Messages
53
Reaction score
1
Points
8
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?
 
Last edited:

dopetek

Member
Messages
53
Reaction score
1
Points
8
Well you're wonderful and I hope you get paid for this either in money or gratitude.
 
Status
Not open for further replies.
Top