Just wanted to get some advice from a couple of gurus before I go off half cocked and get irate with my host provider...
Cannot get to my board receive the following error.
Script:
Line#:
SQL Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Please verify that your MySQL server is running
SQL Error #: 2002
Query: Unable to connect to the database!

Just got this board working last month thanks to Rick with an upgrade/new install of 7.3?

Anyways I am by no means an expert but looks to me like this is on the server end??? Just wanted to check and see before I get the email from webhost provider tech support that proclaims it is a third party software problem..

http://www.challengeacademy.org/forum/ubbthreads.php

Thanks in advance to any advice given..

JT

Are you able to connect to the tables using what your host control panel has. Such as MyPHPAdmin?
If so ftp to the site. Then goto config.inc.php in the includes folder and double check your database settings. It should be the first couple of lines in the file.

I found config.php file what should I be looking for ????

Depending on the version the top few lines should have the path and MYsql database settings:
Make sure they are correct
DATABASE_SERVER' => 'path to Mysql server',
'DATABASE_USER' => 'user Id',
'DATABASE_PASSWORD' => 'database password',
'DATABASE_NAME' => 'database name',
'TABLE_PREFIX' => 'usually ubbt_ if you used default',

Ok I found the file and it is totally blank..looks like it was last modified this am around the same time I was initially checking the board... If I copy what the config.php file has in it is that the same???

JT

Well there is a lot more to the file than just the first few lines. Something must have happened to it. If you have a current backup I would restore it. If not then you need to double check at least a few more lines. Then you can go into your control panel and check the rest of it.
A few lines down you will find
'FULL_URL' => 'Full URL to Main Directory',
'BASE_URL' => 'Relative URL to Main Directory',
'FULL_PATH' => 'Absolute PATH to Main Directory',

Thanks Ruben,

The file is totally empty 0 kb...I will try the back up...
JT

Okay that file is usually fairly static unless you have changed settings since the last backup. So even if the file is months old as long as the paths are correct the control panel will open and you will need to update what has changed since then, The real important stuff is the paths and mysql table stuff I posted. Which can be corrected via notepad.
Once you do that you may still need to save things in the control panel such as the paths and URLs section to update the table

Looks like you are up again. I would for sure make a full backup after you are sure all is okay again.

Ruben you're a life saver

I updated the file using a back up and then went into cp and saved all the primary settings..

Now for the big question.. how does this type of thing happen???Is it a bug? something I may have set wrong???
I did not make any changes to any of the files i first noticed this morning that my page did not have "who's on line or any pictures that it usally has on it but the forms were there..I assumed slow down load times then as I purused the forms poof the sql problem...any ideas???


Thanks again for the assistance..
JT