SourceBans++ 1.6.4

[gg.cfg]

@Крузяра, Где именно ? все на разных машинах находится

 

[Kruzya]

@gg.cfg, на игровом для начала.

 

[gg.cfg]

@Крузяра, выключил теперь Error connecting #111: Connection refused
--- Добавлено позже ---
Разобрался нужно было в параметрах запуска прописать +net_public_adr xx.xx.xx.xx +ip xx.xx.xx.xx +hostport 27015

 

[БлагоЯр]

Кто знает в чём проблема:
Если с сайта SB++ отправляешь игроку приватное сообщение на кириллице, то в игре видно отправителя, но текста нет. На латинице/числа - всё нормально
-------------------------------
Ещё предупреждение возникает, когда пытаешься отправить жалобу на игрока

Warning: mail(): Multiple or malformed newlines found in additional_header in /var/www/u2703/data/www/bans.nkm18.ru/pages/page.submit.php on line 179


При этом пишет, что письмо отправлено, но уведомление никому (из админов) не приходит.

 

[Kruzya]

@fenix28rn, баг в СБ. Пишите разработчикам.

 

[БлагоЯр]

баг в СБ. Пишите разработчикам.

По обоим причинам?

ПС. Не в курсе куда лучше писать? На почту, дискорд ...?

 

[Kruzya]

По обоим причинам?

Не совсем.
По первой причине - Ркон протокол Сурса не совсем уж и любит кириллицу. Это баг движка уже. Решается костылями.
По второй - да. Там некоторые заголовки почтовому сервису не понравились, потому письма он и не отправил.

Писать на Гитхаб строго.

 

[БлагоЯр]

Это баг движка уже. Решается костылями.

Ещё недавно был админом на чужом сервере. Там версия была 1.5.1 правда была - всё работало. Правда не ++.
Костыли тоже пойдут. Где можно почитать?

Там некоторые заголовки почтовому сервису не понравились, потому письма он и не отправил.

Гуглил. И очень часто люди писали, что проблема в двойном переносе "\n\n" в заголовке (он же header). Только вот где их править. Точнее убрать, не в курсе какой файл отвечает за это?

 

[Kruzya]

Костыли тоже пойдут. Где можно почитать?

Не подскажу. Не интересовался.

не в курсе какой файл отвечает за это?

Вот тут у СБ всё плохо.
У него это всё раскидано по разным файлам.
Но если фиксить конкретно отправку жалоб на игрока - Вам сюда.

 

[БлагоЯр]

Не подскажу. Не интересовался.

А откуда информация? Просто нагуглить не могу и не придумаю как вопрос задать ему, этому гуглу, чтобы он понял чего я хочу

Но если фиксить конкретно отправку жалоб

Да там ещё и журнал ошибок сыпет - матюкается на functionmath и smarty. Создал Issue на github

 

[bodya]

Спойлер: error sb

