Raised This Month: $12 Target: $400
 3% 

Player Time Tracker v2.3.5


Post New Thread Reply   
 
Thread Tools Display Modes
clad
Senior Member
Join Date: Oct 2006
Old 12-03-2011 , 18:07   Re: Player Time Tracker v2.3.5
Reply With Quote #101

That issue has been on going for quite some time. i have yet to get any database to connect.
https://forums.alliedmods.net/showpo...7&postcount=78

I too have no problem connecting with other plugins that need a database such as sourcebans (as mentioned above in someone else post).
We colo-host our server machines, and have full access.
__________________
clad is offline
crazydog
AlliedModders Donor
Join Date: Jan 2006
Old 12-03-2011 , 19:52   Re: Player Time Tracker v2.3.5
Reply With Quote #102

Quote:
Originally Posted by clad View Post
That issue has been on going for quite some time. i have yet to get any database to connect.
https://forums.alliedmods.net/showpo...7&postcount=78

I too have no problem connecting with other plugins that need a database such as sourcebans (as mentioned above in someone else post).
We colo-host our server machines, and have full access.
It makes me think whatever MySQL driver/binary is on the system only allows one concurrent connection at a time, but I'm not sure if that's true at all. ^_^
crazydog is offline
clad
Senior Member
Join Date: Oct 2006
Old 12-03-2011 , 19:57   Re: Player Time Tracker v2.3.5
Reply With Quote #103

I don't think that is the case. i tested on a test server with no other databases need but ppt, and it still doesn't want to connect.
i haven't tested anything new since around the time i made the original post.
So i don't know if you have changed anything in the plugin since then.
__________________
clad is offline
wtfaatp
Senior Member
Join Date: Jul 2010
Old 12-03-2011 , 23:01   Re: Player Time Tracker v2.3.5
Reply With Quote #104

Even the theory of only allowing one connection is off cause I use it for two. Maprating system and sourcebans.

Turning off the other plugins didnt do anything :\
__________________
SourceMod : 1.10.0 (Official) | MetaMod : 1.10.7 (Official)
Server : NFOservers - Windows
wtfaatp is offline
crazydog
AlliedModders Donor
Join Date: Jan 2006
Old 12-04-2011 , 01:03   Re: Player Time Tracker v2.3.5
Reply With Quote #105

I haven't changed anything with the database connections. Here, try this old version. Lemme know if IT works.

This is version 2.3.3
Attached Files
File Type: sp Get Plugin or Get Source (ptt.sp - 510 views - 22.2 KB)
crazydog is offline
wtfaatp
Senior Member
Join Date: Jul 2010
Old 12-04-2011 , 02:08   Re: Player Time Tracker v2.3.5
Reply With Quote #106

Connected no prob. However Now im getting spammed with this
Code:
L 12/04/2011 - 07:06:52: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/04/2011 - 07:06:52: [SM]   [0]  Line 595, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::Queries()
L 12/04/2011 - 07:06:52: [SM]   [1]  Line 659, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::updateTime()
L 12/04/2011 - 07:06:57: [SM] Native "IsFakeClient" reported: Client 12 is not connected
L 12/04/2011 - 07:06:57: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/04/2011 - 07:06:57: [SM]   [0]  Line 595, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::Queries()
L 12/04/2011 - 07:06:57: [SM]   [1]  Line 659, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::updateTime()
L 12/04/2011 - 07:07:02: [SM] Native "IsFakeClient" reported: Client 12 is not connected
L 12/04/2011 - 07:07:02: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/04/2011 - 07:07:02: [SM]   [0]  Line 595, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::Queries()
L 12/04/2011 - 07:07:02: [SM]   [1]  Line 659, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::updateTime()
L 12/04/2011 - 07:07:07: [SM] Native "IsFakeClient" reported: Client 12 is not connected
L 12/04/2011 - 07:07:07: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/04/2011 - 07:07:07: [SM]   [0]  Line 595, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::Queries()
L 12/04/2011 - 07:07:07: [SM]   [1]  Line 659, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::updateTime()
L 12/04/2011 - 07:07:12: [SM] Native "IsFakeClient" reported: Client 12 is not connected
L 12/04/2011 - 07:07:12: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/04/2011 - 07:07:12: [SM]   [0]  Line 595, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::Queries()
L 12/04/2011 - 07:07:12: [SM]   [1]  Line 659, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::updateTime()
Also as an example to show its working http://mfc4life.com/ptt.php
__________________
SourceMod : 1.10.0 (Official) | MetaMod : 1.10.7 (Official)
Server : NFOservers - Windows

Last edited by wtfaatp; 12-04-2011 at 02:11.
wtfaatp is offline
clad
Senior Member
Join Date: Oct 2006
Old 12-04-2011 , 02:18   Re: Player Time Tracker v2.3.5
Reply With Quote #107

