PDA

View Full Version : MySQL Question - Thanks!


hewittpro
30/10/2013, 09:14 PM
I'm running with delux-host and I've created a MySQL Database but my server won't start up and I'm almost positive it's because of the MySQL side of things, I'm new to it so I could be forgetting something. I've added my .sql file to the database. At the bottom of my screen it also says "Server running with Suhosin. Please refer to documentation for possible issues." I don't know if thats an issue relating to my problem? Thanks guys!

http://i43.tinypic.com/6z9d7m.png


Thanks guys!!!!

DanishHaq
30/10/2013, 09:17 PM
Contact your host about the this is a Suhosin server or whatever, via a ticket or phone call, this is not a scripting problem. However for the database not connecting, you've probably got a problem in your syntax for the mysql_connect. Show us the Debug.txt.

GWMPT
30/10/2013, 09:20 PM
"...but my server won't start up..."
Since when is it related to PHPMyAdmin?
Did you even taken a look in the log file to see what's causing it?
Did you used crashdetect plugin to know what's causing it?

PHP Suhosin has nothing to do with the MySQL server.

hewittpro
30/10/2013, 09:53 PM
@kikito Okay Well actually it does. If the Mysql plugin doesn't connect with the database then it rejects the connection and unloads the mysql plugin, thats how it works for my gamemode at least.

@DanishHaq Yes I've got a ticket on hold right now with them and the my mysql database works perfectly fine when I'm running it via apache from XXAMP on localhost and I also don't get the Suhousin error. But with the database that was provided with the SAMP Hosting its giving me trouble. This is what I've found in my server_log.txt


Run time error 19: "File or function is not found"
[12:01:12] Number of vehicle models: 0
[16:26:58] BAD RCON ATTEMPT BY: 2.133.117.168
[16:33:38] BAD RCON ATTEMPT BY: 2.133.117.168
[16:39:54] BAD RCON ATTEMPT BY: 2.133.117.168
[16:46:26] BAD RCON ATTEMPT BY: 2.133.117.168
[16:59:40] BAD RCON ATTEMPT BY: 2.133.117.168
[17:06:56] BAD RCON ATTEMPT BY: 2.133.117.168
[17:14:05] BAD RCON ATTEMPT BY: 2.133.117.168
[17:22:46] BAD RCON ATTEMPT BY: 2.133.117.168
[17:30:13] BAD RCON ATTEMPT BY: 2.133.117.168
[17:41:09] BAD RCON ATTEMPT BY: 195.58.251.228
[17:43:21] BAD RCON ATTEMPT BY: 195.58.251.228
[17:45:34] BAD RCON ATTEMPT BY: 195.58.251.228
[17:47:55] BAD RCON ATTEMPT BY: 195.58.251.228
[17:50:18] SAMPBrute 1.03.2 by 2010kohtep
[17:52:42] BAD RCON ATTEMPT BY: 195.58.251.228
[17:54:52] BAD RCON ATTEMPT BY: 2.133.117.168
[18:01:48] BAD RCON ATTEMPT BY: 2.133.117.168
[18:08:50] BAD RCON ATTEMPT BY: 2.133.117.168
[18:16:07] BAD RCON ATTEMPT BY: 2.133.117.168
[18:24:32] BAD RCON ATTEMPT BY: 2.133.117.168
[18:32:56] BAD RCON ATTEMPT BY: 2.133.117.168
[18:41:25] BAD RCON ATTEMPT BY: 2.133.117.168
[18:50:42] BAD RCON ATTEMPT BY: 2.133.117.168
[18:59:38] BAD RCON ATTEMPT BY: 2.133.117.168
[19:07:38] BAD RCON ATTEMPT BY: 2.133.117.168
[19:18:07] BAD RCON ATTEMPT BY: 2.133.117.168
[19:23:35] BAD RCON ATTEMPT BY: 2.133.117.168
[19:31:45] BAD RCON ATTEMPT BY: 2.133.117.168
[19:44:27] BAD RCON ATTEMPT BY: 2.133.117.168
[19:55:10] BAD RCON ATTEMPT BY: 2.133.117.168
[20:00:01] BAD RCON ATTEMPT BY: 2.133.117.168
[20:05:14] BAD RCON ATTEMPT BY: 2.133.117.168
[20:10:45] BAD RCON ATTEMPT BY: 2.133.117.168
[20:16:53] BAD RCON ATTEMPT BY: 2.133.117.168
[20:21:25] BAD RCON ATTEMPT BY: 2.133.117.168
[20:21:38] BAD RCON ATTEMPT BY: 2.133.117.168


----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3x, (C)2005-2013 SA-MP Team

[22:11:11]
[22:11:11] Server Plugins
[22:11:11] --------------
[22:11:11] Loading plugin: mysql
[22:11:11] Failed (plugins/mysql: cannot open shared object file: No such file or directory)
[22:11:11] Loading plugin: streamer.dll
[22:11:11] Failed (plugins/streamer.dll: invalid ELF header)
[22:11:11] Loading plugin: sscanf
[22:11:11] Failed (plugins/sscanf: cannot open shared object file: No such file or directory)
[22:11:11] Loading plugin: audio
[22:11:11] Failed (plugins/audio: cannot open shared object file: No such file or directory)
[22:11:11] Loading plugin: nativechecker
[22:11:11] Failed (plugins/nativechecker: cannot open shared object file: No such file or directory)
[22:11:11] Loaded 0 plugins.

[22:11:11]
[22:11:11] Ban list
[22:11:11] --------
[22:11:11] Loaded: samp.ban
[22:11:11]
[22:11:11]
[22:11:11] Filterscripts
[22:11:11] ---------------
[22:11:11] Loaded 0 filterscripts.

[22:11:12] Script[gamemodes/hgrp10.amx]: Run time error 19: "File or function is not found"
[22:11:12] Number of vehicle models: 0

hewittpro
30/10/2013, 10:09 PM
oh fuck... lmao.. I have the windows MySQL plugin not the linux one :D oops

GWMPT
30/10/2013, 10:36 PM
PHPMyAdmin ISN'T an MySQL server for god sake!
Since when PHPMyAdmin has to do with the MySQL server?
As well, since when PHP Suhosin (http://en.wikipedia.org/wiki/Suhosin) has to do with MySQL at all?

And next time, check the logs before creating a thread!

hewittpro
30/10/2013, 10:42 PM
Okay now I've changed it all to Linux and this is what I'm looking at Any Ideas anyone? Please give me a hand with this? I've been stuck on this for a few days now ! :(


4728 SA-MP Dedicated Server
4729 ----------------------
4730 v0.3x, (C)2005-2013 SA-MP Team
4731
4732 [23:44:23]
4733 [23:44:23] Server Plugins
4734 [23:44:23] --------------
4735 [23:44:23] Loading plugin: mysql.so
4736 [23:44:23] SA:MP MySQL Plugin v2.1.1 Loaded.
4737 [23:44:23] Loaded.
4738 [23:44:23] Loading plugin: streamer.so
4739 [23:44:23]
4740
4741 *** Streamer Plugin v2.6.1 by Incognito loaded ***
4742
4743 [23:44:23] Loaded.
4744 [23:44:23] Loading plugin: sscanf.so
4745 [23:44:23]
4746
4747 [23:44:23] ===============================
4748
4749 [23:44:23] sscanf plugin loaded.
4750
4751 [23:44:23] (c) 2009 Alex "******" Cole
4752
4753 [23:44:23] 0.3d-R2 500 Players "dnee"
4754
4755 [23:44:23] ===============================
4756
4757 [23:44:23] Loaded.
4758 [23:44:23] Loading plugin: audio.so
4759 [23:44:23]
4760
4761 *** Audio Plugin v0.5 R2 by Incognito loaded ***
4762
4763 [23:44:23] Loaded.
4764 [23:44:23] Loading plugin: nativechecker.so
4765 [23:44:23] Loaded.
4766 [23:44:23] Loaded 5 plugins.
4767
4768 [23:44:23] [MySQL] Thread running. Threadsafe: Yes.
4769 [23:44:24]
4770 [23:44:24] Ban list
4771 [23:44:24] --------
4772 [23:44:24] Loaded: samp.ban
4773 [23:44:24]
4774 [23:44:24]
4775 [23:44:24] Filterscripts
4776 [23:44:24] ---------------
4777 [23:44:24] Loaded 0 filterscripts.
4778
4779 [23:44:24] Error: Function not registered: 'mysql_retrieve_row'
4780 [23:44:24] Error: Function not registered: 'mysql_fetch_field_row'
4781 [23:44:24] Script[gamemodes/hgrp10.amx]: Run time error 19: "File or function is not found"
4782 [23:44:24] Number of vehicle models: 0

hewittpro
30/10/2013, 10:46 PM
Kikito I still have a problem! I don't know why you need to give me such a hard time? This section is for asking questions.. is it not? If you are just going to rant on here you don't have to post? Sorry if I irritated you but I was just asking for help..

GWMPT
30/10/2013, 11:01 PM
4779 [23:44:24] Error: Function not registered: 'mysql_retrieve_row'
4780 [23:44:24] Error: Function not registered: 'mysql_fetch_field_row'

Make sure that you're running the latest mysql plugin, as well make sure that you had compiled your gamemode with the latest mysql native.

Djole1337
30/10/2013, 11:57 PM
Server running with Suhosin. Please refer to documentation for possible issues." I don't know if thats an issue relating to my problem? Thanks guys!


No, suhosin PHP patch has nothing to do with your issue.

hewittpro
31/10/2013, 12:41 AM
Thanks Kikito !