Server rentals :: NFOservers.com

Forums

All times are UTC - 8 hours



Author Message
PostPosted: Tue Jun 21, 2011 12:39 am 
Offline
New to forums
New to forums

Joined: Tue Jun 21, 2011 12:28 am
Posts: 3
Hello! We have a managed VPS from the great people here at nfo.

First, the error:
Quote:
L 06/20/2011 - 22:17:02: [sourcebans.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). See FAQ: http://www.sourcebans.net/node/20


This is from our game server, so I didn't know if I should put this topic here or in the game server section. I figured here because this use to work before we transferred over, and it appears to be an error on the web side. Anyway, the database.cfg that we were told to use is:
Quote:
"Databases"
{
"driver_default" "mysql"

"sourcebans"
{
"driver" "mysql"
"host" "localhost"
"database" "cwgfastdl_sb"
"user" "cwgfastdl"
"pass" "****"
//"timeout" "0"
"port" "3306"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
}


Background information:

We were using sourcebans from our old host, but for some reason we all thought it was on our website. Instead, it was on our game server box that we cancelled when we transferred over to here, so we lost that information. now we have almost no admin control over our servers, and it is starting to cause a headache!!!

I searched the forums, but I did not find much that helped. any ideas anyone? Thanks!!


Top
 Profile  
 
PostPosted: Tue Jun 21, 2011 10:31 am 
Offline
Founder
Founder
User avatar

Joined: Thu Apr 18, 2002 11:04 pm
Posts: 9222
Location: Seattle
Your databases.cfg is set up to connect to a local MySQL server, but we run our MySQL server separately for security and performance reasons. If you use the MySQL server that comes with our webhosting, you'll need to replace this line:

Code:
"host" "localhost"

With something like this:
Code:
"host" "hosted.nfoservers.com"

Replace "hosted.nfoservers.com" with the DNS to your website or with the actual hosted websites machine that you are on (hosted2, hosted3, etc).


Top
 Profile  
 
PostPosted: Tue Jun 21, 2011 12:58 pm 
Offline
New to forums
New to forums

Joined: Tue Jun 21, 2011 12:28 am
Posts: 3
I feel really dumb because it clearly says that in the sql home page, about using the DNS or whatever....


Awesome, It looks like its working! thank you so much!!!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
cron
It is currently Sun May 19, 2013 3:16 am
Powered by phpBB® Forum Software © phpBB Group