Quote:
Originally Posted by wtfaatp View Post
Code:
L 12/03/2011 - 16:45:00: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 12/03/2011 - 16:45:00: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 12/03/2011 - 16:45:00: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/03/2011 - 16:45:00: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 12/03/2011 - 16:55:50: Error log file session closed.
L 12/03/2011 - 16:55:53: SourceMod error session started
L 12/03/2011 - 16:55:53: Info (map "gg_mario_vs_wario_v2") (file "errors_20111203.log")
L 12/03/2011 - 16:55:53: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 12/03/2011 - 16:55:53: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 12/03/2011 - 16:55:53: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/03/2011 - 16:55:53: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 12/03/2011 - 17:07:56: Error log file session closed.
L 12/03/2011 - 17:07:59: SourceMod error session started
L 12/03/2011 - 17:07:59: Info (map "gg_awp_angular") (file "errors_20111203.log")
L 12/03/2011 - 17:07:59: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 12/03/2011 - 17:07:59: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 12/03/2011 - 17:07:59: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/03/2011 - 17:07:59: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 12/03/2011 - 17:53:42: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 12/03/2011 - 17:53:42: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 12/03/2011 - 17:53:42: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/03/2011 - 17:53:42: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 12/03/2011 - 18:03:26: Error log file session closed.
wtfaatp, about this error. It looks like your trying to connect as localhost.
Am i right ? If so.
As root, Look in this folder /tmp/ and check to see if you have a simlink to mysql.sock

I read you have other databases working, but i was just wondering if you have that.
__________________
clad is offline
crazydog
AlliedModders Donor
Join Date: Jan 2006
Old 12-04-2011 , 02:53   Re: Player Time Tracker v2.3.5
Reply With Quote #108

Quote:
Originally Posted by wtfaatp View Post
Connected no prob. However Now im getting spammed with this
Code:
L 12/04/2011 - 07:06:52: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/04/2011 - 07:06:52: [SM]   [0]  Line 595, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::Queries()
L 12/04/2011 - 07:06:52: [SM]   [1]  Line 659, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::updateTime()
L 12/04/2011 - 07:06:57: [SM] Native "IsFakeClient" reported: Client 12 is not connected
L 12/04/2011 - 07:06:57: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/04/2011 - 07:06:57: [SM]   [0]  Line 595, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::Queries()
L 12/04/2011 - 07:06:57: [SM]   [1]  Line 659, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::updateTime()
L 12/04/2011 - 07:07:02: [SM] Native "IsFakeClient" reported: Client 12 is not connected
L 12/04/2011 - 07:07:02: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/04/2011 - 07:07:02: [SM]   [0]  Line 595, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::Queries()
L 12/04/2011 - 07:07:02: [SM]   [1]  Line 659, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::updateTime()
L 12/04/2011 - 07:07:07: [SM] Native "IsFakeClient" reported: Client 12 is not connected
L 12/04/2011 - 07:07:07: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/04/2011 - 07:07:07: [SM]   [0]  Line 595, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::Queries()
L 12/04/2011 - 07:07:07: [SM]   [1]  Line 659, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::updateTime()
L 12/04/2011 - 07:07:12: [SM] Native "IsFakeClient" reported: Client 12 is not connected
L 12/04/2011 - 07:07:12: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/04/2011 - 07:07:12: [SM]   [0]  Line 595, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::Queries()
L 12/04/2011 - 07:07:12: [SM]   [1]  Line 659, /home/groups/alliedmodders/forums/files/9/4/5/8/96206.attach::updateTime()
Also as an example to show its working http://mfc4life.com/ptt.php
Yeah that was fixed in 2.3.4, but I only had 2.3.3 handy. ^_^

Interesting that 2.3.5 broke it. I'll check some things later.
crazydog is offline
wtfaatp
Senior Member
Join Date: Jul 2010
Old 12-04-2011 , 16:32   Re: Player Time Tracker v2.3.5
Reply With Quote #109

I'm not connecting localy. Its on a different box altogether.. :\
I'm glad its tracking however I really would like the modification added in 2.3.5
__________________
SourceMod : 1.10.0 (Official) | MetaMod : 1.10.7 (Official)
Server : NFOservers - Windows
wtfaatp is offline
Fujiwara
Member
Join Date: Jul 2010
Old 01-04-2012 , 19:04   Re: Player Time Tracker v2.3.5
Reply With Quote #110

2.3.5 seems busted... I've double checked the the IP pointing to the site is fine and the user and password is also correct, as well as the config files on the game server itself. I'm not sure what I'm doing wrong here. I get no updates shown in console being sent to my site.

Code:
L 01/04/2012 - 23:53:55: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 01/04/2012 - 23:53:55: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 01/04/2012 - 23:53:55: [SM] Displaying call stack trace for plugin "ptt.smx":
L 01/04/2012 - 23:53:55: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 01/04/2012 - 23:53:57: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 01/04/2012 - 23:53:57: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 01/04/2012 - 23:53:57: [SM] Displaying call stack trace for plugin "ptt.smx":
L 01/04/2012 - 23:53:57: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 01/04/2012 - 23:54:00: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 01/04/2012 - 23:54:00: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 01/04/2012 - 23:54:00: [SM] Displaying call stack trace for plugin "ptt.smx":
L 01/04/2012 - 23:54:00: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 01/04/2012 - 23:56:41: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 01/04/2012 - 23:56:41: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 01/04/2012 - 23:56:41: [SM] Displaying call stack trace for plugin "ptt.smx":
L 01/04/2012 - 23:56:41: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()

----
Edit
----

Just changed sm_ptt_team "2" to sm_ptt_team "1" and it seems to work fine.

Last edited by Fujiwara; 01-04-2012 at 19:16.
Fujiwara is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:52.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode