Problema Mysql

TheRake1993 · July 12, 2018

Buna ziua ,azi mi-am luat un GM de la Edison acel Burned si nu merge sa ma loghez..intru pe server pun parola si imi zice ca parola este gresita

Aici este log

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[13:00:27] 
[13:00:27] Server Plugins
[13:00:27] --------------
[13:00:27]  Loading plugin: crashdetect.so
[13:00:27]   CrashDetect v4.15.1 is OK.
[13:00:27]   Loaded.
[13:00:27]  Loading plugin: nativechecker.so
[13:00:27]   Loaded.
[13:00:27]  Loading plugin: sscanf.so
[13:00:27] 

[13:00:27]  ===============================

[13:00:27]       sscanf plugin loaded.     

[13:00:27]          Version:  2.8.1        

[13:00:27]    (c) 2012 Alex "Y_Less" Cole  

[13:00:27]  ===============================

[13:00:27]   Loaded.
[13:00:27]  Loading plugin: mysql.so
[13:00:27]  >> plugin.mysql: R34 successfully loaded.
[13:00:27]   Loaded.
[13:00:27]  Loading plugin: streamer.so
[13:00:27] 

*** Streamer Plugin v2.7.7 by Incognito loaded ***

[13:00:27]   Loaded.
[13:00:27]  Loading plugin: mysql_static.so
[13:00:27]   Failed (plugins/mysql_static.so: cannot open shared object file: No such file or directory)
[13:00:27]  Loaded 5 plugins.

[13:00:27] 
[13:00:27] Filterscripts
[13:00:27] ---------------
[13:00:27]   Loaded 0 filterscripts.

[13:00:28]    Error: Function not registered: 'cache_get_row_count'
[13:00:28]    Error: Function not registered: 'cache_get_field_content'
[13:00:28]    Error: Function not registered: 'cache_get_field_count'
[13:00:28]    Error: Function not registered: 'cache_get_row'
[13:00:28]    Error: Function not registered: 'CreateDynamicRectangle'
[13:00:28]    Error: Function not registered: 'SSCANF_Init'
[13:00:28]    Error: Function not registered: 'SSCANF_IsConnected'
[13:00:28]    Error: Function not registered: 'SSCANF_Join'
[13:00:28]    Error: Function not registered: 'SSCANF_Leave'
[13:00:28]    Error: Function not registered: 'mysql_query'
[13:00:28]    Error: Function not registered: 'CreateDynamicObject'
[13:00:28]    Error: Function not registered: 'SetDynamicObjectMaterial'
[13:00:28]    Error: Function not registered: 'SetDynamicObjectMaterialText'
[13:00:28]    Error: Function not registered: 'CreateDynamic3DTextLabel'
[13:00:28]    Error: Function not registered: 'CreateDynamicMapIcon'
[13:00:28]    Error: Function not registered: 'CreateDynamicPickup'
[13:00:28]    Error: Function not registered: 'mysql_close'
[13:00:28]    Error: Function not registered: 'mysql_log'
[13:00:28]    Error: Function not registered: 'mysql_connect'
[13:00:28]    Error: Function not registered: 'cache_delete'
[13:00:28]    Error: Function not registered: 'DestroyDynamicObject'
[13:00:28]    Error: Function not registered: 'mysql_format'
[13:00:28]    Error: Function not registered: 'mysql_tquery'
[13:00:28]    Error: Function not registered: 'cache_insert_id'
[13:00:28]    Error: Function not registered: 'GetDynamicObjectPos'
[13:00:28]    Error: Function not registered: 'GetDynamicObjectRot'
[13:00:28]    Error: Function not registered: 'AttachDynamicObjectToVehicle'
[13:00:28]    Error: Function not registered: 'MoveDynamicObject'
[13:00:28]    Error: Function not registered: 'DestroyDynamicPickup'
[13:00:28]    Error: Function not registered: 'sscanf'
[13:00:28]    Error: Function not registered: 'EditDynamicObject'
[13:00:28]    Error: Function not registered: 'DestroyDynamic3DTextLabel'
[13:00:28]    Error: Function not registered: 'mysql_escape_string'
[13:00:28]    Error: Function not registered: 'cache_get_field_content_int'
[13:00:28]    Error: Function not registered: 'cache_get_field_content_float'
[13:00:28]    Error: Function not registered: 'mysql_unprocessed_queries'
[13:00:28]    Error: Function not registered: 'UpdateDynamic3DTextLabelText'
[13:00:28]  
[13:00:28]  
[13:00:28]  
[13:00:28]  ======================================= 
[13:00:28]  |                                     | 
[13:00:28]  |        YSI version 3.09.0684        | 
[13:00:28]  |        By Alex "Y_Less" Cole        | 
[13:00:28]  |                                     | 
[13:00:28]  ======================================= 
[13:00:28]  
[13:00:28] Server: hosted
[13:00:28] Server vehicles: 0
[13:00:28] Safezones: 0
[13:00:28] Houses: 0
[13:00:28] Clans: 0
[13:00:28] Clan zones: 0
[13:00:28] Bussines: 0
[13:00:28] Turfs: 0
[13:00:28] Factions: 0
[13:00:28] Jobs: 0
[13:00:28] Furnitures: 0
[13:00:28] Stuff Loaded
[13:00:28] Safes: 0
[13:00:28] Number of vehicle models: 18
[13:00:28] ====================================================================
[13:00:28] Error ID: 2006, Error: MySQL server has gone away
[13:00:28] Callback: LoadDSVeh
[13:00:28] gQuery: SELECT * FROM `dsveh`
[13:00:28] ====================================================================

Iar aici server.cfg

echo Executing Server Config...
lanmode 0
rcon_password movdDtdone
maxplayers 50
bind 89.79.15.129
port 7777
hostname This server is managed with GameCP
gamemode0 wa-rpg
plugins crashdetect.so nativechecker.so sscanf.so mysql.so streamer.so mysql_static.so
announce 0 
query 1
weburl $WEBSITE
maxnpc 0
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000

Iar aici mysql din gm pawn

Quote


public OnGameModeExit() {
    if(SERVER_HOSTSTATUS == 1) {
        mysql_query(SQL, "UPDATE `users` SET `Status` = '0' WHERE `Status` = '1'");
        mysql_close(SQL);
    }
    DestroyActor(SpawnActor);
    return 1;
}

public OnGameModeInit()
{
    mysql_log(LOG_ERROR, LOG_TYPE_TEXT);
    
    if(SERVER_HOSTSTATUS == 1) SQL = mysql_connect("89.59.53.129", "samp1", "samp1", "TEST"), print("Server: hosted"

TheRake1993 · July 12, 2018

Nimeni nimic ?

UP !

Reset · July 12, 2018

Nu ai conectat baza de date la gamemode.

Este tutorial pe youtube, daca nu stii.

HaoSs07 · July 12, 2018

Scrie clar ca nu iti incarca plugin ul MySQL

Failed (plugins/mysql_static.so: cannot open shared object file: No such file or directory)

Nu exista mysql_static.so in folderul plugins.

#edit
Se pare ca sunt chior, ai o versiune MySQL gresita.

Edited July 12, 2018 by HaoSs07

TheRake1993 · July 12, 2018

Si care MySQL ar fi bun pentru el ?

TheRake1993 · July 12, 2018

22 minutes ago, RebornAdv said:

Nu ai conectat baza de date la gamemode.

Este tutorial pe youtube, daca nu stii.

Si baza de date este conectata bine te asigur.

HaoSs07 · July 12, 2018

4 minutes ago, TheRake1993 said:

Si care MySQL ar fi bun pentru el ?

R39-6
https://github.com/pBlueG/SA-MP-MySQL/releases
Iti recomand si un update la streamer la acelasi timp

Edited July 12, 2018 by HaoSs07

LucaAdv · July 13, 2018

Citat

SQL = mysql_connect("infine21", "nuzic", "nuaidecat", "ailuatteapa"), print("Server:hosted");

Unde ruleaza pe host / local ?

Daca e pe host trebuie sa pui asta la mysql_connect

si la #define NORMAL trebuie sa pui un 1 langa el si va arata asa : #define NORMAL 1

Edited July 13, 2018 by LucaAdv
21

HaoSs07 · July 13, 2018

38 minutes ago, LucaAdv said:

Unde ruleaza pe host / local ?

Daca e pe host trebuie sa pui asta la mysql_connect

si la #define NORMAL trebuie sa pui un 1 langa el si va arata asa : #define NORMAL 1

Scripter 2017 ? Citeste ce scrie in server_log

LucaAdv · July 13, 2018

@HaoSs07 Nu am vazut =)

wNekiRo · July 13, 2018

mysql_static din ce stiu nu se mai foloseste pe linux ci pe windows,incearca mysql.so
Incearca versiunea asta.
LINK: https://www28.zippyshare.com/v/Qx5Bjxc6/file.html

HaoSs07 · July 13, 2018

21 minutes ago, Exodus_xD said:

mysql_static din ce stiu nu se mai foloseste pe linux ci pe windows,incearca mysql.so
Incearca versiunea asta.
LINK: https://www28.zippyshare.com/v/Qx5Bjxc6/file.html

13:00:27]  Loading plugin: mysql.so
[13:00:27]  >> plugin.mysql: R34 successfully loaded.
[13:00:27]   Loaded.

