Connection Problems..

[Suke]

Connection Problems

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

Thats what it says, it was working fine until I changed my password for my Cpanel.. what did I do wrong, and how do I fix it? I haven't made a backup in a while... so I can't put my forum back up from a backup. I juss wanna know how to get it back online.

[Gary]

Check your settings.php file and make sure that all the details are correct.

-AwwLilMaggie

[Suke]

Where would I check it? In my PhpMyAdmin you mean? Should I post what is in it?

[Gary]

No. I mean in your settings.php file in your SMF folder in the FTP.

-AwwLilMaggie

[woden]

Change the password in Settings.php to match what you changed it to in cpanel.

[Suke]

No. I mean in your settings.php file in your SMF folder in the FTP.

-AwwLilMaggie

Lol. Sorry, My bad.

Code Select Expand

<?php
/******************************************************************************
* Settings.php                                                                *
*******************************************************************************
* SMF: Simple Machines Forum                                                  *
* Open-Source Project Inspired by Zef Hemel ([email protected])                *
* =========================================================================== *
* Software Version:           SMF 1.0                                         *
* Software by:                Simple Machines (http://www.simplemachines.org) *
* Copyright 2001-2005 by:     Lewis Media (http://www.lewismedia.com)         *
* Support, News, Updates at:  http://www.simplemachines.org                   *
*******************************************************************************
* This program is free software; you may redistribute it and/or modify it     *
* under the terms of the provided license as published by Lewis Media.        *
*                                                                             *
* This program is distributed in the hope that it is and will be useful,      *
* but WITHOUT ANY WARRANTIES; without even any implied warranty of            *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.                        *
*                                                                             *
* See the "license.txt" file for details of the Simple Machines license.      *
* The latest version can always be found at http://www.simplemachines.org.    *
******************************************************************************/

########## Maintenance ##########
# Note: If $maintenance is set to 2, the forum will be unusable!  Change it to 0 to fix it.
$maintenance = 0; # Set to 1 to enable Maintenance Mode, 2 to make the forum untouchable. (you'll have to make it 0 again manually!)
$mtitle = 'Maintenance Mode'; # Title for the Maintenance Mode message.
$mmessage = 'Ok faithful users...we\'re attempting to restore an older backup of the database...news will be posted once we\'re back!'; # Description of why the forum is in maintenance mode.

########## Forum Info ##########
$mbname = 'My Community'; # The name of your forum.
$language = 'english'; # The default language file set for the forum.
$boardurl = 'http://127.0.0.1/smf'; # URL to your forum's folder. (without the trailing /!)
$webmaster_email = '[email protected]'; # Email address to send emails from. (like [email protected].)
$cookiename = 'SMFCookie10'; # Name of the cookie to set for authentication.

########## Database Info ##########
$db_server = 'localhost';
$db_name = 'smf';
$db_user = 'root';
$db_passwd = '';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;

########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = dirname(__FILE__); # The absolute path to the forum's folder. (not just '.'!)
$sourcedir = dirname(__FILE__) . '/Sources'; # Path to the Sources directory.

########## Error-Catching ##########
# Note: You shouldn't touch these settings.
$db_last_error = 0;

if (file_exists(dirname(__FILE__) . '/install.php'))
header('Location: http://' . (empty($_SERVER['HTTP_HOST']) ? $_SERVER['SERVER_NAME'] . (empty($_SERVER['SERVER_PORT']) || $_SERVER['SERVER_PORT'] == '80' ? '' : ':' . $_SERVER['SERVER_PORT']) : $_SERVER['HTTP_HOST']) . (strtr(dirname($_SERVER['PHP_SELF']), '\\', '/') == '/' ? '' : strtr(dirname($_SERVER['PHP_SELF']), '\\', '/')) . '/install.php');

# Make sure the paths are correct... at least try to fix them.
if (!file_exists($boarddir) && file_exists(dirname(__FILE__) . '/agreement.txt'))
$boarddir = dirname(__FILE__);
if (!file_exists($sourcedir) && file_exists($boarddir . '/Sources'))
$sourcedir = $boarddir . '/Sources';

?>

I dunno if I'm meant to post that though... but is that right? And what do I change to make it match my Cpanel Password?

But also, it made me reset my Password to something like "10xbzyZN" but when I connect through FTP it's still like "MyPassWord" the original password...

[Gary]

Code Select Expand


########## Forum Info ##########
$mbname = 'My Community'; # The name of your forum.
$language = 'english'; # The default language file set for the forum.
$boardurl = 'http://127.0.0.1/smf'; # URL to your forum's folder. (without the trailing /!)
$webmaster_email = '[email protected]'; # Email address to send emails from. (like [email protected].)
$cookiename = 'SMFCookie10'; # Name of the cookie to set for authentication.


Code Select Expand


########## Database Info ##########
$db_server = 'localhost';
$db_name = 'smf';
$db_user = 'root';
$db_passwd = '';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;


There's why, you've not entered your MySQL info. If you havent already, I suggest that you run install.php

-AwwLilMaggie

[Suke]

This is teh second time it's happened lol. Can you plz direct me as to where I can Download JUST teh install.php file please? And thanks, you're a huge help!!

[Gary]

Hehe. You can just enter your info in the relative areas in the file and upload it, but I used to do it this way myself, just use the same info and you'll be back and running.

I've attached a copy of install.php just upload it to your SMF Directory.

-AwwLilMaggie

[Suke]

Unable to find crucial installation files in the directory of this script!

