[Tiger50]

Hi

The custom player stats has stopped working on my windows l4d2 servers 6 of them

Here is the error log

L 05/20/2016 - 07:27:55: [l4d_stats.smx] Failed to connect to database: [1044]: Access denied for user 'pwwebhosting'@'%' to database 'pwwebhosting_l4dstats'
L 05/20/2016 - 07:27:55: [SM] Plugin encountered error 25: Call was aborted
L 05/20/2016 - 07:27:55: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 05/20/2016 - 07:27:55: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 05/20/2016 - 07:27:55: [SM] [0] Line 1053, /home/groups/sourcemod/upload_tmp/phpzIguUu.sp::OnConfigsExecuted()
L 05/20/2016 - 09:492: SourceMod error session started
L 05/20/2016 - 09:492: Info (map "c1m4_atrium") (file "errors_20160520.log")
L 05/20/2016 - 09:492: [l4d_stats.smx] Failed to connect to database: [1044]: Access denied for user 'pwwebhosting'@'%' to database 'pwwebhosting_l4dstats'
L 05/20/2016 - 09:492: [SM] Plugin encountered error 25: Call was aborted
L 05/20/2016 - 09:492: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 05/20/2016 - 09:492: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 05/20/2016 - 09:492: [SM] [0] Line 1053, /home/groups/sourcemod/upload_tmp/phpzIguUu.sp::OnConfigsExecuted

The plugin is is still working fine on my ubuntu l4d2 servers 14 of them

Can anyone please help me get this great plugin working on my windows servers
Ive tried different versions of MM & SM but still no luck
Ive tried re-compiling the .sp file

Thank you in advance

[cravenge]

Just be patient and wait as the author is currently doing an update since there was a new L4D2 update so there are signatures that may have changed and the structure of .sql files for mySQL have also changed.

[Tiger50]

Originally Posted by cravenge Just be patient and wait as the author is currently doing an update since there was a new L4D2 update so there are signatures that may have changed and the structure of .sql files for mySQL have also changed.

Sure I understand that but why is this great plugin is working on my l4d2 ubuntu servers with with no problems, and stopped working on my windows servers

[muukis]

Originally Posted by Tiger50 Hi The custom player stats has stopped working on my windows l4d2 servers 6 of them Here is the error log L 05/20/2016 - 07:27:55: [l4d_stats.smx] Failed to connect to database: [1044]: Access denied for user 'pwwebhosting'@'%' to database 'pwwebhosting_l4dstats' L 05/20/2016 - 07:27:55: [SM] Plugin encountered error 25: Call was aborted L 05/20/2016 - 07:27:55: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details. L 05/20/2016 - 07:27:55: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 05/20/2016 - 07:27:55: [SM] [0] Line 1053, /home/groups/sourcemod/upload_tmp/phpzIguUu.sp::OnConfigsExecuted() L 05/20/2016 - 09:492: SourceMod error session started L 05/20/2016 - 09:492: Info (map "c1m4_atrium") (file "errors_20160520.log") L 05/20/2016 - 09:492: [l4d_stats.smx] Failed to connect to database: [1044]: Access denied for user 'pwwebhosting'@'%' to database 'pwwebhosting_l4dstats' L 05/20/2016 - 09:492: [SM] Plugin encountered error 25: Call was aborted L 05/20/2016 - 09:492: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details. L 05/20/2016 - 09:492: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 05/20/2016 - 09:492: [SM] [0] Line 1053, /home/groups/sourcemod/upload_tmp/phpzIguUu.sp::OnConfigsExecuted The plugin is is still working fine on my ubuntu l4d2 servers 14 of them Can anyone please help me get this great plugin working on my windows servers Ive tried different versions of MM & SM but still no luck Ive tried re-compiling the .sp file Thank you in advance

It looks to me that something has happened to the firewall or the connectivity in general between the DB server and the Windows game servers. I'm fairly sure that in your Windows game servers you cannot run any plugins that connects to the same database server? My educated guess is that the problem is not the plugin.