Ala e in plus ce are acolo, nici macar nu are asa ceva in folderul plugins, solutia este:
MySQL R39-6: https://github.com/pBlueG/SA-MP-MySQL/releases
Streamer 2.9.3: https://github.com/samp-incognito/samp-streamer-plugin/releases

+

Recompile

=

$olved

Deja am lungit prea mult acest topic cu raspunsuri inutile.

T/C ca solved ?

TheRake1993 · July 13, 2018

Sunt la munca momentan , am sa revin cu un mesaj daca e solved.

Edited July 13, 2018 by TheRake1993

wNekiRo · July 13, 2018

Chiar acum, HaoSs07 a spus:
13:00:27]  Loading plugin: mysql.so
[13:00:27]  >> plugin.mysql: R34 successfully loaded.
[13:00:27]   Loaded.
Ala e in plus ce are acolo, nici macar nu are asa ceva in folderul plugins, solutia este:
MySQL R39-6: https://github.com/pBlueG/SA-MP-MySQL/releases
Streamer 2.9.3: https://github.com/samp-incognito/samp-streamer-plugin/releases

+

Recompile

=

$olved

Deja am lungit prea mult acest topic cu raspunsuri inutile.

T/C ca solved ?

el ruleaza si mysql_static.so scriptere,daca ruleaza si ala rupe conexiunea impreuna cu mysql.so,daca stii ce zic.

TheRake1993 · July 13, 2018

Acuma primesc asta


----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[02:05:09] 
[02:05:09] Server Plugins
[02:05:09] --------------
[02:05:09]  Loading plugin: crashdetect.so
[02:05:09]   CrashDetect v4.15.1 is OK.
[02:05:09]   Loaded.
[02:05:09]  Loading plugin: mysql.so
[02:05:09]   Failed (log-core.so: cannot open shared object file: No such file or directory)
[02:05:09]  Loading plugin: sscanf.so
[02:05:09] 

[02:05:09]  ===============================

[02:05:09]       sscanf plugin loaded.     

[02:05:09]          Version:  2.8.1        

[02:05:09]    (c) 2012 Alex "Y_Less" Cole  

[02:05:09]  ===============================

[02:05:09]   Loaded.
[02:05:09]  Loading plugin: streamer.so
[02:05:09] 

