ROZWIĄZANE Problem z Sourcebans.

[RafalR]

Witam, mam problem z moim sourcebansem.

 

Mianowicie nie łączy mnie z bazą danych. Zrobiłem udostępnianie, nadałem GRANT ALL PRIVILEGES na konto root i dalej reaguje w taki sposób:

 

[sourcebans.smx] Could not connect to the database. ([2013]: Lost connection to MySQL server at 'reading initial communication packet',  

 

Tutaj jest pełny log po wpisaniu komendy:

************** WARNING ***************
Running the dedicated server as root
is highly discouraged. It is generally
unnecessary to use root privileges to
execute the dedicated server.
**************************************


./srcds_run: 32: ./srcds_run: pushd: not foundss
./srcds_run: 35: ./srcds_run: popd: not found
Server will auto-restart if there is a crash.
LD_LIBRARY_PATH=/serwercs/csgo/bin:/serwercs/csgo:/serwercs/csgo/bin:
#
#Console initialized.
Setting breakpad minidump AppID = 740
#Using breakpad minidump system 740/13566.440.DC
Using breakpad crash handler
Forcing breakpad minidump interfaces to load
dlopen failed trying to load:
/root/.steam/sdk32/steamclient.so
with error:
/root/.steam/sdk32/steamclient.so: cannot open shared object file: No such file                                                                                                              or directory
Looking up breakpad interfaces from steamclient
Calling BreakpadMiniDumpSystemInit
#Loading VPK file hashes for pure server operation.
#Loading VPK file hashes for pure server operation.
#Loading VPK file hashes for pure server operation.
#Game.dll loaded for "Counter-Strike: Global Offensive"
#CGameEventManager::AddListener: event 'server_pre_shutdown' unknown.
#CGameEventManager::AddListener: event 'game_newmap' unknown.
#CGameEventManager::AddListener: event 'finale_start' unknown.
#CGameEventManager::AddListener: event 'round_start' unknown.
#CGameEventManager::AddListener: event 'round_end' unknown.
#CGameEventManager::AddListener: event 'difficulty_changed' unknown.
#CGameEventManager::AddListener: event 'player_connect' unknown.
#CGameEventManager::AddListener: event 'player_disconnect' unknown.
#GameTypes: missing mapgroupsSP entry for game type/mode (custom/custom).
#GameTypes: missing mapgroupsSP entry for game type/mode (cooperative/cooperativ                                                                                                             e).
#GameTypes: missing mapgroupsSP entry for game type/mode (cooperative/coopmissio                                                                                                             n).
Failed to load gamerulescvars.txt, game rules cvars might not be reported to man                                                                                                             agement tools.
Server is hibernating
[S_API FAIL] SteamAPI_Init() failed; SteamAPI_IsSteamRunning() failed.
[S_API FAIL] SteamAPI_Init() failed; unable to locate a running instance of Stea                                                                                                             m, or a local steamclient.so.
Particles: Missing 'particles/money_fx.pcf'
No web api auth key specified - workshop downloads will be disabled.
maxplayers set to 64
ConVarRef cl_embedded_stream_video_playing doesn't point to an existing ConVar
Unknown command "cl_bobamt_vert"
Unknown command "cl_bobamt_lat"
Unknown command "cl_bob_lower_amt"
Unknown command "cl_viewmodel_shift_left_amt"
Unknown command "cl_viewmodel_shift_right_amt"
Unknown command "cl_teamid_min"
Unknown command "cl_teamid_max"
Unknown command "cl_teamid_overhead"
Unknown command "cl_teamid_overhead_maxdist"
Setting mapgroup to 'mg_active'
Network: IP 155.133.43.15 ---- Host_NewGame ----
ConVarRef r_staticlight_streams doesn't point to an existing ConVar
Host_NewGame on map de_dust2
L 02/13/2017 - 13:05:00: -------- Mapchange to de_dust2 --------
L 02/13/2017 - 13:05:00: [GEOIP] GeoIP database info: GEO-106FREE 20161206 Build                                                                                                              1 Copyright (c) 2016 MaxMind
CGameEventManager::AddListener: event 'teamplay_win_panel' unknown.
CGameEventManager::AddListener: event 'teamplay_restart_round' unknown.
CGameEventManager::AddListener: event 'arena_win_panel' unknown.
GameTypes: missing mapgroupsSP entry for game type/mode (custom/custom).
GameTypes: missing mapgroupsSP entry for game type/mode (cooperative/cooperative                                                                                                             ).
GameTypes: missing mapgroupsSP entry for game type/mode (cooperative/coopmission                                                                                                             ).
ConVarRef room_type doesn't point to an existing ConVar
bot_autodifficulty_threshold_high - 5.0
bot_autodifficulty_threshold_low - -2.0
bot_chatter - normal
bot_defer_to_human_goals - 0
bot_defer_to_human_items - 1
bot_difficulty - 1
bot_quota - 10
bot_quota_mode - normal
bot_allow_grenades - 1
bot_allow_pistols - 1
bot_allow_sub_machine_guns - 1
bot_allow_shotguns - 1
bot_allow_rifles - 1
bot_allow_snipers - 1
bot_allow_machine_guns - 1
sv_auto_adjust_bot_difficulty - 1
sv_bots_get_easier_each_win - 0
sv_bots_force_rebuy_every_round - 0
sv_bots_get_harder_after_each_wave - 0
mp_playercashawards - 1
cash_player_bomb_defused - 300
cash_player_bomb_planted - 300
cash_player_damage_hostage - -30
cash_player_interact_with_hostage - 150
cash_player_killed_enemy_default - 300
cash_player_killed_enemy_factor - 1
cash_player_killed_hostage - -1000
cash_player_killed_teammate - -300
cash_player_rescued_hostage - 1000
cash_player_respawn_amount - 0
cash_player_get_killed - 0
mp_teamcashawards - 1
cash_team_elimination_bomb_map - 3250
cash_team_elimination_hostage_map_t - 1000
cash_team_elimination_hostage_map_ct - 2000
cash_team_hostage_alive - 0
cash_team_hostage_interaction - 500
cash_team_loser_bonus - 1400
cash_team_loser_bonus_consecutive_rounds - 500
cash_team_planted_bomb_but_defused - 800
cash_team_rescued_hostage - 0
cash_team_terrorist_win_bomb - 3500
cash_team_win_by_defusing_bomb - 3250
cash_team_win_by_hostage_rescue - 3500
cash_team_win_by_time_running_out_bomb - 3250
cash_team_win_by_time_running_out_hostage - 3250
cash_team_survive_guardian_wave - 1000
mp_afterroundmoney - 0
mp_buytime - 90
mp_buy_anywhere - 0
mp_buy_during_immunity - 0
mp_startmoney - 800
mp_maxmoney - 16000
sv_buy_status_override - -1
mp_death_drop_defuser - 1
mp_death_drop_grenade - 2
mp_death_drop_gun - 1
mp_deathcam_skippable - 1
mp_defuser_allocation - 0
mp_give_player_c4 - 1
mp_free_armor - 0
mp_molotovusedelay - 15.0
mp_weapons_allow_zeus - 1
mp_weapons_allow_map_placed - 0
mp_weapons_glow_on_ground - 0
mp_ct_default_melee - weapon_knife
mp_ct_default_secondary - weapon_hkp2000
mp_ct_default_primary -
mp_ct_default_grenades -
mp_t_default_melee - weapon_knife
mp_t_default_secondary - weapon_glock
mp_t_default_primary -
mp_t_default_grenades -
mp_buy_allow_grenades - 1
mp_weapons_allow_typecount - 5
mp_freezetime - 6
mp_force_pick_time - 15
mp_halftime - 0
mp_match_can_clinch - 1
mp_maxrounds - 0
mp_roundtime - 5
mp_roundtime_defuse - 0
mp_roundtime_hostage - 0
mp_timelimit - 5
mp_warmuptime - 30
mp_warmuptime_all_players_connected - 60
mp_warmup_pausetimer - 0
mp_halftime_pausetimer - 0
mp_default_team_winner_no_objective - -1
mp_hostagepenalty - 10
mp_solid_teammates - 1
sv_allow_votes - 1
sv_alltalk - 0
sv_auto_full_alltalk_during_warmup_half_end - 1
sv_deadtalk - 0
sv_ignoregrenaderadio - 0
mp_teammates_are_enemies - 0
mp_damage_scale_ct_body - 1.0
mp_damage_scale_ct_head - 1.0
mp_damage_scale_t_body - 1.0
mp_damage_scale_t_head - 1.0
mp_friendlyfire - 0
ff_damage_reduction_bullets - 0.1
ff_damage_reduction_grenade - 0.25
ff_damage_reduction_grenade_self - 1
ff_damage_reduction_other - 0.25
mp_limitteams - 2
spec_freeze_panel_extended_time - 0.0
spec_freeze_time - 2.0
mp_forcecamera - 1
mp_respawn_immunitytime - 4.0
mp_respawn_on_death_t - 0
mp_respawn_on_death_ct - 0
mp_display_kill_assists - 1
mp_use_respawn_waves - 0
mp_respawnwavetime_ct - 10.0
mp_respawnwavetime_t - 10.0
mp_randomspawn - 0
mp_randomspawn_los - 1
mp_randomspawn_dist - 0
mp_radar_showall - 0
mp_force_assign_teams - 0
sv_gravity - 800
sv_accelerate - 5.5
sv_stopspeed - 80
sv_airaccelerate - 12
sv_wateraccelerate - 10
sv_waterfriction - 1
sv_friction - 5.2
sv_bounce - 0
sv_maxvelocity - 3500
sv_maxspeed - 320
sv_bot_buy_grenade_chance - 33
sv_bot_buy_smoke_weight - 1
sv_bot_buy_flash_weight - 1
sv_bot_buy_decoy_weight - 1
sv_bot_buy_molotov_weight - 1
sv_bot_buy_hegrenade_weight - 6
sv_guardian_min_wave_for_heavy - 0
sv_guardian_max_wave_for_heavy - 0
sv_guardian_heavy_count - 0
sv_guardian_heavy_all - 0
mp_ggprogressive_round_restart_delay - 15.0
mp_ggtr_bomb_defuse_bonus - 1.0
mp_ggtr_bomb_detonation_bonus - 1.0
mp_ggtr_bomb_pts_for_flash - 4
mp_ggtr_bomb_pts_for_he - 3
mp_ggtr_bomb_pts_for_molotov - 5
mp_ggtr_bomb_pts_for_upgrade - 2.0
mp_ggtr_bomb_respawn_delay - 0.0
mp_ggtr_end_round_kill_bonus - 1
mp_ggtr_halftime_delay - 0.0
mp_ggtr_last_weapon_kill_ends_half - 0
sv_arms_race_vote_to_restart_disallowed_after - 0
mp_coop_force_join_ct - 0
bot_allow_rogues - 1
mp_guardian_special_kills_needed - 10
mp_guardian_special_weapon_needed - awp
mp_guardian_player_dist_min - 1300
mp_guardian_player_dist_max - 2000
mp_guardian_target_site - -1
mp_hostages_spawn_force_positions -
mp_hostages_spawn_same_every_round - 1
mp_guardian_bot_money_per_wave - 800
sv_disable_show_team_select_menu - 0
mp_hostages_max - 2
spec_replay_enable - 0
mp_round_restart_delay - 7.0
mp_coopmission_bot_difficulty_offset - 0
sv_duplicate_playernames_ok - 0
mp_anyone_can_pickup_c4 - 0
mp_c4_cannot_be_defused - 0
mp_c4timer - 40
mp_coopmission_mission_number - 0
weapon_reticle_knife_show - 0
mp_death_drop_c4 - 1
Executing dedicated server config file
Server waking up from hibernation
Stopping 0 worker threads
Starting 1 worker threads
1 threads. 619,899 ticks
exec: couldn't exec gamemode_casual_server.cfg
PrecacheScriptSound 'Player.DamageHelmetOtherFar' failed, no such sound script e                                                                                                             ntry
Commentary: Could not find commentary data file 'maps/de_dust2_commentary.txt'.
Error parsing BotProfile.db - unknown attribute 'Rank'
Error parsing BotProfile.db - unknown attribute 'Rank'
Error parsing BotProfile.db - unknown attribute 'Rank'
Error parsing BotProfile.db - unknown attribute 'Rank'
Error parsing BotProfile.db - unknown attribute 'Rank'
Error parsing BotProfile.db - unknown attribute 'Rank'
Error parsing BotProfile.db - unknown attribute 'Rank'
Error parsing BotProfile.db - unknown attribute 'Rank'
Initializing Steam libraries for secure Internet server
[S_API FAIL] SteamAPI_Init() failed; SteamAPI_IsSteamRunning() failed.
Setting breakpad minidump AppID = 730
dlopen failed trying to load:
/root/.steam/sdk32/steamclient.so
with error:
/root/.steam/sdk32/steamclient.so: cannot open shared object file: No such file                                                                                                              or directory
Looking up breakpad interfaces from steamclient
Calling BreakpadMiniDumpSystemInit
Setting breakpad minidump AppID = 740
Logging into Steam gameserver account with logon token 'C8CB935Cxxxxxxxxxxxxxxxx                                                                                                             xxxxxxxx'
L 02/13/2017 - 13:05:00: [sourcebans.smx] Could not connect to the database. ([2                                                                                                             013]: Lost connection to MySQL server at 'reading initial communication packet',                                                                                                              system error: 111)
Connection to Steam servers successful.
   Public IP is 155.133.43.15.
Assigned persistent gameserver Steam ID [G:1:987578].
VAC secure mode is activated.
GC Connection established for server version 440, instance idx 1
Host state 4 at Mon Feb 13 13:05:08 2017
 -- SIGINT received, live server, delaying request.

 

System operacyjny: Ubuntu 14 64 bitowy.

 

 

Plik databases:

 

"Databases"
{
    "driver_default"        "mysql"
    
    // When specifying "host", you may use an IP address, a hostname, or a socket file path
    
    "default"
    {
        "driver"            "default"
        "host"                "localhost"
        "database"            "sourcemod"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
    
    "sourcebans"
    {
        "driver"            "mysql"
        "host"            "155.133.25.111"
        "database"        "sourcebans"
        "user"            "root"
        "pass"            "Fr1AEN2F1mr2z14hrG"
        //"timeout"        "0"
        "port"            "3306"
    }
    
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
}

 

 

VPS, na którym postawiłem CS GO znajduje się na innym co VPS z forum i sourcebans. 
Proszę o szybką pomoc.

 

 

[xBBBay]

Zaloguj się lub zarejestruj aby zobaczyć zawartość.

[RafalR]

Zaloguj się lub zarejestruj aby zobaczyć zawartość.

[xBBBay]

Zaloguj się lub zarejestruj aby zobaczyć zawartość.

[RafalR]

Zaloguj się lub zarejestruj aby zobaczyć zawartość.

[xBBBay]

Zaloguj się lub zarejestruj aby zobaczyć zawartość.

[Zmoorg]

Zaloguj się lub zarejestruj aby zobaczyć zawartość.

[Zmoorg]

Zaloguj się lub zarejestruj aby zobaczyć zawartość.

[RafalR]

Zaloguj się lub zarejestruj aby zobaczyć zawartość.

[Zmoorg]

Zaloguj się lub zarejestruj aby zobaczyć zawartość.

[owner_2019]

Zaloguj się lub zarejestruj aby zobaczyć zawartość.