[Tiger50]

@ muukis

One thing is when i access the admin menu on the windows servers now the custom player menu is all funny symbols, this was a problem when i very fist put the plugin on to all my servers, I just re-compiled the .sp and the problem was solved

since then Ive using the plugin for many many months on both my windows and ubuntu l4d2 servers with no problems, its been perfect, all my members love it as do I

As Ive said before its still working perfect on my ubuntu servers and I have not added any plugins or removed any plugins from both sets of servers all 20 or so servers are setup in the same way

Here is the latest error log

L 05/21/2016 - 14:447: [l4d_stats.smx] Failed to connect to database: [1044]: Access denied for user 'pwwebhosting'@'%' to database 'pwwebhosting_l4dstats'
L 05/21/2016 - 14:447: [SM] Plugin encountered error 25: Call was aborted
L 05/21/2016 - 14:447: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 05/21/2016 - 14:447: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 05/21/2016 - 14:447: [SM] [0] Line 1053, /home/groups/sourcemod/upload_tmp/phpzIguUu.sp::OnConfigsExecuted()

If you wish i can give you full access to my windows servers so you can see yourself

The custom player stats is such a brilliant plugin it would be a shame to lose it

Im sure if you had a quick look you might be able to offer a solution

Thanks in advance

[cravenge]

Originally Posted by Tiger50 @ muukis One thing is when i access the admin menu on the windows servers now the custom player menu is all funny symbols, this was a problem when i very fist put the plugin on to all my servers, I just re-compiled the .sp and the problem was solved since then Ive using the plugin for many many months on both my windows and ubuntu l4d2 servers with no problems, its been perfect, all my members love it as do I As Ive said before its still working perfect on my ubuntu servers and I have not added any plugins or removed any plugins from both sets of servers all 20 or so servers are setup in the same way Here is the latest error log L 05/21/2016 - 14:447: [l4d_stats.smx] Failed to connect to database: [1044]: Access denied for user 'pwwebhosting'@'%' to database 'pwwebhosting_l4dstats' L 05/21/2016 - 14:447: [SM] Plugin encountered error 25: Call was aborted L 05/21/2016 - 14:447: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details. L 05/21/2016 - 14:447: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 05/21/2016 - 14:447: [SM] [0] Line 1053, /home/groups/sourcemod/upload_tmp/phpzIguUu.sp::OnConfigsExecuted() If you wish i can give you full access to my windows server so you can see yourself The custom player stats is such a brilliant plugin it would be a shame to lose it Im sure if you had a quick look you might be able to offer a solution Thanks in advance

As I said before, many things have changed since the recent L4D2 update. For your errors, try to check this and if it doesn't resolve your problem, that means the plugin is not working properly for Windows:

1. For database connection failure, please check your database.cfg if cpstats database is there.
2. Again, check your cpstats config.php if all is correct.

[muukis]

Originally Posted by P00kster There was a L4D2 update recently, and most likely some of the signatures have changed for Windows.

Tested on my Windows 2012 server and everything is working flawlessly. Signatures have not changed apparently? Attached a screenshot from console.

Running my web stats here: http://pilssi.net/l4dstats/

[muukis]

Originally Posted by muukis Tested on my Windows 2012 server and everything is working flawlessly. Signatures have not changed apparently? Attached a screenshot from console. Running my web stats here: http://pilssi.net/l4dstats/

Video from a play today:
https://www.youtube.com/watch?v=0pq6mKb__24

[muukis]

Originally Posted by muukis Tested on my Windows 2012 server and everything is working flawlessly. Signatures have not changed apparently? Attached a screenshot from console. Running my web stats here: http://pilssi.net/l4dstats/

Another video shot today:
https://www.youtube.com/watch?v=eUHNIfwo_CQ

[cravenge]

EDIT: Nvm, I found out that the databases I made were not given privileges in phpMyAdmin.

EDIT 2: The signatures in L4D2 I found in the gamedata file have wrong values. The one I attached below is the latest one.