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

[Any] Classy Crash Logger


Post New Thread Reply   
 
Thread Tools Display Modes
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 03-28-2010 , 17:54   Re: [Any] Classy Crash Logger
Reply With Quote #11

Quote:
Originally Posted by snelvuur View Post
L 01/29/2010 - 17:513: [crashlogger.smx] Can't select database
L 01/29/2010 - 17:513: [SM] Native "SQL_FastQuery" reported: Invalid database Handle 0 (error: 4)
L 01/29/2010 - 17:513: [SM] Displaying call stack trace for plugin "crashlogger.smx":
L 01/29/2010 - 17:513: [SM] [0] Line 63, /home/groups/alliedmodders/forums/files/4/9/8/6/5/57029.attach::createdbtables()
L 01/29/2010 - 17:513: [SM] [1] Line 19, /home/groups/alliedmodders/forums/files/4/9/8/6/5/57029.attach::OnPluginStart()

I checked, but this datasource is working (in databases.cfg) i have a whole list of database entry's in there which do work.

Tried to create it manually (sql) based on the source code but still gave same error.
Have you checked your databases.cfg file to make sure there arent any errant closing braces "}" anywhere?
Are you sure the game server can communicate with the mysql server?

If the plugin can't connect to the mysql server it's most likely because of one or more of these reasons:
  • Incorrect server address (IP etc)
  • Incorrect database name
  • Incorrect database user (name)
  • Incorrect database user password
  • Gameserver IP isn't allowed access to database
Keep in mind that the gameserver's IP that shows in steam isn't always the IP that is used to connect to the mysql server.

Hope that helps.
__________________
DarthNinja is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 03-28-2010 , 17:55   Re: [Any] Classy Crash Logger
Reply With Quote #12

Quote:
Originally Posted by berni View Post
Please fix screenshot link and comment on snelvuur's post.
Done and done.
__________________
DarthNinja is offline
bouncer
Veteran Member
Join Date: Apr 2009
Old 05-15-2010 , 07:55   Re: [Any] Classy Crash Logger
Reply With Quote #13

so this ONLY shows on webpage when server crashed? could you make it log the errors like 5 min before crash or something? that would be more helpful.
__________________


bouncer is offline
snelvuur
Veteran Member
Join Date: Jun 2008
Location: Netherlands
Old 05-17-2010 , 11:53   Re: [Any] Classy Crash Logger
Reply With Quote #14

Ok, i will check those things out too.. will report back (when i find the time again)
snelvuur is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 05-17-2010 , 18:20   Re: [Any] Classy Crash Logger
Reply With Quote #15

Quote:
Originally Posted by bouncer View Post
so this ONLY shows on webpage when server crashed? could you make it log the errors like 5 min before crash or something? that would be more helpful.
When the plugin loads it sends a timestamp to the database. The reason being so that you can open your log files and look before that time.
__________________
DarthNinja is offline
eraserhead
Veteran Member
Join Date: Nov 2009
Old 07-26-2010 , 14:15   Re: [Any] Classy Crash Logger
Reply With Quote #16

Hi DN,

It would be nice if you could add a cvar for this plugin so it uses a table in an existing database because my provider limits the amount of databases i can setup.
__________________
eraserhead is offline
Send a message via Skype™ to eraserhead
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 07-26-2010 , 17:27   Re: [Any] Classy Crash Logger
Reply With Quote #17

Quote:
Originally Posted by eraserhead View Post
Hi DN,

It would be nice if you could add a cvar for this plugin so it uses a table in an existing database because my provider limits the amount of databases i can setup.
You mean several tables so you could run it on more then one server more effectively?
Eg, crashtable1, crashtable2, crashtable3.
__________________
DarthNinja is offline
eraserhead
Veteran Member
Join Date: Nov 2009
Old 07-27-2010 , 07:51   Re: [Any] Classy Crash Logger
Reply With Quote #18

No that's not what i meant. Currently our hosting provider (gameservers.com) provides us with a hosting plan that allows only 3 MySQL databases. And we are using all of them right now. For example this plugin: https://forums.alliedmods.net/showthread.php?t=69593 has this cvar:
Quote:
  • maprate_table (default "map_ratings")
    • The name of the database table to store map ratings in. If you run multiple servers, you may want to change this for different game types or for individual servers, depending on whether you servers share databases and whether you want maprating data shared across multiple servers.
This allowed me to still use MySQL although i was using the maximum of 3 databases. I simply let the plugin add the data to an existing databse by using this cvar.
__________________
eraserhead is offline
Send a message via Skype™ to eraserhead
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 07-27-2010 , 09:32   Re: [Any] Classy Crash Logger
Reply With Quote #19

Umm...

The plugin currently connects to whatever database you set for it in your server's database.cfg

It then auto-creates and populates a table with timestamps for each crash.

Database == changeable.
Table == currently not changeable.
__________________
DarthNinja is offline
snelvuur
Veteran Member
Join Date: Jun 2008
Location: Netherlands
Old 08-17-2010 , 15:34   Re: [Any] Classy Crash Logger
Reply With Quote #20

could you add something that it shows which server crashed? i have several servers and i cant really tell which server now actually "crashed" because it seems for single use correct?

i assume you can take the servername via the plugin and put that in the sql too.

Last edited by snelvuur; 08-17-2010 at 15:45.
snelvuur 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 17:11.


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