Connection problems.

[northstarmensfishingclub]

After the move I had an issue that we resolved by changing the server setting in Settings.php to localhost. Everything worked for for about a day and since then I get the following message whenever I try to check the page.

Connection Problems

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

 

[Gouri]

After the move I had an issue that we resolved by changing the server setting in Settings.php to localhost. Everything worked for for about a day and since then I get the following message whenever I try to check the page.

Connection Problems

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

Hi,

goto mysql databases in your Cpanel and

drop user(Don't delete user or database) then
re assign the user to database by giving all privileges

And check the forum.

 

[northstarmensfishingclub]

I tried that a few days ago. I just tried it again. Still having the connection problem

 

[northstarmensfishingclub]

Removing and re-adding the user is not fixing the problem. My site was working briefly a couple of days ago, so it has been functional since the move.

 

[Gouri]

Removing and re-adding the user is not fixing the problem. My site was working briefly a couple of days ago, so it has been functional since the move.

Are you able to see the database and tables in your phpmyadmin.

 

[northstarmensfishingclub]

Yes, I can see the db and am able to view it's structure table

 

[Gouri]

Yes, I can see the db and am able to view it's structure table

Just confirm that you are using the correct database information. check in your settings.php

########## Database Info ##########
$db_server = 'localhost';
$db_name = 'cpanelusername_databsename';
$db_user = 'cpanelusername_databaseusername';

 

[northstarmensfishingclub]

Not quite

$db_server = 'localhost';
$db_name = 'jakelamb_smf';
$db_user = 'jakelamb_smf';

Where jakelamb is the cPanel username and smf is the database

Should the last entry be

$db_user = 'jakelamb_jakelamb_smf';

where jakelamb_smf is the db username?

Edit: tested the above fix, still getting the connection problem message

 

[Gouri]

Not quite

$db_server = 'localhost';
$db_name = 'jakelamb_smf';
$db_user = 'jakelamb_smf';

Where jakelamb is the cPanel username and smf is the database

Should the last entry be

$db_user = 'jakelamb_jakelamb_smf';

where jakelamb_smf is the db username?

No, no change, the above information is correct. means jakelamb_smf is correct if you given smf while creating the database it will be jackelamb_smf.

 

[Gouri]

Check your "remote mysql" in your cpanel whether it set a %

 

[northstarmensfishingclub]

No, it's not using the % wildcard. It lists three access hosts and that's all.

 

[Gouri]

No, it's not using the % wildcard. It lists three access hosts and that's all.

Add % then try to access the site.

 

[northstarmensfishingclub]

Added %, still getting the same error.

 

[Gouri]

Added %, still getting the same error.

Try to use the repair_settings.php file. It is available at http://www.simplemachines.org/community/index.php?topic=18096.0

 

[northstarmensfishingclub]

ok, will give it a try and post back. it will have to wait for a bit.

 

[descalzo]

Removing and re-adding the user is not fixing the problem. My site was working briefly a couple of days ago, so it has been functional since the move.

You have to make sure to check ALL PRIVILEGES when that screen comes up. It is unchecked by default.

 

[northstarmensfishingclub]

Have tried that a number of times. Still no luck.

 

[Gouri]

Have tried that a number of times. Still no luck.

Did you tried the repair_settings.php ?

 

[northstarmensfishingclub]

not yet. the computer i am currently on is behind a firewall that will not let me download the file. i will do so this evening. thanks for the help.

 

[northstarmensfishingclub]

ok, finally got some time to do this. ran the repair_setting.php and everything matched the recommended settings. however I got an error message at the top of the page that reads:

Some settings are not being shown because the MySQL connection information is incorrect


In the remoteSQL section of cPanel I have a fourth entry under the Access Hosts

mysql-boru.x10hosting.com

could this be causing the issue?