SA-MP Forums Archive
MySQL plugin doesn't load properly. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL plugin doesn't load properly. (/showthread.php?tid=618512)



MySQL plugin doesn't load properly. - iKevin - 06.10.2016

So recently I've had some issues with the mysql plugin on a linux server. The mysql.so didn't work, so I used mysql_static.so. It didn't work aswell, the server crashed before it started. Then I switched the order of the plugins, and all of them were loaded, but it said "The server has stopped (unknown error)" on the control panel. I've tried mostly everything, and it still doesn't load.

Some screenshots;





If anyone could help me, I would really appreciate it. It's urgent tho.

Thanks in advance.


Re: MySQL plugin doesn't load properly. - SickAttack - 06.10.2016

Contact their support team.


Re: MySQL plugin doesn't load properly. - Mencent - 06.10.2016

Hello!

Can you use the nativechecker plugin to get more Information about this issue?
https://sampforum.blast.hk/showthread.php?tid=249226

Think off that the nativechecker plugin must be at the end of the plugins line in the Server.cfg.


Re: MySQL plugin doesn't load properly. - iKevin - 06.10.2016

Quote:
Originally Posted by SickAttack
Посмотреть сообщение
Contact their support team.


There's literally no support team, and please, just help me out, a comment like your doesn't help at all, bud.

Quote:
Originally Posted by Mencent
Посмотреть сообщение
Hello!

Can you use the nativechecker plugin to get more Information about this issue?
https://sampforum.blast.hk/showthread.php?tid=249226

Think off that the nativechecker plugin must be at the end of the plugins line in the Server.cfg.
Doing it.


Re: MySQL plugin doesn't load properly. - iKevin - 06.10.2016

Literally the same. Nothing happens.

Код:
SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[21:37:02] filterscripts = ""  (string)
[21:37:02] 
[21:37:02] Server Plugins
[21:37:02] --------------
[21:37:02]  Loading plugin: mysql_static.so
[21:37:02]  >> plugin.mysql: R39-3 successfully loaded.
[21:37:02]   Loaded.
[21:37:02]  Loading plugin: streamer.so
[21:37:02] 

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

[21:37:02]   Loaded.
[21:37:02]  Loading plugin: sscanf.so
[21:37:02] 

[21:37:02]  ===============================

[21:37:02]       sscanf plugin loaded.     

[21:37:02]          Version:  2.8.1        

[21:37:02]    © 2012 Alex "******" Cole  

[21:37:02]  ===============================

[21:37:02]   Loaded.
[21:37:02]  Loading plugin: regex.so
[21:37:02] 

[21:37:02] ______________________________________

[21:37:02]  Regular Expression Plugin v0.2.1 loaded
[21:37:02] ______________________________________

[21:37:02]  By: Fro © Copyright  2009-2011
[21:37:02] ______________________________________

[21:37:02]   Loaded.
[21:37:02]  Loading plugin: Whirlpool.so
[21:37:02]  
[21:37:02]  ==================
[21:37:02]  
[21:37:02]   Whirlpool loaded
[21:37:02]  
[21:37:02]  ==================
[21:37:02]  
[21:37:02]   Loaded.
[21:37:02]  Loading plugin: nativechecker.so
[21:37:02]   Loaded.
[21:37:02]  Loaded 6 plugins.

[21:37:02] 
[21:37:02] Ban list
[21:37:02] --------
[21:37:02]  Loaded: samp.ban
[21:37:02] 
[21:37:02] 
[21:37:02] Filterscripts
[21:37:02] ---------------
[21:37:02]   Loaded 0 filterscripts.

[21:37:02]  
[21:37:02]  
[21:37:02]  
[21:37:02]  ======================================= 
[21:37:02]  |                                     | 
[21:37:02]  |        YSI version 3.09.0684        | 
[21:37:02]  |        By Alex "******" Cole        | 
[21:37:02]  |                                     | 
[21:37:02]  ======================================= 
[21:37:02]
Maybe the YSI is the problem? It stops loading when it reaches it. Any ideas?


Re: MySQL plugin doesn't load properly. - Mencent - 06.10.2016

Can you try a blank gamemode (with the same plugins and includes)? Do it work then?


Re: MySQL plugin doesn't load properly. - iKevin - 06.10.2016

Quote:
Originally Posted by Mencent
Посмотреть сообщение
Can you try a blank gamemode? Do it work then?
Yep, it works.


Re: MySQL plugin doesn't load properly. - Logic_ - 06.10.2016

Had the same issue on their services, moved towards Ultra-H and having no issues.


Re: MySQL plugin doesn't load properly. - Mencent - 06.10.2016

Did the gamemode already work at this Server or do you try it for the first time?
On your PC (localhost) it work?


Re: MySQL plugin doesn't load properly. - iKevin - 06.10.2016

It worked. What should I do?


Re: MySQL plugin doesn't load properly. - Logic_ - 06.10.2016

Quote:
Originally Posted by Mencent
Посмотреть сообщение
Did the gamemode already work at this Server or do you try it for the first time?
On your PC (localhost) it work?
Frag.gs has a huge MySQL plugin loading issue - One fix would be to upload mysql.net connector and putting the plugin in the main directory.


Re: MySQL plugin doesn't load properly. - oMa37 - 06.10.2016

Check mysql_log.txt.
I don't think the issue from the MySQL plugin, Since it's getting loaded properly.


Re: MySQL plugin doesn't load properly. - Logic_ - 06.10.2016

^^
https://www.frag.gs/knowledgebase/10...e-mysql-plugin

https://dev.mysql.com/downloads/connector/c/

Quote:
Originally Posted by oMa37
Посмотреть сообщение
Check mysql_log.txt.
I don't think the issue from the MySQL plugin, Since it's getting loaded properly.
It is, I tried MySQL version of my gamemode and it didn't work but when i tried my Y_INI version with the same plugins, it worked.


Re: MySQL plugin doesn't load properly. - iKevin - 06.10.2016

So I should just use the newest MySQL version and compile with it? Easy then, if that's it.


Re: MySQL plugin doesn't load properly. - Mencent - 06.10.2016

Quote:
Originally Posted by KevinExec
Посмотреть сообщение
So I should just use the newest MySQL version and compile with it? Easy then, if that's it.
Think off that the latest mysql Version Need some changes, look here:
(R40 => https://github.com/pBlueG/SA-MP-MySQL/releases)

- EDIT:
First I would check if an upgrade to the latest mysql Version is the only solution. Before you did the changes for nothing at the end.


Re: MySQL plugin doesn't load properly. - SickAttack - 06.10.2016

If they don't give you support, then switch hosts!!!


Re: MySQL plugin doesn't load properly. - ev0lution - 07.10.2016

FRAG servers are memory limited depending on the package, so the free package has the lowest amount of available memory to prevent abuse. The Whirlpool plugin has been known to cause issues, using a disproportionately large amount of memory on startup which causes the server to be shut down. For some reason it happens after the plugin has been loaded. mysql_static looks like it's loading correctly, so I would try removing Whirlpool and see if that resolves your issue.


Re: MySQL plugin doesn't load properly. - Vince - 07.10.2016

Whirlpool is unnecessary now, anyway. There is a SHA256 native which is a perfectly viable alternative that incidentally doesn't require an entire plugin to be loaded. Also I can't help but say: you get what you pay for. If you pay nothing, don't expect anything.