[terminator2k2]

hi there, ive got my new site up and running, but i am getting this error message in sourcemod, which also prevents anyone from even getting on the server...the server just crashes...:

06/07/2010 - 23:47:55: [SM] Plugin encountered error 25: Call was aborted
L 06/07/2010 - 23:47:55: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 06/07/2010 - 23:47:55: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 06/07/2010 - 23:47:55: [SM] [0] Line 566, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart()
L 06/07/2010 - 23:47:55: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 06/07/2010 - 23:47:55: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 06/07/2010 - 23:47:55: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[GrossKopf]

I have this running on my clan's website and I just installed it for my personal server and something I noticed is that the maps don't show up, even though I loaded those CSV files and ran the install (There was no update.php like the installer said to run).

Here's the link: http://l4dstats.proconhosting.com

What could I be doing wrong?

[.=QUACK=.Major.pain]

Originally Posted by terminator2k2 hi there, ive got my new site up and running, but i am getting this error message in sourcemod, which also prevents anyone from even getting on the server...the server just crashes...: 06/07/2010 - 23:47:55: [SM] Plugin encountered error 25: Call was aborted L 06/07/2010 - 23:47:55: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details. L 06/07/2010 - 23:47:55: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 06/07/2010 - 23:47:55: [SM] [0] Line 566, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart() L 06/07/2010 - 23:47:55: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) L 06/07/2010 - 23:47:55: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) L 06/07/2010 - 23:47:55: [admin-sql-prefetch.smx] Could not connect to database "default": [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Not knowing what you did or how you did your setup, I can see an issue of not connecting to the database.

Things to look at:
- double check your database.cfg to make sure you have the correct info.
- confirm you have the correct url in the database.cfg, by pinging the url.
(Click start>run and enter cmd and enter to open the cmd console. Type ping yoururl. Your url is the database url or ip if you use an ip. You should see several steps taken to reach the database successfully. If incorrect, you will see that it doesn't reach your database server, and you will have to check that.)
- Make sure you setup remotesql, to allow your gameserver access to your database. If not setup, your database server will continue to block the connection.

Just a few ideas to look at.

[.=QUACK=.Major.pain]

Originally Posted by GrossKopf I have this running on my clan's website and I just installed it for my personal server and something I noticed is that the maps don't show up, even though I loaded those CSV files and ran the install (There was no update.php like the installer said to run). Here's the link: http://l4dstats.proconhosting.com What could I be doing wrong?

The developer did away with update.php.
You just need to go to install.php now.

It is an install/update all in one.

If the table doesn't exist, it is created.
If the table exists and nothing is changed, nothing is done.
If the table exists and is different, it modifies the table.

[muukis]

Originally Posted by .=QUACK=.Major.pain That file is set to 777.

OK, then it's something else. I'll run a few tests.

[terminator2k2]

hi there, im still unable to get this to work.......

i get the following error after reinstalling sourcemod:

L 06/09/2010 - 12:59:17: Info (map "c1m1_hotel") (file "errors_20100609.log")
L 06/09/2010 - 12:59:17: [l4d_stats.smx] Failed to connect to database: [2003]: Can't connect to MySQL server on 'deadonarrival.eahosters.info' (110)
L 06/09/2010 - 12:59:17: [SM] Plugin encountered error 25: Call was aborted
L 06/09/2010 - 12:59:17: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 06/09/2010 - 12:59:17: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 06/09/2010 - 12:59:17: [SM] [0] Line 566, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart()


my databases.cfg looks like:

"Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
"l4dstats"
{
"driver" "mysql"
"host" "deadonarrival.eahosters.info"
"database" "chris2k2_doa"
"user" "chris2k2_chris2k"
"pass" "********"
"port" "3306"
}

}


ive set the webstats to accept the mysql data base and vice versa and also my game server ip addy is in the allowed list of my remote sql......

my webstats site is up and running but still my game server cant connect to my database......

its a free web host with mysql database and shares the same addy......

im really stuck now and keep going round in circles hehe.....

anyone help.?

cheers chris

[muukis]

Originally Posted by muukis Originally Posted by ".=QUACK=.Major.pain" That file is set to 777. OK, then it's something else. I'll run a few tests.

In my tests the file was generated like specified. Check your server time and the timestamp in the templates/awards_cache.html file.

Originally Posted by terminator2k2 ...

What are your system specs? Not interested in the HW. Can you test the connectivity with some other means from the game server? Console + telnet? Some MySQL DB explorer?

[.=QUACK=.Major.pain]

@muukis

Never mind, checked today, and the page is working now.


@muukis and terminator2k2

I did some looking, and found this issue is to do with linux servers.

to help others who have Linux. lib32z1 is needed. apt-get install lib32z1 did the trick for me if you dont have Access as Admin on the Dedicated server then you will need to contact your game host to get it solved

Got this here: http://warcraft-source.com/board/index.php?topic=8175.0

I would assume same cause even though it is for warcraft.

[muukis]

Originally Posted by .=QUACK=.Major.pain to help others who have Linux. lib32z1 is needed. apt-get install lib32z1 did the trick for me if you dont have Access as Admin on the Dedicated server then you will need to contact your game host to get it solved

Even though the error in that problem is different from what in this case the problem is, your post could be useful in other cases - Thanks!

Error from the problem you posted:

L 08/14/2009 - 13:52:14: [SM] Unable to load extension "dbi.mysql.ext.so": libz.so.1: cannot open shared object file: No such file or directory
L 08/14/2009 - 13:52:14: [wow.smx] MySQL Error: Could not find driver "mysql"

Error from the problem terminator2k2 posted:

L 06/09/2010 - 12:59:17: [l4d_stats.smx] Failed to connect to database: [2003]: Can't connect to MySQL server on 'deadonarrival.eahosters.info' (110)

You can google the error code 2003 and will find this page that will give you the cause of the error.

[DmanWCG]

I had the same problem for a while and I had to allow remote SQL with a "wild" (%) as the last IP number.