Jump to content
Concurs pentru galeria sa-mp.ro
  • -1

Problema Mysql

TheRake1993

Asked by TheRake1993,

 Share

Question

TheRake1993 Rookie

TheRake1993

Posted
Posted

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
HaoSs07 Apprentice

HaoSs07

Posted
Posted (edited)

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
LucaAdv Enthusiast

LucaAdv

Posted
Posted (edited)
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
HaoSs07 Apprentice

HaoSs07

Posted
Posted
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
HaoSs07 Apprentice

HaoSs07

Posted
Posted
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
ChickenNigg3r Community Regular

ChickenNigg3r

Posted
Posted
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
TheRake1993 Rookie

TheRake1993

Posted
  • Author
Posted

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
HaoSs07 Apprentice

HaoSs07

Posted
Posted (edited)
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
costynw Apprentice

costynw

Posted
Posted

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.

×
 Share
Go to question listing
×
×
  • 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.

  I accept