[whtevrwt]

This is a god-like update. Thanks a lot for this. It's good to see a dev actually care about their work.

[mrkos9i4ok]

This print always when server restarted
L 08/31/2017 - 00:01:22: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 08/31/2017 - 00:01:22: [SM] Blaming: sm_ctban.smx
L 08/31/2017 - 00:01:22: [SM] Call stack trace:
L 08/31/2017 - 00:01:22: [SM] [0] SQL_TQuery
L 08/31/2017 - 00:01:22: [SM] [1] Line 804, sm_ctban.sp::OnClientAuthorized
i use last version plugin

[databomb]

Originally Posted by mrkos9i4ok This print always when server restarted L 08/31/2017 - 00:01:22: [SM] Exception reported: Invalid database Handle 0 (error: 4) L 08/31/2017 - 00:01:22: [SM] Blaming: sm_ctban.smx L 08/31/2017 - 00:01:22: [SM] Call stack trace: L 08/31/2017 - 00:01:22: [SM] [0] SQL_TQuery L 08/31/2017 - 00:01:22: [SM] [1] Line 804, sm_ctban.sp::OnClientAuthorized i use last version plugin

This may be one where my testing is different. In testing, the database and the game server were on the same box. How far away is your ctban database from your game server? Post more logs. I want to see the time between when you are starting the server and the first client is connecting and how often there are these errors for each restart.

Here is 2.0.1beta1 which adds a timer to re-check this info if the database is not connected yet. May need to adjust the timer rescan rates.
https://hastebin.com/tasufenefa.cpp

[mrkos9i4ok]

Originally Posted by databomb This may be one where my testing is different. In testing, the database and the game server were on the same box. How far away is your ctban database from your game server? Post more logs. I want to see the time between when you are starting the server and the first client is connecting and how often there are these errors for each restart. Here is 2.0.1beta1 which adds a timer to re-check this info if the database is not connected yet. May need to adjust the timer rescan rates. https://hastebin.com/tasufenefa.cpp

My error did not appear any more.

[databomb]

Version 2.0.1

Fixes an issue with errors in OnClientAuthorized operating on a disconnected database.
Fixes an issue with errors in the ForceCT and UnforceCT commands.

[5IVE]

Originally Posted by databomb Version 2.0.1 Fixes an issue with errors in OnClientAuthorized operating on a disconnected database. Fixes an issue with errors in the ForceCT and UnforceCT commands.

Plugin only MySQL???
L 09/02/2017 - 07:25:10: [sm_ctban.smx] Default database database connection failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 09/02/2017 - 07:25:10: [SM] Exception reported: Error while connecting to default database. Exiting.
L 09/02/2017 - 07:25:10: [SM] Blaming: sm_ctban.smx
L 09/02/2017 - 07:25:10: [SM] Call stack trace:
L 09/02/2017 - 07:25:10: [SM] [0] SetFailState
L 09/02/2017 - 07:25:10: [SM] [1] Line 1528, /home/forums/content/files/5/4/6/4/8/165271.attach:B_Callback_Connect

"ctban"
{
"driver" "default"
"database" "ctban"
"host" "localhost"
"user" "root"
"pass" ""
}

[databomb]

Originally Posted by 5IVE Plugin only MySQL??? Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Does your '/tmp/mysql.sock' exist? There is a common issue that the symbolic link must be created on the server. From the root user you would execute a command like:

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

Then restart your MySQL server and try to access it via the command line before you launch the plugin.

You can try SQLite if that does not work, but SQLite is not recommended for anything except clientprefs. The syntax of all queries has not been tested on SQLite.

[hartii14]

Errors:
sm_ctban.smx (CT Ban): Error while connecting to default database. Exiting.




i need help..

[databomb]

Originally Posted by hartii14 Errors: sm_ctban.smx (CT Ban): Error while connecting to default database. Exiting. i need help..

The plugin requires a database connection be specified in your addons/sourcemod/configs/databases.cfg. Some people just use the same database as their SourceBans uses while others have a separate local MySQL/MariaDB database running for CT Bans. Either option is fine but you need a database. You could try SQLite like clientprefs uses but it is not tested and not recommended.

[hartii14]

Originally Posted by databomb The plugin requires a database connection be specified in your addons/sourcemod/configs/databases.cfg. Some people just use the same database as their SourceBans uses while others have a separate local MySQL/MariaDB database running for CT Bans. Either option is fine but you need a database. You could try SQLite like clientprefs uses but it is not tested and not recommended.

i did as you said now ctban loads but when i want ctban someone nothing happens..