AlliedModders - [Any] Classy Crash Logger

AlliedModders (https://forums.alliedmods.net/index.php)

- Plugins (https://forums.alliedmods.net/forumdisplay.php?f=108)

- - [Any] Classy Crash Logger (https://forums.alliedmods.net/showthread.php?t=115080)

Re: [Any] Classy Crash Logger

Quote:

Originally Posted by snelvuur (Post 1071736)

L 01/29/2010 - 17:51:33: [crashlogger.smx] Can't select database
L 01/29/2010 - 17:51:33: [SM] Native "SQL_FastQuery" reported: Invalid database Handle 0 (error: 4)
L 01/29/2010 - 17:51:33: [SM] Displaying call stack trace for plugin "crashlogger.smx":
L 01/29/2010 - 17:51:33: [SM] [0] Line 63, /home/groups/alliedmodders/forums/files/4/9/8/6/5/57029.attach::createdbtables()
L 01/29/2010 - 17:51:33: [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.

Re: [Any] Classy Crash Logger

Quote:

Originally Posted by berni (Post 1131727)

Please fix screenshot link and comment on snelvuur's post.

Done and done. :up:

Re: [Any] Classy Crash Logger

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.

Re: [Any] Classy Crash Logger

Ok, i will check those things out too.. will report back (when i find the time again)

Re: [Any] Classy Crash Logger

Quote:

Originally Posted by bouncer (Post 1180747)

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.

Re: [Any] Classy Crash Logger

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.

Re: [Any] Classy Crash Logger

Quote:

Originally Posted by eraserhead (Post 1252221)

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.

Re: [Any] Classy Crash Logger

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.

Re: [Any] Classy Crash Logger

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.

Re: [Any] Classy Crash Logger

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.