Please make sure you uploaded the entire installation package, including the sql file, and then try again.

Click here to try this step again.

Anything?

[Gary]

I realised shortly after that you're using 1.0.7, that one was for RC2.

My bad.

Here's the one for 1.0.7

-AwwLilMaggie

[Suke]

I realised shortly after that you're using 1.0.7, that one was for RC2.

My bad.

Here's the one for 1.0.7

-AwwLilMaggie

I had someone else Upgrade my forum from 1.0.7 to RC2 though, but if I'm not mistaken I still have 1.0.7 on my HDD, should I juss DL it from my server?

[Gary]

Do you have a back up of the database for 1.0.7? Coz if so, restore it and alter the settings.php file accordingly.

-AwwLilMaggie

[Suke]

I very much doubt it, I had to restore my pc, and it wiped alot of stuff.. It wiped my main account, and I lost loads of my site things, but It's still all on teh server, should I juss post what teh settings.php file on teh actual site says? Cuz It might be different from teh one I posted originally...

[Suke]

Code Select Expand

########## Maintenance ##########
# Note: If $maintenance is set to 2, the forum will be unusable!  Change it to 0 to fix it.
$maintenance = 0; # Set to 1 to enable Maintenance Mode, 2 to make the forum untouchable. (you'll have to make it 0 again manually!)
$mtitle = 'Maintenance Mode'; # Title for the Maintenance Mode message.
$mmessage = 'Ok faithful users...we\'re attempting to restore an older backup of the database...news will be posted once we\'re back!'; # Description of why the forum is in maintenance mode.

########## Forum Info ##########
$mbname = 'Masta-Gamerz'; # The name of your forum.
$language = 'english'; # The default language file set for the forum.
$boardurl = 'http://www.masta-gamerz.com/MgForum/index.php'; # URL to your forum's folder. (without the trailing /!)
$webmaster_email = '[email protected]'; # Email address to send emails from. (like [email protected].)
$cookiename = 'SMFCookie10'; # Name of the cookie to set for authentication.

########## Database Info ##########
$db_server = 'localhost';
$db_name = 'marksta_MG';
$db_user = 'MyUserName';
$db_passwd = 'MyPassWord';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;

########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = dirname(__FILE__); # The absolute path to the forum's folder. (not just '.'!)
$sourcedir = dirname(__FILE__) . '/Sources'; # Path to the Sources directory.

########## Error-Catching ##########
# Note: You shouldn't touch these settings.
$db_last_error = 0;

if (file_exists(dirname(__FILE__) . '/install.php'))
header('Location: http://' . (empty($_SERVER['HTTP_HOST']) ? $_SERVER['SERVER_NAME'] . (empty($_SERVER['SERVER_PORT']) || $_SERVER['SERVER_PORT'] == '80' ? '' : ':' . $_SERVER['SERVER_PORT']) : $_SERVER['HTTP_HOST']) . (strtr(dirname($_SERVER['PHP_SELF']), '\\', '/') == '/' ? '' : strtr(dirname($_SERVER['PHP_SELF']), '\\', '/')) . '/install.php');

# Make sure the paths are correct... at least try to fix them.
if (!file_exists($boarddir) && file_exists(dirname(__FILE__) . '/agreement.txt'))
$boarddir = dirname(__FILE__);
if (!file_exists($sourcedir) && file_exists($boarddir . '/Sources'))
$sourcedir = $boarddir . '/Sources';

?>

Is that better? It still doesn't work though..

[Gary]

Hmm... Maybe try the repair_settings.php tool which you can find on the converters page (why  It's there I dont know). Thats been known to sort things out.

-AwwLilMaggie

[Suke]

Can you please direct me to teh Converters page.. ?

[Gary]

Sure.

http://www.simplemachines.org/download/?converters

-AwwLilMaggie

[Suke]

Thanks, but what do I do with it?

[Gary]

Download it and upload it somewhere in your forum directory and run it in your browser. And make sure everything is honkey-dory.

-AwwLilMaggie

[Suke]

Run it in my browser? Whats teh Url?

[Gary]

Wherever you uploaded it to. eg: http://your-forum-url-here.com/repair_settings.php

-AwwLilMaggie

[Suke]

These are the settings most likely to be screwing up your board, but try the things below (especially the path and URL ones) if these don't help. You can click on the recommendded value to use it.

Is it meant to say that?

[Gary]

No. It's not. Obviously, one/some of the MySQL info is incorrect, I'd suggest that you'd check to make sure that the Database password, username and the database info itself is correct in your cPanel.

-AwwLilMaggie.

[Suke]

I fixed it all, thanks dude. I appreciate it alot... My Password that changed obviously changed it for everything. It works again, w00t!!

[Gary]

No problem, now if I were you, I'd delete repair_settings.php as keeping it is a major security risk.

-AwwLilMaggie

[Suke]

Yeah, it said that it was lol.

I deleted it, don't worry. Thanks again ~

[Gary]

Glad I was able to help.

-AwwLilMaggie

[bradleyjohnsonjr.us]

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

I am getting that message also...

[Gary]

This is old. Follow instructions in my previous posts.

[nonamediveclub]

I think I messed with my database password by accident and I do not remember it...what do I do?

[Aleksi "Lex" Kilpinen]

As the OP's problem is solved I'll mark this topic as such.

I think I messed with my database password by accident and I do not remember it...what do I do?

You probably have no other choice than to a) try creating a new password through your hosting control panel, or b) have your host do the same for you.