Some MySQL errors - Printable Version

Some MySQL errors - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Some MySQL errors (/showthread.php?tid=579217)

Some MySQL errors - Stanford - 25.06.2015

Hello there, I believe that the machine got the latest MySQL version, we attempted to run the server and these errors showed up:

pawn Код:

[15:10:46] Script[gamemodes/RP.amx]: Run time error 19: "File or function is no$
[15:10:46] Number of vehicle models: 0
[15:10:45]   Loaded.
[15:10:45]  Loading plugin: mysql.so
[15:10:45]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No$
[15:10:45]   Loaded.
[15:10:45]  Loading plugin: mysql.so
[15:10:45]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
[15:10:45]  Loading plugin: whirlpool.so
[15:10:45]
[15:10:45]  ==================
[15:10:45]
[15:10:45]   Whirlpool loaded
[15:10:45]
[15:10:45]  ==================
[15:10:45]
[15:10:45]   Loaded.
[15:10:45]  Loaded 3 plugins.

[15:10:45]
[15:10:45] Filterscripts
[15:10:45] ---------------
[15:10:45]   Loaded 0 filterscripts.

[15:10:46] Script[gamemodes/RP.amx]: Run time error 19: "File or function is not found"
[15:10:46] Number of vehicle models: 0

MySQL:
[15:10:45]  Loading plugin: mysql.so
[15:10:45]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
[15:10:46] Script[gamemodes/RP.amx]: Run time error 19: "File or function is not found"

We would appreciate if someone posts a solution for this
this has nothing to do with other plugins I think its only MySQL issue and do not tell me to update MySQL or whatever as the gamemode itself works in my own pc (compiled and everything)

Operating System: "CentOS release 6.6 (final)"

Re: Some MySQL errors - Michael B - 25.06.2015

Did you add mysql.so to your plugins folder? As far as I can see, the file is missing.
Try to run nativechecker plugin with your server.

Re: Some MySQL errors - stueycow - 25.06.2015

Basicly, Your missing the 'MySQL.so' plugin. This should be located in your plugin folder. If it isn't you may have the MySQL.dll plugin instead which is for Windows.

To fix the issue download the MySQL.so plugin, add to your plugins folder and run. Any further problems post here.

Re: Some MySQL errors - Stanford - 25.06.2015

I have mysql.so included in the server.cfg and the file exists in plugins folder.. any other help?

Re: Some MySQL errors - Stanford - 25.06.2015

This is weird, I added nativechecker.so and came up with this:

pawn Код:

[14:47:42]    Error: Function not registered: 'SSCANF_Init'
[14:47:42]    Error: Function not registered: 'SSCANF_Join'
[14:47:42]    Error: Function not registered: 'SSCANF_Leave'
[14:47:42]    Error: Function not registered: 'sscanf'
[14:47:42]    Error: Function not registered: 'mysql_connect'
[14:47:42]    Error: Function not registered: 'mysql_errno'
[14:47:42]    Error: Function not registered: 'mysql_tquery'
[14:47:42]    Error: Function not registered: 'mysql_format'
[14:47:42]    Error: Function not registered: 'IsValidDynamic3DTextLabel'
[14:47:42]    Error: Function not registered: 'DestroyDynamic3DTextLabel'
[14:47:42]    Error: Function not registered: 'CreateDynamic3DTextLabel'
[14:47:42]    Error: Function not registered: 'CreateDynamicPickup'
[14:47:42]    Error: Function not registered: 'DestroyDynamicPickup'
[14:47:42]    Error: Function not registered: 'cache_insert_id'
[14:47:42]    Error: Function not registered: 'CreateDynamicObject'
[14:47:42]    Error: Function not registered: 'GetDynamicObjectPos'
[14:47:42]    Error: Function not registered: 'GetDynamicObjectRot'
[14:47:42]    Error: Function not registered: 'EditDynamicObject'
[14:47:42]    Error: Function not registered: 'DestroyDynamicObject'
[14:47:42]    Error: Function not registered: 'UpdateDynamic3DTextLabelText'
[14:47:42]    Error: Function not registered: 'CreateDynamicObjectEx'
[14:47:42]    Error: Function not registered: 'SetDynamicObjectMaterial'
[14:47:42]    Error: Function not registered: 'SetDynamicObjectMaterialText'
[14:47:42]    Error: Function not registered: 'CreateDynamicSphere'
[14:47:42]    Error: Function not registered: 'IsValidDynamicObject'
[14:47:42]    Error: Function not registered: 'SetDynamicObjectPos'
[14:47:42]    Error: Function not registered: 'SetDynamicObjectRot'
[14:47:42]    Error: Function not registered: 'DestroyDynamicArea'
[14:47:42]    Error: Function not registered: 'mysql_close'
[14:47:42]    Error: Function not registered: 'WP_Hash'
[14:47:42]    Error: Function not registered: 'IsValidDynamicPickup'
[14:47:42]    Error: Function not registered: 'MoveDynamicObject'
[14:47:42]    Error: Function not registered: 'cache_get_data'
[14:47:42]    Error: Function not registered: 'cache_get_field_content'
[14:47:42]    Error: Function not registered: 'CreateDynamicMapIcon'
[14:47:42]    Error: Function not registered: 'DestroyAllDynamicObjects'
[14:47:42]    Error: Function not registered: 'DestroyAllDynamic3DTextLabels'
[14:47:42]    Error: Function not registered: 'DestroyAllDynamicCPs'
[14:47:42]    Error: Function not registered: 'DestroyAllDynamicMapIcons'
[14:47:42]    Error: Function not registered: 'DestroyAllDynamicRaceCPs'
[14:47:42]    Error: Function not registered: 'DestroyAllDynamicAreas'
[14:47:42]    Error: Function not registered: 'mysql_stat'
[14:47:42]    Error: Function not registered: 'DestroyDynamicMapIcon'
[14:47:42]    Error: Function not registered: 'cache_affected_rows'
[14:47:42]    Error: Function not registered: 'AttachDynamicObjectToVehicle'
[14:47:42] Script[gamemodes/RP.amx]: Run time error 19: "File or function is not found"
[14:47:42] Number of vehicle models: 0

all of these files already in the directory!

Re: Some MySQL errors - Stanford - 25.06.2015

Do not tell me about re-compiling or updating, I have already done these!

Re: Some MySQL errors - muzammilfreeman - 25.06.2015

Okay, if you got shared hosting. Than make a ticket and ask them to update MySQl library of their VPS, at which your server is hosted. If you got VPS just update MySQL library. Or use MySQL_Static plugin.. it might work without those errors...

P.S: The Native checker showed you those error cuz' you are unable to connect to MySQl, cuz' of above errors...

Код:

 
cd /usr/lib ; wget http://mow.vg/files/libmysqlclient.so.16 ; cp libmysqlclient.so.16 hlibmysqlclient_.so.16

Try this too..!

Re: Some MySQL errors - kyriakos587 - 25.06.2015

Which version of mysql do you run ??

Re: Some MySQL errors - Stanford - 25.06.2015

Alright the issue is fixed when we used MySQL static, however, does using static version gives disadvantages? any ideas about this? whats the difference between both versions? another question is if we want to update for example to R39 - 3 there aint any static file there, does this mean that we have to stick to R39 or is it ok if we just replaced the files uploaded in github only?.

Thanks this means a lot to us!

Re: Some MySQL errors - Jake187 - 28.06.2015

R39-3 does have a static version it's not just in the mysql-r39-3-debian7.tgz file, it would work fine with any linux OS normally.

But anyways the error is happening because you are missing the required 32bit libs because your using a 64bit mySQL. The R39-3 CentOS7 version is for 64bit system as CentOS dropped 32bit support, but it won't work for CentOS6.

The best solution for you in this case is download and install mySQL on your system using mySQL's official repo located at https://dev.mysql.com/downloads/repo/yum/ once you install mySQL with that repo you can yum install mysql-community-libs-compat which will have the 32bit libs you require.

another solution is installing CentOS7 instead and using the R39-3 CentOS7 version. Far as the difference between static and non-static there is no difference as I am aware.