HLstats Нет подключения к базе данных

Тема в разделе "HLstatsX:CE", создана пользователем scriptas, 12 июл 2015.

  1. scriptas

    scriptas

    Сообщения:
    51
    Симпатии:
    0
    HLstatsX все работает.Ho на стороне сервера он не подключиться к базе данных? Что делать?


    Contact with me skype: griffin811
     
  2. ykpon

    ykpon Владыка Read Only

    Сообщения:
    399
    Симпатии:
    104
    Check available remote access on MySQL with game server.
     
  3. scriptas

    scriptas

    Сообщения:
    51
    Симпатии:
    0
    потому что это позволяет подключать при запуске HLstatsX поддерживать в полном объеме, но, когда он подключается запуски уже CSGO сервера он не связан-доступ .Ho HLstatsX соединяет почему? .... но не плагин?
     
  4. ykpon

    ykpon Владыка Read Only

    Сообщения:
    399
    Симпатии:
    104
    Send console log from game server in time run server.
     
  5. scriptas

    scriptas

    Сообщения:
    51
    Симпатии:
    0


    ************** 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.
    WARNING: Could not locate steam dir:, ignoring.
    LD_LIBRARY_PATH=/root/to/csgo-ds/bin:/root/to/csgo-ds:/root/to/csgo-ds/bin:
    #
    #Console initialized.
    Setting breakpad minidump AppID = 740
    #Using breakpad minidump system 740/13493.197.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.
    #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/cooperative).
    Failed to load gamerulescvars.txt, game rules cvars might not be reported to management 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 Steam, or a local steamclient.so.
    No web api auth key specified - workshop downloads will be disabled.
    maxplayers set to 64
    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_allclassic'
    Unknown command "port"
    ApplyGameSettings: Invalid mapgroup name mg_allclassic
    ---- Host_NewGame ----
    Host_NewGame on map de_dust2
    GameTypes: missing mapgroupsSP entry for game type/mode (custom/custom).
    GameTypes: missing mapgroupsSP entry for game type/mode (cooperative/cooperative).
    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_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_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_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 - 5.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_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
    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_guardian_special_kills_needed - 10
    mp_guardian_special_weapon_needed - awp
    mp_guardian_player_dist_min - 1300
    mp_guardian_player_dist_max - 2000
    mp_randomspawn_in_bombsite - -1
    bot_custom_strat -
    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
    Executing dedicated server config file
    Writing cfg/banned_user.cfg.
    Writing cfg/banned_ip.cfg.
    Server logging enabled.
    Server logging data to file logs/L091_211_245_252_27017_201507120926_000.log
    L 07/12/2015 - 09:26:42: Log file started (file "logs/L091_211_245_252_27017_201507120926_000.log") (game "/root/to/csgo-ds/csgo") (version "6079")
    L 07/12/2015 - 09:26:42: server_cvar: "cash_player_bomb_defused" "200"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_player_bomb_planted" "200"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_player_interact_with_hostage" "300"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_player_killed_enemy_default" "200"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_player_killed_enemy_factor" "0.5"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_team_elimination_bomb_map" "2700"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_team_elimination_hostage_map_t" "2000"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_team_elimination_hostage_map_ct" "2300"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_team_loser_bonus" "2400"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_team_loser_bonus_consecutive_rounds" "0"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_team_planted_bomb_but_defused" "200"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_team_terrorist_win_bomb" "2700"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_team_win_by_defusing_bomb" "2700"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_team_win_by_hostage_rescue" "3000"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_team_win_by_time_running_out_hostage" "2000"
    L 07/12/2015 - 09:26:42: server_cvar: "cash_team_win_by_time_running_out_bomb" "2700"
    L 07/12/2015 - 09:26:42: server_cvar: "mp_freezetime" "3"
    L 07/12/2015 - 09:26:42: server_cvar: "mp_friendlyfire" "1"
    L 07/12/2015 - 09:26:42: server_cvar: "mp_maxrounds" "15"
    L 07/12/2015 - 09:26:42: server_cvar: "mp_roundtime" "2"
    L 07/12/2015 - 09:26:42: server_cvar: "mp_roundtime_hostage" "2"
    L 07/12/2015 - 09:26:42: server_cvar: "mp_roundtime_defuse" "2.25"
    L 07/12/2015 - 09:26:42: server_cvar: "mp_timelimit" "0"
    Stopping 0 worker threads
    Starting 1 worker threads
    1 threads. 609,616 ticks
    exec: couldn't exec gamemode_casual_server.cfg
    PrecacheScriptSound 'carpet.stepleft' failed, no such sound script entry
    PrecacheScriptSound 'carpet.stepright' failed, no such sound script entry
    PrecacheScriptSound 'atv_impact_medium' failed, no such sound script entry
    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 anonymous gameserver account.
    Connection to Steam servers successful.
    Public IP is 91.211.245.252.
    Assigned anonymous gameserver Steam ID [A:1:3271076873(5675)].
    VAC secure mode is activated.
    GC Connection established for server version 197, instance idx 1
     
  6. ykpon

    ykpon Владыка Read Only

    Сообщения:
    399
    Симпатии:
    104
    Why did you decide that the server can not connect?
    Send database.cfg too, only remove passwd's from contents.
     
  7. scriptas

    scriptas

    Сообщения:
    51
    Симпатии:
    0
    Bc i see it on server and HlstatsX web


    this is my database.cfg

    "Databases"
    {
    "driver_default" "mysql"

    // When specifying "host", you may use an IP address, a hostname, or a socket file path

    "default"
    {
    "driver" "default"
    "host" "frageris.lt"
    "database" "frageris_stats"
    "user" "frageris_stats"
    "pass" ""
    //"timeout" "0"
    //"port" "0"

    }

    "storage-local"
    {
    "driver" "sqlite"
    "database" "sourcemod-local"
    }

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

    and this is my HLstatsX config.cfg and he work fine.

    define("DB_ADDR", "frageris.lt");

    // DB_USER - The username to connect to the database as
    define("DB_USER", "frageris_stats");

    // DB_PASS - The password for DB_USER
    define("DB_PASS", "");

    // DB_NAME - The name of the database
    define("DB_NAME", "frageris_stats");

    // DB_TYPE - The database server type. Only "mysql" is supported currently
    define("DB_TYPE", "mysql");

    and this is my HLstatsX scripts folder cfg when connect to db to fine.

    # DBHost - Database server "address" or "address:port". Address can be an IP or
    # a hostname. The default MySQL port is 3306 (tcp).
    DBHost "frageris.lt"

    # DBUsername - User to connect to the database as.
    DBUsername "frageris_stats"

    # DBPassword - Password for the database user.
    DBPassword ""

    # DBName - Name of the database to use.
    DBName "frageris_stats"
     
  8. ykpon

    ykpon Владыка Read Only

    Сообщения:
    399
    Симпатии:
    104
    i blunted..
    u add in server.cfg:
    logaddress_add ip:port
    ip:port - address server statistic.

    Server can not connect to the database.
    Him don't need to connect to it.
    Connected to database only from site.

    Error connection shown on site or where?
     
  9. scriptas

    scriptas

    Сообщения:
    51
    Симпатии:
    0
    on server side..

    maybe can u give me your skype?
     
  10. ykpon

    ykpon Владыка Read Only

    Сообщения:
    399
    Симпатии:
    104
    i dont have skype.
    On server side need only add line in server.cfg:
    logaddress_add ip:port
    More server no contact on site statistic.
    Maybe u see some error? Send screenshot?
    btw, if u use local mysql database, change "frageris.lt" to "localhost" or "127.0.0.1".
     
  11. scriptas

    scriptas

    Сообщения:
    51
    Симпатии:
    0
    I add this

    logaddress_add 91.211.245.252:27016
     
  12. ykpon

    ykpon Владыка Read Only

    Сообщения:
    399
    Симпатии:
    104
    That address game server.
    You need put address server statistic.
     
  13. scriptas

    scriptas

    Сообщения:
    51
    Симпатии:
    0
    not help change to localhost
    and try this 127.0.0.1

    Добавлено через 6 минут
    "localhost" or "127.0.0.1". this dont work

    Добавлено через 7 минут
    what u mean? Address server statistic???
     
    Последнее редактирование: 12 июл 2015
  14. ykpon

    ykpon Владыка Read Only

    Сообщения:
    399
    Симпатии:
    104
    http://cstrike.nyfiber.net/node/5
    Step 8 see.
     
    scriptas нравится это.
  15. scriptas

    scriptas

    Сообщения:
    51
    Симпатии:
    0
  16. ykpon

    ykpon Владыка Read Only

    Сообщения:
    399
    Симпатии:
    104
  17. scriptas

    scriptas

    Сообщения:
    51
    Симпатии:
    0
    Can't setup UDP socket on frageris.lt:27500: Cannot assign requested address
    [email protected]:/var/www/html/web/scripts# ./hlstats.pl
    2015-07-12 16:42:58: - MYSQL: Connecting to MySQL database 'frageris_stats' on 'frageris.lt' as user 'frageris_stats' ... connected ok
    2015-07-12 16:42:58: - CONFIG: Reading database config...
    2015-07-12 16:42:58: - CONFIG: I have found the following server configs in database:
    2015-07-12 16:42:58: - S_CONFIG: 91.211.245.252:27016
    2015-07-12 16:42:58: - ERROR: GeoIP method set to binary file lookup but .//GeoLiteCity/GeoLiteCity.dat NOT FOUND
    2015-07-12 16:42:58: - HLSTATSX: HLstatsX:CE 1.6.19 starting...

    Can't setup UDP socket on frageris.lt:2222: Cannot assign requested address
    [email protected]:/var/www/html/web/scripts# ./hlstats.pl
    2015-07-12 16:43:43: - MYSQL: Connecting to MySQL database 'frageris_stats' on 'frageris.lt' as user 'frageris_stats' ... connected ok
    2015-07-12 16:43:43: - CONFIG: Reading database config...
    2015-07-12 16:43:43: - CONFIG: I have found the following server configs in database:
    2015-07-12 16:43:43: - S_CONFIG: 91.211.245.252:27016
    2015-07-12 16:43:43: - ERROR: GeoIP method set to binary file lookup but .//GeoLiteCity/GeoLiteCity.dat NOT FOUND
    2015-07-12 16:43:43: - HLSTATSX: HLstatsX:CE 1.6.19 starting...
    2015-07-12 16:43:43: - UDP: Opening UDP listen socket on 91.211.245.252:27500 ... ok
    2015-07-12 16:43:43: - HLSTATSX: Tracking Trend of the stats are enabled
    2015-07-12 16:43:43: - HLSTATSX: Maximum Skill Change on all servers are 10 points
    2015-07-12 16:43:43: - HLSTATSX: Minimum Skill Change on all servers are 2 points
    2015-07-12 16:43:43: - HLSTATSX: Minimum Players Kills on all servers are 50 kills
    2015-07-12 16:43:43: - HLSTATSX: Players chat logging is enabled
    2015-07-12 16:43:43: - HLSTATSX: Broadcasting public chat is disabled
    2015-07-12 16:43:43: - HLSTATSX: Event queue size is set to 10
    2015-07-12 16:43:43: - HLSTATSX: HLstatsX:CE is now running (Normal mode, debug level 1)
     
  18. ykpon

    ykpon Владыка Read Only

    Сообщения:
    399
    Симпатии:
    104
    91.211.245.252:27500 - that your server statistic. :)
     
  19. scriptas

    scriptas

    Сообщения:
    51
    Симпатии:
    0
    finaly work ty for help ;)

    in all shit need do this :D 91.211.245.252:27500

    Добавлено через 48 секунд
    in server cfg add to this and work 91.211.245.252:27500
     
    Последнее редактирование: 12 июл 2015
  20. ykpon

    ykpon Владыка Read Only

    Сообщения:
    399
    Симпатии:
    104
    Old record logaddress_add remove and replace this logaddress_add 91.211.245.252:27500