[fantek]

Hi. I installed plugin on my L4D server and on this same serwer is MySQL datebases.
In game is every thing ok all is recording etc. but my Left 4 Dead Player Stats site is something wrong. Look:


My config.php

// MySQL information for L4D Stats DB $mysql_server = "89.xxx.xx.xx"; $mysql_db = "baza_2515"; $mysql_user = "baza_2515"; $mysql_password = "xxxxxxxxx"; $mysql_tableprefix = "baza_";

And my L4D datebase.cfg

"Databases" { "l4dstats" { "driver" "mysql" "host" "89.xxx.xx.xx" "database" "baza_2515" "user" "baza_2515" "pass" "xxxxxxxxx" //"port" "3306" }

What is te reason to this errors?

[muukis]

Originally Posted by fantek Hi. I installed plugin on my L4D server and on this same serwer is MySQL datebases. In game is every thing ok all is recording etc. but my Left 4 Dead Player Stats site is something wrong. Look: My config.php And my L4D datebase.cfg What is te reason to this errors?

This is the first thing that you should look into: Can't connect to MySQL server on '89.231.6.12'. Is your porn-warez.eu site also at the same machine? If not, you will have to use a DB account that is open for connections from your... web site. Using the same credentials from different sources (IPs) will not work unless you have set your DB account remote access filter properly.

[fantek]

Exactly. My DB is not on the same porn-warez.eu site machine.DB is on the serwer where I have got L4D serwer.I write to host admin where I've got l4d server to add IP acces (i check IP this coman in console: Ping porn-warez.eu) from my porn-warez.eu site and hi is do this.But i still this same errors

[@lex666]

Hello, I would like to thank you for the work made for this plugin.

But, I have a problem with custom map. In fact, I have add many custom map, and when I play with it, the plugin doesn’t work.

The plugin work perfectly in normal maps (map of the game), but it not work on custom map when I play on easy mod.

I does not understand why, can use me please.

List of custom maps :

• deadhightshool (I have play on, plugin doesn't work on easy mod)
• death sentence (I have play on, plugin doesn't work on easy mod)
• heavencanwaitl4d2 (no tested for the moment)
• midnightoil (I have play on, plugin doesn't work on easy mod)
• rotld_sbs_ls (no tested for the moment)
• shool_1_2 (no tested for the moment)
• suicideblitz2 (I have play on, plugin doesn't work on easy mod)
• tourofrerror (I have play on, plugin doesn't work on easy mod)
• zombie_caribbean (I have play on, plugin doesn't work on easy mod)

Sorry for my bad english

[sirphr]

Is my Database.cfg correct?

"Databases"
{
    "driver_default"        "mysql"
    
    // When specifying "host", you may use an IP address, a hostname, or a socket file path
    
    "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"                "66.71.242.130"
        "database"            "sbflifei_XXXX"
        "user"                "sbflifei_XXXX"
        "pass"                "XXXXXX"

    }  
}

Because i got this:

L 06/24/2011 - 03:51:23: [l4d_stats.smx] Failed to connect to database: [1045]: Access denied for user 'sbflifei_sbf'@'72.51.60.10' (using password: YES)
L 06/24/2011 - 03:51:23: [SM] Plugin encountered error 25: Call was aborted
L 06/24/2011 - 03:51:23: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 06/24/2011 - 03:51:23: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 06/24/2011 - 03:51:23: [SM]   [0]  Line 996, /home/groups/alliedmodders/forums/files/5/2/0/8/2/80462.attach::OnConfigsExecuted()

[muukis]

Originally Posted by fantek Exactly. My DB is not on the same porn-warez.eu site machine.DB is on the serwer where I have got L4D serwer.I write to host admin where I've got l4d server to add IP acces (i check IP this coman in console: Ping porn-warez.eu) from my porn-warez.eu site and hi is do this.But i still this same errors

Try connecting the DB server from the web site by other means but the web stats. Telnet or preferably some actual mysql client. Google the ways to connect your DB. I would like to know if you have something blocking the connections between the two servers.

Originally Posted by @lex666 Hello, I would like to thank you for the work made for this plugin. But, I have a problem with custom map. In fact, I have add many custom map, and when I play with it, the plugin doesn’t work. The plugin work perfectly in normal maps (map of the game), but it not work on custom map when I play on easy mod. I does not understand why, can use me please. List of custom maps : deadhightshool (I have play on, plugin doesn't work on easy mod) death sentence (I have play on, plugin doesn't work on easy mod) heavencanwaitl4d2 (no tested for the moment) midnightoil (I have play on, plugin doesn't work on easy mod) rotld_sbs_ls (no tested for the moment) shool_1_2 (no tested for the moment) suicideblitz2 (I have play on, plugin doesn't work on easy mod) tourofrerror (I have play on, plugin doesn't work on easy mod) zombie_caribbean (I have play on, plugin doesn't work on easy mod) Sorry for my bad english

If I have not fully forgotten how things work around here, the plugin does not work on "easy". Not on any map, custom nor original?

Originally Posted by Surf3rDud3 Is my Database.cfg correct? "Databases" { "driver_default" "mysql" // When specifying "host", you may use an IP address, a hostname, or a socket file path "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" "66.71.242.130" "database" "sbflifei_XXXX" "user" "sbflifei_XXXX" "pass" "XXXXXX" } } Because i got this: L 06/24/2011 - 03:51:23: [l4d_stats.smx] Failed to connect to database: [1045]: Access denied for user 'sbflifei_sbf'@'72.51.60.10' (using password: YES) L 06/24/2011 - 03:51:23: [SM] Plugin encountered error 25: Call was aborted L 06/24/2011 - 03:51:23: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details. L 06/24/2011 - 03:51:23: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 06/24/2011 - 03:51:23: [SM] [0] Line 996, /home/groups/alliedmodders/forums/files/5/2/0/8/2/80462.attach::OnConfigsExecuted()

Try this:

mysql> GRANT ALL ON sbflifei_XXXX.* TO 'sbflifei_sbf'@'72.51.60.10' IDENTIFIED BY 'PASSWORD';

[@lex666]

Originally Posted by muukis If I have not fully forgotten how things work around here, the plugin does not work on "easy". Not on any map, custom nor original?

Indeed, the plugin does not work on "easy" mode, on all maps of the game. But why ?

Thanks for your reply and your help

[muukis]

Originally Posted by @lex666 Indeed, the plugin does not work on "easy" mode, on all maps of the game. But why ?

I think the original author was thinking easy to be too easy? Anyways, that is how I feel. Sorry for the inconvenience.

[@lex666]

I have read the source of plugin, and I have discovered this paragraph :

The plugin ONLY works in Co-op mode, in every difficulty but Easy. Stats will automatically stop tracking if any of these conditions are met: . Game is in Easy difficulty . sv_cheats is set to "1" . There are not enough Human players, as determined by a Cvar . The Database connection has failed.

Easy it's easy, but on custom map, it's sometimes difficult on normal

Thanks for your help

[Stargate75]

Custom Player Stats: Connecting to database failed. Read error log for further details. WHY?

"Databases"
{
    "driver_default"        "mysql"
    
    "sourcebans"
    {
        "driver"            "mysql"
        "host"                "localhost"
        "database"            "sb"
        "user"                "xxxxxxxxxxxx"
        "pass"                "xxxxxxxxxx"
        //"timeout"            "0"
        "port"            "3306"
    }
    
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }
    
    "l4dstats"
    {
        "driver"            "mysql"
        "host"                "localhost"
        "database"            "l4dstats"
        "user"                "xxxxxxxxxxxxx"
        "pass"                "xxxxxxxxxxx"
        //"timeout"            "0"
        "port"            "3306"
    }
}

SourceMod error session started
L 07/02/2011 - 07:19:11: Info (map "c8m1_apartment") (file "errors_20110702.log")
L 07/02/2011 - 07:19:11: [l4d_stats.smx] Fast query failed! (Error = "Table 'l4dstats.players' doesn't exist") Query = "SELECT * FROM players WHERE 1 = 2"
L 07/02/2011 - 07:19:11: [l4d_stats.smx] Database is missing required table or tables.
L 07/02/2011 - 07:19:11: [SM] Plugin encountered error 25: Call was aborted
L 07/02/2011 - 07:19:11: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 07/02/2011 - 07:19:11: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 07/02/2011 - 07:19:11: [SM]   [0]  Line 996, /home/groups/alliedmodders/forums/files/5/2/0/8/2/80462.attach::OnConfigsExecuted()