*** Streamer Plugin v2.7.7 by Incognito loaded ***

[02:05:09]   Loaded.
[02:05:09]  Loading plugin: mysql_static.so
[02:05:09]   Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.15' not found (required by plugins/mysql_static.so))
[02:05:09]  Loaded 3 plugins.

[02:05:09] 
[02:05:09] Filterscripts
[02:05:09] ---------------
[02:05:09]   Loaded 0 filterscripts.

[02:05:10] [debug] Run time error 19: "File or function is not found"
[02:05:10] [debug]  cache_get_row_count
[02:05:10] [debug]  cache_get_field_content
[02:05:10] [debug]  cache_get_field_count
[02:05:10] [debug]  cache_get_row
[02:05:10] [debug]  mysql_query
[02:05:10] [debug]  mysql_log
[02:05:10] [debug]  mysql_connect
[02:05:10] [debug]  cache_delete
[02:05:10] [debug]  mysql_format
[02:05:10] [debug]  mysql_tquery
[02:05:10] [debug]  cache_insert_id
[02:05:10] [debug]  mysql_escape_string
[02:05:10] [debug]  cache_get_field_content_int
[02:05:10] [debug]  cache_get_field_content_float
[02:05:10] [debug]  mysql_unprocessed_queries
[02:05:10] [debug] Run time error 19: "File or function is not found"
[02:05:10] [debug]  cache_get_row_count
[02:05:10] [debug]  cache_get_field_content
[02:05:10] [debug]  cache_get_field_count
[02:05:10] [debug]  cache_get_row
[02:05:10] [debug]  mysql_query
[02:05:10] [debug]  mysql_log
[02:05:10] [debug]  mysql_connect
[02:05:10] [debug]  cache_delete
[02:05:10] [debug]  mysql_format
[02:05:10] [debug]  mysql_tquery
[02:05:10] [debug]  cache_insert_id
[02:05:10] [debug]  mysql_escape_string
[02:05:10] [debug]  cache_get_field_content_int
[02:05:10] [debug]  cache_get_field_content_float
[02:05:10] [debug]  mysql_unprocessed_queries
[02:05:10] Script[gamemodes/wa-rpg.amx]: Run time error 19: "File or function is not found"
[02:05:10] Number of vehicle models: 0

HaoSs07 · July 13, 2018

3 hours ago, Exodus_xD said:

el ruleaza si mysql_static.so scriptere,daca ruleaza si ala rupe conexiunea impreuna cu mysql.so,daca stii ce zic.

Google Translate pentru tine scriptere

Failed (plugins/mysql_static.so: cannot open shared object file: No such file or directory)

//
Scoate din server.cfg plugin ul mysql_static.so

Descarca log-core si adauga l in director ul root al serverului

https://github.com/maddinat0r/samp-log-core/releases

Edited July 13, 2018 by HaoSs07

costynw · April 28, 2022

sall cine ma pote ajuta si pe mine

oaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[21:13:03] password = "" (string)
[21:13:03]
[21:13:03] Server Plugins
[21:13:03] --------------
[21:13:03] Loading plugin: crashdetect.so
[21:13:03] CrashDetect v4.15.1 is OK.
[21:13:03] Loaded.
[21:13:03] Loading plugin: __mysql.so
[21:13:03] Failed (plugins/__mysql.so: invalid ELF header)
[21:13:03] Loading plugin: mysql_static.so
[21:13:03] >> plugin.mysql: R39-6 successfully loaded.
[21:13:03] Loaded.
[21:13:03] Loading plugin: mysql.so
[21:13:03] >> plugin.mysql: R38 successfully loaded.
[21:13:03] Loaded.
[21:13:03] Loading plugin: sampvoice.so
[21:13:03] [sv:dbg:network:init] : module initializing...
[21:13:03] [dbg:raknet:init] : module initializing...
[21:13:03] [dbg:raknet:init] : installed hook to 'GetRakServerInterface' function (ptr:0x806ca30)
[21:13:03] [dbg:raknet:init] : installed hook to 'OnPlayerDisconnect' function (ptr:0x80a51d0)
[21:13:03] [dbg:raknet:init] : module initialized
[21:13:03] [sv:dbg:network:init] : module initialized
[21:13:03] -------------------------------------------
[21:13:03] ___ __ __ _
[21:13:03] / __| __ _ _ __ _ _\ \ / /__ (_) __ ___
[21:13:03] \__ \/ _` | ' \| '_ \ / _ \| |/ _/ -_)
[21:13:03] |___/\__,_|_|_|_| .__/\_/\___/|_|\__\___|
[21:13:03] |_|
[21:13:03] -------------------------------------------
[21:13:03] SampVoice by MOR loaded
[21:13:03] -------------------------------------------
[21:13:03] Loaded.
[21:13:03] Loading plugin: fixes2.so
[21:13:03]

[21:13:03] ===============================

[21:13:03] fixes plugin loaded.

[21:13:03] ===============================

[21:13:03] Loaded.
[21:13:03] Loading plugin: streamer.so
[21:13:03]

*** Streamer Plugin v2.9.4 by Incognito loaded ***

[21:13:03] Loaded.
[21:13:03] Loading plugin: Whirlpool.so
[21:13:03]
[21:13:03] ==================
[21:13:03]
[21:13:03] Whirlpool loaded
[21:13:03]
[21:13:03] ==================
[21:13:03]
[21:13:03] Loaded.
[21:13:03] Loading plugin: sscanf.so
[21:13:03]

[21:13:03] ===============================

[21:13:03] sscanf plugin loaded.

[21:13:03] Version: 2.8.3

[21:13:03] ===============================

[21:13:03] Loaded.
[21:13:03] Loading plugin: __mysql_static.soonfoot_rate
[21:13:03] Failed (plugins/__mysql_static.soonfoot_rate: cannot open shared object file: No such file or directory)
[21:13:03] Loading plugin: 40
[21:13:03] Failed (plugins/40: cannot open shared object file: No such file or directory)
[21:13:03] Loaded 8 plugins.

[21:13:03]
[21:13:03] Filterscripts
[21:13:03] ---------------
[21:13:03] Loading filterscript 'ls_beachside.amx'...
[21:13:03] [sv:dbg:main:AmxLoad] : net game pointer (value:0x8b61188) received
[21:13:03] [sv:dbg:network:bind] : voice server running on port 53746
[21:13:03]

[21:13:03] |---------------------------------------------------
[21:13:03] |--- LS BeachSide Filterscript
[21:13:03] |-- Script v1.03
[21:13:03] |-- 19th April 2015
[21:13:03] |---------------------------------------------------
[21:13:03] |-- LS BeachSide Building Elevator created
[21:13:03] |---------------------------------------------------
[21:13:03] Loading filterscript 'fsdebug.amx'...
[21:13:03] [sv:dbg:main:AmxLoad] : failed to bind voice server
[21:13:03]

Waller. · April 29, 2022

Sign In

Problema Mysql

Question

TheRake1993

17 answers to this question

Recommended Posts

TheRake1993

Reset

HaoSs07

TheRake1993

TheRake1993

HaoSs07

LucaAdv

HaoSs07

LucaAdv

wNekiRo

HaoSs07

TheRake1993

wNekiRo

TheRake1993

HaoSs07

costynw

Waller.

Create an account or sign in to comment

Create an account

Sign in

Similar Content

Actualizare textdraw (speedometer) la secunda (problema)

Problema /vehicles

Problema billboards (la expirarea billboard-ului nu seteaza variabila Billboard 0 jucatorului offline)

Problema clan members: Nu afiseaza membrii.

Problema dialog dealership (nu afiseaza ID-ul masinii)

Recently Browsing 0 members

Browse

Activity

Important Information