L 01/22/2019 - 12:46:57: SourceMod error session started
L 01/22/2019 - 12:46:57: Info (map "de_dust2") (file "errors_20190122.log")
L 01/22/2019 - 12:46:57: [sbpp_comms.smx] You must set valid `ServerID` value in sourcebans.cfg!
L 01/22/2019 - 12:46:57: [SM] Exception reported: Failed to connect to SourceBans DB, [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:46:57: [SM] Blaming: sbpp_checker.smx
L 01/22/2019 - 12:46:57: [SM] Call stack trace:
L 01/22/2019 - 12:46:57: [SM] [0] SetFailState
L 01/22/2019 - 12:46:57: [SM] [1] Line 75, .\sbpp_checker.sp::OnDatabaseConnected
L 01/22/2019 - 12:46:57: [sbpp_sleuth.smx] SourceSleuth: Database connection error: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:46:57: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:47:28: Error log file session closed.
L 01/22/2019 - 12:47:29: SourceMod error session started
L 01/22/2019 - 12:47:29: Info (map "de_dust2") (file "errors_20190122.log")
L 01/22/2019 - 12:47:29: [sbpp_comms.smx] You must set valid `ServerID` value in sourcebans.cfg!
L 01/22/2019 - 12:47:29: [SM] Exception reported: Failed to connect to SourceBans DB, [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:47:29: [SM] Blaming: sbpp_checker.smx
L 01/22/2019 - 12:47:29: [SM] Call stack trace:
L 01/22/2019 - 12:47:29: [SM] [0] SetFailState
L 01/22/2019 - 12:47:29: [SM] [1] Line 75, .\sbpp_checker.sp::OnDatabaseConnected
L 01/22/2019 - 12:47:37: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:48:02: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:49:56: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:49:57: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:50:06: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Вот такая ошибка в логах после установки.
В чем проблема?

 

[KonveeR]

Спойлер: error sb

L 01/22/2019 - 12:46:57: SourceMod error session started
L 01/22/2019 - 12:46:57: Info (map "de_dust2") (file "errors_20190122.log")
L 01/22/2019 - 12:46:57: [sbpp_comms.smx] You must set valid `ServerID` value in sourcebans.cfg!
L 01/22/2019 - 12:46:57: [SM] Exception reported: Failed to connect to SourceBans DB, [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:46:57: [SM] Blaming: sbpp_checker.smx
L 01/22/2019 - 12:46:57: [SM] Call stack trace:
L 01/22/2019 - 12:46:57: [SM] [0] SetFailState
L 01/22/2019 - 12:46:57: [SM] [1] Line 75, .\sbpp_checker.sp::OnDatabaseConnected
L 01/22/2019 - 12:46:57: [sbpp_sleuth.smx] SourceSleuth: Database connection error: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:46:57: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:47:28: Error log file session closed.
L 01/22/2019 - 12:47:29: SourceMod error session started
L 01/22/2019 - 12:47:29: Info (map "de_dust2") (file "errors_20190122.log")
L 01/22/2019 - 12:47:29: [sbpp_comms.smx] You must set valid `ServerID` value in sourcebans.cfg!
L 01/22/2019 - 12:47:29: [SM] Exception reported: Failed to connect to SourceBans DB, [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:47:29: [SM] Blaming: sbpp_checker.smx
L 01/22/2019 - 12:47:29: [SM] Call stack trace:
L 01/22/2019 - 12:47:29: [SM] [0] SetFailState
L 01/22/2019 - 12:47:29: [SM] [1] Line 75, .\sbpp_checker.sp::OnDatabaseConnected
L 01/22/2019 - 12:47:37: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:48:02: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:49:56: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:49:57: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:50:06: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Вот такая ошибка в логах после установки.
В чем проблема?

 

[mika]

Спойлер: error sb

L 01/22/2019 - 12:46:57: SourceMod error session started
L 01/22/2019 - 12:46:57: Info (map "de_dust2") (file "errors_20190122.log")
L 01/22/2019 - 12:46:57: [sbpp_comms.smx] You must set valid `ServerID` value in sourcebans.cfg!
L 01/22/2019 - 12:46:57: [SM] Exception reported: Failed to connect to SourceBans DB, [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:46:57: [SM] Blaming: sbpp_checker.smx
L 01/22/2019 - 12:46:57: [SM] Call stack trace:
L 01/22/2019 - 12:46:57: [SM] [0] SetFailState
L 01/22/2019 - 12:46:57: [SM] [1] Line 75, .\sbpp_checker.sp::OnDatabaseConnected
L 01/22/2019 - 12:46:57: [sbpp_sleuth.smx] SourceSleuth: Database connection error: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:46:57: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:47:28: Error log file session closed.
L 01/22/2019 - 12:47:29: SourceMod error session started
L 01/22/2019 - 12:47:29: Info (map "de_dust2") (file "errors_20190122.log")
L 01/22/2019 - 12:47:29: [sbpp_comms.smx] You must set valid `ServerID` value in sourcebans.cfg!
L 01/22/2019 - 12:47:29: [SM] Exception reported: Failed to connect to SourceBans DB, [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:47:29: [SM] Blaming: sbpp_checker.smx
L 01/22/2019 - 12:47:29: [SM] Call stack trace:
L 01/22/2019 - 12:47:29: [SM] [0] SetFailState
L 01/22/2019 - 12:47:29: [SM] [1] Line 75, .\sbpp_checker.sp::OnDatabaseConnected
L 01/22/2019 - 12:47:37: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:48:02: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:49:56: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:49:57: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:50:06: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Вот такая ошибка в логах после установки.
В чем проблема?

Если вдс,то ниже, если нет - "классный хостинг у тебя".
На стороне сервера:

apt install lib32z1 lib32stdc++6 libc6 libgcc1 libc6-i386 lib32gcc1

На стороне веб-сервера:
/etc/mysql/mysql.conf.d/mysqld.cnf

 

[NaN]

Спойлер: error sb

L 01/22/2019 - 12:46:57: SourceMod error session started
L 01/22/2019 - 12:46:57: Info (map "de_dust2") (file "errors_20190122.log")
L 01/22/2019 - 12:46:57: [sbpp_comms.smx] You must set valid `ServerID` value in sourcebans.cfg!
L 01/22/2019 - 12:46:57: [SM] Exception reported: Failed to connect to SourceBans DB, [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:46:57: [SM] Blaming: sbpp_checker.smx
L 01/22/2019 - 12:46:57: [SM] Call stack trace:
L 01/22/2019 - 12:46:57: [SM] [0] SetFailState
L 01/22/2019 - 12:46:57: [SM] [1] Line 75, .\sbpp_checker.sp::OnDatabaseConnected
L 01/22/2019 - 12:46:57: [sbpp_sleuth.smx] SourceSleuth: Database connection error: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:46:57: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:47:28: Error log file session closed.
L 01/22/2019 - 12:47:29: SourceMod error session started
L 01/22/2019 - 12:47:29: Info (map "de_dust2") (file "errors_20190122.log")
L 01/22/2019 - 12:47:29: [sbpp_comms.smx] You must set valid `ServerID` value in sourcebans.cfg!
L 01/22/2019 - 12:47:29: [SM] Exception reported: Failed to connect to SourceBans DB, [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:47:29: [SM] Blaming: sbpp_checker.smx
L 01/22/2019 - 12:47:29: [SM] Call stack trace:
L 01/22/2019 - 12:47:29: [SM] [0] SetFailState
L 01/22/2019 - 12:47:29: [SM] [1] Line 75, .\sbpp_checker.sp::OnDatabaseConnected
L 01/22/2019 - 12:47:37: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:48:02: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:49:56: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:49:57: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/22/2019 - 12:50:06: [sbpp_comms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Вот такая ошибка в логах после установки.
В чем проблема?

Во-первых, укажите ServerID.
Во-вторых, у вас точно на localhost MySQL сервер?

 

[bodya]

Во-первых, укажите ServerID.
Во-вторых, у вас точно на localhost MySQL сервер?

Если вдс,то ниже, если нет - "классный хостинг у тебя".
На стороне сервера:

apt install lib32z1 lib32stdc++6 libc6 libgcc1 libc6-i386 lib32gcc1

На стороне веб-сервера:
/etc/mysql/mysql.conf.d/mysqld.cnf
Посмотреть вложение 38098

Сервер стоит на cw-serv
На услуге WEBХостинг.

Вот ещё одна ошибка.

Спойлер: error new

L 01/22/2019 - 13:54:36: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 13:55:59: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 13:56:14: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 13:58:41: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:00:13: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:00:29: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:01:04: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:01:47: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:02:11: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:02:46: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)

в database.cfg
host прописан так

Спойлер: database

"sourcebans"
{
"driver" "default"
"host" "isp.cw-serv.ru"
"database" "banscs"
"user" "banscs"
"pass" ""
//"timeout" "0"
"port" "3306"

 

[Kruzya]

@bodya, удалённый доступ к базе не прописан.

 

[NaN]

Сервер стоит на cw-serv
На услуге WEBХостинг.

Вот ещё одна ошибка.

Спойлер: error new

L 01/22/2019 - 13:54:36: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 13:55:59: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 13:56:14: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 13:58:41: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:00:13: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:00:29: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:01:04: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:01:47: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:02:11: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)
L 01/22/2019 - 14:02:46: [sbpp_comms.smx] Connecting to database failed: [1045]: Access denied for user 'banscs'@'109.237.109.82' (using password: YES)

в database.cfg
host прописан так

Спойлер: database

"sourcebans"
{
"driver" "default"
"host" "isp.cw-serv.ru"
"database" "banscs"
"user" "banscs"
"pass" ""
//"timeout" "0"
"port" "3306"

Пароль верный? Подключение с IP 109.237.109.82 разрешено у пользователя?

 

[bodya]

Пароль верный? Подключение с IP 109.237.109.82 разрешено у пользователя?

Сервер и WEB хост стоят на разных айпи.
Как правильно прописать тогда hosts

 

[Kruzya]

@bodya, в databases.cfg его оставляете как есть.
В ISP Manager найдите кнопку "Удалённый доступ", пропишите туда IP-адрес игрового сервера.

 

[bodya]

@bodya, в databases.cfg его оставляете как есть.
В ISP Manager найдите кнопку "Удалённый доступ", пропишите туда IP-адрес игрового сервера.

не могу найти её.