Jump to content
  • -1

Problema Mysql


TheRake1993

Question

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"

 

 

Link to comment
Share on other sites

17 answers to this question

Recommended Posts

  • 0

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 by HaoSs07
Link to comment
Share on other sites

  • 0
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 by LucaAdv
21
  • Haha 1
Citat

Cauti un scripter de calitate?
PM sau :
Discord : LucaAdv#9084

Doresc un om cu seriozitate si macar 5 - 10 e psf sa ieie promovare la Server!

Multumesc!

 

Link to comment
Share on other sites

  • 0
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 ;)

Link to comment
Share on other sites

  • 0
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 ?
 

Link to comment
Share on other sites

  • 0
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. -_- 

Link to comment
Share on other sites

  • 0

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

 

Link to comment
Share on other sites

  • 0
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 by HaoSs07
Link to comment
Share on other sites

  • 0

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]    (c) 2012 Alex "Y_Less" Cole

[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]   (c) 2018 Alex "Y_Less" Cole  

[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] 
 

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.