MySQL works on own PC, but not on Windows 2012 Server.

MySQL works on own PC, but not on Windows 2012 Server. - 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 works on own PC, but not on Windows 2012 Server. (/showthread.php?tid=547794)

MySQL works on own PC, but not on Windows 2012 Server. - AnthonyTimmers - 25.11.2014

When I try to run the server, it fails to load the MySQL plugin (BlueG's), however when I try it on my PC, it works.

https://github.com/pBlueG/SA-MP-MySQL#faq

I have downloaded the C++ redistributables, and am trying to follow the Build Instruction,

Quote:

Windows

Install Microsoft Visual Studio C++ (2012 or newer, the Express version also works) and the MySQL C Connector (32-bit)
Install the boost libraries (version 1.55 or higher)
Open the solution file with Visual Studio -> right click on the project -> Properties -> VC++ Directories, use Release as configuration and adjust the paths to the previously installed libraries
Build the solution with Release as configuration

I know how Visual Studio works (C# programmer), however what solution file are they talking about? I've downloaded all the files.

Код:

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[12:00:25] filterscripts = ""  (string)
[12:00:25] 
[12:00:25] Server Plugins
[12:00:25] --------------
[12:00:25]  Loading plugin: mysql
[12:00:30]   Failed.
[12:00:30]  Loading plugin: nativechecker
[12:00:30]   Loaded.
[12:00:30]  Loaded 1 plugins.

[12:00:30] 
[12:00:30] Ban list
[12:00:30] --------
[12:00:30]  Loaded: samp.ban
[12:00:30] 
[12:00:30] 
[12:00:30] Filterscripts
[12:00:30] ---------------
[12:00:30]   Loaded 0 filterscripts.

[12:00:30]    Error: Function not registered: 'mysql_connect'
[12:00:30]    Error: Function not registered: 'mysql_format'
[12:00:30]    Error: Function not registered: 'mysql_query'
[12:00:30]    Error: Function not registered: 'cache_get_row_count'
[12:00:30]    Error: Function not registered: 'cache_delete'
[12:00:30]    Error: Function not registered: 'cache_get_field_content_int'
[12:00:30] Script[gamemodes/TimmehRP.amx]: Run time error 19: "File or function is not found"
[12:00:30] Number of vehicle models: 0

Re: MySQL works on own PC, but not on Windows 2012 Server. - AnthonyTimmers - 25.11.2014

When I try to start the server it comes with this error:

Quote:

The procedure entry point _crtCreateSymbolicLinkW could not be located in the dynamic link library
C:\\Windows\SYSTEM32\MSVCP110.dll.

Re: MySQL works on own PC, but not on Windows 2012 Server. - OsteeN - 25.11.2014

Quote:

Originally Posted by AnthonyTimmers

I know how Visual Studio works (C# programmer), however what solution file are they talking about? I've downloaded all the files.

A solution file (.sln) is the file that contains information about your project or alike; which I'm sure you'd know if you actually were a C# programmer & knew how to Visual Studio works as you're implying you are/do.

Re: MySQL works on own PC, but not on Windows 2012 Server. - Vince - 25.11.2014

Still, why are you trying to compile the plugin yourself if there are precompiled binaries? https://github.com/pBlueG/SA-MP-MySQL/releases

Re: MySQL works on own PC, but not on Windows 2012 Server. - AnthonyTimmers - 25.11.2014

Quote:

Originally Posted by OsteeN

Ofcourse I know WHAT a solution file is..
If you'd get your head out of your ass, you could perhaps read correctly before posting such ridiciously stupid posts.

Quote:

what solution file are they talking about?

As in, WHERE is this solution file located? Because there is no solution file included as far as I can see in the zips I downloaded. I already fixed this issue by replacing the dll from my own System32 with the one on my server OS.

Re: MySQL works on own PC, but not on Windows 2012 Server. - AnthonyTimmers - 25.11.2014

Quote:

Originally Posted by Vince

Still, why are you trying to compile the plugin yourself if there are precompiled binaries? https://github.com/pBlueG/SA-MP-MySQL/releases

I was just following the steps other people tried when they had a similar problem (yes, I search and read other topics before I post something), however I found my own solution and indeed recompiling was not necessary.